/// <summary>
/// 提交今日工作日志
/// </summary>
/// <param name="list1"></param>
/// <returns></returns>
public bool UpdateTodayLog(List <KORWeb.DDL.Tb_WorkLogDD> list1)
{
bool succ = false;
JConnect.GetConnect().BeginTrans();
try
{
List <SearchField> condition = new List <SearchField>();
Tb_WorkLogDA da1 = new Tb_WorkLogDA();
Dictionary <String, object> dic1 = new Dictionary <string, object>();
foreach (Tb_WorkLogDD d1 in list1)
{
condition.Clear();
condition.Add(new SearchField("AddUserID", d1.AddUserID));
condition.Add(new SearchField("parentGuid", d1.ParentGuid));
condition.Add(new SearchField("PlanID", d1.PlanID));
condition.Add(new SearchField("PlanNum", d1.PlanNum));
String t1 = "CDate('" + d1.BegDate.ToString("yyyy-MM-dd") + "')";
condition.Add(new SearchField("begDate", t1, SearchFieldType.NumericType));
dic1.Clear();
//修改数据
if (da1.HasData(condition))
{
dic1["LogContent"] = d1.LogContent;
dic1["WorkLoad"] = d1.WorkLoad;
da1.EditData(condition, dic1);
}
else
{
dic1["LogContent"] = d1.LogContent;
dic1["WorkLoad"] = d1.WorkLoad;
if (d1.LogContent.Length > 0 && d1.WorkLoad > 0)
{
dic1["LogContent"] = d1.LogContent;
dic1["WorkLoad"] = d1.WorkLoad;
dic1["parentGuid"] = d1.ParentGuid;
dic1["PlanID"] = d1.PlanID;
dic1["PlanNum"] = d1.PlanNum;
dic1["AddUserID"] = d1.AddUserID;
dic1["AddUserName"] = d1.AddUserName;
dic1["begDate"] = d1.BegDate;
dic1["Addtime"] = d1.AddTime;
dic1["LogID"] = WebFrame.Util.JString.GetUnique32ID();
da1.NewData(dic1);
}
}
}
JConnect.GetConnect().CommitTrans();
succ = true;
}
catch (Exception err)
{
JConnect.GetConnect().RollBackTrans();
succ = false;
}
return(succ);
}
/// <summary>
/// 功能：执行普通的SQL语句
/// </summary>
public void ExcuteSql(String sql)
{
try
{
Tb_WorkLogDA da1 = new Tb_WorkLogDA();
da1.ExcuteSql(sql);
}
catch (Exception err)
{
this.ErrorInfo = err.Message.Replace("\r", "").Replace("\t", "").Replace("\n", "");
}
}
/// <summary>
/// 根据条件，修改一个数据
/// </summary>
/// <param name="condition">修改数据的条件</param>
/// <param name="data1">新的数据</param>
public void EditData(List <SearchField> condition, Dictionary <String, object> data1)
{
try
{
Tb_WorkLogDA da1 = new Tb_WorkLogDA();
da1.EditData(condition, data1);
this.executeResultCount = da1.ExecuteResultCount;
}
catch (Exception err)
{
this.ErrorInfo = err.Message.Replace("\r", "").Replace("\t", "").Replace("\n", "");
}
}
/// <summary>
/// 根据条件删除数据
/// </summary>
/// <param name="condition">删除数据条件</param>
public void DeleteData(List <SearchField> condition)
{
try
{
Tb_WorkLogDA da1 = new Tb_WorkLogDA();
da1.DeleteData(condition);
this.executeResultCount = da1.ExecuteResultCount;
}
catch (Exception err)
{
this.ErrorInfo = err.Message.Replace("\r", "").Replace("\t", "").Replace("\n", "");
}
}
/// <summary>
/// 新增一条数据
/// </summary>
/// <param name="data1">Dictionary数据</param>
public void NewData(Dictionary <String, object> data1)
{
try
{
Tb_WorkLogDA da1 = new Tb_WorkLogDA();
da1.NewData(data1);
this.executeResultCount = da1.ExecuteResultCount;
}
catch (Exception err)
{
this.ErrorInfo = err.Message.Replace("\r", "").Replace("\t", "").Replace("\n", "");
}
}
/// <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>
/// 保存工作日志
/// </summary>
///
/// <param name="logid"></param>
/// <param name="authorid"></param>
/// <param name="authorName"></param>
/// <param name="logcontent"></param>
/// <param name="begdate"></param>
///
/// <returns></returns>
public int SaveWorkLog(
String logid,
String authorid,
String authorName,
String logcontent,
String begdate)
{
int succ = 0;
JConnect.GetConnect().BeginTrans();
try
{
//1--插入或修改日志
Dictionary <String, object> dic1 = new Dictionary <string, object>();
JConnect.GetConnect().CommitTrans();
dic1["logid"] = logid;
dic1["AddUserID"] = authorid;
dic1["AddUserName"] = authorName;
dic1["begdate"] = DateTime.Parse(begdate);
dic1["logcontent"] = logcontent;
if (DateTime.Parse(begdate).ToString("yyyy-MM-dd") != DateTime.Now.ToString("yyyy-MM-dd"))
{
dic1["IsBuDeng"] = true;
}
else
{
dic1["IsBuDeng"] = false;
}
List <SearchField> condition = new List <SearchField>();
condition.Add(new SearchField("logid", logid));
Tb_WorkLogDA da1 = new Tb_WorkLogDA();
if (da1.HasData(condition))
{
da1.EditData(condition, dic1);
}
else
{
da1.NewData(dic1);
}
JConnect.GetConnect().CommitTrans();
succ = 1;
}
catch (Exception err)
{
JConnect.GetConnect().RollBackTrans();
}
return(succ);
}
/// <summary>
/// 判断是否有符合条件的数据
/// </summary>
///<param name="condition">查询条件</param>
/// <returns></returns>
public bool HasData(List <SearchField> condition)
{
bool result = false;
try
{
Tb_WorkLogDA da1 = new Tb_WorkLogDA();
result = da1.HasData(condition);
}
catch (Exception err)
{
this.ErrorInfo = err.Message.Replace("\r", "").Replace("\t", "").Replace("\n", "");
}
return(result);
}
/// <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);
}
/// <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);
}
