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 } }