TrainManage/TrainKq_kqjl_add_dr.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 TrainKq_kqjl_add_dr : System.Web.UI.Page
    {
        Db List = new Db();
        protected void Page_Load(object sender, EventArgs e)
        {
            PeiXunJH.Attributes.Add("readonly", "readonly");

            string SQL_GetList = "select * from qp_hr_TrainPlan  where id='" + List.GetFormatStr(Request.QueryString["PeiXunJhId"]) + "'";
            OleDbDataReader NewReader = List.GetList(SQL_GetList);
            if (NewReader.Read())
            {
                PeiXunJH.Text = NewReader["Mingcheng"].ToString();
                PeiXunJhNumber.Text = NewReader["Number"].ToString();
            }
            NewReader.Close();


        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            string SQL_tb = "select   * from qp_hr_TrainPlan_yg  where Number='" + PeiXunJhNumber.Text + "'  order by id asc";
            OleDbDataReader NewReaderTB = List.GetList(SQL_tb);
            while (NewReaderTB.Read())
            {
                string sql_insert = "insert into qp_hr_TrainKq_yg (Number,PeiXunJhId,PeiXunJhNumber,PeiXunJh,StaffId,StaffNumer,XingMing,XingBie,BuMenID,BuMen,ChuQinZK,BeiZhu,Username,Realname,NowTimes) values ('" + Request.QueryString["Number"] + "','" + Request.QueryString["PeiXunJhId"] + "','" + NewReaderTB["Number"].ToString() + "','" + NewReaderTB["PeiXunJH"].ToString() + "','" + NewReaderTB["StaffId"].ToString() + "','" + NewReaderTB["StaffNumer"].ToString() + "','" + NewReaderTB["XingMing"].ToString() + "','" + NewReaderTB["XingBie"].ToString() + "','" + NewReaderTB["BuMenID"].ToString() + "','" + NewReaderTB["BuMen"].ToString() + "','未考勤','" + List.GetFormatStr(BeiZhu.Text) + "','" + Session["Username"] + "','" + Session["Realname"] + "','" + System.DateTime.Now.ToString() + "')";
                List.ExeSql(sql_insert);
            }
            NewReaderTB.Close();

            List.InsertLog("导入人员信息[" + PeiXunJH.Text + "]", "考勤记录-导入人员信息");
            this.Response.Write("<script language=javascript>alert('提交成功！');window.close()</script>");
        }
    }
}