protected void btn_overtime_Click(object sender, EventArgs e)
{
if (Session["name"] == null)
{
Page.ClientScript.RegisterStartupScript(GetType(), "", "alert('登录已过期');location.href='SBSLogin.aspx';", true);
}
int row_count = 0;
workDBDataContext db = new workDBDataContext();
var query = from a in db.overtime
where a.approve == -1
select a;
foreach (GridViewRow r in gv_over.Rows)
{
Control c = r.FindControl("chb_reivew");
overtime 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");
}
protected void btleave_Click(object sender, EventArgs e)
{
workDBDataContext db = new workDBDataContext();
overtime work = new overtime();
if (Session["name"] == null)
{
Page.ClientScript.RegisterStartupScript(GetType(), "", "alert('登录已过期');location.href='SBSLogin.aspx';", true);
return;
}
work.name = Session["name"].ToString();
work.reason = this.tb_leave.Text;
string day = this.drp_orgin.Text.Substring(0, this.drp_orgin.Text.LastIndexOf(" "));
string shift = this.drp_orgin.Text.Substring(day.Length + 1);
if (shift.Equals("上午"))
{
work.origin_shift = "明天上午";
work.origin_week = convertdate(DateTime.Parse(day).AddDays(-1).DayOfWeek.ToString());
work.originwork = DateTime.Parse(day).AddDays(-1);
}
else
{
work.origin_shift = "当天下午";
work.origin_week = convertdate(DateTime.Parse(day).DayOfWeek.ToString());
work.originwork = DateTime.Parse(day);
}
work.overwork = DateTime.Parse(this.txtTo.Text);
work.current_shift = this.drp_end.Text;
work.current_week = convertdate(DateTime.Parse(this.txtTo.Text).DayOfWeek.ToString());
work.approve = -1;
if (work.originwork > work.overwork)
{
Page.ClientScript.RegisterStartupScript(GetType(), "", "alert('提交失败，开始日期不得晚于结束日期');location.href='CommitOver.aspx';", true);
return;
}
var query_over = from a in db.overtime
where a.originwork == work.originwork && a.name == Session["name"].ToString()
select a;
if (query_over.Count() != 0)
{
Page.ClientScript.RegisterStartupScript(GetType(), "", "alert('提交失败，您已经把该日调休替换到其他时间了，请检查！！');location.href='CommitOver.aspx';", true);
return;
}
db.overtime.InsertOnSubmit(work);
db.SubmitChanges();
Page.ClientScript.RegisterStartupScript(GetType(), "", "alert('申请提交成功!');location.href='staff.aspx';", true);
}
partial void Updateovertime(overtime instance);
partial void Deleteovertime(overtime instance);
partial void Insertovertime(overtime instance);
