leave/Add.aspx.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

 using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Text;
using System.Data.SqlClient;

public partial class leave_Add : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
        
        }
    }
    protected void btnSave_Click(object sender, EventArgs e)
    {    
        if(DateTime.Parse(txt_leaveTime1.Text)>DateTime.Parse(txt_leaveTime2.Text))
        {
             Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('开始日期不能大于结束日期！');</script>");
            return;
        }

       //设置添加sql
        string strSql = String.Format(@"insert into leave(staffNo,leaveType,leaveMemo,leaveTime1,leaveTime2,leaveTime3,leaveFlag)
                                values ('{0}','{1}','{2}','{3}','{4}','{5}','等待审核')",
                                Session["adminId"].ToString(),txt_leaveType.Text,txt_leaveMemo.Text,DateTime.Parse (txt_leaveTime1.Text),DateTime.Parse (txt_leaveTime2.Text),DateTime.Now);
        //提交到数据库
        SqlHelper.ExecuteNonQuery(strSql.ToString());

        Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('提交成功，请等待管理员的审核！');location.href='Manage.aspx';</script>");

    }
}