295 lines
12 KiB
C#
295 lines
12 KiB
C#
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 XLCPWHInfo : SingleCardBase
|
||
{
|
||
#region Page类事件继承
|
||
XLCPWH entity = new XLCPWH();
|
||
|
||
protected void Page_Load(object sender, EventArgs e)
|
||
{
|
||
this.UMID = 101421012;
|
||
this.UMName = "线缆产品维护";
|
||
this.CurMaster = Master;
|
||
this.CurEntity = entity;
|
||
this.PageHeight = 400;
|
||
this.PageWidth = 500;
|
||
base.InitPage();
|
||
}
|
||
|
||
#endregion
|
||
|
||
#region 模板事件继承
|
||
|
||
protected override void SetControlState()
|
||
{
|
||
base.SetControlState();
|
||
//txtWLID.Enabled = false;
|
||
txtWLMC.Enabled = false;
|
||
txtGGXH.Enabled = false;
|
||
txtTH.Enabled = false;
|
||
txtCZ.Enabled = false;
|
||
txtJLDW.Enabled = false;
|
||
txtWHR.Enabled = false;
|
||
datWHSJ.Enabled = false;
|
||
|
||
//if (ControlState == TControlState.ctsBrowse)
|
||
//{
|
||
// cbxXH.Enabled = false;
|
||
// txtGG.Enabled = false;
|
||
// cbxBZ.Enabled = false;
|
||
// cbxDYDJ.Enabled = false;
|
||
//}
|
||
//else
|
||
//{
|
||
// if (!txtWLID.Text.Trim().Equals(""))
|
||
// {
|
||
// cbxXH.Enabled = false;
|
||
// txtGG.Enabled = false;
|
||
// cbxBZ.Enabled = false;
|
||
// cbxDYDJ.Enabled = false;
|
||
// }
|
||
// else
|
||
// {
|
||
// cbxXH.Enabled = true;
|
||
// txtGG.Enabled = true;
|
||
// cbxBZ.Enabled = true;
|
||
// cbxDYDJ.Enabled = true;
|
||
// }
|
||
//}
|
||
}
|
||
|
||
protected override void LoadRecord()
|
||
{
|
||
if (!IsPostBack)
|
||
{
|
||
entity.Param.Add("OLD_XLXHID", PageParam.GetRTrimString("XLXLB_XLXHID"));
|
||
entity.Param.Add("OLD_XLGGID", PageParam.GetRTrimString("XLXLB_XLGGID"));
|
||
entity.Param.Add("OLD_XLBZID", PageParam.GetRTrimString("XLXLB_XLBZID"));
|
||
entity.Param.Add("OLD_DYDJID", PageParam.GetRTrimString("XLXLB_DYDJID"));
|
||
entity.Param.Add("OLD_WLID", PageParam.GetRTrimString("XLXLB_WLID").Equals("") ? " " : PageParam.GetRTrimString("XLXLB_WLID"));
|
||
entity.Param.Add("OLD_XLYSID", PageParam.GetRTrimString("XLXLB_XLYSID").Equals("") ? " " : PageParam.GetRTrimString("XLXLB_XLYSID"));
|
||
|
||
}
|
||
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());
|
||
entity.Param.Add("OLD_WLID", txtOLDWLID.Value.Trim().Equals("") ? " " : txtOLDWLID.Value.Trim());
|
||
entity.Param.Add("OLD_XLYSID", txtOLDXLYSID.Value.Trim().Equals("") ? " " : txtOLDXLYSID.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();
|
||
txtOLDWLID.Value = txtWLID.Text.Trim();
|
||
txtOLDXLYSID.Value = cbxXLYSID.SelectedValue.Trim();
|
||
|
||
}
|
||
|
||
protected override void OnNewRecorder()
|
||
{
|
||
base.OnNewRecorder();
|
||
cbxXLYSID.SelectedValue = "";
|
||
txtWLID.Text = "";
|
||
txtWLMC.Text = "";
|
||
txtGGXH.Text = "";
|
||
txtTH.Text = "";
|
||
txtCZ.Text = "";
|
||
txtJLDW.Text = "";
|
||
txtWHR.Text = tSession.UserName;
|
||
txtWHRID.Value = tSession.UserId;
|
||
datWHSJ.Text = DateTime.Now.ToString();
|
||
}
|
||
|
||
protected override void OnCopyRecorder()
|
||
{
|
||
base.OnCopyRecorder();
|
||
cbxXLYSID.SelectedValue = "";
|
||
txtWLID.Text = "";
|
||
txtWLMC.Text = "";
|
||
txtGGXH.Text = "";
|
||
txtTH.Text = "";
|
||
txtCZ.Text = "";
|
||
txtJLDW.Text = "";
|
||
//txtWJ.Value = 0;
|
||
//txtZXWQBS.Value = 0;
|
||
txtWHR.Text = tSession.UserName;
|
||
txtWHRID.Value = tSession.UserId;
|
||
datWHSJ.Text = DateTime.Now.ToString();
|
||
}
|
||
|
||
protected override bool DataLogicValid()
|
||
{
|
||
if (!base.DataLogicValid()) return false;
|
||
string sWLID = txtWLID.Text.Trim().Equals("") ? " " : txtWLID.Text.Trim();
|
||
string sXLYSID = cbxXLYSID.SelectedValue.Trim().Equals("") ? " " : cbxXLYSID.SelectedValue.Trim();
|
||
if (string.IsNullOrEmpty(sWLID.Trim()) && !string.IsNullOrEmpty(sXLYSID.Trim()))
|
||
{
|
||
ShowMessage("“线缆颜色”、“物料编码”必须同时为空或同时非空！");
|
||
return false;
|
||
}
|
||
if (string.IsNullOrEmpty(sXLYSID.Trim()) && !string.IsNullOrEmpty(sWLID.Trim()))
|
||
{
|
||
ShowMessage("“线缆颜色”、“物料编码”必须同时为空或同时非空！");
|
||
return false;
|
||
}
|
||
if (!string.IsNullOrEmpty(sWLID.Trim()))
|
||
{
|
||
if (!CMISproDataBase.ExistsRecord("DBERP", "select 1 from WL where WL_WLID='" + sWLID + "'"))
|
||
{
|
||
ShowMessage("物料编码不存在！");
|
||
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()||txtWLID.Text.Trim()!=txtOLDWLID.Value.Trim())))
|
||
if (CMISproDataBase.ExistsRecord("DBERP", "SELECT 1 FROM XLXLB WHERE XLXLB_XLXHID='" + cbxXH.SelectedValue.Trim() + "' and XLXLB_XLGGID='" + txtGG.Text.Trim() + "' and XLXLB_XLBZID='" + cbxBZ.SelectedValue.Trim() + "' and XLXLB_DYDJID='" + cbxDYDJ.SelectedValue.Trim() + "' and ISNULL(XLXLB_WLID, ' ')='" + sWLID + "'"))
|
||
{
|
||
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);
|
||
TComboBox.SetComboBox("DBERP", cbxXLYSID, string.Format("select XLYSB_XLYSID,XLYSB_XLYSMC from XLYSB where 1=1 and XLYSB_XLYSID='{0}' order by XLYSB_XSXH,XLYSB_XLYSID", cbxXLYSID.SelectedValue.Trim()), true);
|
||
|
||
}
|
||
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);
|
||
TComboBox.SetComboBox("DBERP", cbxXLYSID, string.Format("select XLYSB_XLYSID,XLYSB_XLYSMC from XLYSB where 1=1 order by XLYSB_XSXH,XLYSB_XLYSID"), true);
|
||
}
|
||
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();
|
||
txtOLDWLID.Value = txtWLID.Text.Trim();
|
||
txtOLDXLYSID.Value = cbxXLYSID.SelectedValue.Trim();
|
||
return base.Master_AfterSaveAction(sender, e);
|
||
}
|
||
protected override void AfterSave(TDatabase db, ref bool ActionIsDone)
|
||
{
|
||
if (string.IsNullOrEmpty(txtWLID.Text.Trim()))
|
||
{
|
||
TSQL SQL = new TSQL(db);
|
||
SQL.Clear();
|
||
SQL.Add("UPDATE XLXLB SET");
|
||
SQL.Add(" XLXLB_WJ = :XLXLB_WJ,");
|
||
SQL.Add(" XLXLB_ZXWQBS = :XLXLB_ZXWQBS,");
|
||
SQL.Add(" XLXLB_WHR = :XLXLB_WHR,");
|
||
SQL.Add(" XLXLB_WHRID = :XLXLB_WHRID,");
|
||
SQL.Add(" XLXLB_WHSJ = :XLXLB_WHSJ");
|
||
SQL.Add(" WHERE XLXLB_XLXHID = :XLXLB_XLXHID AND XLXLB_XLGGID = :XLXLB_XLGGID AND XLXLB_XLBZID = :XLXLB_XLBZID AND XLXLB_DYDJID = :XLXLB_DYDJID");
|
||
SQL.ParamByName("XLXLB_WJ").Value = txtWJ.Value;
|
||
SQL.ParamByName("XLXLB_ZXWQBS").Value = txtZXWQBS.Value;
|
||
SQL.ParamByName("XLXLB_WHR").Value = tSession.UserName;
|
||
SQL.ParamByName("XLXLB_WHRID").Value = tSession.UserId;
|
||
SQL.ParamByName("XLXLB_WHSJ").Value = DateTime.Now.ToString();
|
||
SQL.ParamByName("XLXLB_XLXHID").Value = cbxXH.SelectedValue.Trim();
|
||
SQL.ParamByName("XLXLB_XLGGID").Value = txtGG.Text.Trim();
|
||
SQL.ParamByName("XLXLB_XLBZID").Value = cbxBZ.SelectedValue.Trim();
|
||
SQL.ParamByName("XLXLB_DYDJID").Value = cbxDYDJ.SelectedValue.Trim();
|
||
db.ExecSQL(SQL);
|
||
|
||
}
|
||
|
||
base.AfterSave(db, ref ActionIsDone);
|
||
|
||
}
|
||
|
||
|
||
|
||
#endregion
|
||
|
||
#region 自定义函数
|
||
|
||
protected void txtWLID_OnTextChanged(object sender, EventArgs e)
|
||
{
|
||
if (txtWLID.Text.Trim().Equals(""))
|
||
return;
|
||
|
||
TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
|
||
TSQL sql = new TSQL(dberp);
|
||
sql.Clear();
|
||
sql.Add("select WL_MC,WL_GG,WL_TZ,WL_CL,WL_JLDW from WL where WL_WLID=:pWLID ");
|
||
sql.ParamByName("pWLID").Value = txtWLID.Text.Trim();
|
||
DataSet ds = dberp.OpenDataSet(sql);
|
||
if (ds.Tables[0].Rows.Count <= 0)
|
||
return;
|
||
txtWLMC.Text = ds.Tables[0].Rows[0]["WL_MC"].ToString().Trim();
|
||
txtGGXH.Text = ds.Tables[0].Rows[0]["WL_GG"].ToString().Trim();
|
||
txtTH.Text = ds.Tables[0].Rows[0]["WL_TZ"].ToString().Trim();
|
||
txtCZ.Text = ds.Tables[0].Rows[0]["WL_CL"].ToString().Trim();
|
||
txtJLDW.Text = ds.Tables[0].Rows[0]["WL_JLDW"].ToString().Trim();
|
||
|
||
}
|
||
|
||
#endregion
|
||
}
|
||
}
|
||
|