241 lines
9.5 KiB
C#
241 lines
9.5 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_MODEL.Page;
|
|
using GThinking.N_MISPRO.Data;
|
|
using System.Text;
|
|
using GThinking.N_MISPRO;
|
|
using GThinking.N_MISPRO.Utility;
|
|
using GThinking.N_CONTROL;
|
|
using System.IO;
|
|
using System.Collections.Generic;
|
|
using GThinking.N_MISPROAS;
|
|
|
|
namespace GThinking.N_XLXSBJ
|
|
{
|
|
public partial class XLBJD_PZGSList : SingleGridBase
|
|
{
|
|
XLBJD_PZGS entity = new XLBJD_PZGS();
|
|
Dictionary<string, string> ColumnNames = new Dictionary<string, string>();
|
|
|
|
protected void Page_Load(object sender, EventArgs e)
|
|
{
|
|
this.UMID = 100860000;
|
|
this.UMName = "线缆销售报价单";
|
|
this.CurMaster = Master;
|
|
this.ModuleGV = grdContentGrid;
|
|
this.CurEntity = entity;
|
|
this.sURLTarget = "XLBJD_PZGSInfo.aspx";
|
|
this.PageHeight = 500;
|
|
this.PageWidth = 700;
|
|
this.Master.EnableQueryBtn = false;
|
|
|
|
base.DataKeyNames = new string[] { "XLXSBJDDRZ_PZXH" };
|
|
|
|
base.InitPage();
|
|
|
|
if (!IsPostBack)
|
|
{
|
|
Master_OnStandardQuery(null, null);
|
|
}
|
|
}
|
|
|
|
#region 模板事件继承
|
|
protected override void Master_OnStandardQuery(object sender, EventArgs e)
|
|
{
|
|
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("XLXSBJDDRZ_PZXH", this.grdContentGrid.SelectedDataKey["XLXSBJDDRZ_PZXH"].ToString().Trim());
|
|
base.BeforeDelete(db, ref ActionIsDone);
|
|
}
|
|
|
|
protected override bool Master_AfterDeleteAction(object sender, EventArgs e)
|
|
{
|
|
if (!base.Master_AfterDeleteAction(sender, e)) return false;
|
|
|
|
entity.EntityTable.QuerySelSql = GetSQL();
|
|
entity.GridDataBind(grdContentGrid, tSession);
|
|
grdContentGrid.SelectedIndex = -1;
|
|
return true;
|
|
}
|
|
|
|
protected override void moduleGV_RowDataBound(object sender, GridViewRowEventArgs e)
|
|
{
|
|
if (e.Row.RowType == DataControlRowType.DataRow)
|
|
{
|
|
LinkPageParam.AddString("XLXSBJDDRZ_PZXH", grdContentGrid.DataKeys[e.Row.RowIndex]["XLXSBJDDRZ_PZXH"].ToString().Trim());
|
|
}
|
|
|
|
base.moduleGV_RowDataBound(sender, e);
|
|
}
|
|
|
|
protected override void moduleGV_PageIndexChanging(object sender, GridViewPageEventArgs e)
|
|
{
|
|
entity.EntityTable.QuerySelSql = GetSQL();
|
|
grdContentGrid.SelectedIndex = -1;
|
|
|
|
base.moduleGV_PageIndexChanging(sender, e);
|
|
}
|
|
|
|
protected override void AfterDelete(TDatabase db, ref bool ActionIsDone)
|
|
{
|
|
base.AfterDelete(db, ref ActionIsDone);
|
|
|
|
db.ExecSQL(string.Format("delete from XLXSBJDDR where XLXSBJDDR_PZXH={0}", this.grdContentGrid.SelectedDataKey["XLXSBJDDRZ_PZXH"].ToString().Trim()));
|
|
}
|
|
|
|
#endregion
|
|
|
|
#region 自定义函数
|
|
|
|
private string GetSQL()
|
|
{
|
|
StringBuilder sSQL = new StringBuilder();
|
|
sSQL.AppendLine("select XLXSBJDDRZ_PZXH,XLXSBJDDRZ_PZMC,XLXSBJDDRZ_BZ,XLXSBJDDRZ_WHR,XLXSBJDDRZ_WHRID,XLXSBJDDRZ_WHSJ ");
|
|
sSQL.AppendLine("from XLXSBJDDRZ ");
|
|
sSQL.AppendLine("where 1=1 ");
|
|
sSQL.AppendLine("order by XLXSBJDDRZ_PZXH");
|
|
return sSQL.ToString();
|
|
}
|
|
|
|
#endregion
|
|
|
|
#region 按钮事件
|
|
|
|
protected void btnMX_OnDropDown(object sender, EventArgs e)
|
|
{
|
|
if (grdContentGrid.SelectedIndex < 0)
|
|
{
|
|
return;
|
|
}
|
|
btnMX.Nodes.Clear();
|
|
double dPZXH = CMISproConvert.StrToFloat(grdContentGrid.DataKeys[grdContentGrid.SelectedIndex]["XLXSBJDDRZ_PZXH"].ToString().Trim());
|
|
TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
|
|
TSQL SQL = new TSQL(dberp);
|
|
SQL.Add("select XLXSBJDDR_PZXH,XLXSBJDDR_EXCELLM,XLXSBJDDR_BJLM ");
|
|
SQL.Add("from XLXSBJDDR ");
|
|
SQL.Add("where XLXSBJDDR_PZXH=:XLXSBJDDR_PZXH ");
|
|
SQL.Add("order by XLXSBJDDR_BJLM ");
|
|
SQL.ParamByName("XLXSBJDDR_PZXH").Value = dPZXH;
|
|
DataSet ds = dberp.OpenDataSet(SQL);
|
|
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
|
|
{
|
|
string sEXCELLM = ds.Tables[0].Rows[i]["XLXSBJDDR_EXCELLM"].ToString().Trim();
|
|
string sBJLM = ds.Tables[0].Rows[i]["XLXSBJDDR_BJLM"].ToString().Trim();
|
|
string sBJLMMC = "";
|
|
if (sBJLM.Equals("1"))
|
|
sBJLMMC = "型号";
|
|
else if (sBJLM.Equals("2"))
|
|
sBJLMMC = "规格";
|
|
else if (sBJLM.Equals("3"))
|
|
sBJLMMC = "电压等级";
|
|
else if (sBJLM.Equals("4"))
|
|
sBJLMMC = "标准";
|
|
else if (sBJLM.Equals("5"))
|
|
sBJLMMC = "颜色";
|
|
else if (sBJLM.Equals("6"))
|
|
sBJLMMC = "计量单位";
|
|
else if (sBJLM.Equals("7"))
|
|
sBJLMMC = "报价数量";
|
|
else if (sBJLM.Equals("8"))
|
|
sBJLMMC = "报价";
|
|
else if (sBJLM.Equals("9"))
|
|
sBJLMMC = "调整后报价金额";
|
|
else if (sBJLM.Equals("10"))
|
|
sBJLMMC = "型号-规格";
|
|
else if (sBJLM.Equals("11"))
|
|
sBJLMMC = "型号-电压等级 规格";
|
|
else if (sBJLM.Equals("12"))
|
|
sBJLMMC = "备注";
|
|
else
|
|
sBJLMMC = sBJLM;
|
|
|
|
string sText = sEXCELLM + "|" + sBJLMMC;
|
|
btnMX.Nodes.Add(new gtTreeNode(sEXCELLM, sText));
|
|
}
|
|
MenuAreaUpdate();
|
|
}
|
|
|
|
protected void btnMX_Click(object sender, EventArgs e)
|
|
{
|
|
if (grdContentGrid.SelectedIndex < 0)
|
|
{
|
|
ShowMessage("请选择处理记录！");
|
|
return;
|
|
}
|
|
|
|
TPageParams tpp = new TPageParams();
|
|
tpp.UrlPath = "XLBJD_PZGSMXInfo.aspx";
|
|
tpp.CallAction = TPageCallAction.pcaInsert;
|
|
tpp.AddString("PZXH", grdContentGrid.DataKeys[grdContentGrid.SelectedIndex]["XLXSBJDDRZ_PZXH"].ToString().Trim());
|
|
OpenDialog(tpp);
|
|
}
|
|
|
|
protected void btnMX_MenuItemClick(object sender, string ItemIndex)
|
|
{
|
|
if (grdContentGrid.SelectedIndex < 0)
|
|
{
|
|
ShowMessage("请选择处理记录！");
|
|
return;
|
|
}
|
|
string sEXCELLM = ItemIndex;
|
|
|
|
TPageParams tpp = new TPageParams();
|
|
tpp.UrlPath = "XLBJD_PZGSMXInfo.aspx";
|
|
tpp.CallAction = TPageCallAction.pcaBrowse;
|
|
tpp.AddString("XLXSBJDDR_PZXH", grdContentGrid.DataKeys[grdContentGrid.SelectedIndex]["XLXSBJDDRZ_PZXH"].ToString().Trim());
|
|
tpp.AddString("XLXSBJDDR_EXCELLM", sEXCELLM);
|
|
OpenDialog(tpp);
|
|
}
|
|
|
|
protected void btnDR_Click(object sender, EventArgs e)
|
|
{
|
|
if (grdContentGrid.SelectedIndex < 0)
|
|
{
|
|
ShowMessage("请选择处理记录！");
|
|
return;
|
|
}
|
|
|
|
TPageParams pageParams2 = new TPageParams();
|
|
pageParams2.UrlPath = "XLBJD_DR.aspx";
|
|
pageParams2.AddString("BJRQ", PageParam.GetRTrimString("BJRQ"));
|
|
pageParams2.AddString("BJFLID", PageParam.GetRTrimString("BJFLID"));
|
|
pageParams2.AddString("BJDID", PageParam.GetRTrimString("BJDID"));
|
|
pageParams2.AddString("JGBID", PageParam.GetRTrimString("JGBID"));
|
|
pageParams2.AddString("JGCIDS", PageParam.GetRTrimString("JGCIDS"));
|
|
pageParams2.AddString("BJLY", PageParam.GetRTrimString("BJLY"));
|
|
pageParams2.AddString("XSQYID", PageParam.GetRTrimString("XSQYID"));
|
|
pageParams2.AddString("PJLX", PageParam.GetRTrimString("PJLX"));
|
|
pageParams2.AddString("FKQXNR", PageParam.GetRTrimString("FKQXNR"));
|
|
pageParams2.AddString("SYDWID", PageParam.GetRTrimString("SYDWID"));
|
|
pageParams2.AddString("HSBZ", PageParam.GetRTrimString("HSBZ"));
|
|
pageParams2.AddString("JCLLX", PageParam.GetRTrimString("JCLLX"));
|
|
pageParams2.AddString("LJJCLLX", PageParam.GetRTrimString("LJJCLLX"));
|
|
pageParams2.AddString("NeedUpdBJDHQCLCB", PageParam.GetRTrimString("NeedUpdBJDHQCLCB"));
|
|
pageParams2.AddString("PZXH", grdContentGrid.DataKeys[grdContentGrid.SelectedIndex]["XLXSBJDDRZ_PZXH"].ToString().Trim());
|
|
pageParams2.AddString("BJDHQLY", PageParam.GetRTrimString("BJDHQLY"));
|
|
pageParams2.AddString("TBJCLID", PageParam.GetRTrimString("TBJCLID"));
|
|
pageParams2.AddString("LBJCLID", PageParam.GetRTrimString("LBJCLID"));
|
|
pageParams2.AddString("TJ", PageParam.GetRTrimString("TJ"));
|
|
pageParams2.AddString("LJ", PageParam.GetRTrimString("LJ"));
|
|
pageParams2.AddString("CPBJMRXSWS", PageParam.GetRTrimString("CPBJMRXSWS"));
|
|
pageParams2.AddString("ZDXJJCLLX", PageParam.GetRTrimString("ZDXJJCLLX"));
|
|
OpenDialog(pageParams2);
|
|
}
|
|
|
|
#endregion
|
|
}
|
|
}
|