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_PUBLIC;
using GThinking.N_MISPRO.Utility;

namespace GThinking.U20261363_N_XLXSBJ
{
    public partial class XLBJD_WBBJDMX_BBPPGZWHInfo : SingleCardBase
    {
        XLBJD_WBBJDMX_BBPPGZWH entity = new XLBJD_WBBJDMX_BBPPGZWH();

        #region Page事件继承
        protected void Page_Load(object sender, EventArgs e)
        {
            this.UMID = 100860174;
            this.UMName = "标准匹配规则";
            this.CurMaster = Master;
            this.CurEntity = entity;
            this.Master.EnableAttachBtn = false;
            this.Master.EnablePrintBtn = false;
            this.PageWidth = 500;
            this.PageHeight = 400;

            base.InitPage();

            if (!IsPostBack)
            {
                InitControl();
            }
        }

        #endregion

        #region 模板事件继承

        protected override void LoadRecord()
        {
            if (!IsPostBack)
            {
                this.CurEntity.Param.Add("ID", PageParam.GetRTrimString("ID"));
            }
            else
            {
                this.CurEntity.Param.Add("ID", txtID.Value);
            }

            base.LoadRecord();
        }

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

            txtPriority.Value = 1;
            chkIsActive.Checked = true;
        }

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

            txtPriority.Value = 1;
            chkIsActive.Checked = true;
        }

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

            datCreateTime.Enabled = false;
        }

       

        protected override bool DataLogicValid()
        {
            if (txtHeaderStd.Text.Trim().Equals(""))
            {
                ShowMessage("表头指定标准不允许为空！");
                return false;
            }

            if (txtDbStd.SelectedValue.Trim().Equals(""))
            {
                ShowMessage("匹配标准不允许为空！");
                return false;
            }

            //新增/复制时校验同一表头标准下匹配标准不能重复
            if ((ControlState == TControlState.ctsInsert) || (ControlState == TControlState.ctsCopy))
            {
                TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
                TSQL SQL = new TSQL(dberp);
                SQL.Add("select 1 from dbo.StandardMatchRule where HeaderStd=:pHeaderStd and DbStd=:pDbStd");
                SQL.ParamByName("pHeaderStd").Value = txtHeaderStd.Text.Trim();
                SQL.ParamByName("pDbStd").Value = txtDbStd.SelectedValue.Trim();
                if (dberp.OpenDataSet(SQL).Tables[0].Rows.Count > 0)
                {
                    ShowMessage("该表头指定标准下此匹配标准已经存在，不允许重复！");
                    return false;
                }
            }

            return base.DataLogicValid();
        }

        protected override bool Master_BeforeSaveAction(object sender, EventArgs e)
        {
            txtHeaderStd.Text = txtHeaderStd.Text.Trim();
            txtDbStd.SelectedValue = txtDbStd.SelectedValue.Trim();

            return base.Master_BeforeSaveAction(sender, e);
        }

        protected override bool Master_AfterSaveAction(object sender, EventArgs e)
        {
            //新增/复制后回填自增ID，保证保存后继续编辑时能正确定位记录
            if ((ControlState == TControlState.ctsInsert) || (ControlState == TControlState.ctsCopy))
            {
                TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
                TSQL SQL = new TSQL(dberp);
                SQL.Add("select ID from dbo.StandardMatchRule where HeaderStd=:pHeaderStd and DbStd=:pDbStd");
                SQL.ParamByName("pHeaderStd").Value = txtHeaderStd.Text.Trim();
                SQL.ParamByName("pDbStd").Value = txtDbStd.SelectedValue.Trim();
                DataSet ds = dberp.OpenDataSet(SQL);
                if (ds.Tables[0].Rows.Count > 0)
                {
                    txtID.Value = ds.Tables[0].Rows[0]["ID"].ToString().Trim();
                }
            }

            return base.Master_AfterSaveAction(sender, e);
        }

        #endregion

        #region 私有函数
        private void InitControl()
        {
            //TComboBox.SetComboBox("DBERP",txtHeaderStd,"select XLBZ_XLBZID,XLBZ_XLBZLXMC from XLBZ order by XLBZ_PX",false);
            TComboBox.SetComboBox("DBERP", txtDbStd, "select XLBZ_XLBZID,XLBZ_XLBZLXMC from XLBZ order by XLBZ_PX", false);

        }
        #endregion
    }
}