N_XLJC--MX/BJCPWH_AWLLBDRInfo.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 GThinking.N_MISPRO;
using GThinking.N_MISPRO.Data;
using GThinking.N_MODEL.Page;
using GThinking.N_WORKFLOW;
using GThinking.N_MODEL.Dialog;
using GThinking.N_PUBLIC;
using GThinking.N_MISPRO.Utility;
using GThinking.N_CONTROL;
using System.IO;
using System.Data.OleDb;
using System.Data.Common;
using GThinking.N_MISPROAS;
using System.Text.RegularExpressions;
using System.Collections.Generic;

namespace GThinking.N_XLJC
{
    public partial class BJCPWH_AWLLBDRInfo : SingleCardBase
    {
        BJCPWHDR entity = new BJCPWHDR();

        protected void Page_Load(object sender, EventArgs e)
        {
            this.UMID = 101421013;
            this.UMName = "报价产品维护";
            base.CurMaster = Master;
            base.CurEntity = entity;
            this.PageHeight = 180;
            this.PageWidth = 420;
            Master.EnableAttachBtn = false;
            Master.EnableCancelBtn = false;
            Master.EnableCopyBtn = false;
            Master.EnableDeleteBtn = false;
            Master.EnableEditBtn = false;
            Master.EnableInsertBtn = false;
            Master.EnablePrintBtn = false;
            Master.EnableRefreshBtn = false;
            Master.EnableSaveBtn = false;
           
            base.InitPage();

        }

        protected override void SetComboxItems()
        {
            base.SetComboxItems();

            string sSQL = @"select distinct  WL_PIID,PL_MC
                            from XLXLB
                            left join WL on XLXLB_WLID=WL_WLID
                            left join PL on PL_PIID=WL_PIID
                            where XLXLB_TYBZ<>'Y' and  isnull(WL_PIID,' ')<>' '";
            TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
            try
            {
                DataSet ds = dberp.OpenDataSet(sSQL);
                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                    string sID = ds.Tables[0].Rows[i]["WL_PIID"].ToString().Trim();
                    string sName = ds.Tables[0].Rows[i]["PL_MC"].ToString().Trim();
                    cbxPI.Items.Add(new ListItem(sName, sID));
                }
            }
            finally
            {
            }
            
           
        }

        protected void btnQD_Click(object sender, EventArgs e)
        {
            if (string.IsNullOrEmpty(cbxPI.SelectedValue.Trim()))
            {
                ShowMessage("请选择物料类别！");
                return;
            }
            TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
            TSQL SQL = new TSQL(dberp);
            SQL.Clear();
            SQL.Add(@" select distinct  XLXLB_XLXHID,XLXLB_XLGGID,XLXLB_XLBZID,XLXLB_DYDJID,XLXLB_DTJGXX,XLXLB_WJ,XLXLB_ZXWQBS
                        from XLXLB
                        left join WL on XLXLB_WLID=WL_WLID
                        left join PL on PL_PIID=WL_PIID
                        where XLXLB_TYBZ<>'Y' and  isnull(WL_PIID,' ')<>' ' and "+CMISproDataBase.GetWhereEqual("PL_PIID",cbxPI.SelectedValue.Trim()));
            DataSet ds = dberp.OpenDataSet(SQL);
            if (ds.Tables[0].Rows.Count > 0)
            {
                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                    string sXH = ds.Tables[0].Rows[i]["XLXLB_XLXHID"].ToString().Trim();
                    string sGG = ds.Tables[0].Rows[i]["XLXLB_XLGGID"].ToString().Trim();
                    string sBZ = ds.Tables[0].Rows[i]["XLXLB_XLBZID"].ToString().Trim();
                    string sDY = ds.Tables[0].Rows[i]["XLXLB_DYDJID"].ToString().Trim();
                    string sDTJGXX = ds.Tables[0].Rows[i]["XLXLB_DTJGXX"].ToString().Trim();
                    string sWJ = ds.Tables[0].Rows[i]["XLXLB_WJ"].ToString().Trim();
                    string sZXWQBS = ds.Tables[0].Rows[i]["XLXLB_ZXWQBS"].ToString().Trim();
                    if (CMISproDataBase.ExistsRecord("DBERP", "SELECT 1 FROM BJCPXX WHERE BJCPXX_XLXHID='" + sXH + "'  and  BJCPXX_XLGGID='" + sGG + "' and BJCPXX_XLBZID='" + sBZ + "'  and  BJCPXX_DYDJID='" + sDY + "'"))
                        continue;
                    SQL.Clear();
                    SQL.Add(@"INSERT INTO BJCPXX(BJCPXX_XLXHID, BJCPXX_XLGGID, BJCPXX_XLBZID, BJCPXX_DYDJID, BJCPXX_DTJGXX, BJCPXX_WJ, BJCPXX_ZXWQBS, BJCPXX_WHR, BJCPXX_WHRID, BJCPXX_WHSJ)
                               VALUES(:BJCPXX_XLXHID, :BJCPXX_XLGGID, :BJCPXX_XLBZID, :BJCPXX_DYDJID, :BJCPXX_DTJGXX, :BJCPXX_WJ, :BJCPXX_ZXWQBS, :BJCPXX_WHR, :BJCPXX_WHRID, :BJCPXX_WHSJ)");

                    SQL.ParamByName("BJCPXX_XLXHID").Value = sXH;
                    SQL.ParamByName("BJCPXX_XLGGID").Value = sGG;
                    SQL.ParamByName("BJCPXX_XLBZID").Value = sBZ;
                    SQL.ParamByName("BJCPXX_DYDJID").Value = sDY;

                    SQL.ParamByName("BJCPXX_WJ").Value = sWJ;
                    SQL.ParamByName("BJCPXX_ZXWQBS").Value = sZXWQBS;
                    SQL.ParamByName("BJCPXX_DTJGXX").Value = sDTJGXX;
                    SQL.ParamByName("BJCPXX_WHR").Value = tSession.UserName;
                    SQL.ParamByName("BJCPXX_WHRID").Value = tSession.UserId;
                    SQL.ParamByName("BJCPXX_WHSJ").Value = DateTime.Now;
                    dberp.ExecSQL(SQL);
                }
               
            }

            ShowMessage("导入成功！");
            CloseWindow();
         

        }

        protected void btnQX_Click(object sender, EventArgs e)
        {
            CloseWindow();
        }

    }
}