protected void Button1_Click1(object sender, EventArgs e)
{
if (TextBox4.Text == "" || TextBox5.Text == "" || Tex10.Text == "")
{
Response.Write("<script>alert('请填写完信息')</script>");
return;
}
Msg_info msg = new Msg_info();
msg.UserId = Label1.Text;
msg.TpId = Convert.ToInt32(DdlType.SelectedValue);
msg.Cause = Tex10.Text;
msg.Beginday = Convert.ToDateTime(TextBox4.Text);
msg.EndDay = Convert.ToDateTime(TextBox5.Text);
msg.SubmitDay = DateTime.Now;
msg.Stutas = 0;
if (BLL.UserManager.ADDQJ(msg) == 1)
{
ClientScript.RegisterStartupScript(typeof(string), "print", "<script>alert('" + "提交成功" + "');window.location.href ='UserInfoManager.aspx'</script>");
}
else
{
Response.Write("<script>alert('添加失败')</script>");
}
}
/// <summary>
/// 根据id修改请假状态
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static int updateStateqjByid(Msg_info ms)
{
sqltext = "update [dbo].[Msg_info] set [Stutas]=" + ms.Stutas + " where [UserId]=" + ms.UserId + "";
int i = (int)SQLHelper.ExecuteNonQuery(sqltext);
return(i);
}
/// <summary>
/// 提交请假单
/// </summary>
/// <param name="userinfo"></param>
/// <returns></returns>
public static int ADDQJ(Msg_info mag)
{
sqltext = "insert into [dbo].[Msg_info]([UserId],[TpId],[Cause],[Beginday],[EndDay],[SubmitDay],[Stutas])values('" + mag.UserId + "'," + mag.TpId + ",'" + mag.Cause + "','" + mag.Beginday + "','" + mag.EndDay + "','" + mag.SubmitDay + "'," + mag.Stutas + ")";
int i = (int)SQLHelper.ExecuteNonQuery(sqltext);
return(i);
}
protected void rptList_ItemCommand(object source, RepeaterCommandEventArgs e)
{
if (e.CommandName == "tongguo")
{
string id = e.CommandArgument.ToString();
Msg_info msg = new Msg_info();
msg.Stutas = 1;
msg.UserId = id;
if (BLL.AdminManager.updateStateqjByid(msg) == 1)
{
Response.Redirect("~/admin/Msg.aspx");
}
else
{
Response.Write("<script>alert('失败')</script>");
}
}
if (e.CommandName == "fouding")
{
string id = e.CommandArgument.ToString();
Msg_info msg = new Msg_info();
msg.Stutas = 2;
msg.UserId = id;
if (BLL.AdminManager.updateStateqjByid(msg) == 1)
{
Response.Redirect("~/admin/Msg.aspx");
}
else
{
Response.Write("<script>alert('失败')</script>");
}
}
}
/// <summary>
/// 根据id修改请假状态
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static int updateStateqjByid(Msg_info ms)
{
return(DAL.AdminServer.updateStateqjByid(ms));
}
/// <summary>
/// 提交请假单
/// </summary>
/// <param name="userinfo"></param>
/// <returns></returns>
public static int ADDQJ(Msg_info mag)
{
return(DAL.UserServer.ADDQJ(mag));
}
