//修改 protected void btnOK_Click(object sender, EventArgs e) { // @ApplyUser, @Title, @BeginDate, @EndDate, @Reason, @ApplyDate, @ApproveDate, @Status, @Result, @Remark @ApproveID Model.Approve a = new Model.Approve(); Model.UserInfo u = (Model.UserInfo)Session["User"]; //将登陆时获取的用户信息Session重新调用 a.ApproveID = Convert.ToInt32(lblNo.Text); //请假ID a.ApproveDate = DateTime.Now; //审批时间 a.Result = Convert.ToByte(ddlApproveResult.SelectedValue); //审批结果 a.Remark = txtBackup.Text; //备注 a.ApproveUser = u.UserID; // 申请人ID a.Title = txtTitle.Text; //标题 a.Reason = txtLeaveReason.Text; //请假原因 //请假单状态 if (ddlApproveResult.SelectedValue == "2") { Label1.Visible = true; return; } else { Label1.Visible = false; } a.Status = 1; //将以上数据赋值 if (BLL.LeaveApproveBll.IsApprove(a)) { //审批成功 this.ClientScript.RegisterStartupScript(GetType(), "", "alert('恭喜您,审批已通过!!');window.parent.location='LeaveApprove.aspx';", true); } else { this.ClientScript.RegisterStartupScript(GetType(), "", "alert('很遗憾,审批未通过!');window.parent.location='LeaveApprove.aspx';", true); } }
//添加 protected void btnOK_Click(object sender, EventArgs e) { //@ApplyUser, @Title, @BeginDate, @EndDate, @Reason, @ApproveUser, @ApplyDate, @ApproveDate, @Status, @Result, @Remark Model.Approve u = new Model.Approve(); Model.UserInfo user = (Model.UserInfo)Session["User"]; //将登陆时获取的用户信息Session重新调用 u.ApplyUser = user.UserID; //申请人ID u.Title = txtTitle.Text; //标题 u.BeginDate = Convert.ToDateTime(txtBeginTime.Text + " " + ddlBegin.Text); //开始时间 u.EndDate = Convert.ToDateTime(txtEndTime.Text + " " + ddlEnd.Text); //结束时间 u.Reason = txtLeaveReason.Text; //请假原因 u.ApplyDate = DateTime.Now; //申请时间 u.Status = 0; //请假单状态 DateTime beginTime = Convert.ToDateTime(u.BeginDate); DateTime endTime = Convert.ToDateTime(u.EndDate); if (beginTime > endTime) //判断起始时间,最终时间 输入的时候合理 { this.ClientScript.RegisterStartupScript(GetType(), "", "alert('请假的起始时间不能大于结束时间!');", true); } else { //将以上数据赋值 if (BLL.LeaveApplyBll.InsertAttendInfo(u)) { //添加成功 this.ClientScript.RegisterStartupScript(GetType(), "", "alert('恭喜您,添加成功!');window.parent.location='LeaveApply.aspx';", true); } //添加失败 else { this.ClientScript.RegisterStartupScript(GetType(), "", "alert('很遗憾,添加失败!');", true); } } }
protected void Page_Load(object sender, EventArgs e) { //页面第一次加载 if (!IsPostBack) { //禁用 txtBeginTime.Enabled = false; txtEndTime.Enabled = false; txtLeaveReason.Enabled = false; txtTitle.Enabled = false; //判断是否是查看 if (Request.QueryString["ApproveID"] != null) { //表示查看 Model.Approve a = new Model.Approve(); a.ApproveID = Convert.ToInt32(Request["ApproveID"]); Model.UserInfo u = (Model.UserInfo)Session["User"]; DataTable dt = BLL.LeaveApproveBll.GetApproveInfo(a); if (dt.Rows[0] != null) //存在请假单 { lblNo.Text = dt.Rows[0]["ApproveID"].ToString(); //请假单ID lblApply.Text = dt.Rows[0]["UserName"].ToString(); //申请人 txtTitle.Text = dt.Rows[0]["Title"].ToString(); //标题 //拆分时间 DateTime begin = Convert.ToDateTime(dt.Rows[0]["BeginDate"]); //起始时间 txtBeginTime.Text = begin.ToString("yyyy-MM-dd"); DateTime end = Convert.ToDateTime(dt.Rows[0]["EndDate"]); //结束时间 ddlBegin.Text = begin.ToString("HH:nn"); txtEndTime.Text = end.ToString("yyyy-MM-dd"); ddlEnd.SelectedValue = end.ToString("HH:nn"); txtLeaveReason.Text = dt.Rows[0]["Reason"].ToString(); //请假原因 lblApplyTime.Text = dt.Rows[0]["ApplyDate"].ToString(); //申请时间 txtBackup.Text = dt.Rows[0]["Remark"].ToString(); //备注 lblApproveTime.Text = dt.Rows[0]["ApproveDate"].ToString(); //申请时间 ddlBegin.Enabled = false; ddlEnd.Enabled = false; if (Convert.ToInt32(dt.Rows[0]["Status"]) == 1) //判断请假单状态 ===》 0:待办 1:归档 { //归档 ddlApproveResult.SelectedValue = dt.Rows[0]["Result"].ToString(); //审批结果 //禁用按钮 隐藏 ddlApproveResult.Enabled = false; txtBackup.Enabled = false; txtBeginTime.Enabled = false; txtEndTime.Enabled = false; txtLeaveReason.Enabled = false; txtTitle.Enabled = false; btnOK.Visible = false; lblApplyTime.ForeColor = Color.Blue; ddlApproveResult.ForeColor = Color.Blue; lblApproveTime.ForeColor = Color.Blue; txtBackup.ForeColor = Color.Blue; } } } } }
//根据用户ID删除用户信息 public static bool DelApproveInfo(Model.Approve u) { string sql = "delete from Approve where ApproveID=@ApproveID"; SqlParameter[] para = { new SqlParameter("ApproveID", u.ApproveID) }; return(DBHelper.ExecuteNonQuery(sql, para)); }
/// <summary> /// 获取请假单信息 /// </summary> /// <param name="u"></param> /// <returns></returns> public static DataTable GetApproveInfo(Model.Approve u) { string strSql = "select * from Approve left join UserInfo on Approve.ApplyUser=UserInfo.UserID where ApproveID=@ApproveID"; SqlParameter[] para = { new SqlParameter("ApproveID", u.ApproveID), }; return(DBHelper.ExecuteSelect(strSql, para)); }
public static bool UpdateApproveInfo(Model.Approve u) { //参数化sql语句 string strSql = "UPDATE [Approve] SET [Title] = @Title where ApproveID =" + u.ApproveID; SqlParameter[] para = { new SqlParameter("Title", u.Title), }; return(DBHelper.ExecuteNonQuery(strSql, para)); }
//查询 private void BindApprove() { Model.Approve a = new Model.Approve(); a.Title = txtTitle.Text; //标题 a.ApplyUser = txtApplyUser.Text; //申请人ID //判断初始时间/起始时间是否输入 if (txtFromDate.Text != "") { a.BeginDate = Convert.ToDateTime(txtFromDate.Text); } else //设置初始,起始时间 { a.BeginDate = Convert.ToDateTime("2014-4-12"); } if (txtToDate.Text != "") { a.EndDate = Convert.ToDateTime(txtToDate.Text); } else { a.EndDate = Convert.ToDateTime("2020-4-15"); } a.Status = Convert.ToByte(rblLeaveState.SelectedValue); //讲以上数据 进行赋值 DataTable dt = BLL.LeaveApproveBll.SearchLeaveApprove(a, txtApplyUser.Text); if (dt != null) //成功 { gvApproveInfo.DataSource = dt; gvApproveInfo.DataBind(); //总共数据量 lblRowsCount.Text = dt.Rows.Count.ToString();; //总共数据量 } else //失败 { this.ClientScript.RegisterStartupScript(GetType(), "", "alert('很遗憾,数据库出现异常!')", true); } //分页功能 List <int> li = new List <int>(); for (int i = 1; i <= gvApproveInfo.PageCount; i++) { li.Add(i); } ddlPageIndex.DataSource = li; ddlPageIndex.DataBind(); lblPageCount.Text = gvApproveInfo.PageCount.ToString(); //求的总页码数 lblRowsCount.Text = BLL.LeaveApproveBll.SearchLeaveApprove(a, txtApplyUser.Text).Rows.Count.ToString(); //总共数据量 lblPageIndex.Text = Convert.ToString(gvApproveInfo.PageIndex + 1); //当前第几页 }
/// <summary> /// 实现对考勤的修改 /// </summary> /// <param name="u"></param> /// <returns></returns> public static bool UpdateApproveInfo(Model.Approve u) { //参数化sql语句 string strSql = "UPDATE [Approve] SET [Title] = @Title, [BeginDate] = @BeginDate, [EndDate] = @EndDate, [Reason] = @Reason WHERE [ApproveID] = @ApproveID"; SqlParameter[] para = { new SqlParameter("Title", u.Title), new SqlParameter("BeginDate", u.BeginDate), new SqlParameter("EndDate", u.EndDate), new SqlParameter("Reason", u.Reason), new SqlParameter("ApproveID", u.ApproveID), }; return(DBHelper.ExecuteNonQuery(strSql, para)); }
/// <summary> /// 确定是否审批 /// </summary> /// <param name="u"></param> /// <returns></returns> public static bool IsApprove(Model.Approve u) { string strSql = "UPDATE [Approve] SET [ApproveUser] = @ApproveUser, [ApproveDate] = @ApproveDate, [Result] = @Result, [Status] = @Status, [Remark] = @Remark WHERE [ApproveID] = @ApproveID"; SqlParameter[] para = { new SqlParameter("Result", u.Result), //审批结果 new SqlParameter("Remark", u.Remark), //备注 new SqlParameter("ApproveDate", u.ApproveDate), //批复时间 new SqlParameter("ApproveUser", u.ApproveUser), //审批人ID new SqlParameter("ApproveID", u.ApproveID), //请假单号 new SqlParameter("Status", u.Status), //请假单状态 }; return(DBHelper.ExecuteNonQuery(strSql, para)); }
protected void GvAskForLeave_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "DeleteApproveInfo") { Model.Approve a = new Model.Approve(); a.ApproveID = int.Parse(e.CommandArgument.ToString()); if (BLL.Approve.DelApproveInfo(a)) { GetDataBind(); this.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('删除成功!');", true); } else { this.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('删除失败!');", true); } } }
protected void Page_Load(object sender, EventArgs e) { //页面第一次加载 if (!IsPostBack) { //获取申请单ID // getIDInfo(); //判断是否是查看,修改 if (Request.QueryString["ApproveID"] != null) { //表示查看,修改 Model.Approve a = new Model.Approve(); a.ApproveID = Convert.ToInt32(Request["ApproveID"]); //请假单ID Model.UserInfo u = (Model.UserInfo)Session["User"]; a.UserID = u.UserID; //申请人ID DataTable dt = BLL.LeaveApplyBll.GetSingleApproveInfo(a); if (dt.Rows[0] != null) //存在请假单 { txtLeaveReason.Text = dt.Rows[0]["Reason"].ToString(); //请假原因 lblNo.Text = dt.Rows[0]["ApproveID"].ToString(); //请假单ID txtTitle.Text = dt.Rows[0]["Title"].ToString(); //标题 //拆分时间 DateTime begin = Convert.ToDateTime(dt.Rows[0]["BeginDate"]); //起始时间 txtBeginTime.Text = begin.ToString("yyyy-MM-dd"); DateTime end = Convert.ToDateTime(dt.Rows[0]["EndDate"]); //结束时间 ddlBegin.Text = begin.ToString("HH:nn"); txtEndTime.Text = end.ToString("yyyy-MM-dd"); //结束时间 ddlEnd.SelectedValue = end.ToString("HH:nn"); if (Convert.ToInt32(dt.Rows[0]["Status"]) == 0) //判断请假单状态 ===》 0:待办 1:归档 { //待办 btnOK.Visible = false; btnUpdate.Visible = true; } } } else //表示添加 { btnOK.Visible = true; btnUpdate.Visible = false; } } }
//更新 protected void gvApproveInfo_RowUpdating(object sender, GridViewUpdateEventArgs e) { Model.Approve a = new Model.Approve(); a.ApproveID = Convert.ToInt32(gvApproveInfo.DataKeys[e.RowIndex].Value.ToString()); a.Title = ((TextBox)(gvApproveInfo.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString().Trim(); if (BLL.LeaveApproveBll.UpdateApproveInfo(a)) { ClientScript.RegisterStartupScript(this.GetType(), "成功提示", "alert('更新成功!')", true); BindApprove(); } else { ClientScript.RegisterStartupScript(this.GetType(), "温馨提示", "alert('更新失败……')", true); } //编辑更新后,自动回到不可编辑状态 gvApproveInfo.EditIndex = -1; //调用绑定方法 BindApprove(); }
/// <summary> /// 添加请假条 /// </summary> /// <param name="u"></param> /// <returns></returns> public static bool InsertAttendInfo(Model.Approve u) { //参数化sql语句 string strSql = "INSERT INTO [Approve] ([ApplyUser], [Title], [BeginDate], [EndDate], [Reason], [ApproveUser], [ApplyDate], [ApproveDate], [Status], [Result], [Remark]) VALUES (@ApplyUser, @Title, @BeginDate, @EndDate, @Reason, @ApproveUser, @ApplyDate, @ApproveDate, @Status, @Result, @Remark)"; SqlParameter[] para = { new SqlParameter("ApplyUser", u.ApplyUser), //申请人ID new SqlParameter("Title", u.Title), //标题 new SqlParameter("BeginDate", u.BeginDate), //请假起始时间 new SqlParameter("EndDate", u.EndDate), //请假结束时间 new SqlParameter("Reason", u.Reason), //请假原因 new SqlParameter("ApproveUser", ""), //审批人ID new SqlParameter("ApplyDate", u.ApplyDate), //申请时间 new SqlParameter("ApproveDate", DBNull.Value), //批复时间 new SqlParameter("Status", u.Status), //请假单状态 new SqlParameter("Result", ""), //审批结果 new SqlParameter("Remark", ""), //备注 }; return(DBHelper.ExecuteNonQuery(strSql, para)); }
//命令对象 ===>删除 protected void gvApproveInfo_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "DeleteApproveInfo") { //表示要执行删除操作 Model.Approve a = new Model.Approve(); a.ApproveID = Convert.ToInt32(e.CommandArgument.ToString()); if (BLL.LeaveApplyBll.DelApproveInfo(a)) { //表示删除成功 this.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('恭喜您,删除成功!');", true); //即时刷新列表里面的数据 BindApprove(); } else { //表示删除失败 this.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('对不起,删除失败!');", true); } } }
//修改 protected void btnUpdate_Click(object sender, EventArgs e) { Model.Approve u = new Model.Approve(); u.ApproveID = Convert.ToInt32(lblNo.Text); //申请单ID u.Title = txtTitle.Text; //标题 string beginTime = txtBeginTime.Text + " " + ddlBegin.Text; u.BeginDate = Convert.ToDateTime(beginTime);//起始时间 string endTimer = txtEndTime.Text + " " + ddlEnd.Text; u.EndDate = Convert.ToDateTime(endTimer); //结束时间 u.Reason = txtLeaveReason.Text; //请假原因 if (BLL.LeaveApplyBll.UpdateApproveInfo(u)) { //表示修改成功 this.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('恭喜您,修改成功!');window.parent.location='/LeaveApply.aspx';", true); } else { //表示修改失败 this.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('对不起,修改失败!');", true); } }
//查询=====>请假审批 public static DataTable SearchLeaveApprove(Model.Approve u, string userName) { string strSql = "select CASE WHEN status = 0 THEN '待审批' WHEN status = 1 THEN '归档' ELSE '' END AS status, * from Approve inner join UserInfo on UserInfo.UserID=Approve.ApplyUser"; if (u.Title != "") //如果标题不为空 { strSql += " and title like '%" + u.Title + "%'"; } if (u.BeginDate.ToString() != "" || u.EndDate.ToString() != "") //判断申请时间是否为空 { // strSql += " and ApplyDate between '" + u.BeginDate + "' and '" + u.EndDate + "'"; strSql += " and ApplyDate >'" + u.BeginDate + "' and ApplyDate < '" + u.EndDate + "'"; } if (u.Status != 2) //请假状态 0待办 1归档 2全部 当前状态为全部 { strSql += " and Status=" + u.Status; } //如果申请人不为空 if (u.ApplyUser != "") { strSql += " and UserInfo.UserName like '%" + userName + "%'"; } return(DBHelper.ExecuteSelect(strSql)); }
/// <summary> /// 修改申请信息 /// </summary> ApplyUser= '******' /// <param name="model"></param> /// <returns></returns> public static bool UpdateApproveInfo(Model.Approve model) { string sql = "update Approve set Title= '" + model.Title + "',BeginDate= '" + model.BeginDate + "',EndDate= '" + model.EndDate + "',Reason= '" + model.Reason + "',Result='" + model.Result + "',ApplyDate= '" + model.ApplyDate + "' where ApproveID= '" + model.ApproveID + "'"; return(DBHelper.ExecuteNonQuery(sql, null));; }
public static bool UpdateApproveInfo1(Model.Approve model) { string sql = "update Approve set ApproveUser='******', ApproveDate='" + model.ApproveDate + "',Status='" + model.Status + "',Result='" + model.Result + "',Remark='" + model.Remark + "' where ApproveID= '" + model.ApproveID + "'"; return(DBHelper.ExecuteNonQuery(sql)); }
//根据用户ID删除用户信息 public static bool DelApproveInfo(Model.Approve u) { return(DAL.LeaveApplyDal.DelApproveInfo(u)); }
/// <summary> /// 根据ApproveID获取单个用户对象 /// </summary> /// <param name="userID">审批ID</param> /// <returns></returns> public static DataTable GetSingleApproveInfo(Model.Approve u) { return(DAL.LeaveApplyDal.GetSingleApproveInfo(u)); }
/// <summary> /// 新增申请信息 /// </summary> /// <param name="where"></param> /// <returns></returns> public static bool AddApproveInfo(Model.Approve model) { return(DAL.Approve.AddApproveInfo(model)); }
/// <summary> /// 实现对考勤的修改 /// </summary> /// <param name="u"></param> /// <returns></returns> public static bool UpdateApproveInfo(Model.Approve u) { return(DAL.LeaveApproveDal.UpdateApproveInfo(u)); }
/// <summary> /// 确定是否审批 /// </summary> /// <param name="u"></param> /// <returns></returns> public static bool IsApprove(Model.Approve u) { return(DAL.LeaveApproveDal.IsApprove(u)); }
/// <summary> /// 删除申请信息 /// </summary> /// <param name="where"></param> /// <returns></returns> public static bool DelApproveInfo(Model.Approve model) { return(DAL.Approve.DelApproveInfo(model)); }
public static bool UpdateApproveInfo1(Model.Approve model) { return(DAL.Approve.UpdateApproveInfo1(model)); }
/// <summary> /// 新增申请信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public static bool AddApproveInfo(Model.Approve model) { string sql = "insert into Approve (ApplyUser,Title,BeginDate,EndDate,Reason,ApplyDate,Status,Result) values ('" + model.ApplyUser + "', '" + model.Title + "', '" + model.BeginDate + "', '" + model.EndDate + "', '" + model.Reason + "','" + model.ApplyDate + "', '" + model.Status + "', '" + model.Result + "')"; return(DBHelper.ExecuteNonQuery(sql, null)); }
/// <summary> /// 删除申请信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public static bool DelApproveInfo(Model.Approve model) { string sql = " delete Approve where ApproveID ='" + model.ApproveID + "'"; return(DBHelper.ExecuteNonQuery(sql, null)); }
/// <summary> /// 添加请假条 /// </summary> /// <param name="u"></param> /// <returns></returns> public static bool InsertAttendInfo(Model.Approve u) { return(DAL.LeaveApplyDal.InsertAttendInfo(u)); }
/// <summary> /// 查询=====>请假申请 /// </summary> /// <param name="u"></param> /// <param name="userName"></param> /// <returns></returns> public static DataTable SearchLeaveApprove(Model.Approve u, string userName) { return(DAL.LeaveApproveDal.SearchLeaveApprove(u, userName)); }
protected void btnSave_Click(object sender, EventArgs e) { Model.UserInfo u = (Model.UserInfo)Session["User"]; Model.Approve a = new Model.Approve(); if (u.UserType == 0) //员工点击 { userNum = u.UserID; if (Request["ID"] == null) { if (VaildateNull()) //非空验证 { DataTable dt = BLL.Approve.GetApproveInfo(" and b.UserID='" + u.UserID + "'"); for (int i = 0; i < dt.Rows.Count; i++) { DateTime begin = DateTime.Parse(txtBeginTime.Text + " " + ddlBeginTime.Text); DateTime end = DateTime.Parse(txtEndTime.Text + " " + ddlEndTime.Text); if (begin > DateTime.Parse(dt.Rows[i]["BeginDate"].ToString()) && begin <= DateTime.Parse(dt.Rows[i]["EndDate"].ToString())) { this.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('在" + begin + " 至" + end + " 存在请假记录');", true); } if (end > DateTime.Parse(dt.Rows[i]["BeginDate"].ToString()) && begin <= DateTime.Parse(dt.Rows[i]["EndDate"].ToString())) { this.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('在" + begin + " 至" + end + " 存在请假记录');", true); } } a.ApplyUser = userNum; a.Title = txtTitle.Text; a.BeginDate = DateTime.Parse(txtBeginTime.Text + " " + ddlBeginTime.Text); a.EndDate = DateTime.Parse(txtEndTime.Text + " " + ddlEndTime.Text); a.ApplyDate = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); a.Reason = txtReason.Text; a.Status = 0; if (BLL.Approve.AddApproveInfo(a)) { //表示添加成功 this.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('添加成功!');window.parent.location='/AskForLeave.aspx';", true); } else { //表示添加失败 this.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('添加失败!');", true); } } } else { if (VaildateNull()) { //DataTable dt = BLL.Approve.GetApproveInfo(" and b.UserID='" + u.UserID + "'"); //for (int i = 0; i < dt.Rows.Count; i++) //{ // DateTime begin = DateTime.Parse(txtBeginTime.Text + " " + ddlBeginTime.Text); // DateTime end = DateTime.Parse(txtEndTime.Text + " " + ddlEndTime.Text); // if (begin > DateTime.Parse(dt.Rows[i]["BeginDate"].ToString()) && begin <= DateTime.Parse(dt.Rows[i]["EndDate"].ToString())) // { // this.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('在" + begin + " 至" + end + " 已经存在请假记录');", true); // } // if (end > DateTime.Parse(dt.Rows[i]["BeginDate"].ToString()) && begin <= DateTime.Parse(dt.Rows[i]["EndDate"].ToString())) // { // this.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('在" + begin + " 至" + end + " 已经存在请假记录');", true); // } //} a.ApproveID = int.Parse(lblNum.Text); a.ApplyUser = userNum; a.Title = txtTitle.Text; a.BeginDate = DateTime.Parse(txtBeginTime.Text + " " + ddlBeginTime.Text); a.EndDate = DateTime.Parse(txtEndTime.Text + " " + ddlEndTime.Text); a.ApplyDate = DateTime.Parse(DateTime.Now.ToString()); a.Reason = txtReason.Text; if (BLL.Approve.UpdateApproveInfo(a)) { //表示修改成功 this.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('修改成功!');window.parent.location='/AskForLeave.aspx';", true); } else { //表示修改失败 this.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('修改失败!');", true); } } } } else { if (string.IsNullOrEmpty(ddlResult.SelectedValue)) { lblResult.Text = "请选择审批结果!"; } else { a.ApproveID = int.Parse(Request["ID"].ToString()); a.ApproveUser = u.UserID; a.ApplyDate = DateTime.Parse(lblApplyDate.Text); a.ApproveDate = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); a.Status = 1; a.Result = byte.Parse(ddlResult.SelectedValue); a.Remark = txtRemark.Text; if (BLL.Approve.UpdateApproveInfo1(a)) { //表示审批成功 this.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('审批成功!');window.parent.location='/AskForLeaveApproval.aspx';", true); } else { //表示审批失败 this.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('审批失败!');", true); } } } }