Esempio n. 1
0
    protected void Page_Load(object sender, EventArgs e)
    {
        dt = objConn.GetDataTable("select 显示名字,分类编码 from 材料分类表 where 是否启用=1 and len(分类编码)=2 and 分类编码 in (08,07,02,04,05,01,06) order by 分类编码 desc");

        dt1 = objConn.GetDataTable("select distinct  显示名字,分类编码 from 材料分类表 where 是否启用=1 and len(分类编码)=4 ");

        dt2 = objConn.GetDataTable("select 显示名字,分类编码 from 材料分类表 where 是否启用=1 and len(分类编码)=2 and 分类编码 not in(08,07,02,04,05,01,06 )");

        ////数据表DataTable转集合
        this.Items1 = new List <FLObject>();
        this.Items2 = new List <FLObject>();
        this.Items3 = new List <FLObject>();

        for (int x = 0; x < dt.Rows.Count; x++)
        {
            DataRow dr2 = dt.Rows[x];

            if (Convert.ToString(dr2["分类编码"]).Length == 2)
            {
                FLObject item = new FLObject();
                item.Name = Convert.ToString(dr2["显示名字"]);
                item.Sid  = Convert.ToString(dr2["分类编码"]);
                this.Items1.Add(item);
            }
        }
        for (int x = 0; x < dt2.Rows.Count; x++)
        {
            DataRow dr = dt2.Rows[x];

            if (Convert.ToString(dr["分类编码"]).Length == 2)
            {
                FLObject item = new FLObject();
                item.Name = Convert.ToString(dr["显示名字"]);
                item.Sid  = Convert.ToString(dr["分类编码"]);
                this.Items3.Add(item);
            }
        }
        for (int x = 0; x < dt1.Rows.Count; x++)
        {
            DataRow dr2 = dt1.Rows[x];
            if (Convert.ToString(dr2["分类编码"]).Length == 4)
            {
                FLObject item = new FLObject();
                item.Name = Convert.ToString(dr2["显示名字"]);
                item.Sid  = Convert.ToString(dr2["分类编码"]);
                this.Items2.Add(item);
            }
        }
    }
Esempio n. 2
0
 public static FLObject ToTemp(this FLObject fLObject, out FLObject temp)
 {
     temp = fLObject;
     return(fLObject);
 }