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 } }