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