protected void btleave_Click(object sender, EventArgs e)
{
workDBDataContext db = new workDBDataContext();
workoff mywork = new workoff();
if (Session["name"] == null)
{
Page.ClientScript.RegisterStartupScript(GetType(), "", "alert('登录已过期');location.href='SBSLogin.aspx';", true);
return;
}
mywork.name = Session["name"].ToString();
mywork.starttime = DateTime.Parse(this.txtFrom.Text);
mywork.originshift = this.drp_start.Text;
mywork.originweek = convertdate(Convert.ToDateTime(this.txtFrom.Text).DayOfWeek.ToString());
mywork.endtime = DateTime.Parse(this.txtTo.Text);
mywork.currentshift = this.drp_end.Text;
mywork.currentweek = convertdate(Convert.ToDateTime(this.txtTo.Text).DayOfWeek.ToString());
mywork.reason = this.tb_leave.Text;
mywork.approve = -1;
if (mywork.starttime > mywork.endtime)
{
Page.ClientScript.RegisterStartupScript(GetType(), "", "alert('开始日期不得晚于结束日期');location.href='CommitLeave.aspx';", true);
return;
}
else if (mywork.starttime == mywork.endtime && mywork.originshift == "下午" && mywork.currentshift == "上午")
{
Page.ClientScript.RegisterStartupScript(GetType(), "", "alert('开始日期不得晚于结束日期');location.href='CommitLeave.aspx';", true);
return;
}
db.workoff.InsertOnSubmit(mywork);
db.SubmitChanges();
Page.ClientScript.RegisterStartupScript(GetType(), "", "alert('申请提交成功!');location.href='staff.aspx';", true);
}
protected void btn_leave_Click(object sender, EventArgs e)
{
if (Session["name"] == null)
{
Page.ClientScript.RegisterStartupScript(GetType(), "", "alert('登录已过期');location.href='SBSLogin.aspx';", true);
return;
}
int row_count = 0;
workDBDataContext db = new workDBDataContext();
var query = from a in db.workoff
where a.approve == -1
select a;
foreach (GridViewRow r in gv_leave.Rows)
{
Control c = r.FindControl("chb_leave");
workoff ot = query.ToList().ElementAt(row_count++);
if (ot.name == r.Cells[1].Text)
{
if (((CheckBox)c).Checked)
{
ot.approve = 4;
}
else
{
ot.approve = 5;
}
}
}
//修改数据库
db.SubmitChanges();
//刷新表单
Response.Redirect("~/admin.aspx");
}
partial void Updateworkoff(workoff instance);
partial void Deleteworkoff(workoff instance);
partial void Insertworkoff(workoff instance);
