/// <summary>
/// 工作日志添加
/// </summary>
/// <param name="log"></param>
/// <returns></returns>
public static object workLogAdd(worklog log)
{
sqltext = "insert into worklog( uid , detail , time ) values('" + log.Uid + "','" + log.Detail + "','" + log.Datetime + "')";
int i = (int)DAL.SQLHELPER.ExecuteNonQuery(sqltext);
return(i);
}
/// <summary>
/// 精确查找工作日志 BYWID
/// </summary>
/// <param name="log"></param>
/// <returns></returns>
public static DataSet selectWorkLogByWid(worklog log)
{
sqltext = "select logid as 日志编号,uid as 员工编号,detail as 详细信息 ,time as 时间 from worklog where uid='" + log.Uid + "';";
DataSet work = DAL.SQLHELPER.ExecuteDataSet(sqltext);
return(work);
}
private void btnSubmit_Click(object sender, EventArgs e)
{
//提交
worklog w = new worklog();
w.Detail = this.txtWorklog.Text;
w.Uid = Local.getCurrentUid();
w.Datetime = DateTime.Now.ToLocalTime().ToString();//YYYY-MM-dd hh:mm::ss
if (WorkLogBll.addWorklog(w) == 1)
{
MessageBox.Show("提交成功");
bind();
}
}
public Fixture AddWorklog(worklog worklog)
{
_worklogs.Add(worklog);
return(this);
}
/// <summary>
/// 工作日志添加
/// </summary>
/// <param name="log"></param>
/// <returns></returns>
public static object workLogAdd(worklog log)
{
return(DAL.WorklogServercs.workLogAdd(log));
}
/// <summary>
/// 精确查找工作日志 BYWID
/// </summary>
/// <param name="log"></param>
/// <returns></returns>
public static DataSet selectWorkLogByWid(worklog log)
{
return(DAL.WorklogServercs.selectWorkLogByWid(log));
}
//添加工作日志
public static int addWorklog(worklog log)
{
return(DAL.WorklogServercs.addWorklog(log));
}
//添加工作日志
public static int addWorklog(worklog log)
{
sqltext = "INSERT INTO worklog(uid,detail,time)VALUES('" + log.Uid + "','" + log.Detail + "','" + log.Datetime + "')";
return(Convert.ToInt32(DAL.SQLHELPER.ExecuteNonQuery(sqltext)));
}
