TrainManage/TrainPlan_kc_add.aspx.cs

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

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;
using qiupeng.Public;
using System.IO;
namespace qphr.TrainManage
{
    public partial class TrainPlan_kc_add : System.Web.UI.Page
    {
        Db List = new Db();
        BindDrowDownList list = new BindDrowDownList();
        public static string fjkey;

        protected void Page_Load(object sender, EventArgs e)
        {
            if (this.Session["username"] == null)
            {
                this.Response.Write("<script language=javascript>alert('登陆超时！');window.parent.location = '../main_d.aspx'</script>");
                return;

            }

            if (!Page.IsPostBack)
            {
                BindAttribute();
            }
        }
        public void BindAttribute()
        {
            JiangShi.Attributes.Add("readonly", "readonly");
            PeiXunKJ.Attributes.Add("readonly", "readonly");
            Button1.Attributes["onclick"] = "javascript:return chknull();";
        }


        protected void Button1_Click(object sender, EventArgs e)
        {
            string sql_insert = "insert into qp_hr_TrainPlan_kc (Number,PeiXunJH,KeChengMC,KaiShiRQ,JieZhiRQ,PeiXunKJID,PeiXunKJ,JiangShiID,JiangShi,SouKeFS,PeiXunFF,BeiZhu,Username,Realname,NowTimes) values ('" + Request.QueryString["Number"] + "','','" + List.GetFormatStr(KeChengMC.Text) + "','" + List.GetFormatStr(KaiShiRQ.Text) + "','" + List.GetFormatStr(JieZhiRQ.Text) + "','" + List.GetFormatStr(PeiXunKJID.Text) + "','" + List.GetFormatStr(PeiXunKJ.Text) + "','" + List.GetFormatStr(JiangShiID.Text) + "','" + List.GetFormatStr(JiangShi.Text) + "','" + List.GetFormatStr(SouKeFS.Text) + "','" + List.GetFormatStr(PeiXunFF.Text) + "','" + List.GetFormatStr(BeiZhu.Text) + "','" + Session["Username"] + "','" + Session["Realname"] + "','" + System.DateTime.Now.ToString() + "')";
            List.ExeSql(sql_insert);
            List.InsertLog("新增培训课程[" + KeChengMC.Text + "]", "培训计划-培训课程");
            this.Response.Write("<script language=javascript>alert('提交成功！');window.close()</script>");

        }

    }
}