N_XLXSBJ----MX/JGCZBMLInfo.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;

namespace GThinking.N_XLXSBJ
{
    public partial class JGCZBMLInfo : SingleCardBase
    {
        JGCZBML entity = new JGCZBML();

        protected void Page_Load(object sender, EventArgs e)
        {
            this.UMID = 100860020;
            this.UMName = "线缆销售报价结构尺重表";
            this.CurMaster = Master;
            this.CurEntity = entity;
            this.PageHeight = 400;
            this.PageWidth = 500;

            Master.EnableInsertBtn = false;
            Master.EnableCopyBtn = false;
            Master.EnableEditBtn = false;
            Master.EnableSaveBtn = false;
            Master.EnableCancelBtn = false;
            Master.EnableDeleteBtn = false;

            if (!IsPostBack)
            {
                cbxCZBJLDW.ClearItems();
                cbxCZBJLDW.Items.Add(new ListItem("Kg/Km", "1"));
                cbxCZBJLDW.Items.Add(new ListItem("Kg/m", "2"));

                cbxXLGGDW.ClearItems();
                cbxXLGGDW.Items.Add(new ListItem("mm", "mm"));
                cbxXLGGDW.Items.Add(new ListItem("mm2", "mm2"));
            }

            base.InitPage();
        }

        #region 模板事件继承

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

        protected override void LoadRecord()
        {
            if (!IsPostBack)
            {
                entity.Param.Add("OLD_XLJGCZBML_JGCZBID", PageParam.GetRTrimString("XLJGCZBML_JGCZBID"));
            }
            else
            {
                entity.Param.Add("OLD_XLJGCZBML_JGCZBID", txtOLD_JGCZBID.Value);
            }
            base.LoadRecord();
            txtOLD_JGCZBID.Value = txtJGCZBID.Text.Trim();
        }

        protected override void OnNewRecorder()
        {
            base.OnNewRecorder();
            cbxCZBJLDW.SelectedValue = "1";
            cbxXLGGDW.SelectedValue = "mm2";
        }

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

        }

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

            

            return true;
        }

        protected override bool Master_BeforeSaveAction(object sender, EventArgs e)
        {
            if (ControlState == TControlState.ctsInsert || ControlState == TControlState.ctsCopy)
            {
                txtJGCZBID.Text = GetNewJGCZBID();
            }
            return base.Master_BeforeSaveAction(sender, e);
        }

        protected override bool Master_AfterSaveAction(object sender, EventArgs e)
        {
            txtOLD_JGCZBID.Value = txtJGCZBID.Text.Trim();

            return base.Master_AfterSaveAction(sender, e);
        }

        protected override void AfterSave(TDatabase db, ref bool ActionIsDone)
        {
            base.AfterSave(db, ref ActionIsDone);

            
        }

        protected override void AfterDelete(TDatabase db, ref bool ActionIsDone)
        {
            base.AfterDelete(db, ref ActionIsDone);

            
        }

        protected override void SetComboxItems()
        {
            if (ControlState == TControlState.ctsBrowse)
            {
                string sSQL = string.Format("SELECT XLXSCPML_CPMLID,XLXSCPML_CPMLMC FROM XLXSCPML where 1 = 1 and XLXSCPML_CPMLID = '{0}' ", cbxCPMLID.SelectedValue.Trim());
                TComboBox.SetComboBox("DBERP", cbxCPMLID, sSQL, false);

            }
            else if (ControlState == TControlState.ctsCopy || ControlState == TControlState.ctsInsert || ControlState == TControlState.ctsEdit)
            {
                TComboBox.SetComboBox("DBERP", cbxCPMLID, "SELECT XLXSCPML_CPMLID,XLXSCPML_CPMLMC FROM XLXSCPML where isnull(XLXSCPML_TYBZ,'N')<>'Y' order by XLXSCPML_CPMLID ", false);
            }
            base.SetComboxItems();
        }


        #endregion

        #region 自定义函数

        private string GetNewJGCZBID()
        {
            TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
            TSQL sql = new TSQL(dberp);
            sql.Clear();
            sql.Add("select isnull(max(right(XLJGCZBML_JGCZBID,4)),' ')");
            sql.Add(" from XLJGCZBML");
            sql.Add(" where XLJGCZBML_JGCZBID like 'XLXSBJ%'");
            DataSet dsXH = dberp.OpenDataSet(sql);
            double fJGCZBXH = 0;
            if (dsXH.Tables[0].Rows.Count > 0)
            {
                try
                {
                    fJGCZBXH = double.Parse(dsXH.Tables[0].Rows[0][0].ToString().Trim());
                }
                catch
                {
                    fJGCZBXH = 0;
                }
            }
            fJGCZBXH = fJGCZBXH + 1;
            return "XLXSBJ" + CMISproConvert.StrToInt(fJGCZBXH.ToString()).ToString().PadLeft(4, '0');
        }

        #endregion
    }
}