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 XLXLGGQuery : SingleQueryBase
    {
        XLXLGG_M queryentity = new XLXLGG_M();

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

        #region 模板事件
        #endregion

        #region 自定义事件

        private void InitControl()
        {
            TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
            TSQL SQL = new TSQL(dberp);
            SQL.Clear();
            SQL.Add("select distinct XLDTJMZHB_DTJM1 from XLDTJMZHB order by XLDTJMZHB_DTJM1 ");
            DataSet ds = dberp.OpenDataSet(SQL);
            cbxZXJM.ClearItems();
            cbxZXJM.Items.Add(new ListItem("",""));
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                cbxZXJM.Items.Add(new ListItem(ds.Tables[0].Rows[i]["XLDTJMZHB_DTJM1"].ToString().Trim(), ds.Tables[0].Rows[i]["XLDTJMZHB_DTJM1"].ToString().Trim()));
            }


            TComboBox.SetComboBox("DBERP", cbxXXJGID, "select XLXXJGB_XXJGID,XLXXJGB_XXJGID from XLXXJGB order by XLXXJGB_SFXD1,XLXXJGB_SL1,XLXXJGB_SFXD2,XLXXJGB_SL2,XLXXJGB_SFXD3,XLXXJGB_SL3,XLXXJGB_SFXD4,XLXXJGB_SL4 ", true);
        }
        #endregion


    }
}