704 lines
43 KiB
C#
704 lines
43 KiB
C#
using System;
|
||
using System.Data;
|
||
using System.Configuration;
|
||
using System.Collections;
|
||
using System.Web;
|
||
using System.Web.Security;
|
||
using System.Web.UI;
|
||
using System.Web.UI.WebControls;
|
||
using System.Web.UI.WebControls.WebParts;
|
||
using System.Web.UI.HtmlControls;
|
||
using GThinking.N_MISPRO;
|
||
using GThinking.N_MISPRO.Data;
|
||
using GThinking.N_MODEL.Page;
|
||
using GThinking.N_MISPRO.Utility;
|
||
using GThinking.N_PUBLIC;
|
||
using GThinking.N_MODEL.Dialog;
|
||
using GThinking.N_WORKFLOW;
|
||
using System.Collections.Generic;
|
||
using GThinking.N_CONTROL;
|
||
using System.Text;
|
||
|
||
namespace GThinking.U20261363_N_XLXSBJ
|
||
{
|
||
|
||
[TableMap(DB = "DBERP", DbTableName = "XLXSJGBMX", Umid = 100860174, IsWorkFlow = false, IsAttach = false, UseWhr = true,
|
||
|
||
QuerySelSql = " ",
|
||
|
||
EntitySelSql = " ",
|
||
|
||
UpdateSql = " ",
|
||
|
||
InsertSql = " ",
|
||
|
||
DeleteSql = " ")]
|
||
|
||
public class XLBJD_JGFLD : EntityManager
|
||
{
|
||
|
||
}
|
||
public partial class XLBJD_JGFLDInfo : SingleCardBase
|
||
{
|
||
XLBJD_JGFLD entity = new XLBJD_JGFLD();
|
||
|
||
protected void Page_Load(object sender, EventArgs e)
|
||
{
|
||
this.UMID = 100860174;
|
||
this.UMName = "线缆销售报价单";
|
||
this.CurMaster = Master;
|
||
this.CurEntity = entity;
|
||
this.PageHeight = 180;
|
||
this.PageWidth = 420;
|
||
|
||
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;
|
||
|
||
txtJCCLJG.DecimalPlaces = XLBJDUtils.BJCLPriceDecimal;
|
||
txtJCHSJG.DecimalPlaces = XLBJDUtils.BJCLPriceDecimal;
|
||
txtJGLWSJGF.DecimalPlaces = XLBJDUtils.BJCLPriceDecimal;
|
||
txtJGLHSJGF.DecimalPlaces = XLBJDUtils.BJCLPriceDecimal;
|
||
txtJGLCLJG.DecimalPlaces = XLBJDUtils.BJCLPriceDecimal;
|
||
txtJGLHSJG.DecimalPlaces = XLBJDUtils.BJCLPriceDecimal;
|
||
txtJGYLCLJG.DecimalPlaces = XLBJDUtils.BJCLPriceDecimal;
|
||
txtJGYLHSJG.DecimalPlaces = XLBJDUtils.BJCLPriceDecimal;
|
||
|
||
base.InitPage();
|
||
|
||
if (!this.IsPostBack)
|
||
{
|
||
InitControls();
|
||
}
|
||
}
|
||
|
||
#region 模板事件继承
|
||
|
||
#endregion
|
||
|
||
#region 自定义函数
|
||
|
||
private void InitControls()
|
||
{
|
||
int flag = 0;
|
||
DataSet dsBJCL = null;
|
||
string sBJCLID = PageParam.GetRTrimString("BJCLID");
|
||
string sJGBID = PageParam.GetRTrimString("JGBID");
|
||
string sBJDID = PageParam.GetRTrimString("BJDID");
|
||
string sBJDHQLY = PageParam.GetRTrimString("BJDHQLY");
|
||
string sBJLY = PageParam.GetRTrimString("BJLY");
|
||
string sBJFLID = PageParam.GetRTrimString("BJFLID");
|
||
string sBJRQ = PageParam.GetRTrimString("BJRQ");
|
||
TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
|
||
TSQL SQL = new TSQL(dberp);
|
||
if (!sBJCLID.Equals(""))
|
||
{
|
||
SQL.Clear();
|
||
SQL.Add(" select XLXSBJCL_JGYBJCLID,XLXSBJCL_BJCLID,XLXSBJCL_BJCLMC from XLXSBJCL where (XLXSBJCL_BJCLID = :pBJCLID or XLXSBJCL_JGYBJCLID = :pBJCLID) order by XLXSBJCL_JGYBJCLID ");
|
||
SQL.ParamByName("pBJCLID").Value = sBJCLID;
|
||
dsBJCL = dberp.OpenDataSet(SQL);
|
||
if (dsBJCL.Tables[0].Rows.Count > 0)
|
||
{
|
||
//判断 加工原料 铜
|
||
for (int i = 0; i < dsBJCL.Tables[0].Rows.Count; i++)
|
||
{
|
||
if (dsBJCL.Tables[0].Rows[i]["XLXSBJCL_JGYBJCLID"].ToString().Trim().Equals(""))
|
||
{
|
||
flag = 1;
|
||
}
|
||
}
|
||
}
|
||
else
|
||
{
|
||
flag = 2;
|
||
}
|
||
}
|
||
|
||
//加工料----table2
|
||
//加工原料----table3
|
||
|
||
//铜丝
|
||
if (0 == flag)
|
||
{
|
||
table2.Style["display"] = "block";
|
||
table3.Style["display"] = "none";
|
||
txtJGLZZSL.Value = CMISproConvert.StrToFloat(PageParam.GetRTrimString("ZZSL"));
|
||
txtJGLCLJG.Value = CMISproConvert.StrToFloat(PageParam.GetRTrimString("CLJG"));
|
||
txtJGLHSJG.Value = CMISproConvert.StrToFloat(PageParam.GetRTrimString("HSJG"));
|
||
|
||
txtJGLWSJGF.Value = CMISproConvert.StrToFloat(PageParam.GetRTrimString("WSJGF"));
|
||
txtJGLHSJGF.Value = CMISproConvert.StrToFloat(PageParam.GetRTrimString("HSJGF"));
|
||
//加工原料-铜
|
||
string sJGYBJCLID = dsBJCL.Tables[0].Rows[0]["XLXSBJCL_JGYBJCLID"].ToString().Trim();
|
||
TComboBox.SetComboBox("DBERP", cbxJGYLID, "select XLXSBJCL_BJCLID,XLXSBJCL_BJCLMC from XLXSBJCL where 1=1 order by XLXSBJCL_BJCLID", false);
|
||
TComboBox.SetComboBox("DBERP", cbxJGLID, "select XLXSBJCL_BJCLID,XLXSBJCL_BJCLMC from XLXSBJCL where 1=1 order by XLXSBJCL_BJCLID", false);
|
||
cbxJGYLID.SelectedValue = dsBJCL.Tables[0].Rows[0]["XLXSBJCL_JGYBJCLID"].ToString().Trim();
|
||
cbxJGLID.SelectedValue = sBJCLID;
|
||
txtJCCLJG.Value = CMISproConvert.StrToFloat(PageParam.GetRTrimString("JCCLJG"));
|
||
txtJCHSJG.Value = CMISproConvert.StrToFloat(PageParam.GetRTrimString("JCHSJG"));
|
||
|
||
}
|
||
//铜
|
||
else if (1 == flag)
|
||
{
|
||
table2.Style["display"] = "none";
|
||
table3.Style["display"] = "block";
|
||
txtJGYLZZSL.Value = CMISproConvert.StrToFloat(PageParam.GetRTrimString("ZZSL"));
|
||
txtJGYLCLJG.Value = CMISproConvert.StrToFloat(PageParam.GetRTrimString("CLJG"));
|
||
txtJGYLHSJG.Value = CMISproConvert.StrToFloat(PageParam.GetRTrimString("HSJG"));
|
||
}
|
||
else
|
||
{
|
||
table2.Style["display"] = "none";
|
||
table3.Style["display"] = "none";
|
||
}
|
||
|
||
}
|
||
|
||
#endregion
|
||
|
||
#region 控件事件
|
||
|
||
protected void btnQR_Click(object sender, EventArgs e)
|
||
{
|
||
int flag = 0;
|
||
DataSet dsBJCL = null;
|
||
string sBJCLID = PageParam.GetRTrimString("BJCLID");
|
||
string sJGBID = PageParam.GetRTrimString("JGBID");
|
||
string sBJDID = PageParam.GetRTrimString("BJDID");
|
||
string sWLVID = PageParam.GetRTrimString("WLVID");
|
||
string sCLVID = PageParam.GetRTrimString("CLVID");
|
||
string sBJDHQLY = PageParam.GetRTrimString("BJDHQLY");
|
||
string sBJLY = PageParam.GetRTrimString("BJLY");
|
||
string sBJFLID = PageParam.GetRTrimString("BJFLID");
|
||
string sBJRQ = PageParam.GetRTrimString("BJRQ");
|
||
string sJGYBJCLID1 = PageParam.GetRTrimString("JGYBJCLID1");
|
||
double fJGBL1 = CMISproConvert.StrToFloat(PageParam.GetRTrimString("JGBL1"));
|
||
TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
|
||
TSQL SQL = new TSQL(dberp);
|
||
if (!sBJCLID.Equals(""))
|
||
{
|
||
SQL.Clear();
|
||
SQL.Add(" select XLXSBJCL_JGYBJCLID,XLXSBJCL_BJCLID,XLXSBJCL_BJCLMC from XLXSBJCL where (XLXSBJCL_BJCLID = :pBJCLID or XLXSBJCL_JGYBJCLID = :pBJCLID) order by XLXSBJCL_JGYBJCLID ");
|
||
SQL.ParamByName("pBJCLID").Value = sBJCLID;
|
||
dsBJCL = dberp.OpenDataSet(SQL);
|
||
if (dsBJCL.Tables[0].Rows.Count > 0)
|
||
{
|
||
//判断 加工原料 铜
|
||
for (int i = 0; i < dsBJCL.Tables[0].Rows.Count; i++)
|
||
{
|
||
if (dsBJCL.Tables[0].Rows[i]["XLXSBJCL_JGYBJCLID"].ToString().Trim().Equals(""))
|
||
{
|
||
flag = 1;
|
||
}
|
||
}
|
||
}
|
||
else
|
||
{
|
||
flag = 2;
|
||
}
|
||
}
|
||
|
||
try
|
||
{
|
||
SQL.Clear();
|
||
SQL.Add(" select V_XLXSBJDCLHQ_WSJG,V_XLXSBJDCLHQ_HSJG from V_XLXSBJDCLHQ where V_XLXSBJDCLHQ_BJCLID = :pBJCLID and V_XLXSBJDCLHQ_BJDID = :pBJDID ");
|
||
SQL.Add(" and V_XLXSBJDCLHQ_ID = :pCLVID and V_XLXSBJDCLHQ_TZRYID = :pRYID ");
|
||
SQL.ParamByName("pBJCLID").Value = sBJCLID;
|
||
SQL.ParamByName("pBJDID").Value = sBJDID;
|
||
SQL.ParamByName("pCLVID").Value = sCLVID;
|
||
SQL.ParamByName("pRYID").Value = tSession.RYID;
|
||
DataSet dsBJDCLHQ = dberp.OpenDataSet(SQL);
|
||
//铜丝
|
||
if (0 == flag)
|
||
{
|
||
//加工料
|
||
//if (txtJGLWSJGF.Value < 0)
|
||
//{
|
||
// ShowMessage("无税加工费不允许小于0！");
|
||
// return;
|
||
//}
|
||
|
||
//if (txtJGLHSJGF.Value < 0)
|
||
//{
|
||
// ShowMessage("含税加工费不允许小于0！");
|
||
// return;
|
||
//}
|
||
if (txtJGLCLJG.Value < 0)
|
||
{
|
||
ShowMessage("无税材料价格不允许小于0！");
|
||
return;
|
||
}
|
||
|
||
if (txtJGLHSJG.Value < 0)
|
||
{
|
||
ShowMessage("含税材料价格不允许小于0！");
|
||
return;
|
||
}
|
||
if (dsBJDCLHQ.Tables[0].Rows.Count > 0)
|
||
{
|
||
//更新
|
||
SQL.Clear();
|
||
SQL.Add(" update V_XLXSBJDCLHQ ");
|
||
SQL.Add(" set V_XLXSBJDCLHQ_WSJG = :XLXSBJDCLHQ_WSJG,V_XLXSBJDCLHQ_HSJG=:XLXSBJDCLHQ_HSJG,V_XLXSBJDCLHQ_WSJGF= :XLXSBJDCLHQ_WSJGF, V_XLXSBJDCLHQ_HSJGF=:XLXSBJDCLHQ_HSJGF, ");
|
||
SQL.Add(" V_XLXSBJDCLHQ_WSJG1=:V_XLXSBJDCLHQ_WSJG1,V_XLXSBJDCLHQ_HSJG1=:V_XLXSBJDCLHQ_HSJG1,V_XLXSBJDCLHQ_JGBL1=:V_XLXSBJDCLHQ_JGBL1, ");
|
||
SQL.Add(" V_XLXSBJDCLHQ_WHRID = :XLXSBJDCLHQ_WHRID, V_XLXSBJDCLHQ_WHR = :XLXSBJDCLHQ_WHR, V_XLXSBJDCLHQ_WHSJ = :XLXSBJDCLHQ_WHSJ");
|
||
SQL.Add(" where V_XLXSBJDCLHQ_BJDID =:pBJDID and V_XLXSBJDCLHQ_BJCLID = :pBJCLID and V_XLXSBJDCLHQ_ID = :pCLVID and V_XLXSBJDCLHQ_TZRYID = :pRYID ");
|
||
SQL.ParamByName("XLXSBJDCLHQ_WSJG").Value = txtJGLCLJG.Value;
|
||
SQL.ParamByName("XLXSBJDCLHQ_HSJG").Value = txtJGLHSJG.Value;
|
||
SQL.ParamByName("XLXSBJDCLHQ_WSJGF").Value = txtJGLWSJGF.Value;
|
||
SQL.ParamByName("XLXSBJDCLHQ_HSJGF").Value = txtJGLHSJGF.Value;
|
||
SQL.ParamByName("V_XLXSBJDCLHQ_WSJG1").Value = txtJGYLCLJG.Value;
|
||
SQL.ParamByName("V_XLXSBJDCLHQ_HSJG1").Value = txtJGYLHSJG.Value;
|
||
SQL.ParamByName("V_XLXSBJDCLHQ_JGBL1").Value = fJGBL1;
|
||
SQL.ParamByName("XLXSBJDCLHQ_WHR").Value = tSession.UserName;
|
||
SQL.ParamByName("XLXSBJDCLHQ_WHRID").Value = tSession.UserId;
|
||
SQL.ParamByName("XLXSBJDCLHQ_WHSJ").Value = DateTime.Now.ToString();
|
||
SQL.ParamByName("pBJCLID").Value = sBJCLID;
|
||
SQL.ParamByName("pBJDID").Value = sBJDID;
|
||
SQL.ParamByName("pCLVID").Value = sCLVID;
|
||
SQL.ParamByName("pRYID").Value = tSession.RYID;
|
||
dberp.ExecSQL(SQL);
|
||
}
|
||
else
|
||
{
|
||
//插入
|
||
SQL.Clear();
|
||
SQL.Add(" insert into V_XLXSBJDCLHQ( ");
|
||
SQL.Add(" V_XLXSBJDCLHQ_BJCLID,V_XLXSBJDCLHQ_BJDID, V_XLXSBJDCLHQ_WSJG,V_XLXSBJDCLHQ_HSJG, V_XLXSBJDCLHQ_WSJGF,V_XLXSBJDCLHQ_HSJGF, ");
|
||
SQL.Add(" V_XLXSBJDCLHQ_JGYBJCLID1,V_XLXSBJDCLHQ_WSJG1,V_XLXSBJDCLHQ_HSJG1,V_XLXSBJDCLHQ_JGBL1, ");
|
||
SQL.Add(" V_XLXSBJDCLHQ_ID,V_XLXSBJDCLHQ_TZRYID,V_XLXSBJDCLHQ_TZRYGH,V_XLXSBJDCLHQ_TZRYMC,V_XLXSBJDCLHQ_TIMESTAMP,V_XLXSBJDCLHQ_WHRID, V_XLXSBJDCLHQ_WHR, V_XLXSBJDCLHQ_WHSJ )");
|
||
SQL.Add(" values(");
|
||
SQL.Add(" :XLXSBJDCLHQ_BJCLID, :XLXSBJDCLHQ_BJDID, :XLXSBJDCLHQ_WSJG,:XLXSBJDCLHQ_HSJG, :XLXSBJDCLHQ_WSJGF, :XLXSBJDCLHQ_HSJGF,");
|
||
SQL.Add(" :V_XLXSBJDCLHQ_JGYBJCLID1,:V_XLXSBJDCLHQ_WSJG1,:V_XLXSBJDCLHQ_HSJG1,:V_XLXSBJDCLHQ_JGBL1, ");
|
||
SQL.Add(" :pCLVID,:pRYID,:pRYGH,:pRYMC,:pTIMESTAMP, :XLXSBJDCLHQ_WHRID, :XLXSBJDCLHQ_WHR, :XLXSBJDCLHQ_WHSJ )");
|
||
SQL.ParamByName("XLXSBJDCLHQ_BJCLID").Value = sBJCLID;
|
||
SQL.ParamByName("XLXSBJDCLHQ_BJDID").Value = sBJDID;
|
||
SQL.ParamByName("pCLVID").Value = sCLVID;
|
||
SQL.ParamByName("pRYID").Value = tSession.RYID;
|
||
SQL.ParamByName("pRYGH").Value = tSession.UserId;
|
||
SQL.ParamByName("pRYMC").Value = tSession.UserName;
|
||
SQL.ParamByName("pTIMESTAMP").Value = MISproUtils.GetServerTime();
|
||
SQL.ParamByName("XLXSBJDCLHQ_WSJG").Value = txtJGLCLJG.Value;
|
||
SQL.ParamByName("XLXSBJDCLHQ_HSJG").Value = txtJGLHSJG.Value;
|
||
SQL.ParamByName("XLXSBJDCLHQ_WSJGF").Value = txtJGLWSJGF.Value;
|
||
SQL.ParamByName("XLXSBJDCLHQ_HSJGF").Value = txtJGLHSJGF.Value;
|
||
SQL.ParamByName("V_XLXSBJDCLHQ_JGYBJCLID1").Value = sJGYBJCLID1;
|
||
SQL.ParamByName("V_XLXSBJDCLHQ_WSJG1").Value = txtJGYLCLJG.Value;
|
||
SQL.ParamByName("V_XLXSBJDCLHQ_HSJG1").Value = txtJGYLHSJG.Value;
|
||
SQL.ParamByName("V_XLXSBJDCLHQ_JGBL1").Value = fJGBL1;
|
||
SQL.ParamByName("XLXSBJDCLHQ_WHR").Value = tSession.UserName;
|
||
SQL.ParamByName("XLXSBJDCLHQ_WHRID").Value = tSession.UserId;
|
||
SQL.ParamByName("XLXSBJDCLHQ_WHSJ").Value = DateTime.Now;
|
||
dberp.ExecSQL(SQL);
|
||
}
|
||
}
|
||
//铜
|
||
else if (1 == flag)
|
||
{
|
||
//加工原料
|
||
if (txtJGYLCLJG.Value < 0)
|
||
{
|
||
ShowMessage("无税材料价格不允许小于0！");
|
||
return;
|
||
}
|
||
|
||
if (txtJGYLHSJG.Value < 0)
|
||
{
|
||
ShowMessage("含税材料价格不允许小于0！");
|
||
return;
|
||
}
|
||
if (dsBJDCLHQ.Tables[0].Rows.Count > 0)
|
||
{
|
||
//更新铜
|
||
SQL.Clear();
|
||
SQL.Add(" update V_XLXSBJDCLHQ ");
|
||
SQL.Add(" set V_XLXSBJDCLHQ_WSJG = :XLXSBJDCLHQ_WSJG,V_XLXSBJDCLHQ_HSJG=:XLXSBJDCLHQ_HSJG, ");
|
||
SQL.Add(" V_XLXSBJDCLHQ_WHRID = :XLXSBJDCLHQ_WHRID, V_XLXSBJDCLHQ_WHR = :XLXSBJDCLHQ_WHR, V_XLXSBJDCLHQ_WHSJ = :XLXSBJDCLHQ_WHSJ");
|
||
SQL.Add(" where V_XLXSBJDCLHQ_BJDID =:pBJDID and V_XLXSBJDCLHQ_BJCLID = :pBJCLID and V_XLXSBJDCLHQ_ID = :pCLVID and V_XLXSBJDCLHQ_TZRYID = :pRYID ");
|
||
SQL.ParamByName("XLXSBJDCLHQ_WSJG").Value = txtJGYLCLJG.Value;
|
||
SQL.ParamByName("XLXSBJDCLHQ_HSJG").Value = txtJGYLHSJG.Value;
|
||
SQL.ParamByName("XLXSBJDCLHQ_WHR").Value = tSession.UserName;
|
||
SQL.ParamByName("XLXSBJDCLHQ_WHRID").Value = tSession.UserId;
|
||
SQL.ParamByName("XLXSBJDCLHQ_WHSJ").Value = DateTime.Now;
|
||
SQL.ParamByName("pBJCLID").Value = sBJCLID;
|
||
SQL.ParamByName("pBJDID").Value = sBJDID;
|
||
SQL.ParamByName("pCLVID").Value = sCLVID;
|
||
SQL.ParamByName("pRYID").Value = tSession.RYID;
|
||
dberp.ExecSQL(SQL);
|
||
}
|
||
else
|
||
{
|
||
//插入
|
||
SQL.Clear();
|
||
SQL.Add(" insert into V_XLXSBJDCLHQ( ");
|
||
SQL.Add(" V_XLXSBJDCLHQ_BJCLID,V_XLXSBJDCLHQ_BJDID, V_XLXSBJDCLHQ_WSJG,V_XLXSBJDCLHQ_HSJG, ");
|
||
SQL.Add(" V_XLXSBJDCLHQ_ID,V_XLXSBJDCLHQ_TZRYID,V_XLXSBJDCLHQ_TZRYGH,V_XLXSBJDCLHQ_TZRYMC,V_XLXSBJDCLHQ_TIMESTAMP,V_XLXSBJDCLHQ_WHRID, V_XLXSBJDCLHQ_WHR, V_XLXSBJDCLHQ_WHSJ )");
|
||
SQL.Add(" values(");
|
||
SQL.Add(" :XLXSBJDCLHQ_BJCLID, :XLXSBJDCLHQ_BJDID, :XLXSBJDCLHQ_WSJG,:XLXSBJDCLHQ_HSJG,");
|
||
SQL.Add(" :pCLVID,:pRYID,:pRYGH,:pRYMC,:pTIMESTAMP, :XLXSBJDCLHQ_WHRID, :XLXSBJDCLHQ_WHR, :XLXSBJDCLHQ_WHSJ )");
|
||
SQL.ParamByName("XLXSBJDCLHQ_BJCLID").Value = sBJCLID;
|
||
SQL.ParamByName("XLXSBJDCLHQ_BJDID").Value = sBJDID;
|
||
SQL.ParamByName("pCLVID").Value = sCLVID;
|
||
SQL.ParamByName("pRYID").Value = tSession.RYID;
|
||
SQL.ParamByName("pRYGH").Value = tSession.UserId;
|
||
SQL.ParamByName("pRYMC").Value = tSession.UserName;
|
||
SQL.ParamByName("pTIMESTAMP").Value = MISproUtils.GetServerTime();
|
||
SQL.ParamByName("XLXSBJDCLHQ_WSJG").Value = txtJGYLCLJG.Value;
|
||
SQL.ParamByName("XLXSBJDCLHQ_HSJG").Value = txtJGYLHSJG.Value;
|
||
SQL.ParamByName("XLXSBJDCLHQ_WHR").Value = tSession.UserName;
|
||
SQL.ParamByName("XLXSBJDCLHQ_WHRID").Value = tSession.UserId;
|
||
SQL.ParamByName("XLXSBJDCLHQ_WHSJ").Value = DateTime.Now;
|
||
dberp.ExecSQL(SQL);
|
||
}
|
||
|
||
//处理 因为铜导致的--铜丝，铜带等数据的变更；2020.09.21【LF】铜带细分的物料价格变更
|
||
string sJGLBJCL = "";
|
||
string sJGLWLBJCL = "";
|
||
string sJGLBJCLID = "";
|
||
double JGLWSJGF = 0.0;
|
||
double JGLHSJGF = 0.0;
|
||
if (dsBJCL.Tables[0].Rows.Count > 0)
|
||
{
|
||
//判断 加工原料 铜
|
||
for (int i = 0; i < dsBJCL.Tables[0].Rows.Count; i++)
|
||
{
|
||
JGLWSJGF = 0.0;
|
||
JGLHSJGF = 0.0;
|
||
sJGLBJCLID = dsBJCL.Tables[0].Rows[i]["XLXSBJCL_BJCLID"].ToString().Trim();
|
||
if (!dsBJCL.Tables[0].Rows[i]["XLXSBJCL_JGYBJCLID"].ToString().Trim().Equals(""))
|
||
{
|
||
sJGLBJCL = sJGLBJCL + dsBJCL.Tables[0].Rows[i]["XLXSBJCL_BJCLMC"].ToString().Trim() + "、";
|
||
SQL.Clear();
|
||
//查询是否存在记录
|
||
SQL.Add("select 1 from V_XLXSBJDCLHQ where V_XLXSBJDCLHQ_BJDID =:pBJDID and V_XLXSBJDCLHQ_BJCLID = :pBJCLID ");
|
||
SQL.Add(" and V_XLXSBJDCLHQ_ID = :pCLVID and V_XLXSBJDCLHQ_TZRYID = :pRYID ");
|
||
SQL.ParamByName("pBJDID").Value = sBJDID;
|
||
SQL.ParamByName("pCLVID").Value = sCLVID;
|
||
SQL.ParamByName("pRYID").Value = tSession.RYID;
|
||
SQL.ParamByName("pBJCLID").Value = sJGLBJCLID;
|
||
DataSet ds = dberp.OpenDataSet(SQL);
|
||
if (ds.Tables[0].Rows.Count > 0)
|
||
{
|
||
SQL.Clear();
|
||
SQL.Add(" update V_XLXSBJDCLHQ ");
|
||
SQL.Add(" set V_XLXSBJDCLHQ_WSJG1 = :XLXSBJDCLHQ_WSJG,V_XLXSBJDCLHQ_HSJG1=:XLXSBJDCLHQ_HSJG, ");
|
||
SQL.Add(" V_XLXSBJDCLHQ_WHRID = :XLXSBJDCLHQ_WHRID, V_XLXSBJDCLHQ_WHR = :XLXSBJDCLHQ_WHR, V_XLXSBJDCLHQ_WHSJ = :XLXSBJDCLHQ_WHSJ");
|
||
SQL.Add(" where V_XLXSBJDCLHQ_BJDID =:pBJDID and V_XLXSBJDCLHQ_ID = :pCLVID and V_XLXSBJDCLHQ_TZRYID = :pRYID and V_XLXSBJDCLHQ_BJCLID = :pBJCLID ");
|
||
|
||
SQL.ParamByName("XLXSBJDCLHQ_WSJG").Value = txtJGYLCLJG.Value;
|
||
SQL.ParamByName("XLXSBJDCLHQ_HSJG").Value = txtJGYLHSJG.Value;
|
||
SQL.ParamByName("XLXSBJDCLHQ_WHR").Value = tSession.UserName;
|
||
SQL.ParamByName("XLXSBJDCLHQ_WHRID").Value = tSession.UserId;
|
||
SQL.ParamByName("XLXSBJDCLHQ_WHSJ").Value = DateTime.Now;
|
||
SQL.ParamByName("pBJCLID").Value = sJGLBJCLID;
|
||
SQL.ParamByName("pBJDID").Value = sBJDID;
|
||
SQL.ParamByName("pCLVID").Value = sCLVID;
|
||
SQL.ParamByName("pRYID").Value = tSession.RYID;
|
||
dberp.ExecSQL(SQL);
|
||
}
|
||
else
|
||
{
|
||
string sJGYBJCLID = string.Empty;
|
||
//'ZZZZZZZZ'
|
||
SQL.Clear();
|
||
SQL.Add(" select XLXSCLHQ_WSJGF,XLXSCLHQ_HSJGF,XLXSCLHQ_JGYBJCLID1 ");
|
||
SQL.Add(" from XLXSCLHQ ");
|
||
SQL.Add(" where XLXSCLHQ_JGBID= :pJGBID ");
|
||
SQL.Add(" and XLXSCLHQ_BJCLID=:pBJCLID ");
|
||
SQL.Add(" and XLXSCLHQ_YXQS=");
|
||
SQL.Add(" (");
|
||
SQL.Add(" select max(XLXSCLHQ_YXQS) as maxYXQS");
|
||
SQL.Add(" from XLXSCLHQ");
|
||
SQL.Add(" where XLXSCLHQ_JGBID= :pJGBID ");
|
||
SQL.Add(" and XLXSCLHQ_BJCLID=:pBJCLID");
|
||
SQL.Add(" and XLXSCLHQ_YXQS<=:pYXQS");
|
||
SQL.Add(" )");
|
||
//1-价格表行情 2-报价日行情
|
||
string tSQL = string.Format(" select 1 from XLXSBJFLBJRHQCL "
|
||
+ " where XLXSBJFLBJRHQCL_BJCLID = '{0}' and XLXSBJFLBJRHQCL_BJFLID = '{1}' ", sBJCLID, sBJFLID);
|
||
if (CMISproDataBase.ExistsRecord("DBERP", tSQL) || sBJDHQLY.Equals("2"))
|
||
{
|
||
SQL.ParamByName("pJGBID").Value = "ZZZZZZZZ";
|
||
SQL.ParamByName("pBJCLID").Value = sJGLBJCLID;
|
||
SQL.ParamByName("pYXQS").Value = sBJRQ;
|
||
DataSet dsBJRCLHQ = dberp.OpenDataSet(SQL);
|
||
if (dsBJRCLHQ.Tables[0].Rows.Count > 0)
|
||
{
|
||
JGLHSJGF = CMISproConvert.StrToFloat(dsBJRCLHQ.Tables[0].Rows[0]["XLXSCLHQ_HSJGF"].ToString().Trim());
|
||
JGLWSJGF = CMISproConvert.StrToFloat(dsBJRCLHQ.Tables[0].Rows[0]["XLXSCLHQ_WSJGF"].ToString().Trim());
|
||
sJGYBJCLID = dsBJRCLHQ.Tables[0].Rows[0]["XLXSCLHQ_JGYBJCLID1"].ToString().Trim();
|
||
}
|
||
|
||
}
|
||
else
|
||
{
|
||
SQL.ParamByName("pJGBID").Value = sJGBID;
|
||
SQL.ParamByName("pBJCLID").Value = sJGLBJCLID;
|
||
SQL.ParamByName("pYXQS").Value = sBJRQ;
|
||
DataSet dsJGBCLHQ = dberp.OpenDataSet(SQL);
|
||
if (dsJGBCLHQ.Tables[0].Rows.Count > 0)
|
||
{
|
||
JGLHSJGF = CMISproConvert.StrToFloat(dsJGBCLHQ.Tables[0].Rows[0]["XLXSCLHQ_HSJGF"].ToString().Trim());
|
||
JGLWSJGF = CMISproConvert.StrToFloat(dsJGBCLHQ.Tables[0].Rows[0]["XLXSCLHQ_WSJGF"].ToString().Trim());
|
||
sJGYBJCLID = dsJGBCLHQ.Tables[0].Rows[0]["XLXSCLHQ_JGYBJCLID1"].ToString().Trim();
|
||
}
|
||
|
||
}
|
||
|
||
SQL.Clear();
|
||
SQL.Add(" insert into V_XLXSBJDCLHQ( ");
|
||
SQL.Add(" V_XLXSBJDCLHQ_BJCLID,V_XLXSBJDCLHQ_BJDID, V_XLXSBJDCLHQ_WSJG1,V_XLXSBJDCLHQ_HSJG1,V_XLXSBJDCLHQ_WSJGF,V_XLXSBJDCLHQ_HSJGF,");
|
||
SQL.Add(" V_XLXSBJDCLHQ_JGYBJCLID1,V_XLXSBJDCLHQ_JGBL1,");
|
||
SQL.Add(" V_XLXSBJDCLHQ_ID,V_XLXSBJDCLHQ_TZRYID,V_XLXSBJDCLHQ_TZRYGH,V_XLXSBJDCLHQ_TZRYMC,V_XLXSBJDCLHQ_TIMESTAMP,V_XLXSBJDCLHQ_WHRID, V_XLXSBJDCLHQ_WHR, V_XLXSBJDCLHQ_WHSJ )");
|
||
SQL.Add(" VALUES(:pBJCLID,:pBJDID, :XLXSBJDCLHQ_WSJG,:XLXSBJDCLHQ_HSJG, ");
|
||
SQL.Add(" isnull(:XLXSBJDCLHQ_WSJGF,0),isnull(:XLXSBJDCLHQ_HSJGF,0), ");
|
||
SQL.Add(" :XLXSBJDCLHQ_JGYBJCLID1, isnull(:XLXSBJDCLHQ_JGBL1,0), ");
|
||
SQL.Add(" :pCLVID,:pRYID,:pRYGH,:pRYMC,:pTIMESTAMP,:XLXSBJDCLHQ_WHRID, :XLXSBJDCLHQ_WHR, :XLXSBJDCLHQ_WHSJ)");
|
||
SQL.ParamByName("XLXSBJDCLHQ_WSJG").Value = txtJGYLCLJG.Value;
|
||
SQL.ParamByName("XLXSBJDCLHQ_HSJG").Value = txtJGYLHSJG.Value;
|
||
SQL.ParamByName("XLXSBJDCLHQ_WSJGF").Value = JGLWSJGF;
|
||
SQL.ParamByName("XLXSBJDCLHQ_HSJGF").Value = JGLHSJGF;
|
||
SQL.ParamByName("XLXSBJDCLHQ_JGYBJCLID1").Value = sJGYBJCLID;
|
||
SQL.ParamByName("XLXSBJDCLHQ_JGBL1").Value = 1;
|
||
SQL.ParamByName("XLXSBJDCLHQ_WHR").Value = tSession.UserName;
|
||
SQL.ParamByName("XLXSBJDCLHQ_WHRID").Value = tSession.UserId;
|
||
SQL.ParamByName("XLXSBJDCLHQ_WHSJ").Value = DateTime.Now;
|
||
SQL.ParamByName("pBJCLID").Value = sJGLBJCLID;
|
||
SQL.ParamByName("pBJDID").Value = sBJDID;
|
||
SQL.ParamByName("pCLVID").Value = sCLVID;
|
||
SQL.ParamByName("pRYID").Value = tSession.RYID;
|
||
SQL.ParamByName("pRYGH").Value = tSession.UserId;
|
||
SQL.ParamByName("pRYMC").Value = tSession.UserName;
|
||
SQL.ParamByName("pTIMESTAMP").Value = MISproUtils.GetServerTime();
|
||
dberp.ExecSQL(SQL);
|
||
}
|
||
|
||
//更新或插入后处理加工料的HSJG、WSJG
|
||
SQL.Clear();
|
||
SQL.Add(" update V_XLXSBJDCLHQ set V_XLXSBJDCLHQ_WSJG=V_XLXSBJDCLHQ_WSJG1*V_XLXSBJDCLHQ_JGBL1+V_XLXSBJDCLHQ_WSJGF, ");
|
||
SQL.Add(" V_XLXSBJDCLHQ_HSJG=V_XLXSBJDCLHQ_HSJG1*V_XLXSBJDCLHQ_JGBL1+V_XLXSBJDCLHQ_HSJGF ");
|
||
SQL.Add(" where V_XLXSBJDCLHQ_BJDID =:pBJDID and V_XLXSBJDCLHQ_ID = :pCLVID and V_XLXSBJDCLHQ_TZRYID = :pRYID and V_XLXSBJDCLHQ_BJCLID = :pBJCLID ");
|
||
SQL.ParamByName("pBJCLID").Value = sJGLBJCLID;
|
||
SQL.ParamByName("pBJDID").Value = sBJDID;
|
||
SQL.ParamByName("pCLVID").Value = sCLVID;
|
||
SQL.ParamByName("pRYID").Value = tSession.RYID;
|
||
dberp.ExecSQL(SQL);
|
||
|
||
//#region 更新XLXSBJD_TJ,XLXSBJD_LJ---不用更新，调整材料行情确定时会更新
|
||
//if (!PageParam.GetRTrimString("TBJCLID").Equals(""))
|
||
//{
|
||
// SQL.Clear();
|
||
// SQL.Add("update XLXSBJD set XLXSBJD_TJ=(select ");
|
||
// if (PageParam.GetRTrimString("HSBZ").Equals("Y"))
|
||
// SQL.Add("XLXSBJDCLHQ_HSJG ");
|
||
// else
|
||
// SQL.Add("XLXSBJDCLHQ_WSJG ");
|
||
// SQL.Add(" from XLXSBJDCLHQ ");
|
||
// SQL.Add("where XLXSBJDCLHQ_BJDID=:pBJDID");
|
||
// SQL.Add(" and XLXSBJDCLHQ_BJCLID=:pTBJCLID");
|
||
// SQL.Add(") ");
|
||
// SQL.Add("where XLXSBJD_BJDID=:pBJDID");
|
||
// SQL.ParamByName("pBJDID").Value = sBJDID;
|
||
// SQL.ParamByName("pTBJCLID").Value = PageParam.GetRTrimString("TBJCLID");
|
||
// dberp.ExecSQL(SQL);
|
||
//}
|
||
//if (!PageParam.GetRTrimString("LBJCLID").Equals(""))
|
||
//{
|
||
// SQL.Clear();
|
||
// SQL.Add("update XLXSBJD set XLXSBJD_LJ=(select ");
|
||
// if (PageParam.GetRTrimString("HSBZ").Equals("Y"))
|
||
// SQL.Add("XLXSBJDCLHQ_HSJG ");
|
||
// else
|
||
// SQL.Add("XLXSBJDCLHQ_WSJG ");
|
||
// SQL.Add(" from XLXSBJDCLHQ ");
|
||
// SQL.Add("where XLXSBJDCLHQ_BJDID=:pBJDID");
|
||
// SQL.Add(" and XLXSBJDCLHQ_BJCLID=:pLBJCLID");
|
||
// SQL.Add(") ");
|
||
// SQL.Add("where XLXSBJD_BJDID=:pBJDID");
|
||
// SQL.ParamByName("pBJDID").Value = sBJDID;
|
||
// SQL.ParamByName("pLBJCLID").Value = PageParam.GetRTrimString("LBJCLID");
|
||
// dberp.ExecSQL(SQL);
|
||
//}
|
||
//#endregion
|
||
|
||
#region 补充----同步调整对应的物料行情
|
||
|
||
SQL.Clear();
|
||
SQL.Add(" SELECT XLXSBJCLWL_WLID,XLXSBJCLWL_BJCLID,XLXSBJCL_BJCLMC FROM XLXSBJCLWL ");
|
||
SQL.Add(" left join XLXSBJCL on XLXSBJCL_BJCLID=XLXSBJCLWL_BJCLID ");
|
||
SQL.Add(" WHERE XLXSBJCL_BJHQ = '2' and isnull(XLXSBJCL_JGYBJCLID,' ') <> ' ' ");
|
||
DataSet dsBJCLWL = dberp.OpenDataSet(SQL);
|
||
if (dsBJCLWL.Tables[0].Rows.Count > 0)
|
||
{
|
||
for (int j = 0; j < dsBJCLWL.Tables[0].Rows.Count; j++)
|
||
{
|
||
if (dsBJCLWL.Tables[0].Rows[j]["XLXSBJCLWL_BJCLID"].ToString().Trim().Equals(sJGLBJCLID))
|
||
{
|
||
if (!sJGLWLBJCL.Contains(dsBJCLWL.Tables[0].Rows[j]["XLXSBJCL_BJCLMC"].ToString().Trim()))
|
||
{
|
||
sJGLWLBJCL = sJGLWLBJCL + dsBJCLWL.Tables[0].Rows[j]["XLXSBJCL_BJCLMC"].ToString().Trim() + "、";
|
||
}
|
||
|
||
string sWLID = dsBJCLWL.Tables[0].Rows[j]["XLXSBJCLWL_WLID"].ToString().Trim();
|
||
SQL.Clear();
|
||
//查询是否存在插入记录
|
||
SQL.Add("select 1 from V_XLXSBJDWLHQ where V_XLXSBJDWLHQ_BJDID=:pBJDID and V_XLXSBJDWLHQ_WLID=:pWLID ");
|
||
SQL.Add(" and V_XLXSBJDWLHQ_ID = :pWLVID and V_XLXSBJDWLHQ_TZRYID = :pRYID ");
|
||
SQL.ParamByName("pBJDID").Value = sBJDID;
|
||
SQL.ParamByName("pWLVID").Value = sWLVID;
|
||
SQL.ParamByName("pRYID").Value = tSession.RYID;
|
||
SQL.ParamByName("pWLID").Value = sWLID;
|
||
DataSet dsWLHQ = dberp.OpenDataSet(SQL);
|
||
if (dsWLHQ.Tables[0].Rows.Count > 0)
|
||
{
|
||
SQL.Clear();
|
||
SQL.Add(" update V_XLXSBJDWLHQ ");
|
||
SQL.Add(" set V_XLXSBJDWLHQ_WSJG1 = :XLXSBJDWLHQ_WSJG,V_XLXSBJDWLHQ_HSJG1=:XLXSBJDWLHQ_HSJG, ");
|
||
SQL.Add(" V_XLXSBJDWLHQ_WHRID = :XLXSBJDWLHQ_WHRID, V_XLXSBJDWLHQ_WHR = :XLXSBJDWLHQ_WHR, V_XLXSBJDWLHQ_WHSJ = :XLXSBJDWLHQ_WHSJ");
|
||
SQL.Add(" where V_XLXSBJDWLHQ_BJDID=:pBJDID and V_XLXSBJDWLHQ_ID = :pWLVID and V_XLXSBJDWLHQ_TZRYID = :pRYID and V_XLXSBJDWLHQ_WLID=:pWLID ");
|
||
SQL.ParamByName("XLXSBJDWLHQ_WSJG").Value = txtJGYLCLJG.Value;
|
||
SQL.ParamByName("XLXSBJDWLHQ_HSJG").Value = txtJGYLHSJG.Value;
|
||
SQL.ParamByName("XLXSBJDWLHQ_WHR").Value = tSession.UserName;
|
||
SQL.ParamByName("XLXSBJDWLHQ_WHRID").Value = tSession.UserId;
|
||
SQL.ParamByName("XLXSBJDWLHQ_WHSJ").Value = DateTime.Now;
|
||
SQL.ParamByName("pBJDID").Value = sBJDID;
|
||
SQL.ParamByName("pWLVID").Value = sWLVID;
|
||
SQL.ParamByName("pRYID").Value = tSession.RYID;
|
||
SQL.ParamByName("pWLID").Value = sWLID;
|
||
dberp.ExecSQL(SQL);
|
||
}
|
||
else
|
||
{
|
||
SQL.Clear();
|
||
SQL.Add(" insert into V_XLXSBJDWLHQ( ");
|
||
SQL.Add(" V_XLXSBJDWLHQ_BJDID,V_XLXSBJDWLHQ_WLID, V_XLXSBJDWLHQ_WSJG1,V_XLXSBJDWLHQ_HSJG1, V_XLXSBJDWLHQ_WSJGF,V_XLXSBJDWLHQ_HSJGF,");
|
||
SQL.Add(" V_XLXSBJDWLHQ_JGYBJCLID1,V_XLXSBJDWLHQ_JGBL1, ");
|
||
SQL.Add(" V_XLXSBJDWLHQ_ID,V_XLXSBJDWLHQ_TZRYID,V_XLXSBJDWLHQ_TZRYGH,V_XLXSBJDWLHQ_TZRYMC,V_XLXSBJDWLHQ_TIMESTAMP,V_XLXSBJDWLHQ_WHRID, V_XLXSBJDWLHQ_WHR, V_XLXSBJDWLHQ_WHSJ)");
|
||
SQL.Add(" SELECT ");
|
||
SQL.Add(" :XLXSBJDWLHQ_BJDID,:pWLID,:XLXSBJDWLHQ_WSJG,:XLXSBJDWLHQ_HSJG,");
|
||
SQL.Add(" isnull(XLXSWLHQ_WSJGF,0),isnull(XLXSWLHQ_HSJGF,0), ");
|
||
SQL.Add(" isnull(XLXSWLHQ_JGYBJCLID1,' '),isnull(XLXSWLHQ_JGBL1,0), ");
|
||
SQL.Add(" :pWLVID,:pRYID,:pRYGH,:pRYMC,:pTIMESTAMP,:XLXSBJDWLHQ_WHRID, :XLXSBJDWLHQ_WHR, :XLXSBJDWLHQ_WHSJ ");
|
||
SQL.Add(" from XLXSWLHQ ");
|
||
SQL.Add(" where XLXSWLHQ_JGBID=' '");
|
||
SQL.Add(" and XLXSWLHQ_WLID=:pWLID");
|
||
SQL.Add(" and XLXSWLHQ_YXQS=");
|
||
SQL.Add(" (");
|
||
SQL.Add(" select max(XLXSWLHQ_YXQS) as maxYXQS");
|
||
SQL.Add(" from XLXSWLHQ");
|
||
SQL.Add(" where XLXSWLHQ_JGBID=' ' ");
|
||
SQL.Add(" and XLXSWLHQ_WLID=:pWLID");
|
||
SQL.Add(" and XLXSWLHQ_YXQS<=:pBJRQ ");
|
||
SQL.Add(" and (XLXSWLHQ_YXQZ>=:pBJRQ or XLXSWLHQ_YXQZ is null)");
|
||
SQL.Add(" )");
|
||
//SQL.Add(" and XLXSWLHQ_YXQZ is null ");
|
||
SQL.ParamByName("XLXSBJDWLHQ_BJDID").Value = sBJDID;
|
||
SQL.ParamByName("pWLVID").Value = sWLVID;
|
||
SQL.ParamByName("pRYID").Value = tSession.RYID;
|
||
SQL.ParamByName("pRYGH").Value = tSession.UserId;
|
||
SQL.ParamByName("pRYMC").Value = tSession.UserName;
|
||
SQL.ParamByName("pTIMESTAMP").Value = MISproUtils.GetServerTime();
|
||
SQL.ParamByName("pWLID").Value = sWLID;
|
||
SQL.ParamByName("XLXSBJDWLHQ_WSJG").Value = txtJGYLCLJG.Value;
|
||
SQL.ParamByName("XLXSBJDWLHQ_HSJG").Value = txtJGYLHSJG.Value;
|
||
SQL.ParamByName("XLXSBJDWLHQ_WHR").Value = tSession.UserName;
|
||
SQL.ParamByName("XLXSBJDWLHQ_WHRID").Value = tSession.UserId;
|
||
SQL.ParamByName("XLXSBJDWLHQ_WHSJ").Value = DateTime.Now;
|
||
SQL.ParamByName("pBJRQ").Value = sBJRQ;
|
||
dberp.ExecSQL(SQL);
|
||
}
|
||
//更新/插入后处理加工料的HSJG、WSJG
|
||
SQL.Clear();
|
||
SQL.Add(" update V_XLXSBJDWLHQ set V_XLXSBJDWLHQ_WSJG=V_XLXSBJDWLHQ_WSJG1*V_XLXSBJDWLHQ_JGBL1+V_XLXSBJDWLHQ_WSJGF, ");
|
||
SQL.Add(" V_XLXSBJDWLHQ_HSJG=V_XLXSBJDWLHQ_HSJG1*V_XLXSBJDWLHQ_JGBL1+V_XLXSBJDWLHQ_HSJGF ");
|
||
SQL.Add(" where V_XLXSBJDWLHQ_BJDID=:pBJDID and V_XLXSBJDWLHQ_ID = :pWLVID and V_XLXSBJDWLHQ_TZRYID = :pRYID and V_XLXSBJDWLHQ_WLID=:pWLID ");
|
||
SQL.ParamByName("pBJDID").Value = sBJDID;
|
||
SQL.ParamByName("pWLVID").Value = sWLVID;
|
||
SQL.ParamByName("pRYID").Value = tSession.RYID;
|
||
SQL.ParamByName("pWLID").Value = sWLID;
|
||
dberp.ExecSQL(SQL);
|
||
}
|
||
}
|
||
}
|
||
|
||
#endregion
|
||
}
|
||
}
|
||
sJGLBJCL = sJGLBJCL.TrimEnd('、');
|
||
sJGLWLBJCL = sJGLWLBJCL.TrimEnd('、');
|
||
if (!sJGLBJCL.Equals("") && !sJGLWLBJCL.Equals(""))
|
||
{
|
||
ShowMessage("已同步调整 " + sJGLBJCL + " 的材料价格！" + "\r\n" + "已同步调整 " + sJGLWLBJCL + " 的对应物料价格！");
|
||
}
|
||
else if (!sJGLBJCL.Equals(""))
|
||
{
|
||
ShowMessage("已同步调整 " + sJGLBJCL + " 的材料价格！");
|
||
}
|
||
else if (!sJGLWLBJCL.Equals(""))
|
||
{
|
||
ShowMessage("已同步调整 " + sJGLWLBJCL + " 的对应物料价格！");
|
||
}
|
||
}
|
||
|
||
}
|
||
else
|
||
{
|
||
//不处理
|
||
}
|
||
}
|
||
catch (Exception ex)
|
||
{
|
||
ShowMessage("调整出现错误，请联系系统管理员！" + ex);
|
||
}
|
||
|
||
//使用脚本给父页面的隐藏控件赋值，调用父页面的控件事件
|
||
DialogOperationScript dos = new DialogOperationScript(this);
|
||
dos.ClickOwnerButton(PageParam.GetRTrimString("CallBackCtrlID"));
|
||
dos.CloseSelf();
|
||
dos.Execute();
|
||
}
|
||
|
||
protected void btnQX_Click(object sender, EventArgs e)
|
||
{
|
||
CloseWindow();
|
||
}
|
||
|
||
//加工费
|
||
protected void txtJGLWSJGF_OnTextChanged(object sender, EventArgs e)
|
||
{
|
||
double dJGBL1 = CMISproConvert.StrToFloat(PageParam.GetRTrimString("JGBL1"));
|
||
txtJGLCLJG.Value = NumberUtils.RoundX(txtJGLWSJGF.Value + txtJCCLJG.Value * dJGBL1, XLBJDUtils.BJCLPriceDecimal);
|
||
txtJGLHSJGF.Value = NumberUtils.RoundX(txtJGLWSJGF.Value * (1 + txtJGLZZSL.Value / 100.0), XLBJDUtils.BJCLPriceDecimal);
|
||
txtJGLHSJG.Value = NumberUtils.RoundX(txtJGLHSJGF.Value + txtJCHSJG.Value * dJGBL1, XLBJDUtils.BJCLPriceDecimal);
|
||
}
|
||
|
||
protected void txtJGLHSJGF_OnTextChanged(object sender, EventArgs e)
|
||
{
|
||
double dJGBL1 = CMISproConvert.StrToFloat(PageParam.GetRTrimString("JGBL1"));
|
||
txtJGLHSJG.Value = NumberUtils.RoundX(txtJGLHSJGF.Value + txtJCHSJG.Value * dJGBL1, XLBJDUtils.BJCLPriceDecimal);
|
||
txtJGLWSJGF.Value = NumberUtils.RoundX(txtJGLHSJGF.Value / (1 + txtJGLZZSL.Value / 100.0), XLBJDUtils.BJCLPriceDecimal);
|
||
txtJGLCLJG.Value = NumberUtils.RoundX(txtJGLWSJGF.Value + txtJCCLJG.Value * dJGBL1, XLBJDUtils.BJCLPriceDecimal);
|
||
}
|
||
|
||
//材料价格
|
||
protected void txtJGYLCLJG_OnTextChanged(object sender, EventArgs e)
|
||
{
|
||
txtJGYLHSJG.Value = NumberUtils.RoundX(txtJGYLCLJG.Value * (1 + txtJGYLZZSL.Value / 100.0), XLBJDUtils.BJCLPriceDecimal);
|
||
}
|
||
|
||
protected void txtJGYLHSJG_OnTextChanged(object sender, EventArgs e)
|
||
{
|
||
txtJGYLCLJG.Value = NumberUtils.RoundX(txtJGYLHSJG.Value / (1 + txtJGYLZZSL.Value / 100.0), XLBJDUtils.BJCLPriceDecimal);
|
||
}
|
||
|
||
#endregion
|
||
}
|
||
}
|