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_PUBLIC;
using GThinking.N_MISPRO;
using GThinking.N_MISPRO.Data;
using GThinking.N_MODEL.Page;
using GThinking.N_MISPRO.Utility;
using GThinking.N_CONTROL;


namespace GThinking.N_XLXSBJ
{
    public partial class CXJGB_XLXHQuery : SingleQueryBase
    {
        CXJGB_XLXH_M queryentity = new CXJGB_XLXH_M();
        #region page事件

        protected void Page_Load(object sender, EventArgs e)
        {
            this.UMID = 100860037;
            this.UMName = "查询";
            this.CurMaster = Master;
            this.CurQueryEntity = queryentity;
            this.CurQueryTable = QueryTalbe;
            if (!IsPostBack)
            {
                InitControls();
            }
            base.InitPage();

        }

        #endregion

        #region 模板事件

        protected override bool QueryLogicValid()
        {
            if (cbxJGB.SelectedValue.Trim().Equals(""))
            {
                ShowMessage("请选择价格表！");
                return false;
            }
            if (cbxXSFS.SelectedValue.Trim().Equals("1"))
            {
                if (cbxXH.SelectedValue.Trim().Equals(""))
                {
                    ShowMessage("按型号列示表价时，型号不允许为空（可多选）！");
                    return false;
                }
                else if (cbxXH.SelectedValue.Trim().Split(',').Length > 253)
                {
                    ShowMessage(string.Format("已选{0}个型号，请控制在253以内！", cbxXH.SelectedValue.Trim().Split(',').Length));
                    return false;
                }
            }
            else if (cbxXSFS.SelectedValue.Trim().Equals("2"))
            {
                if (cbxXH.SelectedValue.Trim().Equals(""))
                {
                    ShowMessage("按主芯截面列示表价时，型号不允许为空（不可多选）！");
                    return false;
                }
                else if (cbxXH.SelectedValue.Trim().Contains(","))
                {
                    ShowMessage("按主芯截面列示表价时，型号不允许多选！");
                    return false;
                }
                if (cbxBZ.SelectedValue.Trim().Equals(""))
                {
                    ShowMessage("按主芯截面列示表价时，标准不允许为空！");
                    return false;
                }
                if (cbxDYDJ.SelectedValue.Trim().Equals(""))
                {
                    ShowMessage("按主芯截面列示表价时，电压等级不允许为空！");
                    return false;
                }
            }
            else if (cbxXSFS.SelectedValue.Trim().Equals("3"))
            {
                if (cbxXH.SelectedValue.Trim().Equals(""))
                {
                    ShowMessage("按规格列示表价时，型号不允许为空（不可多选）！");
                    return false;
                }
                else if (cbxXH.SelectedValue.Trim().Contains(","))
                {
                    ShowMessage("按规格列示表价时，型号不允许多选！");
                    return false;
                }
                if (cbxBZ.SelectedValue.Trim().Equals(""))
                {
                    ShowMessage("按规格列示表价时，标准不允许为空！");
                    return false;
                }
                if (cbxDYDJ.SelectedValue.Trim().Equals(""))
                {
                    ShowMessage("按规格列示表价时，电压等级不允许为空！");
                    return false;
                }
            }
            return base.QueryLogicValid();
        }
        # endregion

        #region 自定义事件

        private void InitControls()
        {
            cbxFL.ClearItems();
            cbxFL.Items.Add(new ListItem("报价价格表", "JGB"));
            cbxFL.Items.Add(new ListItem("基价价格表", "JGC"));
  
            cbxXSFS.ClearItems();
            cbxXSFS.Items.Add(new ListItem("按型号列示表价", "1"));
            cbxXSFS.Items.Add(new ListItem("按主芯截面列示表价", "2"));
            cbxXSFS.Items.Add(new ListItem("按规格列示表价", "3"));
        }

        #endregion

        #region 控件事件

        protected void cbxFL_Select(object sender, EventArgs e)
        {
            if (!cbxFL.SelectedValue.Trim().Equals(""))
            {
                TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
                TSQL sql = new TSQL(dberp);
                sql.Add("SELECT XLXSJGB_JGBID,XLXSJGB_YXQS,XLXSJGB_YXQZ,XLXSJGB_JGBMC from XLXSJGB where XLXSJGB_MXBH='"+cbxFL.SelectedValue+"' order by XLXSJGB_JGBID");
                DataSet ds = dberp.OpenDataSet(sql);
                cbxJGB.ClearItems();
                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                    string sJGBID = ds.Tables[0].Rows[i]["XLXSJGB_JGBID"].ToString().Trim();
                    string sYXQS = ds.Tables[0].Rows[i]["XLXSJGB_YXQS"].ToString().Trim();
                    string sYXQZ = ds.Tables[0].Rows[i]["XLXSJGB_YXQZ"].ToString().Trim();
                    string sJGBMC = ds.Tables[0].Rows[i]["XLXSJGB_JGBMC"].ToString().Trim();
                    if (sYXQS.Equals(""))
                        sYXQS = "--";
                    else
                        sYXQS = CMISproConvert.ConvertDate(sYXQS);
                    if (sYXQZ.Equals(""))
                        sYXQZ = "--";
                    else
                        sYXQZ = CMISproConvert.ConvertDate(sYXQZ);
                    if (sJGBMC.Equals(""))
                        cbxJGB.Items.Add(new ListItem(sJGBID + "|" + sYXQS + "至" + sYXQZ, sJGBID));
                    else
                        cbxJGB.Items.Add(new ListItem(sJGBID + "|" + sYXQS + "至" + sYXQZ + "|" + sJGBMC, sJGBID));
                }
                cbxJGB.ShowValue = false;
            }
        }

        protected void cbxJGB_Select(object sender, EventArgs e)
        {
            cbxXH.SelectedValue = "";
            cbxBZ.SelectedValue = "";
            cbxDYDJ.SelectedValue = "";

            if (!cbxJGB.SelectedValue.Trim().Equals(""))
            {
                TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
                TSQL sql = new TSQL(dberp);
                sql.Add("select distinct XLXSJGBMX_XLXHID as ID,XLXSJGBMX_XLXHID as Name from XLXSJGBMX where XLXSJGBMX_JGBID ='" + cbxJGB.SelectedValue.Trim() + "' order by ID");
                DataSet ds = dberp.OpenDataSet(sql);
                cbxXH.ClearItems();
                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                    cbxXH.Items.Add(new ListItem(ds.Tables[0].Rows[i]["Name"].ToString().Trim(), ds.Tables[0].Rows[i]["ID"].ToString().Trim()));
                }
                cbxXH.ShowValue = false;

                cbxBZ.ClearItems();
                TComboBox.SetComboBox("DBERP", cbxBZ, "select  distinct XLBZ_XLBZID,XLBZ_XLBZLXMC,XLBZ_PX from XLXSJGBMX left join XLBZ on XLBZ_XLBZID = XLXSJGBMX_XLBZID where XLXSJGBMX_JGBID ='" + cbxJGB.SelectedValue.Trim() + "' and isnull(XLXSJGBMX_XLBZID,' ')<>' ' order by XLBZ_PX,XLBZ_XLBZID", true);

                cbxDYDJ.ClearItems();
                TComboBox.SetComboBox("DBERP", cbxDYDJ, "select distinct XLXSJGBMX_DYDJID as ID,XLXSJGBMX_DYDJID as Name from XLXSJGBMX left join XLDYDJB on XLDYDJB_DYDJID=XLXSJGBMX_DYDJID where XLXSJGBMX_JGBID ='" + cbxJGB.SelectedValue.Trim() + "' and isnull(XLDYDJB_DYDJID,' ')<>' ' order by ID", true);
                cbxDYDJ.ShowValue = false;
            }
            else
            {
                cbxXH.ClearItems();
                cbxBZ.ClearItems();
                cbxDYDJ.ClearItems();
            }
        }

        protected void cbxXH_Select(object sender, EventArgs e)
        {
            cbxBZ.SelectedValue = "";
            cbxDYDJ.SelectedValue = "";

            if (!cbxXH.SelectedValue.Trim().Equals(""))
            {
                cbxBZ.ClearItems();
                TComboBox.SetComboBox("DBERP", cbxBZ, "select distinct XLBZ_XLBZID,XLBZ_XLBZLXMC,XLBZ_PX from XLXSJGBMX left join XLBZ on XLBZ_XLBZID = XLXSJGBMX_XLBZID where XLXSJGBMX_JGBID ='" + cbxJGB.SelectedValue.Trim() + "' and " + CMISproDataBase.GetWhereEqual("XLXSJGBMX_XLXHID", cbxXH.SelectedValue.Trim()) + " and isnull(XLXSJGBMX_XLBZID,' ')<>' ' order by XLBZ_PX,XLBZ_XLBZID", true);

                cbxDYDJ.ClearItems();
                TComboBox.SetComboBox("DBERP", cbxDYDJ, "select distinct XLXSJGBMX_DYDJID as ID,XLXSJGBMX_DYDJID as Name from XLXSJGBMX left join XLDYDJB on XLDYDJB_DYDJID=XLXSJGBMX_DYDJID where XLXSJGBMX_JGBID ='" + cbxJGB.SelectedValue.Trim() + "' and " + CMISproDataBase.GetWhereEqual("XLXSJGBMX_XLXHID", cbxXH.SelectedValue.Trim()) + " and isnull(XLDYDJB_DYDJID,' ')<>' ' order by ID", true);
                cbxDYDJ.ShowValue = false;

                if (cbxBZ.ItemsCount == 2)
                {
                    cbxBZ.SelectedIndex = 1;
                }
                if (cbxDYDJ.ItemsCount == 2)
                {
                    cbxDYDJ.SelectedIndex = 1;
                }
            }
            else
            {
                cbxBZ.ClearItems();
                TComboBox.SetComboBox("DBERP", cbxBZ, "select distinct XLBZ_XLBZID,XLBZ_XLBZLXMC,XLBZ_PX from XLXSJGBMX left join XLBZ on XLBZ_XLBZID = XLXSJGBMX_XLBZID where XLXSJGBMX_JGBID ='" + cbxJGB.SelectedValue.Trim() + "' and isnull(XLXSJGBMX_XLBZID,' ')<>' ' order by XLBZ_PX,XLBZ_XLBZID", true);

                cbxDYDJ.ClearItems();
                TComboBox.SetComboBox("DBERP", cbxDYDJ, "select distinct XLXSJGBMX_DYDJID as ID,XLXSJGBMX_DYDJID as Name from XLXSJGBMX left join XLDYDJB on XLDYDJB_DYDJID=XLXSJGBMX_DYDJID where XLXSJGBMX_JGBID ='" + cbxJGB.SelectedValue.Trim() + "' and isnull(XLDYDJB_DYDJID,' ')<>' ' order by ID", true);
                cbxDYDJ.ShowValue = false;
            }
        }
        #endregion
    }
}