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_MODEL.Page;
using GThinking.N_MODEL.Dialog;
using GThinking.N_PUBLIC;
using GThinking.N_MISPRO.Utility;
using GThinking.N_MISPRO.Data;

namespace GThinking.N_XLJC
{
    public partial class XLXLXHQuery : SingleQueryBase
    {
        XLXHB_M queryentity = new XLXHB_M();

        protected void Page_Load(object sender, EventArgs e)
        {
            this.UMID = 101421000;
            this.UMName = "线缆型号";
            this.CurMaster = Master;
            this.CurQueryTable = QueryTable;
            this.CurQueryEntity = queryentity;
            base.InitPage();
            if (!IsPostBack)
            {
                InitControl();
            }
        }

        #region 自定义事件

        private void InitControl()
        {
            TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
            TSQL sSQL = new TSQL(dberp);
            sSQL.Clear();
            sSQL.Add("select distinct XLXHB_CPYT,XLCPYT_CPYTMC from XLXHB left join XLCPYT on XLCPYT_CPYT=XLXHB_CPYT where isnull(XLXHB_CPYT,' ') <> ' ' ");
            cbxCPYT.ClearItems();
            cbxCPYT.Items.Add(new ListItem("", ""));
            DataSet ds = dberp.OpenDataSet(sSQL);
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                cbxCPYT.Items.Add(new ListItem(ds.Tables[0].Rows[i]["XLCPYT_CPYTMC"].ToString().Trim(), ds.Tables[0].Rows[i]["XLXHB_CPYT"].ToString().Trim()));                
            }
        }


        #endregion


    }
}