trips/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 trips_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_tripTime1.Text) > DateTime.Parse(txt_tripTime2.Text))
        {
            Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('开始日期不能大于结束日期！');</script>");
            return;
        }


       //设置添加sql
       string strSql=String.Format(@"insert into trips(tripTitle,tripTime1,tripTime2,tripMemo,tripTime3,staffNo)
                                values ('{0}','{1}','{2}','{3}','{4}','{5}')",
                                txt_tripTitle.Text,txt_tripTime1.Text,txt_tripTime2.Text,txt_tripMemo.Text,DateTime.Now,Session["adminId"].ToString());
        //提交到数据库
        SqlHelper.ExecuteNonQuery(strSql.ToString());

        Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('添加成功！');location.href='Manage.aspx';</script>");

    }
}