//修改
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);
}
}
}
}
