注册 登录
编程论坛 ASP.NET技术论坛

有无其他方法赋值

闻启学 发布于 2010-01-25 11:21, 851 次点击
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;

        }

有无其他方法赋值!
这样很麻烦!
8 回复
#2
saitor2010-01-25 14:01
用linq to sql
#3
闻启学2010-01-25 20:05
我不会,怎样搞!
#4
yms1232010-01-26 13:10
还有一种方法叫反射。
相关概念的解释
http://blog.
比较简单的反射代码实例
http://blog.
另一篇应用代码
http://hi.baidu.com/fcxcf4/blog/item/5c9e75d8523a303f33fa1cc0.html

#5
saitor2010-01-27 11:13
先建个LINQ TO SQL的类,把你用到的表拖进去。
在调用里实例化这个类。
你这里可以这么调
public static Hl_ptype GetHl_ptypeByTypeId(string typeId)
        {
DataClasses1DataContext date = new DataClasses1DataContext();
表名 ptype=.GetTable<表名>().FirstOrDefault(n=>n.TypeId==typeId);
return ptype;
}
连实体类都不用建
#6
闻启学2010-01-28 11:41
先建个LINQ TO SQL的类,把你用到的表拖进去。
怎样建,Linq我不懂!!
#7
saitor2010-01-30 21:49
VS2008新建数据库里面有LINQ TO SQL类
#8
闻启学2010-01-30 23:15
我是VS2005的!!
#9
saitor2010-01-30 23:21
呃,我没办法了,用CODESMITH。自动生成实体类吧。
1