1089 lines
54 KiB
C#
1089 lines
54 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_MODEL.Page;
|
|
using GThinking.N_MISPRO.Data;
|
|
using GThinking.N_PUBLIC;
|
|
using System.Text;
|
|
using GThinking.N_MISPRO.Utility;
|
|
using GThinking.N_CONTROL;
|
|
using GThinking.N_MISPRO.TableCache;
|
|
|
|
namespace GThinking.N_XLXSBJ
|
|
{
|
|
public partial class TZYZJJ8List : SingleGridBase
|
|
{
|
|
TZYZJJ8 entity = new TZYZJJ8();
|
|
TZYZJJ8_M qryEntity = new TZYZJJ8_M();
|
|
DataSet dsTJYS8 = new DataSet();
|
|
|
|
protected void Page_Load(object sender, EventArgs e)
|
|
{
|
|
this.UMID = 100860096;
|
|
this.UMName = "按材料重量每吨加价调表价";
|
|
this.CurMaster = Master;
|
|
this.ModuleGV = ContentGrid;
|
|
this.CurEntity = entity;
|
|
this.CurQueryEntity = qryEntity;
|
|
this.sURLTarget = "TZYZJJ8Info.aspx";
|
|
this.sQueryURLTarget = "TZYZJJ8Query.aspx";
|
|
this.PageHeight = 600;
|
|
this.PageWidth = 750;
|
|
|
|
base.DataKeyNames = new string[] { "XLXSJGBYZZ8_JGBID", "XLXSJGBYZZ8_XLXHID", "XLXSJGBYZZ8_XLGGID", "XLXSJGBYZZ8_XLBZID", "XLXSJGBYZZ8_DYDJID", "minYZID" };
|
|
|
|
ContentGrid.FindColumnByFieldName("XLXSJGBYZZ8_JGBID").Visible = false;
|
|
|
|
if (!IsPostBack)
|
|
{
|
|
if (!PageParam.GetRTrimString("JGBID").Equals(""))
|
|
CurQueryEntity.FieldByName("JGBID").Value = PageParam.GetRTrimString("JGBID");
|
|
else
|
|
CurQueryEntity.FieldByName("JGBID").Value = GetDefaultJGBID();
|
|
CurQueryEntity.FieldByName("XLXHIDJQPP").Value = "True";
|
|
if (!PageParam.GetRTrimString("XLXHID").Equals(""))
|
|
CurQueryEntity.FieldByName("XLXHID").Value = PageParam.GetRTrimString("XLXHID");
|
|
}
|
|
|
|
CanDeleteCheckedRows = true;
|
|
base.InitPage();
|
|
InitControl();
|
|
if (!IsPostBack)
|
|
{
|
|
if (!PageParam.GetRTrimString("JGBID").Equals(""))
|
|
Master_OnStandardQuery(null, null);
|
|
else
|
|
{
|
|
if (IsDefaultExecute)
|
|
Master_OnStandardQuery(null, null);
|
|
else
|
|
{
|
|
setBtnVisibled(CurQueryEntity.FieldByName("JGBID").Value.Trim());
|
|
this.Master.StandardNewButton.OnClientClick = "alert('请先查询调价表！');";
|
|
this.Master.StandardCopyButton.OnClientClick = "alert('请先查询调价表！');";
|
|
}
|
|
}
|
|
|
|
}
|
|
|
|
}
|
|
|
|
#region 模板事件继承
|
|
protected override void Master_OnStandardQuery(object sender, EventArgs e)
|
|
{
|
|
entity.EntityTable.QuerySelSql = GetSQL();
|
|
base.Master_OnStandardQuery(sender, e);
|
|
entity.GridDataBind(ContentGrid, tSession);
|
|
|
|
if (CurQueryEntity.FieldByName("JGBID").Value.Trim().Equals(""))
|
|
{
|
|
this.Master.StandardNewButton.OnClientClick = "alert('请先查询调价表！');";
|
|
this.Master.StandardCopyButton.OnClientClick = "alert('请先查询调价表！');";
|
|
}
|
|
else
|
|
{
|
|
this.Master.StandardNewButton.OnClientClick = "OpenCardForm('INSERT');return false;";
|
|
this.Master.StandardCopyButton.OnClientClick = "OpenCardForm('COPY');return false;";
|
|
}
|
|
setBtnVisibled(CurQueryEntity.FieldByName("JGBID").Value.Trim());
|
|
TPageParams pageParams = new TPageParams();
|
|
pageParams.AddString("XLXSJGBYZZ8_JGBID", CurQueryEntity.FieldByName("JGBID").Value.Trim());
|
|
pageParams.AddString("TJYZList", txtTJYZList.Value.Trim());
|
|
pageParams.AddString("FirstYZID", txtFirstYZID.Value.Trim());
|
|
if (!PageParam.GetRTrimString("XLXHID").Equals(""))
|
|
pageParams.AddString("XLXHID", PageParam.GetRTrimString("XLXHID").Trim());
|
|
SetNewFormParam(pageParams);
|
|
}
|
|
|
|
protected override void BeforeDelete(TDatabase db, ref bool ActionIsDone)
|
|
{
|
|
string sYZIDlist = TZYZBJAInfo.GetYZIDList(txtTJYZList.Value.Trim());
|
|
entity.EntityTable.DeleteSql = " delete from XLXSJGBYZZ8 where XLXSJGBYZZ8_JGBID=:XLXSJGBYZZ8_JGBID and XLXSJGBYZZ8_XLXHID =:XLXSJGBYZZ8_XLXHID and XLXSJGBYZZ8_XLGGID =:XLXSJGBYZZ8_XLGGID and XLXSJGBYZZ8_XLBZID=:XLXSJGBYZZ8_XLBZID and XLXSJGBYZZ8_DYDJID=:XLXSJGBYZZ8_DYDJID and "
|
|
+ CMISproDataBase.GetWhereEqual("XLXSJGBYZZ8_YZID", sYZIDlist);
|
|
entity.Param.Add("XLXSJGBYZZ8_JGBID", this.ContentGrid.SelectedDataKey["XLXSJGBYZZ8_JGBID"].ToString().Trim());
|
|
entity.Param.Add("XLXSJGBYZZ8_XLXHID", this.ContentGrid.SelectedDataKey["XLXSJGBYZZ8_XLXHID"].ToString().Trim());
|
|
entity.Param.Add("XLXSJGBYZZ8_XLGGID", this.ContentGrid.SelectedDataKey["XLXSJGBYZZ8_XLGGID"].ToString().Trim());
|
|
entity.Param.Add("XLXSJGBYZZ8_XLBZID", this.ContentGrid.SelectedDataKey["XLXSJGBYZZ8_XLBZID"].ToString().Trim());
|
|
entity.Param.Add("XLXSJGBYZZ8_DYDJID", this.ContentGrid.SelectedDataKey["XLXSJGBYZZ8_DYDJID"].ToString());
|
|
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(ContentGrid, tSession);
|
|
ContentGrid.SelectedIndex = -1;
|
|
return true;
|
|
}
|
|
|
|
protected override void moduleGV_PageIndexChanging(object sender, GridViewPageEventArgs e)
|
|
{
|
|
entity.EntityTable.QuerySelSql = GetSQL();
|
|
ContentGrid.SelectedIndex = -1;
|
|
|
|
base.moduleGV_PageIndexChanging(sender, e);
|
|
}
|
|
|
|
protected override void moduleGV_RowDataBound(object sender, GridViewRowEventArgs e)
|
|
{
|
|
if (e.Row.RowType == DataControlRowType.DataRow)
|
|
{
|
|
LinkPageParam.AddString("XLXSJGBYZZ8_JGBID", ContentGrid.DataKeys[e.Row.RowIndex]["XLXSJGBYZZ8_JGBID"].ToString().Trim());
|
|
LinkPageParam.AddString("XLXSJGBYZZ8_XLXHID", ContentGrid.DataKeys[e.Row.RowIndex]["XLXSJGBYZZ8_XLXHID"].ToString().Trim());
|
|
LinkPageParam.AddString("XLXSJGBYZZ8_XLGGID", ContentGrid.DataKeys[e.Row.RowIndex]["XLXSJGBYZZ8_XLGGID"].ToString().Trim());
|
|
LinkPageParam.AddString("XLXSJGBYZZ8_XLBZID", ContentGrid.DataKeys[e.Row.RowIndex]["XLXSJGBYZZ8_XLBZID"].ToString().Trim());
|
|
LinkPageParam.AddString("XLXSJGBYZZ8_DYDJID", ContentGrid.DataKeys[e.Row.RowIndex]["XLXSJGBYZZ8_DYDJID"].ToString());
|
|
LinkPageParam.AddString("XLXSJGBYZZ8_YZID", ContentGrid.DataKeys[e.Row.RowIndex]["minYZID"].ToString().Trim());
|
|
LinkPageParam.AddString("TJYZList", txtTJYZList.Value.Trim());
|
|
}
|
|
|
|
base.moduleGV_RowDataBound(sender, e);
|
|
}
|
|
|
|
|
|
|
|
#endregion
|
|
|
|
#region 自定义函数
|
|
private void InitControl()
|
|
{
|
|
if (PageParam.ContainsKey("SQDH"))
|
|
{
|
|
if (!IsPostBack)//首次打开需要补上这一段，否则按钮还是可用状态
|
|
{
|
|
Master.RightNewBtn = false;
|
|
Master.RightCopyBtn = false;
|
|
Master.RightViewBtn = false;
|
|
Master.RightEditBtn = false;
|
|
Master.RightDeleteBtn = false;
|
|
}
|
|
Master.StandardNewButton.Enabled = false;
|
|
Master.StandardCopyButton.Enabled = false;
|
|
Master.StandardEditButton.Enabled = false;
|
|
Master.StandardDeleteButton.Enabled = false;
|
|
Master.StandardViewButton.Enabled = false;
|
|
btnDRWJ.Visible = false;
|
|
btnPLSZ.Visible = false;
|
|
}
|
|
else
|
|
{
|
|
btnPLSZ1.Visible = false;
|
|
}
|
|
}
|
|
|
|
private bool XSWHR()
|
|
{
|
|
if (!PageParam.GetRTrimString("TJYZID").Equals("") && (!PageParam.GetRTrimString("TJYZID").Contains(",")) && string.IsNullOrEmpty(PageParam.GetRTrimString("SQDH")))
|
|
return true;
|
|
return false;
|
|
}
|
|
|
|
//判断模块是否存在并且是否有权限
|
|
private bool CheckModule(string sUMID)
|
|
{
|
|
int iUMID = CMISproConvert.StrToInt(sUMID);
|
|
UserRight UR = OpRightUtils.GetUserRight(tSession.UserId, iUMID);
|
|
return (DSActiveModule.IsActiveModule(iUMID) && UR.Open);
|
|
}
|
|
|
|
private string GetSQL()
|
|
{
|
|
base.InitEntityByCondition();
|
|
InitGridView();
|
|
string sYZIDlist = TZYZBJAInfo.GetYZIDList(txtTJYZList.Value.Trim());
|
|
StringBuilder sSQL = new StringBuilder();
|
|
sSQL.AppendLine("select :pJGBID as XLXSJGBYZZ8_JGBID,XLXSJGBYZZ8_XLXHID,XLXSJGBYZZ8_XLGGID,XLXSJGBYZZ8_XLBZID,RTRIM(XLXSJGBYZZ8_XLBZID)|| '|' || XLBZ_XLBZLXMC as XLBZ,XLXSJGBYZZ8_DYDJID");
|
|
sSQL.AppendLine(" ,minYZID");
|
|
if (XSWHR())
|
|
{
|
|
sSQL.AppendLine(" , WHR, WHSJ ");
|
|
}
|
|
else
|
|
{
|
|
sSQL.AppendLine(" ,' ' as WHR, ' ' as WHSJ ");
|
|
}
|
|
for (int i = 0; i < dsTJYS8.Tables[0].Rows.Count; i++)
|
|
{
|
|
sSQL.AppendLine(string.Format(",TZYZ_{0}", dsTJYS8.Tables[0].Rows[i][0].ToString().Trim()));
|
|
}
|
|
sSQL.AppendLine(" from ");
|
|
sSQL.AppendLine(" ( ");
|
|
sSQL.AppendLine(" select XLXSJGBYZZ8_XLXHID,XLXSJGBYZZ8_XLGGID,XLXSJGBYZZ8_XLBZID,XLXSJGBYZZ8_DYDJID,min(XLXSJGBYZZ8_YZID) as minYZID ");
|
|
if (XSWHR())
|
|
{
|
|
sSQL.AppendLine(" ,WHR,WHSJ ");
|
|
}
|
|
for (int i = 0; i < dsTJYS8.Tables[0].Rows.Count; i++)
|
|
{
|
|
sSQL.AppendLine(string.Format(",sum(CASE XLXSJGBYZZ8_YZID WHEN '{0}' THEN XLXSJGBYZZ8_YZZ ELSE 0 END) as TZYZ_{0}", dsTJYS8.Tables[0].Rows[i][0].ToString().Trim()));
|
|
}
|
|
sSQL.AppendLine(" from ");
|
|
sSQL.AppendLine(" (");
|
|
sSQL.AppendLine(" select distinct XLXSJGBYZZ8_XLXHID,XLXSJGBYZZ8_XLGGID,XLXSJGBYZZ8_XLBZID,XLXSJGBYZZ8_DYDJID,XLXSJGBYZZ8_YZID,XLXSJGBYZZ8_YZZ");
|
|
if (XSWHR())
|
|
{
|
|
sSQL.AppendLine(" ,XLXSJGBYZZ8_WHR as WHR,XLXSJGBYZZ8_WHSJ as WHSJ ");
|
|
}
|
|
if (PageParam.ContainsKey("SQDH"))
|
|
{
|
|
sSQL.AppendLine(" from ( ");
|
|
sSQL.AppendLine(" select :pJGBID as XLXSJGBYZZ8_JGBID,XLXSBJYLZDMX_XLXHID as XLXSJGBYZZ8_XLXHID, ");
|
|
sSQL.AppendLine(" XLXSBJYLZDMX_XLGGID as XLXSJGBYZZ8_XLGGID,XLXSBJYLZDMX_XLBZID as XLXSJGBYZZ8_XLBZID,XLXSBJYLZDMX_DYDJID as XLXSJGBYZZ8_DYDJID, ");
|
|
sSQL.AppendLine(" case when isnull(XLXSJGBYZZ8_YZID,' ') = ' ' then 'JZ08' else XLXSJGBYZZ8_YZID end as XLXSJGBYZZ8_YZID,XLXSJGBYZZ8_YZZ");
|
|
sSQL.AppendLine(" from ( select distinct ");
|
|
sSQL.AppendLine(" XLXSBJYLZDMX_XLXHID,XLXSBJYLZDMX_XLGGID,XLXSBJYLZDMX_XLBZID,XLXSBJYLZDMX_DYDJID,XLXSJGBYZZ8_JGBID,XLXSJGBYZZ8_YZID,isnull(XLXSJGBYZZ8_YZZ,0) as XLXSJGBYZZ8_YZZ ");
|
|
sSQL.AppendLine(" from XLXSBJYLZDMX ");
|
|
sSQL.AppendLine(" left join XLXSJGBYZZ8 on XLXSJGBYZZ8_XLXHID = XLXSBJYLZDMX_XLXHID and XLXSJGBYZZ8_XLGGID = XLXSBJYLZDMX_XLGGID ");
|
|
sSQL.AppendLine(" and XLXSJGBYZZ8_XLBZID = XLXSBJYLZDMX_XLBZID and XLXSJGBYZZ8_DYDJID =XLXSBJYLZDMX_DYDJID and XLXSJGBYZZ8_JGBID = :pJGBID ");
|
|
if (!string.IsNullOrEmpty(sYZIDlist))
|
|
{
|
|
sSQL.AppendLine(" and " + CMISproDataBase.GetWhereEqual("XLXSJGBYZZ8_YZID", sYZIDlist));
|
|
}
|
|
sSQL.AppendLine(" where XLXSBJYLZDMX_SQDH = :pSQDH ");
|
|
sSQL.AppendLine(" ) ab ) YZZ1");
|
|
entity.Param.Add("pSQDH", PageParam.GetRTrimString("SQDH"));
|
|
}
|
|
else
|
|
sSQL.AppendLine(" from XLXSJGBYZZ8 YZZ1");
|
|
if (string.IsNullOrEmpty(CurQueryEntity.FieldByName("JGBID").Value.Trim()))
|
|
{
|
|
sSQL.AppendLine(" where 1<>1 ");
|
|
}
|
|
else
|
|
{
|
|
sSQL.AppendLine(" where YZZ1.XLXSJGBYZZ8_JGBID = :pJGBID ");
|
|
}
|
|
//型号模糊
|
|
if (!CurQueryEntity.FieldByName("XLXHIDJQPP").Value.ToString().Trim().ToUpper().Equals("TRUE"))
|
|
{
|
|
if (!string.IsNullOrEmpty(CurQueryEntity.FieldByName("XLXHID").Value.Trim()))
|
|
{
|
|
sSQL.AppendLine(" and YZZ1.XLXSJGBYZZ8_XLXHID like :pXLXHID ");
|
|
entity.Param.Add("pXLXHID", "%" + CurQueryEntity.FieldByName("XLXHID").Value.Trim() + "%");
|
|
}
|
|
}
|
|
else
|
|
{
|
|
string sXLXHID = CurQueryEntity.FieldByName("XLXHID").Value.Trim();
|
|
if (!string.IsNullOrEmpty(sXLXHID))
|
|
{
|
|
string[] sTemp = sXLXHID.Split(new Char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
|
|
if (sTemp.Length >= 2)
|
|
{
|
|
sSQL.AppendLine(" and " + CMISproDataBase.GetWhereEqual("YZZ1.XLXSJGBYZZ8_XLXHID", sXLXHID));
|
|
}
|
|
else
|
|
{
|
|
sSQL.AppendLine(" and YZZ1.XLXSJGBYZZ8_XLXHID = :pXLXHID ");
|
|
entity.Param.Add("pXLXHID", sXLXHID);
|
|
}
|
|
}
|
|
}
|
|
if (!string.IsNullOrEmpty(CurQueryEntity.FieldByName("DYDJID").Value.Trim()))
|
|
{
|
|
sSQL.AppendLine(" and " + CMISproDataBase.GetWhereEqual("YZZ1.XLXSJGBYZZ8_DYDJID", CurQueryEntity.FieldByName("DYDJID").Value.Trim()));
|
|
}
|
|
if (!string.IsNullOrEmpty(CurQueryEntity.FieldByName("XLGG").Value.Trim()))
|
|
{
|
|
sSQL.AppendLine(" and YZZ1.XLXSJGBYZZ8_XLGGID like :pXLGGID ");
|
|
entity.Param.Add("pXLGGID", "%" + CurQueryEntity.FieldByName("XLGG").Value.Trim() + "%");
|
|
}
|
|
if (!string.IsNullOrEmpty(CurQueryEntity.FieldByName("XLBZID").Value.Trim()))
|
|
{
|
|
sSQL.AppendLine(" and YZZ1.XLXSJGBYZZ8_XLBZID = :pXLBZID ");
|
|
entity.Param.Add("pXLBZID", CurQueryEntity.FieldByName("XLBZID").Value.Trim());
|
|
}
|
|
|
|
if (!string.IsNullOrEmpty(sYZIDlist))
|
|
{
|
|
sSQL.AppendLine(" and " + CMISproDataBase.GetWhereEqual("YZZ1.XLXSJGBYZZ8_YZID", sYZIDlist));
|
|
}
|
|
sSQL.AppendLine(" ) tmp");
|
|
sSQL.AppendLine(" group by XLXSJGBYZZ8_XLXHID,XLXSJGBYZZ8_XLGGID,XLXSJGBYZZ8_XLBZID,XLXSJGBYZZ8_DYDJID");
|
|
if (XSWHR())
|
|
{
|
|
sSQL.AppendLine(" , WHR, WHSJ ");
|
|
}
|
|
sSQL.AppendLine(" ) a ");
|
|
sSQL.AppendLine(" left join XLBZ on XLBZ_XLBZID=XLXSJGBYZZ8_XLBZID ");
|
|
sSQL.AppendLine(" where 1=1 ");
|
|
sSQL.AppendLine(" order by XLXSJGBYZZ8_XLXHID,XLXSJGBYZZ8_XLGGID,XLXSJGBYZZ8_XLBZID,XLXSJGBYZZ8_DYDJID");
|
|
entity.Param.Add("pJGBID", CurQueryEntity.FieldByName("JGBID").Value.Trim());
|
|
return sSQL.ToString();
|
|
}
|
|
|
|
private void InitGridView()
|
|
{
|
|
TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
|
|
TSQL SQL = new TSQL(dberp);
|
|
|
|
SQL.Clear();
|
|
SQL.Add("select XLXSTZYZ_YZID, XLXSTZYZ_YZMC, XLXSTZYZ_JJFS ");
|
|
SQL.Add(" from XLXSTZYZ");
|
|
SQL.Add(" where XLXSTZYZ_MXBH = 'JZJ' and XLXSTZYZ_TJYS='8' ");
|
|
SQL.Add(" and XLXSTZYZ_JGBID = :pJGBID");
|
|
if (!string.IsNullOrEmpty(PageParam.GetRTrimString("TJYZID")))
|
|
{
|
|
SQL.Add(" and " + CMISproDataBase.GetWhereEqual("XLXSTZYZ_YZID", PageParam.GetRTrimString("TJYZID").Trim()));
|
|
}
|
|
SQL.Add("order by XLXSTZYZ_YZID,XLXSTZYZ_XSXH");
|
|
SQL.ParamByName("pJGBID").Value = CurQueryEntity.FieldByName("JGBID").Value.Trim();
|
|
DataSet ds = dberp.OpenDataSet(SQL);
|
|
dsTJYS8 = ds;
|
|
txtTJYZList.Value = "";
|
|
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
|
|
{
|
|
if (i == 0)
|
|
txtFirstYZID.Value = ds.Tables[0].Rows[i]["XLXSTZYZ_YZID"].ToString().Trim();
|
|
|
|
string sJJFSMC = "";
|
|
int iXSWS = 2;
|
|
//加价类型的基价因子小数位数按BJU002设置的来
|
|
if (ds.Tables[0].Rows[i]["XLXSTZYZ_JJFS"].ToString().Trim().Equals("JJ"))
|
|
{
|
|
//iXSWS = CMISproConvert.StrToInt(GetOption("BJU002"));
|
|
iXSWS = 5;
|
|
sJJFSMC = "(元)";
|
|
}
|
|
else if (ds.Tables[0].Rows[i]["XLXSTZYZ_JJFS"].ToString().Trim().Equals("JD") || ds.Tables[0].Rows[i]["XLXSTZYZ_JJFS"].ToString().Trim().Equals("KD"))
|
|
{
|
|
sJJFSMC = "(%)";
|
|
}
|
|
AddColumn("TZYZ_" + ds.Tables[0].Rows[i]["XLXSTZYZ_YZID"].ToString().Trim(), ds.Tables[0].Rows[i]["XLXSTZYZ_YZMC"].ToString().Trim() + sJJFSMC, iXSWS, 80);
|
|
txtTJYZList.Value += ds.Tables[0].Rows[i]["XLXSTZYZ_YZID"].ToString().Trim() + "|" + ds.Tables[0].Rows[i]["XLXSTZYZ_YZMC"].ToString().Trim() + sJJFSMC + ",";
|
|
}
|
|
txtTJYZList.Value = txtTJYZList.Value.TrimEnd(',');
|
|
if (XSWHR())
|
|
{
|
|
AddColumn("WHR", "维护人", 72);
|
|
AddColumn("WHSJ", "维护时间", TDateTimeEditKinds.dtDateTime);
|
|
}
|
|
}
|
|
|
|
private string GetDefaultJGBID()
|
|
{
|
|
TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
|
|
TSQL SQL = new TSQL(dberp);
|
|
SQL.Add("SELECT XLXSJGB_JGBID from XLXSJGB where XLXSJGB_MXBH='JZJ' and XLXSJGB_TJYS='1' order by XLXSJGB_JGBID");
|
|
DataSet ds = dberp.OpenDataSet(SQL);
|
|
if (ds.Tables[0].Rows.Count > 0)
|
|
{
|
|
return ds.Tables[0].Rows[0][0].ToString().Trim();
|
|
}
|
|
else
|
|
return "";
|
|
}
|
|
|
|
public static string GetTJYZMC(string sTJYZID, string sMXBH)
|
|
{
|
|
string sTJYZMC = "";
|
|
TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
|
|
TSQL SQL = new TSQL(dberp);
|
|
SQL.Clear();
|
|
SQL.Add(" select XLXSTZYZ_YZMC from XLXSTZYZ where XLXSTZYZ_MXBH = :pMXBH and XLXSTZYZ_YZID = :pYZID ");
|
|
SQL.ParamByName("pMXBH").Value = sMXBH;
|
|
SQL.ParamByName("pYZID").Value = sTJYZID;
|
|
DataSet ds = dberp.OpenDataSet(SQL);
|
|
if (ds.Tables[0].Rows.Count > 0)
|
|
{
|
|
sTJYZMC = ds.Tables[0].Rows[0]["XLXSTZYZ_YZMC"].ToString().Trim();
|
|
}
|
|
return sTJYZMC;
|
|
}
|
|
|
|
private void setBtnVisibled(string sJGBID)
|
|
{
|
|
if (!string.IsNullOrEmpty(PageParam.GetRTrimString("XLJGBID")) && PageParam.GetRTrimString("JGBID").Equals(sJGBID))
|
|
btnTBZJGB.Visible = true;
|
|
else
|
|
btnTBZJGB.Visible = false;
|
|
}
|
|
|
|
private void OpenInfo(TPageCallAction tpCallAction)
|
|
{
|
|
TPageParams LinkPageParam = new TPageParams();
|
|
LinkPageParam.UrlPath = "TZYZJJ8Info.aspx";
|
|
LinkPageParam.AddString("XLXSJGBYZZ8_JGBID", ContentGrid.DataKeys[ContentGrid.SelectedIndex]["XLXSJGBYZZ8_JGBID"].ToString().Trim());
|
|
LinkPageParam.AddString("XLXSJGBYZZ8_XLXHID", ContentGrid.DataKeys[ContentGrid.SelectedIndex]["XLXSJGBYZZ8_XLXHID"].ToString().Trim());
|
|
LinkPageParam.AddString("XLXSJGBYZZ8_XLGGID", ContentGrid.DataKeys[ContentGrid.SelectedIndex]["XLXSJGBYZZ8_XLGGID"].ToString().Trim());
|
|
LinkPageParam.AddString("XLXSJGBYZZ8_XLBZID", ContentGrid.DataKeys[ContentGrid.SelectedIndex]["XLXSJGBYZZ8_XLBZID"].ToString().Trim());
|
|
LinkPageParam.AddString("XLXSJGBYZZ8_DYDJID", ContentGrid.DataKeys[ContentGrid.SelectedIndex]["XLXSJGBYZZ8_DYDJID"].ToString());
|
|
LinkPageParam.AddString("XLXSJGBYZZ8_YZID", ContentGrid.DataKeys[ContentGrid.SelectedIndex]["minYZID"].ToString().Trim());
|
|
LinkPageParam.AddString("TJYZList", txtTJYZList.Value.Trim());
|
|
if (PageParam.ContainsKey("BJDID"))
|
|
LinkPageParam.AddString("BJDID", PageParam.GetRTrimString("BJDID"));
|
|
if (tpCallAction == TPageCallAction.pcaInsert)
|
|
{
|
|
LinkPageParam.AddString("CLYLZDSZ", "Y");
|
|
}
|
|
LinkPageParam.CallAction = tpCallAction;
|
|
OpenDialog(LinkPageParam);
|
|
|
|
}
|
|
|
|
//private void OpenInfo(TPageCallAction tpCallAction, string sYZID)
|
|
//{
|
|
// TPageParams LinkPageParam = new TPageParams();
|
|
// LinkPageParam.UrlPath = "TZYZJJ8Info.aspx";
|
|
// LinkPageParam.AddString("XLXSJGBYZZ8_JGBID", ContentGrid.DataKeys[ContentGrid.SelectedIndex]["XLXSJGBYZZ8_JGBID"].ToString().Trim());
|
|
// LinkPageParam.AddString("XLXSJGBYZZ8_XLXHID", ContentGrid.DataKeys[ContentGrid.SelectedIndex]["XLXSJGBYZZ8_XLXHID"].ToString().Trim());
|
|
// LinkPageParam.AddString("XLXSJGBYZZ8_XLGGID", ContentGrid.DataKeys[ContentGrid.SelectedIndex]["XLXSJGBYZZ8_XLGGID"].ToString().Trim());
|
|
// LinkPageParam.AddString("XLXSJGBYZZ8_XLBZID", ContentGrid.DataKeys[ContentGrid.SelectedIndex]["XLXSJGBYZZ8_XLBZID"].ToString().Trim());
|
|
// LinkPageParam.AddString("XLXSJGBYZZ8_DYDJID", ContentGrid.DataKeys[ContentGrid.SelectedIndex]["XLXSJGBYZZ8_DYDJID"].ToString());
|
|
// LinkPageParam.AddString("XLXSJGBYZZ8_YZID", sYZID);
|
|
// LinkPageParam.AddString("TJYZList", txtTJYZList.Value.Trim());
|
|
// LinkPageParam.CallAction = tpCallAction;
|
|
// OpenDialog(LinkPageParam);
|
|
|
|
//}
|
|
|
|
private string GetCLFirstYZ()
|
|
{
|
|
string sJGBID_CL = ContentGrid.DataKeys[ContentGrid.SelectedIndex]["XLXSJGBYZZ8_JGBID"].ToString().Trim();
|
|
string sXLXHID_CL = ContentGrid.DataKeys[ContentGrid.SelectedIndex]["XLXSJGBYZZ8_XLXHID"].ToString().Trim();
|
|
string sXLGGID_CL = ContentGrid.DataKeys[ContentGrid.SelectedIndex]["XLXSJGBYZZ8_XLGGID"].ToString().Trim();
|
|
string sXLBZID_CL = ContentGrid.DataKeys[ContentGrid.SelectedIndex]["XLXSJGBYZZ8_XLBZID"].ToString().Trim();
|
|
string sDYDJID_CL = ContentGrid.DataKeys[ContentGrid.SelectedIndex]["XLXSJGBYZZ8_DYDJID"].ToString().Trim();
|
|
string sYZIDlist = TZYZBJAInfo.GetYZIDList(txtTJYZList.Value.Trim());
|
|
string sSQL_CL = string.Format(@"select XLXSJGBYZZ8_YZID from XLXSJGBYZZ8 where XLXSJGBYZZ8_XLXHID = '{0}' and XLXSJGBYZZ8_XLGGID = '{1}'
|
|
and XLXSJGBYZZ8_XLBZID = '{2}' and XLXSJGBYZZ8_DYDJID ='{3}' and XLXSJGBYZZ8_JGBID = '{4}' and" + CMISproDataBase.GetWhereEqual("XLXSJGBYZZ8_YZID", sYZIDlist)
|
|
, sXLXHID_CL, sXLGGID_CL, sXLBZID_CL, sDYDJID_CL, sJGBID_CL);
|
|
TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
|
|
TSQL SQL = new TSQL(dberp);
|
|
SQL.Add(sSQL_CL);
|
|
DataSet ds = dberp.OpenDataSet(SQL);
|
|
if (ds.Tables[0].Rows.Count > 0)
|
|
{
|
|
return ds.Tables[0].Rows[0][0].ToString().Trim();
|
|
}
|
|
else
|
|
return "";
|
|
}
|
|
|
|
#endregion
|
|
|
|
#region 控件事件
|
|
|
|
protected void ContentGrid_RowDoubleClick(object sender, GThinking.N_CONTROL.RowDoubleClickEventArgs e)
|
|
{
|
|
if (PageParam.ContainsKey("SQDH"))
|
|
{
|
|
string sYZID = GetCLFirstYZ();
|
|
if (!sYZID.Equals(""))
|
|
OpenInfo(TPageCallAction.pcaEdit);
|
|
else
|
|
OpenInfo(TPageCallAction.pcaInsert);
|
|
}
|
|
else
|
|
OpenInfo(TPageCallAction.pcaBrowse);
|
|
}
|
|
|
|
protected void btnRefreshDRJGBMX_Click(object sender, EventArgs e)
|
|
{
|
|
moduleGV_PageIndexChanging(null, null);
|
|
}
|
|
|
|
protected void btnPLSZ_Click(object sender, EventArgs e)
|
|
{
|
|
base.InitEntityByCondition();
|
|
if (CurQueryEntity.FieldByName("JGBID").Value.Trim().Equals(""))
|
|
{
|
|
ShowMessage("调价表条件为空，请先进行查询！");
|
|
return;
|
|
}
|
|
|
|
txtTJYZValue.Value = "";
|
|
|
|
TPageParams pageParams = new TPageParams();
|
|
pageParams.UrlPath = "TZYZJJ8_PLSZList.aspx";
|
|
pageParams.AddString("JGBID", CurQueryEntity.FieldByName("JGBID").Value.Trim());
|
|
pageParams.AddString("SelIndexs", ContentGrid.CheckedRowIndexs);
|
|
pageParams.AddString("TJYZValueCID", txtTJYZValue.ClientID);
|
|
pageParams.AddString("btnRefresh1CID", btnRefresh1.ClientID);
|
|
pageParams.AddString("TJYS", "8");
|
|
pageParams.AddString("YZID", PageParam.GetRTrimString("TJYZID"));
|
|
OpenDialog(pageParams);
|
|
}
|
|
|
|
protected void btnDRWJ_Click(object sender, EventArgs e)
|
|
{
|
|
base.InitEntityByCondition();
|
|
if (CurQueryEntity.FieldByName("JGBID").Value.Trim().Equals(""))
|
|
{
|
|
ShowMessage("调价表条件为空，请先进行查询！");
|
|
return;
|
|
}
|
|
TPageParams pageParams = new TPageParams();
|
|
pageParams.UrlPath = "TZYZJJ8_DRJGB.aspx";
|
|
pageParams.AddString("JGBID", CurQueryEntity.FieldByName("JGBID").Value.Trim());
|
|
pageParams.AddString("btnRefresh1CID", btnRefresh2.ClientID);
|
|
OpenDialog(pageParams);
|
|
}
|
|
|
|
protected void btnPLSZ_MenuItemClick(object sender, string ItemIndex)
|
|
{
|
|
switch (ItemIndex)
|
|
{
|
|
case "1"://从材料清单导入
|
|
btnTBYZZ_Click(null, null);
|
|
break;
|
|
}
|
|
}
|
|
|
|
protected void btnDRWJ_MenuItemClick(object sender, string ItemIndex)
|
|
{
|
|
switch (ItemIndex)
|
|
{
|
|
case "DRCLQD"://从材料清单导入
|
|
btnDRCLQD_Click(null, null);
|
|
break;
|
|
}
|
|
}
|
|
|
|
protected void btnDRCLQD_Click(object sender, EventArgs e)
|
|
{
|
|
base.InitEntityByCondition();
|
|
if (CurQueryEntity.FieldByName("JGBID").Value.Trim().Equals(""))
|
|
{
|
|
ShowMessage("调价表条件为空，请先进行查询！");
|
|
return;
|
|
}
|
|
|
|
if (txtFirstYZID.Value.Trim().Equals(""))
|
|
{
|
|
ShowMessage("没有适用的调价因子！");
|
|
return;
|
|
}
|
|
|
|
Confirm.Register("IsQD", "将按照材料清单数据生成待设置记录，是否继续？");
|
|
Confirm.ShowBtnText = TConfirm.cBtnText.Yes_No;
|
|
if (Confirm.GetValue("IsQD").Trim().Equals(""))
|
|
{
|
|
Confirm.Ask("IsQD");
|
|
return;
|
|
}
|
|
else if (Confirm.GetValue("IsQD").Trim().Equals("N"))
|
|
{
|
|
//表示进行了提示并选择了取消，直接返回或其他处理
|
|
|
|
Confirm.Clear();
|
|
return;
|
|
}
|
|
else if (Confirm.GetValue("IsQD").Trim().Equals("Y"))
|
|
{
|
|
//表示进行了提示并选择了确认
|
|
|
|
Confirm.Clear();
|
|
}
|
|
|
|
TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
|
|
try
|
|
{
|
|
dberp.BeginTrans();
|
|
|
|
TSQL sSQL = new TSQL(dberp);
|
|
|
|
string[] sTJYZList = txtTJYZList.Value.Split(',');
|
|
for (int i = 0; i < sTJYZList.Length; i++)
|
|
{
|
|
sSQL.Clear();
|
|
sSQL.Add("insert into XLXSJGBYZZ8(XLXSJGBYZZ8_JGBID,XLXSJGBYZZ8_XLXHID,XLXSJGBYZZ8_XLGGID,XLXSJGBYZZ8_XLBZID,XLXSJGBYZZ8_DYDJID,XLXSJGBYZZ8_YZID,XLXSJGBYZZ8_YZZ,XLXSJGBYZZ8_WHR,XLXSJGBYZZ8_WHRID,XLXSJGBYZZ8_WHSJ)");
|
|
sSQL.Add(" select :pJGBID,XLXSCLQD_XLXHID,XLXSCLQD_XLGGID,XLXSCLQD_XLBZID,XLXSCLQD_DYDJID,:pYZID,0,:pWHR,:pWHRID,:pWHSJ ");
|
|
sSQL.Add(" from XLXSCLQD ");
|
|
sSQL.Add(" where not exists(select 1 from XLXSJGBYZZ8 where XLXSJGBYZZ8_JGBID=:pJGBID and XLXSJGBYZZ8_YZID=:pYZID and XLXSJGBYZZ8_XLXHID=XLXSCLQD_XLXHID and XLXSJGBYZZ8_XLGGID=XLXSCLQD_XLGGID");
|
|
sSQL.Add(" and XLXSJGBYZZ8_XLBZID=XLXSCLQD_XLBZID and XLXSJGBYZZ8_DYDJID=XLXSCLQD_DYDJID)");
|
|
sSQL.Add(" and XLXSCLQD_WPID='ZZZZ' ");
|
|
sSQL.ParamByName("pJGBID").Value = CurQueryEntity.FieldByName("JGBID").Value.Trim();
|
|
sSQL.ParamByName("pYZID").Value = sTJYZList[i].Split('|')[0];
|
|
sSQL.ParamByName("pWHR").Value = tSession.UserName;
|
|
sSQL.ParamByName("pWHRID").Value = tSession.UserId;
|
|
sSQL.ParamByName("pWHSJ").Value = DateTime.Now;
|
|
dberp.ExecSQL(sSQL);
|
|
}
|
|
XLBJDUtils.SyncXLXSBJXLGGTHB_ByXLXSJGBYZZ8_Batch(dberp, tSession);
|
|
dberp.CommitTrans();
|
|
|
|
ShowMessage("导入材料清单数据完成！");
|
|
moduleGV_PageIndexChanging(null, null);
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
ShowMessage(ex.Message);
|
|
dberp.RollbackTrans();
|
|
}
|
|
}
|
|
|
|
protected void btnTBZJGB_Click(object sender, EventArgs e)
|
|
{
|
|
string sMsg = "当前数据将同步至价格表【" + PageParam.GetRTrimString("XLJGBMC") + "】的" + PageParam.GetRTrimString("XLJGBTJYZMC") + "中，并重算表价，是否继续？";
|
|
Confirm.Register("IsQD", sMsg);
|
|
Confirm.ShowBtnText = TConfirm.cBtnText.Yes_No;
|
|
if (Confirm.GetValue("IsQD").Trim().Equals(""))
|
|
{
|
|
Confirm.Ask("IsQD");
|
|
return;
|
|
}
|
|
else if (Confirm.GetValue("IsQD").Trim().Equals("N"))
|
|
{
|
|
//否
|
|
Confirm.Clear();
|
|
return;
|
|
}
|
|
else if (Confirm.GetValue("IsQD").Trim().Equals("Y"))
|
|
{
|
|
Confirm.Clear();
|
|
}
|
|
//执行完毕后关闭当前页面
|
|
DialogOperationScript dos = new DialogOperationScript(this);
|
|
dos.ClickOwnerButton(PageParam.GetRTrimString("btnRefreshTBCID"));
|
|
dos.CloseSelf();
|
|
dos.Execute();
|
|
}
|
|
|
|
protected void btnTBSJ_Click(object sender, EventArgs e)
|
|
{
|
|
base.InitEntityByCondition();
|
|
if (CurQueryEntity.FieldByName("JGBID").Value.Trim().Equals(""))
|
|
{
|
|
ShowMessage("调价表条件为空，请先进行查询！");
|
|
return;
|
|
}
|
|
|
|
TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
|
|
TSQL SQL = new TSQL(dberp);
|
|
SQL.Clear();
|
|
SQL.Add(" select XLXSTZYZ_JGBID,XLXSTZYZ_YZID, XLXSTZYZ_YZMC from XLXSTZYZ where XLXSTZYZ_MXBH = 'BJD' and XLXSTZYZ_TJYS = 'A' ");
|
|
DataSet ds = dberp.OpenDataSet(SQL);
|
|
if (ds.Tables[0].Rows.Count == 0)
|
|
{
|
|
ShowMessage("不存在调价因素为【A|型号&规格&电压&标准】的报价单调价因子！");
|
|
return;
|
|
}
|
|
else if (ds.Tables[0].Rows.Count == 1)
|
|
{
|
|
string sTJYZID = PageParam.GetRTrimString("TJYZID");
|
|
string sTJYZMC = GetTJYZMC(sTJYZID, "JZJ");
|
|
string sMsg = "将同步【" + sTJYZMC + "】价格表因子调价表数据至【" + ds.Tables[0].Rows[0]["XLXSTZYZ_YZMC"].ToString().Trim() + "】报价单因子调价表，是否确认？";
|
|
Confirm.Register("IsQD", sMsg);
|
|
Confirm.ShowBtnText = TConfirm.cBtnText.Yes_No;
|
|
if (Confirm.GetValue("IsQD").Trim().Equals(""))
|
|
{
|
|
Confirm.Ask("IsQD");
|
|
return;
|
|
}
|
|
else if (Confirm.GetValue("IsQD").Trim().Equals("N"))
|
|
{
|
|
//否
|
|
Confirm.Clear();
|
|
return;
|
|
}
|
|
else if (Confirm.GetValue("IsQD").Trim().Equals("Y"))
|
|
{
|
|
Confirm.Clear();
|
|
try
|
|
{
|
|
dberp.BeginTrans();
|
|
|
|
SQL.Clear();
|
|
SQL.Add(" delete from XLXSBJDYZZA where XLXSBJDYZZA_JGBID = :pJGBID and XLXSBJDYZZA_YZID = :pYZID ");
|
|
SQL.ParamByName("pJGBID").Value = ds.Tables[0].Rows[0]["XLXSTZYZ_JGBID"].ToString().Trim();
|
|
SQL.ParamByName("pYZID").Value = ds.Tables[0].Rows[0]["XLXSTZYZ_YZID"].ToString().Trim();
|
|
dberp.ExecSQL(SQL);
|
|
|
|
SQL.Clear();
|
|
SQL.Add(" insert into XLXSBJDYZZA(XLXSBJDYZZA_JGBID,XLXSBJDYZZA_XLXHID,XLXSBJDYZZA_XLGGID,XLXSBJDYZZA_DYDJID,XLXSBJDYZZA_XLBZID,XLXSBJDYZZA_YZID,XLXSBJDYZZA_YZZ,XLXSBJDYZZA_WHR,XLXSBJDYZZA_WHRID,XLXSBJDYZZA_WHSJ)");
|
|
SQL.Add(" select :XLXSBJDYZZA_JGBID,XLXSJGBYZZ8_XLXHID,XLXSJGBYZZ8_XLGGID,XLXSJGBYZZ8_DYDJID,XLXSJGBYZZ8_XLBZID,:XLXSBJDYZZA_YZID,XLXSJGBYZZ8_YZZ,:XLXSBJDYZZA_WHR,:XLXSBJDYZZA_WHRID,:XLXSBJDYZZA_WHSJ from XLXSJGBYZZ8 ");
|
|
SQL.Add(" where XLXSJGBYZZ8_JGBID = :XLXSJGBYZZ8_JGBID and XLXSJGBYZZ8_YZID = :XLXSJGBYZZ8_YZID ");
|
|
SQL.ParamByName("XLXSBJDYZZA_JGBID").Value = ds.Tables[0].Rows[0]["XLXSTZYZ_JGBID"].ToString().Trim();
|
|
SQL.ParamByName("XLXSBJDYZZA_YZID").Value = ds.Tables[0].Rows[0]["XLXSTZYZ_YZID"].ToString().Trim();
|
|
SQL.ParamByName("XLXSJGBYZZ8_JGBID").Value = CurQueryEntity.FieldByName("JGBID").Value.Trim();
|
|
SQL.ParamByName("XLXSJGBYZZ8_YZID").Value = sTJYZID;
|
|
SQL.ParamByName("XLXSBJDYZZA_WHR").Value = tSession.UserName;
|
|
SQL.ParamByName("XLXSBJDYZZA_WHRID").Value = tSession.UserId;
|
|
SQL.ParamByName("XLXSBJDYZZA_WHSJ").Value = DateTime.Now;
|
|
dberp.ExecSQL(SQL);
|
|
|
|
XLBJDUtils.SyncXLXSBJXLGGTHB_ByXLXSJGBYZZ8_Batch(dberp, tSession);
|
|
dberp.CommitTrans();
|
|
ShowMessage("同步成功！");
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
ShowMessage(ex.Message);
|
|
dberp.RollbackTrans();
|
|
}
|
|
}
|
|
}
|
|
else if (ds.Tables[0].Rows.Count > 1)
|
|
{
|
|
//目标调价因素存在多个因子进入因子选择页面
|
|
string sTJYZID = PageParam.GetRTrimString("TJYZID");
|
|
string sTJYZMC = GetTJYZMC(sTJYZID, "JZJ");
|
|
TPageParams pageParams = new TPageParams();
|
|
pageParams.UrlPath = "TZYZJJ_YZXZInfo.aspx";
|
|
pageParams.AddString("JGBID", CurQueryEntity.FieldByName("JGBID").Value.Trim());
|
|
pageParams.AddString("TJYZID", sTJYZID);
|
|
pageParams.AddString("TJYZMC", sTJYZMC);
|
|
pageParams.AddString("LY", "JGB");
|
|
OpenDialog(pageParams);
|
|
}
|
|
|
|
}
|
|
|
|
protected void btnRefresh1_Click(object sender, EventArgs e)
|
|
{
|
|
base.InitEntityByCondition();
|
|
if (!ContentGrid.CheckedRowIndexs.Equals(""))
|
|
{
|
|
#region 勾选导入
|
|
TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
|
|
TSQL sSQL = new TSQL(dberp);
|
|
try
|
|
{
|
|
dberp.BeginTrans();
|
|
|
|
string[] RowsArry = ContentGrid.CheckedRowIndexs.Split(new char[] { ',' });
|
|
for (int j = 0; j < RowsArry.Length; j++)
|
|
{
|
|
string sJGBID = ContentGrid.DataKeys[CMISproConvert.StrToInt(RowsArry[j])]["XLXSJGBYZZ8_JGBID"].ToString().Trim();
|
|
string sXLXHID = ContentGrid.DataKeys[CMISproConvert.StrToInt(RowsArry[j])]["XLXSJGBYZZ8_XLXHID"].ToString().Trim();
|
|
string sXLGGID = ContentGrid.DataKeys[CMISproConvert.StrToInt(RowsArry[j])]["XLXSJGBYZZ8_XLGGID"].ToString().Trim();
|
|
string sXLBZID = ContentGrid.DataKeys[CMISproConvert.StrToInt(RowsArry[j])]["XLXSJGBYZZ8_XLBZID"].ToString().Trim();
|
|
string sDYDJID = ContentGrid.DataKeys[CMISproConvert.StrToInt(RowsArry[j])]["XLXSJGBYZZ8_DYDJID"].ToString().Trim();
|
|
|
|
string[] sYZValue = txtTJYZValue.Value.Split(',');//因子ID|因子值|是否相对值
|
|
for (int k = 0; k < sYZValue.Length; k++)
|
|
{
|
|
if (!sYZValue[k].Trim().Equals(""))
|
|
{
|
|
|
|
if (!sYZValue[k].Split('|')[2].Equals("Y"))//非相对值
|
|
{
|
|
sSQL.Clear();
|
|
sSQL.Add("delete from XLXSJGBYZZ8 where XLXSJGBYZZ8_JGBID=:pJGBID and XLXSJGBYZZ8_XLXHID=:pXLXHID and XLXSJGBYZZ8_XLGGID=:pXLGGID ");
|
|
sSQL.Add(" and XLXSJGBYZZ8_XLBZID=:pXLBZID and XLXSJGBYZZ8_DYDJID=:pDYDJID ");
|
|
sSQL.Add(" and XLXSJGBYZZ8_YZID=:pYZID");
|
|
sSQL.ParamByName("pJGBID").Value = sJGBID;
|
|
sSQL.ParamByName("pXLXHID").Value = sXLXHID;
|
|
sSQL.ParamByName("pXLGGID").Value = sXLGGID;
|
|
sSQL.ParamByName("pXLBZID").Value = sXLBZID;
|
|
sSQL.ParamByName("pDYDJID").Value = sDYDJID;
|
|
sSQL.ParamByName("pYZID").Value = sYZValue[k].Split('|')[0].Trim();
|
|
dberp.ExecSQL(sSQL);
|
|
|
|
sSQL.Clear();
|
|
sSQL.Add("insert into XLXSJGBYZZ8(XLXSJGBYZZ8_JGBID,XLXSJGBYZZ8_XLXHID,XLXSJGBYZZ8_XLGGID,XLXSJGBYZZ8_XLBZID,XLXSJGBYZZ8_DYDJID,XLXSJGBYZZ8_YZID,XLXSJGBYZZ8_YZZ,XLXSJGBYZZ8_WHR,XLXSJGBYZZ8_WHRID,XLXSJGBYZZ8_WHSJ)");
|
|
sSQL.Add(" values(:pJGBID,:pXLXHID,:pXLGGID,:pXLBZID,:pDYDJID,:pYZID,:pYZZ,:pWHR,:pWHRID,:pWHSJ)");
|
|
sSQL.ParamByName("pJGBID").Value = sJGBID;
|
|
sSQL.ParamByName("pXLXHID").Value = sXLXHID;
|
|
sSQL.ParamByName("pXLGGID").Value = sXLGGID;
|
|
sSQL.ParamByName("pXLBZID").Value = sXLBZID;
|
|
sSQL.ParamByName("pDYDJID").Value = sDYDJID;
|
|
sSQL.ParamByName("pYZID").Value = sYZValue[k].Split('|')[0].Trim();
|
|
sSQL.ParamByName("pYZZ").Value = CMISproConvert.StrToFloat(sYZValue[k].Split('|')[1], 0);
|
|
sSQL.ParamByName("pWHR").Value = tSession.UserName;
|
|
sSQL.ParamByName("pWHRID").Value = tSession.UserId;
|
|
sSQL.ParamByName("pWHSJ").Value = DateTime.Now;
|
|
dberp.ExecSQL(sSQL);
|
|
}
|
|
else//相对值
|
|
{
|
|
sSQL.Clear();
|
|
sSQL.Add("update XLXSJGBYZZ8 set XLXSJGBYZZ8_YZZ=XLXSJGBYZZ8_YZZ+:pYZZ,XLXSJGBYZZ8_WHR=:pWHR,XLXSJGBYZZ8_WHRID=:pWHRID,XLXSJGBYZZ8_WHSJ=:pWHSJ");
|
|
sSQL.Add(" where XLXSJGBYZZ8_JGBID=:pJGBID and XLXSJGBYZZ8_XLXHID=:pXLXHID and XLXSJGBYZZ8_XLGGID=:pXLGGID");
|
|
sSQL.Add(" and XLXSJGBYZZ8_XLBZID=:pXLBZID and XLXSJGBYZZ8_DYDJID=:pDYDJID ");
|
|
sSQL.Add(" and XLXSJGBYZZ8_YZID=:pYZID");
|
|
sSQL.ParamByName("pJGBID").Value = sJGBID;
|
|
sSQL.ParamByName("pXLXHID").Value = sXLXHID;
|
|
sSQL.ParamByName("pXLGGID").Value = sXLGGID;
|
|
sSQL.ParamByName("pXLBZID").Value = sXLBZID;
|
|
sSQL.ParamByName("pDYDJID").Value = sDYDJID;
|
|
sSQL.ParamByName("pYZID").Value = sYZValue[k].Split('|')[0].Trim();
|
|
sSQL.ParamByName("pYZZ").Value = CMISproConvert.StrToFloat(sYZValue[k].Split('|')[1], 0);
|
|
sSQL.ParamByName("pWHR").Value = tSession.UserName;
|
|
sSQL.ParamByName("pWHRID").Value = tSession.UserId;
|
|
sSQL.ParamByName("pWHSJ").Value = DateTime.Now;
|
|
dberp.ExecSQL(sSQL);
|
|
}
|
|
|
|
|
|
}
|
|
}
|
|
}
|
|
XLBJDUtils.SyncXLXSBJXLGGTHB_ByXLXSJGBYZZ8_Batch(dberp, tSession);
|
|
dberp.CommitTrans();
|
|
|
|
ShowMessage("设置完成！");
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
ShowMessage(ex.Message);
|
|
dberp.RollbackTrans();
|
|
}
|
|
#endregion
|
|
}
|
|
else
|
|
{
|
|
|
|
TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
|
|
TSQL sSQL = new TSQL(dberp);
|
|
try
|
|
{
|
|
dberp.BeginTrans();
|
|
|
|
string[] sYZValue = txtTJYZValue.Value.Split(',');//因子ID|因子值|是否相对值
|
|
for (int k = 0; k < sYZValue.Length; k++)
|
|
{
|
|
if (!sYZValue[k].Trim().Equals(""))
|
|
{
|
|
//先补齐记录
|
|
sSQL.Clear();
|
|
sSQL.Add("insert into XLXSJGBYZZ8(XLXSJGBYZZ8_JGBID,XLXSJGBYZZ8_XLXHID,XLXSJGBYZZ8_XLGGID,XLXSJGBYZZ8_XLBZID,XLXSJGBYZZ8_DYDJID,XLXSJGBYZZ8_YZID,XLXSJGBYZZ8_YZZ,XLXSJGBYZZ8_WHR,XLXSJGBYZZ8_WHRID,XLXSJGBYZZ8_WHSJ)");
|
|
sSQL.Add(" select :pJGBID,a.XLXSJGBYZZ8_XLXHID, a.XLXSJGBYZZ8_XLGGID, a.XLXSJGBYZZ8_XLBZID, a.XLXSJGBYZZ8_DYDJID,:pYZID,0, :pWHR,:pWHRID,:pWHSJ ");
|
|
sSQL.Add(" from XLXSJGBYZZ8 a");
|
|
sSQL.Add(" where a.XLXSJGBYZZ8_JGBID = :pJGBID ");
|
|
sSQL.Add(" and a.XLXSJGBYZZ8_YZID<>:pYZID");
|
|
sSQL.Add(" and not exists(select 1 from XLXSJGBYZZ8 b where b.XLXSJGBYZZ8_JGBID=:pJGBID and b.XLXSJGBYZZ8_XLXHID=a.XLXSJGBYZZ8_XLXHID and b.XLXSJGBYZZ8_XLGGID=a.XLXSJGBYZZ8_XLGGID ");
|
|
sSQL.Add(" and b.XLXSJGBYZZ8_XLBZID=a.XLXSJGBYZZ8_XLBZID and b.XLXSJGBYZZ8_DYDJID=a.XLXSJGBYZZ8_DYDJID and b.XLXSJGBYZZ8_YZID=:pYZID)");
|
|
sSQL.ParamByName("pJGBID").Value = CurQueryEntity.FieldByName("JGBID").Value.Trim();
|
|
sSQL.ParamByName("pYZID").Value = sYZValue[k].Split('|')[0].Trim();
|
|
sSQL.ParamByName("pWHR").Value = tSession.UserName;
|
|
sSQL.ParamByName("pWHRID").Value = tSession.UserId;
|
|
sSQL.ParamByName("pWHSJ").Value = DateTime.Now;
|
|
dberp.ExecSQL(sSQL);
|
|
|
|
|
|
sSQL.Clear();
|
|
sSQL.Add("update XLXSJGBYZZ8 set ");
|
|
if (!sYZValue[k].Split('|')[2].Equals("Y"))//非相对值
|
|
sSQL.Add(" XLXSJGBYZZ8_YZZ=:pYZZ,");
|
|
else
|
|
sSQL.Add(" XLXSJGBYZZ8_YZZ=XLXSJGBYZZ8_YZZ+:pYZZ,");
|
|
sSQL.Add(" XLXSJGBYZZ8_WHR=:pWHR,XLXSJGBYZZ8_WHRID=:pWHRID,XLXSJGBYZZ8_WHSJ=:pWHSJ");
|
|
sSQL.Add(" from");
|
|
sSQL.Add(" (select XLXSJGBYZZ8_XLXHID as XLXHID, XLXSJGBYZZ8_XLGGID as XLGGID, XLXSJGBYZZ8_XLBZID as XLBZID, XLXSJGBYZZ8_DYDJID as DYDJID");
|
|
sSQL.Add(" from XLXSJGBYZZ8");
|
|
sSQL.Add(" where XLXSJGBYZZ8_JGBID = :pJGBID and XLXSJGBYZZ8_YZID=:pYZID ");
|
|
|
|
if (!string.IsNullOrEmpty(CurQueryEntity.FieldByName("XLXHID").Value.Trim()))
|
|
{
|
|
sSQL.Add(" and XLXSJGBYZZ8_XLXHID = :pXLXHID ");
|
|
sSQL.ParamByName("pXLXHID").Value = CurQueryEntity.FieldByName("XLXHID").Value.Trim();
|
|
}
|
|
if (!string.IsNullOrEmpty(CurQueryEntity.FieldByName("DYDJID").Value.Trim()))
|
|
{
|
|
sSQL.Add(" and XLXSJGBYZZ8_DYDJID = :pDYDJID ");
|
|
sSQL.ParamByName("pDYDJID").Value = CurQueryEntity.FieldByName("DYDJID").Value.Trim();
|
|
}
|
|
|
|
sSQL.Add(" ) a");
|
|
sSQL.Add(" where XLXSJGBYZZ8_JGBID = :pJGBID and XLXSJGBYZZ8_YZID=:pYZID ");
|
|
sSQL.Add(" and XLXSJGBYZZ8_XLXHID=a.XLXHID and XLXSJGBYZZ8_XLGGID=a.XLGGID and XLXSJGBYZZ8_XLBZID=a.XLBZID and XLXSJGBYZZ8_DYDJID=a.DYDJID");
|
|
sSQL.ParamByName("pJGBID").Value = CurQueryEntity.FieldByName("JGBID").Value.Trim();
|
|
sSQL.ParamByName("pYZID").Value = sYZValue[k].Split('|')[0].Trim();
|
|
sSQL.ParamByName("pYZZ").Value = CMISproConvert.StrToFloat(sYZValue[k].Split('|')[1], 0);
|
|
sSQL.ParamByName("pWHR").Value = tSession.UserName;
|
|
sSQL.ParamByName("pWHRID").Value = tSession.UserId;
|
|
sSQL.ParamByName("pWHSJ").Value = DateTime.Now;
|
|
dberp.ExecSQL(sSQL);
|
|
|
|
}
|
|
}
|
|
XLBJDUtils.SyncXLXSBJXLGGTHB_ByXLXSJGBYZZ8_Batch(dberp, tSession);
|
|
dberp.CommitTrans();
|
|
|
|
ShowMessage("设置完成！");
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
ShowMessage(ex.Message);
|
|
dberp.RollbackTrans();
|
|
}
|
|
}
|
|
moduleGV_PageIndexChanging(null, null);
|
|
}
|
|
|
|
protected void btnTBYZZ_Click(object sender, EventArgs e)
|
|
{
|
|
string sMsg = "将同步与当前查询结果相同型号规格记录的因子值，是否确认？";
|
|
Confirm.Register("IsQD", sMsg);
|
|
Confirm.ShowBtnText = TConfirm.cBtnText.Yes_No;
|
|
if (Confirm.GetValue("IsQD").Trim().Equals(""))
|
|
{
|
|
Confirm.Ask("IsQD");
|
|
return;
|
|
}
|
|
else if (Confirm.GetValue("IsQD").Trim().Equals("N"))
|
|
{
|
|
//否
|
|
Confirm.Clear();
|
|
return;
|
|
}
|
|
else if (Confirm.GetValue("IsQD").Trim().Equals("Y"))
|
|
{
|
|
base.InitEntityByCondition();
|
|
string sYZIDlist = TZYZBJAInfo.GetYZIDList(txtTJYZList.Value.Trim());
|
|
string sJGBID = CurQueryEntity.FieldByName("JGBID").Value.Trim();
|
|
string sSQDH = PageParam.GetRTrimString("SQDH");
|
|
TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
|
|
TSQL SQL = new TSQL(dberp);
|
|
if (!string.IsNullOrEmpty(sYZIDlist))
|
|
{
|
|
try
|
|
{
|
|
dberp.BeginTrans();
|
|
foreach (string sYZID in sYZIDlist.Split(','))
|
|
{
|
|
SQL.Clear();
|
|
SQL.Add(" merge into XLXSJGBYZZ8 tag ");
|
|
SQL.Add(" using( ");
|
|
SQL.Add(" select distinct XLXSBJYLZDMX_XLXHID,XLXSBJYLZDMX_XLGGID,XLXSBJYLZDMX_XLBZID,XLXSBJYLZDMX_DYDJID,isnull(YZZ,0) as YZZ ");
|
|
SQL.Add(" from XLXSBJYLZDMX ");
|
|
SQL.Add(" left join (select XLXSJGBYZZ8_XLXHID,XLXSJGBYZZ8_XLGGID,MAX(XLXSJGBYZZ8_YZZ) as YZZ ");
|
|
SQL.Add(" from XLXSJGBYZZ8 where XLXSJGBYZZ8_JGBID = :pJGBID and XLXSJGBYZZ8_YZID = :pYZID ");
|
|
SQL.Add(" group by XLXSJGBYZZ8_XLXHID,XLXSJGBYZZ8_XLGGID) b on XLXSBJYLZDMX_XLXHID = XLXSJGBYZZ8_XLXHID and XLXSBJYLZDMX_XLGGID = XLXSJGBYZZ8_XLGGID ");
|
|
SQL.Add(" where XLXSBJYLZDMX_SQDH = :pSQDH ");
|
|
SQL.Add(" ) sor ");
|
|
SQL.Add(" on (XLXSJGBYZZ8_JGBID = :pJGBID and XLXSJGBYZZ8_YZID = :pYZID ");
|
|
SQL.Add(" and XLXSJGBYZZ8_XLXHID = XLXSBJYLZDMX_XLXHID and XLXSJGBYZZ8_XLGGID = XLXSBJYLZDMX_XLGGID ");
|
|
SQL.Add(" and XLXSJGBYZZ8_XLBZID = XLXSBJYLZDMX_XLBZID and XLXSJGBYZZ8_DYDJID = XLXSBJYLZDMX_DYDJID) ");
|
|
SQL.Add(" when matched then update set XLXSJGBYZZ8_YZZ = YZZ,XLXSJGBYZZ8_WHR = :pWHR,XLXSJGBYZZ8_WHRID = :pWHRID,XLXSJGBYZZ8_WHSJ = :pWHSJ ");
|
|
SQL.Add(" when not matched then insert ");
|
|
SQL.Add(" (XLXSJGBYZZ8_JGBID,XLXSJGBYZZ8_YZID,XLXSJGBYZZ8_XLXHID,XLXSJGBYZZ8_XLGGID,XLXSJGBYZZ8_XLBZID,XLXSJGBYZZ8_DYDJID, ");
|
|
SQL.Add(" XLXSJGBYZZ8_YZZ,XLXSJGBYZZ8_WHR,XLXSJGBYZZ8_WHRID,XLXSJGBYZZ8_WHSJ) ");
|
|
SQL.Add(" values(:pJGBID,:pYZID,XLXSBJYLZDMX_XLXHID,XLXSBJYLZDMX_XLGGID,XLXSBJYLZDMX_XLBZID,XLXSBJYLZDMX_DYDJID, ");
|
|
SQL.Add(" YZZ,:pWHR,:pWHRID,:pWHSJ)");
|
|
SQL.ParamByName("pJGBID").Value = sJGBID;
|
|
SQL.ParamByName("pYZID").Value = sYZID;
|
|
SQL.ParamByName("pSQDH").Value = sSQDH;
|
|
SQL.ParamByName("pWHR").Value = tSession.UserName;
|
|
SQL.ParamByName("pWHRID").Value = tSession.UserId;
|
|
SQL.ParamByName("pWHSJ").Value = DateTime.Now;
|
|
dberp.ExecSQL(SQL);
|
|
}
|
|
XLBJDUtils.SyncXLXSBJXLGGTHB_ByXLXSJGBYZZ8_Batch(dberp, tSession);
|
|
dberp.CommitTrans();
|
|
ShowMessage("同步完成！");
|
|
moduleGV_PageIndexChanging(null, null);
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
ShowMessage(ex.Message);
|
|
dberp.RollbackTrans();
|
|
}
|
|
}
|
|
}
|
|
}
|
|
|
|
|
|
|
|
#endregion
|
|
|
|
#region GridView增加列
|
|
|
|
/// <summary>
|
|
/// 设置etCheckBox列的属性
|
|
/// </summary>
|
|
/// <param name="sDataField"></param>
|
|
/// <param name="HeadText"></param>
|
|
/// <param name="Width"></param>
|
|
/// <param name="CheckBox"></param>
|
|
private void AddColumn(string sDataField, string HeadText, int Width, TEditType CheckBox)
|
|
{
|
|
BoundField Column = new BoundField();
|
|
Column.DataField = sDataField;
|
|
Column.HeaderText = HeadText;
|
|
Column.ItemStyle.Width = (Unit)Width;
|
|
Column.HeaderStyle.Width = (Unit)Width;
|
|
ContentGrid.Columns.Add(Column);
|
|
|
|
gtGridView_Column ColumnEx = new gtGridView_Column();
|
|
ColumnEx.DataField = sDataField;
|
|
ColumnEx.EditType = TEditType.etCheckBox;
|
|
ContentGrid.ColumnsEx.Insert(0, ColumnEx);
|
|
}
|
|
|
|
/// <summary>
|
|
/// 设置etString列的属性
|
|
/// </summary>
|
|
/// <param name="sDataField"></param>
|
|
/// <param name="HeadText"></param>
|
|
/// <param name="Width"></param>
|
|
private void AddColumn(string sDataField, string HeadText, int Width)
|
|
{
|
|
BoundField Column = new BoundField();
|
|
Column.DataField = sDataField;
|
|
Column.HeaderText = HeadText;
|
|
Column.ItemStyle.Width = (Unit)Width;
|
|
Column.HeaderStyle.Width = (Unit)Width;
|
|
ContentGrid.Columns.Add(Column);
|
|
|
|
gtGridView_Column ColumnEx = new gtGridView_Column();
|
|
ColumnEx.DataField = sDataField;
|
|
ColumnEx.EditType = TEditType.etString;
|
|
ColumnEx.ShowHint = true;
|
|
ContentGrid.ColumnsEx.Insert(0, ColumnEx);
|
|
}
|
|
|
|
/// <summary>
|
|
/// 设置etNumber列的属
|
|
/// </summary>
|
|
/// <param name="sDataField"></param>
|
|
/// <param name="HeadText"></param>
|
|
/// <param name="NumberDecimalPlace"></param>
|
|
/// <param name="Width"></param>
|
|
private void AddColumn(string sDataField, string HeadText, int NumberDecimalPlace, int Width)
|
|
{
|
|
BoundField Column = new BoundField();
|
|
Column.DataField = sDataField;
|
|
Column.HeaderText = HeadText;
|
|
Column.ItemStyle.Width = (Unit)Width;
|
|
Column.HeaderStyle.Width = (Unit)Width;
|
|
Column.ItemStyle.HorizontalAlign = HorizontalAlign.Right;
|
|
ContentGrid.Columns.Add(Column);
|
|
|
|
gtGridView_Column ColumnEx = new gtGridView_Column();
|
|
ColumnEx.DataField = sDataField;
|
|
ColumnEx.EditType = TEditType.etNumber;
|
|
ColumnEx.ShowHint = true;
|
|
ColumnEx.NumberDecimalPlace = NumberDecimalPlace;
|
|
ContentGrid.ColumnsEx.Insert(0, ColumnEx);
|
|
}
|
|
|
|
/// <summary>
|
|
/// 设置etDateTime列的属性
|
|
/// </summary>
|
|
/// <param name="sDataField"></param>
|
|
/// <param name="HeadText"></param>
|
|
/// <param name="DateTimeKind"></param>
|
|
/// <param name="Width"></param>
|
|
private void AddColumn(string sDataField, string HeadText, TDateTimeEditKinds DateTimeKind)
|
|
{
|
|
BoundField Column = new BoundField();
|
|
Column.DataField = sDataField;
|
|
Column.HeaderText = HeadText;
|
|
Column.ItemStyle.Width = (Unit)(DateTimeKind == TDateTimeEditKinds.dtDateTime ? 125 : 72);
|
|
Column.HeaderStyle.Width = (Unit)(DateTimeKind == TDateTimeEditKinds.dtDateTime ? 125 : 72);
|
|
ContentGrid.Columns.Add(Column);
|
|
|
|
gtGridView_Column ColumnEx = new gtGridView_Column();
|
|
ColumnEx.DataField = sDataField;
|
|
ColumnEx.EditType = TEditType.etDateTime;
|
|
ColumnEx.DateTimeEditKins = DateTimeKind;
|
|
ContentGrid.ColumnsEx.Insert(0, ColumnEx);
|
|
}
|
|
|
|
|
|
#endregion
|
|
}
|
|
}
|