DataRow dr = dt.NewRow();

    DataTable dt = new DataTable(“t1”); 
    DataRow dr = dt.NewRow(); dt.Rows.Add(dr);

///  
/// 构造用户信息细节表 
///  
///  
public static DataTable getAllDetail() {     

    DataTable dt = new DataTable();     
    dt.Columns.Add(“UID”, typeof(System.Int32));//用户编号 
    dt.Columns.Add(“UserName”, typeof(System.String));//用户姓名
    dt.Columns.Add(“FileOver”, typeof(System.Int32));//处理完的数量         
    dt.Columns.Add(“FileUnDeal”, typeof(System.Int32));//未处理的数量
    dt.Columns.Add(“FileDealing”, typeof(System.Int32));//正在处理的数量 

    DataTable dtUsr = UserBLL.getAll();//用户列表 

    for (int i = 0; i < dtUsr.Rows.Count; i++)//这里处理 
    { 
        DataRow dr = dt.NewRow();         
        string UID = dtUsr.Rows[i][“UID”].ToString();         
        dr[“UID”] = Convert.ToInt32(UID);         
        dr[“UserName”] = dtUsr.Rows[i][“UserName”].ToString(); ;         
        dr[“FileOver”] = RegFilesBLL.getTotalByUidProcess(UID, 10, 10);         
        dr[“FileUnDeal”] = RegFilesBLL.getTotalByUidProcess(UID, 0, 0);         
        dr[“FileDealing”] = RegFilesBLL.getTotalByUidProcess(UID, 1, 9);                 
        dt.Rows.Add(dr);     
    }     
    return dt; 
}
        

 

foreach (DictionaryEntry ht in lstHt)
{
        DataRow dr = dt.NewRow();
         dr[ht.Key] = ht.Value;
         dt.Rows.Add(dr);
}
posted @ 2017-09-22 11:22  晒晒  阅读(2638)  评论(0)    收藏  举报