U20261363_N_XLXSBJ/XLBJD_WBBJDMX_MRDYWHInfo.aspx.cs

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

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

        protected void Page_Load(object sender, EventArgs e)
        {
            this.UMID = 100860174;
            this.UMName = "外部线缆产品导入";
            this.CurMaster = Master;
            this.CurEntity = entity;
            this.PageHeight = 400;
            this.PageWidth = 500;
            this.Master.EnableAttachBtn = false;
            InitPage();
        }

        #region 模板事件继承

        protected override void LoadRecord()
        {
            if (!IsPostBack)
            {
                this.CurEntity.Param.Add("XLXHID", PageParam.GetRTrimString("XLXHID").Equals("") ? " " : PageParam.GetRTrimString("XLXHID"));
                this.CurEntity.Param.Add("ZXJMS", PageParam.GetRTrimString("ZXJMS").Equals("") ? "0" : PageParam.GetRTrimString("ZXJMS"));
                this.CurEntity.Param.Add("ZXJMZ", PageParam.GetRTrimString("ZXJMZ").Equals("") ? "0" : PageParam.GetRTrimString("ZXJMZ"));
            }
            else
            {
                this.CurEntity.Param.Add("XLXHID", txtOLDXLXHID.Value.Trim().Equals("") ? " " : txtOLDXLXHID.Value.Trim());
                this.CurEntity.Param.Add("ZXJMS", txtOLDZXJMS.Value.Trim().Equals("") ? "0" : txtOLDZXJMS.Value.Trim());
                this.CurEntity.Param.Add("ZXJMZ", txtOLDZXJMZ.Value.Trim().Equals("") ? "0" : txtOLDZXJMZ.Value.Trim());
            }

            base.LoadRecord();

            txtOLDXLXHID.Value = cbxXLXHID.SelectedValue.Trim().Equals("") ? " " : cbxXLXHID.SelectedValue.Trim();
            txtOLDZXJMS.Value = txtZXJMS.Value.ToString();
            txtOLDZXJMZ.Value = txtZXJMZ.Value.ToString();
        }

        protected override void OnCopyRecorder()
        {
            base.OnCopyRecorder();
            txtOLDXLXHID.Value = "";
            txtOLDZXJMS.Value = "";
            txtOLDZXJMZ.Value = "";
        }

        protected override bool DataLogicValid()
        {
            if (cbxXLXHID.SelectedValue.Trim().Equals(""))
            {
                ShowMessage("型号不允许为空！");
                return false;
            }
            if (txtZXJMZ.Value < 0)
            {
                ShowMessage("主芯截面止不允许为负数！");
                return false;
            }
            if (txtZXJMS.Value < 0)
            {
                ShowMessage("主芯截面始不允许为负数！");
                return false;
            }
            if (txtZXJMS.Value > txtZXJMZ.Value)
            {
                ShowMessage("主芯截面始不允许大于主芯截面止！");
                return false;
            }
            //校验相同型号的主芯截面范围没有交集
            double dZXJMS = txtZXJMS.Value;
            double dZXJMZ = txtZXJMZ.Value;
            string sNotSelf = "";
            if (!txtOLDXLXHID.Value.Trim().Equals(""))
            {
                sNotSelf = string.Format(" and not (XLXHID='{0}' and ZXJMS={1} and ZXJMZ={2}) ",
                    txtOLDXLXHID.Value.Trim().Replace("'", "''"), txtOLDZXJMS.Value.Trim(), txtOLDZXJMZ.Value.Trim());
            }
            string sSql = string.Format(@"select top 1 XLXHID,ZXJMS,ZXJMZ from MRDYWH
                            where XLXHID='{0}' and not (ZXJMZ < {1} or ZXJMS > {2}) {3} ",
                cbxXLXHID.SelectedValue.Trim().Replace("'", "''"), dZXJMS, dZXJMZ, sNotSelf);
            TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
            TSQL sql = new TSQL(dberp);
            sql.Add(sSql);
            DataSet ds = dberp.OpenDataSet(sql);
            if (ds.Tables[0].Rows.Count > 0)
            {
                double dExistS = CMISproConvert.StrToFloat(ds.Tables[0].Rows[0]["ZXJMS"].ToString().Trim(), 0);
                double dExistZ = CMISproConvert.StrToFloat(ds.Tables[0].Rows[0]["ZXJMZ"].ToString().Trim(), 0);
                if (dExistS == dZXJMS && dExistZ == dZXJMZ)
                {
                    ShowMessage(string.Format("型号[{0}]已存在相同的主芯截面范围[{1}~{2}]，不允许重复保存！",
                        cbxXLXHID.SelectedValue.Trim(), dExistS, dExistZ));
                }
                else
                {
                    ShowMessage(string.Format("型号[{0}]已存在主芯截面范围[{1}~{2}]，相同型号的主芯截面范围不允许有交集！",
                        cbxXLXHID.SelectedValue.Trim(), dExistS, dExistZ));
                }
                return false;
            }

            return base.DataLogicValid();
        }

        protected override void SetComboxItems()
        {
            if (ControlState == TControlState.ctsBrowse)
            {
                cbxXLXHID.ClearItems();
                cbxXLXHID.Items.Add(new ListItem(cbxXLXHID.SelectedValue.Trim(), cbxXLXHID.SelectedValue.Trim()));

                cbxDYDJID.ClearItems();
                cbxDYDJID.Items.Add(new ListItem(cbxDYDJID.SelectedValue.Trim(), cbxDYDJID.SelectedValue.Trim()));
            }
            else
            {
                TComboBox.SetComboBox("DBERP", cbxXLXHID, "select XLXHB_XLXHID as ID,XLXHB_XLXHID as Name from XLXHB where isnull(XLXHB_TYBZ,'N')<>'Y' order by ID ", false);
                TComboBox.SetComboBox("DBERP", cbxDYDJID, "select distinct XLDYDJB_DYDJID as ID,XLDYDJB_DYDJID as Name from XLDYDJB where isnull(XLDYDJB_TYBZ,' ')<>'Y' and isnull(XLDYDJB_DYDJID,' ')<>' ' order by ID", true);
            }
            base.SetComboxItems();
        }

        protected override bool Master_AfterSaveAction(object sender, EventArgs e)
        {
            txtOLDXLXHID.Value = cbxXLXHID.SelectedValue.Trim().Equals("") ? " " : cbxXLXHID.SelectedValue.Trim();
            txtOLDZXJMS.Value = txtZXJMS.Value.ToString();
            txtOLDZXJMZ.Value = txtZXJMZ.Value.ToString();
            return base.Master_AfterSaveAction(sender, e);
        }

        #endregion

        #region 自定义事件

        #endregion
    }
}