Backup/Training/TrainingrecordAdd.aspx.cs

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

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;
using Eclipse.HRM.UI;

namespace Eclipse.HRM.UI.Training
{
    public partial class TrainingrecordAdd1 : PageBase 
    {
        protected void Page_Load(object sender, EventArgs e)
        {
        }
        protected void Button1_Click(object sender, EventArgs e)
        {
            string index;
            string a;
            string b;
            index = "insert into gradelist(trainner) values('" + TextBox23.Text + "')";
            if (Eclipse.HRM.UI.DBhelper.ExeQuery(index))
                index = "insert into train_sort(train_sort_name,status) values('" + TextBox26.Text + "','1')";
            if (TextBox26.Text != null)
            {
                Eclipse.HRM.UI.DBhelper.ExeQuery(index);
            }
            //index = "insert into train_record(train_sort_ID) select train_sort_ID from train_sort";
            a = "select max(train_sort_ID) as max1 from train_sort";
            b = "select max(train_number) as max2 from gradelist";
            //Eclipse.HRM.UI.DBhelper.ExeQuery(index);
            DataTable dt = new DataTable();
            dt = Eclipse.HRM.UI.DBhelper.GetDataTable(a);
            a = dt.Rows[0]["max1"].ToString();
            DataTable db = new DataTable();
            db = Eclipse.HRM.UI.DBhelper.GetDataTable(b);
            b = db.Rows[0]["max2"].ToString();
            index = "insert into train_record(train_number,train_sort_ID,train_char,train_name,s_time,e_time,fee,place,style,res_name,status) values('" + b + "','" + a + "','" + TextBox16.Text + "','" + TextBox18.Text + "','" + TextBox19.Text + "','" + TextBox20.Text + "','" + TextBox21.Text + "','" + TextBox22.Text + "','" + TextBox25.Text + "','" + TextBox24.Text + "','1') ";
            if (Eclipse.HRM.UI.DBhelper.ExeQuery(index))
            {
                Response.Write("<script>alert('添加成功')</script>");
                Server.Transfer("Trainingrecord.aspx");
            }
            else 
            {
                this.ClientScript.RegisterStartupScript(this.GetType(), "addError", "alert('添加数据失败。')", true);
            }
        }

       
    }
}