HireManage/peoplezpms_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.HireManage
{
    public partial class peoplezpms_add_dr : System.Web.UI.Page
    {
        Db List = new Db();
        protected void Page_Load(object sender, EventArgs e)
        {
            Button1.Attributes["onclick"] = "javascript:return chknull();";
            CxTitle.Attributes.Add("readonly", "readonly");
        }

        protected void Button1_Click(object sender, EventArgs e)
        {



            string SQL_tb = "select   * from qp_hr_peoplezpcx_mx  where Number='" + CxNumber.Text + "' and CsJieGuo='" + CsJieGuo.SelectedValue + "'  order by id asc";
            OleDbDataReader NewReaderTB = List.GetList(SQL_tb);
            while (NewReaderTB.Read())
            {
                string sql_insert = "insert into qp_hr_peoplezpms_mx (CxGongz,Number,Title,Name,CsBothDay,JiGuan,XueLi,ZhuanYe,DianHua,Email,DiZhi,ZpBmId,ZpBmName,CxRiQi,ZhiWei,CxFanShi,CsJieGuo,BeiZhu,Username,Realname,NowTimes) values ('" + NewReaderTB["CxGongz"].ToString() + "','" + Request.QueryString["Number"] + "','','" + NewReaderTB["Name"].ToString() + "','" + NewReaderTB["CsBothDay"].ToString() + "','" + NewReaderTB["JiGuan"].ToString() + "','" + NewReaderTB["XueLi"].ToString() + "','" + NewReaderTB["ZhuanYe"].ToString() + "','" + NewReaderTB["DianHua"].ToString() + "','" + NewReaderTB["Email"].ToString() + "','" + NewReaderTB["DiZhi"].ToString() + "','" + NewReaderTB["ZpBmId"].ToString() + "','" + NewReaderTB["ZpBmName"].ToString() + "','','" + NewReaderTB["ZhiWei"].ToString() + "','','未审核','" + NewReaderTB["BeiZhu"].ToString() + "','" + Session["Username"] + "','" + Session["Realname"] + "','" + System.DateTime.Now.ToString() + "')";
                List.ExeSql(sql_insert);
            }
            NewReaderTB.Close();

            List.InsertLog("导入人员信息[" + CxTitle.Text + "]", "招聘面试-导入人员信息");
            this.Response.Write("<script language=javascript>alert('提交成功！');window.close()</script>");
        }
    }
}