271 lines
9.3 KiB
C#
271 lines
9.3 KiB
C#
using System;
|
|
using System.Data;
|
|
using System.Configuration;
|
|
using System.Collections;
|
|
using System.Web;
|
|
using System.Web.Security;
|
|
using System.Web.UI;
|
|
using System.Web.UI.WebControls;
|
|
using System.Web.UI.WebControls.WebParts;
|
|
using System.Web.UI.HtmlControls;
|
|
using GThinking.N_MODEL.Page;
|
|
using GThinking.N_MISPRO.Utility;
|
|
using GThinking.N_MISPRO.Data;
|
|
using GThinking.N_MODEL.Dialog;
|
|
|
|
namespace GThinking.U20261363_N_XLXSBJ
|
|
{
|
|
public class ZDFX_M : TBaseNamedQuery
|
|
{
|
|
public ZDFX_M()
|
|
{
|
|
AddFieldDefs("ZDLX", "撞单类型", false);
|
|
AddFieldDefs("ZDYY", "撞单种类(不显示)");
|
|
AddFieldDefs("BZBJDH", "报价单号(被撞)", false);
|
|
AddFieldDefs("SFYXXG", "报价单号(被撞)是否允许修改");
|
|
AddFieldDefs("ZCBJDH", "报价单号(撞出)");
|
|
AddFieldDefs("STATE", "流程状态");
|
|
AddFieldDefs("ND", "年度");
|
|
AddFieldDefs("BJRQS", "报价日期始");
|
|
AddFieldDefs("BJRQZ", "报价日期止");
|
|
AddFieldDefs("KH", "客户");
|
|
AddFieldDefs("KHLXR", "客户联系人");
|
|
AddFieldDefs("KHDH", "客户电话");
|
|
AddFieldDefs("XM", "项目");
|
|
AddFieldDefs("TXY", "销售员");
|
|
AddFieldDefs("BAXMKH", "备案项目客户");
|
|
AddFieldDefs("BACKRQ", "备案参考日期");
|
|
AddFieldDefs("BAXMTXY", "备案项目销售员");
|
|
AddFieldDefs("BJFL", "报价分类");
|
|
AddFieldDefs("BJY", "不校验");
|
|
AddFieldDefs("PCXTBJD", "排除相同报价单");
|
|
AddFieldDefs("BJRQDX", "报价日期倒序");
|
|
AddFieldDefs("PXYXJ", "排序优先级");
|
|
AddFieldDefs("YFK", "已反馈");
|
|
}
|
|
}
|
|
|
|
public partial class ZDFXQuery : SingleQueryBase
|
|
{
|
|
ZDFX_M queryentity = new ZDFX_M();
|
|
|
|
#region page事件
|
|
private string sZDYY = "";
|
|
private string sBZBJDH = "";
|
|
protected void Page_Load(object sender, EventArgs e)
|
|
{
|
|
this.UMID = 100860174;
|
|
this.UMName = "查询";
|
|
this.CurMaster = Master;
|
|
this.CurQueryEntity = queryentity;
|
|
this.CurQueryTable = QueryTalbe;
|
|
if (!IsPostBack)
|
|
{
|
|
InitControls();
|
|
//Controls();
|
|
}
|
|
lblSFYXXG.Style["display"] = "none";
|
|
HidBJDSFYXXG.Style["display"] = "none";
|
|
lblZDYY.Style["display"] = "none";
|
|
HidZDYY.Style["display"] = "none";
|
|
base.InitPage();
|
|
HiddenField querycontrol = (HiddenField)this.CurMaster.FindControl("DefaultCondition");
|
|
string querycondition = querycontrol.Value.ToString();
|
|
if (querycondition != "")
|
|
{
|
|
queryentity.UnSerializeCondition(querycondition);
|
|
}
|
|
HidBJDSFYXXG.Text = queryentity.FieldByName("SFYXXG").Value;
|
|
if (HidBJDSFYXXG.Text.Equals("N"))
|
|
{
|
|
txtBZBJDH.Text = queryentity.FieldByName("BZBJDH").Value;
|
|
sBZBJDH = txtBZBJDH.Text;
|
|
}
|
|
if (!IsPostBack)
|
|
{
|
|
HidControls();
|
|
}
|
|
}
|
|
|
|
#endregion
|
|
|
|
#region 模板事件
|
|
|
|
protected override bool QueryLogicValid()
|
|
{
|
|
if (txtBZBJDH.Text.Trim().Equals(""))
|
|
{
|
|
ShowMessage("报价单号(被撞)不允许为空！");
|
|
return false;
|
|
}
|
|
return base.QueryLogicValid();
|
|
}
|
|
|
|
protected override void SetControlState()
|
|
{
|
|
base.SetControlState();
|
|
if (!sBZBJDH.Trim().Equals(""))
|
|
{
|
|
txtBZBJDH.Text = sBZBJDH;
|
|
HidControls();
|
|
}
|
|
}
|
|
|
|
# endregion
|
|
|
|
#region 自定义事件
|
|
|
|
private void InitControls()
|
|
{
|
|
bool bVisible = false;
|
|
|
|
WorkFlowUtils.SetCheckedDropDownList_WFPROC("XLXSBJ_BJD", cbxWFState);
|
|
|
|
XLXSBJPZXX pzxx = XLBJDUtils.GetXLXSBJPZXX(100860068);
|
|
cbxZDLX.ClearItems();
|
|
if (pzxx.XLXSBJPZ_KHTXYXZ == "Y")
|
|
{
|
|
cbxZDLX.Items.Add(new ListItem("客户+销售员相撞", "1"));
|
|
chkPXYXJ.Items.Add(new ListItem("客户+销售员相撞", "1"));
|
|
sZDYY += "1,";
|
|
}
|
|
if (pzxx.XLXSBJPZ_KHMCCF == "Y")
|
|
{
|
|
cbxZDLX.Items.Add(new ListItem("客户名称重复", "2"));
|
|
chkPXYXJ.Items.Add(new ListItem("客户名称重复", "2"));
|
|
sZDYY += "2,";
|
|
}
|
|
if (pzxx.XLXSBJPZ_XMMCCF == "Y")
|
|
{
|
|
cbxZDLX.Items.Add(new ListItem("项目名称重复", "3"));
|
|
chkPXYXJ.Items.Add(new ListItem("项目名称重复", "3"));
|
|
sZDYY += "3,";
|
|
}
|
|
if (pzxx.XLXSBJPZ_XMMCCZCF == "Y")
|
|
{
|
|
cbxZDLX.Items.Add(new ListItem("项目名称词组重复", "4"));
|
|
chkPXYXJ.Items.Add(new ListItem("项目名称词组重复", "4"));
|
|
sZDYY += "4,";
|
|
}
|
|
if (pzxx.XLXSBJPZ_CPCF == "Y")
|
|
{
|
|
cbxZDLX.Items.Add(new ListItem("产品重复", "5"));
|
|
chkPXYXJ.Items.Add(new ListItem("产品重复", "5"));
|
|
sZDYY += "5,";
|
|
}
|
|
if (pzxx.XLXSBJPZ_CPFDCF == "Y")
|
|
{
|
|
cbxZDLX.Items.Add(new ListItem("按产品个数区间+分段重复率查产品重复", "14"));
|
|
chkPXYXJ.Items.Add(new ListItem("按产品个数区间+分段重复率查产品重复", "14"));
|
|
sZDYY += "14,";
|
|
}
|
|
if (pzxx.XLXSBJPZ_CPSLCF == "Y")
|
|
{
|
|
cbxZDLX.Items.Add(new ListItem("产品+数量重复", "6"));
|
|
chkPXYXJ.Items.Add(new ListItem("产品+数量重复", "6"));
|
|
sZDYY += "6,";
|
|
}
|
|
if (ZDFXPZHelper.IsGGSLCFEnabled())
|
|
{
|
|
cbxZDLX.Items.Add(new ListItem("规格+数量重复", "16"));
|
|
chkPXYXJ.Items.Add(new ListItem("规格+数量重复", "16"));
|
|
sZDYY += "16,";
|
|
}
|
|
if (pzxx.XLXSBJPZ_XHGGCF == "Y")
|
|
{
|
|
cbxZDLX.Items.Add(new ListItem("仅型号规格重复", "7"));
|
|
chkPXYXJ.Items.Add(new ListItem("仅型号规格重复", "7"));
|
|
sZDYY += "7,";
|
|
}
|
|
if (pzxx.XLXSBJPZ_BAXMKHMCCF == "Y")
|
|
{
|
|
cbxZDLX.Items.Add(new ListItem("备案项目客户名称重复", "8"));
|
|
bVisible = true;
|
|
sZDYY += "8,";
|
|
}
|
|
if (pzxx.XLXSBJPZ_BAXMMCCF == "Y")
|
|
{
|
|
cbxZDLX.Items.Add(new ListItem("备案项目名称重复", "9"));
|
|
bVisible = true;
|
|
sZDYY += "9,";
|
|
}
|
|
if (pzxx.XLXSBJPZ_BAXMMCTXYCF == "Y")
|
|
{
|
|
cbxZDLX.Items.Add(new ListItem("备案项目名称+销售员重复", "10"));
|
|
bVisible = true;
|
|
sZDYY += "10,";
|
|
}
|
|
if (pzxx.XLXSBJPZ_XMKHMCXZ == "Y")
|
|
{
|
|
cbxZDLX.Items.Add(new ListItem("项目与客户名称相撞", "11"));
|
|
chkPXYXJ.Items.Add(new ListItem("项目与客户名称相撞", "11"));
|
|
bVisible = true;
|
|
sZDYY += "11,";
|
|
}
|
|
if (pzxx.XLXSBJPZ_KHLXRCF == "Y")
|
|
{
|
|
cbxZDLX.Items.Add(new ListItem("客户联系人重复", "12"));
|
|
chkPXYXJ.Items.Add(new ListItem("客户联系人重复", "12"));
|
|
bVisible = true;
|
|
sZDYY += "12,";
|
|
}
|
|
if (pzxx.XLXSBJPZ_LXDHCF == "Y")
|
|
{
|
|
cbxZDLX.Items.Add(new ListItem("客户电话重复", "13"));
|
|
chkPXYXJ.Items.Add(new ListItem("客户电话重复", "13"));
|
|
bVisible = true;
|
|
sZDYY += "13,";
|
|
}
|
|
if (pzxx.XLXSBJPZ_KHMCXMMCCF == "Y")
|
|
{
|
|
cbxZDLX.Items.Add(new ListItem("客户名称、项目名称重复", "15"));
|
|
chkPXYXJ.Items.Add(new ListItem("客户名称、项目名称重复", "15"));
|
|
bVisible = true;
|
|
sZDYY += "15,";
|
|
}
|
|
Mac.MacLog.TraceFormat("sZDYY:" + sZDYY);
|
|
cbxZDLX.ShowValue = false;
|
|
if (!bVisible)
|
|
{
|
|
tdBACKRQ.Visible = false;
|
|
tdBAXMKH.Visible = false;
|
|
tdBAXMXSY.Visible = false;
|
|
}
|
|
|
|
chkBJY.ClearItems();
|
|
chkBJY.Items.Add(new ListItem("客户+销售员相同", "1"));
|
|
chkBJY.Items.Add(new ListItem("销售员相同", "2"));
|
|
chkBJY.ShowValue = false;
|
|
|
|
string sSQL = "select XLXSBJFL_BJFLID,XLXSBJFL_BJFLMC from XLXSBJFL where 1=1 ";
|
|
if (!string.IsNullOrEmpty(GetOption(100860068, "BJU012").Trim()))
|
|
{
|
|
sSQL += " and " + CMISproDataBase.GetWhereEqual("XLXSBJFL_BJFLID", GetOption(100860068, "BJU012").Trim());
|
|
}
|
|
sSQL += " order by XLXSBJFL_XSXH,XLXSBJFL_BJFLID ";
|
|
TComboBox.SetComboBox("DBERP", cbxBJFL, sSQL, true);
|
|
|
|
}
|
|
|
|
private void HidControls()
|
|
{
|
|
if (HidBJDSFYXXG.Text.Trim() == "N")
|
|
{
|
|
txtBZBJDH.Enabled = false;
|
|
}
|
|
else
|
|
{
|
|
txtBZBJDH.Enabled = true;
|
|
}
|
|
Mac.MacLog.TraceFormat("sZDYY:" + sZDYY);
|
|
HidZDYY.Text = sZDYY;
|
|
}
|
|
|
|
#endregion
|
|
|
|
#region 控件事件
|
|
|
|
#endregion
|
|
}
|
|
}
|