389 lines
16 KiB
C#
389 lines
16 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 System.Collections.Generic;
|
|
|
|
namespace GThinking.N_XLJC
|
|
{
|
|
[TableMap(DB = "DBERP", DbTableName = "XLJGCZBML", Umid = 101421008, IsWorkFlow = false, UseWhr = true, IsAttach = false,
|
|
|
|
QuerySelSql = "",
|
|
|
|
EntitySelSql = "",
|
|
|
|
InsertSql = "",
|
|
|
|
UpdateSql = "",
|
|
|
|
DeleteSql = "")]
|
|
public class XLJGCZB_XHMLOperEntity : EntityManager
|
|
{
|
|
}
|
|
public partial class XLJGCZB_XHMLOper : SingleCardBase
|
|
{
|
|
XLJGCZB_XHMLOperEntity entity = new XLJGCZB_XHMLOperEntity();
|
|
|
|
protected void Page_Load(object sender, EventArgs e)
|
|
{
|
|
this.UMID = 101421008;
|
|
this.UMName = "线缆结构尺重表";
|
|
this.CurMaster = Master;
|
|
this.CurEntity = entity;
|
|
this.PageHeight = 400;
|
|
this.PageWidth = 500;
|
|
|
|
Master.EnableAttachBtn = false;
|
|
Master.EnableCancelBtn = false;
|
|
Master.EnableCopyBtn = false;
|
|
Master.EnableDeleteBtn = false;
|
|
Master.EnableEditBtn = false;
|
|
Master.EnableInsertBtn = false;
|
|
Master.EnablePrintBtn = false;
|
|
Master.EnableRefreshBtn = false;
|
|
Master.EnableSaveBtn = false;
|
|
|
|
base.InitPage();
|
|
//类型-工艺分类编码-对应按钮界面栏目数
|
|
//A-无-4-不可用
|
|
//B-/-4
|
|
//C-有-6-必填
|
|
//G-有/无-6/4-选填
|
|
//Z-无-4-不可用
|
|
|
|
//默认显示栏目数为4的界面（无工艺分类）
|
|
cLSBZ.Style["display"] = "block";
|
|
cCAPP.Style["display"] = "none";
|
|
|
|
if ((PageParam.GetRTrimString("CZBLX").Equals("G") && !PageParam.GetRTrimString("GYFLBM").Equals("")) || PageParam.GetRTrimString("CZBLX").Equals("C"))
|
|
{
|
|
cLSBZ.Style["display"] = "none";
|
|
cCAPP.Style["display"] = "block";
|
|
}
|
|
|
|
//表内表外
|
|
cbxXLBZID_CAPP.Enabled = cbxXLBZID_LSBZ.Enabled = PageParam.GetRTrimString("XLBZBN").Equals("N");
|
|
cbxDYDJID_CAPP.Enabled = cbxDYDJID_LSBZ.Enabled = PageParam.GetRTrimString("DYDJBN").Equals("N");
|
|
cbxXLJBXHID_CAPP.Enabled = cbxXLJBXHID_LSBZ.Enabled = cbxXLXHID_CAPP.Enabled = cbxXLXHID_LSBZ.Enabled = PageParam.GetRTrimString("XLXHBN").Equals("N");
|
|
if (!IsPostBack)
|
|
{
|
|
InitControl();
|
|
}
|
|
}
|
|
|
|
#region 模板继承事件
|
|
|
|
#endregion
|
|
|
|
#region 自定义函数
|
|
|
|
private void InitControl()
|
|
{
|
|
TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
|
|
TSQL SQL = new TSQL(dberp);
|
|
|
|
DataSet ds;
|
|
///G|临时编制&Z|自主策划
|
|
///
|
|
TComboBox.SetComboBox("DBERP", cbxXLBZID_LSBZ, "select XLBZ_XLBZID as ID,XLBZ_XLBZLXMC as Name from XLBZ where 1=1 order by XLBZ_XLBZID ", true);
|
|
|
|
|
|
|
|
///C|成套计算
|
|
///
|
|
TComboBox.SetComboBox("DBERP", cbxXLBZID_CAPP, "select XLBZ_XLBZID as ID,XLBZ_XLBZLXMC as Name from XLBZ where 1=1 order by XLBZ_XLBZID ", true);
|
|
TComboBox.SetComboBox("DBERP", cbxXLBZBH_CAPP, "select XLZXBZ_XLBZBH as ID, rtrim(XLZXBZ_XLBZMC) as Name from XLZXBZ where 1=1 order by XLZXBZ_XLBZID,XLZXBZ_XLBZBH ", true);
|
|
|
|
//----------共
|
|
//电压等级
|
|
SQL.Clear();
|
|
SQL.Add("select XLDYDJB_DYDJID from XLDYDJB where isnull(XLDYDJB_TYBZ,'N')<>'Y' order by XLDYDJB_XH ");
|
|
ds = dberp.OpenDataSet(SQL);
|
|
cbxDYDJID_LSBZ.ClearItems();
|
|
cbxDYDJID_CAPP.ClearItems();
|
|
if (ds.Tables[0].Rows.Count > 0)
|
|
{
|
|
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
|
|
{
|
|
cbxDYDJID_LSBZ.Items.Add(new ListItem(ds.Tables[0].Rows[i][0].ToString().Trim(), ds.Tables[0].Rows[i][0].ToString().Trim()));
|
|
cbxDYDJID_CAPP.Items.Add(new ListItem(ds.Tables[0].Rows[i][0].ToString().Trim(), ds.Tables[0].Rows[i][0].ToString().Trim()));
|
|
}
|
|
|
|
}
|
|
|
|
//线缆基本型号
|
|
SQL.Clear();
|
|
SQL.Add("select XLXHB_XLXHID from XLXHB where XLXHB_XLXHID=XLXHB_XLJBXHID order by XLXHB_XLXHID ");
|
|
ds = dberp.OpenDataSet(SQL);
|
|
cbxXLJBXHID_LSBZ.ClearItems();
|
|
cbxXLJBXHID_CAPP.ClearItems();
|
|
if (ds.Tables[0].Rows.Count > 0)
|
|
{
|
|
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
|
|
{
|
|
cbxXLJBXHID_LSBZ.Items.Add(new ListItem(ds.Tables[0].Rows[i][0].ToString().Trim(), ds.Tables[0].Rows[i][0].ToString().Trim()));
|
|
cbxXLJBXHID_CAPP.Items.Add(new ListItem(ds.Tables[0].Rows[i][0].ToString().Trim(), ds.Tables[0].Rows[i][0].ToString().Trim()));
|
|
}
|
|
}
|
|
|
|
cbxXLJBXHID_OnSelectedIndexChanged(null, null);
|
|
}
|
|
|
|
|
|
#endregion
|
|
|
|
#region 控件事件
|
|
//基本型号的change
|
|
protected void cbxXLJBXHID_OnSelectedIndexChanged(object sender, EventArgs e)
|
|
{
|
|
//查询全部
|
|
int flag = 0;
|
|
TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
|
|
TSQL SQL = new TSQL(dberp);
|
|
DataSet ds;
|
|
string sLSBZ;
|
|
string sCAPP;
|
|
if (!cbxXLJBXHID_LSBZ.SelectedValue.Trim().Equals(""))
|
|
{
|
|
sLSBZ = cbxXLXHID_LSBZ.SelectedValue.Trim();
|
|
cbxXLXHID_LSBZ.ClearItems();
|
|
SQL.Clear();
|
|
SQL.Add("select XLXHB_XLXHID from XLXHB where 1 = 1 and " + CMISproDataBase.GetWhereEqual("XLXHB_XLJBXHID",cbxXLJBXHID_LSBZ.SelectedValue.Trim()));
|
|
ds = dberp.OpenDataSet(SQL);
|
|
if (ds.Tables[0].Rows.Count > 0)
|
|
{
|
|
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
|
|
{
|
|
cbxXLXHID_LSBZ.Items.Add(new ListItem(ds.Tables[0].Rows[i][0].ToString().Trim(), ds.Tables[0].Rows[i][0].ToString().Trim()));
|
|
}
|
|
|
|
}
|
|
cbxXLXHID_LSBZ.SelectedValue = sLSBZ;
|
|
flag = 1;
|
|
}
|
|
|
|
if (!cbxXLJBXHID_CAPP.SelectedValue.Trim().Equals(""))
|
|
{
|
|
sCAPP = cbxXLXHID_CAPP.SelectedValue.Trim();
|
|
cbxXLXHID_CAPP.ClearItems();
|
|
SQL.Clear();
|
|
SQL.Add("select XLXHB_XLXHID from XLXHB where 1 = 1 and " + CMISproDataBase.GetWhereEqual("XLXHB_XLJBXHID",cbxXLJBXHID_CAPP.SelectedValue.Trim()));
|
|
ds = dberp.OpenDataSet(SQL);
|
|
if (ds.Tables[0].Rows.Count > 0)
|
|
{
|
|
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
|
|
{
|
|
cbxXLXHID_CAPP.Items.Add(new ListItem(ds.Tables[0].Rows[i][0].ToString().Trim(), ds.Tables[0].Rows[i][0].ToString().Trim()));
|
|
}
|
|
|
|
}
|
|
cbxXLXHID_CAPP.SelectedValue = sCAPP;
|
|
flag = 1;
|
|
}
|
|
|
|
|
|
if (0 == flag)
|
|
{
|
|
sLSBZ = cbxXLXHID_LSBZ.SelectedValue.Trim();
|
|
sCAPP = cbxXLXHID_CAPP.SelectedValue.Trim();
|
|
|
|
cbxXLXHID_LSBZ.ClearItems();
|
|
cbxXLXHID_CAPP.ClearItems();
|
|
|
|
SQL.Clear();
|
|
SQL.Add("select XLXHB_XLXHID from XLXHB order by XLXHB_XLXHID ");
|
|
ds = dberp.OpenDataSet(SQL);
|
|
if (ds.Tables[0].Rows.Count > 0)
|
|
{
|
|
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
|
|
{
|
|
cbxXLXHID_LSBZ.Items.Add(new ListItem(ds.Tables[0].Rows[i][0].ToString().Trim(), ds.Tables[0].Rows[i][0].ToString().Trim()));
|
|
cbxXLXHID_CAPP.Items.Add(new ListItem(ds.Tables[0].Rows[i][0].ToString().Trim(), ds.Tables[0].Rows[i][0].ToString().Trim()));
|
|
}
|
|
}
|
|
cbxXLXHID_LSBZ.SelectedValue = sLSBZ;
|
|
cbxXLXHID_CAPP.SelectedValue = sCAPP;
|
|
}
|
|
}
|
|
|
|
|
|
protected void btnQR_Click(object sender, EventArgs e)
|
|
{
|
|
if (!(PageParam.GetRTrimString("CZBLX").Equals("G") && !PageParam.GetRTrimString("GYFLBM").Equals("")) && !PageParam.GetRTrimString("CZBLX").Equals("C"))
|
|
{
|
|
if (PageParam.GetRTrimString("XLBZBN").Equals("Y") && PageParam.GetRTrimString("DYDJBN").Equals("Y") && PageParam.GetRTrimString("XLXHBN").Equals("Y"))
|
|
{
|
|
ShowMessage("线缆型号，标准和电压等级均为表内，不允许批量添加！");
|
|
return;
|
|
}
|
|
}
|
|
string sJGCZBID = PageParam.GetRTrimString("JGCZBID");
|
|
int iXH = XLJGCZB_XHML.getNewXH(sJGCZBID);
|
|
|
|
string sRepeat = "";
|
|
string sJGCZB = "";
|
|
int falg = 0;
|
|
TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
|
|
TSQL SQL = new TSQL(dberp);
|
|
//对应CAPP按钮
|
|
if ((PageParam.GetRTrimString("CZBLX").Equals("G") && !PageParam.GetRTrimString("GYFLBM").Equals("")) || PageParam.GetRTrimString("CZBLX").Equals("C"))
|
|
{
|
|
try
|
|
{
|
|
|
|
dberp.BeginTrans();
|
|
string sCAPP_XLXHID = cbxXLXHID_CAPP.SelectedValue.Trim();
|
|
SQL.Clear();
|
|
SQL.Add("insert into XLXHJGCZBML");
|
|
SQL.Add(" (XLXHJGCZBML_JGCZBID,XLXHJGCZBML_JGCZBXH,XLXHJGCZBML_XLXHID,XLXHJGCZBML_DYDJID,");
|
|
SQL.Add(" XLXHJGCZBML_XLBZID,XLXHJGCZBML_XLBZBH,");
|
|
SQL.Add(" XLXHJGCZBML_WHRID,XLXHJGCZBML_WHR,XLXHJGCZBML_WHSJ) ");
|
|
SQL.Add("values ");
|
|
SQL.Add(" (:XLXHJGCZBML_JGCZBID,:XLXHJGCZBML_JGCZBXH,:XLXHJGCZBML_XLXHID,:XLXHJGCZBML_DYDJID,");
|
|
SQL.Add(" :XLXHJGCZBML_XLBZID,:XLXHJGCZBML_XLBZBH,");
|
|
SQL.Add(" :XLXHJGCZBML_WHRID,:XLXHJGCZBML_WHR,:XLXHJGCZBML_WHSJ)");
|
|
SQL.ParamByName("XLXHJGCZBML_JGCZBID").Value = sJGCZBID;
|
|
|
|
|
|
SQL.ParamByName("XLXHJGCZBML_DYDJID").Value = cbxDYDJID_CAPP.SelectedValue.Trim();
|
|
SQL.ParamByName("XLXHJGCZBML_XLBZID").Value = cbxXLBZID_CAPP.SelectedValue.Trim();
|
|
|
|
SQL.ParamByName("XLXHJGCZBML_XLBZBH").Value = cbxXLBZBH_CAPP.SelectedValue.Trim();
|
|
SQL.ParamByName("XLXHJGCZBML_WHRID").Value = tSession.UserId;
|
|
SQL.ParamByName("XLXHJGCZBML_WHR").Value = tSession.UserName;
|
|
SQL.ParamByName("XLXHJGCZBML_WHSJ").Value = DateTime.Now.ToString();
|
|
|
|
string[] sTemp = sCAPP_XLXHID.ToString().Trim().Split(',');
|
|
for (int i = 0; i < sTemp.Length; i++)
|
|
{
|
|
//此处判断重复
|
|
sJGCZB = XLJGCZB_XHML.ReJudge(sTemp[i], cbxDYDJID_CAPP.SelectedValue.Trim(),
|
|
cbxXLBZID_CAPP.SelectedValue.Trim(), PageParam.GetRTrimString("GYFLBM"),
|
|
cbxXLBZBH_CAPP.SelectedValue.Trim(), sJGCZBID);
|
|
if (sJGCZB.Equals(""))
|
|
{
|
|
SQL.ParamByName("XLXHJGCZBML_JGCZBXH").Value = iXH;
|
|
SQL.ParamByName("XLXHJGCZBML_XLXHID").Value = sTemp[i];
|
|
dberp.ExecSQL(SQL);
|
|
iXH--;
|
|
}
|
|
else
|
|
{
|
|
falg = 1;
|
|
sRepeat += sJGCZB + "\r\n";
|
|
}
|
|
|
|
}
|
|
dberp.CommitTrans();
|
|
if (0 == falg)
|
|
{
|
|
ShowMessage("添加完成！");
|
|
}
|
|
else
|
|
{
|
|
ShowMessage("存在如下涵盖范围记录重复：\r\n" + sRepeat);
|
|
}
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
ShowMessage("批量添加(CAPP)出现异常！异常信息：" + ex);
|
|
dberp.RollbackTrans();
|
|
}
|
|
}
|
|
////对应ADD按钮
|
|
else
|
|
{
|
|
try
|
|
{
|
|
dberp.BeginTrans();
|
|
string sLSBZ_XLXHID = cbxXLXHID_LSBZ.SelectedValue.Trim();
|
|
string sLSBZ_DYDJID = cbxDYDJID_LSBZ.SelectedValue.Trim();
|
|
SQL.Clear();
|
|
SQL.Add("insert into XLXHJGCZBML");
|
|
SQL.Add("(XLXHJGCZBML_JGCZBID,XLXHJGCZBML_JGCZBXH,XLXHJGCZBML_XLXHID,XLXHJGCZBML_DYDJID,");
|
|
SQL.Add(" XLXHJGCZBML_XLBZID,XLXHJGCZBML_XLBZBH,");
|
|
SQL.Add(" XLXHJGCZBML_WHRID,XLXHJGCZBML_WHR,XLXHJGCZBML_WHSJ) ");
|
|
SQL.Add("values ");
|
|
SQL.Add("(:XLXHJGCZBML_JGCZBID,:XLXHJGCZBML_JGCZBXH,:XLXHJGCZBML_XLXHID,:XLXHJGCZBML_DYDJID,");
|
|
SQL.Add(" :XLXHJGCZBML_XLBZID,:XLXHJGCZBML_XLBZBH,");
|
|
SQL.Add(" :XLXHJGCZBML_WHRID,:XLXHJGCZBML_WHR,:XLXHJGCZBML_WHSJ)");
|
|
SQL.ParamByName("XLXHJGCZBML_JGCZBID").Value = sJGCZBID;
|
|
|
|
|
|
|
|
SQL.ParamByName("XLXHJGCZBML_XLBZID").Value = cbxXLBZID_LSBZ.SelectedValue.Trim();
|
|
|
|
SQL.ParamByName("XLXHJGCZBML_XLBZBH").Value = "";
|
|
SQL.ParamByName("XLXHJGCZBML_WHRID").Value = tSession.UserId;
|
|
SQL.ParamByName("XLXHJGCZBML_WHR").Value = tSession.UserName;
|
|
SQL.ParamByName("XLXHJGCZBML_WHSJ").Value = DateTime.Now.ToString();
|
|
|
|
string[] sTempA = sLSBZ_XLXHID.ToString().Trim().Split(',');
|
|
string[] sTempB = sLSBZ_DYDJID.ToString().Trim().Split(',');
|
|
for (int i = 0; i < sTempA.Length; i++)
|
|
{
|
|
for (int j = 0; j < sTempB.Length; j++)
|
|
{
|
|
//此处判断重复
|
|
sJGCZB = XLJGCZB_XHML.ReJudge(sTempA[i], sTempB[j],
|
|
cbxXLBZID_LSBZ.SelectedValue.Trim(), " ",
|
|
"", sJGCZBID);
|
|
if (sJGCZB.Equals(""))
|
|
{
|
|
SQL.ParamByName("XLXHJGCZBML_JGCZBXH").Value = iXH;
|
|
SQL.ParamByName("XLXHJGCZBML_XLXHID").Value = sTempA[i];
|
|
SQL.ParamByName("XLXHJGCZBML_DYDJID").Value = sTempB[j];
|
|
dberp.ExecSQL(SQL);
|
|
iXH--;
|
|
}
|
|
else
|
|
{
|
|
falg = 1;
|
|
sRepeat += sJGCZB + "\r\n";
|
|
}
|
|
}
|
|
}
|
|
dberp.CommitTrans();
|
|
if (0 == falg)
|
|
{
|
|
ShowMessage("添加完成！");
|
|
}
|
|
else
|
|
{
|
|
ShowMessage("存在如下涵盖范围记录重复：\r\n" + sRepeat);
|
|
}
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
ShowMessage("批量添加(LSBZ)出现异常！异常信息：" + ex);
|
|
dberp.RollbackTrans();
|
|
}
|
|
|
|
}
|
|
//使用脚本给父页面的隐藏控件赋值，调用父页面的控件事件
|
|
DialogOperationScript dos = new DialogOperationScript(this);
|
|
dos.ClickOwnerButton(PageParam.GetRTrimString("RefreshCtrlID"));
|
|
dos.CloseSelf();
|
|
dos.Execute();
|
|
}
|
|
|
|
protected void btnQX_Click(object sender, EventArgs e)
|
|
{
|
|
CloseWindow();
|
|
}
|
|
|
|
#endregion
|
|
}
|
|
}
|