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_MISPRO.Utility;
using GThinking.N_PUBLIC;

namespace GThinking.N_XLXSBJ
{
    public partial class CLQD_SZCLJGBL : SingleCardBase
    {
        SZCLJGBL entity = new SZCLJGBL();
        protected void Page_Load(object sender, EventArgs e)
        {
            this.UMID = 100860002;
            this.UMName = "设置材料用量比例";
            this.CurMaster = Master;
            this.CurEntity = entity;
            this.PageHeight = 400;
            this.PageWidth = 500;

            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();
            if (!IsPostBack)
            {
                InitControl();
                txtCLJGBL.Value = 1;
            }
        }

        #region 自定义函数

        private void InitControl()
        {
            if (!PageParam.GetRTrimString("JGCZBID").Equals(""))
            {
                //加载材料名称
                cbxCLMC.ClearItems();
                TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
                TSQL SQL = new TSQL(dberp);
                SQL.Clear();
                SQL.Add("select SUBSTRING(XLJGCZBLM_CLQDL,2,2) as ID,XLJGCZBLM_CLQDL,XLXSBJCL_BJCLID, ");
                SQL.Add(" case when isnull(XLXSBJCL_BJCLID,' ')=' ' then XLJGCZBLM_CZBLMMC else XLXSBJCL_BJCLMC end as CLMC ");
                SQL.Add(" from XLJGCZBLM left join XLXSBJCL on XLXSBJCL_BJCLID=XLJGCZBLM_BJCLID ");
                //SQL.Add(" left join XLJGCZBML on XLJGCZBML_JGCZBID = XLJGCZBLM_JGCZBID ");
                SQL.Add(" where XLJGCZBLM_JGCZBID=:pJGCZBID and XLJGCZBLM_JGCZBBBID =:pJGCZBBBID and isnull(XLJGCZBLM_CLQDL,' ')<>' ' ");
                SQL.Add(" order by XLJGCZBLM_CLQDL");
                SQL.ParamByName("pRQ").Value = DateTime.Now.ToShortDateString();
                SQL.ParamByName("pJGCZBID").Value = PageParam.GetRTrimString("JGCZBID");
                SQL.ParamByName("pJGCZBBBID").Value = PageParam.GetRTrimString("JGCZBBBID");
                DataSet ds = dberp.OpenDataSet(SQL);
                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                    cbxCLMC.Items.Add(new ListItem(ds.Tables[0].Rows[i]["XLJGCZBLM_CLQDL"].ToString().Trim() + ":" + ds.Tables[0].Rows[i]["XLXSBJCL_BJCLID"].ToString().Trim()
                        + "|" + ds.Tables[0].Rows[i]["CLMC"].ToString().Trim(), ds.Tables[0].Rows[i]["ID"].ToString().Trim()));
                }
                cbxCLMC.ShowValue = false;
            }
        }
        #endregion

        #region 控件事件
        protected void btnQD_Click(object sender, EventArgs e)
        {
            //校验数据项
            if (cbxCLMC.SelectedValue.Trim().Equals(""))
            {
                ShowMessage("材料名称不允许为空！");
                return;
            }
            if (txtCLJGBL.Value <= 0)
            {
                ShowMessage("材料用量比例不允许小于等于0！");
                return;
            }
            else if (txtCLJGBL.Value > 1)
            {
                ShowMessage("材料用量比例不允许大于1！");
                return;
            }
            //使用脚本给父页面的隐藏控件赋值，调用父页面的控件事件
            DialogOperationScript dos = new DialogOperationScript(this);
            dos.SetOwnerControlValue("ctl00_CPHForm_txtCLMXList", cbxCLMC.SelectedValue.Trim());
            dos.SetOwnerControlValue("ctl00_CPHForm_txtCLJGBL", txtCLJGBL.Value.ToString());
            dos.ClickOwnerButton(PageParam.GetRTrimString("RefreshCtrlID"));
            dos.CloseSelf();
            dos.Execute();
        }

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

        #endregion
    }
}