1214 lines
51 KiB
C#
1214 lines
51 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_MODEL.Dialog;
|
|
using GThinking.N_MISPRO.Utility;
|
|
using GThinking.N_PUBLIC2;
|
|
using GThinking.N_MISPRO.TableCache;
|
|
using GThinking.N_MISPRO.MISPROAS;
|
|
using System.Collections.Generic;
|
|
using GThinking.N_CONTROL;
|
|
using GThinking.N_MISPRO.Caching;
|
|
|
|
|
|
namespace GThinking.N_XLXSBJ
|
|
{
|
|
public partial class BJFLInfo : SingleCardBase
|
|
{
|
|
XLXSBJFL entity = new XLXSBJFL();
|
|
|
|
#region Page类事件继承
|
|
protected void Page_Load(object sender, EventArgs e)
|
|
{
|
|
this.UMID = 100860023;
|
|
this.UMName = "线缆销售报价分类";
|
|
this.CurMaster = Master;
|
|
this.CurEntity = entity;
|
|
this.PageHeight = 650;
|
|
this.PageWidth = 750;
|
|
if (!IsPostBack)
|
|
{
|
|
cbxMXBH.ClearItems();
|
|
cbxMXBH.Items.Add(new ListItem("报价价格表", "JGB"));
|
|
cbxMXBH.Items.Add(new ListItem("表价实时计算价格表", "JGE"));
|
|
|
|
cbxKJJGLM.ClearItems();
|
|
cbxKJJGLM.Items.Add(new ListItem("表价", "JGBBJ"));
|
|
cbxKJJGLM.Items.Add(new ListItem("报价", "CPBJ"));
|
|
cbxKJJGLM.Items.Add(new ListItem("报价金额", "BJJE"));
|
|
cbxKJJGLM.ShowValue = false;
|
|
|
|
cbxBJJCLLX.ClearItems();
|
|
cbxBJJCLLX.Items.Add(new ListItem("", ""));
|
|
cbxBJJCLLX.Items.Add(new ListItem("(调整后报价金额-表价金额)/调整后报价金额*100", "1"));
|
|
cbxBJJCLLX.Items.Add(new ListItem("(表价金额-调整后报价金额)/表价金额*100", "2"));
|
|
cbxBJJCLLX.Items.Add(new ListItem("表价金额/调整后报价金额*100", "3"));
|
|
cbxBJJCLLX.Items.Add(new ListItem("(调整后报价金额-表价金额)/表价金额*100", "4"));
|
|
|
|
cbxLJJCLLX.ClearItems();
|
|
cbxLJJCLLX.Items.Add(new ListItem("", ""));
|
|
cbxLJJCLLX.Items.Add(new ListItem("(调整后报价金额-价格表行情料价金额)/调整后报价金额*100", "1"));
|
|
cbxLJJCLLX.Items.Add(new ListItem("(调整后报价金额-报价单行情料价金额)/调整后报价金额*100", "2"));
|
|
cbxLJJCLLX.Items.Add(new ListItem("(调整后报价金额-报价单行情料价金额)/报价单行情料价金额*100", "3"));
|
|
|
|
|
|
cbxBJLJJCL.ClearItems();
|
|
cbxBJLJJCL.Items.Add(new ListItem("", ""));
|
|
cbxBJLJJCL.Items.Add(new ListItem("(表价金额-报价单行情料价金额)/表价金额*100", "1"));
|
|
|
|
cbxZDXJJCLLX.ClearItems();
|
|
cbxZDXJJCLLX.Items.Add(new ListItem("", ""));
|
|
cbxZDXJJCLLX.Items.Add(new ListItem("(调整后报价金额-最低限价金额)/调整后报价金额*100", "1"));
|
|
|
|
cbxYXJJCLLX.ClearItems();
|
|
cbxYXJJCLLX.Items.Add(new ListItem("", ""));
|
|
cbxYXJJCLLX.Items.Add(new ListItem("(1-最低限价/意向价)*100", "1"));
|
|
|
|
cbxTZJGBBJ.ClearItems();
|
|
cbxTZJGBBJ.Items.Add(new ListItem("不允许调整表价", "1"));
|
|
cbxTZJGBBJ.Items.Add(new ListItem("允许调整表价", "2"));
|
|
cbxTZJGBBJ.Items.Add(new ListItem("仅允许调整无清单产品的表价", "3"));
|
|
cbxTZJGBBJ.Items.Add(new ListItem("仅允许调整表价为0的产品的表价", "4"));
|
|
|
|
cbxTZBJDHQLJ.ClearItems();
|
|
cbxTZBJDHQLJ.Items.Add(new ListItem("不允许调整报价单行情料价", "1"));
|
|
cbxTZBJDHQLJ.Items.Add(new ListItem("仅允许调整无清单产品的报价单行情料价", "2"));
|
|
cbxTZBJDHQLJ.Items.Add(new ListItem("允许调整报价单材料行情料价", "3"));
|
|
|
|
cbxTZBJ.ClearItems();
|
|
cbxTZBJ.Items.Add(new ListItem("不允许调整报价", "1"));
|
|
cbxTZBJ.Items.Add(new ListItem("允许调整报价", "2"));
|
|
|
|
SetColorComboBox(cbxBJDYBJTXS);
|
|
SetColorComboBox(cbxBJQSTXS);
|
|
SetColorComboBox(cbxZDXJJCLTXS);
|
|
WorkFlowUtils.SetCheckedDropDownList_WFPROC("XLXSBJ_BJD", cbxKJJGHJ);
|
|
|
|
cbxLJJCLPLTJFW.ClearItems();
|
|
cbxLJJCLPLTJFW.Items.Add(new ListItem("无表价", "1"));
|
|
}
|
|
base.InitPage();
|
|
Master.EnableAttachBtn = false;
|
|
HiddenField HiddenGRPID = ((HiddenField)CurMaster.FindControl("txtDOCGRPID"));
|
|
if (HiddenGRPID != null)
|
|
txtDOCGRPID.Value = HiddenGRPID.Value;
|
|
SyncAttachControl();
|
|
}
|
|
#endregion
|
|
|
|
#region 模板事件继承
|
|
|
|
protected override void LoadRecord()
|
|
{
|
|
if (!IsPostBack)
|
|
{
|
|
this.CurEntity.Param.Add("XLXSBJFL_BJFLID", PageParam.GetRTrimString("XLXSBJFL_BJFLID").Trim());
|
|
}
|
|
else
|
|
{
|
|
this.CurEntity.Param.Add("XLXSBJFL_BJFLID", txtOLDBJFLID.Value);
|
|
}
|
|
|
|
base.LoadRecord();
|
|
cbxBJDYBJTXS.SelectedValue = txtBJDYBJTXS.Value;
|
|
cbxBJDYBJTXS.SelectedText = XLXSBJFL.GetColourMCByID(cbxBJDYBJTXS.SelectedValue);
|
|
cbxBJQSTXS.SelectedValue = txtBJQSTXS.Value;
|
|
cbxBJQSTXS.SelectedText = XLXSBJFL.GetColourMCByID(cbxBJQSTXS.SelectedValue);
|
|
cbxZDXJJCLTXS.SelectedValue = txtZDXJJCLTXS.Value;
|
|
cbxZDXJJCLTXS.SelectedText = XLXSBJFL.GetColourMCByID(cbxZDXJJCLTXS.SelectedValue);
|
|
txtZDXJGS.Text = XLXSBJFL.GetZDXJGSMC(txtValue.Value.Trim());
|
|
txtJSJGS.Text = XLXSBJFL.GetZDXJGSMC(txtJSJGSValue.Value.Trim());
|
|
txtOLD_TBJCLID.Value = cbxTBJCLID.SelectedValue.Trim();
|
|
txtOLD_LBJCLID.Value = cbxLBJCLID.SelectedValue.Trim();
|
|
}
|
|
|
|
protected override void OnNewRecorder()
|
|
{
|
|
base.OnNewRecorder();
|
|
txtOLDBJFLID.Value = "";
|
|
txtDOCGRPID.Value = "0";
|
|
SyncAttachControl();
|
|
datQYSJ.Text = CMISproConvert.ConvertDate(DateTime.Now.ToString());
|
|
chkTYBZ.Checked = false;
|
|
txtWHR.Text = tSession.UserName;
|
|
txtWHRID.Value = tSession.UserId;
|
|
datWHSJ.Value = CMISproConvert.ConvertTime(DateTime.Now);
|
|
txtZDXJGS.Text = "";
|
|
txtJSJGS.Text = "";
|
|
txtValue.Value = "";
|
|
txtJSJGSValue.Value = "";
|
|
chkMRCKC.Checked = false;
|
|
chkXSJGBJJ.Checked = false;
|
|
chkXSJGBBJJCE.Checked = false;
|
|
chkTZCLHQ.Checked = false;
|
|
chkTZWLHQ.Checked = false;
|
|
cbxTZJGBBJ.SelectedValue = "1";
|
|
cbxTZBJDHQLJ.SelectedValue = "1";
|
|
cbxTZBJ.SelectedValue = "2";
|
|
cbxBJJCLLX.SelectedValue = "1";
|
|
|
|
cbxLJJCLLX.SelectedValue = "1";
|
|
cbxBJDHQLY.SelectedValue = "1";
|
|
cbxBJCPFZJS.SelectedValue = "1";
|
|
chkXHABJCSDP.Checked = false;
|
|
chkBABZFGDY.Checked = false;
|
|
chkXSTZCPBJ.Checked = false;
|
|
chkXSTZBJJE.Checked = false;
|
|
|
|
chkXSYZ.Checked = false;
|
|
chkXSBH.Checked = false;
|
|
chkXSYSCP.Checked = false;
|
|
chkTLJTZGXQTCL.Checked = false;
|
|
|
|
chkJYF.Checked = false;
|
|
chkBJHYF.Checked = false;
|
|
cbxYFWLID.SelectedValue = "";
|
|
|
|
chkJJZJGBXH.Checked = false;
|
|
chkJJZJGBXH.Enabled = false;
|
|
|
|
cbxMXBH.SelectedValue = "JGB";
|
|
cbxBJDYBJTXS.SelectedValue = "#FF0000";
|
|
cbxBJQSTXS.SelectedValue = "#FF0000";
|
|
cbxZDXJJCLTXS.SelectedValue = "#FF0000";
|
|
txtZDXJJCLXX.Text = "0";
|
|
|
|
cbxLJJCLPLTJFW.SelectedValue = "1";
|
|
|
|
cbxBJYZJY.SelectedValue = "N";
|
|
|
|
txtCPBJMRXSWS.Value = CMISproConvert.StrToFloat(GetOption(100860000, "BJU002"));
|
|
FormAreaUpdate();
|
|
|
|
}
|
|
|
|
protected override void OnCopyRecorder()
|
|
{
|
|
base.OnCopyRecorder();
|
|
//txtOLDBJFLID.Value = "";
|
|
txtDOCGRPID.Value = "0";
|
|
SyncAttachControl();
|
|
datQYSJ.Text = CMISproConvert.ConvertDate(DateTime.Now.ToString());
|
|
chkTYBZ.Checked = false;
|
|
datTYSJ.Text = "";
|
|
txtWHR.Text = tSession.UserName;
|
|
txtWHRID.Value = tSession.UserId;
|
|
datWHSJ.Value = CMISproConvert.ConvertTime(DateTime.Now);
|
|
txtZDXJGS.Text = "";
|
|
txtJSJGS.Text = "";
|
|
txtValue.Value = "";
|
|
txtJSJGSValue.Value = "";
|
|
chkJYF.Checked = false;
|
|
chkBJHYF.Checked = false;
|
|
cbxYFWLID.SelectedValue = "";
|
|
|
|
|
|
}
|
|
|
|
protected override void BeforeAttach()
|
|
{
|
|
attDoc.WorkTableName = "XLXSBJFL";
|
|
attDoc.UpdCondition = string.Format("XLXSBJFL_BJFLID='{0}'", txtOLDBJFLID.Value.Trim());
|
|
|
|
base.BeforeAttach();
|
|
}
|
|
|
|
protected override void OnPreRender(EventArgs e)
|
|
{
|
|
base.OnPreRender(e);
|
|
}
|
|
|
|
protected override bool DataLogicValid()
|
|
{
|
|
string sSQL = "";
|
|
if (txtBJFLMC.Text.ToString().Trim().Equals(""))
|
|
{
|
|
ShowMessage("报价分类名称不能为空！");
|
|
return false;
|
|
}
|
|
if (chkJYF.Checked)
|
|
{
|
|
if (cbxYFWLID.SelectedValue.Trim().Equals(""))
|
|
{
|
|
ShowMessage("勾选计运费，运费物料不允许为空！");
|
|
return false;
|
|
}
|
|
}
|
|
|
|
if (cbxJGBTJYSS.SelectedValue.Trim().Contains("3") && !cbxJGBTJYSS.SelectedValue.Trim().Equals("3"))
|
|
{
|
|
ShowMessage("价格表调价因素3只能单独使用！");
|
|
return false;
|
|
}
|
|
if (cbxJGBTJYSS.SelectedValue.Trim().Equals("3"))
|
|
{
|
|
if (!cbxBJDHQLY.SelectedValue.Trim().Equals("1"))
|
|
{
|
|
ShowMessage("价格表调价因素3时，报价单行情来源仅能选择“1|价格表行情”！");
|
|
return false;
|
|
}
|
|
}
|
|
|
|
if (ControlState == TControlState.ctsEdit)
|
|
{
|
|
if (!txtOLDBJFLID.Value.ToString().Trim().Equals(txtBJFLID.Text.ToString().Trim()))
|
|
{
|
|
sSQL = string.Format("select XLXSBJFL_BJFLID from XLXSBJFL where XLXSBJFL_BJFLID = '{0}'", txtBJFLID.Text.ToString().Trim());
|
|
if (CMISproDataBase.ExistsRecord("DBERP", sSQL))
|
|
{
|
|
string sHint = string.Format("报价分类号'{0}'在线缆销售报价分类中已经存在，请重新输入编码！", txtBJFLID.Text.ToString().Trim());
|
|
ShowMessage(sHint);
|
|
return false;
|
|
}
|
|
|
|
if (txtBJFLID.Text.Trim().Equals("--------"))
|
|
{
|
|
ShowMessage("“--------”为系统内置演示分类号，请修改分类号重新保存！");
|
|
return false;
|
|
}
|
|
}
|
|
}
|
|
|
|
if ((ControlState == TControlState.ctsInsert) || (ControlState == TControlState.ctsCopy))
|
|
{
|
|
sSQL = string.Format("select 1 from XLXSBJFL where XLXSBJFL_BJFLID = '{0}'", txtBJFLID.Text.ToString());
|
|
if (CMISproDataBase.ExistsRecord("DBERP", sSQL))
|
|
{
|
|
string sHint = string.Format("报价分类号'{0}'在线缆销售报价分类中已经存在，请重新输入编码！", txtBJFLID.Text.ToString().Trim());
|
|
ShowMessage(sHint);
|
|
return false;
|
|
}
|
|
|
|
if (txtBJFLID.Text.Trim().Equals("--------"))
|
|
{
|
|
ShowMessage("“--------”为系统内置演示分类号，请修改分类号重新保存！");
|
|
return false;
|
|
}
|
|
}
|
|
|
|
|
|
if (datQYSJ.Text.Trim() != "" && datTYSJ.Text.Trim() != "")
|
|
{
|
|
if (Convert.ToDateTime(datQYSJ.Text.Trim()) > Convert.ToDateTime(datTYSJ.Text.Trim()))
|
|
{
|
|
ShowMessage("停用日期不允许小于启用日期！");
|
|
return false;
|
|
}
|
|
}
|
|
|
|
if (cbxMXBH.SelectedValue.Trim().Equals("JGB") && cbxJGBTJYSS.SelectedValue.Trim().Equals(""))
|
|
{
|
|
ShowMessage("JGB类型下，价格表调价因素不允许为空！");
|
|
return false;
|
|
}
|
|
if (cbxMXBH.SelectedValue.Trim().Equals("JGE") && !chkJLBJDHQ.Checked)
|
|
{
|
|
ShowMessage("JGE类型下，记录报价单行情必须勾选！");
|
|
return false;
|
|
}
|
|
|
|
if (chkXSDZXJ.Checked && cbxZDXJJCLLX.SelectedValue.Trim().Equals(""))
|
|
{
|
|
ShowMessage("显示最低限价时，最低限价价差率公式不允许为空！");
|
|
return false;
|
|
}
|
|
|
|
if ((!chkXSDZXJ.Checked)&&(!cbxZDXJJCLLX.SelectedValue.Trim().Equals("")))
|
|
{
|
|
ShowMessage("最低限价价差率公式不为空时，必须勾选显示最低限价！");
|
|
return false;
|
|
}
|
|
if (cbxYXJJCLLX.SelectedValue == "1" && !chkXSDZXJ.Checked)
|
|
{
|
|
ShowMessage("意向价价差率公式为(1-最低限价/意向价)*100，请勾选显示最低限价！");
|
|
return false;
|
|
}
|
|
|
|
|
|
return base.DataLogicValid();
|
|
}
|
|
|
|
protected override bool Master_BeforeDeleteAction(object sender, EventArgs e)
|
|
{
|
|
if (txtBJFLID.Text.Trim().Equals("--------"))
|
|
{
|
|
ShowMessage("演示分类不允许删除！");
|
|
return false;
|
|
}
|
|
//已在报价单模块使用
|
|
string sSQL = string.Format("select 1 from XLXSBJD where XLXSBJD_BJFLID = '{0}'", txtBJFLID.Text);
|
|
if (CMISproDataBase.ExistsRecord("DBERP", sSQL))
|
|
{
|
|
ShowMessage("已被报价单使用，不允许删除！");
|
|
return false;
|
|
}
|
|
return base.Master_BeforeDeleteAction(sender, e);
|
|
}
|
|
|
|
protected override bool Master_BeforeSaveAction(object sender, EventArgs e)
|
|
{
|
|
txtWHR.Text = tSession.UserName;
|
|
txtWHRID.Value = tSession.UserId;
|
|
datWHSJ.Value = CMISproConvert.ConvertTime(DateTime.Now);
|
|
|
|
txtBJDYBJTXS.Value = cbxBJDYBJTXS.SelectedValue;
|
|
txtBJQSTXS.Value = cbxBJQSTXS.SelectedValue;
|
|
txtZDXJJCLTXS.Value = cbxZDXJJCLTXS.SelectedValue;
|
|
return base.Master_BeforeSaveAction(sender, e);
|
|
}
|
|
|
|
protected override void SetControlState()
|
|
{
|
|
base.SetControlState();
|
|
|
|
txtWHR.Enabled = false;
|
|
datWHSJ.Enabled = false;
|
|
|
|
chkBJHYF.Enabled = false;
|
|
cbxYFWLID.Enabled = false;
|
|
chkBJHYF.Enabled = false;
|
|
|
|
this.altAttachList.Enabled = true;
|
|
this.altAttachList.ReadOnly = false;
|
|
|
|
if (ControlState == TControlState.ctsInsert || ControlState == TControlState.ctsCopy || ControlState == TControlState.ctsEdit)
|
|
{
|
|
btnTJYZ.Enabled = false;
|
|
//计运费
|
|
if (chkJYF.Checked)
|
|
{
|
|
chkBJHYF.Enabled = true;
|
|
cbxYFWLID.Enabled = true;
|
|
}
|
|
else
|
|
{
|
|
chkBJHYF.Enabled = false;
|
|
cbxYFWLID.Enabled = false;
|
|
}
|
|
|
|
//记录报价行情、仅加载价格表型号
|
|
if (cbxMXBH.SelectedValue.Trim().Equals("JGE"))
|
|
{
|
|
chkJLBJDHQ.Enabled = false;
|
|
chkJJZJGBXH.Checked = false;
|
|
chkJJZJGBXH.Enabled = false;
|
|
chkABJDHQJSBJ.Enabled = false;
|
|
|
|
}
|
|
else
|
|
{
|
|
chkJLBJDHQ.Enabled = true;
|
|
chkJJZJGBXH.Enabled = true;
|
|
|
|
chkABJDHQJSBJ.Enabled = false;
|
|
if (cbxJGBTJYSS.SelectedValue.Trim()=="1"&&chkJLBJDHQ.Checked)
|
|
chkABJDHQJSBJ.Enabled = true;
|
|
}
|
|
if (chkXSYXJ.Checked)
|
|
{
|
|
cbxYXJJCLLX.Enabled = true;
|
|
}
|
|
else
|
|
{
|
|
cbxYXJJCLLX.Enabled = false;
|
|
cbxYXJJCLLX.SelectedValue = "";
|
|
}
|
|
}
|
|
else
|
|
{
|
|
btnTJYZ.Enabled = true;
|
|
}
|
|
|
|
if (ControlState == TControlState.ctsEdit)
|
|
{
|
|
if (CMISproDataBase.ExistsRecord("DBERP", string.Format("select 1 from XLXSBJD where XLXSBJD_BJFLID = '{0}'", txtBJFLID.Text.Trim()))
|
|
|| CMISproDataBase.ExistsRecord("DBERP", string.Format("select 1 from XLXSBJFLKH where XLXSBJFLKH_BJFLID = '{0}'", txtBJFLID.Text.Trim()))
|
|
|| txtBJFLID.Text.Trim().Equals("--------"))//演示分类编码特殊处理
|
|
{
|
|
txtBJFLID.Enabled = false;
|
|
cbxMXBH.Enabled = false;
|
|
}
|
|
|
|
//演示分类编码特殊处理
|
|
if (txtBJFLID.Text.Trim().Equals("--------"))
|
|
{
|
|
txtBJFLMC.Enabled = false;
|
|
}
|
|
}
|
|
else if (ControlState == TControlState.ctsInsert || ControlState == TControlState.ctsCopy)
|
|
{
|
|
txtBJFLID.Enabled = true;
|
|
txtBJFLMC.Enabled = true;
|
|
}
|
|
|
|
if (ControlState == TControlState.ctsInsert || ControlState == TControlState.ctsCopy || ControlState == TControlState.ctsEdit)
|
|
{
|
|
if (cbxMXBH.SelectedValue.Trim().Equals("JGE"))
|
|
{
|
|
//cbxJGBIDS.Enabled = false;
|
|
//cbxCPMLID.Enabled = false;
|
|
cbxBJDHQLY.Enabled = false;
|
|
chkTLJTZGXQTCL.Enabled = true;
|
|
}
|
|
else
|
|
{
|
|
//cbxJGBIDS.Enabled = true;
|
|
//cbxCPMLID.Enabled = true;
|
|
cbxBJDHQLY.Enabled = true;
|
|
chkTLJTZGXQTCL.Enabled = false;
|
|
}
|
|
if (chkJLBJDHQ.Checked)
|
|
{
|
|
cbxTBJCLID.Enabled = true;
|
|
cbxLBJCLID.Enabled = true;
|
|
chkTZCLHQ.Enabled = true;
|
|
chkTZWLHQ.Enabled = true;
|
|
}
|
|
else
|
|
{
|
|
cbxTBJCLID.Enabled = false;
|
|
cbxLBJCLID.Enabled = false;
|
|
chkTZCLHQ.Enabled = false;
|
|
chkTZWLHQ.Enabled = false;
|
|
}
|
|
|
|
if (chkJLRBJCP.Checked)
|
|
{
|
|
cbxLRYZ.Enabled = true;
|
|
cbxKJJGHJ.Enabled = true;
|
|
cbxKJJGLM.Enabled = true;
|
|
}
|
|
else
|
|
{
|
|
cbxLRYZ.Enabled = false;
|
|
cbxKJJGHJ.Enabled = false;
|
|
cbxKJJGLM.Enabled = false;
|
|
}
|
|
|
|
}
|
|
|
|
chkSDJGBCLHQFW.Enabled = false;
|
|
if (ControlState != TControlState.ctsBrowse)
|
|
{
|
|
if (!cbxCPMLID.SelectedValue.Trim().Equals("") && !cbxMXBH.SelectedValue.Trim().Equals("JGE"))
|
|
chkSDJGBCLHQFW.Enabled = true;
|
|
}
|
|
|
|
btnSZ.Enabled = ControlState == TControlState.ctsBrowse;
|
|
btnJSJGSSZ.Enabled = ControlState == TControlState.ctsBrowse;
|
|
//浏览状态下才可以点击按角色隐藏栏目按钮
|
|
btnAJSYCLM.Enabled = ControlState == TControlState.ctsBrowse;
|
|
|
|
if (ControlState == TControlState.ctsBrowse || ControlState == TControlState.ctsNull)
|
|
{
|
|
this.altAttachList.ReadOnly = true;
|
|
}
|
|
|
|
if (cbxTZJGBBJ.SelectedValue.Trim().Equals("1"))
|
|
{
|
|
chkTZBJBJBB.Enabled = false;
|
|
}
|
|
else
|
|
{
|
|
chkTZBJBJBB.Enabled = true;
|
|
}
|
|
|
|
}
|
|
|
|
protected override void AfterSave(TDatabase db, ref bool ActionIsDone)
|
|
{
|
|
base.AfterSave(db, ref ActionIsDone);
|
|
if (ControlState == TControlState.ctsCopy && !txtOLDBJFLID.Value.Trim().Equals(txtBJFLID.Text.Trim()))
|
|
{
|
|
TSQL SQL = new TSQL(db);
|
|
SQL.Clear();
|
|
SQL.Add(@"insert into XLXSBJFLJSLM(XLXSBJFLJSLM_BJFLID,XLXSBJFLJSLM_JSLX,XLXSBJFLJSLM_LMLX,XLXSBJFLJSLM_LMID,XLXSBJFLJSLM_YCBZ,XLXSBJFLJSLM_WHR,XLXSBJFLJSLM_WHRID,XLXSBJFLJSLM_WHSJ)
|
|
select :pBJFLID,XLXSBJFLJSLM_JSLX,XLXSBJFLJSLM_LMLX,XLXSBJFLJSLM_LMID,XLXSBJFLJSLM_YCBZ,:pWHR,:pWHRID,:pWHSJ
|
|
from XLXSBJFLJSLM
|
|
where XLXSBJFLJSLM_BJFLID=:pOLDBJFLID ");
|
|
SQL.ParamByName("pBJFLID").Value = txtBJFLID.Text.Trim();
|
|
SQL.ParamByName("pOLDBJFLID").Value = txtOLDBJFLID.Value.Trim();
|
|
SQL.ParamByName("pWHR").Value = tSession.UserName;
|
|
SQL.ParamByName("pWHRID").Value = tSession.UserId;
|
|
SQL.ParamByName("pWHSJ").Value = DateTime.Now;
|
|
db.ExecSQL(SQL);
|
|
|
|
}
|
|
txtOLDBJFLID.Value = txtBJFLID.Text.Trim();
|
|
//当前cbxTBJCLID与txtOLD_TBJCLID值不相同 或 当前cbxLBJCLID与txtOLD_LBJCLID值不相同
|
|
if (!txtOLD_TBJCLID.Value.Equals(cbxTBJCLID.SelectedValue.Trim()) || !txtOLD_LBJCLID.Value.Equals(cbxLBJCLID.SelectedValue.Trim()))
|
|
{
|
|
bool bTBJCLID = false;
|
|
TSQL SQL = new TSQL(db);
|
|
SQL.Clear();
|
|
SQL.Add(" update XLXSBJD set ");
|
|
if (!txtOLD_TBJCLID.Value.Equals(cbxTBJCLID.SelectedValue.Trim()))
|
|
{
|
|
SQL.Add(" XLXSBJD_TJ = isnull((select XLXSBJDCLHQ_HSJG from XLXSBJDCLHQ where XLXSBJDCLHQ_BJDID=XLXSBJD_BJDID and XLXSBJDCLHQ_BJCLID=:pTBJCLID),0) ");
|
|
SQL.ParamByName("pTBJCLID").Value = cbxTBJCLID.SelectedValue.Trim();
|
|
bTBJCLID = true;
|
|
}
|
|
if (!txtOLD_LBJCLID.Value.Equals(cbxLBJCLID.SelectedValue.Trim()))
|
|
{
|
|
if (bTBJCLID)
|
|
{
|
|
SQL.Add(" , ");
|
|
}
|
|
SQL.Add(" XLXSBJD_LJ = isnull((select XLXSBJDCLHQ_HSJG from XLXSBJDCLHQ where XLXSBJDCLHQ_BJDID=XLXSBJD_BJDID and XLXSBJDCLHQ_BJCLID=:pLBJCLID),0) ");
|
|
SQL.ParamByName("pLBJCLID").Value = cbxLBJCLID.SelectedValue.Trim();
|
|
}
|
|
SQL.Add("where XLXSBJD_JZBJHS='Y' and XLXSBJD_BJFLID=:pBJFLID");
|
|
SQL.ParamByName("pBJFLID").Value = txtBJFLID.Text.Trim();
|
|
db.ExecSQL(SQL);
|
|
|
|
SQL.Clear();
|
|
SQL.Add(" update XLXSBJD set ");
|
|
if (!txtOLD_TBJCLID.Value.Equals(cbxTBJCLID.SelectedValue.Trim()))
|
|
{
|
|
SQL.Add(" XLXSBJD_TJ = isnull((select XLXSBJDCLHQ_WSJG from XLXSBJDCLHQ where XLXSBJDCLHQ_BJDID=XLXSBJD_BJDID and XLXSBJDCLHQ_BJCLID=:pTBJCLID),0) ");
|
|
SQL.ParamByName("pTBJCLID").Value = cbxTBJCLID.SelectedValue.Trim();
|
|
}
|
|
if (!txtOLD_LBJCLID.Value.Equals(cbxLBJCLID.SelectedValue.Trim()))
|
|
{
|
|
if (bTBJCLID)
|
|
{
|
|
SQL.Add(" , ");
|
|
}
|
|
SQL.Add(" XLXSBJD_LJ = isnull((select XLXSBJDCLHQ_WSJG from XLXSBJDCLHQ where XLXSBJDCLHQ_BJDID=XLXSBJD_BJDID and XLXSBJDCLHQ_BJCLID=:pLBJCLID),0) ");
|
|
SQL.ParamByName("pLBJCLID").Value = cbxLBJCLID.SelectedValue.Trim();
|
|
}
|
|
SQL.Add("where XLXSBJD_JZBJHS<>'Y' and XLXSBJD_BJFLID=:pBJFLID");
|
|
SQL.ParamByName("pBJFLID").Value = txtBJFLID.Text.Trim();
|
|
db.ExecSQL(SQL);
|
|
|
|
txtOLD_TBJCLID.Value = cbxTBJCLID.SelectedValue.Trim();
|
|
txtOLD_LBJCLID.Value = cbxLBJCLID.SelectedValue.Trim();
|
|
}
|
|
CacheNotify.TableIsUpdated("DBERP", "XLXSBJFL");
|
|
}
|
|
|
|
protected override void AfterDelete(TDatabase db, ref bool ActionIsDone)
|
|
{
|
|
base.AfterDelete(db, ref ActionIsDone);
|
|
db.ExecSQL(string.Format("delete from XLXSBJFLKH where XLXSBJFLKH_BJFLID='{0}'", txtBJFLID.Text.Trim()));
|
|
db.ExecSQL(string.Format("delete from XLXSBJFLYZ where XLXSBJFLYZ_BJFLID='{0}'", txtBJFLID.Text.Trim()));
|
|
db.ExecSQL(string.Format("delete from XLXSBJFLJSLM where XLXSBJFLJSLM_BJFLID='{0}'", txtBJFLID.Text.Trim()));
|
|
|
|
|
|
}
|
|
|
|
protected override bool Master_AfterSaveAction(object sender, EventArgs e)
|
|
{
|
|
CacheNotify.TableIsUpdated("DBERP", "XLXSBJFL");
|
|
return base.Master_AfterSaveAction(sender, e);
|
|
}
|
|
|
|
protected override bool Master_AfterDeleteAction(object sender, EventArgs e)
|
|
{
|
|
CacheNotify.TableIsUpdated("DBERP", "XLXSBJFL");
|
|
return base.Master_AfterDeleteAction(sender, e);
|
|
}
|
|
|
|
protected override void SetComboxItems()
|
|
{
|
|
TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
|
|
TSQL sql = new TSQL(dberp);
|
|
|
|
cbxBJDHQLY.ClearItems();
|
|
cbxBJDHQLY.Items.Add(new ListItem("价格表行情", "1"));
|
|
cbxBJDHQLY.Items.Add(new ListItem("报价日行情", "2"));
|
|
|
|
cbxBJCPFZJS.ClearItems();
|
|
cbxBJCPFZJS.Items.Add(new ListItem("先材料清单再价格表检索", "1"));
|
|
cbxBJCPFZJS.Items.Add(new ListItem("先价格表再材料清单检索", "2"));
|
|
|
|
cbxBJYZJY.ClearItems();
|
|
cbxBJYZJY.Items.Add(new ListItem("不校验", "N"));
|
|
cbxBJYZJY.Items.Add(new ListItem("相同型号+规格+标准+电压报价一致", "Y"));
|
|
cbxBJYZJY.Items.Add(new ListItem("相同型号+规格+标准+电压+颜色报价一致", "5"));
|
|
cbxBJYZJY.ShowValue = false;
|
|
|
|
if (cbxMXBH.SelectedValue.Trim().Equals("JGE"))
|
|
{
|
|
cbxJGBTJYSS.ClearItems();
|
|
cbxJGBTJYSS.Items.Add(new ListItem("表价(出厂价)=基价(材料价)&调价", "1"));
|
|
}
|
|
else
|
|
{
|
|
cbxJGBTJYSS.ClearItems();
|
|
cbxJGBTJYSS.Items.Add(new ListItem("表价(出厂价)=基价(材料价)&调价", "1"));
|
|
cbxJGBTJYSS.Items.Add(new ListItem("表价(区域价)=基价(出厂价)&调价", "2"));
|
|
cbxJGBTJYSS.Items.Add(new ListItem("表价(现行价)=基价(出厂价+材料价价差)&调价", "3"));
|
|
}
|
|
|
|
if (ControlState == TControlState.ctsBrowse)
|
|
{
|
|
sql.Clear();
|
|
sql.Add("select XSQY_XSQYID,XSQY_XSQYMC from XSQY where 1=1 and " + CMISproDataBase.GetWhereEqual("XSQY_XSQYID", cbxXSQYIDS.SelectedValue.Trim()) + " order by XSQY_XSQYID");
|
|
DataSet ds = dberp.OpenDataSet(sql);
|
|
cbxXSQYIDS.ClearItems();
|
|
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
|
|
{
|
|
cbxXSQYIDS.Items.Add(new ListItem(ds.Tables[0].Rows[i]["XSQY_XSQYMC"].ToString().Trim(), ds.Tables[0].Rows[i]["XSQY_XSQYID"].ToString().Trim()));
|
|
}
|
|
|
|
sql.Clear();
|
|
sql.Add("select XLXSJGB_JGBID,XLXSJGB_YXQS,XLXSJGB_YXQZ,XLXSJGB_JGBMC,XLXSJGB_JGBIDS,XLXSJGB_MXBH from XLXSJGB where XLXSJGB_MXBH in ('JGB','JGE') ");
|
|
sql.Add(" and " + CMISproDataBase.GetWhereEqual("XLXSJGB_JGBID", cbxJGBIDS.SelectedValue.Trim()));
|
|
sql.Add(" order by XLXSJGB_JGBID desc,isnull(XLXSJGB_CPMLID,' '),XLXSJGB_YXQS,ISNULL(XLXSJGB_YXQZ,'9999-12-31') ");
|
|
ds = dberp.OpenDataSet(sql);
|
|
cbxJGBIDS.ClearItems();
|
|
cbxJGBIDS.Items.Add(new ListItem("CUR|当前有效价格表", "CUR"));
|
|
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
|
|
{
|
|
string sJGBID = ds.Tables[0].Rows[i]["XLXSJGB_JGBID"].ToString().Trim();
|
|
string sYXQS = ds.Tables[0].Rows[i]["XLXSJGB_YXQS"].ToString().Trim();
|
|
string sYXQZ = ds.Tables[0].Rows[i]["XLXSJGB_YXQZ"].ToString().Trim();
|
|
string sJGBMC = ds.Tables[0].Rows[i]["XLXSJGB_JGBMC"].ToString().Trim();
|
|
string sMXBH = ds.Tables[0].Rows[i]["XLXSJGB_MXBH"].ToString().Trim();
|
|
if (sYXQS.Equals(""))
|
|
sYXQS = "--";
|
|
else
|
|
sYXQS = CMISproConvert.ConvertDate(sYXQS);
|
|
if (sYXQZ.Equals(""))
|
|
sYXQZ = "--";
|
|
else
|
|
sYXQZ = CMISproConvert.ConvertDate(sYXQZ);
|
|
if (sMXBH.Equals("JGB"))
|
|
{
|
|
if (sJGBMC.Equals(""))
|
|
cbxJGBIDS.Items.Add(new ListItem(sJGBID + "|" + sYXQS + "至" + sYXQZ, sJGBID));
|
|
else
|
|
cbxJGBIDS.Items.Add(new ListItem(sJGBID + "|" + sYXQS + "至" + sYXQZ + "|" + sJGBMC, sJGBID));
|
|
}
|
|
else
|
|
cbxJGBIDS.Items.Add(new ListItem(sJGBID + "|" + sJGBMC, sJGBID));
|
|
}
|
|
|
|
|
|
sql.Clear();
|
|
ds = null;
|
|
sql.Add(" select XLXSCPML_CPMLID as ID,XLXSCPML_CPMLMC as CODE from XLXSCPML ");
|
|
sql.Add(" where XLXSCPML_CPMLID = :XLXSCPML_CPMLID ");
|
|
sql.Add(" order by XLXSCPML_CPMLID");
|
|
sql.ParamByName("XLXSCPML_CPMLID").Value = cbxCPMLID.SelectedValue.Trim();
|
|
ds = dberp.OpenDataSet(sql);
|
|
cbxCPMLID.ClearItems();
|
|
cbxCPMLID.Items.Add(new ListItem("", ""));
|
|
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
|
|
{
|
|
cbxCPMLID.Items.Add(new ListItem(ds.Tables[0].Rows[i]["CODE"].ToString().Trim(), ds.Tables[0].Rows[i]["ID"].ToString().Trim()));
|
|
}
|
|
|
|
TComboBox.SetComboBox("DBERP", cbxTBJCLID, string.Format("select XLXSBJCL_BJCLID,XLXSBJCL_BJCLMC from XLXSBJCL where XLXSBJCL_BJCLID='{0}'", cbxTBJCLID.SelectedValue.Trim()), true);
|
|
TComboBox.SetComboBox("DBERP", cbxLBJCLID, string.Format("select XLXSBJCL_BJCLID,XLXSBJCL_BJCLMC from XLXSBJCL where XLXSBJCL_BJCLID='{0}'", cbxLBJCLID.SelectedValue.Trim()), true);
|
|
TComboBox.SetComboBox("DBERP", cbxYFWLID, string.Format("select DISTINCT YFWL_WLID,WL_MC from YFWL left join WL on WL_WLID = YFWL_WLID where YFWL_WLID='{0}'", cbxYFWLID.SelectedValue.Trim()), true);
|
|
|
|
sql.Clear();
|
|
ds = null;
|
|
sql.Add("select XLXSBJCL_BJCLID,XLXSBJCL_BJCLMC from XLXSBJCL where 1=1 and " + CMISproDataBase.GetWhereEqual("XLXSBJCL_BJCLID", cbxZLGZCLS.SelectedValue.Trim()) + " order by XLXSBJCL_BJCLID");
|
|
ds = dberp.OpenDataSet(sql);
|
|
cbxZLGZCLS.ClearItems();
|
|
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
|
|
{
|
|
cbxZLGZCLS.Items.Add(new ListItem(ds.Tables[0].Rows[i]["XLXSBJCL_BJCLMC"].ToString().Trim(), ds.Tables[0].Rows[i]["XLXSBJCL_BJCLID"].ToString().Trim()));
|
|
}
|
|
|
|
Dictionary<string, string> dic = XLBJDUtils.GetALLYZIDDic();
|
|
|
|
string sJMBGSYZID = cbxJMBGSYZID.SelectedValue.Trim();
|
|
string sLRYZID = cbxLRYZ.SelectedValue.Trim();
|
|
cbxJMBGSYZID.ClearItems();
|
|
cbxLRYZ.ClearItems();
|
|
if (dic.ContainsKey(sJMBGSYZID))
|
|
{
|
|
cbxJMBGSYZID.Items.Add(new ListItem(dic[sJMBGSYZID], sJMBGSYZID));
|
|
}
|
|
if (dic.ContainsKey(sLRYZID))
|
|
{
|
|
cbxLRYZ.Items.Add(new ListItem(dic[sLRYZID], sLRYZID));
|
|
}
|
|
|
|
TComboBox.SetComboBox("DBERP", cbxZDXJQZBJDFL, string.Format("select XLXSBJFL_BJFLID as ID, XLXSBJFL_BJFLMC as NAME from XLXSBJFL where XLXSBJFL_BJFLID='{0}'", cbxZDXJQZBJDFL.SelectedValue.Trim()), true);
|
|
|
|
|
|
}
|
|
else
|
|
{
|
|
sql.Clear();
|
|
sql.Add("select XSQY_XSQYID,XSQY_XSQYMC from XSQY where 1=1 and isnull(XSQY_TYBZ,' ')<>'Y' order by XSQY_XSQYID");
|
|
DataSet ds = dberp.OpenDataSet(sql);
|
|
cbxXSQYIDS.ClearItems();
|
|
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
|
|
{
|
|
cbxXSQYIDS.Items.Add(new ListItem(ds.Tables[0].Rows[i]["XSQY_XSQYMC"].ToString().Trim(), ds.Tables[0].Rows[i]["XSQY_XSQYID"].ToString().Trim()));
|
|
}
|
|
|
|
InitcbxJGBIDS();
|
|
InitcbxCPMLID();
|
|
|
|
TComboBox.SetComboBox("DBERP", cbxTBJCLID, "select XLXSBJCL_BJCLID,XLXSBJCL_BJCLMC from XLXSBJCL where XLXSBJCL_BJHQ='1' and isnull(XLXSBJCL_TYBZ,'N') <> 'Y' order by XLXSBJCL_BJCLID", true);
|
|
TComboBox.SetComboBox("DBERP", cbxLBJCLID, "select XLXSBJCL_BJCLID,XLXSBJCL_BJCLMC from XLXSBJCL where XLXSBJCL_BJHQ='1' and isnull(XLXSBJCL_TYBZ,'N') <> 'Y' order by XLXSBJCL_BJCLID", true);
|
|
TComboBox.SetComboBox("DBERP", cbxYFWLID, "select DISTINCT YFWL_WLID AS ID,WL_MC AS NAME from YFWL left join WL on WL_WLID = YFWL_WLID order by ID", false);
|
|
|
|
sql.Clear();
|
|
ds = null;
|
|
sql.Add("select XLXSBJCL_BJCLID,XLXSBJCL_BJCLMC from XLXSBJCL where XLXSBJCL_BJJZ='Y' and isnull(XLXSBJCL_TYBZ,'N') <> 'Y' order by XLXSBJCL_BJCLID");
|
|
ds = dberp.OpenDataSet(sql);
|
|
cbxZLGZCLS.ClearItems();
|
|
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
|
|
{
|
|
cbxZLGZCLS.Items.Add(new ListItem(ds.Tables[0].Rows[i]["XLXSBJCL_BJCLMC"].ToString().Trim(), ds.Tables[0].Rows[i]["XLXSBJCL_BJCLID"].ToString().Trim()));
|
|
}
|
|
|
|
cbxJMBGSYZID.ClearItems();
|
|
cbxJMBGSYZID.Items.Add(new ListItem("",""));
|
|
cbxLRYZ.ClearItems();
|
|
cbxLRYZ.Items.Add(new ListItem("", ""));
|
|
List<TZYZXX> yzxx_List = XLBJDUtils.GetBJFLYZOrderByXSXH(txtBJFLID.Text.Trim());
|
|
foreach(TZYZXX yzxx in yzxx_List)
|
|
{
|
|
if (yzxx.XLXSTZYZ_TJMDID == "0" && string.IsNullOrEmpty(yzxx.XLXSTZYZ_TJYS.Trim()))
|
|
{
|
|
if (yzxx.XLXSTZYZ_JJFS == "JD" || yzxx.XLXSTZYZ_JJFS == "MD" || yzxx.XLXSTZYZ_JJFS == "MX")
|
|
cbxJMBGSYZID.Items.Add(new ListItem(yzxx.XLXSTZYZ_YZMC, yzxx.XLXSTZYZ_YZID));
|
|
cbxLRYZ.Items.Add(new ListItem(yzxx.XLXSTZYZ_YZMC, yzxx.XLXSTZYZ_YZID));
|
|
}
|
|
}
|
|
TComboBox.SetComboBox("DBERP", cbxZDXJQZBJDFL,"select XLXSBJFL_BJFLID as ID, XLXSBJFL_BJFLMC as NAME from XLXSBJFL where 1=1 and XLXSBJFL_TYBZ <>'Y' ", true);
|
|
|
|
|
|
}
|
|
|
|
|
|
base.SetComboxItems();
|
|
}
|
|
|
|
#endregion
|
|
|
|
private void InitcbxJGBIDS()
|
|
{
|
|
if (cbxMXBH.SelectedValue.Trim().Equals("JGB"))
|
|
{
|
|
cbxJGBIDS.ClearItems();
|
|
cbxJGBIDS.Items.Add(new ListItem("CUR|当前有效价格表", "CUR"));
|
|
if (!cbxJGBTJYSS.SelectedValue.Trim().Equals(""))
|
|
{
|
|
TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
|
|
TSQL SQL = new TSQL(dberp);
|
|
SQL.Clear();
|
|
SQL.Add("select XLXSJGB_JGBID,XLXSJGB_YXQS,XLXSJGB_YXQZ,XLXSJGB_JGBMC,XLXSJGB_JGBIDS from XLXSJGB where XLXSJGB_MXBH='JGB' ");
|
|
SQL.Add(" and " + CMISproDataBase.GetWhereEqual("XLXSJGB_TJYS", cbxJGBTJYSS.SelectedValue.Trim()));
|
|
SQL.Add(" order by XLXSJGB_JGBID desc,isnull(XLXSJGB_CPMLID,' '),XLXSJGB_YXQS,ISNULL(XLXSJGB_YXQZ,'9999-12-31') ");
|
|
DataSet ds = dberp.OpenDataSet(SQL);
|
|
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
|
|
{
|
|
string sJGBID = ds.Tables[0].Rows[i]["XLXSJGB_JGBID"].ToString().Trim();
|
|
string sYXQS = ds.Tables[0].Rows[i]["XLXSJGB_YXQS"].ToString().Trim();
|
|
string sYXQZ = ds.Tables[0].Rows[i]["XLXSJGB_YXQZ"].ToString().Trim();
|
|
string sJGBMC = ds.Tables[0].Rows[i]["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(""))
|
|
cbxJGBIDS.Items.Add(new ListItem(sJGBID + "|" + sYXQS + "至" + sYXQZ, sJGBID));
|
|
else
|
|
cbxJGBIDS.Items.Add(new ListItem(sJGBID + "|" + sYXQS + "至" + sYXQZ + "|" + sJGBMC, sJGBID));
|
|
}
|
|
}
|
|
}
|
|
else if (cbxMXBH.SelectedValue.Trim().Equals("JGE"))
|
|
{
|
|
TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
|
|
TSQL sql = new TSQL(dberp);
|
|
sql.Clear();
|
|
sql.Add("select XLXSJGB_JGBID,XLXSJGB_JGBMC from XLXSJGB ");
|
|
sql.Add(" where XLXSJGB_MXBH='JGE' ");
|
|
sql.Add(" order by XLXSJGB_JGBID desc,isnull(XLXSJGB_CPMLID,' '),XLXSJGB_YXQS,ISNULL(XLXSJGB_YXQZ,'9999-12-31') ");
|
|
DataSet ds = dberp.OpenDataSet(sql);
|
|
cbxJGBIDS.ClearItems();
|
|
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
|
|
{
|
|
string sJGBID = ds.Tables[0].Rows[i]["XLXSJGB_JGBID"].ToString().Trim();
|
|
string sJGBMC = ds.Tables[0].Rows[i]["XLXSJGB_JGBMC"].ToString().Trim();
|
|
cbxJGBIDS.Items.Add(new ListItem(sJGBID + "|" + sJGBMC, sJGBID));
|
|
}
|
|
}
|
|
}
|
|
|
|
private void InitcbxCPMLID()
|
|
{
|
|
cbxCPMLID.ClearItems();
|
|
|
|
if (cbxMXBH.SelectedValue.Trim().Equals("JGE"))
|
|
{
|
|
string sSQL="select XLXSCPML_CPMLID as ID,XLXSCPML_CPMLMC as MC from XLXSCPML where XLXSCPML_CPMLLX='Y' and XLXSCPML_TYBZ<>'Y' order by XLXSCPML_XSXH,XLXSCPML_CPMLID";
|
|
TComboBox.SetComboBox("DBERP", cbxCPMLID, sSQL, true);
|
|
|
|
}
|
|
else if (!cbxJGBTJYSS.SelectedValue.Trim().Equals(""))
|
|
{
|
|
TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
|
|
TSQL SQL = new TSQL(dberp);
|
|
SQL.Clear();
|
|
SQL.Add(" select XLXSJGBPZ_CPMLID as ID,XLXSCPML_CPMLMC as CODE from XLXSJGBPZ left join XLXSCPML on XLXSCPML_CPMLID=XLXSJGBPZ_CPMLID where XLXSJGBPZ_MXBH='JGB' ");
|
|
SQL.Add(" and " + CMISproDataBase.GetWhereEqual("XLXSJGBPZ_TJYS", cbxJGBTJYSS.SelectedValue.Trim()));
|
|
SQL.Add(" order by XLXSJGBPZ_CPMLID");
|
|
DataSet ds = dberp.OpenDataSet(SQL);
|
|
cbxCPMLID.Items.Add(new ListItem("", ""));
|
|
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
|
|
{
|
|
cbxCPMLID.Items.Add(new ListItem(ds.Tables[0].Rows[i]["CODE"].ToString().Trim(), ds.Tables[0].Rows[i]["ID"].ToString().Trim()));
|
|
}
|
|
}
|
|
}
|
|
|
|
private void SyncAttachControl()
|
|
{
|
|
this.altAttachList.DocGroupId = CMISproConvert.StrToFloat(txtDOCGRPID.Value);
|
|
this.altAttachList.DocGroupField = "XLXSBJFL_JGMBGRPID";
|
|
this.altAttachList.UpdCondition = string.Format("XLXSBJFL_BJFLID='{0}'", txtOLDBJFLID.Value.Trim());
|
|
this.altAttachList.WorkTableName = "XLXSBJFL";
|
|
this.altAttachList.AddAttachFromDocsVisible = false;
|
|
this.altAttachList.OneAttach = true;
|
|
}
|
|
|
|
private void SetColorComboBox(gtColorComboBox p_ComboBox)
|
|
{
|
|
p_ComboBox.ClearItems();
|
|
p_ComboBox.Items.Add(new ListItem("", ""));
|
|
p_ComboBox.Items.Add(new ListItem("白色", "#FFFFFF"));
|
|
p_ComboBox.Items.Add(new ListItem("红色", "#FF0000"));
|
|
p_ComboBox.Items.Add(new ListItem("浅红色", "#FF6262"));
|
|
p_ComboBox.Items.Add(new ListItem("紫红色", "#FF00FF"));
|
|
p_ComboBox.Items.Add(new ListItem("黄色", "#FFFF00"));
|
|
p_ComboBox.Items.Add(new ListItem("浅黄色", "#F5DEB3"));
|
|
p_ComboBox.Items.Add(new ListItem("绿色", "#008000"));
|
|
p_ComboBox.Items.Add(new ListItem("浅绿色", "#00FFFF"));
|
|
p_ComboBox.Items.Add(new ListItem("蓝色", "#0000FF"));
|
|
p_ComboBox.Items.Add(new ListItem("浅蓝色", "#8784F0"));
|
|
p_ComboBox.Items.Add(new ListItem("天蓝色", "#F0FFFF"));
|
|
p_ComboBox.Items.Add(new ListItem("橄榄色", "#808000"));
|
|
p_ComboBox.Items.Add(new ListItem("紫色", "#800080"));
|
|
p_ComboBox.Items.Add(new ListItem("灰色", "#D4D0C8"));
|
|
}
|
|
|
|
#region 控件事件
|
|
|
|
//按角色隐藏栏目
|
|
protected void btnAJSYCLM_Click(object sender, EventArgs e)
|
|
{
|
|
string sBJFLID = txtBJFLID.Text.ToString().Trim();
|
|
TPageParams tpp = new TPageParams();
|
|
tpp.UrlPath = "BJFLJSLM.aspx";
|
|
//tpp.CallAction = TPageCallAction;
|
|
tpp.AddString("BJFLID", sBJFLID);
|
|
tpp.AddString("BJFLMC", txtBJFLMC.Text.Trim());
|
|
OpenFuncModuleDialog(100860023, tpp);
|
|
}
|
|
|
|
protected void cbxMXBH_SelectedIndexChanged(object sender, EventArgs e)
|
|
{
|
|
if (ControlState == TControlState.ctsInsert || ControlState == TControlState.ctsCopy || ControlState == TControlState.ctsEdit)
|
|
{
|
|
InitcbxJGBIDS();
|
|
InitcbxCPMLID();
|
|
if (cbxMXBH.SelectedValue.Trim().Equals("JGE"))
|
|
{
|
|
cbxJGBTJYSS.ClearItems();
|
|
cbxJGBTJYSS.Items.Add(new ListItem("表价(出厂价)=基价(材料价)&调价", "1"));
|
|
|
|
|
|
cbxJGBIDS.SelectedValue = "";
|
|
//cbxJGBIDS.Enabled = false;
|
|
//cbxCPMLID.SelectedValue = "";
|
|
//cbxCPMLID.Enabled = false;
|
|
cbxCPMLID_SelectedIndexChanged(null, null);
|
|
cbxBJDHQLY.SelectedValue = "2";
|
|
cbxBJDHQLY.Enabled = false;
|
|
|
|
cbxTBJCLID.Enabled = true;
|
|
cbxLBJCLID.Enabled = true;
|
|
|
|
chkJLBJDHQ.Checked = true;
|
|
chkJLBJDHQ.Enabled = false;
|
|
chkJLBJDHQ_CheckedChanged(null, null);
|
|
|
|
chkJJZJGBXH.Checked = false;
|
|
chkJJZJGBXH.Enabled = false;
|
|
|
|
chkTLJTZGXQTCL.Enabled = true;
|
|
|
|
chkABJDHQJSBJ.Checked = true;
|
|
chkABJDHQJSBJ.Enabled = false;
|
|
}
|
|
else
|
|
{
|
|
cbxJGBTJYSS.ClearItems();
|
|
cbxJGBTJYSS.Items.Add(new ListItem("表价(出厂价)=基价(材料价)&调价", "1"));
|
|
cbxJGBTJYSS.Items.Add(new ListItem("表价(区域价)=基价(出厂价)&调价", "2"));
|
|
cbxJGBTJYSS.Items.Add(new ListItem("表价(现行价)=基价(出厂价+材料价价差)&调价", "3"));
|
|
|
|
//cbxJGBIDS.Enabled = true;
|
|
//cbxCPMLID.Enabled = true;
|
|
cbxCPMLID_SelectedIndexChanged(null, null);
|
|
cbxBJDHQLY.Enabled = true;
|
|
|
|
cbxTBJCLID.SelectedValue = "";
|
|
cbxTBJCLID.Enabled = false;
|
|
cbxLBJCLID.SelectedValue = "";
|
|
cbxLBJCLID.Enabled = false;
|
|
|
|
chkJLBJDHQ.Checked = false;
|
|
chkJLBJDHQ.Enabled = true;
|
|
chkJLBJDHQ_CheckedChanged(null, null);
|
|
|
|
chkJJZJGBXH.Enabled = true;
|
|
|
|
chkTLJTZGXQTCL.Checked = false;
|
|
chkTLJTZGXQTCL.Enabled = false;
|
|
|
|
chkABJDHQJSBJ.Checked = false;
|
|
chkABJDHQJSBJ.Enabled = false;
|
|
if (cbxJGBTJYSS.SelectedValue.Trim() == "1" && chkJLBJDHQ.Checked)
|
|
chkABJDHQJSBJ.Enabled = true;
|
|
}
|
|
}
|
|
}
|
|
|
|
protected void cbxJGBTJYSS_SelectedIndexChanged(object sender, EventArgs e)
|
|
{
|
|
if (IsPostBack)
|
|
{
|
|
InitcbxJGBIDS();
|
|
InitcbxCPMLID();
|
|
if (cbxMXBH.SelectedValue.Trim().Equals("JGE"))
|
|
{
|
|
chkABJDHQJSBJ.Checked = true;
|
|
chkABJDHQJSBJ.Enabled = false;
|
|
}
|
|
else
|
|
{
|
|
chkABJDHQJSBJ.Checked = false;
|
|
chkABJDHQJSBJ.Enabled = false;
|
|
if (cbxJGBTJYSS.SelectedValue.Trim() == "1" && chkJLBJDHQ.Checked)
|
|
chkABJDHQJSBJ.Enabled = true;
|
|
}
|
|
}
|
|
}
|
|
|
|
protected void cbxCPMLID_SelectedIndexChanged(object sender, EventArgs e)
|
|
{
|
|
chkSDJGBCLHQFW.Enabled = false;
|
|
if (ControlState != TControlState.ctsBrowse)
|
|
{
|
|
if (!cbxCPMLID.SelectedValue.Trim().Equals("") && !cbxMXBH.SelectedValue.Trim().Equals("JGE"))
|
|
{
|
|
chkSDJGBCLHQFW.Enabled = true;
|
|
chkSDJGBCLHQFW.Checked = true;
|
|
}
|
|
else
|
|
{
|
|
chkSDJGBCLHQFW.Checked = false;
|
|
}
|
|
}
|
|
}
|
|
|
|
//计运费
|
|
protected void chkJYF_OnCheckedChanged(object sender, EventArgs e)
|
|
{
|
|
|
|
if (chkJYF.Checked)
|
|
{
|
|
chkBJHYF.Enabled = true;
|
|
cbxYFWLID.Enabled = true;
|
|
TComboBox.SetComboBox("DBERP", cbxYFWLID, "select DISTINCT YFWL_WLID AS ID,WL_MC AS NAME from YFWL left join WL on WL_WLID = YFWL_WLID order by ID", false);
|
|
}
|
|
else
|
|
{
|
|
chkBJHYF.Enabled = false;
|
|
cbxYFWLID.Enabled = false;
|
|
chkBJHYF.Checked = false;
|
|
cbxYFWLID.SelectedValue = "";
|
|
}
|
|
}
|
|
|
|
protected void btnSZ_Click(object sender, EventArgs e)
|
|
{
|
|
TPageParams pageParams = new TPageParams();
|
|
pageParams.UrlPath = "BJFL_ZDXJGSInfo.aspx";
|
|
pageParams.AddString("BJFLID", txtBJFLID.Text.Trim());
|
|
pageParams.AddString("MXBH",cbxMXBH.SelectedValue.Trim());
|
|
pageParams.AddString("ZDXJGS", txtValue.Value.Trim());
|
|
pageParams.AddString("btnRefreshCID", btnRefresh.ClientID);
|
|
OpenDialog(pageParams);
|
|
}
|
|
|
|
protected void btnJSJGSSZ_Click(object sender, EventArgs e)
|
|
{
|
|
TPageParams pageParams = new TPageParams();
|
|
pageParams.UrlPath = "BJFL_ZDXJGSInfo.aspx";
|
|
pageParams.AddString("BJFLID", txtBJFLID.Text.Trim());
|
|
pageParams.AddString("JSJGS", txtJSJGSValue.Value.Trim());
|
|
pageParams.AddString("MXBH", cbxMXBH.SelectedValue.Trim());
|
|
pageParams.AddString("btnRefreshCID", btnRefresh.ClientID);
|
|
OpenDialog(pageParams);
|
|
}
|
|
|
|
protected void btnRefresh_Click(object sender, EventArgs e)
|
|
{
|
|
LoadRecord();
|
|
RefreshForm();
|
|
SetControlState();
|
|
FormAreaUpdate();
|
|
MenuAreaUpdate();
|
|
}
|
|
//停用
|
|
protected void chkTYBZ_CheckedChanged(object sender, EventArgs e)
|
|
{
|
|
if (chkTYBZ.Checked)
|
|
{
|
|
if (datTYSJ.Text.Trim().Equals(""))
|
|
{
|
|
datTYSJ.Text = CMISproConvert.ConvertDate(DateTime.Now.ToString());
|
|
}
|
|
}
|
|
else if (chkTYBZ.Checked == false)
|
|
{
|
|
datQYSJ.Text = CMISproConvert.ConvertDate(DateTime.Now.ToString());
|
|
datTYSJ.Text = "";
|
|
}
|
|
}
|
|
|
|
protected void datTYSJ_TextChanged(object sender, EventArgs e)
|
|
{
|
|
if (!datTYSJ.Text.Trim().Equals(""))
|
|
{
|
|
if (chkTYBZ.Checked == false)
|
|
{
|
|
chkTYBZ.Checked = true;
|
|
}
|
|
}
|
|
}
|
|
|
|
protected void chkJLBJDHQ_CheckedChanged(object sender, EventArgs e)
|
|
{
|
|
if (chkJLBJDHQ.Checked)
|
|
{
|
|
cbxTBJCLID.Enabled = true;
|
|
cbxLBJCLID.Enabled = true;
|
|
chkTZCLHQ.Enabled = true;
|
|
chkTZWLHQ.Enabled = true;
|
|
chkABJDHQJSBJ.Enabled = false;
|
|
if (cbxJGBTJYSS.SelectedValue.Trim() == "1"&&cbxMXBH.SelectedValue.Trim().Equals("JGB"))
|
|
chkABJDHQJSBJ.Enabled = true;
|
|
if(cbxMXBH.SelectedValue.Trim().Equals("JGE"))
|
|
chkABJDHQJSBJ.Checked = true;
|
|
}
|
|
else
|
|
{
|
|
cbxTBJCLID.Enabled = false;
|
|
cbxLBJCLID.Enabled = false;
|
|
chkTZCLHQ.Enabled = false;
|
|
chkTZWLHQ.Enabled = false;
|
|
cbxTBJCLID.SelectedValue = "";
|
|
cbxLBJCLID.SelectedValue = "";
|
|
chkTZCLHQ.Value = "";
|
|
chkTZWLHQ.Value = "";
|
|
chkABJDHQJSBJ.Enabled = false;
|
|
chkABJDHQJSBJ.Checked = false;
|
|
|
|
}
|
|
}
|
|
|
|
protected void chkXSTZZDXJ_OnCheckedChanged(object sender, EventArgs e)
|
|
{
|
|
if (!chkXSTZZDXJ.Checked)
|
|
{
|
|
if (CMISproDataBase.ExistsRecord("DBERP", string.Format("select 1 from XLXSBJFL where XLXSBJFL_TZQCPBJGS like '%TZZDXJ%' and XLXSBJFL_BJFLID='{0}'", txtBJFLID.Text.Trim())))
|
|
{
|
|
ShowMessage("请先取消勾选调整最低限价因子！");
|
|
chkXSTZZDXJ.Checked = true;
|
|
}
|
|
}
|
|
}
|
|
|
|
protected void chkXSYXJ_OnCheckedChanged(object sender, EventArgs e)
|
|
{
|
|
if (chkXSYXJ.Checked)
|
|
{
|
|
cbxYXJJCLLX.Enabled = true;
|
|
}
|
|
else
|
|
{
|
|
cbxYXJJCLLX.Enabled = false;
|
|
cbxYXJJCLLX.SelectedValue = "";
|
|
}
|
|
|
|
}
|
|
|
|
protected void chkJLRBJCP_OnCheckedChanged(object sender, EventArgs e)
|
|
{
|
|
if (chkJLRBJCP.Checked)
|
|
{
|
|
cbxLRYZ.Enabled = true;
|
|
cbxKJJGHJ.Enabled = true;
|
|
cbxKJJGLM.Enabled = true;
|
|
cbxKJJGLM.SelectedValue = "CPBJ,BJJE";
|
|
}
|
|
else
|
|
{
|
|
cbxLRYZ.Enabled = false;
|
|
cbxKJJGHJ.Enabled = false;
|
|
cbxKJJGLM.Enabled = false;
|
|
cbxLRYZ.SelectedValue = "";
|
|
cbxKJJGHJ.SelectedValue = "";
|
|
cbxKJJGLM.SelectedValue = "";
|
|
}
|
|
|
|
}
|
|
|
|
protected void btnTJYZ_Click(object sender, EventArgs e)
|
|
{
|
|
string sBJFLID = txtBJFLID.Text.ToString().Trim();
|
|
|
|
TPageParams param = new TPageParams();
|
|
param.UrlPath = "BJFL_TJYZList.aspx";
|
|
param.AddString("BJFLID", sBJFLID);
|
|
OpenDialog(param);
|
|
}
|
|
|
|
protected void OncbxTZJGBBJSelected(object sender, EventArgs e)
|
|
{
|
|
if (ControlState == TControlState.ctsInsert || ControlState == TControlState.ctsCopy || ControlState == TControlState.ctsEdit)
|
|
{
|
|
if (cbxTZJGBBJ.SelectedValue.Trim().Equals("1"))
|
|
{
|
|
chkTZBJBJBB.Checked = false;
|
|
chkTZBJBJBB.Enabled = false;
|
|
}
|
|
else
|
|
{
|
|
chkTZBJBJBB.Enabled = true;
|
|
}
|
|
}
|
|
}
|
|
#endregion
|
|
}
|
|
}
|