789 lines
32 KiB
C#
789 lines
32 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 System.Text.RegularExpressions;
|
|
using GThinking.N_MISPRO.TableCache;
|
|
|
|
namespace GThinking.N_XLJC
|
|
{
|
|
public partial class XLJGCZBInfo : SingleCardBase
|
|
{
|
|
XLJGCZB entity = new XLJGCZB();
|
|
|
|
protected void Page_Load(object sender, EventArgs e)
|
|
{
|
|
this.UMID = 101421008;
|
|
this.UMName = "线缆结构尺重表";
|
|
base.CurMaster = Master;
|
|
this.CurEntity = entity;
|
|
this.PageHeight = 500;
|
|
this.PageWidth = 700;
|
|
|
|
if (!IsPostBack)
|
|
{
|
|
InitControls();
|
|
}
|
|
|
|
base.InitPage();
|
|
}
|
|
|
|
#region 模板继承事件
|
|
|
|
protected override void LoadRecord()
|
|
{
|
|
if (!this.IsPostBack)
|
|
{
|
|
entity.Param.Add("XLJGCZBML_JGCZBID", PageParam.GetRTrimString("XLJGCZBML_JGCZBID").Trim());
|
|
}
|
|
else
|
|
{
|
|
entity.Param.Add("XLJGCZBML_JGCZBID", txtOLDJGCZBID.Value.Trim());
|
|
}
|
|
|
|
base.LoadRecord();
|
|
txtOLDJGCZBID.Value = txtJGCZBID.Text.Trim();
|
|
cbxCZBLX.SelectedValue = cbxCZBLX.SelectedValue.Trim().Equals("") ? "Z" : cbxCZBLX.SelectedValue.Trim();
|
|
}
|
|
|
|
protected override void OnNewRecorder()
|
|
{
|
|
base.OnNewRecorder();
|
|
|
|
txtWHR.Text = tSession.UserName;
|
|
txtWHRID.Value = tSession.UserId;
|
|
datWHSJ.Text = CMISproConvert.ConvertTime(System.DateTime.Now);
|
|
if (PageParam.ContainsKey("FromCLYL"))
|
|
{
|
|
cbxCZBLX.SelectedValue = "A";
|
|
}
|
|
else
|
|
{
|
|
cbxCZBLX.SelectedValue = "Z";
|
|
}
|
|
cbxGYFLBM.SelectedValue = "";
|
|
|
|
cbxCZBJLDW.SelectedValue = "1";
|
|
cbxXLGGDW.SelectedValue = "mm2";
|
|
cbxCPMLID.SelectedValue = "ZZ";
|
|
txtFZR.Text = tSession.UserName;
|
|
|
|
txtJGCZBBBID.Text = "1.0";
|
|
|
|
cbxCZBLX_OnSelectedIndexChanged(null, null);
|
|
}
|
|
|
|
protected override void OnCopyRecorder()
|
|
{
|
|
base.OnCopyRecorder();
|
|
|
|
txtWHR.Text = tSession.UserName;
|
|
txtWHRID.Value = tSession.UserId;
|
|
datWHSJ.Text = CMISproConvert.ConvertTime(System.DateTime.Now);
|
|
txtOLDJGCZBID.Value = "";
|
|
txtJGCZBBBID.Text = "1.0";
|
|
txtFZR.Text = tSession.UserName;
|
|
|
|
|
|
cbxCZBLX_OnSelectedIndexChanged(null, null);
|
|
}
|
|
|
|
protected override void SetControlState()
|
|
{
|
|
base.SetControlState();
|
|
txtWHR.Enabled = false;
|
|
datWHSJ.Enabled = false;
|
|
txtJGCZBID.Enabled = false;
|
|
|
|
cbxGGHLX.Enabled = false;
|
|
cbxXLXHBN.Enabled = false;
|
|
cbxXLBZBN.Enabled = false;
|
|
cbxDYDJBN.Enabled = false;
|
|
cbxGYFLBM.Enabled = false;
|
|
cbxGYFLBBID.Enabled = false;
|
|
txtEXCEL.Enabled = false;
|
|
txtSHEET.Enabled = false;
|
|
|
|
if (ControlState == TControlState.ctsEdit || ControlState == TControlState.ctsInsert || ControlState== TControlState.ctsCopy)
|
|
{
|
|
cbxCZBLX_OnSelectedIndexChanged(null, null);
|
|
}
|
|
|
|
btnHGFW.Enabled = ControlState == TControlState.ctsBrowse;
|
|
btnXHML.Enabled = ControlState == TControlState.ctsBrowse;
|
|
btnCZBLM.Enabled = ControlState == TControlState.ctsBrowse;
|
|
}
|
|
|
|
protected override bool DataLogicValid()
|
|
{
|
|
if(cbxCPMLID.SelectedValue.Trim().Equals(""))
|
|
{
|
|
ShowMessage("产品目录不允许为空！");
|
|
return false;
|
|
}
|
|
|
|
if (cbxCZBLX.SelectedValue.Equals(""))
|
|
{
|
|
ShowMessage("尺重表类型不允许为空！");
|
|
return false;
|
|
}
|
|
|
|
if (txtJGCZBBBID.Text.Trim().Equals(""))
|
|
{
|
|
ShowMessage("尺重表版本不允许为空！");
|
|
return false;
|
|
}
|
|
|
|
string sJGCZBID = txtJGCZBID.Text.Trim();
|
|
string sSQL = string.Format("select 1 from XLJGCZBML where XLJGCZBML_JGCZBID='{0}' and XLJGCZBML_JGCZBID <> '{1}'", sJGCZBID, txtOLDJGCZBID.Value.ToString().Trim());
|
|
if (CMISproDataBase.ExistsRecord("DBERP", sSQL))
|
|
{
|
|
ShowMessage("表号已经存在，不允许保存！");
|
|
return false;
|
|
}
|
|
|
|
if (!cbxGYFLBM.SelectedValue.Trim().Equals("") && cbxGYFLBBID.SelectedValue.Trim().Equals(""))
|
|
{
|
|
ShowMessage("工艺分类不为空时，工艺分类版本不允许为空！");
|
|
return false;
|
|
}
|
|
|
|
//不同类型对应的必填
|
|
if (cbxCZBLX.SelectedValue.Equals("Z"))
|
|
{
|
|
if (txtEXCEL.Text.Trim().Equals(""))
|
|
{
|
|
ShowMessage("尺重表类型为自主策划时，Excel文件名不允许为空！");
|
|
return false;
|
|
}
|
|
|
|
if (txtSHEET.Text.Trim().Equals(""))
|
|
{
|
|
ShowMessage("尺重表类型为自主策划时，sheet名不允许为空！");
|
|
return false;
|
|
}
|
|
|
|
if (ControlState == TControlState.ctsEdit)
|
|
{
|
|
sSQL = string.Format("select 1 from XLJGCZBML where isNull(XLJGCZBML_SHEET,' ')='{0}' and isNull(XLJGCZBML_EXCEL,' ')='{1}' and XLJGCZBML_JGCZBID <> '{2}'", txtSHEET.Text.Trim(), txtEXCEL.Text.Trim(), txtOLDJGCZBID.Value.ToString().Trim());
|
|
if (CMISproDataBase.ExistsRecord("DBERP", sSQL))
|
|
{
|
|
ShowMessage("已存在Excel文件名和sheet名相同的记录！");
|
|
return false;
|
|
}
|
|
}
|
|
else if (ControlState == TControlState.ctsInsert)
|
|
{
|
|
sSQL = string.Format("select 1 from XLJGCZBML where isNull(XLJGCZBML_SHEET,' ')='{0}' and isNull(XLJGCZBML_EXCEL,' ')='{1}' ", txtSHEET.Text.Trim(), txtEXCEL.Text.Trim());
|
|
if (CMISproDataBase.ExistsRecord("DBERP", sSQL))
|
|
{
|
|
ShowMessage("已存在Excel文件名和sheet名相同的记录！");
|
|
return false;
|
|
}
|
|
|
|
}
|
|
}
|
|
|
|
if (cbxCZBLX.SelectedValue.Trim().Equals("C"))
|
|
{
|
|
if (cbxGYFLBM.SelectedValue.Trim().Equals(""))
|
|
{
|
|
ShowMessage("尺重表类型为计算生成结构重量表时，工艺分类不允许为空！");
|
|
return false;
|
|
}
|
|
}
|
|
|
|
if (cbxCZBLX.SelectedValue.Equals("D"))
|
|
{
|
|
if (cbxGYFLBM.SelectedValue.Trim().Equals(""))
|
|
{
|
|
ShowMessage("尺重表类型为结构工艺(BOM&GYLX导入)时，工艺分类不允许为空！");
|
|
return false;
|
|
}
|
|
|
|
if (cbxGYFLBBID.SelectedValue.Trim().Equals(""))
|
|
{
|
|
ShowMessage("尺重表类型为结构工艺(BOM&GYLX导入)时，工艺分类版本不允许为空！");
|
|
return false;
|
|
}
|
|
|
|
}
|
|
return base.DataLogicValid();
|
|
}
|
|
|
|
protected override bool Master_BeforeDeleteAction(object sender, EventArgs e)
|
|
{
|
|
string sJGCZBID = txtJGCZBID.Text.Trim();
|
|
string sJGCBZLX = cbxCZBLX.SelectedValue.Trim();
|
|
string sSQL = "";
|
|
|
|
if (sJGCBZLX.Equals("A") || sJGCBZLX.Equals("B"))
|
|
{
|
|
sSQL = string.Format("select top 1 XLXSCLQD_JGCZBID from XLXSCLQD where XLXSCLQD_JGCZBID='{0}'", sJGCZBID);
|
|
if (CMISproDataBase.ExistsRecord("DBERP", sSQL))
|
|
{
|
|
ShowMessage("当前尺重表存在材料清单记录，不允许删除！");
|
|
return false;
|
|
}
|
|
}
|
|
else
|
|
{
|
|
sSQL = string.Format("select TOP 1 XLXHJGCZBML_JGCZBID from XLXHJGCZBML where XLXHJGCZBML_JGCZBID='{0}' and XLXHJGCZBML_JGCZBXH< 0 ", sJGCZBID);
|
|
if (CMISproDataBase.ExistsRecord("DBERP", sSQL))
|
|
{
|
|
ShowMessage("已经存在涵盖范围，不允许删除！");
|
|
return false;
|
|
}
|
|
|
|
sSQL = string.Format("select top 1 XLJGCZBNR_JGCZBID from XLJGCZBNR where XLJGCZBNR_JGCZBID='{0}'", sJGCZBID);
|
|
if (CMISproDataBase.ExistsRecord("DBERP", sSQL))
|
|
{
|
|
ShowMessage("当前尺重表已存在导入内容，不允许删除！");
|
|
return false;
|
|
}
|
|
|
|
sSQL = string.Format("select top 1 XLXHJGCZBNR_JGCZBID from XLXHJGCZBNR where XLXHJGCZBNR_JGCZBID='{0}'", sJGCZBID);
|
|
if (CMISproDataBase.ExistsRecord("DBERP", sSQL))
|
|
{
|
|
ShowMessage("当前尺重表已生成型号内容，不允许删除！");
|
|
return false;
|
|
}
|
|
|
|
sSQL = string.Format("select top 1 XLXHJGCZBML_JGCZBID from XLXHJGCZBML where XLXHJGCZBML_JGCZBID='{0}' and XLXHJGCZBML_JGCZBXH>0 ", sJGCZBID);
|
|
if (CMISproDataBase.ExistsRecord("DBERP", sSQL))
|
|
{
|
|
ShowMessage("当前尺重表已处理过结构工艺，不允许删除！");
|
|
return false;
|
|
}
|
|
}
|
|
return base.Master_BeforeDeleteAction(sender, e);
|
|
}
|
|
|
|
protected override void BeforeDelete(TDatabase db, ref bool ActionIsDone)
|
|
{
|
|
|
|
base.BeforeDelete(db, ref ActionIsDone);
|
|
}
|
|
|
|
protected override void AfterDelete(TDatabase db, ref bool ActionIsDone)
|
|
{
|
|
string sJGCZBID = txtJGCZBID.Text.Trim();
|
|
string sJGCBZLX = cbxCZBLX.SelectedValue.Trim();
|
|
string sSQL1 = string.Format("delete from XLXHJGCZBML where XLXHJGCZBML_JGCZBID='{0}'", sJGCZBID);
|
|
string sSQL2 = string.Format("delete from XLJGCZBRZ where XLJGCZBRZ_JGCZBID='{0}'", sJGCZBID);
|
|
string sSQL3 = string.Format("delete from XLJGCZBBB where XLJGCZBBB_JGCZBID='{0}'", sJGCZBID);
|
|
db.ExecSQL(sSQL1);
|
|
db.ExecSQL(sSQL2);
|
|
db.ExecSQL(sSQL3);
|
|
if (sJGCBZLX.Equals("A") || sJGCBZLX.Equals("B"))
|
|
{
|
|
string sSQL4 = string.Format("delete from XLJGCZBNR where XLJGCZBNR_JGCZBID='{0}'", sJGCZBID);
|
|
string sSQL5 = string.Format("delete from XLJGCZBLM where XLJGCZBLM_JGCZBID='{0}'", sJGCZBID);
|
|
string sSQL6 = string.Format("delete from XLXHJGCZBNR where XLXHJGCZBNR_JGCZBID='{0}'", sJGCZBID);
|
|
string sSQL7 = string.Format("delete from XLXHJGCZBML where XLXHJGCZBML_JGCZBID='{0}'", sJGCZBID);
|
|
string sSQL8 = string.Format("delete from XLXSCLQDWL where XLXSCLQDWL_JGCZBID='{0}'", sJGCZBID);
|
|
db.ExecSQL(sSQL4);
|
|
db.ExecSQL(sSQL5);
|
|
db.ExecSQL(sSQL6);
|
|
db.ExecSQL(sSQL7);
|
|
db.ExecSQL(sSQL8);
|
|
}
|
|
base.AfterDelete(db, ref ActionIsDone);
|
|
}
|
|
|
|
protected override bool Master_BeforeSaveAction(object sender, EventArgs e)
|
|
{
|
|
if ((ControlState == TControlState.ctsInsert) || (ControlState == TControlState.ctsEdit))
|
|
{
|
|
txtWHR.Text = tSession.UserName;
|
|
txtWHRID.Value = tSession.UserId;
|
|
datWHSJ.Text = CMISproConvert.ConvertTime(System.DateTime.Now);
|
|
}
|
|
|
|
if (ControlState == TControlState.ctsInsert || ControlState == TControlState.ctsCopy)
|
|
{
|
|
string sNewBH = GetNewID();
|
|
txtJGCZBID.Text = sNewBH;
|
|
}
|
|
return base.Master_BeforeSaveAction(sender, e);
|
|
}
|
|
|
|
protected override bool Master_AfterSaveAction(object sender, EventArgs e)
|
|
{
|
|
txtOLDJGCZBID.Value = txtJGCZBID.Text.Trim();
|
|
cbxCZBLX.SelectedValue = cbxCZBLX.SelectedValue.Trim().Equals("") ? "Z" : cbxCZBLX.SelectedValue.Trim();
|
|
//XLJGCZBRZ
|
|
string sJGCZBID = txtJGCZBID.Text.Trim();
|
|
DateTime dt = DateTime.Now;
|
|
TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
|
|
TSQL SQL = new TSQL(dberp);
|
|
SQL.Clear();
|
|
if (cbxCZBLX.SelectedValue.Trim().Equals("C") || cbxCZBLX.SelectedValue.Trim().Equals("G"))
|
|
{
|
|
SQL.Clear();
|
|
SQL.Add("select top 1 XLJGCZBRZ_JGCZBID from XLJGCZBRZ where XLJGCZBRZ_JGCZBID=:pJGCZBID ");
|
|
SQL.ParamByName("pJGCZBID").Value = sJGCZBID;
|
|
DataSet ds = dberp.OpenDataSet(SQL);
|
|
if (ds.Tables[0].Rows.Count > 0)
|
|
{
|
|
SQL.Clear();
|
|
SQL.Add("update XLJGCZBML ");
|
|
SQL.Add("set XLJGCZBML_DRSJ=(select max(XLJGCZBRZ_DRSJ) from XLJGCZBRZ where XLJGCZBRZ_JGCZBID=XLJGCZBML_JGCZBID) ");
|
|
SQL.Add("where XLJGCZBML_JGCZBID=:pJGCZBID and XLJGCZBML_DRSJ is null ");
|
|
SQL.ParamByName("pJGCZBID").Value = sJGCZBID;
|
|
dberp.ExecSQL(SQL);
|
|
}
|
|
else
|
|
{
|
|
SQL.Clear();
|
|
SQL.Add(" insert into XLJGCZBRZ ");
|
|
SQL.Add(" (XLJGCZBRZ_JGCZBID,XLJGCZBRZ_DRSJ,XLJGCZBRZ_DRRRYID,XLJGCZBRZ_DRRGH, ");
|
|
SQL.Add(" XLJGCZBRZ_DRRRYMC,XLJGCZBRZ_DRJGCZB,XLJGCZBRZ_ZBDRSJ) ");
|
|
SQL.Add(" values ");
|
|
SQL.Add(" (:pJGCZBID,:pDRSJ,:pDRRRYID,:pDRRGH, ");
|
|
SQL.Add(" :pDRRRYMC,:pDRJGCZB,:pZBDRSJ) ");
|
|
SQL.ParamByName("pJGCZBID").Value = sJGCZBID;
|
|
SQL.ParamByName("pDRSJ").Value = dt;
|
|
SQL.ParamByName("pDRRRYID").Value = TRYXX.GetRYByGH(tSession.UserId).RYID;
|
|
SQL.ParamByName("pDRRGH").Value = tSession.UserId;
|
|
SQL.ParamByName("pDRRRYMC").Value = tSession.UserName;
|
|
SQL.ParamByName("pDRJGCZB").Value = "N";
|
|
SQL.ParamByName("pZBDRSJ").Value = dt;
|
|
dberp.ExecSQL(SQL);
|
|
|
|
SQL.Clear();
|
|
SQL.Add("update XLJGCZBML set XLJGCZBML_DRSJ=:pDRSJ ");
|
|
SQL.Add(" where XLJGCZBML_JGCZBID=:pJGCZBID ");
|
|
SQL.ParamByName("pJGCZBID").Value = sJGCZBID;
|
|
SQL.ParamByName("pDRSJ").Value = dt;
|
|
dberp.ExecSQL(SQL);
|
|
}
|
|
SQL.Clear();
|
|
SQL.Add("select 1 from XLJGCZBBB where XLJGCZBBB_JGCZBBBID=:pBBID and XLJGCZBBB_JGCZBID=:pID ");
|
|
SQL.ParamByName("pID").Value = sJGCZBID;
|
|
SQL.ParamByName("pBBID").Value = txtJGCZBBBID.Text.Trim();
|
|
ds = dberp.OpenDataSet(SQL);
|
|
if (ds.Tables[0].Rows.Count <= 0)
|
|
{
|
|
SQL.Clear();
|
|
SQL.Add("insert into XLJGCZBBB ");
|
|
SQL.Add("(XLJGCZBBB_JGCZBID,XLJGCZBBB_JGCZBBBID,XLJGCZBBB_GYFLBBID,XLJGCZBBB_YXRQS, ");
|
|
SQL.Add(" XLJGCZBBB_WHR,XLJGCZBBB_WHRID,XLJGCZBBB_WHSJ)");
|
|
SQL.Add("values(:pJGCZBID,:pJGCZBBBID,:pGYFLBBID,:pYXRQS,");
|
|
SQL.Add(" :pWHR,:pWHRID,:pWHSJ)");
|
|
SQL.ParamByName("pGYFLBBID").Value = cbxGYFLBBID.SelectedValue.Trim();
|
|
SQL.ParamByName("pYXRQS").Value = dt;
|
|
SQL.ParamByName("pJGCZBID").Value = sJGCZBID;
|
|
SQL.ParamByName("pJGCZBBBID").Value = txtJGCZBBBID.Text.Trim();
|
|
SQL.ParamByName("pWHRID").Value = tSession.UserId;
|
|
SQL.ParamByName("pWHR").Value = tSession.UserName;
|
|
SQL.ParamByName("pWHSJ").Value = dt;
|
|
dberp.ExecSQL(SQL);
|
|
}
|
|
|
|
}
|
|
|
|
|
|
return base.Master_AfterSaveAction(sender, e);
|
|
}
|
|
|
|
protected override void SetComboxItems()
|
|
{
|
|
cbxCZBJLDW.ClearItems();
|
|
cbxCZBJLDW.Items.Add(new ListItem("Kg/Km", "1"));
|
|
cbxCZBJLDW.Items.Add(new ListItem("Kg/m", "2"));
|
|
cbxCZBJLDW.Items.Add(new ListItem("Kg/T", "8"));
|
|
|
|
|
|
cbxXLGGDW.ClearItems();
|
|
cbxXLGGDW.Items.Add(new ListItem("mm2", "mm2"));
|
|
cbxXLGGDW.Items.Add(new ListItem("mm", "mm"));
|
|
cbxXLGGDW.ShowValue = false;
|
|
|
|
cbxCZBLX.ClearItems();
|
|
cbxCZBLX.Items.Add(new ListItem("自主策划", "Z"));
|
|
cbxCZBLX.Items.Add(new ListItem("材料用量(直接维护)", "A"));
|
|
cbxCZBLX.Items.Add(new ListItem("材料用量(Excel导入)", "B"));
|
|
cbxCZBLX.Items.Add(new ListItem("结构工艺(成套计算)", "C"));
|
|
cbxCZBLX.Items.Add(new ListItem("结构工艺(临时编制)", "G"));
|
|
cbxCZBLX.Items.Add(new ListItem("结构工艺(BOM&GYLX导入)", "D"));
|
|
|
|
cbxGGHLX.ClearItems();
|
|
cbxGGHLX.Items.Add(new ListItem("单行", "1"));
|
|
cbxGGHLX.Items.Add(new ListItem("双行", "2"));
|
|
|
|
cbxXLBZBN.ClearItems();
|
|
cbxXLBZBN.Items.Add(new ListItem("表外", "N"));
|
|
cbxXLBZBN.Items.Add(new ListItem("表内", "Y"));
|
|
cbxXLBZBN.ShowValue = false;
|
|
|
|
cbxDYDJBN.ClearItems();
|
|
cbxDYDJBN.Items.Add(new ListItem("表外", "N"));
|
|
cbxDYDJBN.Items.Add(new ListItem("表内", "Y"));
|
|
cbxDYDJBN.ShowValue = false;
|
|
|
|
cbxXLXHBN.ClearItems();
|
|
cbxXLXHBN.Items.Add(new ListItem("表外", "N"));
|
|
cbxXLXHBN.Items.Add(new ListItem("表内", "Y"));
|
|
cbxXLXHBN.ShowValue = false;
|
|
|
|
TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
|
|
TSQL sql = new TSQL(dberp);
|
|
if (ControlState == TControlState.ctsBrowse)
|
|
{
|
|
sql.Clear();
|
|
sql.Add("select XLXSCPML_CPMLID,XLXSCPML_CPMLMC from XLXSCPML where 1=1 and XLXSCPML_CPMLID ='" + cbxCPMLID.SelectedValue.Trim() + "'and isnull(XLXSCPML_SJY,'N')='Y' order by XLXSCPML_CPMLID");
|
|
DataSet ds = dberp.OpenDataSet(sql);
|
|
cbxCPMLID.ClearItems();
|
|
if (ds.Tables[0].Rows.Count > 0)
|
|
{
|
|
cbxCPMLID.Items.Add(new ListItem(ds.Tables[0].Rows[0]["XLXSCPML_CPMLMC"].ToString().Trim(), ds.Tables[0].Rows[0]["XLXSCPML_CPMLID"].ToString().Trim()));
|
|
}
|
|
}
|
|
else
|
|
{
|
|
sql.Clear();
|
|
sql.Add("select XLXSCPML_CPMLID,XLXSCPML_CPMLMC from XLXSCPML where isnull(XLXSCPML_TYBZ,' ')<>'Y' and isnull(XLXSCPML_SJY,'N')='Y' order by XLXSCPML_CPMLID");
|
|
DataSet ds = dberp.OpenDataSet(sql);
|
|
cbxCPMLID.ClearItems();
|
|
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
|
|
{
|
|
cbxCPMLID.Items.Add(new ListItem(ds.Tables[0].Rows[i]["XLXSCPML_CPMLMC"].ToString().Trim(), ds.Tables[0].Rows[i]["XLXSCPML_CPMLID"].ToString().Trim()));
|
|
}
|
|
|
|
}
|
|
|
|
//工艺分类以及工艺分类版本
|
|
if (ControlState == TControlState.ctsBrowse)
|
|
{
|
|
sql.Clear();
|
|
sql.Add("select XLGYFL_GYFLBM,XLGYFL_GYFLMC from XLGYFL where 1=1 and XLGYFL_GYFLBM ='" + cbxGYFLBM.SelectedValue.Trim() + "' order by XLGYFL_GYFLBM");
|
|
DataSet ds = dberp.OpenDataSet(sql);
|
|
cbxGYFLBM.ClearItems();
|
|
cbxGYFLBM.Items.Add(new ListItem("", ""));
|
|
if (ds.Tables[0].Rows.Count > 0)
|
|
{
|
|
cbxGYFLBM.Items.Add(new ListItem(ds.Tables[0].Rows[0][1].ToString().Trim(), ds.Tables[0].Rows[0][0].ToString().Trim()));
|
|
}
|
|
}
|
|
else
|
|
{
|
|
|
|
sql.Clear();
|
|
sql.Add("select XLGYFL_GYFLBM,XLGYFL_GYFLMC from XLGYFL where isnull(XLGYFL_TYBZ,'N')<>'Y' order by XLGYFL_GYFLBM ");
|
|
DataSet ds = dberp.OpenDataSet(sql);
|
|
cbxGYFLBM.ClearItems();
|
|
cbxGYFLBM.Items.Add(new ListItem("", ""));
|
|
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
|
|
{
|
|
cbxGYFLBM.Items.Add(new ListItem(ds.Tables[0].Rows[i][1].ToString().Trim(), ds.Tables[0].Rows[i][0].ToString().Trim()));
|
|
}
|
|
|
|
}
|
|
|
|
base.SetComboxItems();
|
|
}
|
|
|
|
#endregion
|
|
|
|
#region 自定义事件
|
|
|
|
private void InitControls()
|
|
{
|
|
|
|
}
|
|
|
|
//2020 05 0002
|
|
public string GetNewID()
|
|
{
|
|
string sNewID = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString().PadLeft(2, '0');
|
|
int iMaxXH = 0;
|
|
TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
|
|
TSQL SQL = new TSQL(dberp);
|
|
SQL.Clear();
|
|
SQL.Add("select max(XLJGCZBML_JGCZBID) as MaxID from XLJGCZBML where 1 = 1 ");
|
|
SQL.Add(" and XLJGCZBML_JGCZBID like :pXLJGCZBML_JGCZBID ");
|
|
SQL.ParamByName("pXLJGCZBML_JGCZBID").Value = sNewID + "%";
|
|
DataSet ds = dberp.OpenDataSet(SQL);
|
|
if (ds.Tables[0].Rows.Count > 0)
|
|
{
|
|
if (!ds.Tables[0].Rows[0]["MaxID"].ToString().Trim().Equals(""))
|
|
{
|
|
iMaxXH = CMISproConvert.StrToInt(ds.Tables[0].Rows[0]["MaxID"].ToString().Trim().Substring(6, 4));
|
|
}
|
|
else
|
|
{
|
|
//iMaxXH = 0
|
|
}
|
|
}
|
|
iMaxXH++;
|
|
return sNewID + iMaxXH.ToString().PadLeft(4, '0');
|
|
}
|
|
|
|
#endregion
|
|
|
|
#region 控件事件
|
|
protected void btnHGFW_Click(object sender, EventArgs e)
|
|
{
|
|
string sJGCZBID = txtJGCZBID.Text.Trim();
|
|
TPageParams pageParams = new TPageParams();
|
|
pageParams.CallAction = TPageCallAction.pcaBrowse;
|
|
pageParams.UrlPath = "XLJGCZB_XHMLList.aspx";
|
|
pageParams.Title = "涵盖范围";
|
|
pageParams.AddString("LX", "HGFW");
|
|
pageParams.AddString("JGCZBID", sJGCZBID);
|
|
pageParams.AddString("CZBLX", cbxCZBLX.SelectedValue.Trim());
|
|
pageParams.AddString("GYFLBM", cbxGYFLBM.SelectedValue.Trim());
|
|
//表内表外
|
|
pageParams.AddString("XLXHBN", cbxXLXHBN.SelectedValue.Trim());
|
|
pageParams.AddString("XLBZBN", cbxXLBZBN.SelectedValue.Trim());
|
|
pageParams.AddString("DYDJBN", cbxDYDJBN.SelectedValue.Trim());
|
|
OpenModuleDialog(101421008, pageParams);
|
|
}
|
|
|
|
protected void btnXHML_Click(object sender, EventArgs e)
|
|
{
|
|
string sJGCZBID = txtJGCZBID.Text.Trim();
|
|
TPageParams pageParams = new TPageParams();
|
|
pageParams.CallAction = TPageCallAction.pcaBrowse;
|
|
pageParams.UrlPath = "XLJGCZB_XHMLList.aspx";
|
|
pageParams.Title = "型号目录";
|
|
pageParams.AddString("LX", "XHML");
|
|
pageParams.AddString("JGCZBID", sJGCZBID);
|
|
pageParams.AddString("CZBLX", cbxCZBLX.SelectedValue.Trim());
|
|
pageParams.AddString("GYFLBM", cbxGYFLBM.SelectedValue.Trim());
|
|
//表内表外
|
|
pageParams.AddString("XLXHBN", cbxXLXHBN.SelectedValue.Trim());
|
|
pageParams.AddString("XLBZBN", cbxXLBZBN.SelectedValue.Trim());
|
|
pageParams.AddString("DYDJBN", cbxDYDJBN.SelectedValue.Trim());
|
|
OpenModuleDialog(101421008, pageParams);
|
|
}
|
|
|
|
|
|
protected void btnCZBLM_Click(object sender, EventArgs e)
|
|
{
|
|
string sJGCZBID = txtJGCZBID.Text.Trim();
|
|
string sCZBLX = cbxCZBLX.SelectedValue.Trim();
|
|
if (!sCZBLX.Equals("A"))
|
|
{
|
|
ShowMessage("仅A类尺重表可以设置尺重表栏目！");
|
|
return;
|
|
}
|
|
|
|
TPageParams pageParams = new TPageParams();
|
|
pageParams.CallAction = TPageCallAction.pcaBrowse;
|
|
pageParams.UrlPath = "XLJGCZB_LMSZList.aspx";
|
|
pageParams.AddString("JGCZBID", sJGCZBID);
|
|
OpenModuleDialog(101421008, pageParams);
|
|
}
|
|
|
|
|
|
protected void cbxGYFLBM_OnSelectedIndexChanged(object sender, EventArgs e)
|
|
{
|
|
TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
|
|
TSQL SQL = new TSQL(dberp);
|
|
SQL.Clear();
|
|
if (cbxGYFLBM.SelectedValue.Trim().Equals(""))
|
|
{
|
|
cbxGYFLBBID.Tag = GThinking.N_CONTROL.gtComboBox.DTagStates.None;
|
|
|
|
SQL.Add("select distinct XLGYFLBB_GYFLBBID from XLGYFLBB ");
|
|
SQL.Add(" where XLGYFLBB_GYFLBM = :pGYFLBM ");
|
|
SQL.Add(" and XLGYFLBB_YXRQS <= :pDate ");
|
|
SQL.Add(" and XLGYFLBB_YXRQZ is null ");
|
|
SQL.Add(" order by XLGYFLBB_GYFLBBID ");
|
|
SQL.ParamByName("pGYFLBM").Value = cbxGYFLBM.SelectedValue.Trim();
|
|
SQL.ParamByName("pDate").Value = DateTime.Now;
|
|
DataSet ds = dberp.OpenDataSet(SQL);
|
|
cbxGYFLBBID.ClearItems();
|
|
cbxGYFLBBID.Items.Add(new ListItem("", ""));
|
|
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
|
|
{
|
|
if (!ds.Tables[0].Rows[i]["XLGYFLBB_GYFLBBID"].ToString().Trim().Equals(""))
|
|
{
|
|
cbxGYFLBBID.Items.Add(new ListItem(ds.Tables[0].Rows[i]["XLGYFLBB_GYFLBBID"].ToString().Trim(), ds.Tables[0].Rows[i]["XLGYFLBB_GYFLBBID"].ToString().Trim()));
|
|
}
|
|
}
|
|
}
|
|
else
|
|
{
|
|
cbxGYFLBBID.Tag = GThinking.N_CONTROL.gtComboBox.DTagStates.Star;
|
|
|
|
SQL.Add("select distinct XLGYFLBB_GYFLBBID from XLGYFLBB ");
|
|
SQL.Add(" where XLGYFLBB_GYFLBM = :pGYFLBM ");
|
|
SQL.Add(" and XLGYFLBB_YXRQS <= :pDate ");
|
|
SQL.Add(" and XLGYFLBB_YXRQZ is null ");
|
|
SQL.Add(" order by XLGYFLBB_GYFLBBID ");
|
|
SQL.ParamByName("pGYFLBM").Value = cbxGYFLBM.SelectedValue.Trim();
|
|
SQL.ParamByName("pDate").Value = DateTime.Now;
|
|
DataSet ds = dberp.OpenDataSet(SQL);
|
|
cbxGYFLBBID.ClearItems();
|
|
cbxGYFLBBID.Items.Add(new ListItem("", ""));
|
|
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
|
|
{
|
|
if (!ds.Tables[0].Rows[i]["XLGYFLBB_GYFLBBID"].ToString().Trim().Equals(""))
|
|
{
|
|
cbxGYFLBBID.Items.Add(new ListItem(ds.Tables[0].Rows[i]["XLGYFLBB_GYFLBBID"].ToString().Trim(), ds.Tables[0].Rows[i]["XLGYFLBB_GYFLBBID"].ToString().Trim()));
|
|
}
|
|
}
|
|
}
|
|
}
|
|
|
|
protected void cbxCZBLX_OnSelectedIndexChanged(object sender, EventArgs e)
|
|
{
|
|
txtEXCEL.Tag = GThinking.N_CONTROL.gtTextBox.DTagStates.None;
|
|
txtEXCEL.Tag = GThinking.N_CONTROL.gtTextBox.DTagStates.None;
|
|
cbxGYFLBM.Tag = GThinking.N_CONTROL.gtComboBox.DTagStates.None;
|
|
if (cbxCZBLX.SelectedValue.Trim().Equals("Z"))
|
|
{
|
|
cbxGYFLBM.Enabled = false;
|
|
cbxGYFLBBID.Enabled = false;
|
|
cbxGGHLX.Enabled = true;
|
|
cbxXLBZBN.Enabled = true;
|
|
cbxDYDJBN.Enabled = true;
|
|
cbxXLXHBN.Enabled = true;
|
|
txtEXCEL.Enabled = true;
|
|
txtSHEET.Enabled = true;
|
|
|
|
if (ControlState == TControlState.ctsInsert)
|
|
{
|
|
cbxGYFLBM.SelectedValue = "";
|
|
cbxGGHLX.SelectedValue = "1";
|
|
cbxXLXHBN.SelectedValue = "N";
|
|
cbxXLBZBN.SelectedValue = "N";
|
|
cbxDYDJBN.SelectedValue = "N";
|
|
}
|
|
|
|
txtEXCEL.Tag = GThinking.N_CONTROL.gtTextBox.DTagStates.Star;
|
|
txtSHEET.Tag = GThinking.N_CONTROL.gtTextBox.DTagStates.Star;
|
|
}
|
|
else if (cbxCZBLX.SelectedValue.Trim().Equals("A"))
|
|
{
|
|
cbxGYFLBM.Enabled = false;
|
|
cbxGYFLBBID.Enabled = false;
|
|
cbxGGHLX.Enabled = false;
|
|
cbxXLBZBN.Enabled = false;
|
|
cbxDYDJBN.Enabled = false;
|
|
cbxXLXHBN.Enabled = false;
|
|
txtEXCEL.Enabled = true;
|
|
txtSHEET.Enabled = true;
|
|
|
|
if (ControlState == TControlState.ctsInsert)
|
|
{
|
|
cbxGGHLX.SelectedValue = "1";
|
|
cbxXLXHBN.SelectedValue = "Y";
|
|
cbxXLBZBN.SelectedValue = "Y";
|
|
cbxDYDJBN.SelectedValue = "Y";
|
|
|
|
cbxGYFLBM.SelectedValue = "";
|
|
}
|
|
}
|
|
else if (cbxCZBLX.SelectedValue.Trim().Equals("B"))
|
|
{
|
|
cbxGYFLBM.Enabled = false;
|
|
cbxGYFLBBID.Enabled = false;
|
|
cbxGGHLX.Enabled = false;
|
|
cbxXLBZBN.Enabled = false;
|
|
cbxDYDJBN.Enabled = false;
|
|
cbxXLXHBN.Enabled = false;
|
|
txtEXCEL.Enabled = true;
|
|
txtSHEET.Enabled = true;
|
|
|
|
//当尺重表类型为B时，行类型固定为单行；标准、电压等级、线缆型号固定为表内。工艺分类不可选。
|
|
//切换到涵盖范围页，同A类型，不允许添加。
|
|
if (ControlState == TControlState.ctsInsert)
|
|
{
|
|
cbxGGHLX.SelectedValue = "1";
|
|
}
|
|
if (ControlState == TControlState.ctsInsert || ControlState == TControlState.ctsCopy)
|
|
{
|
|
cbxXLXHBN.SelectedValue = "Y";
|
|
cbxXLBZBN.SelectedValue = "Y";
|
|
cbxDYDJBN.SelectedValue = "Y";
|
|
|
|
cbxGYFLBM.SelectedValue = "";
|
|
}
|
|
}
|
|
else if (cbxCZBLX.SelectedValue.Trim().Equals("C"))
|
|
{
|
|
cbxGYFLBM.Enabled = true;
|
|
cbxGYFLBBID.Enabled = true;
|
|
cbxGGHLX.Enabled = false;
|
|
cbxXLBZBN.Enabled = false;
|
|
cbxDYDJBN.Enabled = false;
|
|
cbxXLXHBN.Enabled = false;
|
|
txtEXCEL.Enabled = true;
|
|
txtSHEET.Enabled = true;
|
|
|
|
|
|
if (ControlState == TControlState.ctsInsert)
|
|
{
|
|
cbxGGHLX.SelectedValue = "1";
|
|
}
|
|
|
|
//C类型尺重表限定标准、电压等级、线缆型号均为表内。
|
|
if (ControlState == TControlState.ctsInsert || ControlState == TControlState.ctsCopy)
|
|
{
|
|
cbxXLXHBN.SelectedValue = "Y";
|
|
cbxXLBZBN.SelectedValue = "Y";
|
|
cbxDYDJBN.SelectedValue = "Y";
|
|
}
|
|
|
|
cbxGYFLBM.Tag = GThinking.N_CONTROL.gtComboBox.DTagStates.Star;
|
|
}
|
|
else if (cbxCZBLX.SelectedValue.Trim().Equals("G"))
|
|
{
|
|
cbxGYFLBM.Enabled = true;
|
|
cbxGYFLBBID.Enabled = true;
|
|
cbxGGHLX.Enabled = false;
|
|
cbxXLBZBN.Enabled = false;
|
|
cbxDYDJBN.Enabled = false;
|
|
cbxXLXHBN.Enabled = false;
|
|
txtEXCEL.Enabled = true;
|
|
txtSHEET.Enabled = true;
|
|
|
|
if (ControlState == TControlState.ctsInsert)
|
|
{
|
|
cbxGGHLX.SelectedValue = "1";
|
|
cbxXLXHBN.SelectedValue = "N";
|
|
cbxXLBZBN.SelectedValue = "N";
|
|
cbxDYDJBN.SelectedValue = "N";
|
|
}
|
|
}
|
|
else if (cbxCZBLX.SelectedValue.Trim().Equals("D"))
|
|
{
|
|
cbxGYFLBM.Enabled = true;
|
|
cbxGYFLBBID.Enabled = true;
|
|
cbxGGHLX.Enabled = false;
|
|
cbxXLBZBN.Enabled = false;
|
|
cbxDYDJBN.Enabled = false;
|
|
cbxXLXHBN.Enabled = false;
|
|
txtEXCEL.Enabled = true;
|
|
txtSHEET.Enabled = true;
|
|
|
|
if (ControlState == TControlState.ctsInsert)
|
|
{
|
|
cbxGGHLX.SelectedValue = "1";
|
|
cbxXLXHBN.SelectedValue = "N";
|
|
cbxXLBZBN.SelectedValue = "N";
|
|
cbxDYDJBN.SelectedValue = "N";
|
|
}
|
|
}
|
|
}
|
|
#endregion
|
|
|
|
}
|
|
}
|