/// <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);
}
