N_XLJC--MX/BJCPWHInfo.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_MISPRO;
using GThinking.N_MISPRO.Data;
using GThinking.N_MODEL.Page;
using GThinking.N_MISPRO.Utility;
using GThinking.N_PUBLIC;
using GThinking.N_MODEL.Dialog;
using GThinking.N_WORKFLOW;
using System.Collections.Generic;
using System.ComponentModel;
using System.Text;

namespace GThinking.N_XLJC
{
    public partial class BJCPWHInfo : SingleCardBase
    {
        #region Page类事件继承
        BJCPWH entity = new BJCPWH();

        protected void Page_Load(object sender, EventArgs e)
        {
            this.UMID = 101421013;
            this.UMName = "报价产品维护";
            this.CurMaster = Master;
            this.CurEntity = entity;
            this.PageHeight = 400;
            this.PageWidth = 500;
            base.InitPage();
        }

        #endregion

        #region 模板事件继承

        protected override void SetControlState()
        {
            base.SetControlState();
            
           
            txtWHR.Enabled = false;
            datWHSJ.Enabled = false;

           
        }

        protected override void LoadRecord()
        {
            if (!IsPostBack)
            {
                entity.Param.Add("OLD_XLXHID", PageParam.GetRTrimString("BJCPXX_XLXHID"));
                entity.Param.Add("OLD_XLGGID", PageParam.GetRTrimString("BJCPXX_XLGGID"));
                entity.Param.Add("OLD_XLBZID", PageParam.GetRTrimString("BJCPXX_XLBZID"));
                entity.Param.Add("OLD_DYDJID", PageParam.GetRTrimString("BJCPXX_DYDJID"));
               

            }
            else
            {
                entity.Param.Add("OLD_XLXHID", txtOLDXH.Value.Trim());
                entity.Param.Add("OLD_XLGGID", txtOLDGG.Value.Trim());
                entity.Param.Add("OLD_XLBZID", txtOLDBZ.Value.Trim());
                entity.Param.Add("OLD_DYDJID", txtOLDDYDJ.Value.Trim());
               
            }
            base.LoadRecord();
            txtOLDXH.Value = cbxXH.SelectedValue.Trim();
            txtOLDGG.Value = txtGG.Text.ToString().Trim();
            txtOLDBZ.Value = cbxBZ.SelectedValue.Trim();
            txtOLDDYDJ.Value = cbxDYDJ.SelectedValue.Trim();
           

        }

        protected override void OnNewRecorder()
        {
            base.OnNewRecorder();
           
            txtWHR.Text = tSession.UserName;
            txtWHRID.Value = tSession.UserId;
            datWHSJ.Text = DateTime.Now.ToString();
        }

        protected override void OnCopyRecorder()
        {
            base.OnCopyRecorder();
          
            txtWHR.Text = tSession.UserName;
            txtWHRID.Value = tSession.UserId;
            datWHSJ.Text = DateTime.Now.ToString();
        }

        protected override bool DataLogicValid()
        {
            if (!base.DataLogicValid()) return false;
           

            if ((ControlState == TControlState.ctsInsert) || (ControlState == TControlState.ctsCopy) || ((ControlState == TControlState.ctsEdit)
                && (cbxXH.SelectedValue.Trim() != txtOLDXH.Value.Trim() || txtGG.Text.Trim() != txtOLDGG.Value.Trim() || cbxBZ.SelectedValue.Trim() != txtOLDBZ.Value.Trim() || cbxDYDJ.SelectedValue.Trim() != txtOLDDYDJ.Value.Trim() )))
                if (CMISproDataBase.ExistsRecord("DBERP", "SELECT 1 FROM BJCPXX WHERE BJCPXX_XLXHID='" + cbxXH.SelectedValue.Trim() + "'  and  BJCPXX_XLGGID='" + txtGG.Text.Trim() + "' and BJCPXX_XLBZID='" + cbxBZ.SelectedValue.Trim() + "'  and  BJCPXX_DYDJID='" + cbxDYDJ.SelectedValue.Trim() + "'"))
                {
                    ShowMessage("已存在相同型号、规格、标准、电压等级的记录，不允许重复新增！");
                    return false;
                }

            return true;
        }

        protected override void SetComboxItems()
        {
            base.SetComboxItems();
            if (ControlState == TControlState.ctsBrowse)
            {
                TComboBox.SetComboBox("DBERP", cbxBZ, "select XLBZ_XLBZID,XLBZ_XLBZLXMC from XLBZ where 1=1 and XLBZ_XLBZID = '" + cbxBZ.SelectedValue.Trim() + "'", false);
                string sSQL = "select XLDYDJB_DYDJID,XLDYDJB_DYDJID as DYDJID from XLDYDJB where 1 = 1 and XLDYDJB_DYDJID = '" + cbxDYDJ.SelectedValue.Trim() + "'";
                TComboBox.SetComboBox("DBERP", cbxDYDJ, sSQL, false);
                TComboBox.SetComboBox("DBERP", cbxXH, "select XLXHB_XLXHID as ID,XLXHB_XLXHID as Name from XLXHB where 1=1 and  XLXHB_XLXHID = '" + cbxXH.SelectedValue.Trim() + "'", false);

            }
            else
            {
                TComboBox.SetComboBox("DBERP", cbxBZ, "select XLBZ_XLBZID,XLBZ_XLBZLXMC from XLBZ where 1=1 order by XLBZ_PX,XLBZ_XLBZID", false);
                string sSQL = "select XLDYDJB_DYDJID,XLDYDJB_DYDJID as DYDJID from XLDYDJB where 1 = 1 and isnull(XLDYDJB_TYBZ,'N')<>'Y' order by XLDYDJB_XH,XLDYDJB_DYDJID ";
                TComboBox.SetComboBox("DBERP", cbxDYDJ, sSQL, false);
                TComboBox.SetComboBox("DBERP", cbxXH, "select XLXHB_XLXHID as ID,XLXHB_XLXHID as Name from XLXHB where 1=1 and  isnull(XLXHB_TYBZ,'N')<>'Y' order by ID ", false);
            }
            cbxDYDJ.ShowValue = false;
            cbxXH.ShowValue = false;
            cbxBZ.ShowValue = true;
        }

        protected override bool Master_BeforeSaveAction(object sender, EventArgs e)
        {
            if (!base.Master_BeforeSaveAction(sender, e)) return false;
            if (txtGG.Text.Contains("x"))
                txtGG.Text = txtGG.Text.Replace("x", "×");
            if (txtGG.Text.Contains("X"))
                txtGG.Text = txtGG.Text.Replace("X", "×");
            if (txtGG.Text.Contains("*"))
                txtGG.Text = txtGG.Text.Replace("*", "×");

            txtWHR.Text = tSession.UserName;
            txtWHRID.Value = tSession.UserId;
            datWHSJ.Text = System.DateTime.Now.ToString();

            return true;
        }

        protected override bool Master_AfterSaveAction(object sender, EventArgs e)
        {
            txtOLDXH.Value = cbxXH.SelectedValue.Trim();
            txtOLDGG.Value = txtGG.Text.Trim();
            txtOLDBZ.Value = cbxBZ.SelectedValue.Trim();
            txtOLDDYDJ.Value = cbxDYDJ.SelectedValue.Trim();
           
            return base.Master_AfterSaveAction(sender, e);
        }
        protected override void AfterSave(TDatabase db, ref bool ActionIsDone)
        {
            

            base.AfterSave(db, ref ActionIsDone);

        }



        #endregion

       
    }
}