/// <summary> /// 根据条件得到列表数据 /// </summary> /// <param name="condition">查询条件</param> /// <param name="PageSize">页大小</param> /// <param name="CurPage">当前页</param> /// <param name="Fields">数据字段</param> /// <param name="orderBy">排序表达式</param> /// <param name="TotalRow">数据总行数</param> /// <param name="Fields">要显示的字段</param> /// <returns>列表数据</returns> public DataTable GetListData(List <SearchField> condition, int PageSize, int CurPage, String orderBy, out int TotalRow, params String[] Fields) { TotalRow = 0; DataTable dt1 = null; try { Tb_WorkLogDA da1 = new Tb_WorkLogDA(); dt1 = da1.GetListData(condition, PageSize, CurPage, orderBy, out TotalRow, Fields); this.executeResultCount = da1.ExecuteResultCount; return(dt1); } catch (Exception err) { this.ErrorInfo = err.Message.Replace("\r", "").Replace("\t", "").Replace("\n", ""); } return(dt1); }
/// <summary> /// 得到用户的最近工作日志 /// </summary> /// <param name="UserID"></param> /// <returns></returns> public Dictionary <String, object> GetLastWorkLog(String UserID) { Dictionary <String, object> dic1 = null; List <SearchField> condition = new List <SearchField>(); condition.Add(new SearchField("AddUserID", UserID)); Tb_WorkLogDA da1 = new Tb_WorkLogDA(); da1.TableName = "Tb_WorkLog"; DataTable dt1 = da1.GetListData(condition, -1, -1, "begDate desc", "*"); if (dt1.Rows.Count > 0) { DataRow dr1 = dt1.Rows[0]; dic1 = new Dictionary <string, object>(StringComparer.CurrentCultureIgnoreCase); foreach (DataColumn col in dt1.Columns) { dic1[col.ColumnName] = dr1[col.ColumnName]; } } return(dic1); }