public void InsertIntoSign(MSign objsign) { StringBuilder sb = new StringBuilder(); sb.Append("INSERT INTO tb_sign ([datetime], employeeName, late, quit) values (@Datetime,@EmployeeName,@Late,@Quit)"); OleDbParameter[] param = { OleDbHelper.GetParameter("@Datetime", OleDbType.Date, "datetime", objsign.Datetime), OleDbHelper.GetParameter("@EmployeeName", OleDbType.VarWChar, 20, "employeeName", objsign.EmployeeName), OleDbHelper.GetParameter("@Late", OleDbType.Boolean, "late", objsign.Late), OleDbHelper.GetParameter("@Quit", OleDbType.Boolean, "quit", objsign.Quit) }; OleDbHelper.ExecuteSql(sb.ToString(), param); }
protected void Button2_Click(object sender, EventArgs e) { sign signs = new sign(); MSign objsign = new MSign(); //下班进行考勤设置 if (DateTime.Compare(Convert.ToDateTime(DateTime.Now.ToString("hh:mm:ss")), Convert.ToDateTime(down)) >= 0) { objsign.Datetime = DateTime.Now; objsign.EmployeeName = Session["loginName"].ToString(); objsign.Late = false; objsign.Quit = false; signs.InsertIntoSign(objsign); } else { objsign.Datetime = DateTime.Now; objsign.EmployeeName = Session["loginName"].ToString(); objsign.Late = false; objsign.Quit = true; signs.InsertIntoSign(objsign); } this.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('签退成功!');</script>"); }
public void InsertIntoSign(MSign objsign) { signs.InsertIntoSign(objsign); }