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