529 lines
25 KiB
C#
529 lines
25 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_XLXSBJ
|
|
{
|
|
public partial class JGCZBLMInfo : SingleCardBase
|
|
{
|
|
JGCZBLM entity = new JGCZBLM();
|
|
|
|
protected void Page_Load(object sender, EventArgs e)
|
|
{
|
|
this.UMID = 100860020;
|
|
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();
|
|
if (!IsPostBack)
|
|
{
|
|
InitControl();
|
|
}
|
|
}
|
|
|
|
#region 模板继承事件
|
|
|
|
#endregion
|
|
|
|
#region 自定义函数
|
|
|
|
private void InitControl()
|
|
{
|
|
TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
|
|
TSQL SQL = new TSQL(dberp);
|
|
string sSFXZ = GetSFXZPZ();
|
|
cbxBJCL.ClearItems();
|
|
SQL.Clear();
|
|
SQL.Add(" select XLXSBJCL_BJCLID, ");
|
|
SQL.Add(" case isnull(XLXSBJCL_BJCLID,' ') when ' ' then ' ' else rtrim(XLXSBJCL_BJCLID)||'|'||XLXSBJCL_BJCLMC || case when isnull(XLXSBJCL_TYBZ,'N')= 'Y' then '(停用)' else ' ' end end as BJCLMC");
|
|
SQL.Add(" from XLXSBJCL");
|
|
SQL.Add(" where isnull(XLXSBJCL_BJCLMC,' ')<>' '");
|
|
//SQL.Add(" and XLXSBJCL_BJCLID = :pBJCLID");
|
|
SQL.Add(" order by isnull(XLXSBJCL_TYBZ,'N'),XLXSBJCL_BJCLID");
|
|
//SQL.ParamByName("pBJCLID").Value = PageParam.GetRTrimString("BJCLID");
|
|
DataSet ds = dberp.OpenDataSet(SQL);
|
|
if (sSFXZ.Equals("Y"))
|
|
cbxBJCL.Items.Add(new ListItem("新增报价材料", "新增报价材料"));
|
|
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
|
|
{
|
|
cbxBJCL.Items.Add(new ListItem((ds.Tables[0].Rows[i][1].ToString().Trim()), (ds.Tables[0].Rows[i][0].ToString().Trim())));
|
|
}
|
|
if (cbxBJCL.ItemsCount >= 2)
|
|
{
|
|
cbxBJCL.SelectedValue = PageParam.GetRTrimString("BJCLID");
|
|
}
|
|
else if (sSFXZ.Equals("Y"))
|
|
{
|
|
cbxBJCL.SelectedValue = "新增报价材料";
|
|
}
|
|
cbxBJCL.ShowValue = false;
|
|
|
|
cbxXLCLZLID.ClearItems();
|
|
cbxXLCLZLID.Items.Add(new ListItem("", ""));
|
|
cbxXLCLZLID.Items.Add(new ListItem("导体材料", "DTCL"));
|
|
cbxXLCLZLID.Items.Add(new ListItem("绝缘材料", "JYCL"));
|
|
cbxXLCLZLID.Items.Add(new ListItem("护套材料", "HTCL"));
|
|
cbxXLCLZLID.Items.Add(new ListItem("铠装材料", "KZCL"));
|
|
cbxXLCLZLID.Items.Add(new ListItem("填充材料", "TCCL"));
|
|
cbxXLCLZLID.Items.Add(new ListItem("外护材料", "WHCL"));
|
|
cbxXLCLZLID.Items.Add(new ListItem("屏蔽材料", "PBCL"));
|
|
cbxXLCLZLID.Items.Add(new ListItem("绕包材料", "RBCL"));
|
|
cbxXLCLZLID.Items.Add(new ListItem("辅助材料", "FZCL"));
|
|
cbxXLCLZLID.Items.Add(new ListItem("导体产品", "DTCP"));
|
|
|
|
SQL.Clear();
|
|
SQL.Add(" select 'DTCL' as XLCLZLID,XLDTCLB_DTCLID as XLCLID,XLDTCLB_XLXTCLID as XLXTCLID,XLDTCLB_WLMC as XLCLMC from XLDTCLB where XLDTCLB_WLID=' ' ");
|
|
SQL.Add(" union all ");
|
|
SQL.Add(" select 'JYCL' as XLCLZLID,XLJYCLB_JYCLID as XLCLID,XLJYCLB_XLXTCLID as XLXTCLID,XLJYCLB_WLMC as XLCLMC from XLJYCLB where XLJYCLB_WLID=' ' ");
|
|
SQL.Add(" union all ");
|
|
SQL.Add(" select 'HTCL' as XLCLZLID,XLHTCLB_HTCLID as XLCLID,XLHTCLB_XLXTCLID as XLXTCLID,XLHTCLB_WLMC as XLCLMC from XLHTCLB where XLHTCLB_WLID=' ' ");
|
|
SQL.Add(" union all ");
|
|
SQL.Add(" select 'KZCL' as XLCLZLID,XLKZCLB_KZCLID as XLCLID,XLKZCLB_XLXTCLID as XLXTCLID,XLKZCLB_WLMC as XLCLMC from XLKZCLB where XLKZCLB_WLID=' ' ");
|
|
SQL.Add(" union all ");
|
|
SQL.Add(" select 'WHCL' as XLCLZLID,XLWHCLB_WHCLID as XLCLID,XLWHCLB_XLXTCLID as XLXTCLID,XLWHCLB_WLMC as XLCLMC from XLWHCLB where XLWHCLB_WLID=' ' ");
|
|
SQL.Add(" union all ");
|
|
SQL.Add(" select 'PBCL' as XLCLZLID,XLPBCLB_PBCLID as XLCLID,XLPBCLB_XLXTCLID as XLXTCLID,XLPBCLB_WLMC as XLCLMC from XLPBCLB where XLPBCLB_WLID=' ' ");
|
|
SQL.Add(" union all ");
|
|
SQL.Add(" select 'TCCL' as XLCLZLID,XLTCCLB_TCCLID as XLCLID,XLTCCLB_XLXTCLID as XLXTCLID,XLTCCLB_WLMC as XLCLMC from XLTCCLB where XLTCCLB_WLID=' ' ");
|
|
SQL.Add(" union all ");
|
|
SQL.Add(" select 'RBCL' as XLCLZLID,XLRBCLB_RBCLID as XLCLID,XLRBCLB_XLXTCLID as XLXTCLID,XLRBCLB_WLMC as XLCLMC from XLRBCLB where XLRBCLB_WLID=' ' ");
|
|
SQL.Add(" union all ");
|
|
SQL.Add(" select 'FZCL' as XLCLZLID,XLFZCLB_FZCLID as XLCLID,XLFZCLB_XLXTCLID as XLXTCLID,XLFZCLB_WLMC as XLCLMC from XLFZCLB where XLFZCLB_WLID=' ' ");
|
|
SQL.Add(" order by XLCLZLID,XLCLID");
|
|
DataSet dsXLCLDHB = dberp.OpenDataSet(SQL);
|
|
cbxXLCLID.ClearItems();
|
|
cbxXLCLID.Items.Add(new ListItem("", ""));
|
|
for (int i = 0; i < dsXLCLDHB.Tables[0].Rows.Count; i++)
|
|
{
|
|
cbxXLCLID.Items.Add(new ListItem((dsXLCLDHB.Tables[0].Rows[i]["XLCLMC"].ToString().Trim()), (dsXLCLDHB.Tables[0].Rows[i]["XLCLID"].ToString().Trim())));
|
|
}
|
|
|
|
//材料种类，材料代号---赋初值
|
|
if (!PageParam.GetRTrimString("XLCLZLID").Equals("") || !PageParam.GetRTrimString("XLCLID").Equals(""))
|
|
{
|
|
cbxXLCLZLID.SelectedValue = PageParam.GetRTrimString("XLCLZLID");
|
|
cbxXLCLID.SelectedValue = PageParam.GetRTrimString("XLCLID");
|
|
}
|
|
else
|
|
{
|
|
SQL.Clear();
|
|
SQL.Add(" SELECT XLXSBJCLDH_XLCLZLID,XLXSBJCLDH_XLCLID ");
|
|
SQL.Add(" from XLXSBJCLDH");
|
|
SQL.Add(" where XLXSBJCLDH_BJCLID =:pXLXSBJCLDH_BJCLID");
|
|
SQL.Add(" order by XLXSBJCLDH_XLCLZLID,XLXSBJCLDH_XLCLID");
|
|
SQL.ParamByName("pXLXSBJCLDH_BJCLID").Value = PageParam.GetRTrimString("BJCLID");
|
|
DataSet dsXLXSBJCLDH = dberp.OpenDataSet(SQL);
|
|
if (dsXLXSBJCLDH.Tables[0].Rows.Count == 1)
|
|
{
|
|
cbxXLCLZLID.SelectedValue = dsXLXSBJCLDH.Tables[0].Rows[0][0].ToString().Trim();
|
|
cbxXLCLID.SelectedValue = dsXLXSBJCLDH.Tables[0].Rows[0][1].ToString().Trim();
|
|
}
|
|
}
|
|
cbxXLCLZLID_OnSelectedIndexChanged(null, null);
|
|
}
|
|
|
|
private string GetNewBJCLID(TDatabase dberp)
|
|
{
|
|
TSQL SQL = new TSQL(dberp);
|
|
string sNewBJCLID = "";
|
|
string sOldBJCLID = "";
|
|
SQL.Clear();
|
|
SQL.Add(" select XLXSBJCL_BJCLID from XLXSBJCL ");
|
|
SQL.Add(" where LEN(rtrim(XLXSBJCL_BJCLID)) = 10 and XLXSBJCL_BJCLID like :pBJCLID order by XLXSBJCL_BJCLID desc ");
|
|
SQL.ParamByName("pBJCLID").Value = "BJCL" + PageParam.GetRTrimString("CZBLMBH") + "%";
|
|
DataSet ds = dberp.OpenDataSet(SQL);
|
|
if (ds.Tables[0].Rows.Count > 0)
|
|
{
|
|
sOldBJCLID = ds.Tables[0].Rows[0]["XLXSBJCL_BJCLID"].ToString().Trim();
|
|
if (sOldBJCLID.Equals(""))
|
|
{
|
|
sNewBJCLID = "BJCL" + PageParam.GetRTrimString("CZBLMBH") + "0000";
|
|
}
|
|
else
|
|
{
|
|
sOldBJCLID = sOldBJCLID.Substring(6);
|
|
sNewBJCLID = "BJCL" + PageParam.GetRTrimString("CZBLMBH") + Convert.ToString(CMISproConvert.StrToInt(sOldBJCLID) + 1).PadLeft(4, '0');
|
|
}
|
|
}
|
|
else
|
|
{
|
|
sNewBJCLID = "BJCL" + PageParam.GetRTrimString("CZBLMBH") + "0000";
|
|
}
|
|
return sNewBJCLID;
|
|
}
|
|
|
|
private bool ExistsXLXSBJCLDH(TDatabase dberp, string sXLCLZLID, string sXLCLID, string sBJCL)
|
|
{
|
|
TSQL SQL = new TSQL(dberp);
|
|
SQL.Clear();
|
|
SQL.Add(" select top 1 XLXSBJCLDH_XLCLZLID from XLXSBJCLDH ");
|
|
SQL.Add(" where XLXSBJCLDH_XLCLZLID = :pXLCLZLID ");
|
|
SQL.Add(" and XLXSBJCLDH_XLCLID = :pXLCLID ");
|
|
SQL.Add(" and XLXSBJCLDH_BJCLID = :pBJCLID ");
|
|
SQL.ParamByName("pXLCLZLID").Value = sXLCLZLID;
|
|
SQL.ParamByName("pXLCLID").Value = sXLCLID;
|
|
SQL.ParamByName("pBJCLID").Value = sBJCL;
|
|
DataSet ds = dberp.OpenDataSet(SQL);
|
|
if (ds.Tables[0].Rows.Count > 0)
|
|
{
|
|
return true;
|
|
}
|
|
else
|
|
{
|
|
return false;
|
|
}
|
|
}
|
|
|
|
private string GetBJCLMC(string sBJCLID)
|
|
{
|
|
string sBJCLMC = "";
|
|
TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
|
|
TSQL SQL = new TSQL(dberp);
|
|
SQL.Clear();
|
|
SQL.Add(" select XLXSBJCL_BJCLID,XLXSBJCL_BJCLMC from XLXSBJCL ");
|
|
SQL.Add(" where XLXSBJCL_BJCLID = :pBJCLID ");
|
|
SQL.ParamByName("pBJCLID").Value = sBJCLID;
|
|
DataSet ds = dberp.OpenDataSet(SQL);
|
|
if (ds.Tables[0].Rows.Count > 0)
|
|
{
|
|
sBJCLMC = ds.Tables[0].Rows[0]["XLXSBJCL_BJCLMC"].ToString().Trim();
|
|
}
|
|
return sBJCLMC;
|
|
}
|
|
|
|
private string GetSFXZPZ()
|
|
{
|
|
string rstr = "Y";
|
|
|
|
XLXSBJPZXX pzxx = XLBJDUtils.GetXLXSBJPZXX(100860020);
|
|
if (!string.IsNullOrEmpty(pzxx.XLXSBJPZ_ALMXZBJCL))
|
|
rstr = pzxx.XLXSBJPZ_ALMXZBJCL;
|
|
return rstr;
|
|
}
|
|
|
|
private string GetXLCLZLID(string sXLCLZLID)
|
|
{
|
|
string sRetValue = sXLCLZLID;
|
|
if (sXLCLZLID.Equals("DTCP") || sXLCLZLID.Equals("DTCL"))
|
|
{
|
|
sRetValue = "DTCL";
|
|
}
|
|
return sRetValue;
|
|
}
|
|
#endregion
|
|
|
|
#region 控件事件
|
|
protected void txtBJCLMC_OnTextChanged(object sender, EventArgs e)
|
|
{
|
|
string sBJCLID = cbxBJCL.SelectedValue.Trim();
|
|
int flag = 0;
|
|
if (!txtBJCLMC.Text.Trim().Equals(""))
|
|
{
|
|
TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
|
|
TSQL SQL = new TSQL(dberp);
|
|
cbxBJCL.ClearItems();
|
|
SQL.Clear();
|
|
SQL.Add(" select XLXSBJCL_BJCLID,case isnull(XLXSBJCL_BJCLID,' ') when ' ' then ' ' else rtrim(XLXSBJCL_BJCLID)||'|'||XLXSBJCL_BJCLMC||case when isnull(XLXSBJCL_TYBZ,'N')= 'Y' then '(停用)' else ' ' end end as BJCLMC from XLXSBJCL ");
|
|
SQL.Add(" where XLXSBJCL_BJCLMC like :pBJCLMC");
|
|
SQL.Add(" order by isnull(XLXSBJCL_TYBZ,'N'),XLXSBJCL_BJCLID");
|
|
SQL.ParamByName("pBJCLMC").Value = "%" + txtBJCLMC.Text.Trim() + "%";
|
|
DataSet ds = dberp.OpenDataSet(SQL);
|
|
cbxBJCL.Items.Add(new ListItem("新增报价材料", "新增报价材料"));
|
|
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
|
|
{
|
|
cbxBJCL.Items.Add(new ListItem((ds.Tables[0].Rows[i][1].ToString().Trim()), (ds.Tables[0].Rows[i][0].ToString().Trim())));
|
|
if(ds.Tables[0].Rows[i][0].ToString().Trim().Equals(PageParam.GetRTrimString("BJCLID")))
|
|
{
|
|
flag = 1;
|
|
}
|
|
}
|
|
if (1 == flag)
|
|
{
|
|
cbxBJCL.SelectedValue = PageParam.GetRTrimString("BJCLID");
|
|
}
|
|
else if (cbxBJCL.ItemsCount >= 2)
|
|
{
|
|
cbxBJCL.SelectedIndex = 1;
|
|
}
|
|
else
|
|
{
|
|
cbxBJCL.SelectedValue = "新增报价材料";
|
|
}
|
|
cbxBJCL.ShowValue = false;
|
|
|
|
cbxBJCL_OnSelectedIndexChanged(null, null);
|
|
}
|
|
else
|
|
{
|
|
InitControl();
|
|
}
|
|
}
|
|
|
|
|
|
protected void cbxBJCL_OnSelectedIndexChanged(object sender, EventArgs e)
|
|
{
|
|
TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
|
|
TSQL SQL = new TSQL(dberp);
|
|
if (!cbxBJCL.SelectedValue.Trim().Equals("新增报价材料") && cbxXLCLZLID.SelectedValue.Trim().Equals(""))
|
|
{
|
|
SQL.Clear();
|
|
SQL.Add(" SELECT XLXSBJCLDH_XLCLZLID,XLXSBJCLDH_XLCLID ");
|
|
SQL.Add(" from XLXSBJCLDH");
|
|
SQL.Add(" where XLXSBJCLDH_BJCLID =:pXLXSBJCLDH_BJCLID");
|
|
SQL.Add(" order by XLXSBJCLDH_XLCLZLID,XLXSBJCLDH_XLCLID");
|
|
SQL.ParamByName("pXLXSBJCLDH_BJCLID").Value = cbxBJCL.SelectedValue.Trim();
|
|
DataSet dsXLXSBJCLDH = dberp.OpenDataSet(SQL);
|
|
if (dsXLXSBJCLDH.Tables[0].Rows.Count == 1)
|
|
{
|
|
cbxXLCLZLID.SelectedValue = dsXLXSBJCLDH.Tables[0].Rows[0][0].ToString().Trim();
|
|
cbxXLCLID.SelectedValue = dsXLXSBJCLDH.Tables[0].Rows[0][1].ToString().Trim();
|
|
}
|
|
}
|
|
cbxXLCLZLID_OnSelectedIndexChanged(null, null);
|
|
}
|
|
|
|
protected void cbxXLCLZLID_OnSelectedIndexChanged(object sender, EventArgs e)
|
|
{
|
|
TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
|
|
TSQL SQL = new TSQL(dberp);
|
|
string sXLCLID = cbxXLCLID.SelectedValue.Trim();
|
|
if (cbxXLCLZLID.SelectedValue.Trim().Equals(""))
|
|
{
|
|
if (cbxXLCLID.SelectedValue.Trim().Equals(""))
|
|
{
|
|
cbxXLCLZLID.Tag = GThinking.N_CONTROL.gtComboBox.DTagStates.None;
|
|
cbxXLCLID.Tag = GThinking.N_CONTROL.gtComboBox.DTagStates.None;
|
|
}
|
|
else
|
|
{
|
|
cbxXLCLZLID.Tag = GThinking.N_CONTROL.gtComboBox.DTagStates.Star;
|
|
cbxXLCLID.Tag = GThinking.N_CONTROL.gtComboBox.DTagStates.Star;
|
|
}
|
|
cbxXLCLID.ClearItems();
|
|
cbxXLCLID.Items.Add(new ListItem("", ""));
|
|
cbxXLCLID.SelectedValue = "";
|
|
}
|
|
else
|
|
{
|
|
cbxXLCLZLID.Tag = GThinking.N_CONTROL.gtComboBox.DTagStates.Star;
|
|
cbxXLCLID.Tag = GThinking.N_CONTROL.gtComboBox.DTagStates.Star;
|
|
SQL.Clear();
|
|
SQL.Add(" SELECT XLCLID, XLCLMC ");
|
|
SQL.Add(" from (");
|
|
SQL.Add(" select 'DTCL' as XLCLZLID,XLDTCLB_DTCLID as XLCLID,XLDTCLB_XLXTCLID as XLXTCLID,XLDTCLB_WLMC as XLCLMC from XLDTCLB where XLDTCLB_WLID=' ' ");
|
|
SQL.Add(" union all ");
|
|
SQL.Add(" select 'JYCL' as XLCLZLID,XLJYCLB_JYCLID as XLCLID,XLJYCLB_XLXTCLID as XLXTCLID,XLJYCLB_WLMC as XLCLMC from XLJYCLB where XLJYCLB_WLID=' ' ");
|
|
SQL.Add(" union all ");
|
|
SQL.Add(" select 'HTCL' as XLCLZLID,XLHTCLB_HTCLID as XLCLID,XLHTCLB_XLXTCLID as XLXTCLID,XLHTCLB_WLMC as XLCLMC from XLHTCLB where XLHTCLB_WLID=' ' ");
|
|
SQL.Add(" union all ");
|
|
SQL.Add(" select 'KZCL' as XLCLZLID,XLKZCLB_KZCLID as XLCLID,XLKZCLB_XLXTCLID as XLXTCLID,XLKZCLB_WLMC as XLCLMC from XLKZCLB where XLKZCLB_WLID=' ' ");
|
|
SQL.Add(" union all ");
|
|
SQL.Add(" select 'WHCL' as XLCLZLID,XLWHCLB_WHCLID as XLCLID,XLWHCLB_XLXTCLID as XLXTCLID,XLWHCLB_WLMC as XLCLMC from XLWHCLB where XLWHCLB_WLID=' ' ");
|
|
SQL.Add(" union all ");
|
|
SQL.Add(" select 'PBCL' as XLCLZLID,XLPBCLB_PBCLID as XLCLID,XLPBCLB_XLXTCLID as XLXTCLID,XLPBCLB_WLMC as XLCLMC from XLPBCLB where XLPBCLB_WLID=' ' ");
|
|
SQL.Add(" union all ");
|
|
SQL.Add(" select 'TCCL' as XLCLZLID,XLTCCLB_TCCLID as XLCLID,XLTCCLB_XLXTCLID as XLXTCLID,XLTCCLB_WLMC as XLCLMC from XLTCCLB where XLTCCLB_WLID=' ' ");
|
|
SQL.Add(" union all ");
|
|
SQL.Add(" select 'RBCL' as XLCLZLID,XLRBCLB_RBCLID as XLCLID,XLRBCLB_XLXTCLID as XLXTCLID,XLRBCLB_WLMC as XLCLMC from XLRBCLB where XLRBCLB_WLID=' ' ");
|
|
SQL.Add(" union all ");
|
|
SQL.Add(" select 'FZCL' as XLCLZLID,XLFZCLB_FZCLID as XLCLID,XLFZCLB_XLXTCLID as XLXTCLID,XLFZCLB_WLMC as XLCLMC from XLFZCLB where XLFZCLB_WLID=' ' ");
|
|
SQL.Add(" ) a ");
|
|
SQL.Add(" where XLCLZLID =:pXLCLZLID");
|
|
SQL.Add(" order by XLCLZLID,XLCLID");
|
|
SQL.ParamByName("pXLCLZLID").Value = GetXLCLZLID(cbxXLCLZLID.SelectedValue.Trim());
|
|
DataSet dsXLCLDHB = dberp.OpenDataSet(SQL);
|
|
cbxXLCLID.ClearItems();
|
|
cbxXLCLID.Items.Add(new ListItem("", ""));
|
|
for (int i = 0; i < dsXLCLDHB.Tables[0].Rows.Count; i++)
|
|
{
|
|
cbxXLCLID.Items.Add(new ListItem((dsXLCLDHB.Tables[0].Rows[i][1].ToString().Trim()), (dsXLCLDHB.Tables[0].Rows[i][0].ToString().Trim())));
|
|
}
|
|
|
|
if (cbxXLCLID.ItemsCount >= 2)
|
|
{
|
|
cbxXLCLID.SelectedValue = sXLCLID;
|
|
}
|
|
}
|
|
cbxXLCLID_OnSelectedIndexChanged(null, null);
|
|
}
|
|
|
|
protected void cbxXLCLID_OnSelectedIndexChanged(object sender, EventArgs e)
|
|
{
|
|
|
|
if (cbxXLCLID.SelectedValue.Trim().Equals(""))
|
|
{
|
|
if (cbxXLCLZLID.SelectedValue.Trim().Equals(""))
|
|
{
|
|
cbxXLCLZLID.Tag = GThinking.N_CONTROL.gtComboBox.DTagStates.None;
|
|
cbxXLCLID.Tag = GThinking.N_CONTROL.gtComboBox.DTagStates.None;
|
|
}
|
|
else
|
|
{
|
|
cbxXLCLZLID.Tag = GThinking.N_CONTROL.gtComboBox.DTagStates.Star;
|
|
cbxXLCLID.Tag = GThinking.N_CONTROL.gtComboBox.DTagStates.Star;
|
|
}
|
|
}
|
|
else
|
|
{
|
|
cbxXLCLZLID.Tag = GThinking.N_CONTROL.gtComboBox.DTagStates.Star;
|
|
cbxXLCLID.Tag = GThinking.N_CONTROL.gtComboBox.DTagStates.Star;
|
|
}
|
|
}
|
|
|
|
protected void btnQR_Click(object sender, EventArgs e)
|
|
{
|
|
//新增报价材料
|
|
if (cbxBJCL.SelectedValue.Trim().Equals("新增报价材料") && !PageParam.GetRTrimString("CZBLMBH").Equals(""))
|
|
{
|
|
TPageParams pageParams = new TPageParams();
|
|
pageParams.CallAction = TPageCallAction.pcaInsert;
|
|
pageParams.UrlPath = "XLXSBJCLInfo.aspx";
|
|
pageParams.AddString("CLMC", PageParam.GetRTrimString("BJCLMC"));
|
|
pageParams.AddString("txtCLID", txtCLID.ClientID);
|
|
OpenModuleDialog(100860012, pageParams, btnRefresh.ClientID.ToString());
|
|
return;
|
|
|
|
}
|
|
//一旦选中“新增报价材料”保存，则新增一报价材料并新增报价材料的XLXSBJCL_BJCLID置为XLJGCZBLM_BJCLID。
|
|
TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
|
|
TSQL SQL = new TSQL(dberp);
|
|
|
|
bool bJSWC = false;
|
|
|
|
if (cbxXLCLZLID.SelectedValue.Trim().Equals("") && !cbxXLCLID.SelectedValue.Trim().Equals(""))
|
|
{
|
|
ShowMessage("材料代号不为空，材料种类也不允许为空！");
|
|
return;
|
|
}
|
|
|
|
if (!cbxXLCLZLID.SelectedValue.Trim().Equals("") && cbxXLCLID.SelectedValue.Trim().Equals(""))
|
|
{
|
|
ShowMessage("材料种类不为空，材料代号也不允许为空！");
|
|
return;
|
|
}
|
|
if (string.IsNullOrEmpty(cbxBJCL.SelectedValue))
|
|
{
|
|
ShowMessage("报价材料不允许为空！");
|
|
return;
|
|
}
|
|
|
|
if (cbxBJCL.SelectedItem.Text.Contains("(停用)"))
|
|
{
|
|
ShowMessage("报价材料已停用！");
|
|
return;
|
|
}
|
|
|
|
string sXLCLZLID = cbxXLCLZLID.SelectedValue.Trim();
|
|
string sXLCLID = cbxXLCLID.SelectedValue.Trim();
|
|
string sBJCL = cbxBJCL.SelectedValue.Trim();
|
|
|
|
|
|
|
|
try
|
|
{
|
|
dberp.BeginTrans();
|
|
SQL.Clear();
|
|
SQL.Add("update XLJGCZBLM set XLJGCZBLM_BJCLID= :pBJCL,XLJGCZBLM_XLCLZLID=:pXLCLZLID,XLJGCZBLM_XLCLID=:pXLCLID, ");
|
|
SQL.Add(" XLJGCZBLM_WHR= :pWHR, ");
|
|
SQL.Add(" XLJGCZBLM_WHRID= :pWHRID, ");
|
|
SQL.Add(" XLJGCZBLM_WHSJ= :pWHSJ ");
|
|
SQL.Add(" where XLJGCZBLM_JGCZBID= :pJGCZBID ");
|
|
SQL.Add(" and XLJGCZBLM_JGCZBBBID= :pJGCZBBBID ");
|
|
SQL.Add(" and XLJGCZBLM_CZBLMBH= :pCZBLMBH ");
|
|
SQL.ParamByName("pBJCL").Value = cbxBJCL.SelectedValue.Trim();
|
|
SQL.ParamByName("pXLCLZLID").Value = sXLCLZLID;
|
|
SQL.ParamByName("pXLCLID").Value = sXLCLID;
|
|
SQL.ParamByName("pJGCZBID").Value = PageParam.GetRTrimString("JGCZBID");
|
|
SQL.ParamByName("pJGCZBBBID").Value = PageParam.GetRTrimString("JGCZBBBID");
|
|
SQL.ParamByName("pCZBLMBH").Value = PageParam.GetRTrimString("CZBLMBH");
|
|
SQL.ParamByName("pWHR").Value = tSession.UserName;
|
|
SQL.ParamByName("pWHRID").Value = tSession.UserId;
|
|
SQL.ParamByName("pWHSJ").Value = DateTime.Now;
|
|
dberp.ExecSQL(SQL);
|
|
|
|
bJSWC = true;
|
|
|
|
if (!sXLCLZLID.Equals("") && !sXLCLID.Equals(""))
|
|
{
|
|
if (!ExistsXLXSBJCLDH(dberp, GetXLCLZLID(sXLCLZLID), sXLCLID, sBJCL))
|
|
{
|
|
SQL.Clear();
|
|
SQL.Add(" insert into XLXSBJCLDH(XLXSBJCLDH_XLCLZLID,XLXSBJCLDH_XLCLID,XLXSBJCLDH_BJCLID,XLXSBJCLDH_BZ,XLXSBJCLDH_WHR,XLXSBJCLDH_WHRID,XLXSBJCLDH_WHSJ) ");
|
|
SQL.Add(" values(:XLXSBJCLDH_XLCLZLID, :XLXSBJCLDH_XLCLID, :XLXSBJCLDH_BJCLID, :XLXSBJCLDH_BZ, :XLXSBJCLDH_WHR, :XLXSBJCLDH_WHRID, :XLXSBJCLDH_WHSJ)");
|
|
SQL.ParamByName("XLXSBJCLDH_XLCLZLID").Value = GetXLCLZLID(sXLCLZLID);
|
|
SQL.ParamByName("XLXSBJCLDH_XLCLID").Value = sXLCLID;
|
|
SQL.ParamByName("XLXSBJCLDH_BJCLID").Value = sBJCL;
|
|
SQL.ParamByName("XLXSBJCLDH_BZ").Value = PageParam.GetRTrimString("JGCZBID") + "|" + PageParam.GetRTrimString("JGCZBMC") + "(栏目设置自动添加)";
|
|
SQL.ParamByName("XLXSBJCLDH_WHRID").Value = tSession.UserId;
|
|
SQL.ParamByName("XLXSBJCLDH_WHR").Value = tSession.UserName;
|
|
SQL.ParamByName("XLXSBJCLDH_WHSJ").Value = DateTime.Now.ToString();
|
|
dberp.ExecSQL(SQL);
|
|
}
|
|
}
|
|
dberp.CommitTrans();
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
ShowMessage("选择报价材料出错，请联系系统管理员！错误原因：" + ex);
|
|
dberp.RollbackTrans();
|
|
}
|
|
|
|
if (bJSWC)
|
|
{
|
|
CLQDList.UpdatCLZL(dberp, SQL, PageParam.GetRTrimString("JGCZBID"), PageParam.GetRTrimString("JGCZBBBID"));
|
|
}
|
|
//使用脚本给父页面的隐藏控件赋值，调用父页面的控件事件
|
|
DialogOperationScript dos = new DialogOperationScript(this);
|
|
dos.ClickOwnerButton(PageParam.GetRTrimString("RefreshCtrlID"));
|
|
dos.CloseSelf();
|
|
dos.Execute();
|
|
}
|
|
|
|
protected void btnQX_Click(object sender, EventArgs e)
|
|
{
|
|
CloseWindow();
|
|
}
|
|
|
|
protected void btnRefresh_Click(object sender, EventArgs e)
|
|
{
|
|
string sCLID = txtCLID.Value.Trim();
|
|
if (!sCLID.Equals(""))
|
|
{
|
|
InitControl();
|
|
cbxBJCL.SelectedValue = sCLID;
|
|
|
|
}
|
|
FormAreaUpdate();
|
|
|
|
}
|
|
|
|
#endregion
|
|
}
|
|
}
|