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