/// <summary> /// 得到今日工作日志 /// </summary> /// <param name="UserID"></param> /// <returns></returns> public Dictionary <String, object> GetTodayWorkLog(String UserID) { List <SearchField> condition = new List <SearchField>(); condition.Add(new SearchField("AddUserID", UserID)); condition.Add(new SearchField("begDate=cdate('" + DateTime.Today.ToString("yyyy-MM-dd") + "')", "", SearchOperator.UserDefine)); Tb_WorkLogDA da1 = new Tb_WorkLogDA(); da1.TableName = "Tb_WorkLog"; Dictionary <String, object> dic1 = da1.GetFirstDictionary(condition, "*"); return(dic1); }
/// <summary> /// 通过LogID,得到日志的数据 /// </summary> /// <param name="LogID">日志ID</param> /// <returns></returns> public Dictionary <String, object> GetWorkLogByLogID(String LogID) { Dictionary <String, object> dic1 = null; if (String.IsNullOrEmpty(LogID) == false) { List <SearchField> condition = new List <SearchField>(); condition.Add(new SearchField("LogID", LogID)); Tb_WorkLogDA da1 = new Tb_WorkLogDA(); da1.TableName = "Tb_WorkLog"; dic1 = da1.GetFirstDictionary(condition, "*"); } return(dic1); }
/// <summary> /// 得到满足条件的第一行数据(返回值为Dictionary) /// </summary> /// <param name="condition">查询条件</param> /// <param name="Fields">数据字段</param> /// <returns>Dictionary字典</returns> public Dictionary <string, object> GetFirstDictionary(List <SearchField> condition, params String[] Fields) { Dictionary <string, object> data1 = null; try { Tb_WorkLogDA da1 = new Tb_WorkLogDA(); data1 = da1.GetFirstDictionary(condition, Fields); this.executeResultCount = da1.ExecuteResultCount; } catch (Exception err) { this.ErrorInfo = err.Message.Replace("\r", "").Replace("\t", "").Replace("\n", ""); } return(data1); }