697 lines
30 KiB
C#
697 lines
30 KiB
C#
#region 功能说明
|
|
/*
|
|
* 参数说明：
|
|
* 注意事项：
|
|
* 更新记录：
|
|
*/
|
|
#endregion
|
|
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_MODEL.Page;
|
|
using GThinking.N_MISPRO.Data;
|
|
using GThinking.N_PUBLIC;
|
|
using GThinking.N_MISPRO.Utility;
|
|
using GThinking.N_CONTROL;
|
|
using GThinking.N_MODEL.Dialog;
|
|
using System.Collections.Generic;
|
|
namespace GThinking.N_XLXSBJ
|
|
{
|
|
public partial class TZYZBJList : SingleGridBase
|
|
{
|
|
XLXSTZYZ entity = new XLXSTZYZ();
|
|
|
|
TZYZBJ_M queryentity = new TZYZBJ_M();
|
|
|
|
#region Page类事件继承
|
|
|
|
protected void Page_Load(object sender, EventArgs e)
|
|
{
|
|
this.UMID = 100860005;
|
|
this.UMName = "线缆销售报价报价单调价因子";
|
|
this.CurMaster = Master;
|
|
this.ModuleGV = grdContentGrid;
|
|
this.CurEntity = entity;
|
|
this.CurQueryEntity = queryentity;
|
|
this.sURLTarget = "TZYZBJInfo.aspx";
|
|
this.sQueryURLTarget = "TZYZBJQuery.aspx";
|
|
this.PageHeight = 600;
|
|
this.PageWidth = 750;
|
|
this.Master.EnableNewBtn = false;
|
|
this.Master.EnableCopyBtn = false;
|
|
this.Master.EnableDeleteBtn = false;
|
|
base.sRefreshClientID = btnGRWJGRefer.ClientID;
|
|
base.DataKeyNames = new string[] { "XLXSTZYZ_MXBH", "XLXSTZYZ_YZID", "XLXSTZYZ_TJYS", "XLXSJGB_YXQS", "XLXSJGB_YXQZ", "XLXSJGB_JGBMC", "XLXSJGB_BZ", "XLXSTZYZ_YZMC", "XLXSTZYZ_WPIDLIST", "XLXSTZYZ_ZDWPIDLIST", "CLQDTX" };
|
|
|
|
base.InitPage();
|
|
|
|
TGtGridView.SetGrdColItems("DBERP", grdContentGrid.FindColumnExByFieldName("XLXSTZYZ_TYZZYZID"), "select XLXSTZYZ_TJYZID,(case XLXSTZYZ_JJFS when 'JD' then '乘以(1+加点(%))' when 'MD' then '乘以(1-下点(%))' when 'JJ' then '加点' when 'KD' then '除以(1-扣点(%))' when 'DD' then '除以(1+上点(%))' else XLXSTZYZ_JJFS end) as Name from XLXSTZYZ ");
|
|
if (!IsPostBack)
|
|
{
|
|
Master_OnStandardQuery(null, null);
|
|
}
|
|
}
|
|
#endregion
|
|
|
|
#region 模板事件继承
|
|
protected override void Master_OnStandardQuery(object sender, EventArgs e)
|
|
{
|
|
base.InitEntityByCondition();
|
|
entity.EntityTable.QuerySelSql = GetSQL();
|
|
base.Master_OnStandardQuery(sender, e);
|
|
entity.GridDataBind(grdContentGrid, tSession);
|
|
}
|
|
|
|
protected override void BeforeDelete(TDatabase db, ref bool ActionIsDone)
|
|
{
|
|
entity.Param.Add("XLXSTZYZ_MXBH", this.grdContentGrid.SelectedDataKey["XLXSTZYZ_MXBH"].ToString());
|
|
entity.Param.Add("XLXSTZYZ_YZID", this.grdContentGrid.SelectedDataKey["XLXSTZYZ_YZID"].ToString());
|
|
base.BeforeDelete(db, ref ActionIsDone);
|
|
}
|
|
|
|
protected override bool Master_AfterDeleteAction(object sender, EventArgs e)
|
|
{
|
|
if (!base.Master_AfterDeleteAction(sender, e)) { return false; }
|
|
base.InitEntityByCondition();
|
|
entity.EntityTable.QuerySelSql = GetSQL();
|
|
entity.GridDataBind(grdContentGrid, tSession);
|
|
grdContentGrid.SelectedIndex = -1;
|
|
return true;
|
|
}
|
|
|
|
protected override void moduleGV_Sorting(object sender, GridViewSortEventArgs e)
|
|
{
|
|
base.InitEntityByCondition();
|
|
string sSQL = GetSQL();
|
|
entity.EntityTable.QuerySelSql = sSQL;
|
|
|
|
base.moduleGV_Sorting(sender, e);
|
|
|
|
}
|
|
|
|
protected override void moduleGV_RowDataBound(object sender, GridViewRowEventArgs e)
|
|
{
|
|
if (e.Row.RowType == DataControlRowType.DataRow)
|
|
{
|
|
|
|
int indexJGBID = grdContentGrid.Columns.IndexOf(grdContentGrid.FindColumnByFieldName("XLXSTZYZ_JGBID"));
|
|
int indexWPIDLIST = grdContentGrid.Columns.IndexOf(grdContentGrid.FindColumnByFieldName("XLXSTZYZ_WPIDLIST"));
|
|
int indexZDWPIDLIST = grdContentGrid.Columns.IndexOf(grdContentGrid.FindColumnByFieldName("XLXSTZYZ_ZDWPIDLIST"));
|
|
//获取调价表索引
|
|
//int indexJGBID = grdContentGrid.Columns.IndexOf(grdContentGrid.FindColumnByFieldName("XLXSTZYZ_JGBID"));
|
|
string sTJYS = grdContentGrid.DataKeys[e.Row.RowIndex]["XLXSTZYZ_TJYS"].ToString();
|
|
string sTJYZID = grdContentGrid.DataKeys[e.Row.RowIndex]["XLXSTZYZ_YZID"].ToString().Trim();
|
|
string sJGBID = e.Row.Cells[indexJGBID].Text.ToString().Trim();
|
|
string sCLQDTX = grdContentGrid.DataKeys[e.Row.RowIndex]["CLQDTX"].ToString().Trim();
|
|
|
|
string sYXQS = grdContentGrid.DataKeys[e.Row.RowIndex]["XLXSJGB_YXQS"].ToString().Trim();
|
|
string sYXQZ = grdContentGrid.DataKeys[e.Row.RowIndex]["XLXSJGB_YXQZ"].ToString().Trim();
|
|
string sJGBMC = grdContentGrid.DataKeys[e.Row.RowIndex]["XLXSJGB_JGBMC"].ToString().Trim();
|
|
if (sYXQS.Equals(""))
|
|
sYXQS = "--";
|
|
else
|
|
sYXQS = CMISproConvert.ConvertDate(sYXQS);
|
|
if (sYXQZ.Equals(""))
|
|
sYXQZ = "--";
|
|
else
|
|
sYXQZ = CMISproConvert.ConvertDate(sYXQZ);
|
|
if (sJGBMC.Equals(""))
|
|
e.Row.Cells[indexJGBID].Text = e.Row.Cells[indexJGBID].Text.Trim() + "|" + sYXQS + "至" + sYXQZ;
|
|
else
|
|
e.Row.Cells[indexJGBID].Text = e.Row.Cells[indexJGBID].Text.Trim() + "|" + sYXQS + "至" + sYXQZ + "|" + sJGBMC;
|
|
|
|
|
|
|
|
|
|
e.Row.Cells[indexWPIDLIST].Text = GetWPNames(grdContentGrid.DataKeys[e.Row.RowIndex]["XLXSTZYZ_WPIDLIST"].ToString().Trim());
|
|
e.Row.Cells[indexZDWPIDLIST].Text = GetWPNames(grdContentGrid.DataKeys[e.Row.RowIndex]["XLXSTZYZ_ZDWPIDLIST"].ToString().Trim());
|
|
//添加a标签
|
|
if (sCLQDTX.Equals("Y"))
|
|
{
|
|
e.Row.Cells[indexJGBID].Text = string.Format("<A href='#' style=\"color:#ffbd09;\" onclick=\"CellClick('{0}','{1}','{2}','{3}') \"><U>"
|
|
+ e.Row.Cells[indexJGBID].Text.ToString().Trim()
|
|
+ "</U></A>", sJGBID, sTJYS, sTJYZID, sCLQDTX);
|
|
}
|
|
else
|
|
{
|
|
e.Row.Cells[indexJGBID].Text = string.Format("<A href='#' style=\"color:blue;\" onclick=\"CellClick('{0}','{1}','{2}','{3}') \"><U>"
|
|
+ e.Row.Cells[indexJGBID].Text.ToString().Trim()
|
|
+ "</U></A>", sJGBID, sTJYS, sTJYZID, sCLQDTX);
|
|
}
|
|
|
|
|
|
|
|
LinkPageParam.AddString("XLXSTZYZ_MXBH", grdContentGrid.DataKeys[e.Row.RowIndex]["XLXSTZYZ_MXBH"].ToString().Trim());
|
|
LinkPageParam.AddString("XLXSTZYZ_YZID", grdContentGrid.DataKeys[e.Row.RowIndex]["XLXSTZYZ_YZID"].ToString().Trim());
|
|
}
|
|
|
|
base.moduleGV_RowDataBound(sender, e);
|
|
}
|
|
|
|
protected override void moduleGV_PageIndexChanging(object sender, GridViewPageEventArgs e)
|
|
{
|
|
base.InitEntityByCondition();
|
|
entity.EntityTable.QuerySelSql = GetSQL();
|
|
grdContentGrid.SelectedIndex = -1;
|
|
|
|
base.moduleGV_PageIndexChanging(sender, e);
|
|
}
|
|
|
|
#endregion
|
|
|
|
#region 自定义函数
|
|
|
|
private string GetWPNames(string WPIDLIST)
|
|
{
|
|
string sReturn = "";
|
|
string[] SList = WPIDLIST.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
|
|
|
|
ListItemCollection WPValueList = new ListItemCollection();
|
|
WorkFlowUtils.SetListItemCollection_WFYWSW("XLXSBJ_BJD", WPValueList);
|
|
foreach (string WPID in SList)
|
|
{
|
|
for (int i = 0; i < WPValueList.Count; i++)
|
|
{
|
|
if (WPValueList[i].Value.Trim().Equals(WPID))
|
|
{
|
|
sReturn += WPValueList[i].Text.Trim() + ",";
|
|
}
|
|
}
|
|
}
|
|
return sReturn.TrimEnd(',');
|
|
}
|
|
|
|
private string GetSQL()
|
|
{
|
|
|
|
Dictionary<string, string> dicCLQDTX7 = new Dictionary<string, string>();
|
|
Dictionary<string, string> dicCLQDTXA = new Dictionary<string, string>();
|
|
Dictionary<string, string> dicCLQDTXE = new Dictionary<string, string>();
|
|
|
|
if (CurQueryEntity.FieldByName("CLQDTX").Value.Trim().ToUpper().Equals("TRUE"))
|
|
{
|
|
TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
|
|
TSQL SQL = new TSQL(dberp);
|
|
SQL.Clear();
|
|
SQL.Add("select XLXSTZYZ_YZID from XLXSTZYZ");
|
|
SQL.Add(" where XLXSTZYZ_TJYS = '7' and XLXSTZYZ_MXBH='BJD'");
|
|
SQL.Add(" and exists(select 1 from XLXSCLQD where XLXSCLQD_WPID='ZZZZ'");
|
|
SQL.Add(" and not exists(select 1 from XLXSBJDYZZ7 where XLXSBJDYZZ7_JGBID=XLXSTZYZ_JGBID and XLXSBJDYZZ7_YZID=XLXSTZYZ_YZID");
|
|
SQL.Add(" and XLXSCLQD_XLXHID=XLXSBJDYZZ7_XLXHID and XLXSCLQD_DYDJID=XLXSBJDYZZ7_DYDJID)");
|
|
SQL.Add(" and not exists(select 1 from XLXSBJDYZZ7 where XLXSBJDYZZ7_JGBID=XLXSTZYZ_JGBID and XLXSBJDYZZ7_YZID=XLXSTZYZ_YZID");
|
|
SQL.Add(" and XLXSCLQD_XLXHID=XLXSBJDYZZ7_XLXHID and XLXSBJDYZZ7_DYDJID=' ')");
|
|
SQL.Add(" )");
|
|
DataSet ds7 = dberp.OpenDataSet(SQL);
|
|
for (int i = 0; i < ds7.Tables[0].Rows.Count; i++)
|
|
{
|
|
dicCLQDTX7.Add(ds7.Tables[0].Rows[i]["XLXSTZYZ_YZID"].ToString().Trim(), "");
|
|
}
|
|
|
|
SQL.Clear();
|
|
SQL.Add("select XLXSTZYZ_YZID from XLXSTZYZ");
|
|
SQL.Add(" where XLXSTZYZ_TJYS = 'A' and XLXSTZYZ_MXBH='BJD'");
|
|
SQL.Add(" and exists(select 1 from XLXSCLQD where XLXSCLQD_WPID='ZZZZ'");
|
|
SQL.Add(" and not exists(select 1 from XLXSBJDYZZA where XLXSBJDYZZA_JGBID=XLXSTZYZ_JGBID and XLXSBJDYZZA_YZID=XLXSTZYZ_YZID");
|
|
SQL.Add(" and XLXSCLQD_XLXHID=XLXSBJDYZZA_XLXHID and XLXSCLQD_XLGGID=XLXSBJDYZZA_XLGGID ");
|
|
SQL.Add(" and XLXSCLQD_XLBZID=XLXSBJDYZZA_XLBZID and XLXSCLQD_DYDJID=XLXSBJDYZZA_DYDJID)");
|
|
SQL.Add(" )");
|
|
DataSet dsA = dberp.OpenDataSet(SQL);
|
|
for (int i = 0; i < dsA.Tables[0].Rows.Count; i++)
|
|
{
|
|
dicCLQDTXA.Add(dsA.Tables[0].Rows[i]["XLXSTZYZ_YZID"].ToString().Trim(), "");
|
|
}
|
|
|
|
SQL.Clear();
|
|
SQL.Add("select XLXSTZYZ_YZID from XLXSTZYZ");
|
|
SQL.Add(" where XLXSTZYZ_TJYS = 'E' and XLXSTZYZ_MXBH='BJD'");
|
|
SQL.Add(" and exists(select 1 from XLXSCLQD where XLXSCLQD_WPID='ZZZZ'");
|
|
SQL.Add(" and not exists(select 1 from XLXSBJDYZZE where XLXSBJDYZZE_JGBID=XLXSTZYZ_JGBID and XLXSBJDYZZE_YZID=XLXSTZYZ_YZID");
|
|
SQL.Add(" and XLXSCLQD_XLXHID=XLXSBJDYZZE_XLXHID and XLXSCLQD_DYDJID=XLXSBJDYZZE_DYDJID)");
|
|
SQL.Add(" and not exists(select 1 from XLXSBJDYZZE where XLXSBJDYZZE_JGBID=XLXSTZYZ_JGBID and XLXSBJDYZZE_YZID=XLXSTZYZ_YZID");
|
|
SQL.Add(" and XLXSCLQD_XLXHID=XLXSBJDYZZE_XLXHID and XLXSBJDYZZE_DYDJID=' ')");
|
|
SQL.Add(" and not exists(select 1 from XLXSBJDYZZE where XLXSBJDYZZE_JGBID=XLXSTZYZ_JGBID and XLXSBJDYZZE_YZID=XLXSTZYZ_YZID");
|
|
SQL.Add(" and XLXSBJDYZZE_XLXHID=' ' and XLXSBJDYZZE_DYDJID=' ')");
|
|
SQL.Add(" )");
|
|
DataSet dsE = dberp.OpenDataSet(SQL);
|
|
for (int i = 0; i < dsE.Tables[0].Rows.Count; i++)
|
|
{
|
|
dicCLQDTXE.Add(dsE.Tables[0].Rows[i]["XLXSTZYZ_YZID"].ToString().Trim(), "");
|
|
}
|
|
}
|
|
string tmpStr = "";
|
|
if (dicCLQDTX7.Keys.Count > 0 || dicCLQDTXA.Keys.Count > 0 || dicCLQDTXE.Keys.Count > 0)
|
|
{
|
|
tmpStr = " case XLXSTZYZ_YZID ";
|
|
foreach (string sKey in dicCLQDTX7.Keys)
|
|
{
|
|
tmpStr += string.Format("when '{0}' then 'Y' ", sKey);
|
|
}
|
|
foreach (string sKey in dicCLQDTXA.Keys)
|
|
{
|
|
tmpStr += string.Format("when '{0}' then 'Y' ", sKey);
|
|
}
|
|
foreach (string sKey in dicCLQDTXE.Keys)
|
|
{
|
|
tmpStr += string.Format("when '{0}' then 'Y' ", sKey);
|
|
}
|
|
tmpStr += " else 'N' end as CLQDTX,";
|
|
}
|
|
else
|
|
{
|
|
tmpStr = " 'N' as CLQDTX,";
|
|
}
|
|
string sSQL = "";
|
|
sSQL = "select XLXSTZYZ_MXBH, XLXSTZYZ_YZID, XLXSTZYZ_YZMC, "+tmpStr+"\r\n"
|
|
+ " rtrim(XLXSTZYZ_TJYZID)||'|'||(case XLXSTZYZ_JJFS when 'JD' then '乘以(1+加点(%))' when 'MD' then '乘以(1-下点(%))' when 'JJ' then ( case XLXSTZYZ_TJLX when '1' then '加价(元)' else '加点' end ) when 'KD' then '除以(1-扣点(%))' when 'DD' then '除以(1+下点(%))' "
|
|
+ " when 'MP' then '乘以(%)' when 'MX' then '乘以(系数)' when 'DX' then '除以(系数)' when 'SX' then '上点除、下点乘' else XLXSTZYZ_JJFS end) as JJFS, " + "\r\n"
|
|
+ " XLXSTZYZ_BCYTJ,XLXSTZYZ_XSXH, XLXSTZYZ_BZ, XLXSTZYZ_WHRID, XLXSTZYZ_WHR, XLXSTZYZ_WHSJ,XLXSTZYZ_TJYS," + "\r\n"
|
|
+ " XLXSTZYZ_JGBID,XLXSJGB_YXQS,XLXSJGB_YXQZ,XLXSJGB_BZ,XLXSJGB_JGBMC,XLXSTZYZ_WPIDLIST,XLXSTZYZ_ZDWPIDLIST,XLXSTZYZ_HCBZ, "
|
|
+ " XLXSTZYZ_TJLX,XLXSTZYZ_TYZZYZID,XLXSTZYZ_YZZZD,XLXSTZYZ_ABJCPJYYZZ "
|
|
+ " from XLXSTZYZ left join XLXSJGB on XLXSJGB_MXBH='BJD' and XLXSTZYZ_TJYS=XLXSJGB_TJYS and XLXSJGB_JGBID=XLXSTZYZ_JGBID " + "\r\n"
|
|
+ " where XLXSTZYZ_MXBH='BJD' "
|
|
+ " order by XLXSTZYZ_MXBH, XLXSTZYZ_XSXH, XLXSTZYZ_YZID \r\n";
|
|
return sSQL;
|
|
}
|
|
|
|
//根据sJGBID、sTJYS、sTJYZID跳转到对应的价格表
|
|
protected void JGBTZ(string sJGBID, string sTJYS, string sTJYZID, string sCLQDTX)
|
|
{
|
|
if (sTJYS.Equals(" "))
|
|
{
|
|
TPageParams tpp = new TPageParams();
|
|
tpp.UrlPath = "TZYZBJ_YZZList.aspx";
|
|
tpp.AddString("JGBID", sJGBID);
|
|
OpenDialog(tpp);
|
|
}
|
|
else if (sTJYS.Equals("1"))
|
|
{
|
|
TPageParams tpp = new TPageParams();
|
|
tpp.UrlPath = "TZYZBJMXList.aspx";
|
|
tpp.AddString("JGBID", sJGBID);
|
|
OpenFuncModuleDialog(100860019, tpp);
|
|
}
|
|
else if (sTJYS.Equals("2"))
|
|
{
|
|
TPageParams tpp = new TPageParams();
|
|
tpp.UrlPath = "TZYZBJ2List.aspx";
|
|
tpp.AddString("JGBID", sJGBID);
|
|
OpenFuncModuleDialog(100860021, tpp);
|
|
}
|
|
else if (sTJYS.Equals("3"))
|
|
{
|
|
TPageParams tpp = new TPageParams();
|
|
tpp.UrlPath = "TZYZBJ3List.aspx";
|
|
tpp.AddString("JGBID", sJGBID);
|
|
OpenFuncModuleDialog(100860022, tpp);
|
|
}
|
|
else if (sTJYS.Equals("4"))
|
|
{
|
|
TPageParams tpp = new TPageParams();
|
|
tpp.UrlPath = "TZYZBJ4List.aspx";
|
|
tpp.AddString("JGBID", sJGBID);
|
|
OpenFuncModuleDialog(100860028, tpp);
|
|
}
|
|
else if (sTJYS.Equals("5"))
|
|
{
|
|
TPageParams tpp = new TPageParams();
|
|
tpp.UrlPath = "TZYZBJ5List.aspx";
|
|
tpp.AddString("JGBID", sJGBID);
|
|
OpenFuncModuleDialog(100860029, tpp);
|
|
}
|
|
else if (sTJYS.Equals("6"))
|
|
{
|
|
TPageParams tpp = new TPageParams();
|
|
tpp.UrlPath = "TZYZBJ6List.aspx";
|
|
tpp.AddString("JGBID", sJGBID);
|
|
OpenFuncModuleDialog(100860030, tpp);
|
|
}
|
|
else if (sTJYS.Equals("7"))
|
|
{
|
|
TPageParams tpp = new TPageParams();
|
|
tpp.UrlPath = "TZYZBJ7List.aspx";
|
|
tpp.AddString("JGBID", sJGBID);
|
|
tpp.AddString("TJYZID", sTJYZID);
|
|
if (sCLQDTX.Equals("Y"))
|
|
tpp.AddString("YCLQDCXWSZ", "True");
|
|
else
|
|
tpp.AddString("YCLQDCXWSZ", "False");
|
|
OpenFuncModuleDialog(100860031, tpp);
|
|
}
|
|
else if (sTJYS.Equals("8"))
|
|
{
|
|
TPageParams tpp = new TPageParams();
|
|
tpp.UrlPath = "TZYZBJ8List.aspx";
|
|
tpp.AddString("JGBID", sJGBID);
|
|
OpenFuncModuleDialog(100860039, tpp);
|
|
}
|
|
else if (sTJYS.Equals("9"))
|
|
{
|
|
TPageParams tpp = new TPageParams();
|
|
tpp.UrlPath = "TZYZBJ9List.aspx";
|
|
tpp.AddString("JGBID", sJGBID);
|
|
OpenFuncModuleDialog(100860040, tpp);
|
|
}
|
|
else if (sTJYS.Equals("A"))
|
|
{
|
|
TPageParams tpp = new TPageParams();
|
|
tpp.UrlPath = "TZYZBJAList.aspx";
|
|
tpp.AddString("JGBID", sJGBID);
|
|
tpp.AddString("TJYZID", sTJYZID);
|
|
if (sCLQDTX.Equals("Y"))
|
|
tpp.AddString("YCLQDCXWSZ", "True");
|
|
else
|
|
tpp.AddString("YCLQDCXWSZ", "False");
|
|
OpenFuncModuleDialog(100860041, tpp);
|
|
}
|
|
else if (sTJYS.Equals("B"))
|
|
{
|
|
TPageParams tpp = new TPageParams();
|
|
tpp.UrlPath = "TZYZBJBList.aspx";
|
|
tpp.AddString("JGBID", sJGBID);
|
|
OpenFuncModuleDialog(100860054, tpp);
|
|
}
|
|
else if (sTJYS.Equals("C"))
|
|
{
|
|
TPageParams tpp = new TPageParams();
|
|
tpp.UrlPath = "TZYZBJCList.aspx";
|
|
tpp.AddString("JGBID", sJGBID);
|
|
tpp.AddString("BJDID", "");
|
|
OpenFuncModuleDialog(100860072, tpp);
|
|
}
|
|
else if (sTJYS.Equals("D"))
|
|
{
|
|
TPageParams tpp = new TPageParams();
|
|
tpp.UrlPath = "TZYZBJDList.aspx";
|
|
tpp.AddString("JGBID", sJGBID);
|
|
OpenFuncModuleDialog(100860085, tpp);
|
|
}
|
|
else if (sTJYS.Equals("E"))
|
|
{
|
|
TPageParams tpp = new TPageParams();
|
|
tpp.UrlPath = "TZYZBJEList.aspx";
|
|
tpp.AddString("JGBID", sJGBID);
|
|
if (sCLQDTX.Equals("Y"))
|
|
tpp.AddString("YCLQDCXWSZ", "True");
|
|
else
|
|
tpp.AddString("YCLQDCXWSZ", "False");
|
|
OpenFuncModuleDialog(100860086, tpp);
|
|
}
|
|
else if (sTJYS.Equals("F"))
|
|
{
|
|
TPageParams tpp = new TPageParams();
|
|
tpp.UrlPath = "TZYZBJFList.aspx";
|
|
tpp.AddString("JGBID", sJGBID);
|
|
OpenFuncModuleDialog(100860089, tpp);
|
|
}
|
|
else if (sTJYS.Equals("G"))
|
|
{
|
|
TPageParams tpp = new TPageParams();
|
|
tpp.UrlPath = "TZYZBJGList.aspx";
|
|
tpp.AddString("JGBID", sJGBID);
|
|
OpenFuncModuleDialog(100860133, tpp);
|
|
}
|
|
else if (sTJYS.Equals("H"))
|
|
{
|
|
TPageParams tpp = new TPageParams();
|
|
tpp.UrlPath = "TZYZBJHList.aspx";
|
|
tpp.AddString("JGBID", sJGBID);
|
|
OpenFuncModuleDialog(100860135, tpp);
|
|
}
|
|
else if (sTJYS.Equals("I"))
|
|
{
|
|
TPageParams tpp = new TPageParams();
|
|
tpp.UrlPath = "TZYZBJIList.aspx";
|
|
tpp.AddString("JGBID", sJGBID);
|
|
OpenFuncModuleDialog(100860149, tpp);
|
|
}
|
|
else if (sTJYS.Equals("J"))
|
|
{
|
|
TPageParams tpp = new TPageParams();
|
|
tpp.UrlPath = "TZYZBJJList.aspx";
|
|
tpp.AddString("JGBID", sJGBID);
|
|
OpenFuncModuleDialog(100860150, tpp);
|
|
}
|
|
else if (sTJYS.Equals("K"))
|
|
{
|
|
TPageParams tpp = new TPageParams();
|
|
tpp.UrlPath = "TZYZBJKList.aspx";
|
|
tpp.AddString("JGBID", sJGBID);
|
|
OpenFuncModuleDialog(100860152, tpp);
|
|
}
|
|
else if (sTJYS.Equals("M"))
|
|
{
|
|
TPageParams tpp = new TPageParams();
|
|
tpp.UrlPath = "TZYZBJMList.aspx";
|
|
tpp.AddString("JGBID", sJGBID);
|
|
OpenFuncModuleDialog(100860178, tpp);
|
|
}
|
|
}
|
|
|
|
#endregion
|
|
|
|
#region 控件事件
|
|
protected void btnTJB_OnDropDown(object sender, EventArgs e)
|
|
{
|
|
if (grdContentGrid.SelectedIndex < 0)
|
|
{
|
|
return;
|
|
}
|
|
btnTJB.Nodes.Clear();
|
|
List<JGBMLXX> jgbxx_List = XLBJDUtils.GetXLXSJGBXXList("BJD");
|
|
string sTJYS = grdContentGrid.DataKeys[grdContentGrid.SelectedIndex]["XLXSTZYZ_TJYS"].ToString().Trim();
|
|
foreach (JGBMLXX jgbxx in jgbxx_List)
|
|
{
|
|
if (jgbxx.XLXSJGB_TJYS.Equals(sTJYS))
|
|
{
|
|
string sJGBID = jgbxx.XLXSJGB_JGBID;
|
|
string sYXQS = jgbxx.XLXSJGB_YXQS;
|
|
string sYXQZ = jgbxx.XLXSJGB_YXQZ;
|
|
string sJGBMC = jgbxx.XLXSJGB_JGBMC;
|
|
if (sYXQS.Equals(""))
|
|
sYXQS = "--";
|
|
else
|
|
sYXQS = CMISproConvert.ConvertDate(sYXQS);
|
|
if (sYXQZ.Equals(""))
|
|
sYXQZ = "--";
|
|
else
|
|
sYXQZ = CMISproConvert.ConvertDate(sYXQZ);
|
|
string sText = "";
|
|
if (sJGBMC.Equals(""))
|
|
sText = sJGBID + "|" + sYXQS + "至" + sYXQZ;
|
|
else
|
|
sText = sJGBID + "|" + sYXQS + "至" + sYXQZ + "|" + sJGBMC;
|
|
btnTJB.Nodes.Add(new gtTreeNode(sJGBID, sText));
|
|
|
|
}
|
|
}
|
|
MenuAreaUpdate();
|
|
}
|
|
|
|
protected void btnTJB_Click(object sender, EventArgs e)
|
|
{
|
|
if (grdContentGrid.SelectedIndex < 0)
|
|
{
|
|
ShowMessage("请选择处理记录！");
|
|
return;
|
|
}
|
|
string sTJYS = grdContentGrid.DataKeys[grdContentGrid.SelectedIndex]["XLXSTZYZ_TJYS"].ToString();//不要trim()
|
|
string sTJYSMC = "";
|
|
if (sTJYS.Trim().Equals("1"))
|
|
{
|
|
sTJYSMC = "付款方式";
|
|
}
|
|
else if (sTJYS.Trim().Equals("2"))
|
|
{
|
|
sTJYSMC = "导体材料&电压区间&报价数量区间";
|
|
}
|
|
else if (sTJYS.Trim().Equals("3"))
|
|
{
|
|
sTJYSMC = "产品用途&电压等级分类&报价数量区间";
|
|
}
|
|
else if (sTJYS.Trim().Equals("4"))
|
|
{
|
|
sTJYSMC = "型号";
|
|
}
|
|
else if (sTJYS.Trim().Equals("5"))
|
|
{
|
|
sTJYSMC = "销售区域&型号&标准&电压等级&主芯截面范围";
|
|
}
|
|
else if (sTJYS.Trim().Equals("6"))
|
|
{
|
|
sTJYSMC = "报价数量区间调价米数/报价数量";
|
|
}
|
|
else if (sTJYS.Trim().Equals("7"))
|
|
{
|
|
sTJYSMC = "型号&电压等级&芯线结构&主芯截面范围";
|
|
}
|
|
else if (sTJYS.Trim().Equals("8"))
|
|
{
|
|
sTJYSMC = "付款期限";
|
|
}
|
|
else if (sTJYS.Trim().Equals("9"))
|
|
{
|
|
sTJYSMC = "导体材料&产品用途&电压等级分类&产品特性";
|
|
}
|
|
else if (sTJYS.Trim().Equals("A"))
|
|
{
|
|
sTJYSMC = "型号&规格&电压&标准";
|
|
}
|
|
else if (sTJYS.Trim().Equals("B"))
|
|
{
|
|
sTJYSMC = "销售单位";
|
|
}
|
|
else if (sTJYS.Trim().Equals("C"))
|
|
{
|
|
sTJYSMC = "产品目录&主芯截面范围&产品特性";
|
|
}
|
|
else if (sTJYS.Trim().Equals("D"))
|
|
{
|
|
sTJYSMC = "颜色&主芯截面范围";
|
|
}
|
|
else if (sTJYS.Trim().Equals("E"))
|
|
{
|
|
sTJYSMC = "型号&电压等级&主芯截面范围&报价数量区间";
|
|
}
|
|
else if (sTJYS.Trim().Equals("F"))
|
|
{
|
|
sTJYSMC = "导体材料&电压&芯线结构&报价数量区间加价/报价数量";
|
|
}
|
|
else if (sTJYS.Trim().Equals("G"))
|
|
{
|
|
sTJYSMC = "电压等级&芯线结构&导体材料&主芯截面范围&报价数量区间";
|
|
}
|
|
else if (sTJYS.Trim().Equals("H"))
|
|
{
|
|
sTJYSMC = "型号&电压等级&颜色&主芯截面范围&报价数量区间加价/报价数量";
|
|
}
|
|
else if (sTJYS.Trim().Equals("I"))
|
|
{
|
|
sTJYSMC = "工艺分类&导体类型&电压等级&主芯截面范围";
|
|
}
|
|
else if (sTJYS.Trim().Equals("J"))
|
|
{
|
|
sTJYSMC = "线缆特征类型&特征";
|
|
}
|
|
else if (sTJYS.Trim().Equals("K"))
|
|
{
|
|
sTJYSMC = "导体类型&电压等级/材料重量";
|
|
}
|
|
else if (sTJYS.Trim().Equals("M"))
|
|
{
|
|
sTJYSMC = "型号&电压等级&规格&报价数量区间";
|
|
}
|
|
else
|
|
{
|
|
|
|
}
|
|
|
|
TPageParams tpp = new TPageParams();
|
|
tpp.UrlPath = "TZYZ_JGBInfo.aspx";
|
|
tpp.CallAction = TPageCallAction.pcaInsert;
|
|
tpp.AddString("MXBH", "BJD");
|
|
tpp.AddString("TJYS", sTJYS);
|
|
tpp.AddString("TJYSMC", sTJYSMC);
|
|
OpenDialog(tpp);
|
|
}
|
|
|
|
protected void btnTJB_MenuItemClick(object sender, string ItemIndex)
|
|
{
|
|
if (grdContentGrid.SelectedIndex < 0)
|
|
{
|
|
ShowMessage("请选择处理记录！");
|
|
return;
|
|
}
|
|
string sJGBID = ItemIndex;
|
|
string sTJYS = grdContentGrid.DataKeys[grdContentGrid.SelectedIndex]["XLXSTZYZ_TJYS"].ToString();//不要trim()
|
|
string sTJYZID = grdContentGrid.DataKeys[grdContentGrid.SelectedIndex]["XLXSTZYZ_YZID"].ToString().Trim();
|
|
string sCLQDTX = grdContentGrid.DataKeys[grdContentGrid.SelectedIndex]["CLQDTX"].ToString().Trim();
|
|
|
|
JGBTZ(sJGBID, sTJYS, sTJYZID, sCLQDTX);
|
|
}
|
|
|
|
protected void btnBJFL_OnDropDown(object sender, EventArgs e)
|
|
{
|
|
if (grdContentGrid.SelectedIndex < 0)
|
|
{
|
|
ShowMessage("请选择一条记录！");
|
|
return;
|
|
}
|
|
string sTJYZID = grdContentGrid.DataKeys[grdContentGrid.SelectedIndex]["XLXSTZYZ_YZID"].ToString().Trim();
|
|
TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
|
|
TSQL SQL = new TSQL(dberp);
|
|
SQL.Clear();
|
|
SQL.Add(" select distinct XLXSBJFLYZ_BJFLID from XLXSBJFLYZ ");
|
|
SQL.Add(" left join XLXSTZYZ on XLXSTZYZ_YZID = XLXSBJFLYZ_YZID ");
|
|
SQL.Add(" where 1=1 ");
|
|
SQL.Add(" and XLXSBJFLYZ_YZID = :pXLXSBJFLYZ_YZID ");
|
|
SQL.Add(" and isnull(XLXSTZYZ_BCYTJ,'N') <> 'Y' ");
|
|
SQL.Add(" order by XLXSBJFLYZ_BJFLID ");
|
|
SQL.ParamByName("pXLXSBJFLYZ_YZID").Value = sTJYZID;
|
|
DataSet ds = dberp.OpenDataSet(SQL);
|
|
btnBJFL.Nodes.Clear();
|
|
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
|
|
{
|
|
SQL.Clear();
|
|
SQL.Add(" select XLXSBJFL_BJFLID,XLXSBJFL_BJFLMC from XLXSBJFL ");
|
|
SQL.Add(" where XLXSBJFL_BJFLID = :pXLXSBJFL_BJFLID ");
|
|
SQL.ParamByName("pXLXSBJFL_BJFLID").Value = ds.Tables[0].Rows[i]["XLXSBJFLYZ_BJFLID"].ToString().Trim();
|
|
DataSet dsBJFL = dberp.OpenDataSet(SQL);
|
|
if (dsBJFL.Tables[0].Rows.Count > 0)
|
|
btnBJFL.Nodes.Add(new N_CONTROL.gtTreeNode(dsBJFL.Tables[0].Rows[0]["XLXSBJFL_BJFLID"].ToString().Trim(), dsBJFL.Tables[0].Rows[0]["XLXSBJFL_BJFLID"].ToString().Trim() + "|" + dsBJFL.Tables[0].Rows[0]["XLXSBJFL_BJFLMC"].ToString().Trim()));
|
|
}
|
|
MenuAreaUpdate();
|
|
}
|
|
|
|
protected void btnBJFL_MenuItemClick(object sender, string ItemIndex)
|
|
{
|
|
if (grdContentGrid.SelectedIndex < 0)
|
|
{
|
|
ShowMessage("请选择处理记录！");
|
|
return;
|
|
}
|
|
string sBJFLID = ItemIndex;
|
|
|
|
TPageParams tpp = new TPageParams();
|
|
tpp.UMID = UMID;
|
|
tpp.UrlPath = "../Components/N_XLBJPZ/BJFLInfo.aspx";
|
|
tpp.CallAction = TPageCallAction.pcaBrowse;
|
|
tpp.AddString("XLXSBJFL_BJFLID", sBJFLID);
|
|
|
|
OpenFuncModuleDialog(102577001, tpp);
|
|
}
|
|
|
|
//关闭info页面自动刷新--sRefreshClientID
|
|
protected void btnGRWJGRefer_Click(object sender, EventArgs e)
|
|
{
|
|
int tmpIndex = grdContentGrid.SelectedIndex;
|
|
moduleGV_PageIndexChanging(null, null);
|
|
grdContentGrid.SelectedIndex = tmpIndex;
|
|
}
|
|
|
|
//跳转
|
|
protected void btnJGBTZ_Click(object sender, EventArgs e)
|
|
{
|
|
string sJGBID = txtJGBID.Value.Trim();
|
|
|
|
string sTJYS = txtTJYS.Value;
|
|
|
|
string sTJYZID = txtTJYZID.Value.Trim();
|
|
|
|
string sCLQDTX = txtCLQDTX.Value.Trim();
|
|
|
|
JGBTZ(sJGBID, sTJYS, sTJYZID, sCLQDTX);
|
|
|
|
}
|
|
|
|
#endregion
|
|
}
|
|
}
|