280 lines
12 KiB
C#
280 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_WORKFLOW;
|
|
using GThinking.N_PUBLIC;
|
|
using GThinking.N_MISPRO.Utility;
|
|
using GThinking.N_PUBLIC2;
|
|
|
|
namespace GThinking.N_XLJC
|
|
{
|
|
public partial class XLXLGGInfo : SingleCardBase
|
|
{
|
|
XLXLGG entity = new XLXLGG();
|
|
#region Page类事件继承
|
|
|
|
protected void Page_Load(object sender, EventArgs e)
|
|
{
|
|
this.UMID = 101421010;
|
|
this.UMName = "线缆规格";
|
|
this.CurMaster = Master;
|
|
this.CurEntity = entity;
|
|
this.PageHeight = 500;
|
|
this.PageWidth = 700;
|
|
this.Master.EnableInsertBtn = false;
|
|
this.Master.EnableCopyBtn = false;
|
|
this.Master.EnableDeleteBtn = false;
|
|
base.InitPage();
|
|
if (!IsPostBack)
|
|
{
|
|
InitControls();
|
|
}
|
|
}
|
|
#endregion
|
|
#region 模板事件继承
|
|
protected override void LoadRecord()
|
|
{
|
|
if (!this.IsPostBack)
|
|
{
|
|
this.CurEntity.Param.Add("XLGGB_XLGGID", PageParam.GetRTrimString("XLGGB_XLGGID").Trim());
|
|
this.CurEntity.Param.Add("XLGGB_XLGGJDGZ", PageParam.GetRTrimString("XLGGB_XLGGJDGZ").Trim());
|
|
}
|
|
else
|
|
{
|
|
entity.Param.Add("XLGGB_XLGGID", txtOLDXLGGID.Value);
|
|
entity.Param.Add("XLGGB_XLGGJDGZ", txtOLDXLGGJDGZ.Value.Trim());
|
|
}
|
|
base.LoadRecord();
|
|
this.txtOLDXLGGID.Value = txtXLGGID.Text.Trim().ToString();
|
|
this.txtOLDXLGGJDGZ.Value = hidXLGGJDGZ.Value;
|
|
}
|
|
protected override bool DataLogicValid()
|
|
{
|
|
if (txtDTJM5.Value > 0 && txtDTJM4.Value == 0)
|
|
{
|
|
ShowMessage("导体截面5大于0，导体截面4不允许为0！");
|
|
return false;
|
|
}
|
|
if (txtDTJM5.Value > 0 && txtDTJM3.Value == 0)
|
|
{
|
|
ShowMessage("导体截面5大于0，导体截面3不允许为0！");
|
|
return false;
|
|
}
|
|
if (txtDTJM5.Value > 0 && txtDTJM2.Value == 0)
|
|
{
|
|
ShowMessage("导体截面5大于0，导体截面2不允许为0！");
|
|
return false;
|
|
}
|
|
if (txtDTJM5.Value > 0 && txtDTJM1.Value == 0)
|
|
{
|
|
ShowMessage("导体截面5大于0，导体截面1不允许为0！");
|
|
return false;
|
|
}
|
|
if (txtDTJM4.Value > 0 && txtDTJM3.Value == 0)
|
|
{
|
|
ShowMessage("导体截面4大于0，导体截面3不允许为0！");
|
|
return false;
|
|
}
|
|
if (txtDTJM4.Value > 0 && txtDTJM2.Value == 0)
|
|
{
|
|
ShowMessage("导体截面4大于0，导体截面2不允许为0！");
|
|
return false;
|
|
}
|
|
if (txtDTJM4.Value > 0 && txtDTJM1.Value == 0)
|
|
{
|
|
ShowMessage("导体截面4大于0，导体截面1不允许为0！");
|
|
return false;
|
|
}
|
|
if (txtDTJM3.Value > 0 && txtDTJM2.Value == 0)
|
|
{
|
|
ShowMessage("导体截面3大于0，导体截面2不允许为0！");
|
|
return false;
|
|
}
|
|
if (txtDTJM3.Value > 0 && txtDTJM1.Value == 0)
|
|
{
|
|
ShowMessage("导体截面3大于0，导体截面1不允许为0！");
|
|
return false;
|
|
}
|
|
if (txtDTJM2.Value > 0 && txtDTJM1.Value == 0)
|
|
{
|
|
ShowMessage("导体截面2大于0，导体截面1不允许为0！");
|
|
return false;
|
|
}
|
|
return base.DataLogicValid();
|
|
}
|
|
|
|
protected override void OnCopyRecorder()
|
|
{
|
|
base.OnCopyRecorder();
|
|
txtWHR.Text = tSession.UserName.ToString().Trim();
|
|
txtWHRID.Value = tSession.UserId.ToString().Trim();
|
|
datWHSJ.Text = CMISproConvert.ConvertTime(System.DateTime.Now);
|
|
}
|
|
|
|
protected override void SetControlState()
|
|
{
|
|
base.SetControlState();
|
|
txtWHR.Enabled = false;
|
|
datWHSJ.Enabled = false;
|
|
txtXH.Enabled = false;
|
|
txtXLGGID.Enabled = false;
|
|
txtDTJMZHID.Enabled = false;
|
|
}
|
|
|
|
protected override bool Master_AfterSaveAction(object sender, EventArgs e)
|
|
{
|
|
if (!base.Master_AfterSaveAction(sender, e)) return false;
|
|
txtOLDXLGGJDGZ.Value = hidXLGGJDGZ.Value;
|
|
txtOLDXLGGID.Value = txtXLGGID.Text.Trim().ToString();
|
|
|
|
string sSFXDList="";
|
|
string sSLList="";
|
|
sSFXDList=txtSFXD1.Value+","+txtSFXD2.Value+","+txtSFXD3.Value+","+txtSFXD4.Value+","+txtSFXD5.Value;
|
|
sSLList=txtSL1.Value+","+txtSL2.Value+","+txtSL3.Value+","+txtSL4.Value+","+txtSL5.Value;
|
|
N_PUBLIC2.XLGGService.SaveXLXXJGB(txtXXJGID.Text.Trim(), sSFXDList, sSLList);//调用公共方法插入XLXXJGB
|
|
N_PUBLIC2.XLGGService.SaveXLDTJMZHB(txtDTJMZHID.Text.Trim()); //调用公共方法插入XLDTJMZHB
|
|
TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
|
|
TSQL sSQL = new TSQL(dberp);
|
|
sSQL.Add(" update XLGGB set XLGGB_XXJGID=:pXXJGID ,XLGGB_DTJMZHID=:pDTJMZHID where XLGGB_XLGGID=:pXLGGB_XLGGID and XLGGB_XLGGJDGZ=:pXLGGB_XLGGJDGZ ");
|
|
sSQL.ParamByName("pXXJGID").Value = txtXXJGID.Text.Trim();
|
|
sSQL.ParamByName("pDTJMZHID").Value = txtDTJMZHID.Text.Trim();
|
|
sSQL.ParamByName("pXLGGB_XLGGID").Value = PageParam.GetRTrimString("XLGGB_XLGGID").Trim();
|
|
sSQL.ParamByName("pXLGGB_XLGGJDGZ").Value = PageParam.GetRTrimString("XLGGB_XLGGJDGZ").Trim();
|
|
dberp.ExecSQL(sSQL);
|
|
return true;
|
|
}
|
|
|
|
protected override bool Master_BeforeSaveAction(object sender, EventArgs e)
|
|
{
|
|
if (ControlState == TControlState.ctsEdit)
|
|
{
|
|
entity.Param.Add("OLDXLGGB_XLGGID", txtOLDXLGGID.Value);
|
|
entity.Param.Add("OLDXLGGB_XLGGJDGZ", txtOLDXLGGJDGZ.Value);
|
|
}
|
|
return base.Master_BeforeSaveAction(sender, e);
|
|
}
|
|
|
|
protected override bool Master_BeforeDeleteAction(object sender, EventArgs e)
|
|
{
|
|
|
|
return base.Master_BeforeDeleteAction(sender, e);
|
|
}
|
|
|
|
protected override void SetComboxItems()
|
|
{
|
|
base.SetComboxItems();
|
|
|
|
}
|
|
|
|
#endregion
|
|
|
|
#region 自定义事件
|
|
private void InitControls()
|
|
{
|
|
cbxXLGGDW.Items.Add(new ListItem("mm2", "mm2"));
|
|
cbxXLGGDW.Items.Add(new ListItem("mm", "mm"));
|
|
cbxXLGGDW.ShowValue = false;
|
|
|
|
}
|
|
private void JmChange()
|
|
{
|
|
if (txtDTJM1.Value > 0)
|
|
{
|
|
txtDTJMZHID.Text = txtDTJM1.Value.ToString();
|
|
}
|
|
if (txtDTJM1.Value > 0 && txtDTJM2.Value > 0)
|
|
{
|
|
txtDTJMZHID.Text = txtDTJM1.Value + "/" + txtDTJM2.Value;
|
|
}
|
|
if (txtDTJM1.Value > 0 && txtDTJM2.Value > 0 && txtDTJM3.Value > 0)
|
|
{
|
|
txtDTJMZHID.Text = txtDTJM1.Value + "/" + txtDTJM2.Value + "/" + txtDTJM3.Value;
|
|
}
|
|
if (txtDTJM1.Value > 0 && txtDTJM2.Value > 0 && txtDTJM3.Value > 0 && txtDTJM4.Value > 0)
|
|
{
|
|
txtDTJMZHID.Text = txtDTJM1.Value + "/" + txtDTJM2.Value + "/" + txtDTJM3.Value + "/" + txtDTJM4.Value;
|
|
}
|
|
if (txtDTJM1.Value > 0 && txtDTJM2.Value > 0 && txtDTJM3.Value > 0 && txtDTJM4.Value > 0 && txtDTJM5.Value > 0)
|
|
{
|
|
txtDTJMZHID.Text = txtDTJM1.Value + "/" + txtDTJM2.Value + "/" + txtDTJM3.Value + "/" + txtDTJM4.Value + "/" + txtDTJM5.Value;
|
|
}
|
|
}
|
|
#endregion
|
|
|
|
#region 控件事件
|
|
protected void txtXXJGID_TextChanged(object sender, EventArgs e)
|
|
{
|
|
TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
|
|
TSQL SQL = new TSQL(dberp);
|
|
SQL.Clear();
|
|
SQL.Add("select XLXXJGB_SFXD1,XLXXJGB_SFXD2,XLXXJGB_SFXD3,XLXXJGB_SFXD4,XLXXJGB_SFXD5,XLXXJGB_SL1,XLXXJGB_SL2,XLXXJGB_SL3,XLXXJGB_SL4,XLXXJGB_SL5 from XLXXJGB ");
|
|
SQL.Add(" where XLXXJGB_XXJGID = :pXXJGID ");
|
|
SQL.ParamByName("pXXJGID").Value = txtXXJGID.Text.Trim();
|
|
DataSet ds = dberp.OpenDataSet(SQL);
|
|
if (ds.Tables[0].Rows.Count >0)
|
|
{
|
|
txtSFXD1.Value = CMISproConvert.StrToFloat(ds.Tables[0].Rows[0]["XLXXJGB_SFXD1"].ToString().Trim());
|
|
txtSFXD2.Value = CMISproConvert.StrToFloat(ds.Tables[0].Rows[0]["XLXXJGB_SFXD2"].ToString().Trim());
|
|
txtSFXD3.Value = CMISproConvert.StrToFloat(ds.Tables[0].Rows[0]["XLXXJGB_SFXD3"].ToString().Trim());
|
|
txtSFXD4.Value = CMISproConvert.StrToFloat(ds.Tables[0].Rows[0]["XLXXJGB_SFXD4"].ToString().Trim());
|
|
txtSFXD5.Value = CMISproConvert.StrToFloat(ds.Tables[0].Rows[0]["XLXXJGB_SFXD5"].ToString().Trim());
|
|
txtSL1.Value = CMISproConvert.StrToFloat(ds.Tables[0].Rows[0]["XLXXJGB_SL1"].ToString().Trim());
|
|
txtSL2.Value = CMISproConvert.StrToFloat(ds.Tables[0].Rows[0]["XLXXJGB_SL2"].ToString().Trim());
|
|
txtSL3.Value = CMISproConvert.StrToFloat(ds.Tables[0].Rows[0]["XLXXJGB_SL3"].ToString().Trim());
|
|
txtSL4.Value = CMISproConvert.StrToFloat(ds.Tables[0].Rows[0]["XLXXJGB_SL4"].ToString().Trim());
|
|
txtSL5.Value = CMISproConvert.StrToFloat(ds.Tables[0].Rows[0]["XLXXJGB_SL5"].ToString().Trim());
|
|
}
|
|
}
|
|
|
|
//protected void txtDTJMZHID_TextChanged(object sender, EventArgs e)
|
|
//{
|
|
// TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
|
|
// TSQL SQL = new TSQL(dberp);
|
|
// SQL.Clear();
|
|
// SQL.Add("select XLDTJMZHB_DTJM1,XLDTJMZHB_DTJM2,XLDTJMZHB_DTJM3,XLDTJMZHB_DTJM4,XLDTJMZHB_DTJM5 FROM XLDTJMZHB ");
|
|
// SQL.Add(" where XLDTJMZHB_DTJMZHID = :pDTJMZHID ");
|
|
// SQL.ParamByName("pDTJMZHID").Value = txtDTJMZHID.Text.Trim();
|
|
// DataSet ds = dberp.OpenDataSet(SQL);
|
|
// if (ds.Tables[0].Rows.Count >0)
|
|
// {
|
|
// txtDTJM1.Value = CMISproConvert.StrToFloat(ds.Tables[0].Rows[0]["XLDTJMZHB_DTJM1"].ToString().Trim());
|
|
// txtDTJM2.Value = CMISproConvert.StrToFloat(ds.Tables[0].Rows[0]["XLDTJMZHB_DTJM2"].ToString().Trim());
|
|
// txtDTJM3.Value = CMISproConvert.StrToFloat(ds.Tables[0].Rows[0]["XLDTJMZHB_DTJM3"].ToString().Trim());
|
|
// txtDTJM4.Value = CMISproConvert.StrToFloat(ds.Tables[0].Rows[0]["XLDTJMZHB_DTJM4"].ToString().Trim());
|
|
// txtDTJM5.Value = CMISproConvert.StrToFloat(ds.Tables[0].Rows[0]["XLDTJMZHB_DTJM5"].ToString().Trim());
|
|
// }
|
|
//}
|
|
protected void txtDTJM1_TextChanged(object sender, EventArgs e)
|
|
{
|
|
JmChange();
|
|
}
|
|
protected void txtDTJM2_TextChanged(object sender, EventArgs e)
|
|
{
|
|
JmChange();
|
|
}
|
|
protected void txtDTJM3_TextChanged(object sender, EventArgs e)
|
|
{
|
|
JmChange();
|
|
}
|
|
protected void txtDTJM4_TextChanged(object sender, EventArgs e)
|
|
{
|
|
JmChange();
|
|
}
|
|
protected void txtDTJM5_TextChanged(object sender, EventArgs e)
|
|
{
|
|
JmChange();
|
|
}
|
|
#endregion
|
|
}
|
|
|
|
} |