public static Hl_ptype GetHl_ptypeByTypeId(string typeId)
        {
            Hl_ptype ptype = null;
            SqlDataReader ptypeRead = Hl_ptypeService.GetProductListByTypeID(typeId);
            if (ptypeRead.Read())
            {
                ptype = new Hl_ptype();
                ptype.TypeId = ptypeRead["typeId"].ToString();
                ptype.ParId = ptypeRead["ParId"].ToString();
                ptype.小类ID1 = ptypeRead["小类ID"].ToString();
                ptype.大类ID1 = ptypeRead["大类ID"].ToString();
                ptype.FullName = ptypeRead["FullName"].ToString();
                ptype.Name = ptypeRead["Name"].ToString();
                ptype.Efullname = ptypeRead["Efullname"].ToString();
                ptype.Ename = ptypeRead["Ename"].ToString();
                ptype.BarCode = ptypeRead["BarCode"].ToString();
                ptype.Standard = Convert.ToDouble(ptypeRead["standard"].ToString());
                ptype.Unit1 = ptypeRead["Unit1"].ToString();
                ptype.Unit2 = ptypeRead["Unit2"].ToString();
                = ptypeRead["Comment"].ToString();
                ptype.KCQX = Convert.ToDouble(ptypeRead["KCQX"].ToString());
                ptype.Warndown = Convert.ToDouble(ptypeRead["warndown"].ToString());
                ptype.Warnup = Convert.ToDouble(ptypeRead["warnup"].ToString());
                ptype.ParamA = Convert.ToDouble(ptypeRead["ParamA"].ToString());
                ptype.ParamB = Convert.ToDouble(ptypeRead["ParamB"].ToString());
                ptype.ParamC = Convert.ToDouble(ptypeRead["ParamC"].ToString());
                ptype.ParamD = Convert.ToDouble(ptypeRead["ParamD"].ToString());
                ptype.Dlyorder = Convert.ToInt32(ptypeRead["dlyorder"].ToString());
                ptype.Deleted = Convert.ToInt32(ptypeRead["deleted"].ToString());
                ptype.Hit = Convert.ToInt32(checkIn.isCheckInNull(ptypeRead["Hit"].ToString()));
                string material = ptypeRead["color"].ToString();
                string color = ptypeRead["color"].ToString();
                WinnerDBHelper.CloseConn();
                ptype.Material = isStringNull(material);
                ptype.Color = isStringNull(color);
            }
            return ptype;

        }

有无其他方法赋值！
这样很麻烦！

用linq to sql

我不会，怎样搞！

还有一种方法叫反射。
相关概念的解释
http://blog.
比较简单的反射代码实例
http://blog.
另一篇应用代码
http://hi.baidu.com/fcxcf4/blog/item/5c9e75d8523a303f33fa1cc0.html

先建个LINQ TO SQL的类，把你用到的表拖进去。
在调用里实例化这个类。
你这里可以这么调
public static Hl_ptype GetHl_ptypeByTypeId(string typeId)
        {
DataClasses1DataContext date = new DataClasses1DataContext();
表名 ptype=.GetTable<表名>().FirstOrDefault(n=>n.TypeId==typeId);
return ptype;
}
连实体类都不用建

先建个LINQ TO SQL的类，把你用到的表拖进去。
怎样建，Linq我不懂！！

VS2008新建数据库里面有LINQ TO SQL类

我是VS2005的!!

呃，我没办法了，用CODESMITH。自动生成实体类吧。