leave.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

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

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
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.Xml.Linq;

using System.Data.SqlClient;
namespace TravelWeb
{
    public partial class leave : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            Binddtlt();
        }

        public void Binddtlt()
        {
            string sqldtlt = "select * from leaves";
            DataTable dt = new DataTable();
            dt = DataConn.xiugai(sqldtlt);
            DataList1.DataSource = dt;
            DataList1.DataBind();

        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            string name = TextBox1.Text;
            string tel = TextBox2.Text;
            string tit = TextBox3.Text;
            string cont = TextBox4.Text;
            DateTime time = DateTime.Now;

           
            string procName = "AddLeave";
            SqlParameter[] parameters ={new SqlParameter("@name",SqlDbType.VarChar),
                                       new SqlParameter("@tel",SqlDbType.VarChar),
                                       new SqlParameter("@tit",SqlDbType.VarChar),
                                       new SqlParameter("@cont",SqlDbType.VarChar),
                                       new SqlParameter("@time",SqlDbType.DateTime)};
            parameters[0].Value = name;
            parameters[1].Value = tel;
            parameters[2].Value = tit;
            parameters[3].Value = cont;
            parameters[4].Value = time;

            SqlConnection conn;
            using (conn = DataConn.getSqlConnection())
            {
                try
                {
                    int rs = DataConn.getExecuteNonQuery(procName, parameters, conn);