using System; using System.Data; using System.Configuration; 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 System.Web.Script.Serialization; using GThinking.N_MISPRO.Data; using GThinking.N_MISPRO.Utility; using GThinking.N_WORKFLOW; using GThinking.N_MISPRO; using System.Collections.Generic; using GThinking.N_PUBLIC; using GThinking.N_PUBLIC2; using System.Text; using GThinking.N_MISPROAS; namespace GThinking.U20261363_N_XLXSBJ { [EntityType(Db = "DBERP", Table = "XLXSBJD", IsWf = true, IsWhr = false, WhrPrefix = "XLXSBJD", IsAttach = true, DocFjs = "XLXSBJD_FJS", DocGrpId = "XLXSBJD_DOCGRPID")] public class XLBJD_BDOBill : EntityObject { private string _BJDID; [ScriptIgnore] public string BJDID { get { return _BJDID; } set { _BJDID = value; _XLBJDMX_BDOBill.BJDID = value; } } //是否进行过比对操作 private bool _fCanE = true; public bool fCanE { set { _fCanE = value; } get { return _fCanE; } } //报价分类中进入提交判断的开关 private string _fCanSubmit = string.Empty; public string fCanSubmit { set { _fCanSubmit = value; } get { return _fCanSubmit; } } //传入BJU003参数 private string _sBJU003 = ""; public string sBJU003 { set { _sBJU003 = value; } get { return _sBJU003; } } public Dictionary sFJXXParams = new Dictionary(); private DataSet _dsFJXXSZ; public DataSet dsFJXXSZ { get { if (_dsFJXXSZ == null) { TDatabase db = TContextDatabases.GetDatabase("DBERP"); TSQL sSQL = new TSQL(db); sSQL.Clear(); sSQL.Add("select XLXSBJKZXXSZ_MC, XLXSBJKZXXSZ_SJLX, XLXSBJKZXXSZ_DYZD, isnull(XLXSBJKZXXSZ_BT,'N') as BT, XLXSBJKZXXSZ_SRFS, "); sSQL.Add("XLXSBJKZXXSZ_MJLB,XLXSBJKZXXSZ_MJSQL,XLXSBJKZXXSZ_WIDTH, XLXSBJKZXXSZ_ROWS, XLXSBJKZXXSZ_JLDW,XLXSBJKZXXSZ_QSZ, "); sSQL.Add("XLXSBJKZXXSZ_WHBZ,XLXSBJKZXXSZ_XSBZ,XLXSBJKZXXSZ_SYBJFLID "); sSQL.Add("from XLXSBJKZXXSZ "); sSQL.Add("where 1=1 "); sSQL.Add("order by XLXSBJKZXXSZ_BJSX, XLXSBJKZXXSZ_BH "); _dsFJXXSZ = db.OpenDataSet(sSQL); } return _dsFJXXSZ; } set { _dsFJXXSZ = value; } } public string sYBJDID = ""; private DataSet _dsFJXX; public DataSet getXLXSBJKZXX(string sBJDID) { bool bReOpen = true; if (sBJDID.Equals(sYBJDID)) if (_dsFJXX != null) bReOpen = false; if (bReOpen) { TDatabase dberp = TContextDatabases.GetDatabase("DBERP"); TSQL sSQL = new TSQL(dberp); sSQL.Clear(); sSQL.Add("select XLXSBJKZXX_BJDID, "); sSQL.Add(" XLXSBJKZXX_KZSZ01, XLXSBJKZXX_KZSZ02, XLXSBJKZXX_KZSZ03, XLXSBJKZXX_KZSZ04, XLXSBJKZXX_KZSZ05, "); sSQL.Add(" XLXSBJKZXX_KZRQ01, XLXSBJKZXX_KZRQ02, XLXSBJKZXX_KZRQ03, XLXSBJKZXX_KZRQ04, XLXSBJKZXX_KZRQ05, "); sSQL.Add(" XLXSBJKZXX_KZZF01, XLXSBJKZXX_KZZF02, XLXSBJKZXX_KZZF03, XLXSBJKZXX_KZZF04, XLXSBJKZXX_KZZF05, "); sSQL.Add(" XLXSBJKZXX_KZZF06, XLXSBJKZXX_KZZF07, XLXSBJKZXX_KZZF08, XLXSBJKZXX_KZZF09, XLXSBJKZXX_KZZF10, "); sSQL.Add(" XLXSBJKZXX_KZWB01, XLXSBJKZXX_KZWB02, XLXSBJKZXX_KZWB03, XLXSBJKZXX_KZWB04, XLXSBJKZXX_KZWB05, "); sSQL.Add(" XLXSBJKZXX_WHR, XLXSBJKZXX_WHRID, XLXSBJKZXX_WHSJ "); sSQL.Add("from XLXSBJKZXX "); sSQL.Add("where XLXSBJKZXX_BJDID = :pBJDID "); sSQL.ParamByName("pBJDID").Value = sBJDID; _dsFJXX = dberp.OpenDataSet(sSQL); } sYBJDID = sBJDID; return _dsFJXX; } [DataMember(DbField = "XLXSBJD_BJDID", DbTitle = "报价单号", IsKey = true, DbType = TGtdbType.VarChar, Len = 20, IsNullable = false, DefValue = "", CtlName = "txtBJDID", CtlType = FieldType.C)] public string XLXSBJD_BJDID { get { return GetField("XLXSBJD_BJDID").ToString().Trim(); } set { SetField("XLXSBJD_BJDID", value); } } [DataMember(DbField = "XLXSBJD_BJFLID", DbTitle = "报价分类", IsKey = false, DbType = TGtdbType.VarChar, Len = 8, IsNullable = false, DefValue = "", CtlName = "cbxBJFLID", CtlType = FieldType.CBX)] public string XLXSBJD_BJFLID { get { return GetField("XLXSBJD_BJFLID").ToString().Trim(); } set { SetField("XLXSBJD_BJFLID", value); } } [DataMember(DbField = "XLXSBJD_KHID", DbTitle = "客户ID", IsKey = false, DbType = TGtdbType.VarChar, Len = 8, IsNullable = true, DefValue = "", CtlName = "txtHidKHID", CtlType = FieldType.HiddenField)] public string XLXSBJD_KHID { get { return GetField("XLXSBJD_KHID").ToString().Trim(); } set { SetField("XLXSBJD_KHID", value); } } [DataMember(DbField = "XLXSBJD_XSQYID", DbTitle = "销售区域", IsKey = false, DbType = TGtdbType.VarChar, Len = 20, IsNullable = true, DefValue = "", CtlName = "cbxXSQYID", CtlType = FieldType.CBX)] public string XLXSBJD_XSQYID { get { return GetField("XLXSBJD_XSQYID").ToString().Trim(); } set { SetField("XLXSBJD_XSQYID", value); } } [DataMember(DbField = "XLXSBJD_JGBID", DbTitle = "价格表", IsKey = false, DbType = TGtdbType.VarChar, Len = 8, IsNullable = true, DefValue = "", CtlName = "cbxJGBID", CtlType = FieldType.CBX)] public string XLXSBJD_JGBID { get { return GetField("XLXSBJD_JGBID").ToString().Trim(); } set { SetField("XLXSBJD_JGBID", value); } } // [DataMember(DbField = "XLXSBJD_CLHQJGBID", DbTitle = "材料行情价格表ID", IsKey = false, DbType = TGtdbType.VarChar, Len = 8, IsNullable = true, DefValue = "", CtlName = "txtCLHQJGBID", CtlType = FieldType.HiddenField)] public string XLXSBJD_CLHQJGBID { get { return GetField("XLXSBJD_CLHQJGBID").ToString().Trim(); } set { SetField("XLXSBJD_CLHQJGBID", value); } } [DataMember(DbField = "XLXSBJD_WPID", DbTitle = "流程状态", IsKey = false, DbType = TGtdbType.VarChar, Len = 4, IsNullable = true, DefValue = "", CtlName = "txtWPID", CtlType = FieldType.HiddenField)] public string XLXSBJD_WPID { get { return GetField("XLXSBJD_WPID").ToString().Trim(); } set { SetField("XLXSBJD_WPID", value); } } [DataMember(DbField = "XLXSBJD_SYDWID", DbTitle = "销售单位", IsKey = false, DbType = TGtdbType.VarChar, Len = 4, IsNullable = true, DefValue = "", CtlName = "cbxSYDWID", CtlType = FieldType.CBX)] public string XLXSBJD_SYDWID { get { return GetField("XLXSBJD_SYDWID").ToString().Trim(); } set { SetField("XLXSBJD_SYDWID", value); } } [DataMember(DbField = "XLXSBJD_BJRQ", DbTitle = "报价日期", IsKey = false, DbType = TGtdbType.DateTime, Len = 20, IsNullable = true, DefValue = "", CtlName = "datBJRQ", CtlType = FieldType.D)] public string XLXSBJD_BJRQ { get { return GetField("XLXSBJD_BJRQ").ToString().Trim(); } set { SetField("XLXSBJD_BJRQ", value); } } [DataMember(DbField = "XLXSBJD_XSJLMC", DbTitle = "销售经理", IsKey = false, DbType = TGtdbType.VarChar, Len = 30, IsNullable = true, DefValue = "", CtlName = "cbxXSJLMC", CtlType = FieldType.CBX)] public string XLXSBJD_XSJLMC { get { return GetField("XLXSBJD_XSJLMC").ToString().Trim(); } set { SetField("XLXSBJD_XSJLMC", value); } } [DataMember(DbField = "XLXSBJD_TXY", DbTitle = "销售员", IsKey = false, DbType = TGtdbType.VarChar, Len = 30, IsNullable = true, DefValue = "", CtlName = "cbxTXY", CtlType = FieldType.CBX)] public string XLXSBJD_TXY { get { return GetField("XLXSBJD_TXY").ToString().Trim(); } set { SetField("XLXSBJD_TXY", value); } } //原 销售部 门 [DataMember(DbField = "XLXSBJD_XSBMID", DbTitle = "销售部门", IsKey = false, DbType = TGtdbType.VarChar, Len = 8, IsNullable = true, DefValue = "", CtlName = "cbxXSBMID", CtlType = FieldType.CBX)] public string XLXSBJD_XSBMID { get { return GetField("XLXSBJD_XSBMID").ToString().Trim(); } set { SetField("XLXSBJD_XSBMID", value); } } [DataMember(DbField = "XLXSBJD_KH", DbTitle = "客户", IsKey = false, DbType = TGtdbType.VarChar, Len = 120, IsNullable = true, DefValue = "", CtlName = "txtKH", CtlType = FieldType.C)] public string XLXSBJD_KH { get { return GetField("XLXSBJD_KH").ToString().Trim(); } set { SetField("XLXSBJD_KH", value); } } [DataMember(DbField = "XLXSBJD_KHLXR", DbTitle = "客户联系人", IsKey = false, DbType = TGtdbType.VarChar, Len = 60, IsNullable = true, DefValue = "", CtlName = "txtKHLXR", CtlType = FieldType.C)] public string XLXSBJD_KHLXR { get { return GetField("XLXSBJD_KHLXR").ToString().Trim(); } set { SetField("XLXSBJD_KHLXR", value); } } [DataMember(DbField = "XLXSBJD_LXDH", DbTitle = "客户联系电话", IsKey = false, DbType = TGtdbType.VarChar, Len = 60, IsNullable = true, DefValue = "", CtlName = "txtLXDH", CtlType = FieldType.C)] public string XLXSBJD_LXDH { get { return GetField("XLXSBJD_LXDH").ToString().Trim(); } set { SetField("XLXSBJD_LXDH", value); } } [DataMember(DbField = "XLXSBJD_CZ", DbTitle = "客户传真", IsKey = false, DbType = TGtdbType.VarChar, Len = 60, IsNullable = true, DefValue = "", CtlName = "txtCZ", CtlType = FieldType.C)] public string XLXSBJD_CZ { get { return GetField("XLXSBJD_CZ").ToString().Trim(); } set { SetField("XLXSBJD_CZ", value); } } [DataMember(DbField = "XLXSBJD_PJLX", DbTitle = "付款方式", IsKey = false, DbType = TGtdbType.VarChar, Len = 2, IsNullable = true, DefValue = "", CtlName = "cbxPJLX", CtlType = FieldType.CBX)] public string XLXSBJD_PJLX { get { return GetField("XLXSBJD_PJLX").ToString().Trim(); } set { SetField("XLXSBJD_PJLX", value); } } //基准报价含税 [DataMember(DbField = "XLXSBJD_JZBJHS", DbTitle = "表价含税", IsKey = false, DbType = TGtdbType.VarChar, Len = 1, IsNullable = true, DefValue = "", CtlName = "chkJZBJHS", CtlType = FieldType.Y)] public string XLXSBJD_JZBJHS { get { return GetField("XLXSBJD_JZBJHS").ToString().Trim(); } set { SetField("XLXSBJD_JZBJHS", value); } } [DataMember(DbField = "XLXSBJD_XMMC", DbTitle = "项目", IsKey = false, DbType = TGtdbType.VarChar, Len = 160, IsNullable = true, DefValue = "", CtlName = "txtXM", CtlType = FieldType.C)] public string XLXSBJD_XMMC { get { return GetField("XLXSBJD_XMMC").ToString().Trim(); } set { SetField("XLXSBJD_XMMC", value); } } [DataMember(DbField = "XLXSBJD_XXDZ", DbTitle = "详细地址", IsKey = false, DbType = TGtdbType.VarChar, Len = 100, IsNullable = true, DefValue = "", CtlName = "txtXXDZ", CtlType = FieldType.C)] public string XLXSBJD_XXDZ { get { return GetField("XLXSBJD_XXDZ").ToString().Trim(); } set { SetField("XLXSBJD_XXDZ", value); } } [DataMember(DbField = "XLXSBJD_FKSM", DbTitle = "付款说明", IsKey = false, DbType = TGtdbType.VarChar, Len = 1500, IsNullable = true, DefValue = "", CtlName = "txtFKSM", CtlType = FieldType.C)] public string XLXSBJD_FKSM { get { return GetField("XLXSBJD_FKSM").ToString().Trim(); } set { SetField("XLXSBJD_FKSM", value); } } [DataMember(DbField = "XLXSBJD_BZ", DbTitle = "报价备注", IsKey = false, DbType = TGtdbType.VarChar, Len = 1500, IsNullable = true, DefValue = "", CtlName = "txtBZ", CtlType = FieldType.C)] public string XLXSBJD_BZ { get { return GetField("XLXSBJD_BZ").ToString().Trim(); } set { SetField("XLXSBJD_BZ", value); } } //总金额 [DataMember(DbField = "XLXSBJD_ZJE", DbTitle = "报价总金额", IsKey = false, DbType = TGtdbType.Float, Len = 0, IsNullable = true, DefValue = "0", CtlName = "txtZJE", CtlType = FieldType.F)] public string XLXSBJD_ZJE { get { return GetField("XLXSBJD_ZJE").ToString().Trim(); } set { SetField("XLXSBJD_ZJE", value); } } [DataMember(DbField = "XLXSBJD_ZZL", DbTitle = "材料总重量", IsKey = false, DbType = TGtdbType.Float, Len = 0, IsNullable = true, DefValue = "0", CtlName = "txtZZL", CtlType = FieldType.F)] public string XLXSBJD_ZZL { get { return GetField("XLXSBJD_ZZL").ToString().Trim(); } set { SetField("XLXSBJD_ZZL", value); } } [DataMember(DbField = "XLXSBJD_LRL", DbTitle = "表价价差率(%)", IsKey = false, DbType = TGtdbType.Float, PrintVisible = false, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtLRL", CtlType = FieldType.F)] public string XLXSBJD_LRL { get { return GetField("XLXSBJD_LRL").ToString().Trim(); } set { SetField("XLXSBJD_LRL", value); } } [DataMember(DbField = "XLXSBJD_BJSM", DbTitle = "报价说明", IsKey = false, DbType = TGtdbType.Text, Len = 4000, IsNullable = true, DefValue = "", CtlName = "txtBJSM", CtlType = FieldType.T)] public string XLXSBJD_BJSM { get { return GetField("XLXSBJD_BJSM").ToString().Trim(); } set { SetField("XLXSBJD_BJSM", value); } } //XLXSBJD_FKQXNR [DataMember(DbField = "XLXSBJD_FKQXNR", DbTitle = "付款期限", IsKey = false, DbType = TGtdbType.VarChar, Len = 250, IsNullable = true, DefValue = "", CtlName = "txtFKQXNR", CtlType = FieldType.C)] public string XLXSBJD_FKQXNR { get { return GetField("XLXSBJD_FKQXNR").ToString().Trim(); } set { SetField("XLXSBJD_FKQXNR", value); } } //运输节点-供应商 [DataMember(DbField = "XLXSBJD_YSJDID", DbTitle = "运输地点", IsKey = false, DbType = TGtdbType.VarChar, Len = 10, IsNullable = true, DefValue = "", CtlName = "cbxYSJDID", CtlType = FieldType.CBX)] public string XLXSBJD_YSJDID { get { return GetField("XLXSBJD_YSJDID").ToString().Trim(); } set { SetField("XLXSBJD_YSJDID", value); } } [DataMember(DbField = "XLXSBJD_GYSID", DbTitle = "送货单位", IsKey = false, DbType = TGtdbType.VarChar, Len = 8, IsNullable = true, DefValue = "", CtlName = "cbxGYSID", CtlType = FieldType.CBX)] public string XLXSBJD_GYSID { get { return GetField("XLXSBJD_GYSID").ToString().Trim(); } set { SetField("XLXSBJD_GYSID", value); } } [DataMember(DbField = "XLXSBJD_YSFY", DbTitle = "运费", IsKey = false, DbType = TGtdbType.Float, Len = 0, IsNullable = true, DefValue = "0", CtlName = "txtYSFY", CtlType = FieldType.F)] public string XLXSBJD_YSFY { get { return GetField("XLXSBJD_YSFY").ToString().Trim(); } set { SetField("XLXSBJD_YSFY", value); } } [DataMember(DbField = "XLXSBJD_TJ", DbTitle = "铜价", IsKey = false, DbType = TGtdbType.Float, Len = 0, IsNullable = true, DefValue = "0", CtlName = "txtTJ", CtlType = FieldType.F)] public string XLXSBJD_TJ { get { return GetField("XLXSBJD_TJ").ToString().Trim(); } set { SetField("XLXSBJD_TJ", value); } } [DataMember(DbField = "XLXSBJD_LJ", DbTitle = "铝价", IsKey = false, DbType = TGtdbType.Float, Len = 0, IsNullable = true, DefValue = "0", CtlName = "txtLJ", CtlType = FieldType.F)] public string XLXSBJD_LJ { get { return GetField("XLXSBJD_LJ").ToString().Trim(); } set { SetField("XLXSBJD_LJ", value); } } [DataMember(DbField = "XLXSBJD_CZJSXY", DbTitle = "有无技术协议", IsKey = false, DbType = TGtdbType.VarChar, Len = 1, IsNullable = true, DefValue = "", CtlName = "cbxCZJSXY", CtlType = FieldType.CBX)] public string XLXSBJD_CZJSXY { get { return GetField("XLXSBJD_CZJSXY").ToString().Trim(); } set { SetField("XLXSBJD_CZJSXY", value); } } [DataMember(DbField = "XLXSBJD_KHDH", DbTitle = "客户单号", IsKey = false, DbType = TGtdbType.VarChar, Len = 30, IsNullable = true, DefValue = "", CtlName = "txtKHDH", CtlType = FieldType.C)] public string XLXSBJD_KHDH { get { return GetField("XLXSBJD_KHDH").ToString().Trim(); } set { SetField("XLXSBJD_KHDH", value); } } // [DataMember(DbField = "XLXSBJD_XZQHID", DbTitle = "行政区划", IsKey = false, DbType = TGtdbType.VarChar, Len = 10, IsNullable = true, DefValue = "", CtlName = "txtXZQHID", CtlType = FieldType.HiddenField)] public string XLXSBJD_XZQHID { get { return GetField("XLXSBJD_XZQHID").ToString().Trim(); } set { SetField("XLXSBJD_XZQHID", value); } } [DataMember(DbField = "XLXSBJD_XMID", DbTitle = "项目ID", IsKey = false, DbType = TGtdbType.VarChar, Len = 10, IsNullable = true, DefValue = "", CtlName = "txtXMID", CtlType = FieldType.HiddenField)] public string XLXSBJD_XMID { get { return GetField("XLXSBJD_XMID").ToString().Trim(); } set { SetField("XLXSBJD_XMID", value); } } [DataMember(DbField = "XLXSBJD_SQR", DbTitle = "申请人", IsKey = false, DbType = TGtdbType.VarChar, Len = 30, IsNullable = true, DefValue = "", CtlName = "txtSQR", CtlType = FieldType.HiddenField)] public string XLXSBJD_SQR { get { return GetField("XLXSBJD_SQR").ToString().Trim(); } set { SetField("XLXSBJD_SQR", value); } } [DataMember(DbField = "XLXSBJD_ZDQRRGH", DbTitle = "撞单人工号", IsKey = false, DbType = TGtdbType.VarChar, Len = 10, IsNullable = true, DefValue = "", CtlName = "txtZDQRRGH", CtlType = FieldType.HiddenField)] public string XLXSBJD_ZDQRRGH { get { return GetField("XLXSBJD_ZDQRRGH").ToString().Trim(); } set { SetField("XLXSBJD_ZDQRRGH", value); } } [DataMember(DbField = "XLXSBJD_SQRGH", DbTitle = "申请人工号", IsKey = false, DbType = TGtdbType.VarChar, Len = 10, IsNullable = true, DefValue = "", CtlName = "txtSQRGH", CtlType = FieldType.HiddenField)] public string XLXSBJD_SQRGH { get { return GetField("XLXSBJD_SQRGH").ToString().Trim(); } set { SetField("XLXSBJD_SQRGH", value); } } [DataMember(DbField = "XLXSBJD_SQRID", DbTitle = "申请人ID", IsKey = false, DbType = TGtdbType.VarChar, Len = 10, IsNullable = true, DefValue = "", CtlName = "txtSQRID", CtlType = FieldType.HiddenField)] public string XLXSBJD_SQRID { get { return GetField("XLXSBJD_SQRID").ToString().Trim(); } set { SetField("XLXSBJD_SQRID", value); } } [DataMember(DbField = "XLXSBJD_SQRQ", DbTitle = "申请日期", IsKey = false, DbType = TGtdbType.DateTime, Len = 22, IsNullable = true, DefValue = "", CtlName = "txtSQRQ", CtlType = FieldType.HiddenField)] public string XLXSBJD_SQRQ { get { return GetField("XLXSBJD_SQRQ").ToString().Trim(); } set { SetField("XLXSBJD_SQRQ", value); } } [DataMember(DbField = "XLXSBJD_YBJDIDS", DbTitle = "原报价单号", IsKey = false, DbType = TGtdbType.VarChar, Len = 250, IsNullable = true, DefValue = "", CtlName = "txtYBJDIDS", CtlType = FieldType.HiddenField)] public string XLXSBJD_YBJDIDS { get { return GetField("XLXSBJD_YBJDIDS").ToString().Trim(); } set { SetField("XLXSBJD_YBJDIDS", value); } } [DataMember(DbField = "XLXSBJD_ZDZDLX", DbTitle = "自动撞单类型", IsKey = false, DbType = TGtdbType.VarChar, Len = 250, IsNullable = true, DefValue = "", CtlName = "txtZDZDLX", CtlType = FieldType.HiddenField)] public string XLXSBJD_ZDZDLX { get { return GetField("XLXSBJD_ZDZDLX").ToString().Trim(); } set { SetField("XLXSBJD_ZDZDLX", value); } } [DataMember(DbField = "XLXSBJD_ZT", DbTitle = "状态", IsKey = false, DbType = TGtdbType.VarChar, Len = 1, IsNullable = true, DefValue = "", CtlName = "txtZT", CtlType = FieldType.HiddenField)] public string XLXSBJD_ZT { get { return GetField("XLXSBJD_ZT").ToString().Trim(); } set { SetField("XLXSBJD_ZT", value); } } [DataMember(DbField = "XLXSBJD_FZBZ", DbTitle = "复制标志", IsKey = false, DbType = TGtdbType.VarChar, Len = 1, IsNullable = true, DefValue = "N", CtlName = "txtFZBZ", CtlType = FieldType.HiddenField)] public string XLXSBJD_FZBZ { get { return GetField("XLXSBJD_FZBZ").ToString().Trim(); } set { SetField("XLXSBJD_FZBZ", value); } } [DataMember(DbField = "XLXSBJD_BJSQDH", DbTitle = "报价申请单号", IsKey = false, DbType = TGtdbType.VarChar, Len = 20, IsNullable = true, DefValue = "", CtlName = "txtBJSQDH", CtlType = FieldType.HiddenField)] public string XLXSBJD_BJSQDH { get { return GetField("XLXSBJD_BJSQDH").ToString().Trim(); } set { SetField("XLXSBJD_BJSQDH", value); } } [DataMember(DbField = "XLXSBJD_KQZYZDBS", DbTitle = "跨区专营撞单标识", IsKey = false, DbType = TGtdbType.VarChar, Len = 1, IsNullable = true, DefValue = "", CtlName = "chkKQZYZDBS", CtlType = FieldType.Y)] public string XLXSBJD_KQZYZDBS { get { return GetField("XLXSBJD_KQZYZDBS").ToString().Trim(); } set { SetField("XLXSBJD_KQZYZDBS", value); } } [DataMember(DbField = "XLXSBJD_DOCGRPID", DbTitle = "文档分组号", IsKey = false, DbType = TGtdbType.Float, PrintVisible = false, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtDOCGRPID", CtlType = FieldType.HiddenField)] public string XLXSBJD_DOCGRPID { get { return GetField("XLXSBJD_DOCGRPID").ToString().Trim(); } set { SetField("XLXSBJD_DOCGRPID", value); } } [DataMember(DbField = "XLXSBJD_FJS", DbTitle = "附件数", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtFJS", CtlType = FieldType.F)] public string XLXSBJD_FJS { get { return GetField("XLXSBJD_FJS").ToString().Trim(); } set { SetField("XLXSBJD_FJS", value); } } [DataMember(DbField = "XLXSBJD_WFID", DbTitle = "工作流号", IsKey = false, DbType = TGtdbType.VarChar, PrintVisible = false, Len = 10, IsNullable = true, DefValue = "", CtlName = "txtWFID", CtlType = FieldType.HiddenField)] public string XLXSBJD_WFID { get { return GetField("XLXSBJD_WFID").ToString().Trim(); } set { SetField("XLXSBJD_WFID", value); } } [DataMember(DbField = "XLXSBJD_WFINST", DbTitle = "工作流实例号", IsKey = false, DbType = TGtdbType.Float, PrintVisible = false, Len = 8, IsNullable = true, DefValue = "", CtlName = "txtWFINST", CtlType = FieldType.HiddenField)] public string XLXSBJD_WFINST { get { return GetField("XLXSBJD_WFINST").ToString().Trim(); } set { SetField("XLXSBJD_WFINST", value); } } [DataMember(DbField = "XLXSBJD_WFAWAITER", DbTitle = "待处理人", IsKey = false, DbType = TGtdbType.VarChar, PrintVisible = false, Len = 250, IsNullable = true, DefValue = "", CtlName = "txtAWAITER", CtlType = FieldType.HiddenField)] public string XLXSBJD_WFAWAITER { get { return GetField("XLXSBJD_WFAWAITER").ToString().Trim(); } set { SetField("XLXSBJD_WFAWAITER", value); } } [DataMember(DbField = "XLXSBJD_WFHANDLER", DbTitle = "已处理人", IsKey = false, DbType = TGtdbType.VarChar, PrintVisible = false, Len = 250, IsNullable = true, DefValue = "", CtlName = "txtHANDLER", CtlType = FieldType.HiddenField)] public string XLXSBJD_WFHANDLER { get { return GetField("XLXSBJD_WFHANDLER").ToString().Trim(); } set { SetField("XLXSBJD_WFHANDLER", value); } } [DataMember(DbField = "XLXSBJD_WHR", DbTitle = "维护人", IsKey = false, DbType = TGtdbType.VarChar, Len = 30, IsNullable = true, DefValue = "", CtlName = "txtWHR", CtlType = FieldType.C)] public string XLXSBJD_WHR { get { return GetField("XLXSBJD_WHR").ToString().Trim(); } set { SetField("XLXSBJD_WHR", value); } } [DataMember(DbField = "XLXSBJD_WHRID", DbTitle = "维护人工号", IsKey = false, DbType = TGtdbType.VarChar, PrintVisible = false, Len = 10, IsNullable = true, DefValue = "", CtlName = "txtWHRID", CtlType = FieldType.HiddenField)] public string XLXSBJD_WHRID { get { return GetField("XLXSBJD_WHRID").ToString().Trim(); } set { SetField("XLXSBJD_WHRID", value); } } [DataMember(DbField = "XLXSBJD_WHSJ", DbTitle = "维护时间", IsKey = false, DbType = TGtdbType.DateTime, Len = 8, IsNullable = true, DefValue = "", CtlName = "datWHSJ", CtlType = FieldType.DT)] public string XLXSBJD_WHSJ { get { return GetField("XLXSBJD_WHSJ").ToString().Trim(); } set { SetField("XLXSBJD_WHSJ", value); } } public override TSQL SetDeleteSql() { TSQL SQL = base.SetDeleteSql(); SQL.Add("delete from XLXSBJD where XLXSBJD_BJDID = :XLXSBJD_BJDID"); return SQL; } public override TSQL SetInsertSql() { TSQL SQL = base.SetInsertSql(); SQL.Add("insert into XLXSBJD( "); SQL.Add("XLXSBJD_BJDID,XLXSBJD_JGBID,XLXSBJD_CLHQJGBID,"); SQL.Add("XLXSBJD_BJFLID,XLXSBJD_KHID,XLXSBJD_XSQYID,"); SQL.Add("XLXSBJD_SYDWID,"); SQL.Add("XLXSBJD_BJRQ,"); SQL.Add("XLXSBJD_XSJLMC,"); SQL.Add("XLXSBJD_TXY,XLXSBJD_XSBMID,"); SQL.Add("XLXSBJD_KH,XLXSBJD_KHLXR,XLXSBJD_LXDH,XLXSBJD_CZ,XLXSBJD_PJLX,XLXSBJD_JZBJHS,"); SQL.Add("XLXSBJD_XMMC,"); SQL.Add("XLXSBJD_XXDZ,XLXSBJD_FKSM,"); SQL.Add("XLXSBJD_BZ,"); SQL.Add("XLXSBJD_ZJE,XLXSBJD_ZZL,"); SQL.Add("XLXSBJD_LRL,"); SQL.Add("XLXSBJD_FKQXNR,"); SQL.Add("XLXSBJD_YSJDID,"); SQL.Add("XLXSBJD_GYSID,"); SQL.Add("XLXSBJD_YSFY,"); SQL.Add("XLXSBJD_TJ,XLXSBJD_LJ,XLXSBJD_CZJSXY,XLXSBJD_KHDH,"); SQL.Add("XLXSBJD_XZQHID,XLXSBJD_XMID,"); SQL.Add("XLXSBJD_SQR,XLXSBJD_SQRGH,XLXSBJD_SQRID,XLXSBJD_SQRQ,"); SQL.Add("XLXSBJD_YBJDIDS,XLXSBJD_ZT,XLXSBJD_FZBZ,XLXSBJD_KQZYZDBS,"); SQL.Add("XLXSBJD_WHRID,"); SQL.Add("XLXSBJD_WHR,"); SQL.Add("XLXSBJD_WHSJ,"); SQL.Add("XLXSBJD_DOCGRPID,"); SQL.Add("XLXSBJD_FJS)"); SQL.Add(" values("); SQL.Add(":XLXSBJD_BJDID,:XLXSBJD_JGBID,:XLXSBJD_CLHQJGBID,"); SQL.Add(":XLXSBJD_BJFLID,:XLXSBJD_KHID,:XLXSBJD_XSQYID,"); SQL.Add(":XLXSBJD_SYDWID,"); SQL.Add(":XLXSBJD_BJRQ,"); SQL.Add(":XLXSBJD_XSJLMC,"); SQL.Add(":XLXSBJD_TXY,:XLXSBJD_XSBMID,"); SQL.Add(":XLXSBJD_KH,:XLXSBJD_KHLXR,:XLXSBJD_LXDH,:XLXSBJD_CZ,:XLXSBJD_PJLX,:XLXSBJD_JZBJHS,"); SQL.Add(":XLXSBJD_XMMC,"); SQL.Add(":XLXSBJD_XXDZ,:XLXSBJD_FKSM,"); SQL.Add(":XLXSBJD_BZ,"); SQL.Add(":XLXSBJD_ZJE,:XLXSBJD_ZZL,"); SQL.Add(":XLXSBJD_LRL,"); SQL.Add(":XLXSBJD_FKQXNR,"); SQL.Add(":XLXSBJD_YSJDID,"); SQL.Add(":XLXSBJD_GYSID,"); SQL.Add(":XLXSBJD_YSFY,"); SQL.Add(":XLXSBJD_TJ,:XLXSBJD_LJ,:XLXSBJD_CZJSXY,:XLXSBJD_KHDH,"); SQL.Add(":XLXSBJD_XZQHID,:XLXSBJD_XMID,"); SQL.Add(":XLXSBJD_SQR,:XLXSBJD_SQRGH,:XLXSBJD_SQRID,:XLXSBJD_SQRQ,"); SQL.Add(":XLXSBJD_YBJDIDS,:XLXSBJD_ZT,:XLXSBJD_FZBZ,:XLXSBJD_KQZYZDBS,"); SQL.Add(":XLXSBJD_WHRID,"); SQL.Add(":XLXSBJD_WHR,"); SQL.Add(":XLXSBJD_WHSJ,"); SQL.Add(":XLXSBJD_DOCGRPID,"); SQL.Add(":XLXSBJD_FJS)"); return SQL; } public override TSQL SetUpdateSql() { TSQL SQL = base.SetUpdateSql(); SQL.Add("update XLXSBJD set "); SQL.Add(" XLXSBJD_BJDID=:XLXSBJD_BJDID,XLXSBJD_JGBID=:XLXSBJD_JGBID,XLXSBJD_CLHQJGBID=:XLXSBJD_CLHQJGBID,"); SQL.Add(" XLXSBJD_BJFLID=:XLXSBJD_BJFLID, XLXSBJD_KHID=:XLXSBJD_KHID, XLXSBJD_XSQYID=:XLXSBJD_XSQYID, XLXSBJD_SYDWID=:XLXSBJD_SYDWID,"); SQL.Add(" XLXSBJD_BJRQ=:XLXSBJD_BJRQ,"); SQL.Add(" XLXSBJD_XSJLMC=:XLXSBJD_XSJLMC,"); SQL.Add(" XLXSBJD_TXY=:XLXSBJD_TXY, XLXSBJD_XSBMID =:XLXSBJD_XSBMID, "); SQL.Add(" XLXSBJD_KH=:XLXSBJD_KH,XLXSBJD_KHLXR=:XLXSBJD_KHLXR,XLXSBJD_LXDH=:XLXSBJD_LXDH,XLXSBJD_CZ=:XLXSBJD_CZ,XLXSBJD_PJLX=:XLXSBJD_PJLX,XLXSBJD_JZBJHS=:XLXSBJD_JZBJHS,"); SQL.Add(" XLXSBJD_XMMC=:XLXSBJD_XMMC,"); SQL.Add(" XLXSBJD_XXDZ=:XLXSBJD_XXDZ, "); SQL.Add(" XLXSBJD_FKSM=:XLXSBJD_FKSM,"); SQL.Add(" XLXSBJD_BZ=:XLXSBJD_BZ, "); SQL.Add(" XLXSBJD_ZJE=:XLXSBJD_ZJE,XLXSBJD_ZZL=:XLXSBJD_ZZL, "); SQL.Add(" XLXSBJD_LRL=:XLXSBJD_LRL, "); SQL.Add(" XLXSBJD_FKQXNR=:XLXSBJD_FKQXNR, "); SQL.Add(" XLXSBJD_YSJDID=:XLXSBJD_YSJDID,XLXSBJD_GYSID=:XLXSBJD_GYSID,XLXSBJD_YSFY=:XLXSBJD_YSFY, "); SQL.Add(" XLXSBJD_TJ=:XLXSBJD_TJ,XLXSBJD_LJ=:XLXSBJD_LJ,XLXSBJD_CZJSXY=:XLXSBJD_CZJSXY,XLXSBJD_KHDH=:XLXSBJD_KHDH,"); SQL.Add(" XLXSBJD_XZQHID=:XLXSBJD_XZQHID,XLXSBJD_XMID=:XLXSBJD_XMID,XLXSBJD_KQZYZDBS=:XLXSBJD_KQZYZDBS,"); SQL.Add(" XLXSBJD_WHR=:XLXSBJD_WHR, "); SQL.Add(" XLXSBJD_WHRID=:XLXSBJD_WHRID, "); SQL.Add(" XLXSBJD_WHSJ=:XLXSBJD_WHSJ, "); SQL.Add(" XLXSBJD_DOCGRPID=:XLXSBJD_DOCGRPID,"); SQL.Add(" XLXSBJD_FJS=:XLXSBJD_FJS"); SQL.Add(" where XLXSBJD_BJDID = :XLXSBJD_BJDID"); return SQL; } public override TSQL SetQuerySql() { TSQL SQL = base.SetQuerySql(); SQL.Add(" select XLXSBJD_BJDID, XLXSBJD_JGBID,XLXSBJD_CLHQJGBID, XLXSBJD_BJFLID, XLXSBJD_KHID, XLXSBJD_XSQYID, XLXSBJD_SYDWID, XLXSBJD_BJRQ, XLXSBJD_XSJLMC, "); SQL.Add(" XLXSBJD_TXY, XLXSBJD_XSBMID, XLXSBJD_KH, XLXSBJD_KHLXR,XLXSBJD_LXDH,XLXSBJD_CZ, XLXSBJD_PJLX, XLXSBJD_JZBJHS, XLXSBJD_XMMC, XLXSBJD_XXDZ, XLXSBJD_FKSM, XLXSBJD_BZ,"); SQL.Add(" XLXSBJD_ZJE,XLXSBJD_ZZL,XLXSBJD_LRL,XLXSBJD_ZDZDLX, "); SQL.Add(" XLXSBJD_FKQXNR,XLXSBJD_BJSM,XLXSBJD_TJ,XLXSBJD_LJ,XLXSBJD_CZJSXY,XLXSBJD_KHDH,"); SQL.Add(" XLXSBJD_XZQHID,XLXSBJD_XMID,"); SQL.Add(" XLXSBJD_YBJDIDS,XLXSBJD_ZT,XLXSBJD_FZBZ,XLXSBJD_BJSQDH,"); SQL.Add(" XLXSBJD_YSJDID,XLXSBJD_GYSID,XLXSBJD_YSFY,XLXSBJD_ZB,XLXSBJD_ZBJE,XLXSBJD_KQZYZDBS,"); SQL.Add(" XLXSBJD_WHR, XLXSBJD_WHRID, XLXSBJD_WHSJ, XLXSBJD_DOCGRPID, XLXSBJD_FJS, XLXSBJD_WFID, XLXSBJD_WFINST, XLXSBJD_WPID, XLXSBJD_WFAWAITER, XLXSBJD_WFHANDLER, XLXSBJD_ACTNAME"); SQL.Add(" from XLXSBJD "); SQL.Add(" where 1 = 1 "); //增加where条件以及参数的赋值 return SQL; } public override TSQL SetQuerySqlByKey() { TSQL SQL = base.SetQuerySqlByKey(); SQL.Add(" select XLXSBJD_BJDID, XLXSBJD_JGBID,XLXSBJD_CLHQJGBID, XLXSBJD_BJFLID, XLXSBJD_KHID, XLXSBJD_XSQYID, XLXSBJD_SYDWID, XLXSBJD_BJRQ, XLXSBJD_XSJLMC, "); SQL.Add(" XLXSBJD_TXY, XLXSBJD_XSBMID, XLXSBJD_KH, XLXSBJD_KHLXR,XLXSBJD_LXDH,XLXSBJD_CZ, XLXSBJD_PJLX, XLXSBJD_JZBJHS, XLXSBJD_XMMC, XLXSBJD_XXDZ, XLXSBJD_FKSM, XLXSBJD_BZ,"); SQL.Add(" XLXSBJD_ZJE,XLXSBJD_ZZL,XLXSBJD_LRL,XLXSBJD_SQR,XLXSBJD_SQRGH,XLXSBJD_SQRID,XLXSBJD_ZDQRRGH, "); SQL.Add(" XLXSBJD_FKQXNR,XLXSBJD_BJSM,XLXSBJD_TJ,XLXSBJD_LJ,XLXSBJD_CZJSXY,XLXSBJD_KHDH,"); SQL.Add(" XLXSBJD_XZQHID,XLXSBJD_XMID,XLXSBJD_ZDZDLX,"); SQL.Add(" XLXSBJD_YBJDIDS,XLXSBJD_ZT,XLXSBJD_FZBZ,XLXSBJD_BJSQDH,"); SQL.Add(" XLXSBJD_YSJDID,XLXSBJD_GYSID,XLXSBJD_YSFY,XLXSBJD_ZB,XLXSBJD_ZBJE,XLXSBJD_KQZYZDBS,"); SQL.Add(" XLXSBJD_WHR, XLXSBJD_WHRID, XLXSBJD_WHSJ, XLXSBJD_DOCGRPID, XLXSBJD_FJS, XLXSBJD_WFID, XLXSBJD_WFINST, XLXSBJD_WPID, XLXSBJD_WFAWAITER, XLXSBJD_WFHANDLER, XLXSBJD_ACTNAME"); SQL.Add(" from XLXSBJD "); SQL.Add(" where XLXSBJD_BJDID = :XLXSBJD_BJDID"); SQL.AddParam("XLXSBJD_BJDID", TGtdbType.VarChar, 20, _BJDID); return SQL; } public override bool Deleted(TSQL sql) { TDatabase dberp = TContextDatabases.GetDatabase("DBERP"); XLBJDUtils.AfterDeleteBJD(dberp, sql, GetField("XLXSBJD_BJDID").ToString().Trim()); return base.Deleted(sql); } public override bool Deleting(TSQL sql) { _XLBJDMX_BDOBill.BJDID = GetField("XLXSBJD_BJDID").ToString().Trim(); return base.Deleting(sql); } public override void WFBeforeAction(TWorkflow Sender, TWFAction Action, ref bool CanAction) { base.WFBeforeAction(Sender, Action, ref CanAction); } public override void WFAfterAction(GThinking.N_WORKFLOW.TWorkflow Sender, TWFAction Action, bool ActionIsDone) { base.WFAfterAction(Sender, Action, ActionIsDone); if (!ActionIsDone) return; string sWPID = ""; string sBJSQDH = ""; TSQL SQL = new TSQL(Sender.dbe); SQL.Clear(); SQL.Add("select XLXSBJD_WPID,XLXSBJD_BJSQDH,XLXSBJD_BJJSJD,XLXSBJD_ZB from XLXSBJD where XLXSBJD_BJDID=:pBJDID"); SQL.ParamByName("pBJDID").Value = XLXSBJD_BJDID; DataSet ds = Sender.dbe.OpenDataSet(SQL); if (ds.Tables[0].Rows.Count > 0) { sWPID = ds.Tables[0].Rows[0]["XLXSBJD_WPID"].ToString().Trim(); sBJSQDH = ds.Tables[0].Rows[0]["XLXSBJD_BJSQDH"].ToString().Trim(); } CMISproSession tSession = getSession(); string sZDQRWPID = XLBJDUtils.GetXLXSBJPZXX(100860068).XLXSBJPZ_ZDQRWPID; if (!sZDQRWPID.Equals("")) { if (Action == TWFAction.wfaSubmit) { if (sZDQRWPID.Contains(sWPID)) { SQL.Clear(); SQL.Add("update XLXSBJD set XLXSBJD_ZDQRRGH=:pZDQRRGH ,XLXSBJD_ZDQRSJ=:pZDQRSJ WHERE XLXSBJD_BJDID=:pBJDID"); SQL.ParamByName("pZDQRRGH").Value = tSession.UserId; SQL.ParamByName("pZDQRSJ").Value = CMISproConvert.ConvertTime(DateTime.Now); SQL.ParamByName("pBJDID").Value = XLXSBJD_BJDID; Sender.dbe.ExecSQL(SQL); } } } if (!sBJSQDH.Trim().Equals("") && XLBJDInfo.CheckXSYBJSQ_SS()) { string sBJJSJD = ds.Tables[0].Rows[0]["XLXSBJD_BJJSJD"].ToString().Trim(); string sWPNAME = Sender.GetWPName(Sender.WFID, sWPID); string sJSJD = tSession.UserName + " " + Sender.WAend.ToString().Trim() + " " + sWPNAME + " " + Sender.GetWFActionName(Action); if (!sBJJSJD.Equals("")) sBJJSJD += "\r\n"; sBJJSJD += sJSJD; SQL.Clear(); SQL.Add(" update XLXSBJD set XLXSBJD_BJJSJD = :pJSJD where XLXSBJD_BJDID = :pBJDID "); SQL.ParamByName("pJSJD").Value = sBJJSJD; SQL.ParamByName("pBJDID").Value = XLXSBJD_BJDID; Sender.dbe.ExecSQL(SQL); } SQL.Clear(); SQL.Add(" update XLXSBJD"); SQL.Add(" set XLXSBJD_WFID = :XLXSBJD_WFID, "); SQL.Add(" XLXSBJD_WPID = :XLXSBJD_WPID, "); SQL.Add(" XLXSBJD_WFAWAITER = :XLXSBJD_WFAWAITER, "); SQL.Add(" XLXSBJD_WFHANDLER = :XLXSBJD_WFHANDLER, "); SQL.Add(" XLXSBJD_WFINST = :XLXSBJD_WFINST, "); SQL.Add(" XLXSBJD_ACTNAME = :XLXSBJD_ACTNAME "); SQL.Add(" where XLXSBJD_BJDID = :XLXSBJD_BJDID "); SQL.ParamByName("XLXSBJD_WFID").Value = Sender.WFID; SQL.ParamByName("XLXSBJD_WFINST").Value = Sender.WFInst; SQL.ParamByName("XLXSBJD_WPID").Value = Sender.WPID; SQL.ParamByName("XLXSBJD_WFAWAITER").Value = Sender.Awaiter; SQL.ParamByName("XLXSBJD_WFHANDLER").Value = Sender.Handler; SQL.ParamByName("XLXSBJD_ACTNAME").Value = Sender.GetWFActionName(Action); SQL.ParamByName("XLXSBJD_BJDID").Value = XLXSBJD_BJDID; Sender.dbe.ExecSQL(SQL); string sCurZT = TWorkflow.Utils.WFGetBZSWID(Sender.WFID, Sender.WPID); if (sCurZT == "ZZZZ") { string sPSDH = ""; bool bINS = false; InsBJPS(SQL, Sender.dbe, Sender, Action, XLXSBJD_BJDID, tSession, "100860000", ref sPSDH, ref bINS); if (bINS) { DispatchtoZZZZ(sPSDH, tSession); } } if (!sZDQRWPID.Equals("")) { if (Action == TWFAction.wfaSubmit) { if (sZDQRWPID.Contains(Sender.WPID)) { SQL.Clear(); SQL.Add("update XLXSBJD set XLXSBJD_ZDZDLX=:pZDZDLX WHERE XLXSBJD_BJDID=:pBJDID"); SQL.ParamByName("pZDZDLX").Value = XLBJD_BDOBill.getZDZDLX(XLXSBJD_BJDID); SQL.ParamByName("pBJDID").Value = XLXSBJD_BJDID; Sender.dbe.ExecSQL(SQL); } } } if (sCurZT == "ZZZZ" && !sBJSQDH.Trim().Equals("") && XLBJDInfo.CheckXSYBJSQ_SS()) { string sZB = ds.Tables[0].Rows[0]["XLXSBJD_ZB"].ToString().Trim(); if (sZB.Equals("Y")) DispatchXLBJSQ(sBJSQDH, "ZZZZ", tSession); else DispatchXLBJSQ(sBJSQDH, "0060", tSession); } } private static CMISproSession getSession() { return CMISproSessionManager.GetCurrentSession(); } public override bool CanEdit() { if (!_fCanE) return false; return base.CanEdit(); } public override void WFOnGetParamName(ref System.Collections.Generic.List ParamList) { base.WFOnGetParamName(ref ParamList); ParamList.Add("自动撞单"); } public override void WFOnGetParam(TWorkflow Sender, string ParamName, ref string Value, ref bool Succeess) { base.WFOnGetParam(Sender, ParamName, ref Value, ref Succeess); if (ParamName == "自动撞单") { if (getZDZDLX(XLXSBJD_BJDID).Equals("")) { Value = "N"; } else { Value = "Y"; } Succeess = true; } } public override bool CanSubmit() { string sBJDID = GetField("XLXSBJD_BJDID").ToString().Trim(); string sWarningMsg = ""; if (fCanSubmit.Equals("Y") || fCanSubmit.Equals("5")) { JudgeDifBJCP(sBJDID, sBJU003, ref sWarningMsg, fCanSubmit); if (!sWarningMsg.Equals("")) { WarningMsg = "显示序号为【" + sWarningMsg + "】的相同报价产品的报价不同，不允许提交！"; return false; } } JudgeDifBJZJE(sBJDID, ref sWarningMsg); if (!sWarningMsg.Equals("")) { WarningMsg = sWarningMsg; return false; } return base.CanSubmit(); } public static void InsBJPS(TSQL SQL, TDatabase dberp, GThinking.N_WORKFLOW.TWorkflow Sender, TWFAction Action, string sBJDID, CMISproSession tSession, string sMDID, ref string sPSDH, ref bool bINS) { if (!TWorkflow.Utils.QYWFByWFVID("SQXM_XMBJ")) { bINS = false; return; } SQL.Clear(); SQL.Add("SELECT XLXSBJD_BJDID,XLXSBJD_BJFLID,XLXSBJD_XMMC,XLXSBJD_BJRQ,XLXSBJD_ZJE FROM XLXSBJD "); SQL.Add(" where 1=1 and XLXSBJD_BJDID = :pXLXSBJD_BJDID "); SQL.ParamByName("pXLXSBJD_BJDID").Value = sBJDID; DataSet ds = dberp.OpenDataSet(SQL); if (ds.Tables[0].Rows.Count > 0) { if (!ds.Tables[0].Rows[0]["XLXSBJD_XMMC"].ToString().Trim().Equals("") && IsYXXM(sBJDID, ds.Tables[0].Rows[0]["XLXSBJD_BJFLID"].ToString().Trim(), sMDID)) { SQL.Clear(); SQL.Add("select "); SQL.Add(" BJPS_PSDH,BJPS_SQRRYID,BJPS_SQRGH,BJPS_SQRRYMC,"); SQL.Add(" BJPS_SQRQ,BJPS_XMID,BJPS_DWBJ,BJPS_NCJJ,BJPS_PSSM, BJPS_BJDID,"); SQL.Add(" BJPS_WHR,BJPS_WHRID,BJPS_WHSJ"); SQL.Add(" from BJPS "); SQL.Add(" where 1=1 and BJPS_BJDID = :pBJPS_BJDID "); SQL.ParamByName("pBJPS_BJDID").Value = sBJDID; DataSet dsBJPS = dberp.OpenDataSet(SQL); if (dsBJPS.Tables[0].Rows.Count > 0) { sPSDH = dsBJPS.Tables[0].Rows[0]["BJPS_PSDH"].ToString().Trim(); SQL.Clear(); SQL.Add(" update BJPS set "); SQL.Add(" BJPS_SQRRYID=:BJPS_SQRRYID,BJPS_SQRGH=:BJPS_SQRGH,BJPS_SQRRYMC=:BJPS_SQRRYMC,"); SQL.Add(" BJPS_SQRQ=:BJPS_SQRQ,BJPS_XMID=:BJPS_XMID,BJPS_DWBJ=:BJPS_DWBJ,BJPS_NCJJ=:BJPS_NCJJ,BJPS_PSSM=:BJPS_PSSM, BJPS_BJDID=:BJPS_BJDID,"); SQL.Add(" BJPS_WHR=:BJPS_WHR,BJPS_WHRID=:BJPS_WHRID,BJPS_WHSJ=:BJPS_WHSJ"); SQL.Add(" where 1=1 and BJPS_PSDH =:BJPS_PSDH"); SQL.ParamByName("BJPS_PSDH").Value = sPSDH; SQL.ParamByName("BJPS_SQRRYID").Value = TRYXX.GetRYXXByGH(tSession.UserId).RYID; SQL.ParamByName("BJPS_SQRGH").Value = tSession.UserId; SQL.ParamByName("BJPS_SQRRYMC").Value = tSession.UserName; SQL.ParamByName("BJPS_SQRQ").Value = ds.Tables[0].Rows[0]["XLXSBJD_BJRQ"].ToString().Trim(); SQL.ParamByName("BJPS_XMID").Value = GetYXXM(ds.Tables[0].Rows[0]["XLXSBJD_XMMC"].ToString().Trim()); SQL.ParamByName("BJPS_DWBJ").Value = ds.Tables[0].Rows[0]["XLXSBJD_ZJE"].ToString().Trim(); SQL.ParamByName("BJPS_NCJJ").Value = GetZDXJ(sBJDID); SQL.ParamByName("BJPS_PSSM").Value = "【" + sBJDID + "】报价单自动生成"; SQL.ParamByName("BJPS_BJDID").Value = sBJDID; SQL.ParamByName("BJPS_WHR").Value = tSession.UserName; SQL.ParamByName("BJPS_WHRID").Value = tSession.UserId; SQL.ParamByName("BJPS_WHSJ").Value = DateTime.Now; dberp.ExecSQL(SQL); bINS = false; } else { sPSDH = GetPSDH(); SQL.Clear(); SQL.Add(" insert into BJPS("); SQL.Add(" BJPS_PSDH,BJPS_SQRRYID,BJPS_SQRGH,BJPS_SQRRYMC,"); SQL.Add(" BJPS_SQRQ,BJPS_XMID,BJPS_DWBJ,BJPS_NCJJ,BJPS_PSSM, BJPS_BJDID,"); SQL.Add(" BJPS_WHR,BJPS_WHRID,BJPS_WHSJ"); SQL.Add(" )"); SQL.Add(" values ("); SQL.Add(" :BJPS_PSDH,:BJPS_SQRRYID,:BJPS_SQRGH,:BJPS_SQRRYMC,"); SQL.Add(" :BJPS_SQRQ,:BJPS_XMID,:BJPS_DWBJ,:BJPS_NCJJ,:BJPS_PSSM, :BJPS_BJDID,"); SQL.Add(" :BJPS_WHR,:BJPS_WHRID,:BJPS_WHSJ"); SQL.Add(" ) "); SQL.ParamByName("BJPS_PSDH").Value = sPSDH; SQL.ParamByName("BJPS_SQRRYID").Value = TRYXX.GetRYXXByGH(tSession.UserId).RYID; SQL.ParamByName("BJPS_SQRGH").Value = tSession.UserId; SQL.ParamByName("BJPS_SQRRYMC").Value = tSession.UserName; SQL.ParamByName("BJPS_SQRQ").Value = ds.Tables[0].Rows[0]["XLXSBJD_BJRQ"].ToString().Trim(); SQL.ParamByName("BJPS_XMID").Value = GetYXXM(ds.Tables[0].Rows[0]["XLXSBJD_XMMC"].ToString().Trim()); SQL.ParamByName("BJPS_DWBJ").Value = ds.Tables[0].Rows[0]["XLXSBJD_ZJE"].ToString().Trim(); SQL.ParamByName("BJPS_NCJJ").Value = GetZDXJ(sBJDID); SQL.ParamByName("BJPS_PSSM").Value = "【" + sBJDID + "】报价单自动生成"; SQL.ParamByName("BJPS_BJDID").Value = sBJDID; SQL.ParamByName("BJPS_WHR").Value = tSession.UserName; SQL.ParamByName("BJPS_WHRID").Value = tSession.UserId; SQL.ParamByName("BJPS_WHSJ").Value = DateTime.Now; dberp.ExecSQL(SQL); //创建工作流//N_SQXM8-100958003|售前项目报价 TWorkflow myWF = new TWorkflow(tSession, new System.Web.Caching.Cache()); myWF.UMID = 100958003; myWF.Enabled = true; myWF.CurUserID = tSession.UserId; myWF.WFNewInst(myWF.GetWFID("SQXM_XMBJ"), tSession.UserId); SQL.Clear(); SQL.Add(" update BJPS set BJPS_WFID=:pWFID, BJPS_WPID=:pWPID, BJPS_WFAWAITER=:pWFAWAITER, BJPS_WFHANDLER=:pWFHANDLER, BJPS_WFINST=:pWFINST, BJPS_ACTNAME=:pACTNAME "); SQL.Add(" where BJPS_PSDH=:pBJPS_PSDH "); SQL.ParamByName("pWFID").Value = myWF.WFID; SQL.ParamByName("pWPID").Value = myWF.WPID; SQL.ParamByName("pWFAWAITER").Value = myWF.Awaiter; SQL.ParamByName("pWFHANDLER").Value = myWF.Handler; SQL.ParamByName("pWFINST").Value = myWF.WFInst; SQL.ParamByName("pACTNAME").Value = myWF.GetWFActionName(TWFAction.wfaNewInst); SQL.ParamByName("pBJPS_PSDH").Value = sPSDH; dberp.ExecSQL(SQL); bINS = true; } } else { bINS = false; } } else { bINS = false; } } public static string GetPSDH() { return CMISproDataBase.GetYWBHByNY("DBERP", "BJPS", "BJPS_PSDH", 4); } public static double GetZDXJ(string sBJDID) { double fZDXJ = 0; TDatabase dberp = TContextDatabases.GetDatabase("DBERP"); TSQL SQL = new TSQL(dberp); SQL.Clear(); SQL.Add("select sum(XLXSBJDMX_ZDXJ) AS ZDXJ from XLXSBJDMX where XLXSBJDMX_BJDID=:pBJDID "); SQL.ParamByName("pBJDID").Value = sBJDID; DataSet ds = dberp.OpenDataSet(SQL); if (ds.Tables[0].Rows.Count > 0) { fZDXJ = CMISproConvert.StrToFloat(ds.Tables[0].Rows[0]["ZDXJ"].ToString().Trim()); } return fZDXJ; } public static string GetYXXM(string sYXXMMC) { string sXMID = ""; TDatabase dberp = TContextDatabases.GetDatabase("DBERP"); TSQL SQL = new TSQL(dberp); SQL.Clear(); SQL.Add("select YXXM_XMID from YXXM where YXXM_MC=:pMC "); SQL.ParamByName("pMC").Value = sYXXMMC; DataSet ds = dberp.OpenDataSet(SQL); if (ds.Tables[0].Rows.Count > 0) { sXMID = ds.Tables[0].Rows[0]["YXXM_XMID"].ToString().Trim(); } return sXMID; } public static bool IsYXXM(string sBJDID, string sBJFLID, string sMDID) { XLXSBJPZXX pzxx = XLBJDUtils.GetXLXSBJPZXX(CMISproConvert.StrToInt(sMDID)); if (pzxx.XLXSBJPZ_XMJSLY == "YXXM") return true; return false; } public static void DispatchtoZZZZ(string sPSDH, CMISproSession tSession) { TDatabase dberp = TContextDatabases.GetDatabase("DBERP"); TSQL SQL = new TSQL(dberp); SQL.Add("select BJPS_WFID,BJPS_WPID,BJPS_WFINST from BJPS where BJPS_PSDH=:BJPS_PSDH"); SQL.ParamByName("BJPS_PSDH").Value = sPSDH; DataSet dsRecord = dberp.OpenDataSet(SQL); if (dsRecord.Tables[0].Rows.Count > 0) { TWorkflow myWF = new TWorkflow(tSession, new System.Web.Caching.Cache()); string sWFID = dsRecord.Tables[0].Rows[0]["BJPS_WFID"].ToString().Trim(); string sWPID = "ZZZZ"; //指定要调度到的事务，不允许为空 double dWFINST = CMISproConvert.StrToFloat(dsRecord.Tables[0].Rows[0]["BJPS_WFINST"].ToString().Trim()); string sTitle = ""; //指定调度后待办事务主题，如果没有特别设置，可以为空或者取工作流名称awf.GetWFName(sWFID) ；title中还同时包含了调度意见，格式：主题__!__调度意见。（__!__共5个字符） string sUser = tSession.UserId; string sAwaiter = TWorkflow.Utils.WfGetAWAITER(sWFID, dWFINST); //指定调度后的待处理人，不允许为空，格式为”,***,***,” string sHandler = TWorkflow.Utils.WfGetHandler(sWFID, dWFINST).Trim(); //指定调度后的已处理人，应该是根据WFID,WFINST获取工对应的_Handle string sDispatcher = myWF.WFGetDispatcher(sWFID); //获取流程调度员返回结果为工号，或者工号列表，如0001,0002,0003，需要判断返回是否为空 TWorkflow smyWF = new TWorkflow(tSession, new System.Web.Caching.Cache()); if (sDispatcher != "") smyWF.WFInfo(sWFID, dWFINST, sDispatcher); //sUser是指定调度执行人，不允许为空，应该取流程调度员之一sDispatcher，如果调度员为空，可以由业务模块考虑是否以当前用户调度或者中断操作 else smyWF.WFInfo(sWFID, dWFINST, sUser); if (sHandler.Equals("")) { sHandler = "," + sDispatcher + ","; } else { if (!sHandler.Contains("," + sDispatcher + ",")) { sHandler = sHandler + sDispatcher + ","; } } smyWF.CurUserID = sUser; string sState = "9"; //如果调度到ZZZZ环节，sState = "9" smyWF.WFDispatch(sWFID, dWFINST, sUser, sState, sTitle, sWPID, "", sAwaiter, sHandler); TSQL WFSQL = new TSQL(dberp); WFSQL.Clear(); WFSQL.Add("update BJPS set BJPS_WFID=:pWFID, BJPS_WFINST=:pWFINST, BJPS_WPID=:pWPID, "); WFSQL.Add(" BJPS_ACTNAME=:pACTNAME, BJPS_WFAWAITER=:pWFAWAITER, BJPS_WFHANDLER=:pWFHANDLER "); WFSQL.Add(" where BJPS_PSDH=:pBJPS_PSDH "); WFSQL.ParamByName("pWFID").Value = smyWF.WFID; WFSQL.ParamByName("pWFINST").Value = smyWF.WFInst; WFSQL.ParamByName("pWPID").Value = smyWF.WPID; WFSQL.ParamByName("pACTNAME").Value = smyWF.GetWFActionName(TWFAction.wfaDispatch); WFSQL.ParamByName("pWFAWAITER").Value = ""; WFSQL.ParamByName("pWFHANDLER").Value = sHandler; WFSQL.ParamByName("pBJPS_PSDH").Value = sPSDH; dberp.ExecSQL(WFSQL); } } public static void DispatchXLBJSQ(string sBJSQDH,string sNextWPID, CMISproSession tSession) { TDatabase dberp = TContextDatabases.GetDatabase("DBERP"); TSQL SQL = new TSQL(dberp); SQL.Add(" select XLBJSQ_WFID,XLBJSQ_WFINST from XLBJSQ where XLBJSQ_SQDH = :pSQDH "); SQL.ParamByName("pSQDH").Value = sBJSQDH; DataSet dsRecord = dberp.OpenDataSet(SQL); if (dsRecord.Tables[0].Rows.Count > 0) { TWorkflow myWF = new TWorkflow(tSession, new System.Web.Caching.Cache()); string sWFID = dsRecord.Tables[0].Rows[0]["XLBJSQ_WFID"].ToString().Trim(); string sWPID = sNextWPID; double dWFINST = CMISproConvert.StrToFloat(dsRecord.Tables[0].Rows[0]["XLBJSQ_WFINST"].ToString().Trim()); string sTitle = ""; //指定调度后待办事务主题，如果没有特别设置，可以为空或者取工作流名称awf.GetWFName(sWFID) ；title中还同时包含了调度意见，格式：主题__!__调度意见。（__!__共5个字符） string sOption = "报价单提交结束，自动调度"; string sPbegin = AppRuntime.ServerNow.ToString(); string sPend = AppRuntime.ServerNow.AddDays(1).ToString(); string sUser = tSession.UserId; string sAwaiter = TWorkflow.Utils.WfGetAWAITER(sWFID, dWFINST); //指定调度后的待处理人，不允许为空，格式为”,***,***,” string sHandler = TWorkflow.Utils.WfGetHandler(sWFID, dWFINST).Trim(); //指定调度后的已处理人，应该是根据WFID,WFINST获取工对应的_Handle string sDispatcher = myWF.WFGetDispatcher(sWFID); //获取流程调度员返回结果为工号，或者工号列表，如0001,0002,0003，需要判断返回是否为空 if (sDispatcher != "") myWF.WFInfo(sWFID, dWFINST, sDispatcher); //sUser是指定调度执行人，不允许为空，应该取流程调度员之一sDispatcher，如果调度员为空，可以由业务模块考虑是否以当前用户调度或者中断操作 else myWF.WFInfo(sWFID, dWFINST, sUser); if (sHandler.Equals("")) { sHandler = "," + sDispatcher + ","; } else { if (!sHandler.Contains("," + sDispatcher + ",")) { sHandler = sHandler + sDispatcher + ","; } } myWF.CurUserID = sUser; string sState = "0"; if (sWPID.Equals("ZZZZ")) { sAwaiter = ""; sState = "9"; } //如果调度到ZZZZ环节，sState = "9" myWF.WFDispatch(sWFID, dWFINST, sUser, sState, sTitle, sWPID, "", sAwaiter, sHandler, sPbegin, sPend, sOption); TSQL WFSQL = new TSQL(dberp); WFSQL.Clear(); WFSQL.Add("update XLBJSQ set XLBJSQ_WFID=:pWFID, XLBJSQ_WFINST=:pWFINST, XLBJSQ_WPID=:pWPID, "); WFSQL.Add(" XLBJSQ_ACTNAME=:pACTNAME, XLBJSQ_WFAWAITER=:pWFAWAITER, XLBJSQ_WFHANDLER=:pWFHANDLER "); WFSQL.Add(" where XLBJSQ_SQDH=:pXLBJSQ_SQDH "); WFSQL.ParamByName("pWFID").Value = myWF.WFID; WFSQL.ParamByName("pWFINST").Value = myWF.WFInst; WFSQL.ParamByName("pWPID").Value = myWF.WPID; WFSQL.ParamByName("pACTNAME").Value = myWF.GetWFActionName(TWFAction.wfaDispatch); WFSQL.ParamByName("pWFAWAITER").Value = ""; WFSQL.ParamByName("pWFHANDLER").Value = sHandler; WFSQL.ParamByName("pXLBJSQ_SQDH").Value = sBJSQDH; dberp.ExecSQL(WFSQL); } } //撞单类型代码->名称 private static readonly Dictionary dicZDLX = new Dictionary(); static XLBJD_BDOBill() { dicZDLX.Add("1", "客户+销售员相撞"); dicZDLX.Add("2", "客户名称重复"); dicZDLX.Add("3", "项目名称重复"); dicZDLX.Add("4", "项目名称词组重复"); dicZDLX.Add("5", "产品重复"); dicZDLX.Add("6", "产品+数量重复"); dicZDLX.Add("G", "规格+数量重复"); dicZDLX.Add("7", "仅型号规格重复"); dicZDLX.Add("8", "备案项目客户名称重复"); dicZDLX.Add("9", "备案项目名称重复"); dicZDLX.Add("A", "备案项目名称+销售员重复"); dicZDLX.Add("B", "项目与客户名称相撞"); dicZDLX.Add("C", "客户联系人重复"); dicZDLX.Add("D", "客户电话重复"); dicZDLX.Add("E", "按产品个数区间+分段重复率查产品重复"); dicZDLX.Add("F", "客户名称、项目名称重复"); } public static string getZDZDLX(string sBJDID) { if (XLBJDUtils.GetXLXSBJPZXX(100860068).XLXSBJPZ_ZDZDLX.Equals("")) return ""; string sZDLXList = string.Empty; string sZDLX=XLBJDUtils.GetXLXSBJPZXX(100860068).XLXSBJPZ_ZDZDLX.Replace("A","10").Replace("B","11").Replace("C","12").Replace("D","13").Replace("E","14").Replace("F","15").Replace("G","16"); int iYF=CMISproConvert.StrToInt(XLBJDUtils.GetXLXSBJPZXX(100860068).XLXSBJPZ_ZDZDYF,0); if(iYF==0) iYF=6; string sSQL=GetZDSQL(sZDLX,sBJDID,iYF); TDatabase dberp = TContextDatabases.GetDatabase("DBERP"); TSQL sql = new TSQL(dberp); sql.Clear(); sql.Add(sSQL); sql.ParamByName("pBJDID").Value = sBJDID; DataSet ds=dberp.OpenDataSet(sql); Dictionary dicYYZDLX = new Dictionary(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { if(!ds.Tables[0].Rows[i][0].ToString().Trim().TrimEnd(',').Equals("")) { string []sZDLXNum = ds.Tables[0].Rows[i][0].ToString().Trim().TrimEnd(',').Split(','); for (int j = 0; j < sZDLXNum.Length; j++) { string sZDMC; if (!dicYYZDLX.ContainsKey(sZDLXNum[j]) && dicZDLX.TryGetValue(sZDLXNum[j], out sZDMC)) { dicYYZDLX.Add(sZDLXNum[j], sZDMC); sZDLXList += sZDMC + ";"; } } } if (dicYYZDLX.Count == 16) break; } sZDLXList = XLBJDUtils.SubStringFunc(sZDLXList.TrimEnd(';'),250); return sZDLXList; } private static string GetZDSQL(string sZDLX, string sBJDID,int iYF) { string sZDYY = sZDLX + ","; string sXMID = ""; string sKH = ""; string sKHLXR = ""; string sLXDH = ""; string sXM = ""; string sTXY = ""; bool bKHXSTZD = false; DateTime dBJRQ = CMISproConvert.StrToDateTime("1900-01-01"); TDatabase dberp = TContextDatabases.GetDatabase("DBERP"); TSQL sql = new TSQL(dberp); sql.Clear(); sql.Add("select XLXSBJD_TXY,XLXSBJD_XMMC,XLXSBJD_XMID,XLXSBJD_BJRQ,XLXSBJD_KH,XLXSBJD_KHLXR,XLXSBJD_LXDH,KH_TXY,KH_KHID "); sql.Add("from XLXSBJD left join KH on KH_MC=XLXSBJD_KH "); sql.Add("where XLXSBJD_BJDID=:pBJDID "); sql.Add(" and isnull(XLXSBJD_YWLX,' ') = ' ' "); sql.ParamByName("pBJDID").Value = sBJDID; DataSet ds = dberp.OpenDataSet(sql); if (ds.Tables[0].Rows.Count > 0) { sTXY = ds.Tables[0].Rows[0]["XLXSBJD_TXY"].ToString().Trim(); sKH = ds.Tables[0].Rows[0]["XLXSBJD_KH"].ToString().Trim(); sKHLXR = ds.Tables[0].Rows[0]["XLXSBJD_KHLXR"].ToString().Trim(); sLXDH = ds.Tables[0].Rows[0]["XLXSBJD_LXDH"].ToString().Trim(); sXM = ds.Tables[0].Rows[0]["XLXSBJD_XMMC"].ToString().Trim(); sXMID = ds.Tables[0].Rows[0]["XLXSBJD_XMID"].ToString().Trim(); string sZDYYLX = sZDLX + ","; if ((!sTXY.Equals("")) && (!sTXY.Equals(ds.Tables[0].Rows[0]["KH_TXY"].ToString().Trim())) && (!ds.Tables[0].Rows[0]["KH_KHID"].ToString().Trim().Equals("")) && (!ds.Tables[0].Rows[0]["KH_TXY"].ToString().Trim().Equals("")) && (sZDLX.Equals("") || sZDYYLX.Contains("1,"))) bKHXSTZD = true; dBJRQ = CMISproConvert.StrToDateTime(ds.Tables[0].Rows[0]["XLXSBJD_BJRQ"].ToString().Trim()); } XLXSBJPZXX pzxx = XLBJDUtils.GetXLXSBJPZXX(100860068); double dMXTMCBL = CMISproConvert.StrToFloat(pzxx.XLXSBJPZ_MXTMCBL) / 100; double dMXFDS = CMISproConvert.StrToFloat(pzxx.XLXSBJPZ_MXFDS); double dXYFDSCFBL = CMISproConvert.StrToFloat(pzxx.XLXSBJPZ_XYFDSCFBL); double dDYFDSCFBL = CMISproConvert.StrToFloat(pzxx.XLXSBJPZ_DYFDSCFBL); double dCPSLCFBL = CMISproConvert.StrToFloat(pzxx.XLXSBJPZ_CPSLCFBL); string sCFCPBQFBZ = pzxx.XLXSBJPZ_CFCPBQFBZ; string sBJY = pzxx.XLXSBJPZ_BJY; bool bBJY1 = sBJY.Contains("1") && !sKH.Equals("") && !sTXY.Equals(""); bool bBJY2 = sBJY.Contains("2") && !sTXY.Equals(""); bool bZD1 = bKHXSTZD && !sKH.Equals("") && ("," + sZDLX + ",").Contains(",1,"); bool bZD2 = (sZDLX.Equals("") || ("," + sZDLX + ",").Contains(",2,")) && !sKH.Equals("") && ("," + sZDYY + ",").Contains(",2,"); bool bZD3 = (sZDLX.Equals("") || ("," + sZDLX + ",").Contains(",3,")) && !sXM.Equals("") && ("," + sZDYY + ",").Contains(",3,"); bool bZD4 = (sZDLX.Equals("") || ("," + sZDLX + ",").Contains(",4,")) && ("," + sZDYY + ",").Contains(",4,"); bool bZD5 = (sZDLX.Equals("") || ("," + sZDLX + ",").Contains(",5,")) && ("," + sZDYY + ",").Contains(",5,"); bool bZD6 = (sZDLX.Equals("") || ("," + sZDLX + ",").Contains(",6,")) && ("," + sZDYY + ",").Contains(",6,"); bool bZD16 = (sZDLX.Equals("") || ("," + sZDLX + ",").Contains(",16,")) && ("," + sZDYY + ",").Contains(",16,"); bool bZD7 = (sZDLX.Equals("") || ("," + sZDLX + ",").Contains(",7,")) && ("," + sZDYY + ",").Contains(",7,"); bool bZD8 = (sZDLX.Equals("") || ("," + sZDLX + ",").Contains(",8,")) && !sKH.Equals("") && ("," + sZDYY + ",").Contains(",8,"); bool bZD9 = (sZDLX.Equals("") || ("," + sZDLX + ",").Contains(",9,")) && !sXMID.Equals("") && ("," + sZDYY + ",").Contains(",9,"); bool bZD10 = (sZDLX.Equals("") || ("," + sZDLX + ",").Contains(",10,")) && !sTXY.Equals("") && ("," + sZDYY + ",").Contains(",10,"); bool bZD11 = (sZDLX.Equals("") || ("," + sZDLX + ",").Contains(",11,")) && !sXM.Equals("") && ("," + sZDYY + ",").Contains(",11,"); bool bZD12 = (sZDLX.Equals("") || ("," + sZDLX + ",").Contains(",12,")) && !sKHLXR.Equals("") && ("," + sZDYY + ",").Contains(",12,"); bool bZD13 = (sZDLX.Equals("") || ("," + sZDLX + ",").Contains(",13,")) && !sLXDH.Equals("") && ("," + sZDYY + ",").Contains(",13,"); bool bZD14 = (sZDLX.Equals("") || ("," + sZDLX + ",").Contains(",14,")) && ("," + sZDYY + ",").Contains(",14,"); bool bZD15 = (sZDLX.Equals("") || ("," + sZDLX + ",").Contains(",15,")) && ("," + sZDYY + ",").Contains(",15,") && !sKH.Equals("") && !sXM.Equals(""); string sTSC = ""; if (!string.IsNullOrEmpty(pzxx.XLXSBJPZ_XMMCTSCZ)) sTSC = CMISproDataBase.GetWhereEqual("XLXSBJZDCZ_XMCZ", pzxx.XLXSBJPZ_XMMCTSCZ); StringBuilder sSQL = new StringBuilder(); sSQL.AppendLine("select "); if (bZD1) sSQL.AppendLine(" case when (XLXSBJD_KH='" + sKH + "' and XLXSBJD_TXY='" + sTXY + "') then '1,' else '' end || "); if (bZD2) sSQL.AppendLine(" case when XLXSBJD_KH='" + sKH + "' then '2,' else '' end || "); if (bZD3) sSQL.AppendLine(" case when (XLXSBJD_XMMC='" + sXM + "' and not exists(select 1 from XLXSBJZDBJYXX where XLXSBJZDBJYXX_XXLX='XM' and XLXSBJZDBJYXX_XXNR=XLXSBJD_XMMC) ) then '3,' else '' end || "); if (bZD4) sSQL.AppendLine(string.Format(" case when A.CZXTGS >={0} then '4,' else '' end || ", pzxx.XLXSBJPZ_XMMCCZCFGS)); if (bZD5) { sSQL.AppendLine(string.Format(" case when sameCPBJD.sameBJCPS>={0} ", pzxx.XLXSBJPZ_CPCFGS)); sSQL.AppendLine(" and GE((case when MX.SL>MXCount.MXCounts then round(100.0*sameCPBJD.sameBJCPS/MX.SL,2) "); sSQL.AppendLine(string.Format(" else round(100.0*sameCPBJD.sameBJCPS/MXCount.MXCounts,2) end),{0}) then '5,' else '' end || ", pzxx.XLXSBJPZ_CPCFBL)); } if (bZD14) { sSQL.AppendLine(string.Format(" case when MX.SL>MXCount.MXCounts*(1- {0}) AND MX.SLMXCount.MXCounts then round(100.0*sameCPBJD.sameBJCPS/MX.SL,2) "); sSQL.AppendLine(string.Format(" else round(100.0*sameCPBJD.sameBJCPS/MXCount.MXCounts,2) end),{0}) AND MXCount.MXCounts <= {1}) ", pzxx.XLXSBJPZ_XYFDSCFBL, pzxx.XLXSBJPZ_MXFDS)); sSQL.AppendLine(" OR (GE((case when MX.SL>MXCount.MXCounts then round(100.0*sameCPBJD.sameBJCPS/MX.SL,2) "); sSQL.AppendLine(string.Format(" else round(100.0*sameCPBJD.sameBJCPS/MXCount.MXCounts,2) end),{0}) AND MXCount.MXCounts > {1})) ", pzxx.XLXSBJPZ_DYFDSCFBL, pzxx.XLXSBJPZ_MXFDS)); sSQL.AppendLine(" then 'E,' else '' end || "); } if (bZD6) { sSQL.AppendLine(string.Format(" case when sameCPSLBJD.sameBJCPSLS>={0} ", pzxx.XLXSBJPZ_CPSLCFGS)); sSQL.AppendLine(" and GE((case when MX.SL>MXCount.MXCounts then round(100.0*sameCPSLBJD.sameBJCPSLS/MX.SL,2) "); sSQL.AppendLine(string.Format(" else round(100.0*sameCPSLBJD.sameBJCPSLS/MXCount.MXCounts,2) end),{0}) ", pzxx.XLXSBJPZ_CPSLCFBL)); sSQL.AppendLine(" then '6,' else '' end || "); } if (bZD16) { sSQL.AppendLine(string.Format(" case when sameGGSLBJD.sameGGSLs>={0} ", ZDFXPZHelper.GetGGSLCFGS())); sSQL.AppendLine(" and GE((case when MX.SL>MXCount.MXCounts then round(100.0*sameGGSLBJD.sameGGSLs/MX.SL,2) "); sSQL.AppendLine(string.Format(" else round(100.0*sameGGSLBJD.sameGGSLs/MXCount.MXCounts,2) end),{0}) ", ZDFXPZHelper.GetGGSLCFBL())); sSQL.AppendLine(" then 'G,' else '' end || "); } if (bZD7) { sSQL.AppendLine(" case when GE((case when MX.SL>MXCount.MXCounts then round(100.0*sameXHGGBJD.sameXHGGS/MX.SL,2) "); sSQL.AppendLine(string.Format(" else round(100.0*sameXHGGBJD.sameXHGGS/MXCount.MXCounts,2) end),{0}) then '7,' else '' end || ", pzxx.XLXSBJPZ_XHGGCFBL)); } if (bZD8) sSQL.AppendLine(" case when (K1MC='" + sKH + "' or K2MC='" + sKH + "' or K3MC='" + sKH + "' or K4MC='" + sKH + "') and isNull(XM.XMID,' ')=XLXSBJD_XMID then '8,' else '' end || "); if (bZD9) sSQL.AppendLine(string.Format(" case when (isNull(XM.XMID,' ')=XLXSBJD_XMID and XLXSBJD_XMID='{0}') then '9,' else '' end || ", sXMID)); if (bZD10) sSQL.AppendLine(string.Format(" case when (isNull(XM.XMID,' ')=XLXSBJD_XMID and XLXSBJD_XMID='{0}' and YXXM_TXY='" + sTXY + "') then 'A,' else '' end || ", sXMID)); if (bZD11) { sSQL.AppendLine(" case when ((XLXSBJD_KH like '%" + sXM + "%' or ('" + sXM + "' like '%' || rtrim(isnull(XLXSBJD_KH,' ')) || '%' and isnull(XLXSBJD_KH,' ') <> ' ')) "); sSQL.AppendLine(" and not exists(select 1 from XLXSBJZDBJYXX where XLXSBJZDBJYXX_XXLX='XM' and XLXSBJZDBJYXX_XXNR=XLXSBJD_XMMC) ) then 'B,' else '' end || "); } if (bZD12) sSQL.AppendLine(" case when XLXSBJD_KHLXR='" + sKHLXR + "' then 'C,' else '' end || "); if (bZD13) sSQL.AppendLine(" case when XLXSBJD_LXDH='" + sLXDH + "' then 'D,' else '' end || "); if(bZD15) sSQL.AppendLine(" case when (XLXSBJD_KH='" + sKH + "' and XLXSBJD_XMMC='" + sXM + "' ) then 'F,' else '' end || "); sSQL.AppendLine(" ' ' as ZDLX "); sSQL.AppendLine(" from XLXSBJD"); sSQL.AppendLine(" left join (select XLXSBJDMX_BJDID as BJDID,count(XLXSBJDMX_XH) as SL from XLXSBJDMX where 1=1 group by XLXSBJDMX_BJDID)MX on MX.BJDID=XLXSBJD_BJDID "); //*项目名称词组重复*/ if (sZDYY.Contains("4")) { sSQL.AppendLine("left join (select XLXSBJZDCZ_BJDID as BJDID,count(1)as CZXTGS "); sSQL.AppendLine(" from XLXSBJZDCZ GJCA "); sSQL.AppendLine(" left join XLXSBJD BJDA on BJDA.XLXSBJD_BJDID=GJCA.XLXSBJZDCZ_BJDID "); sSQL.AppendLine(" where GJCA.XLXSBJZDCZ_BJDID<>:pBJDID and isnull(XLXSBJD_YWLX,' ')= ' ' "); sSQL.AppendLine(" and GJCA.XLXSBJZDCZ_XMCZ in "); sSQL.AppendLine(" (select GJCB.XLXSBJZDCZ_XMCZ from XLXSBJZDCZ GJCB "); sSQL.AppendLine(" left join XLXSBJD BJDB on BJDB.XLXSBJD_BJDID=GJCB.XLXSBJZDCZ_BJDID "); sSQL.AppendLine(" where GJCB.XLXSBJZDCZ_BJDID=:pBJDID and abs(DATEDIFF(year,BJDA.XLXSBJD_BJRQ,BJDB.XLXSBJD_BJRQ))<2 "); if (!sTSC.Equals("")) sSQL.AppendLine(" and not " + sTSC); sSQL.AppendLine(" )group by GJCA.XLXSBJZDCZ_BJDID)A ON A.BJDID=XLXSBJD_BJDID "); } //产品重复、按产品个数区间+分段重复率查产品重复--当前报价单明细记录数为0则不进行此判断*/ if (sZDYY.Contains("5") || sZDYY.Contains("14")) { sSQL.AppendLine(" left join (select a.XLXSBJDMX_BJDID as BJDID,sum(case when isNull(ZCSL,0):pBJDID and isnull(XLXSBJDMX_YWLX,' ')= ' ' ");//--当前报价单号 sSQL.AppendLine(" ) tmpA "); if (sCFCPBQFBZ.Equals("Y")) { sSQL.AppendLine(" group by XLXSBJDMX_BJDID,XLXSBJDMX_XLXHID,XLXSBJDMX_XLGGID,XLXSBJDMX_DYDJID)a,"); } else { sSQL.AppendLine(" group by XLXSBJDMX_BJDID,XLXSBJDMX_XLXHID,XLXSBJDMX_XLGGID,XLXSBJDMX_XLBZID,XLXSBJDMX_DYDJID)a,"); } sSQL.AppendLine(" (select XLXSBJDMX_XLXHID,XLXSBJDMX_XLGGID,"); if (sCFCPBQFBZ.Equals("Y")) { sSQL.AppendLine(" XLXSBJDMX_DYDJID,count(XLXSBJDMX_XH)as BZSL "); } else { sSQL.AppendLine(" XLXSBJDMX_XLBZID,XLXSBJDMX_DYDJID,count(XLXSBJDMX_XH)as BZSL "); } sSQL.AppendLine(" from "); sSQL.AppendLine(" (select XLXSBJDMX_XLXHID,XLXSBJDMX_XLGGID, "); if (sCFCPBQFBZ.Equals("Y")) { sSQL.AppendLine(" XLXSBJDMX_DYDJID,XLXSBJDMX_XH "); } else { sSQL.AppendLine(" XLXSBJDMX_DYDJID,XLXSBJDMX_XH, "); if (pzxx.XLXSBJPZ_CPCFXLBZ.Equals("")) sSQL.AppendLine(" XLXSBJDMX_XLBZID "); else { sSQL.AppendLine(" case XLXSBJDMX_XLBZID "); for (int i = 0; i < pzxx.XLXSBJPZ_CPCFXLBZ.Split(',').Length; i++) { sSQL.AppendLine(string.Format(" when '{0}' then '{1}' ", pzxx.XLXSBJPZ_CPCFXLBZ.Split(',')[i], pzxx.XLXSBJPZ_CPCFXLBZ.Split(',')[0])); } sSQL.AppendLine(" else XLXSBJDMX_XLBZID end as XLXSBJDMX_XLBZID "); } } sSQL.AppendLine(" from XLXSBJDMX "); sSQL.AppendLine(" where XLXSBJDMX_BJDID=:pBJDID ");//--当前报价单号 sSQL.AppendLine(" ) tmpB "); if (sCFCPBQFBZ.Equals("Y")) { sSQL.AppendLine(" group by XLXSBJDMX_XLXHID,XLXSBJDMX_XLGGID,XLXSBJDMX_DYDJID)b "); } else { sSQL.AppendLine(" group by XLXSBJDMX_XLXHID,XLXSBJDMX_XLGGID,XLXSBJDMX_XLBZID,XLXSBJDMX_DYDJID)b "); } sSQL.AppendLine(" where a.XLXSBJDMX_XLXHID=b.XLXSBJDMX_XLXHID"); sSQL.AppendLine(" and a.XLXSBJDMX_XLGGID=b.XLXSBJDMX_XLGGID"); if (!sCFCPBQFBZ.Equals("Y")) { sSQL.AppendLine(" and a.XLXSBJDMX_XLBZID=b.XLXSBJDMX_XLBZID"); } sSQL.AppendLine(" and a.XLXSBJDMX_DYDJID=b.XLXSBJDMX_DYDJID"); sSQL.AppendLine(" group by a.XLXSBJDMX_BJDID)sameCPBJD on sameCPBJD.BJDID=XLXSBJD_BJDID"); } //*产品+数量重复--当前报价单明细记录数为0则不进行此判断*/ if (sZDYY.Contains("6")) { sSQL.AppendLine(" left join (select a.XLXSBJDMX_BJDID as BJDID,sum(case when isNull(ZCSL,0):pBJDID and isnull(XLXSBJDMX_YWLX,' ')= ' ' ");//--当前报价单号 sSQL.AppendLine(" ) tmpA "); if (sCFCPBQFBZ.Equals("Y")) { sSQL.AppendLine(" group by XLXSBJDMX_BJDID,XLXSBJDMX_XLXHID,XLXSBJDMX_XLGGID,XLXSBJDMX_DYDJID,"); } else { sSQL.AppendLine(" group by XLXSBJDMX_BJDID,XLXSBJDMX_XLXHID,XLXSBJDMX_XLGGID,XLXSBJDMX_XLBZID,XLXSBJDMX_DYDJID,"); } sSQL.AppendLine(" ZCBJSL)a, "); sSQL.AppendLine(" (select XLXSBJDMX_XLXHID,XLXSBJDMX_XLGGID, "); if (sCFCPBQFBZ.Equals("Y")) { sSQL.AppendLine(" XLXSBJDMX_DYDJID,count(XLXSBJDMX_XH)as BZSL,BZBJSL "); } else { sSQL.AppendLine(" XLXSBJDMX_XLBZID,XLXSBJDMX_DYDJID,count(XLXSBJDMX_XH)as BZSL,BZBJSL "); } sSQL.AppendLine(" from "); sSQL.AppendLine(" (select XLXSBJDMX_XLXHID,XLXSBJDMX_XLGGID, "); sSQL.AppendLine(" XLXSBJDMX_DYDJID,XLXSBJDMX_XH,XLXSBJDMX_JLDW,XLXSBJDMX_BJSL, "); if (sCFCPBQFBZ.Equals("Y")) { sSQL.AppendLine(" (case when XLXSBJDMX_JLDW ='Km' then XLXSBJDMX_BJSL*1000 else XLXSBJDMX_BJSL end) as BZBJSL "); } else { sSQL.AppendLine(" (case when XLXSBJDMX_JLDW ='Km' then XLXSBJDMX_BJSL*1000 else XLXSBJDMX_BJSL end) as BZBJSL, "); if (pzxx.XLXSBJPZ_CPCFXLBZ.Equals("")) sSQL.AppendLine(" XLXSBJDMX_XLBZID "); else { sSQL.AppendLine(" case XLXSBJDMX_XLBZID "); for (int i = 0; i < pzxx.XLXSBJPZ_CPCFXLBZ.Split(',').Length; i++) { sSQL.AppendLine(string.Format(" when '{0}' then '{1}' ", pzxx.XLXSBJPZ_CPCFXLBZ.Split(',')[i], pzxx.XLXSBJPZ_CPCFXLBZ.Split(',')[0])); } sSQL.AppendLine(" else XLXSBJDMX_XLBZID end as XLXSBJDMX_XLBZID "); } } sSQL.AppendLine(" from XLXSBJDMX "); sSQL.AppendLine(" where XLXSBJDMX_BJDID=:pBJDID ");//--当前报价单号 sSQL.AppendLine(" ) tmpB "); if (sCFCPBQFBZ.Equals("Y")) { sSQL.AppendLine(" group by XLXSBJDMX_XLXHID,XLXSBJDMX_XLGGID,XLXSBJDMX_DYDJID, "); } else { sSQL.AppendLine(" group by XLXSBJDMX_XLXHID,XLXSBJDMX_XLGGID,XLXSBJDMX_XLBZID,XLXSBJDMX_DYDJID, "); } sSQL.AppendLine(" BZBJSL)b "); sSQL.AppendLine(" where a.XLXSBJDMX_XLXHID=b.XLXSBJDMX_XLXHID"); sSQL.AppendLine(" and a.XLXSBJDMX_XLGGID=b.XLXSBJDMX_XLGGID"); if (!sCFCPBQFBZ.Equals("Y")) { sSQL.AppendLine(" and a.XLXSBJDMX_XLBZID=b.XLXSBJDMX_XLBZID"); } sSQL.AppendLine(" and a.XLXSBJDMX_DYDJID=b.XLXSBJDMX_DYDJID"); sSQL.AppendLine(" and a.ZCBJSL=b.BZBJSL "); sSQL.AppendLine(" group by a.XLXSBJDMX_BJDID)sameCPSLBJD on sameCPSLBJD.BJDID=XLXSBJD_BJDID"); } //*规格+数量重复--当前报价单明细记录数为0则不进行此判断*/ if (sZDYY.Contains("16")) { sSQL.AppendLine(" left join (select a.XLXSBJDMX_BJDID as BJDID,sum(case when isNull(ZCSL,0):pBJDID and isnull(XLXSBJDMX_YWLX,' ')= ' ' "); sSQL.AppendLine(" ) tmpA "); sSQL.AppendLine(" group by XLXSBJDMX_BJDID,XLXSBJDMX_XLGGID,ZCBJSL)a, "); sSQL.AppendLine(" (select XLXSBJDMX_XLGGID,count(XLXSBJDMX_XH)as BZSL,BZBJSL "); sSQL.AppendLine(" from "); sSQL.AppendLine(" (select XLXSBJDMX_XLGGID,XLXSBJDMX_XH,XLXSBJDMX_JLDW,XLXSBJDMX_BJSL, "); sSQL.AppendLine(" (case when XLXSBJDMX_JLDW ='Km' then XLXSBJDMX_BJSL*1000 else XLXSBJDMX_BJSL end) as BZBJSL "); sSQL.AppendLine(" from XLXSBJDMX "); sSQL.AppendLine(" where XLXSBJDMX_BJDID=:pBJDID "); sSQL.AppendLine(" ) tmpB "); sSQL.AppendLine(" group by XLXSBJDMX_XLGGID,BZBJSL)b "); sSQL.AppendLine(" where a.XLXSBJDMX_XLGGID=b.XLXSBJDMX_XLGGID"); sSQL.AppendLine(" and a.ZCBJSL=b.BZBJSL "); sSQL.AppendLine(" group by a.XLXSBJDMX_BJDID)sameGGSLBJD on sameGGSLBJD.BJDID=XLXSBJD_BJDID"); } //*仅型号规格重复--当前报价单明细记录数为0则不进行此判断*/ if (sZDYY.Contains("7")) { sSQL.AppendLine(" left join (select a.XLXSBJDMX_BJDID as BJDID,sum(case when isNull(ZCSL,0):pBJDID and isnull(XLXSBJDMX_YWLX,' ')= ' ' ");//--当前报价单号 sSQL.AppendLine(" group by XLXSBJDMX_BJDID,XLXSBJDMX_XLXHID,XLXSBJDMX_XLGGID)a,"); sSQL.AppendLine(" (select XLXSBJDMX_XLXHID,XLXSBJDMX_XLGGID,count(XLXSBJDMX_XH)as BZSL "); sSQL.AppendLine(" from XLXSBJDMX "); sSQL.AppendLine(" where XLXSBJDMX_BJDID=:pBJDID ");//--当前报价单号 sSQL.AppendLine(" group by XLXSBJDMX_XLXHID,XLXSBJDMX_XLGGID)b "); sSQL.AppendLine(" where a.XLXSBJDMX_XLXHID=b.XLXSBJDMX_XLXHID"); sSQL.AppendLine(" and a.XLXSBJDMX_XLGGID=b.XLXSBJDMX_XLGGID"); sSQL.AppendLine(" group by a.XLXSBJDMX_BJDID)sameXHGGBJD on sameXHGGBJD.BJDID=XLXSBJD_BJDID"); } //*型号规格重复、产品重复共用被撞明细记录数量*/ if (sZDYY.Contains("5") || sZDYY.Contains("6") || sZDYY.Contains("16") || sZDYY.Contains("7") || sZDYY.Contains("14")) { sSQL.AppendLine(" left join (select count(1) as MXCounts,XLXSBJDMX_BJDID from XLXSBJDMX where XLXSBJDMX_BJDID=:pBJDID group by XLXSBJDMX_BJDID)MXCount on MXCount.XLXSBJDMX_BJDID=:pBJDID "); } //备案项目 if (sZDYY.Contains("8") || sZDYY.Contains("9") || sZDYY.Contains("10")) { sSQL.AppendLine(" left join (select YXXM_XMID as XMID,YXXM_TXY,YXXM_BARQS,YXXM_BARQZ,"); sSQL.AppendLine(" K1.KHXX_MC as K1MC,K2.KHXX_MC as K2MC, K3.KHXX_MC as K3MC,K4.KHXX_MC as K4MC "); sSQL.AppendLine(" from YXXM "); sSQL.AppendLine(" left join KHXX K1 on K1.KHXX_CRMKHID=YXXM_CRMKHID"); sSQL.AppendLine(" left join KHXX K2 on K2.KHXX_CRMKHID=YXXM_CRMKHID2"); sSQL.AppendLine(" left join KHXX K3 on K3.KHXX_CRMKHID=YXXM_CRMKHID3"); sSQL.AppendLine(" left join KHXX K4 on K4.KHXX_CRMKHID=YXXM_CRMKHID4"); sSQL.AppendLine(" and YXXM_WPID not in ('ZZZZ','ZZZY')"); sSQL.AppendLine(" )XM on XM.XMID=XLXSBJD_XMID"); } sSQL.AppendLine(" where XLXSBJD_BJDID<>:pBJDID "); sSQL.AppendLine(" and isnull(XLXSBJD_YWLX,' ') = ' ' "); sSQL.AppendLine(" and XLXSBJD_BJRQ >= DATEADD(month,-" + iYF + ",getdate()) "); if (bBJY1) { sSQL.AppendLine(" and ( XLXSBJD_KH <> '" + sKH + "' or XLXSBJD_TXY <> '" + sTXY + "' ) "); } if (bBJY2) { sSQL.AppendLine(" and XLXSBJD_TXY <> '" + sTXY + "' "); } sSQL.AppendLine(" and "); sSQL.AppendLine(" (1<>1 "); if (bZD5)//*产品重复*/ { sSQL.AppendLine(" or (sameCPBJD.sameBJCPS>= "+pzxx.XLXSBJPZ_CPCFGS);//*产品重复*/txtCPCFGS sSQL.AppendLine(" and GE((case when MX.SL>MXCount.MXCounts then round(100.0*sameCPBJD.sameBJCPS/MX.SL,2) "); sSQL.AppendLine(" else round(100.0*sameCPBJD.sameBJCPS/MXCount.MXCounts,2) end)," + pzxx.XLXSBJPZ_CPCFBL + ")) "); } if (bZD14)//*按产品个数区间+分段重复率查产品重复*/ { sSQL.AppendLine(string.Format(" or (MX.SL>MXCount.MXCounts*(1- {0}) AND MX.SLMXCount.MXCounts then round(100.0*sameCPBJD.sameBJCPS/MX.SL,2) "); sSQL.AppendLine(string.Format(" else round(100.0*sameCPBJD.sameBJCPS/MXCount.MXCounts,2) end),{0}) AND MXCount.MXCounts <= {1}) ", pzxx.XLXSBJPZ_XYFDSCFBL, pzxx.XLXSBJPZ_MXFDS)); sSQL.AppendLine(" OR (GE((case when MX.SL>MXCount.MXCounts then round(100.0*sameCPBJD.sameBJCPS/MX.SL,2) "); sSQL.AppendLine(string.Format(" else round(100.0*sameCPBJD.sameBJCPS/MXCount.MXCounts,2) end),{0}) AND MXCount.MXCounts > {1}))) ", pzxx.XLXSBJPZ_DYFDSCFBL, pzxx.XLXSBJPZ_MXFDS)); } if (bZD6)//*产品+数量重复*/ { sSQL.AppendLine(string.Format(" or (sameCPSLBJD.sameBJCPSLS>={0} ", pzxx.XLXSBJPZ_CPSLCFGS)); sSQL.AppendLine(string.Format(" and GE((case when MX.SL>MXCount.MXCounts then round(100.0*sameCPSLBJD.sameBJCPSLS/MX.SL,2) ")); sSQL.AppendLine(" else round(100.0*sameCPSLBJD.sameBJCPSLS/MXCount.MXCounts,2) end)," + pzxx.XLXSBJPZ_CPSLCFBL + ")) "); } if (bZD16)//*规格+数量重复*/ { sSQL.AppendLine(string.Format(" or (sameGGSLBJD.sameGGSLs>={0} ", ZDFXPZHelper.GetGGSLCFGS())); sSQL.AppendLine(string.Format(" and GE((case when MX.SL>MXCount.MXCounts then round(100.0*sameGGSLBJD.sameGGSLs/MX.SL,2) ")); sSQL.AppendLine(" else round(100.0*sameGGSLBJD.sameGGSLs/MXCount.MXCounts,2) end)," + ZDFXPZHelper.GetGGSLCFBL() + ")) "); } if (bZD7)//*仅型号规格重复*/ { //*仅型号规格重复*/txtCPSLCFGS sSQL.AppendLine(" or GE((case when MX.SL>MXCount.MXCounts then round(100.0*sameXHGGBJD.sameXHGGS/MX.SL,2) "); sSQL.AppendLine(string.Format(" else round(100.0*sameXHGGBJD.sameXHGGS/MXCount.MXCounts,2) end),{0}) ", pzxx.XLXSBJPZ_XHGGCFBL));//txtXHGGCFBL } if (bZD4)//*项目名称词组重复*/ { sSQL.AppendLine(string.Format(" or (A.CZXTGS >={0}) ", pzxx.XLXSBJPZ_XMMCCZCFGS));//*项目名称词组重复*/ } if (bZD3)//*项目名称重复*/ { sSQL.AppendLine(" or (XLXSBJD_XMMC='" + sXM + "' and not exists(select 1 from XLXSBJZDBJYXX where XLXSBJZDBJYXX_XXLX='XM' and XLXSBJZDBJYXX_XXNR=XLXSBJD_XMMC) ) ");//*项目名称重复*/ } if (bZD2)//*客户名称重复*/ { sSQL.AppendLine(" or (XLXSBJD_KH='" + sKH + "') ");//*客户名称重复*/ } if (bZD1)//*客户+销售员相撞*/ { sSQL.AppendLine(" or (XLXSBJD_KH='" + sKH + "' and XLXSBJD_TXY='" + sTXY + "') ");//*客户+销售员相撞*/ } if (bZD12)//*客户联系人重复*/ { sSQL.AppendLine(" or (XLXSBJD_KHLXR='" + sKHLXR + "') ");//*客户联系人重复*/ } if (bZD13)//*客户电话重复*/ { sSQL.AppendLine(" or (XLXSBJD_LXDH='" + sLXDH + "') ");//*客户电话重复*/ } if (bZD8)//*备案项目客户名称重复*/ { sSQL.AppendLine(" or ((K1MC='" + sKH + "' or K2MC='" + sKH + "' or K3MC='" + sKH + "' or K4MC='" + sKH + "') and isNull(XM.XMID,' ')=XLXSBJD_XMID) ");//*备案项目客户名称重复*/ } if (bZD9)//*备案项目名称重复*/ { sSQL.AppendLine(string.Format(" or (isNull(XM.XMID,' ')=XLXSBJD_XMID and XLXSBJD_XMID='{0}') ",sXMID));//*备案项目客户名称重复,:pXMID为当前报价单的XMID*/ } if (bZD10)//*备案项目名称+销售员重复*/ { sSQL.AppendLine(string.Format("or (isNull(XM.XMID,' ')=XLXSBJD_XMID and XLXSBJD_XMID='{0}' and YXXM_TXY='" + sTXY + "') ", sXMID));//*备案项目名称+销售员重复*/ } if (bZD11)//*项目与客户名称相撞*/ { sSQL.AppendLine(" or (XLXSBJD_KH like '%" + sXM + "%' or ('" + sXM + "' like '%' || rtrim(isnull(XLXSBJD_KH,' ')) || '%' and isnull(XLXSBJD_KH,' ') <> ' ')) ");//*项目名称重复*/ } if (bZD15)//客户名称、项目名称相撞 sSQL.AppendLine(" or (XLXSBJD_KH='" + sKH + "' and XLXSBJD_XMMC='" + sXM + "' )" ); sSQL.AppendLine(" ) "); sSQL.AppendLine("order by "+ "XLXSBJD_BJRQ,XLXSBJD_BJDID "); return sSQL.ToString(); } public static void JudgeDifBJCP(string sBJDID, string sBJU003, ref string WarningMsg, string sXTCPBJYZ) { List lst = new List(); Dictionary dicA = new Dictionary(); Dictionary dicB = new Dictionary(); Dictionary dicC = new Dictionary(); //型号，规格，标准， 电压等级拼接的组合 string sBJCP = ""; string sCPBJ = ""; string iXSSX = ""; TDatabase dberp = TContextDatabases.GetDatabase("DBERP"); TSQL SQL = new TSQL(dberp); SQL.Clear(); SQL.Add("select XLXSBJDMX_XLXHID,XLXSBJDMX_XLGGID,XLXSBJDMX_XLBZID,XLXSBJDMX_DYDJID,XLXSBJDMX_JLDW, "); SQL.Add(" XLXSBJDMX_CPBJ,XLXSBJDMX_XSSX "); if (sXTCPBJYZ.Equals("5") || sXTCPBJYZ.Equals("6")) { SQL.Add(",XLXSBJDMX_XLYSID"); } SQL.Add(" from XLXSBJDMX "); SQL.Add("where XLXSBJDMX_BJDID = :pXLXSBJDMX_BJDID "); SQL.Add(" order by XLXSBJDMX_XLXHID,XLXSBJDMX_XLGGID,XLXSBJDMX_XLBZID,XLXSBJDMX_DYDJID "); SQL.ParamByName("pXLXSBJDMX_BJDID").Value = sBJDID; DataSet dsBJDMX = dberp.OpenDataSet(SQL); for (int i = 0; i < dsBJDMX.Tables[0].Rows.Count; i++) { iXSSX = dsBJDMX.Tables[0].Rows[i]["XLXSBJDMX_XSSX"].ToString().Trim(); sBJCP = dsBJDMX.Tables[0].Rows[i]["XLXSBJDMX_XLXHID"].ToString().Trim().ToUpper() + "|" + dsBJDMX.Tables[0].Rows[i]["XLXSBJDMX_XLGGID"].ToString().Trim() + "|" + dsBJDMX.Tables[0].Rows[i]["XLXSBJDMX_XLBZID"].ToString().Trim() + "|" + dsBJDMX.Tables[0].Rows[i]["XLXSBJDMX_DYDJID"].ToString().Trim() + "|" + XLBJDUtils.GetsJSDW(dsBJDMX.Tables[0].Rows[i]["XLXSBJDMX_JLDW"].ToString().Trim(), sBJU003); if (sXTCPBJYZ.Equals("5") || sXTCPBJYZ.Equals("6")) { sBJCP += "|" + dsBJDMX.Tables[0].Rows[i]["XLXSBJDMX_XLYSID"].ToString().Trim(); } sCPBJ = dsBJDMX.Tables[0].Rows[i]["XLXSBJDMX_CPBJ"].ToString().Trim(); if (!dicB.ContainsKey(sBJCP)) { dicB.Add(sBJCP, iXSSX); } else { string sXSSX = dicB[sBJCP]; dicB[sBJCP] = sXSSX + "," + iXSSX; } dicC.Add(iXSSX, sCPBJ); } foreach (string stBJCP in dicB.Keys) { string sXSSXS = dicB[stBJCP]; if (sXSSXS.Contains(",")) { dicA.Clear(); foreach (string stXSSX in sXSSXS.Split(',')) { string stCPBJ = dicC[stXSSX]; string sKeyA = stBJCP + "|" + stCPBJ; if (!dicA.ContainsKey(sKeyA)) { dicA.Add(sKeyA, stXSSX); } else { string sXSSX = dicA[sKeyA]; dicA[sKeyA] = sXSSX + "," + stXSSX; } } if (dicA.Count > 1) { string sXHList = ""; foreach (string sKeyA in dicA.Keys) { sXHList += "[" + dicA[sKeyA] + "] "; } lst.Add(sXHList); } } } string sXSSXList = ""; if (lst.Count > 0) { for (int i = 0; i < lst.Count; i++) { if (!sXSSXList.Equals("")) sXSSXList += "\n\r"; sXSSXList = sXSSXList + "【 " + lst[i].ToString().Trim() + " 】"; } WarningMsg = sXSSXList; } } public static void JudgeDifBJZJE(string sBJDID, ref string WarningMsg) { TDatabase dberp = TContextDatabases.GetDatabase("DBERP"); TSQL SQL = new TSQL(dberp); SQL.Clear(); SQL.Add(" select XLXSBJD_ZJE, "); SQL.Add(" isnull((select sum(XLXSBJDMX_BJJE) from XLXSBJDMX where XLXSBJDMX_BJDID = XLXSBJD_BJDID),0) as MXZJE "); SQL.Add(" from XLXSBJD where XLXSBJD_BJDID =:pBJDID "); SQL.ParamByName("pBJDID").Value = sBJDID; DataSet ds = dberp.OpenDataSet(SQL); if (ds.Tables[0].Rows.Count > 0) { double BJDZJE = CMISproConvert.StrToFloat(ds.Tables[0].Rows[0]["XLXSBJD_ZJE"].ToString().Trim()); double MXZJE = CMISproConvert.StrToFloat(ds.Tables[0].Rows[0]["MXZJE"].ToString().Trim()); double dCZ = NumberUtils.RoundX(BJDZJE - MXZJE, 2); if (dCZ != 0) { WarningMsg = "当前记录报价总金额和明细总金额不一致，差值为：" + dCZ.ToString().Trim() + "！"; } } } private XLBJDMX_BDOBill _XLBJDMX_BDOBill = new XLBJDMX_BDOBill(); [Association(Name = "XLXSBJDMX", DeleteOnNull = false, Storage = "_XLBJDMX_BDOBill", OtherKey = "XLXSBJD_BJDID", ThisKey = "XLXSBJDMX_XH")] public XLBJDMX_BDOBill XLXSBJDMX { get { return _XLBJDMX_BDOBill; } set { _XLBJDMX_BDOBill = value; } } } [EntityType(Db = "DBERP", Table = "XLXSBJDMX", IsWf = false, IsWhr = true, WhrPrefix = "XLXSBJDMX", IsAttach = false)] public class XLBJDMX_BDOBill : EntityObject { private string _BJDID; [ScriptIgnore] public string BJDID { get { return _BJDID; } set { _BJDID = value; } } private string _XH; [ScriptIgnore] public string XH { get { return _XH; } set { _XH = value; } } //翻页控件的当前显示页数 private int _curPageIndex = 0; public int curPageIndex { set { _curPageIndex = value; } get { return _curPageIndex; } } //翻页控件的每页显示记录数 private int _curPageSize = 0; public int curPageSize { set { _curPageSize = value; } get { return _curPageSize; } } //产品重复标准 private string _sCPCFXLBZ = ""; public string sCPCFXLBZ { set { _sCPCFXLBZ = value; } get { return _sCPCFXLBZ; } } private string _sXSSXFilter = ""; public string sXSSXFilter { set { _sXSSXFilter = value; } get { return _sXSSXFilter; } } private string _sXLXHIDFilter = ""; public string sXLXHIDFilter { set { _sXLXHIDFilter = value; } get { return _sXLXHIDFilter; } } private string _sXLGGIDFilter = ""; public string sXLGGIDFilter { set { _sXLGGIDFilter = value; } get { return _sXLGGIDFilter; } } private string _sXLBZIDFilter = ""; public string sXLBZIDFilter { set { _sXLBZIDFilter = value; } get { return _sXLBZIDFilter; } } private string _sDYDJIDFilter = ""; public string sDYDJIDFilter { set { _sDYDJIDFilter = value; } get { return _sDYDJIDFilter; } } private string _sXLYSIDFilter = ""; public string sXLYSIDFilter { set { _sXLYSIDFilter = value; } get { return _sXLYSIDFilter; } } private string _sBJCPFilter = ""; public string sBJCPFilter { set { _sBJCPFilter = value; } get { return _sBJCPFilter; } } private string _sJGBBJFilter = ""; public string sJGBBJFilter { set { _sJGBBJFilter = value; } get { return _sJGBBJFilter; } } private string _sBZBJDIDFilter = ""; public string sBZBJDIDFilter { set { _sBZBJDIDFilter = value; } get { return _sBZBJDIDFilter; } } private string _sZDXJJCLFilter = ""; public string sZDXJJCLFilter { set { _sZDXJJCLFilter = value; } get { return _sZDXJJCLFilter; } } private string _sCPMLFilter = ""; public string sCPMLFilter { set { _sCPMLFilter = value; } get { return _sCPMLFilter; } } private string _sZHCPMLFilter = ""; public string sZHCPMLFilter { set { _sZHCPMLFilter = value; } get { return _sZHCPMLFilter; } } private string _sXSYZJEFilter = ""; public string sXSYZJEFilter { set { _sXSYZJEFilter = value; } get { return _sXSYZJEFilter; } } private string _sBZFilter = ""; public string sBZFilter { set { _sBZFilter = value; } get { return _sBZFilter; } } public string sBJU002 = "5"; [DataMember(DbField = "XLXSBJDMX_BJDID", DbTitle = "报价单号", IsKey = true, DbType = TGtdbType.VarChar, Len = 20, IsNullable = false, DefValue = "", CtlName = "txtXLXSBJDMX_BJDID", CtlType = FieldType.C)] public string XLXSBJDMX_BJDID { get { return GetField("XLXSBJDMX_BJDID").ToString().Trim(); } set { SetField("XLXSBJDMX_BJDID", value); } } [DataMember(DbField = "XLXSBJDMX_XH", DbTitle = "序号", IsKey = true, DbType = TGtdbType.Float, Len = 8, IsNullable = false, DefValue = "0", CtlName = "txtXLXSBJDMX_XH", CtlType = FieldType.F)] public string XLXSBJDMX_XH { get { return GetField("XLXSBJDMX_XH").ToString().Trim(); } set { SetField("XLXSBJDMX_XH", value); } } [DataMember(DbField = "OLD_XLXSBJDMX_XH", DbTitle = "原序号", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtOLD_XH", PrintVisible = false, CtlType = FieldType.F)] public string OLD_XLXSBJDMX_XH { get { return GetField("OLD_XLXSBJDMX_XH").ToString().Trim(); } set { SetField("OLD_XLXSBJDMX_XH", value); } } [DataMember(DbField = "XLXSBJDMX_XSSX", DbTitle = "显示序号", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = false, DefValue = "0", CtlName = "txtXLXSBJDMX_XSSX", CtlType = FieldType.F)] public string XLXSBJDMX_XSSX { get { return GetField("XLXSBJDMX_XSSX").ToString().Trim(); } set { SetField("XLXSBJDMX_XSSX", value); } } [DataMember(DbField = "XLXSBJDMX_XLXHID", DbTitle = "型号", IsKey = false, DbType = TGtdbType.VarChar, Len = 40, IsNullable = true, DefValue = "", CtlName = "txtXLXSBJDMX_XLXHID", CtlType = FieldType.C)] public string XLXSBJDMX_XLXHID { get { return GetField("XLXSBJDMX_XLXHID").ToString().Trim(); } set { SetField("XLXSBJDMX_XLXHID", value); } } [DataMember(DbField = "XLXSBJDMX_XLGGID", DbTitle = "规格", IsKey = false, DbType = TGtdbType.VarChar, Len = 60, IsNullable = true, DefValue = "", CtlName = "txtXLXSBJDMX_XLGGID", CtlType = FieldType.C)] public string XLXSBJDMX_XLGGID { get { return GetField("XLXSBJDMX_XLGGID").ToString().Trim(); } set { SetField("XLXSBJDMX_XLGGID", value); } } [DataMember(DbField = "XLXSBJDMX_XLBZID", DbTitle = "标准", IsKey = false, DbType = TGtdbType.VarChar, Len = 10, IsNullable = true, DefValue = "", CtlName = "cbxXLXSBJDMX_XLBZID", CtlType = FieldType.CBX)] public string XLXSBJDMX_XLBZID { get { return GetField("XLXSBJDMX_XLBZID").ToString().Trim(); } set { SetField("XLXSBJDMX_XLBZID", value); } } [DataMember(DbField = "XLBZ_XLBZMS", DbTitle = "线缆标准描述", IsKey = false, DbType = TGtdbType.VarChar, Len = 250, IsNullable = true, DefValue = "", CtlName = "cbxXLBZ_XLBZMS", CtlType = FieldType.CBX)] public string XLBZ_XLBZMS { get { return GetField("XLBZ_XLBZMS").ToString().Trim(); } set { SetField("XLBZ_XLBZMS", value); } } [DataMember(DbField = "XLXSBJDMX_DYDJID", DbTitle = "电压等级", IsKey = false, DbType = TGtdbType.VarChar, Len = 20, IsNullable = true, DefValue = "", CtlName = "txtXLXSBJDMX_DYDJID", CtlType = FieldType.C)] public string XLXSBJDMX_DYDJID { get { return GetField("XLXSBJDMX_DYDJID").ToString().Trim(); } set { SetField("XLXSBJDMX_DYDJID", value); } } [DataMember(DbField = "XLXSBJDMX_XLYSID", DbTitle = "颜色", IsKey = false, DbType = TGtdbType.VarChar, Len = 50, IsNullable = true, DefValue = "", CtlName = "cbxXLXSBJDMX_XLYSID", CtlType = FieldType.C)] public string XLXSBJDMX_XLYSID { get { return GetField("XLXSBJDMX_XLYSID").ToString().Trim(); } set { SetField("XLXSBJDMX_XLYSID", value); } } [DataMember(DbField = "XLXSBJDMX_WLID", DbTitle = "物料ID", IsKey = false, DbType = TGtdbType.VarChar, Len = 20, IsNullable = true, DefValue = "", CtlName = "txtXLXSBJDMX_WLID", CtlType = FieldType.C)] public string XLXSBJDMX_WLID { get { return GetField("XLXSBJDMX_WLID").ToString().Trim(); } set { SetField("XLXSBJDMX_WLID", value); } } [DataMember(DbField = "XLXSBJDMX_ZHCPMLMC", DbTitle = "组合产品目录名称", IsKey = false, DbType = TGtdbType.VarChar, Len = 100, IsNullable = true, DefValue = "", CtlName = "txtXLXSBJDMX_ZHCPMLMC", CtlType = FieldType.CBX)] public string XLXSBJDMX_ZHCPMLMC { get { return GetField("XLXSBJDMX_ZHCPMLMC").ToString().Trim(); } set { SetField("XLXSBJDMX_ZHCPMLMC", value); } } [DataMember(DbField = "XLXSBJDMX_CPMLMC", DbTitle = "产品目录名称", IsKey = false, DbType = TGtdbType.VarChar, Len = 100, IsNullable = true, DefValue = "", CtlName = "txtXLXSBJDMX_CPMLMC", CtlType = FieldType.CBX)] public string XLXSBJDMX_CPMLMC { get { return GetField("XLXSBJDMX_CPMLMC").ToString().Trim(); } set { SetField("XLXSBJDMX_CPMLMC", value); } } [DataMember(DbField = "XLXSBJDMX_BJCP", DbTitle = "报价产品", IsKey = false, DbType = TGtdbType.VarChar, Len = 250, IsNullable = true, DefValue = "", CtlName = "txtXLXSBJDMX_BJCP", CtlType = FieldType.C)] public string XLXSBJDMX_BJCP { get { return GetField("XLXSBJDMX_BJCP").ToString().Trim(); } set { SetField("XLXSBJDMX_BJCP", value); } } [DataMember(DbField = "XLXSBJDMX_GYKH", DbTitle = "工艺卡号", IsKey = false, DbType = TGtdbType.VarChar, Len = 50, IsNullable = true, DefValue = "", CtlName = "txtXLXSBJDMX_GYKH", CtlType = FieldType.C)] public string XLXSBJDMX_GYKH { get { return GetField("XLXSBJDMX_GYKH").ToString().Trim(); } set { SetField("XLXSBJDMX_GYKH", value); } } [DataMember(DbField = "XLXSBJDMX_PWQDID", DbTitle = "配网清单ID", IsKey = false, DbType = TGtdbType.VarChar, Len = 50, IsNullable = true, DefValue = "", CtlName = "txtXLXSBJDMX_PWQDID", CtlType = FieldType.C)] public string XLXSBJDMX_PWQDID { get { return GetField("XLXSBJDMX_PWQDID").ToString().Trim(); } set { SetField("XLXSBJDMX_PWQDID", value); } } [DataMember(DbField = "XLXSBJDMX_PWQDWLMC", DbTitle = "物料名称", IsKey = false, DbType = TGtdbType.VarChar, Len = 250, IsNullable = true, DefValue = "", CtlName = "txtXLXSBJDMX_PWQDWLMC", CtlType = FieldType.C)] public string XLXSBJDMX_PWQDWLMC { get { return GetField("XLXSBJDMX_PWQDWLMC").ToString().Trim(); } set { SetField("XLXSBJDMX_PWQDWLMC", value); } } [DataMember(DbField = "XLXSBJDMX_PWQDMS", DbTitle = "描述", IsKey = false, DbType = TGtdbType.VarChar, Len = 250, IsNullable = true, DefValue = "", CtlName = "txtXLXSBJDMX_PWQDMS", CtlType = FieldType.C)] public string XLXSBJDMX_PWQDMS { get { return GetField("XLXSBJDMX_PWQDMS").ToString().Trim(); } set { SetField("XLXSBJDMX_PWQDMS", value); } } /// /// XLXSBJXHML对应产品目录 /// [DataMember(DbField = "HasCPMLID", DbTitle = "产品目录", IsKey = false, DbType = TGtdbType.VarChar, Len = 250, IsNullable = true, DefValue = "", CtlName = "txtCPML", CtlType = FieldType.C)] public string HasCPMLID { get { return GetField("HasCPMLID").ToString().Trim(); } set { SetField("HasCPMLID", value); } } /// /// ////// /// [DataMember(DbField = "XLWLXX", DbTitle = "报价产品", IsKey = false, DbType = TGtdbType.VarChar, Len = 250, IsNullable = true, DefValue = "", CtlName = "txtXLWLXX", CtlType = FieldType.C)] public string XLWLXX { get { return GetField("XLWLXX").ToString().Trim(); } set { SetField("XLWLXX", value); } } [DataMember(DbField = "XLXSBJDMX_WGCPBZ", DbTitle = "外购产品", IsKey = false, DbType = TGtdbType.VarChar, Len = 1, IsNullable = true, DefValue = "N", CtlName = "txtXLXSBJDMX_WGCPBZ", CtlType = FieldType.Y)] public string XLXSBJDMX_WGCPBZ { get { return GetField("XLXSBJDMX_WGCPBZ").ToString().Trim(); } set { SetField("XLXSBJDMX_WGCPBZ", value); } } [DataMember(DbField = "XLXSBJDMX_JLDW", DbTitle = "计量单位", IsKey = false, DbType = TGtdbType.VarChar, Len = 8, IsNullable = true, DefValue = "", CtlName = "cbxXLXSBJDMX_JLDW", CtlType = FieldType.CBX)] public string XLXSBJDMX_JLDW { get { return GetField("XLXSBJDMX_JLDW").ToString().Trim(); } set { SetField("XLXSBJDMX_JLDW", value); } } [DataMember(DbField = "XLXSBJDMX_BJSL", DbTitle = "报价数量", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtXLXSBJDMX_BJSL", CtlType = FieldType.F)] public string XLXSBJDMX_BJSL { get { return GetField("XLXSBJDMX_BJSL").ToString().Trim(); } set { SetField("XLXSBJDMX_BJSL", value); } } [DataMember(DbField = "XLXSBJDMX_BJDHQCLCB", DbTitle = "报价单行情材料成本", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtXLXSBJDMX_BJDHQCLCB", CtlType = FieldType.F)] public string XLXSBJDMX_BJDHQCLCB { get { return GetField("XLXSBJDMX_BJDHQCLCB").ToString().Trim(); } set { SetField("XLXSBJDMX_BJDHQCLCB", value); } } [DataMember(DbField = "XLXSBJDMX_CLCB", DbTitle = "价格表行情材料成本", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtXLXSBJDMX_CLCB", CtlType = FieldType.F)] public string XLXSBJDMX_CLCB { get { return GetField("XLXSBJDMX_CLCB").ToString().Trim(); } set { SetField("XLXSBJDMX_CLCB", value); } } [DataMember(DbField = "XLXSBJDMX_JGBJJ", DbTitle = "基价", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtXLXSBJDMX_JGBJJ", CtlType = FieldType.F)] public string XLXSBJDMX_JGBJJ { get { return GetField("XLXSBJDMX_JGBJJ").ToString().Trim(); } set { SetField("XLXSBJDMX_JGBJJ", value); } } //含税基准报价 [DataMember(DbField = "XLXSBJDMX_JGBBJ", DbTitle = "表价", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtXLXSBJDMX_JGBBJ", CtlType = FieldType.F)] public string XLXSBJDMX_JGBBJ { get { return GetField("XLXSBJDMX_JGBBJ").ToString().Trim(); } set { SetField("XLXSBJDMX_JGBBJ", value); } } //表价变更时间 [DataMember(DbField = "XLXSBJDMX_JGBBJGXSJ", DbTitle = "表价变更时间", IsKey = false, DbType = TGtdbType.DateTime, Len = 22, IsNullable = true, DefValue = "", CtlName = "datXLXSBJDMX_JGBBJGXSJ", CtlType = FieldType.DT)] public string XLXSBJDMX_JGBBJGXSJ { get { return GetField("XLXSBJDMX_JGBBJGXSJ").ToString().Trim(); } set { SetField("XLXSBJDMX_JGBBJGXSJ", value); } } [DataMember(DbField = "XLXSBJDMX_LSJGBBJ", DbTitle = "临时表价", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtXLXSBJDMX_LSJGBBJ", CtlType = FieldType.F)] public string XLXSBJDMX_LSJGBBJ { get { return GetField("XLXSBJDMX_LSJGBBJ").ToString().Trim(); } set { SetField("XLXSBJDMX_LSJGBBJ", value); } } //截面比公式 [DataMember(DbField = "XLXSBJDMX_JMBGS", DbTitle = "截面比公式", IsKey = false, DbType = TGtdbType.VarChar, Len = 60, IsNullable = true, DefValue = "", CtlName = "txtXLXSBJDMX_JMBGS", CtlType = FieldType.C)] public string XLXSBJDMX_JMBGS { get { return GetField("XLXSBJDMX_JMBGS").ToString().Trim(); } set { SetField("XLXSBJDMX_JMBGS", value); } } [DataMember(DbField = "XLXSBJDMX_CJ", DbTitle = "厂价核算", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtXLXSBJDMX_CJ", CtlType = FieldType.F)] public string XLXSBJDMX_CJ { get { return GetField("XLXSBJDMX_CJ").ToString().Trim(); } set { SetField("XLXSBJDMX_CJ", value); } } /***************************************/ //因子 [DataMember(DbField = "TZYZ_BJ01", DbTitle = "TZYZ_BJ01", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtTZYZ_BJ01", CtlType = FieldType.F)] public string TZYZ_BJ01 { get { return GetField("TZYZ_BJ01").ToString().Trim(); } set { SetField("TZYZ_BJ01", value); } } [DataMember(DbField = "TZYZ_BJ02", DbTitle = "TZYZ_BJ02", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtTZYZ_BJ02", CtlType = FieldType.F)] public string TZYZ_BJ02 { get { return GetField("TZYZ_BJ02").ToString().Trim(); } set { SetField("TZYZ_BJ02", value); } } [DataMember(DbField = "TZYZ_BJ03", DbTitle = "TZYZ_BJ03", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtTZYZ_BJ03", CtlType = FieldType.F)] public string TZYZ_BJ03 { get { return GetField("TZYZ_BJ03").ToString().Trim(); } set { SetField("TZYZ_BJ03", value); } } [DataMember(DbField = "TZYZ_BJ04", DbTitle = "TZYZ_BJ04", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtTZYZ_BJ04", CtlType = FieldType.F)] public string TZYZ_BJ04 { get { return GetField("TZYZ_BJ04").ToString().Trim(); } set { SetField("TZYZ_BJ04", value); } } [DataMember(DbField = "TZYZ_BJ05", DbTitle = "TZYZ_BJ05", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtTZYZ_BJ05", CtlType = FieldType.F)] public string TZYZ_BJ05 { get { return GetField("TZYZ_BJ05").ToString().Trim(); } set { SetField("TZYZ_BJ05", value); } } [DataMember(DbField = "TZYZ_BJ06", DbTitle = "TZYZ_BJ06", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtTZYZ_BJ06", CtlType = FieldType.F)] public string TZYZ_BJ06 { get { return GetField("TZYZ_BJ06").ToString().Trim(); } set { SetField("TZYZ_BJ06", value); } } [DataMember(DbField = "TZYZ_BJ07", DbTitle = "TZYZ_BJ07", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtTZYZ_BJ07", CtlType = FieldType.F)] public string TZYZ_BJ07 { get { return GetField("TZYZ_BJ07").ToString().Trim(); } set { SetField("TZYZ_BJ07", value); } } [DataMember(DbField = "TZYZ_BJ08", DbTitle = "TZYZ_BJ08", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtTZYZ_BJ08", CtlType = FieldType.F)] public string TZYZ_BJ08 { get { return GetField("TZYZ_BJ08").ToString().Trim(); } set { SetField("TZYZ_BJ08", value); } } [DataMember(DbField = "TZYZ_BJ09", DbTitle = "TZYZ_BJ09", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtTZYZ_BJ09", CtlType = FieldType.F)] public string TZYZ_BJ09 { get { return GetField("TZYZ_BJ09").ToString().Trim(); } set { SetField("TZYZ_BJ09", value); } } [DataMember(DbField = "TZYZ_BJ10", DbTitle = "TZYZ_BJ10", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtTZYZ_BJ10", CtlType = FieldType.F)] public string TZYZ_BJ10 { get { return GetField("TZYZ_BJ10").ToString().Trim(); } set { SetField("TZYZ_BJ10", value); } } [DataMember(DbField = "TZYZ_BJ11", DbTitle = "TZYZ_BJ11", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtTZYZ_BJ11", CtlType = FieldType.F)] public string TZYZ_BJ11 { get { return GetField("TZYZ_BJ11").ToString().Trim(); } set { SetField("TZYZ_BJ11", value); } } [DataMember(DbField = "TZYZ_BJ12", DbTitle = "TZYZ_BJ12", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtTZYZ_BJ12", CtlType = FieldType.F)] public string TZYZ_BJ12 { get { return GetField("TZYZ_BJ12").ToString().Trim(); } set { SetField("TZYZ_BJ12", value); } } [DataMember(DbField = "TZYZ_BJ13", DbTitle = "TZYZ_BJ13", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtTZYZ_BJ13", CtlType = FieldType.F)] public string TZYZ_BJ13 { get { return GetField("TZYZ_BJ13").ToString().Trim(); } set { SetField("TZYZ_BJ13", value); } } [DataMember(DbField = "TZYZ_BJ14", DbTitle = "TZYZ_BJ14", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtTZYZ_BJ14", CtlType = FieldType.F)] public string TZYZ_BJ14 { get { return GetField("TZYZ_BJ14").ToString().Trim(); } set { SetField("TZYZ_BJ14", value); } } [DataMember(DbField = "TZYZ_BJ15", DbTitle = "TZYZ_BJ15", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtTZYZ_BJ15", CtlType = FieldType.F)] public string TZYZ_BJ15 { get { return GetField("TZYZ_BJ15").ToString().Trim(); } set { SetField("TZYZ_BJ15", value); } } [DataMember(DbField = "TZYZ_BJ16", DbTitle = "TZYZ_BJ16", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtTZYZ_BJ16", CtlType = FieldType.F)] public string TZYZ_BJ16 { get { return GetField("TZYZ_BJ16").ToString().Trim(); } set { SetField("TZYZ_BJ16", value); } } [DataMember(DbField = "TZYZ_BJ17", DbTitle = "TZYZ_BJ17", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtTZYZ_BJ17", CtlType = FieldType.F)] public string TZYZ_BJ17 { get { return GetField("TZYZ_BJ17").ToString().Trim(); } set { SetField("TZYZ_BJ17", value); } } [DataMember(DbField = "TZYZ_BJ18", DbTitle = "TZYZ_BJ18", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtTZYZ_BJ18", CtlType = FieldType.F)] public string TZYZ_BJ18 { get { return GetField("TZYZ_BJ18").ToString().Trim(); } set { SetField("TZYZ_BJ18", value); } } [DataMember(DbField = "TZYZ_BJ19", DbTitle = "TZYZ_BJ19", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtTZYZ_BJ19", CtlType = FieldType.F)] public string TZYZ_BJ19 { get { return GetField("TZYZ_BJ19").ToString().Trim(); } set { SetField("TZYZ_BJ19", value); } } [DataMember(DbField = "TZYZ_BJ20", DbTitle = "TZYZ_BJ20", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtTZYZ_BJ20", CtlType = FieldType.F)] public string TZYZ_BJ20 { get { return GetField("TZYZ_BJ20").ToString().Trim(); } set { SetField("TZYZ_BJ20", value); } } /***************************************/ [DataMember(DbField = "XLXSBJDMX_TZQCPBJ", DbTitle = "调整前报价", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtXLXSBJDMX_TZQCPBJ", CtlType = FieldType.F)] public string XLXSBJDMX_TZQCPBJ { get { return GetField("XLXSBJDMX_TZQCPBJ").ToString().Trim(); } set { SetField("XLXSBJDMX_TZQCPBJ", value); } } [DataMember(DbField = "XLXSBJDMX_TZCPBJ", DbTitle = "调整报价(%)", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtXLXSBJDMX_TZCPBJ", CtlType = FieldType.F)] public string XLXSBJDMX_TZCPBJ { get { return GetField("XLXSBJDMX_TZCPBJ").ToString().Trim(); } set { SetField("XLXSBJDMX_TZCPBJ", value); } } //线缆产品报价 [DataMember(DbField = "XLXSBJDMX_CPBJ", DbTitle = "报价", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtXLXSBJDMX_CPBJ", CtlType = FieldType.F)] public string XLXSBJDMX_CPBJ { get { return GetField("XLXSBJDMX_CPBJ").ToString().Trim(); } set { SetField("XLXSBJDMX_CPBJ", value); } } [DataMember(DbField = "XLXSBJDMX_TZQBJJE", DbTitle = "报价金额", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtXLXSBJDMX_TZQBJJE", CtlType = FieldType.F)] public string XLXSBJDMX_TZQBJJE { get { return GetField("XLXSBJDMX_TZQBJJE").ToString().Trim(); } set { SetField("XLXSBJDMX_TZQBJJE", value); } } [DataMember(DbField = "XLXSBJDMX_TZBJJE", DbTitle = "调整金额", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtXLXSBJDMX_TZBJJE", CtlType = FieldType.F)] public string XLXSBJDMX_TZBJJE { get { return GetField("XLXSBJDMX_TZBJJE").ToString().Trim(); } set { SetField("XLXSBJDMX_TZBJJE", value); } } [DataMember(DbField = "XLXSBJDMX_BJJE", DbTitle = "调整后报价金额", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtXLXSBJDMX_BJJE", CtlType = FieldType.F)] public string XLXSBJDMX_BJJE { get { return GetField("XLXSBJDMX_BJJE").ToString().Trim(); } set { SetField("XLXSBJDMX_BJJE", value); } } [DataMember(DbField = "XLXSBJDMX_PJJE", DbTitle = "盘具金额", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtXLXSBJDMX_PJJE", CtlType = FieldType.F)] public string XLXSBJDMX_PJJE { get { return GetField("XLXSBJDMX_PJJE").ToString().Trim(); } set { SetField("XLXSBJDMX_PJJE", value); } } /// /// ////// /// [DataMember(DbField = "TZHDJ", DbTitle = "调整后单价", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtTZHDJ", CtlType = FieldType.F)] public string TZHDJ { get { return GetField("TZHDJ").ToString().Trim(); } set { SetField("TZHDJ", value); } } //意向价 [DataMember(DbField = "XLXSBJDMX_YXJG", DbTitle = "意向价", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtXLXSBJDMX_YXJG", CtlType = FieldType.F)] public string XLXSBJDMX_YXJG { get { return GetField("XLXSBJDMX_YXJG").ToString().Trim(); } set { SetField("XLXSBJDMX_YXJG", value); } } //定制生产 [DataMember(DbField = "XLXSBJDMX_DZSC", DbTitle = "定制生产", IsKey = false, DbType = TGtdbType.VarChar, Len = 1, IsNullable = true, DefValue = "N", CtlName = "txtXLXSBJDMX_DZSC", CtlType = FieldType.C)] public string XLXSBJDMX_DZSC { get { return GetField("XLXSBJDMX_DZSC").ToString().Trim(); } set { SetField("XLXSBJDMX_DZSC", value); } } [DataMember(DbField = "XLXSBJDMX_CLZL", DbTitle = "材料重量", IsKey = false, DbType = TGtdbType.Float, Len = 0, IsNullable = true, DefValue = "0", CtlName = "txtXLXSBJDMX_CLZL", CtlType = FieldType.F)] public string XLXSBJDMX_CLZL { get { return GetField("XLXSBJDMX_CLZL").ToString().Trim(); } set { SetField("XLXSBJDMX_CLZL", value); } } [DataMember(DbField = "XLXSBJDMX_YXJJCL", DbTitle = "意向价价差率(%)", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtXLXSBJDMX_YXJJCL", CtlType = FieldType.F)] public string XLXSBJDMX_YXJJCL { get { return GetField("XLXSBJDMX_YXJJCL").ToString().Trim(); } set { SetField("XLXSBJDMX_YXJJCL", value); } } [DataMember(DbField = "XLXSBJDMX_CLCBJCL", DbTitle = "料价价差率(%)", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtXLXSBJDMX_CLCBJCL", CtlType = FieldType.F)] public string XLXSBJDMX_CLCBJCL { get { return GetField("XLXSBJDMX_CLCBJCL").ToString().Trim(); } set { SetField("XLXSBJDMX_CLCBJCL", value); } } [DataMember(DbField = "XLXSBJDMX_JGBBJJCL", DbTitle = "表价价差率(%)", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtXLXSBJDMX_JGBBJJCL", CtlType = FieldType.F)] public string XLXSBJDMX_JGBBJJCL { get { return GetField("XLXSBJDMX_JGBBJJCL").ToString().Trim(); } set { SetField("XLXSBJDMX_JGBBJJCL", value); } } [DataMember(DbField = "XLXSBJDMX_JGBBJLJJCL", DbTitle = "价格表表价料价价差率(%)", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtXLXSBJDMX_JGBBJLJJCL", CtlType = FieldType.F)] public string XLXSBJDMX_JGBBJLJJCL { get { return GetField("XLXSBJDMX_JGBBJLJJCL").ToString().Trim(); } set { SetField("XLXSBJDMX_JGBBJLJJCL", value); } } [DataMember(DbField = "XLXSBJDMX_JGBBJJCE", DbTitle = "利润额", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtXLXSBJDMX_JGBBJJCE", CtlType = FieldType.F)] public string XLXSBJDMX_JGBBJJCE { get { return GetField("XLXSBJDMX_JGBBJJCE").ToString().Trim(); } set { SetField("XLXSBJDMX_JGBBJJCE", value); } } [DataMember(DbField = "XLXSBJDMX_TZQZDXJ", DbTitle = "调整前最低限价", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtXLXSBJDMX_TZQZDXJ", CtlType = FieldType.F)] public string XLXSBJDMX_TZQZDXJ { get { return GetField("XLXSBJDMX_TZQZDXJ").ToString().Trim(); } set { SetField("XLXSBJDMX_TZQZDXJ", value); } } [DataMember(DbField = "XLXSBJDMX_TZZDXJ", DbTitle = "调整最低限价(%)", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtXLXSBJDMX_TZZDXJ", CtlType = FieldType.F)] public string XLXSBJDMX_TZZDXJ { get { return GetField("XLXSBJDMX_TZZDXJ").ToString().Trim(); } set { SetField("XLXSBJDMX_TZZDXJ", value); } } [DataMember(DbField = "XLXSBJDMX_ZDXJ", DbTitle = "最低限价", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtXLXSBJDMX_ZDXJ", CtlType = FieldType.F)] public string XLXSBJDMX_ZDXJ { get { return GetField("XLXSBJDMX_ZDXJ").ToString().Trim(); } set { SetField("XLXSBJDMX_ZDXJ", value); } } [DataMember(DbField = "XLXSBJDMX_ZDXJJE", DbTitle = "最低限价金额", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtXLXSBJDMX_ZDXJJE", CtlType = FieldType.F)] public string XLXSBJDMX_ZDXJJE { get { return GetField("XLXSBJDMX_ZDXJJE").ToString().Trim(); } set { SetField("XLXSBJDMX_ZDXJJE", value); } } [DataMember(DbField = "XLXSBJDMX_ZDXJJCL", DbTitle = "最低限价价差率", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtXLXSBJDMX_ZDXJJCL", CtlType = FieldType.F)] public string XLXSBJDMX_ZDXJJCL { get { return GetField("XLXSBJDMX_ZDXJJCL").ToString().Trim(); } set { SetField("XLXSBJDMX_ZDXJJCL", value); } } [DataMember(DbField = "XLXSBJDMX_JSJG", DbTitle = "结算价", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtXLXSBJDMX_JSJG", CtlType = FieldType.F)] public string XLXSBJDMX_JSJG { get { return GetField("XLXSBJDMX_JSJG").ToString().Trim(); } set { SetField("XLXSBJDMX_JSJG", value); } } [DataMember(DbField = "XLXSBJDMX_JSJJE", DbTitle = "结算价金额", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtXLXSBJDMX_JSJJE", CtlType = FieldType.F)] public string XLXSBJDMX_JSJJE { get { return GetField("XLXSBJDMX_JSJJE").ToString().Trim(); } set { SetField("XLXSBJDMX_JSJJE", value); } } [DataMember(DbField = "XLXSBJDMX_JSJJCL", DbTitle = "结算价价差率", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtXLXSBJDMX_JSJJCL", CtlType = FieldType.F)] public string XLXSBJDMX_JSJJCL { get { return GetField("XLXSBJDMX_JSJJCL").ToString().Trim(); } set { SetField("XLXSBJDMX_JSJJCL", value); } } [DataMember(DbField = "XLXSBJDMX_YSCP", DbTitle = "原始产品", IsKey = false, DbType = TGtdbType.VarChar, Len = 250, IsNullable = true, DefValue = "", CtlName = "txtXLXSBJDMX_YSCP", CtlType = FieldType.C)] public string XLXSBJDMX_YSCP { get { return GetField("XLXSBJDMX_YSCP").ToString().Trim(); } set { SetField("XLXSBJDMX_YSCP", value); } } [DataMember(DbField = "XLXSBJDMX_KHWLID", DbTitle = "客户物料编码", IsKey = false, DbType = TGtdbType.VarChar, Len = 50, IsNullable = true, DefValue = "", CtlName = "txtXLXSBJDMX_KHWLID", CtlType = FieldType.C)] public string XLXSBJDMX_KHWLID { get { return GetField("XLXSBJDMX_KHWLID").ToString().Trim(); } set { SetField("XLXSBJDMX_KHWLID", value); } } [DataMember(DbField = "XLXSBJDMX_YZ", DbTitle = "印字", IsKey = false, DbType = TGtdbType.VarChar, Len = 250, IsNullable = true, DefValue = "", CtlName = "txtXLXSBJDMX_YZ", CtlType = FieldType.C)] public string XLXSBJDMX_YZ { get { return GetField("XLXSBJDMX_YZ").ToString().Trim(); } set { SetField("XLXSBJDMX_YZ", value); } } [DataMember(DbField = "XLXSBJDMX_FBH", DbTitle = "包号", IsKey = false, DbType = TGtdbType.VarChar, Len = 30, IsNullable = true, DefValue = "", CtlName = "txtXLXSBJDMX_FBH", CtlType = FieldType.C)] public string XLXSBJDMX_FBH { get { return GetField("XLXSBJDMX_FBH").ToString().Trim(); } set { SetField("XLXSBJDMX_FBH", value); } } [DataMember(DbField = "XLXSBJDMX_CPBJXJ", DbTitle = "产品报价限价", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtXLXSBJDMX_CPBJXJ", CtlType = FieldType.F)] public string XLXSBJDMX_CPBJXJ { get { return GetField("XLXSBJDMX_CPBJXJ").ToString().Trim(); } set { SetField("XLXSBJDMX_CPBJXJ", value); } } [DataMember(DbField = "XLXSBJDMX_BJXJKD", DbTitle = "报价限价扣点", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtXLXSBJDMX_BJXJKD", CtlType = FieldType.F)] public string XLXSBJDMX_BJXJKD { get { return GetField("XLXSBJDMX_BJXJKD").ToString().Trim(); } set { SetField("XLXSBJDMX_BJXJKD", value); } } [DataMember(DbField = "XLXSBJDMX_BJXJJJ", DbTitle = "报价限价加价", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtXLXSBJDMX_BJXJJJ", CtlType = FieldType.F)] public string XLXSBJDMX_BJXJJJ { get { return GetField("XLXSBJDMX_BJXJJJ").ToString().Trim(); } set { SetField("XLXSBJDMX_BJXJJJ", value); } } [DataMember(DbField = "XJBJCE", DbTitle = "限价报价差额", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtXJBJCE", CtlType = FieldType.F)] public string XJBJCE { get { return GetField("XJBJCE").ToString().Trim(); } set { SetField("XJBJCE", value); } } [DataMember(DbField = "XLXSBJDMX_BJJEXJ", DbTitle = "报价金额限价", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtXLXSBJDMX_BJJEXJ", CtlType = FieldType.F)] public string XLXSBJDMX_BJJEXJ { get { return GetField("XLXSBJDMX_BJJEXJ").ToString().Trim(); } set { SetField("XLXSBJDMX_BJJEXJ", value); } } [DataMember(DbField = "XLXSBJDMX_BZ", DbTitle = "备注", IsKey = false, DbType = TGtdbType.VarChar, Len = 250, IsNullable = true, DefValue = "", CtlName = "txtXLXSBJDMX_BZ", CtlType = FieldType.C)] public string XLXSBJDMX_BZ { get { return GetField("XLXSBJDMX_BZ").ToString().Trim(); } set { SetField("XLXSBJDMX_BZ", value); } } [DataMember(DbField = "XLXSBJDMX_BJCPSD", DbTitle = "报价锁定", IsKey = false, DbType = TGtdbType.VarChar, Len = 1, IsNullable = true, DefValue = "N", CtlName = "txtXLXSBJDMX_BJCPSD", CtlType = FieldType.Y)] public string XLXSBJDMX_BJCPSD { get { return GetField("XLXSBJDMX_BJCPSD").ToString().Trim(); } set { SetField("XLXSBJDMX_BJCPSD", value); } } [DataMember(DbField = "XLXSBJDMX_BJSDBZ", DbTitle = "报价锁定", IsKey = false, DbType = TGtdbType.VarChar, Len = 1, IsNullable = true, DefValue = "N", CtlName = "txtXLXSBJDMX_BJSDBZ", CtlType = FieldType.Y)] public string XLXSBJDMX_BJSDBZ { get { return GetField("XLXSBJDMX_BJSDBZ").ToString().Trim(); } set { SetField("XLXSBJDMX_BJSDBZ", value); } } [DataMember(DbField = "XLXSBJDMX_CLCBJCLSDBZ", DbTitle = "按料价价差率算报价", IsKey = false, DbType = TGtdbType.VarChar, Len = 1, IsNullable = true, DefValue = "N", CtlName = "txtXLXSBJDMX_CLCBJCLSDBZ", CtlType = FieldType.Y)] public string XLXSBJDMX_CLCBJCLSDBZ { get { return GetField("XLXSBJDMX_CLCBJCLSDBZ").ToString().Trim(); } set { SetField("XLXSBJDMX_CLCBJCLSDBZ", value); } } [DataMember(DbField = "WLXX", DbTitle = "物料信息", IsKey = false, DbType = TGtdbType.VarChar, Len = 120, IsNullable = true, DefValue = "", CtlName = "txtWLXX", CtlType = FieldType.C)] public string WLXX { get { return GetField("WLXX").ToString().Trim(); } set { SetField("WLXX", value); } } [DataMember(DbField = "XLXSBJDMX_ZB", DbTitle = "中标", IsKey = false, DbType = TGtdbType.VarChar, Len = 1, IsNullable = true, DefValue = "", CtlName = "txtXLXSBJDMX_ZB", CtlType = FieldType.C)] public string XLXSBJDMX_ZB { get { return GetField("XLXSBJDMX_ZB").ToString().Trim(); } set { SetField("XLXSBJDMX_ZB", value); } } [DataMember(DbField = "XLXSBJDMX_ZBSL", DbTitle = "中标数量", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtXLXSBJDMX_ZBSL", CtlType = FieldType.F)] public string XLXSBJDMX_ZBSL { get { return GetField("XLXSBJDMX_ZBSL").ToString().Trim(); } set { SetField("XLXSBJDMX_ZBSL", value); } } [DataMember(DbField = "XLXSBJDMX_ZBJE", DbTitle = "中标金额", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtXLXSBJDMX_ZBJE", CtlType = FieldType.F)] public string XLXSBJDMX_ZBJE { get { return GetField("XLXSBJDMX_ZBJE").ToString().Trim(); } set { SetField("XLXSBJDMX_ZBJE", value); } } [DataMember(DbField = "XLXSBJDMX_WHRID", DbTitle = "维护人工号", IsKey = false, DbType = TGtdbType.VarChar, Len = 10, IsNullable = true, DefValue = "", CtlName = "txtXLXSBJDMX_WHRID", CtlType = FieldType.HiddenField)] public string XLXSBJDMX_WHRID { get { return GetField("XLXSBJDMX_WHRID").ToString().Trim(); } set { SetField("XLXSBJDMX_WHRID", value); } } [DataMember(DbField = "XLXSBJDMX_WHR", DbTitle = "维护人", IsKey = false, DbType = TGtdbType.VarChar, Len = 30, IsNullable = true, DefValue = "", CtlName = "txtXLXSBJDMX_WHR", CtlType = FieldType.C)] public string XLXSBJDMX_WHR { get { return GetField("XLXSBJDMX_WHR").ToString().Trim(); } set { SetField("XLXSBJDMX_WHR", value); } } [DataMember(DbField = "XLXSBJDMX_WHSJ", DbTitle = "维护时间", IsKey = false, DbType = TGtdbType.DateTime, Len = 8, IsNullable = true, DefValue = "", CtlName = "datXLXSBJDMX_WHSJ", CtlType = FieldType.DT)] public string XLXSBJDMX_WHSJ { get { return GetField("XLXSBJDMX_WHSJ").ToString().Trim(); } set { SetField("XLXSBJDMX_WHSJ", value); } } [DataMember(DbField = "HasCLQD", DbTitle = "有无清单", IsKey = false, DbType = TGtdbType.VarChar, Len = 1, IsNullable = true, DefValue = "", CtlName = "txtHasCLQD", CtlType = FieldType.C)] public string HasCLQD { get { return GetField("HasCLQD").ToString().Trim(); } set { SetField("HasCLQD", value); } } [DataMember(DbField = "HasYLDZSQ", DbTitle = "有无用量制定申请", IsKey = false, DbType = TGtdbType.VarChar, Len = 1, IsNullable = true, DefValue = "", CtlName = "txtHasYLDZSQ", CtlType = FieldType.C)] public string HasYLDZSQ { get { return GetField("HasYLDZSQ").ToString().Trim(); } set { SetField("HasYLDZSQ", value); } } [DataMember(DbField = "UpdJJYZList", DbTitle = "更新基价因子值", IsKey = false, DbType = TGtdbType.VarChar, Len = 250, IsNullable = true, DefValue = "", CtlName = "txtUpdJJYZList", CtlType = FieldType.C)] public string UpdJJYZList { get { return GetField("UpdJJYZList").ToString().Trim(); } set { SetField("UpdJJYZList", value); } } [DataMember(DbField = "XLXSBJDMX_BJLY", DbTitle = "报价来源", IsKey = false, DbType = TGtdbType.VarChar, Len = 10, IsNullable = true, DefValue = "", CtlName = "txtBJLY", CtlType = FieldType.C)] public string XLXSBJDMX_BJLY { get { return GetField("XLXSBJDMX_BJLY").ToString().Trim(); } set { SetField("XLXSBJDMX_BJLY", value); } } [DataMember(DbField = "XLXSBJDMX_BJTJCZ", DbTitle = "报价调价操作", IsKey = false, DbType = TGtdbType.VarChar, Len = 10, IsNullable = true, DefValue = "", CtlName = "txtBJTJCZ", CtlType = FieldType.C)] public string XLXSBJDMX_BJTJCZ { get { return GetField("XLXSBJDMX_BJTJCZ").ToString().Trim(); } set { SetField("XLXSBJDMX_BJTJCZ", value); } } [DataMember(DbField = "PFYSQKBZ", DbTitle = "盘费要素清空标志", IsKey = false, DbType = TGtdbType.VarChar, Len = 1, IsNullable = true, DefValue = "", CtlName = "txtPFYSQKBZ", CtlType = FieldType.C)] public string PFYSQKBZ { get { return GetField("PFYSQKBZ").ToString().Trim(); } set { SetField("PFYSQKBZ", value); } } [DataMember(DbField = "HasFDJL", DbTitle = "有无分段记录", IsKey = false, DbType = TGtdbType.VarChar, Len = 1, IsNullable = true, DefValue = "", CtlName = "txtHasFDJL", CtlType = FieldType.C)] public string HasFDJL { get { return GetField("HasFDJL").ToString().Trim(); } set { SetField("HasFDJL", value); } } [DataMember(DbField = "XLXSBJDMX_BJDHQCLCBTZ", DbTitle = "报价单行情材料成本调整", IsKey = false, DbType = TGtdbType.VarChar, Len = 1, IsNullable = true, DefValue = "", CtlName = "txtBJDHQCLCBTZ", CtlType = FieldType.C)] public string XLXSBJDMX_BJDHQCLCBTZ { get { return GetField("XLXSBJDMX_BJDHQCLCBTZ").ToString().Trim(); } set { SetField("XLXSBJDMX_BJDHQCLCBTZ", value); } } [DataMember(DbField = "XLXSBJDMX_ZDXJBJDID", DbTitle = "最低限价报价单号", IsKey = false, DbType = TGtdbType.VarChar, Len = 20, IsNullable = true, DefValue = "", CtlName = "txtXLXSBJDMX_ZDXJBJDID", CtlType = FieldType.C)] public string XLXSBJDMX_ZDXJBJDID { get { return GetField("XLXSBJDMX_ZDXJBJDID").ToString().Trim(); } set { SetField("XLXSBJDMX_ZDXJBJDID", value); } } [DataMember(DbField = "XLXSBJDMX_ZDXJBJDXH", DbTitle = "最低限价报价单序号", IsKey = false, DbType = TGtdbType.Float, Len = 8, IsNullable = true, DefValue = "0", CtlName = "txtXLXSBJDMX_ZDXJBJDXH", CtlType = FieldType.F)] public string XLXSBJDMX_ZDXJBJDXH { get { return GetField("XLXSBJDMX_ZDXJBJDXH").ToString().Trim(); } set { SetField("XLXSBJDMX_ZDXJBJDXH", value); } } [DataMember(DbField = "XLXSBJDMX_XDXLBZID", DbTitle = "下单线缆标准", IsKey = false, DbType = TGtdbType.VarChar, Len = 10, IsNullable = true, DefValue = "", CtlName = "txtXLXSBJDMX_XDXLBZID", CtlType = FieldType.HiddenField)] public string XLXSBJDMX_XDXLBZID { get { return GetField("XLXSBJDMX_XDXLBZID").ToString().Trim(); } set { SetField("XLXSBJDMX_XDXLBZID", value); } } [DataMember(DbField = "XLXSBJDMX_XDXLXHID", DbTitle = "下单线缆型号", IsKey = false, DbType = TGtdbType.VarChar, Len = 40, IsNullable = true, DefValue = "", CtlName = "txtXLXSBJDMX_XDXLXHID", CtlType = FieldType.HiddenField)] public string XLXSBJDMX_XDXLXHID { get { return GetField("XLXSBJDMX_XDXLXHID").ToString().Trim(); } set { SetField("XLXSBJDMX_XDXLXHID", value); } } [DataMember(DbField = "XLXSBJDMX_JGBBJTZ", DbTitle = "价格表表价调整", IsKey = false, DbType = TGtdbType.VarChar, Len = 1, IsNullable = true, DefValue = "N", CtlName = "txtXLXSBJDMX_JGBBJTZ", CtlType = FieldType.C)] public string XLXSBJDMX_JGBBJTZ { get { return GetField("XLXSBJDMX_JGBBJTZ").ToString().Trim(); } set { SetField("XLXSBJDMX_JGBBJTZ", value); } } [DataMember(DbField = "XLXSBJDMX_JGFBZ", DbTitle = "JGF标志", IsKey = false, DbType = TGtdbType.VarChar, Len = 1, IsNullable = true, DefValue = "N", CtlName = "txtXLXSBJDMX_JGFBZ", CtlType = FieldType.C)] public string XLXSBJDMX_JGFBZ { get { return GetField("XLXSBJDMX_JGFBZ").ToString().Trim(); } set { SetField("XLXSBJDMX_JGFBZ", value); } } [DataMember(DbField = "BZTXYS", DbTitle = "标准提醒颜色", IsKey = false, DbType = TGtdbType.VarChar, Len = 10, IsNullable = true, DefValue = "", CtlName = "txtBZTXYS", CtlType = FieldType.C)] public string BZTXYS { get { return GetField("BZTXYS").ToString().Trim(); } set { SetField("BZTXYS", value); } } [DataMember(DbField = "YLZDYXTZ", DbTitle = "用量制定明细调整", IsKey = false, DbType = TGtdbType.VarChar, Len = 1, IsNullable = true, DefValue = "", CtlName = "txtYLZDYXTZ", CtlType = FieldType.C)] public string YLZDYXTZ { get { return GetField("YLZDYXTZ").ToString().Trim(); } set { SetField("YLZDYXTZ", value); } } [DataMember(DbField = "TCLYLBL", DbTitle = "铜材料用量比例", IsKey = false, DbType = TGtdbType.Float, Len = 22, IsNullable = true, DefValue = "0", CtlName = "txtTCLYLBL", CtlType = FieldType.F)] public string TCLYLBL { get { return GetField("TCLYLBL").ToString().Trim(); } set { SetField("TCLYLBL", value); } } [DataMember(DbField = "LCLYLBL", DbTitle = "铝材料用量比例", IsKey = false, DbType = TGtdbType.Float, Len = 22, IsNullable = true, DefValue = "0", CtlName = "txtLCLYLBL", CtlType = FieldType.F)] public string LCLYLBL { get { return GetField("LCLYLBL").ToString().Trim(); } set { SetField("LCLYLBL", value); } } [DataMember(DbField = "LHJCLYLBL", DbTitle = "铝合金材料用量比例", IsKey = false, DbType = TGtdbType.Float, Len = 22, IsNullable = true, DefValue = "0", CtlName = "txtLHJCLYLBL", CtlType = FieldType.F)] public string LHJCLYLBL { get { return GetField("LHJCLYLBL").ToString().Trim(); } set { SetField("LHJCLYLBL", value); } } [DataMember(DbField = "XLGGB_XLGGDW", DbTitle = "线缆规格单位", IsKey = false, DbType = TGtdbType.VarChar, Len = 10, IsNullable = true, DefValue = "", CtlName = "txtXLGGB_XLGGDW", CtlType = FieldType.C)] public string XLGGB_XLGGDW { get { return GetField("XLGGB_XLGGDW").ToString().Trim(); } set { SetField("XLGGB_XLGGDW", value); } } public override TSQL SetQuerySqlByKey() { TSQL SQL = base.SetQuerySqlByKey(); return SQL; } public override TSQL SetQuerySql() { int iXSWS = string.IsNullOrEmpty(sBJU002) ? 5 : CMISproConvert.StrToInt(sBJU002); if (iXSWS < 0) iXSWS = 0; else if (iXSWS > 8) iXSWS = 8; TSQL SQL = base.SetQuerySql(); SQL.Add("select XLXSBJDMX_BJDID,XLXSBJDMX_XH, OLD_XLXSBJDMX_XH,XLXSBJDMX_XSSX, XLXSBJDMX_XLXHID, XLXSBJDMX_XLGGID, "); SQL.Add(" XLXSBJDMX_XLBZID,XLBZ_XLBZMS,XLXSBJDMX_DYDJID,XLXSBJDMX_XLYSID,XLXSBJDMX_WLID,"); SQL.Add(" XLXSBJDMX_ZHCPMLMC,XLXSBJDMX_CPMLMC,HasCPMLID,"); SQL.Add(" XLXSBJDMX_BJCP,XLXSBJDMX_GYKH,XLXSBJDMX_PWQDID,XLXSBJDMX_PWQDWLMC,XLXSBJDMX_PWQDMS,XLWLXX,"); SQL.Add(" XLXSBJDMX_WGCPBZ,XLXSBJDMX_JLDW,XLXSBJDMX_BJSL,XLXSBJDMX_BJDHQCLCB,XLXSBJDMX_CLCB,XLXSBJDMX_JGBJJ,XLXSBJDMX_JGBBJ,XLXSBJDMX_JGBBJGXSJ,XLXSBJDMX_LSJGBBJ,XLXSBJDMX_JMBGS,XLXSBJDMX_CJ,"); SQL.Add(" TZYZ_BJ01,TZYZ_BJ02,TZYZ_BJ03,TZYZ_BJ04,TZYZ_BJ05,"); SQL.Add(" TZYZ_BJ06,TZYZ_BJ07,TZYZ_BJ08,TZYZ_BJ09,TZYZ_BJ10,"); SQL.Add(" TZYZ_BJ11,TZYZ_BJ12,TZYZ_BJ13,TZYZ_BJ14,TZYZ_BJ15,"); SQL.Add(" TZYZ_BJ16,TZYZ_BJ17,TZYZ_BJ18,TZYZ_BJ19,TZYZ_BJ20,"); if (!sXSYZJEFilter.Trim().Equals(""))//SQL语句自测：刘青棚 2025/03/27 18:00:00 { foreach (string sYZID in sXSYZJEFilter.Split(',')) { if (XLBJDUtils.GetYZXXByYZID(sYZID.Trim()).XLXSTZYZ_JJFS == "JJ") { SQL.Add(" RoundFix(TZYZ_" + sYZID + " * XLXSBJDMX_BJSL,2) as TZYZJE_" + sYZID + ","); } else { SQL.Add(" RoundFix(XLXSBJDMX_JGBBJ * " + XLBJDUtils.sCJXS + " * TZYZ_" + sYZID + "/100.0 * XLXSBJDMX_BJSL,2) as TZYZJE_" + sYZID + ","); } } } SQL.Add(" XLXSBJDMX_TZQCPBJ,XLXSBJDMX_TZCPBJ,XLXSBJDMX_CPBJ,XLXSBJDMX_TZQBJJE,XLXSBJDMX_TZBJJE,XLXSBJDMX_BJJE,XLXSBJDMX_PJJE,"); SQL.Add(" TZHDJ, XLXSBJDMX_YXJG,XLXSBJDMX_CLZL,XLXSBJDMX_YXJJCL,XLXSBJDMX_JGBBJLJJCL,XLXSBJDMX_CLCBJCL,XLXSBJDMX_JGBBJJCL,XLXSBJDMX_JGBBJJCE,"); SQL.Add(" XLXSBJDMX_TZQZDXJ,XLXSBJDMX_TZZDXJ,XLXSBJDMX_ZDXJ,RoundFix(XLXSBJDMX_ZDXJ*XLXSBJDMX_BJSL,2) as XLXSBJDMX_ZDXJJE,XLXSBJDMX_ZDXJJCL,XLXSBJDMX_JSJG,XLXSBJDMX_JSJJE,XLXSBJDMX_JSJJCL,XLXSBJDMX_YSCP,XLXSBJDMX_KHWLID,XLXSBJDMX_YZ,XLXSBJDMX_FBH,"); SQL.Add(" XLXSBJDMX_CPBJXJ,XLXSBJDMX_BJXJKD,XLXSBJDMX_BJXJJJ,XJBJCE,XLXSBJDMX_BJJEXJ,XLXSBJDMX_BZ,XLXSBJDMX_BJCPSD,XLXSBJDMX_BJSDBZ,XLXSBJDMX_CLCBJCLSDBZ, "); SQL.Add(" WLXX,XLXSBJDMX_ZB,XLXSBJDMX_ZBSL,XLXSBJDMX_ZBJE,XLXSBJDMX_WHRID,XLXSBJDMX_WHR,XLXSBJDMX_WHSJ, "); SQL.Add(" HasCLQD,HasYLDZSQ,UpdJJYZList,XLXSBJDMX_BJLY,XLXSBJDMX_BJTJCZ,'N' as PFYSQKBZ,HasFDJL,XLXSBJDMX_DZSC,XLXSBJDMX_BJDHQCLCBTZ, "); SQL.Add(" XLXSBJDMX_ZDXJBJDID,XLXSBJDMX_ZDXJBJDXH,XLXSBJDMX_XDXLBZID,XLXSBJDMX_XDXLXHID,XLXSBJDMX_JGBBJTZ,BZTXYS,CPCF,CPSLCF,GGSLCF,XLXSBJDMX_JGFBZ,YLZDYXTZ,TCLYLBL,LCLYLBL,LHJCLYLBL, "); SQL.Add(" XLGGB_XLGGDW"); SQL.Add(" from"); SQL.Add(" ("); SQL.Add(" select ROW_NUMBER()over(order by XLXSBJDMX_XSSX,XLXSBJDMX_XH) as RNum,"); SQL.Add(" XLXSBJDMX_BJDID,XLXSBJDMX_XH, XLXSBJDMX_XH as OLD_XLXSBJDMX_XH,XLXSBJDMX_XSSX, XLXSBJDMX_XLXHID, XLXSBJDMX_XLGGID, "); SQL.Add(" rtrim(XLXSBJDMX_XLBZID)||'|'||rtrim(XLXSBJDMX_XLBZID)||'|'||rtrim(XLBZ_XLBZLXMC) as XLXSBJDMX_XLBZID,XLBZ_XLBZMS,XLXSBJDMX_DYDJID,"); SQL.Add(" rtrim(XLXSBJDMX_XLYSID)||'|'||rtrim(XLYSB_XLYSMC) as XLXSBJDMX_XLYSID, "); if (XLBJDUtils.GetXLXSBJPZXX(100860000).XLXSBJPZ_XSZBXX == "Y") SQL.Add(" case when isnull(XLXSBJDMX_WLID,' ')=' ' then XLXSBJDFKMX_WLID else XLXSBJDMX_WLID end as XLXSBJDMX_WLID,"); else SQL.Add(" XLXSBJDMX_WLID,"); SQL.Add(" XLXSBJDMX_ZHCPMLMC,XLXSBJDMX_CPMLMC,case "); SQL.Add(" (case when ISNULL(A.XLXSBJXHML_CPMLID,' ') = ' ' then ISNULL(B.XLXSBJXHML_CPMLID,' ') else ISNULL(A.XLXSBJXHML_CPMLID,' ') end) "); SQL.Add(" when ' ' then ' ' else "); SQL.Add(" rtrim(case when ISNULL(A.XLXSBJXHML_CPMLID,' ') = ' ' then ISNULL(B.XLXSBJXHML_CPMLID,' ') else ISNULL(A.XLXSBJXHML_CPMLID,' ') end) || '|'|| rtrim(XLXSCPML_CPMLMC) end as HasCPMLID, "); SQL.Add(" XLXSBJDMX_BJCP,XLXSBJDMX_GYKH,XLXSBJDMX_PWQDID,XLXSBJDMX_PWQDWLMC,XLXSBJDMX_PWQDMS,' ' as XLWLXX,"); SQL.Add(" ISNULL(XLXSBJDMX_WGCPBZ,'N') as XLXSBJDMX_WGCPBZ,XLXSBJDMX_JLDW,XLXSBJDMX_BJSL,XLXSBJDMX_BJDHQCLCB,XLXSBJDMX_CLCB,XLXSBJDMX_JGBJJ,XLXSBJDMX_JGBBJ,XLXSBJDMX_JGBBJGXSJ,XLXSBJDMX_LSJGBBJ,XLXSBJDMX_JMBGS,XLXSBJDMX_CJ,"); SQL.Add(" XLXSBJDYZZ0_YZZ01 as TZYZ_BJ01,XLXSBJDYZZ0_YZZ02 as TZYZ_BJ02,XLXSBJDYZZ0_YZZ03 as TZYZ_BJ03,XLXSBJDYZZ0_YZZ04 as TZYZ_BJ04,XLXSBJDYZZ0_YZZ05 as TZYZ_BJ05,"); SQL.Add(" XLXSBJDYZZ0_YZZ06 as TZYZ_BJ06,XLXSBJDYZZ0_YZZ07 as TZYZ_BJ07,XLXSBJDYZZ0_YZZ08 as TZYZ_BJ08,XLXSBJDYZZ0_YZZ09 as TZYZ_BJ09,XLXSBJDYZZ0_YZZ10 as TZYZ_BJ10,"); SQL.Add(" XLXSBJDYZZ0_YZZ11 as TZYZ_BJ11,XLXSBJDYZZ0_YZZ12 as TZYZ_BJ12,XLXSBJDYZZ0_YZZ13 as TZYZ_BJ13,XLXSBJDYZZ0_YZZ14 as TZYZ_BJ14,XLXSBJDYZZ0_YZZ15 as TZYZ_BJ15,"); SQL.Add(" XLXSBJDYZZ0_YZZ16 as TZYZ_BJ16,XLXSBJDYZZ0_YZZ17 as TZYZ_BJ17,XLXSBJDYZZ0_YZZ18 as TZYZ_BJ18,XLXSBJDYZZ0_YZZ19 as TZYZ_BJ19,XLXSBJDYZZ0_YZZ20 as TZYZ_BJ20,"); SQL.Add(" XLXSBJDMX_TZQCPBJ,XLXSBJDMX_TZCPBJ,XLXSBJDMX_CPBJ,XLXSBJDMX_TZQBJJE,XLXSBJDMX_TZBJJE,XLXSBJDMX_BJJE,"); SQL.Add(string.Format(" case when XLXSBJDMX_BJSL=0 then 0 else RoundFix(XLXSBJDMX_BJJE/XLXSBJDMX_BJSL,{0}) end as TZHDJ, XLXSBJDMX_YXJG,XLXSBJDMX_CLZL,XLXSBJDMX_YXJJCL,XLXSBJDMX_JGBBJLJJCL,XLXSBJDMX_CLCBJCL,XLXSBJDMX_JGBBJJCL,XLXSBJDMX_JGBBJJCE,",iXSWS.ToString())); SQL.Add(" XLXSBJDMX_TZQZDXJ,XLXSBJDMX_TZZDXJ,XLXSBJDMX_ZDXJ,XLXSBJDMX_ZDXJJCL,XLXSBJDMX_JSJG,XLXSBJDMX_JSJJE,XLXSBJDMX_JSJJCL,XLXSBJDMX_YSCP,XLXSBJDMX_KHWLID,XLXSBJDMX_YZ,XLXSBJDMX_FBH,"); SQL.Add(" XLXSBJDMX_CPBJXJ,XLXSBJDMX_BJXJKD,XLXSBJDMX_BJXJJJ,RoundFix(XLXSBJDMX_CPBJXJ-XLXSBJDMX_CPBJ,8) as XJBJCE,XLXSBJDMX_BJJEXJ,XLXSBJDMX_BZ,XLXSBJDMX_BJCPSD,XLXSBJDMX_BJSDBZ,XLXSBJDMX_PJJE,XLXSBJDMX_CLCBJCLSDBZ, "); if (XLBJDUtils.GetXLXSBJPZXX(100860000).XLXSBJPZ_XSZBXX == "Y") SQL.Add("case when isnull(WL_WLID,' ') <> ' ' then rtrim(rtrim(rtrim(rtrim(isnull(WL_MC,' '))||' '||rtrim(isnull(WL_GG,' ')))||' '||rtrim(isnull(WL_TZ,' ')))||' '||rtrim(isnull(WL_CL,' '))) else ' ' end as WLXX,"); else SQL.Add(" ' ' as WLXX,"); SQL.Add(" XLXSBJDMX_ZB,XLXSBJDMX_ZBSL,XLXSBJDMX_ZBJE,XLXSBJDMX_WHRID,XLXSBJDMX_WHR,XLXSBJDMX_WHSJ, "); SQL.Add(" case when isnull(XLXSCLQD_WPID,' ')='ZZZZ' then 'Y' else 'N' end as HasCLQD, "); SQL.Add(" case when ((ISNULL(XLXSBJYLZD_WPID,' ')= '0060' or ISNULL(XLXSBJYLZD_WPID,' ')= 'ZZZZ') and isnull(XLXSBJYLZDMX_BZDBZ,'N') ='Y' and isnull(XLXSBJYLZDMX_BJDXH,0) <> 0) then 'N' "); SQL.Add(" when (ISNULL(XLXSBJYLZD_WPID,' ')<> ' ' and isnull(XLXSBJYLZDMX_BJDXH,0) <> 0) then 'Y' "); SQL.Add(" else 'N' end as HasYLDZSQ, "); SQL.Add(" case when isnull(XLXSJGB_MXBH,' ')='JGB' then ' ' else "); for (int i = 1; i <= 20; i++) { string num = i.ToString("D2"); // 格式化为两位数字 "04", "05", ... string fieldName = "XLXSBJDJJYZ_YZZ" + num; if (i > 1) SQL.Add(" ||'|'|| "); SQL.Add(" rtrim(convert(char," + fieldName + ")) "); } SQL.Add(" ||'|'||rtrim(convert(char,XLXSBJDJJYZ_YSJDZ)) end as UpdJJYZList,XLXSBJDMX_BJLY,XLXSBJDMX_BJTJCZ,case when isnull(XLXSBJDMXFD_BJDID,' ') = ' ' then 'N' else 'Y' end as HasFDJL,"); SQL.Add(" XLXSBJDMX_DZSC,XLXSBJDMX_BJDHQCLCBTZ,XLXSBJDMX_ZDXJBJDID,XLXSBJDMX_ZDXJBJDXH,XLXSBJDMX_XDXLBZID,XLXSBJDMX_XDXLXHID,XLXSBJDMX_JGBBJTZ,isnull(XLXSBJBZTXS_TXS,' ') as BZTXYS,XLXSBJDMX_JGFBZ, "); if (!_sBZBJDIDFilter.Equals("")) { SQL.Add(" case when isnull(BZCPB.XLXHID,' ') = ' ' then 'N' else 'Y' end as CPCF,case when isnull(BZCPSLB.XLXHID,' ') = ' ' then 'N' else 'Y' end as CPSLCF,case when isnull(BZGGSLB.XLGGID,' ') = ' ' then 'N' else 'Y' end as GGSLCF "); } else { SQL.Add(" 'N' AS CPCF,'N' AS CPSLCF,'N' AS GGSLCF "); } if (XLBJDUtils.GetXLXSBJPZXX(100860064).XLXSBJPZ_YLZDMXTZ == "Y") { SQL.Add(", case when ( ISNULL(XLXSBJYLZD_WPID,' ')= '0010' and ( "); SQL.Add(" (XLXSBJYLZDMX_BJDXLXHID=XLXSBJYLZDMX_XLXHID and XLXSBJYLZDMX_BJDXLGGID=XLXSBJYLZDMX_XLGGID and XLXSBJYLZDMX_BJDXLBZID=XLXSBJYLZDMX_XLBZID and XLXSBJYLZDMX_BJDDYDJID=XLXSBJYLZDMX_DYDJID ) "); SQL.Add(" or ( isnull(XLXSBJYLZDMX_XLXHID,' ')=' ' and isnull(XLXSBJYLZDMX_XLGGID,' ')= ' ' and isnull(XLXSBJYLZDMX_XLBZID,' ') =' ' and isnull(XLXSBJYLZDMX_DYDJID,' ')=' ' ) "); SQL.Add(" ) ) then 'Y' else 'N' end as YLZDYXTZ "); } else { SQL.Add(" ,'N' as YLZDYXTZ "); } XLXSBJPZXX YLPZXX = XLBJDUtils.GetXLXSBJPZXX(100860014); if (!YLPZXX.XLXSBJPZ_TDTGSCLID.Equals("")) { SQL.Add(" ,case "); for (int i = 1; i <= 80; i++) { SQL.Add(" when '" + YLPZXX.XLXSBJPZ_TDTGSCLID.Trim() + ",' like '%' || rtrim(case when charindex('|',XLXSBJDCLCB_CLID" + i.ToString().PadLeft(2, '0') + ") > 0 then left(XLXSBJDCLCB_CLID" + i.ToString().PadLeft(2, '0') + ",charindex('|',XLXSBJDCLCB_CLID" + i.ToString().PadLeft(2, '0') + ")-1) else XLXSBJDCLCB_CLID" + i.ToString().PadLeft(2, '0') + " end) || ',%' then isnull(BJDCLYLBL_YLBL" + i.ToString().PadLeft(2, '0') + ",1) "); } SQL.Add(" else 1 end as TCLYLBL "); } else { SQL.Add(" ,1 as TCLYLBL "); } if (!YLPZXX.XLXSBJPZ_LBJCLID.Equals("")) { SQL.Add(" ,case "); for (int i = 1; i <= 80; i++) { SQL.Add(" when XLXSBJDCLCB_CLID" + i.ToString().PadLeft(2, '0') + " like '" + YLPZXX.XLXSBJPZ_LBJCLID + "%' then isnull(BJDCLYLBL_YLBL" + i.ToString().PadLeft(2, '0') + ",1) "); } SQL.Add(" else 1 end as LCLYLBL "); } else { SQL.Add(" ,1 as LCLYLBL "); } if (!YLPZXX.XLXSBJPZ_LHJBJCLID.Equals("")) { SQL.Add(" ,case "); for (int i = 1; i <= 80; i++) { SQL.Add(" when XLXSBJDCLCB_CLID" + i.ToString().PadLeft(2, '0') + " like '" + YLPZXX.XLXSBJPZ_LHJBJCLID + "%' then isnull(BJDCLYLBL_YLBL" + i.ToString().PadLeft(2, '0') + ",1) "); } SQL.Add(" else 1 end as LHJCLYLBL "); } else { SQL.Add(" ,1 as LHJCLYLBL "); } SQL.Add(" from XLXSBJDMX "); SQL.Add(" left join XLBZ on XLBZ_XLBZID = XLXSBJDMX_XLBZID "); if (XLBJDUtils.GetXLXSBJPZXX(100860000).XLXSBJPZ_XSZBXX == "Y") { SQL.Add(" left join XLXSBJDFKMX on XLXSBJDFKMX_BJDID = XLXSBJDMX_BJDID and XLXSBJDFKMX_XH=XLXSBJDMX_XH "); SQL.Add(" left join WL on WL_WLID = case when isnull(XLXSBJDMX_WLID,' ')=' ' then XLXSBJDFKMX_WLID else XLXSBJDMX_WLID end "); } SQL.Add(" left join XLYSB on XLYSB_XLYSID = XLXSBJDMX_XLYSID "); SQL.Add(" left join XLXSBJDYZZ0 on XLXSBJDYZZ0_BJDID=XLXSBJDMX_BJDID and XLXSBJDYZZ0_XH=XLXSBJDMX_XH "); SQL.Add(" left join XLXSBJDJJYZ on XLXSBJDJJYZ_BJDID=XLXSBJDMX_BJDID and XLXSBJDJJYZ_XH=XLXSBJDMX_XH "); SQL.Add(" left join XLXSBJD on XLXSBJD_BJDID=XLXSBJDMX_BJDID"); SQL.Add(" left join XLXSJGB on XLXSJGB_JGBID=XLXSBJD_JGBID"); SQL.Add(" left join XLXSCLQD on XLXSCLQD_XLXHID=XLXSBJDMX_XLXHID and XLXSCLQD_XLGGID=XLXSBJDMX_XLGGID and XLXSCLQD_XLBZID=XLXSBJDMX_XLBZID and XLXSCLQD_DYDJID=isnull(XLXSBJDMX_DYDJID,' ')"); SQL.Add(" left join ( select XLXSBJYLZD_BJDID,XLXSBJYLZD_SQDH,XLXSBJYLZD_WPID,XLXSBJYLZD_WFAWAITER, "); SQL.Add(" XLXSBJYLZDMX_BJDXH,XLXSBJYLZDMX_BZDBZ,XLXSBJYLZDMX_BJDXLXHID,XLXSBJYLZDMX_XLXHID,XLXSBJYLZDMX_BJDXLGGID,XLXSBJYLZDMX_XLGGID, "); SQL.Add(" XLXSBJYLZDMX_BJDXLBZID,XLXSBJYLZDMX_XLBZID,XLXSBJYLZDMX_BJDDYDJID,XLXSBJYLZDMX_DYDJID "); SQL.Add(" from XLXSBJYLZDMX "); SQL.Add(" left join XLXSBJYLZD on XLXSBJYLZD_SQDH = XLXSBJYLZDMX_SQDH "); SQL.Add(" where XLXSBJYLZD_BJDID = :XLXSBJDMX_BJDID ) YLZDMX on XLXSBJYLZD_BJDID = XLXSBJDMX_BJDID and XLXSBJYLZDMX_BJDXH = XLXSBJDMX_XH "); SQL.Add(" left join XLXSBJXHML A on A.XLXSBJXHML_XLXHID = XLXSBJDMX_XLXHID and A.XLXSBJXHML_DYDJID = isnull(XLXSBJDMX_DYDJID, ' ') "); SQL.Add(" left join XLXSBJXHML B on B.XLXSBJXHML_XLXHID = XLXSBJDMX_XLXHID and B.XLXSBJXHML_DYDJID = ' ' "); SQL.Add(" left join XLXSCPML on XLXSCPML_CPMLID = case when ISNULL(A.XLXSBJXHML_CPMLID,' ') = ' ' then ISNULL(B.XLXSBJXHML_CPMLID,' ') else ISNULL(A.XLXSBJXHML_CPMLID,' ') end "); SQL.Add(" left join XLXSBJDMXFD on XLXSBJDMXFD_BJDID = XLXSBJDMX_BJDID and XLXSBJDMXFD_BJDXH = XLXSBJDMX_XH "); SQL.Add(" left join XLXSBJBZTXS on XLXSBJBZTXS_XLBZID = XLXSBJDMX_XLBZID "); SQL.Add(" left join XLXSBJXLGGTHB on XLXSBJXLGGTHB_XLGGID = XLXSBJDMX_XLGGID "); if (!YLPZXX.XLXSBJPZ_TDTGSCLID.Equals("") || !YLPZXX.XLXSBJPZ_LBJCLID.Equals("") || !YLPZXX.XLXSBJPZ_LHJBJCLID.Equals("")) { SQL.Add(" left join XLXSBJDCLCB on XLXSBJDCLCB_BJDID = XLXSBJDMX_BJDID and XLXSBJDCLCB_XH = XLXSBJDMX_XH "); SQL.Add(" left join BJDCLYLBL on BJDCLYLBL_BJDID = XLXSBJDMX_BJDID and BJDCLYLBL_XH = XLXSBJDMX_XH "); } if (!_sBZBJDIDFilter.Equals("")) { string sBZYJ = "XLXSBJDMX_XLBZID"; SQL.Add(" left join (select XLXHID,XLGGID,DYDJID,XLBZID "); SQL.Add(" from "); SQL.Add(" (select XLXSBJDMX_XLXHID as XLXHID,XLXSBJDMX_XLGGID as XLGGID,XLXSBJDMX_DYDJID as DYDJID, "); if (sCPCFXLBZ.Trim().Equals("")) SQL.Add(" XLXSBJDMX_XLBZID as XLBZID "); else { sBZYJ = " case XLXSBJDMX_XLBZID "; for (int i = 0; i < sCPCFXLBZ.Split(',').Length; i++) { sBZYJ += string.Format(" when '{0}' then '{1}' ", sCPCFXLBZ.Split(',')[i], sCPCFXLBZ.Split(',')[0]); } sBZYJ += " else XLXSBJDMX_XLBZID end "; SQL.Add(sBZYJ); SQL.Add(" as XLBZID "); } SQL.Add(" from XLXSBJDMX where XLXSBJDMX_BJDID = :pBZBJDID )tmpA group by XLXHID,XLGGID,XLBZID,DYDJID ) BZCPB "); SQL.Add(" on XLXSBJDMX_XLXHID = BZCPB.XLXHID and XLXSBJDMX_XLGGID = BZCPB.XLGGID and ("+sBZYJ+") = BZCPB.XLBZID and XLXSBJDMX_DYDJID = BZCPB.DYDJID "); SQL.Add(" left join (select XLXHID,XLGGID,DYDJID,XLBZID,BJSL,JLDW "); SQL.Add(" from "); SQL.Add(" (select XLXSBJDMX_XLXHID as XLXHID,XLXSBJDMX_XLGGID as XLGGID," + sBZYJ + " as XLBZID,XLXSBJDMX_DYDJID as DYDJID, XLXSBJDMX_BJSL as BJSL, XLXSBJDMX_JLDW AS JLDW "); SQL.Add(" from XLXSBJDMX where XLXSBJDMX_BJDID = :pBZBJDID) tmpB group by XLXHID,XLGGID,DYDJID,XLBZID,BJSL,JLDW ) BZCPSLB "); SQL.Add(" on XLXSBJDMX_XLXHID = BZCPSLB.XLXHID and XLXSBJDMX_XLGGID = BZCPSLB.XLGGID and (" + sBZYJ + ") = BZCPSLB.XLBZID "); SQL.Add(" and XLXSBJDMX_DYDJID = BZCPSLB.DYDJID and XLXSBJDMX_BJSL = BZCPSLB.BJSL and XLXSBJDMX_JLDW = BZCPSLB.JLDW "); SQL.Add(" left join (select XLGGID,BZBJSL "); SQL.Add(" from "); SQL.Add(" (select XLXSBJDMX_XLGGID as XLGGID, (case when XLXSBJDMX_JLDW='Km' then XLXSBJDMX_BJSL*1000 else XLXSBJDMX_BJSL end) as BZBJSL "); SQL.Add(" from XLXSBJDMX where XLXSBJDMX_BJDID = :pBZBJDID and isnull(XLXSBJDMX_YWLX,' ')= ' ') tmpC group by XLGGID,BZBJSL ) BZGGSLB "); SQL.Add(" on XLXSBJDMX_XLGGID = BZGGSLB.XLGGID and (case when XLXSBJDMX_JLDW='Km' then XLXSBJDMX_BJSL*1000 else XLXSBJDMX_BJSL end) = BZGGSLB.BZBJSL "); SQL.ParamByName("pBZBJDID").Value = _sBZBJDIDFilter.Trim(); } SQL.Add(" where XLXSBJDMX_BJDID = :XLXSBJDMX_BJDID "); if (!_sXSSXFilter.Equals("")) { SQL.Add(" and XLXSBJDMX_XSSX=:pXSSX"); SQL.AddParam("pXSSX", TGtdbType.Float, 0, CMISproConvert.StrToFloat(_sXSSXFilter, 0)); } if (!_sXLXHIDFilter.Equals("")) { string sQueryTag = "E"; string sFirstC = _sXLXHIDFilter.Substring(0, 1); string sLastC = _sXLXHIDFilter.Substring(_sXLXHIDFilter.Length - 1, 1); if (sFirstC.Equals("%")) { sQueryTag = "L"; if (sLastC.Equals("%")) sQueryTag = "A"; } else { if (sLastC.Equals("%")) sQueryTag = "R"; } if (sQueryTag.Equals("E")) { SQL.Add(" and XLXSBJDMX_XLXHID=:pXLXHID"); } else { SQL.Add(" and XLXSBJDMX_XLXHID like :pXLXHID"); } SQL.AddParam("pXLXHID", TGtdbType.VarChar, 40, _sXLXHIDFilter); } if (!_sXLGGIDFilter.Equals("")) { if (_sXLGGIDFilter.Split('-').Length > 1) { string sStartNum = _sXLGGIDFilter.Split('-')[0]; string sEndNum = _sXLGGIDFilter.Split('-')[1]; double dStartNum = CMISproConvert.StrToFloat(sStartNum, 0); double dEndNum = CMISproConvert.StrToFloat(sEndNum, 0); SQL.Add(@" and exists(select 1 from XLGGB left join XLDTJMZHB on XLDTJMZHB_DTJMZHID=XLGGB_DTJMZHID where XLGGB_XLGGID=XLXSBJXLGGTHB_XLGGIDCH and XLDTJMZHB_DTJM1>=:pStartNum "); if (dEndNum != 0) { SQL.Add(" and XLDTJMZHB_DTJM1<=:pEndNum "); SQL.AddParam("pEndNum", TGtdbType.Float,0,dEndNum); } SQL.Add(")"); SQL.AddParam("pStartNum", TGtdbType.Float,0, dStartNum); } else { string sQueryTag = "E"; string sFirstC = _sXLGGIDFilter.Substring(0, 1); string sLastC = _sXLGGIDFilter.Substring(_sXLGGIDFilter.Length - 1, 1); if (sFirstC.Equals("%")) { sQueryTag = "L"; if (sLastC.Equals("%")) sQueryTag = "A"; } else { if (sLastC.Equals("%")) sQueryTag = "R"; } if (sQueryTag.Equals("E")) { SQL.Add(" and XLXSBJDMX_XLGGID=:pXLGGID"); } else { SQL.Add(" and XLXSBJDMX_XLGGID like :pXLGGID"); } SQL.AddParam("pXLGGID", TGtdbType.VarChar, 60, _sXLGGIDFilter); } } if (!_sXLBZIDFilter.Equals("")) { string sQueryTag = "E"; string sFirstC = _sXLBZIDFilter.Substring(0, 1); string sLastC = _sXLBZIDFilter.Substring(_sXLBZIDFilter.Length - 1, 1); if (sFirstC.Equals("%")) { sQueryTag = "L"; if (sLastC.Equals("%")) sQueryTag = "A"; } else { if (sLastC.Equals("%")) sQueryTag = "R"; } if (sQueryTag.Equals("E")) { SQL.Add(" and ( XLXSBJDMX_XLBZID=:pXLBZID or XLBZ_XLBZLXMC=:pXLBZMC )"); } else { SQL.Add(" and ( XLXSBJDMX_XLBZID like :pXLBZID or XLBZ_XLBZLXMC like :pXLBZMC )"); } SQL.AddParam("pXLBZID", TGtdbType.VarChar, 10, _sXLBZIDFilter); SQL.AddParam("pXLBZMC", TGtdbType.VarChar, 60, _sXLBZIDFilter); } if (!_sDYDJIDFilter.Equals("")) { string sQueryTag = "E"; string sFirstC = _sDYDJIDFilter.Substring(0, 1); string sLastC = _sDYDJIDFilter.Substring(_sDYDJIDFilter.Length - 1, 1); if (sFirstC.Equals("%")) { sQueryTag = "L"; if (sLastC.Equals("%")) sQueryTag = "A"; } else { if (sLastC.Equals("%")) sQueryTag = "R"; } if (sQueryTag.Equals("E")) { SQL.Add(" and XLXSBJDMX_DYDJID=:pDYDJID"); } else { SQL.Add(" and XLXSBJDMX_DYDJID like :pDYDJID"); } SQL.AddParam("pDYDJID", TGtdbType.VarChar, 20, _sDYDJIDFilter); } if (!_sXLYSIDFilter.Equals("")) { string sQueryTag = "E"; string sFirstC = _sXLYSIDFilter.Substring(0, 1); string sLastC = _sXLYSIDFilter.Substring(_sXLYSIDFilter.Length - 1, 1); if (sFirstC.Equals("%")) { sQueryTag = "L"; if (sLastC.Equals("%")) sQueryTag = "A"; } else { if (sLastC.Equals("%")) sQueryTag = "R"; } if (sQueryTag.Equals("E")) { SQL.Add(" and ( XLXSBJDMX_XLYSID=:pXLYSID or XLYSB_XLYSMC=:pXLYSMC )"); } else { SQL.Add(" and ( XLXSBJDMX_XLYSID like :pXLYSID or XLYSB_XLYSMC like :pXLYSMC )"); } SQL.AddParam("pXLYSID", TGtdbType.VarChar, 10, _sXLYSIDFilter); SQL.AddParam("pXLYSMC", TGtdbType.VarChar, 40, _sXLYSIDFilter); } if (!_sBJCPFilter.Equals("")) { string sQueryTag = "E"; string sFirstC = _sBJCPFilter.Substring(0, 1); string sLastC = _sBJCPFilter.Substring(_sBJCPFilter.Length - 1, 1); if (sFirstC.Equals("%")) { sQueryTag = "L"; if (sLastC.Equals("%")) sQueryTag = "A"; } else { if (sLastC.Equals("%")) sQueryTag = "R"; } if (sQueryTag.Equals("E")) { SQL.Add(" and XLXSBJDMX_BJCP=:pBJCP"); } else { SQL.Add(" and XLXSBJDMX_BJCP like :pBJCP"); } SQL.AddParam("pBJCP", TGtdbType.VarChar, 150, _sBJCPFilter); } if (!_sJGBBJFilter.Equals("")) { SQL.Add(" and XLXSBJDMX_JGBBJ=:pJGBBJ"); SQL.ParamByName("pJGBBJ").Value = CMISproConvert.StrToFloat(_sJGBBJFilter); } if (!_sZDXJJCLFilter.Equals("")) { string tmpZDXJJCL = _sZDXJJCLFilter.Replace(">=","").Replace(">","").Replace("<=","").Replace("<","").Replace("=",""); double dZDXJJCL = CMISproConvert.StrToFloat(tmpZDXJJCL, -999); if (dZDXJJCL == -999) { SQL.Add(" and XLXSBJDMX_ZDXJJCL=:pZDXJJCL"); SQL.ParamByName("pZDXJJCL").Value = dZDXJJCL; } else if (sZDXJJCLFilter.StartsWith(">=")) { SQL.Add(" and XLXSBJDMX_ZDXJJCL>=:pZDXJJCL"); SQL.ParamByName("pZDXJJCL").Value = dZDXJJCL; } else if (sZDXJJCLFilter.StartsWith(">")) { SQL.Add(" and XLXSBJDMX_ZDXJJCL>:pZDXJJCL"); SQL.ParamByName("pZDXJJCL").Value = dZDXJJCL; } else if (sZDXJJCLFilter.StartsWith("<=")) { SQL.Add(" and XLXSBJDMX_ZDXJJCL<=:pZDXJJCL"); SQL.ParamByName("pZDXJJCL").Value = dZDXJJCL; } else if (sZDXJJCLFilter.StartsWith("<")) { SQL.Add(" and XLXSBJDMX_ZDXJJCL<:pZDXJJCL"); SQL.ParamByName("pZDXJJCL").Value = dZDXJJCL; } else if (sZDXJJCLFilter.StartsWith("=")) { SQL.Add(" and XLXSBJDMX_ZDXJJCL=:pZDXJJCL"); SQL.ParamByName("pZDXJJCL").Value = dZDXJJCL; } else { SQL.Add(" and XLXSBJDMX_ZDXJJCL=:pZDXJJCL"); SQL.ParamByName("pZDXJJCL").Value = dZDXJJCL; } } if (!_sCPMLFilter.Equals("")) { if (_sCPMLFilter.Equals("空")) { SQL.Add(" and isnull(XLXSBJDMX_CPMLMC,' ')=' '"); } else { string sQueryTag = "E"; string sFirstC = _sCPMLFilter.Substring(0, 1); string sLastC = _sCPMLFilter.Substring(_sCPMLFilter.Length - 1, 1); if (sFirstC.Equals("%")) { sQueryTag = "L"; if (sLastC.Equals("%")) sQueryTag = "A"; } else { if (sLastC.Equals("%")) sQueryTag = "R"; } if (sQueryTag.Equals("E")) { SQL.Add(" and XLXSBJDMX_CPMLMC=:pCPMLMC"); } else { SQL.Add(" and XLXSBJDMX_CPMLMC like :pCPMLMC"); } SQL.AddParam("pCPMLMC", TGtdbType.VarChar, 150, _sCPMLFilter); } } if (!_sZHCPMLFilter.Equals("")) { if (_sZHCPMLFilter.Equals("空")) { SQL.Add(" and isnull(XLXSBJDMX_ZHCPMLMC,' ')=' '"); } else { string sQueryTag = "E"; string sFirstC = _sZHCPMLFilter.Substring(0, 1); string sLastC = _sZHCPMLFilter.Substring(_sZHCPMLFilter.Length - 1, 1); if (sFirstC.Equals("%")) { sQueryTag = "L"; if (sLastC.Equals("%")) sQueryTag = "A"; } else { if (sLastC.Equals("%")) sQueryTag = "R"; } if (sQueryTag.Equals("E")) { SQL.Add(" and XLXSBJDMX_ZHCPMLMC=:pZHCPMLMC"); } else { SQL.Add(" and XLXSBJDMX_ZHCPMLMC like :pZHCPMLMC"); } SQL.AddParam("pZHCPMLMC", TGtdbType.VarChar, 150, _sZHCPMLFilter); } } if (!_sBZFilter.Equals("")) { string sQueryTag = "E"; string sFirstC = _sBZFilter.Substring(0, 1); string sLastC = _sBZFilter.Substring(_sBZFilter.Length - 1, 1); if (sFirstC.Equals("%")) { sQueryTag = "L"; if (sLastC.Equals("%")) sQueryTag = "A"; } else { if (sLastC.Equals("%")) sQueryTag = "R"; } if (sQueryTag.Equals("E")) { SQL.Add(" and XLXSBJDMX_BZ=:pBZ"); } else { SQL.Add(" and XLXSBJDMX_BZ like :pBZ"); } SQL.AddParam("pBZ", TGtdbType.VarChar, 250, _sBZFilter); } SQL.Add(" ) BJD"); SQL.Add(" left join XLXHB on XLXHB_XLXHID = XLXSBJDMX_XLXHID "); SQL.Add(" left join XLXSBJXLGGTHB on XLXSBJXLGGTHB_XLGGID = XLXSBJDMX_XLGGID "); SQL.Add(" left join XLGGB on XLGGB_XLGGID = XLXSBJXLGGTHB_XLGGIDCH and XLGGB_XLGGJDGZ = XLXHB_XLGGJDGZ "); SQL.Add(" where 1=1"); if (_curPageIndex > 0) { SQL.Add(" and RNum>=:pStartRow"); SQL.Add(" and RNum<=:pEndRow"); } SQL.Add(" order by RNum "); SQL.AddParam("XLXSBJDMX_BJDID", TGtdbType.VarChar, 20, _BJDID); if (_curPageIndex > 0) { SQL.AddParam("pStartRow", TGtdbType.Float, 0, _curPageSize * (_curPageIndex - 1) + 1); SQL.AddParam("pEndRow", TGtdbType.Float, 0, _curPageSize * _curPageIndex); } //增加where条件以及参数的赋值 return SQL; } public override TSQL SetInsertSql() { TSQL SQL = base.SetInsertSql(); SQL.Add("insert into XLXSBJDMX(XLXSBJDMX_BJDID, XLXSBJDMX_XH, XLXSBJDMX_XSSX, XLXSBJDMX_XLXHID, XLXSBJDMX_XLGGID, XLXSBJDMX_XLBZID,XLXSBJDMX_DYDJID,XLXSBJDMX_XLYSID,XLXSBJDMX_WLID,"); SQL.Add("XLXSBJDMX_ZHCPMLMC,XLXSBJDMX_CPMLMC,XLXSBJDMX_BJCP,XLXSBJDMX_GYKH,XLXSBJDMX_PWQDID,XLXSBJDMX_PWQDWLMC,XLXSBJDMX_PWQDMS,XLXSBJDMX_WGCPBZ,XLXSBJDMX_JLDW,XLXSBJDMX_BJSL,XLXSBJDMX_JGBBJ,XLXSBJDMX_JGBBJGXSJ,XLXSBJDMX_LSJGBBJ,XLXSBJDMX_JMBGS,XLXSBJDMX_CJ,XLXSBJDMX_TZQCPBJ,XLXSBJDMX_TZCPBJ,XLXSBJDMX_CPBJ,XLXSBJDMX_TZQBJJE,XLXSBJDMX_TZBJJE,"); SQL.Add("XLXSBJDMX_BJJE,XLXSBJDMX_PJJE,XLXSBJDMX_JGBJJ,XLXSBJDMX_CLCB,XLXSBJDMX_JGBBJLJJCL,XLXSBJDMX_JGBBJJCL,XLXSBJDMX_JGBBJJCE,XLXSBJDMX_YXJG,XLXSBJDMX_CLZL,XLXSBJDMX_YXJJCL,XLXSBJDMX_BJDHQCLCB,XLXSBJDMX_CLCBJCL,XLXSBJDMX_BJCPSD,"); SQL.Add("XLXSBJDMX_BJSDBZ,XLXSBJDMX_CLCBJCLSDBZ,XLXSBJDMX_TZQZDXJ,XLXSBJDMX_TZZDXJ,XLXSBJDMX_ZDXJ,XLXSBJDMX_ZDXJJCL,XLXSBJDMX_JSJG,XLXSBJDMX_JSJJE,XLXSBJDMX_JSJJCL,XLXSBJDMX_YSCP,XLXSBJDMX_KHWLID,XLXSBJDMX_YZ,XLXSBJDMX_FBH,XLXSBJDMX_CPBJXJ,XLXSBJDMX_BJXJKD,XLXSBJDMX_BJXJJJ,XLXSBJDMX_BJJEXJ,XLXSBJDMX_BZ,XLXSBJDMX_BJLY,XLXSBJDMX_BJTJCZ,XLXSBJDMX_DZSC,"); SQL.Add("XLXSBJDMX_BJDHQCLCBTZ,XLXSBJDMX_ZDXJBJDID,XLXSBJDMX_ZDXJBJDXH,XLXSBJDMX_XDXLBZID,XLXSBJDMX_XDXLXHID,XLXSBJDMX_JGBBJTZ,XLXSBJDMX_JGFBZ,XLXSBJDMX_WHRID,XLXSBJDMX_WHR,XLXSBJDMX_WHSJ) "); SQL.Add("values(:XLXSBJDMX_BJDID, :XLXSBJDMX_XH, :XLXSBJDMX_XSSX, :XLXSBJDMX_XLXHID,:XLXSBJDMX_XLGGID,:XLXSBJDMX_XLBZID,isnull(:XLXSBJDMX_DYDJID,' '),:XLXSBJDMX_XLYSID,:XLXSBJDMX_WLID,"); SQL.Add(":XLXSBJDMX_ZHCPMLMC,:XLXSBJDMX_CPMLMC,:XLXSBJDMX_BJCP,:XLXSBJDMX_GYKH,:XLXSBJDMX_PWQDID,:XLXSBJDMX_PWQDWLMC,:XLXSBJDMX_PWQDMS,:XLXSBJDMX_WGCPBZ,:XLXSBJDMX_JLDW, isnull(:XLXSBJDMX_BJSL,0),isnull(:XLXSBJDMX_JGBBJ,0),:XLXSBJDMX_JGBBJGXSJ,isnull(:XLXSBJDMX_LSJGBBJ,0),:XLXSBJDMX_JMBGS,isnull(:XLXSBJDMX_CJ,0),isnull(:XLXSBJDMX_TZQCPBJ,0),isnull(:XLXSBJDMX_TZCPBJ,0),"); SQL.Add("isnull(:XLXSBJDMX_CPBJ,0),isnull(:XLXSBJDMX_TZQBJJE,0),isnull(:XLXSBJDMX_TZBJJE,0),isnull(:XLXSBJDMX_BJJE,0),isnull(:XLXSBJDMX_PJJE,0),isnull(:XLXSBJDMX_JGBJJ,0),isnull(:XLXSBJDMX_CLCB,0),isnull(:XLXSBJDMX_JGBBJLJJCL,0),isnull(:XLXSBJDMX_JGBBJJCL,0),"); SQL.Add("isnull(:XLXSBJDMX_JGBBJJCE,0), isnull(:XLXSBJDMX_YXJG,0),isnull(:XLXSBJDMX_CLZL,0),isnull(:XLXSBJDMX_YXJJCL,0),isnull(:XLXSBJDMX_BJDHQCLCB,0),isnull(:XLXSBJDMX_CLCBJCL,0),ISNULL(:XLXSBJDMX_BJCPSD,'N'),"); SQL.Add("ISNULL(:XLXSBJDMX_BJSDBZ,'N'),ISNULL(:XLXSBJDMX_CLCBJCLSDBZ,'N'),isnull(:XLXSBJDMX_TZQZDXJ,0),isnull(:XLXSBJDMX_TZZDXJ,0),isnull(:XLXSBJDMX_ZDXJ,0),isnull(:XLXSBJDMX_ZDXJJCL,0),isnull(:XLXSBJDMX_JSJG,0),isnull(:XLXSBJDMX_JSJJE,0),isnull(:XLXSBJDMX_JSJJCL,0),:XLXSBJDMX_YSCP,:XLXSBJDMX_KHWLID,:XLXSBJDMX_YZ,"); SQL.Add(":XLXSBJDMX_FBH,:XLXSBJDMX_CPBJXJ,:XLXSBJDMX_BJXJKD,:XLXSBJDMX_BJXJJJ,:XLXSBJDMX_BJJEXJ,:XLXSBJDMX_BZ,:XLXSBJDMX_BJLY,:XLXSBJDMX_BJTJCZ,:XLXSBJDMX_DZSC,:XLXSBJDMX_BJDHQCLCBTZ,:XLXSBJDMX_ZDXJBJDID,:XLXSBJDMX_ZDXJBJDXH,:XLXSBJDMX_XDXLBZID,:XLXSBJDMX_XDXLXHID,isnull(:XLXSBJDMX_JGBBJTZ,0),:XLXSBJDMX_JGFBZ,:XLXSBJDMX_WHRID,:XLXSBJDMX_WHR,:XLXSBJDMX_WHSJ) "); //SQL.ParamByName("XH").Value = CMISproDataBase.GetMaxXH("DBERP", "XLXSBJDMX", "XLXSBJDMX_XH", string.Format("XLXSBJDMX_BJDID='{0}'", BJDID)) + 1; OLD_XLXSBJDMX_XH = XLXSBJDMX_XH; return SQL; } public override bool Inserting(TSQL sql) { SetNullToZero(); SetField("XLXSBJDMX_BJDID", _BJDID); if (XLXSBJDMX_XSSX.Equals("0")) { XLXSBJDMX_XSSX = GetNewNo(_BJDID, "XLXSBJDMX_XSSX").ToString(); } if (XLXSBJDMX_XH.Equals("0")) { XLXSBJDMX_XH = GetNewNo(_BJDID, "XLXSBJDMX_XH").ToString(); } //if (GetField("XLXSBJDMX_XH").ToString().Trim().Equals("0")) //{ // WarningMsg = "明细数据序号不允许为空！"; // return false; //} if (GetField("XLXSBJDMX_XLXHID").ToString().Trim().Equals("")) { WarningMsg = "型号不允许为空！"; return false; } if (GetField("XLXSBJDMX_XLGGID").ToString().Trim().Equals("")) { WarningMsg = "规格不允许为空！"; return false; } if (GetField("XLXSBJDMX_XLBZID").ToString().Trim().Equals(" ")) { SetField("XLXSBJDMX_XLBZID", ""); } if (GetField("XLXSBJDMX_DYDJID").ToString().Trim().Equals(" ")) { SetField("XLXSBJDMX_DYDJID", ""); } if (GetField("XLXSBJDMX_XLYSID").ToString().Trim().Contains("|")) { SetField("XLXSBJDMX_XLYSID", GetField("XLXSBJDMX_XLYSID").ToString().Trim().Split('|')[0]); } if (CMISproConvert.StrToFloat(GetField("XLXSBJDMX_BJSL").ToString().Trim(), 0) < 0) { WarningMsg = "报价数量不允许小于0！"; return false; } return base.Inserting(sql); } public override bool Inserted(TSQL sql) { TDatabase dberp = TContextDatabases.GetDatabase("DBERP"); sql.Clear(); sql.Add("insert into XLXSBJDYZZ0(XLXSBJDYZZ0_BJDID,XLXSBJDYZZ0_XH,XLXSBJDYZZ0_YZZ01,XLXSBJDYZZ0_YZZ02,XLXSBJDYZZ0_YZZ03,XLXSBJDYZZ0_YZZ04,"); sql.Add(" XLXSBJDYZZ0_YZZ05,XLXSBJDYZZ0_YZZ06,XLXSBJDYZZ0_YZZ07,XLXSBJDYZZ0_YZZ08,XLXSBJDYZZ0_YZZ09,XLXSBJDYZZ0_YZZ10,"); sql.Add(" XLXSBJDYZZ0_YZZ11,XLXSBJDYZZ0_YZZ12,XLXSBJDYZZ0_YZZ13,XLXSBJDYZZ0_YZZ14,"); sql.Add(" XLXSBJDYZZ0_YZZ15,XLXSBJDYZZ0_YZZ16,XLXSBJDYZZ0_YZZ17,XLXSBJDYZZ0_YZZ18,XLXSBJDYZZ0_YZZ19,XLXSBJDYZZ0_YZZ20)"); sql.Add(" values(:pBJDID,:pBJDXH,:pYZZ01,:pYZZ02,:pYZZ03,:pYZZ04,:pYZZ05,:pYZZ06,:pYZZ07,:pYZZ08,:pYZZ09,:pYZZ10,:pYZZ11,:pYZZ12,:pYZZ13,:pYZZ14,:pYZZ15,:pYZZ16,:pYZZ17,:pYZZ18,:pYZZ19,:pYZZ20)"); sql.ParamByName("pBJDID").Value = _BJDID; sql.ParamByName("pBJDXH").Value = GetField("XLXSBJDMX_XH"); sql.ParamByName("pYZZ01").Value = GetField("TZYZ_BJ01"); sql.ParamByName("pYZZ02").Value = GetField("TZYZ_BJ02"); sql.ParamByName("pYZZ03").Value = GetField("TZYZ_BJ03"); sql.ParamByName("pYZZ04").Value = GetField("TZYZ_BJ04"); sql.ParamByName("pYZZ05").Value = GetField("TZYZ_BJ05"); sql.ParamByName("pYZZ06").Value = GetField("TZYZ_BJ06"); sql.ParamByName("pYZZ07").Value = GetField("TZYZ_BJ07"); sql.ParamByName("pYZZ08").Value = GetField("TZYZ_BJ08"); sql.ParamByName("pYZZ09").Value = GetField("TZYZ_BJ09"); sql.ParamByName("pYZZ10").Value = GetField("TZYZ_BJ10"); sql.ParamByName("pYZZ11").Value = GetField("TZYZ_BJ11"); sql.ParamByName("pYZZ12").Value = GetField("TZYZ_BJ12"); sql.ParamByName("pYZZ13").Value = GetField("TZYZ_BJ13"); sql.ParamByName("pYZZ14").Value = GetField("TZYZ_BJ14"); sql.ParamByName("pYZZ15").Value = GetField("TZYZ_BJ15"); sql.ParamByName("pYZZ16").Value = GetField("TZYZ_BJ16"); sql.ParamByName("pYZZ17").Value = GetField("TZYZ_BJ17"); sql.ParamByName("pYZZ18").Value = GetField("TZYZ_BJ18"); sql.ParamByName("pYZZ19").Value = GetField("TZYZ_BJ19"); sql.ParamByName("pYZZ20").Value = GetField("TZYZ_BJ20"); dberp.ExecSQL(sql); if (!GetField("UpdJJYZList").ToString().Trim().Equals("")) { string[] strJJYZZ = GetField("UpdJJYZList").ToString().Trim().Split('|'); sql.Clear(); sql.Add("insert into XLXSBJDJJYZ(XLXSBJDJJYZ_BJDID,XLXSBJDJJYZ_XH,XLXSBJDJJYZ_YZZ01,XLXSBJDJJYZ_YZZ02,XLXSBJDJJYZ_YZZ03,XLXSBJDJJYZ_YZZ04,"); sql.Add(" XLXSBJDJJYZ_YZZ05,XLXSBJDJJYZ_YZZ06,XLXSBJDJJYZ_YZZ07,XLXSBJDJJYZ_YZZ08,XLXSBJDJJYZ_YZZ09,XLXSBJDJJYZ_YZZ10,XLXSBJDJJYZ_YZZ11,XLXSBJDJJYZ_YZZ12,XLXSBJDJJYZ_YZZ13,XLXSBJDJJYZ_YZZ14,XLXSBJDJJYZ_YZZ15,XLXSBJDJJYZ_YZZ16,XLXSBJDJJYZ_YZZ17,XLXSBJDJJYZ_YZZ18,XLXSBJDJJYZ_YZZ19,XLXSBJDJJYZ_YZZ20,XLXSBJDJJYZ_YSJDZ)"); sql.Add(" values(:pBJDID,:pBJDXH,:pYZZ01,:pYZZ02,:pYZZ03,:pYZZ04,:pYZZ05,:pYZZ06,:pYZZ07,:pYZZ08,:pYZZ09,:pYZZ10,:pYZZ11,:pYZZ12,:pYZZ13,:pYZZ14,:pYZZ15,:pYZZ16,:pYZZ17,:pYZZ18,:pYZZ19,:pYZZ20,:pYSJDZ)"); sql.ParamByName("pBJDID").Value = _BJDID; sql.ParamByName("pBJDXH").Value = GetField("XLXSBJDMX_XH"); sql.ParamByName("pYZZ01").Value = CMISproConvert.StrToFloat(strJJYZZ[0], 0); sql.ParamByName("pYZZ02").Value = CMISproConvert.StrToFloat(strJJYZZ[1], 0); sql.ParamByName("pYZZ03").Value = CMISproConvert.StrToFloat(strJJYZZ[2], 0); sql.ParamByName("pYZZ04").Value = CMISproConvert.StrToFloat(strJJYZZ[3], 0); sql.ParamByName("pYZZ05").Value = CMISproConvert.StrToFloat(strJJYZZ[4], 0); sql.ParamByName("pYZZ06").Value = CMISproConvert.StrToFloat(strJJYZZ[5], 0); sql.ParamByName("pYZZ07").Value = CMISproConvert.StrToFloat(strJJYZZ[6], 0); sql.ParamByName("pYZZ08").Value = CMISproConvert.StrToFloat(strJJYZZ[7], 0); sql.ParamByName("pYZZ09").Value = CMISproConvert.StrToFloat(strJJYZZ[8], 0); sql.ParamByName("pYZZ10").Value = CMISproConvert.StrToFloat(strJJYZZ[9], 0); sql.ParamByName("pYZZ11").Value = CMISproConvert.StrToFloat(strJJYZZ[10], 0); sql.ParamByName("pYZZ12").Value = CMISproConvert.StrToFloat(strJJYZZ[11], 0); sql.ParamByName("pYZZ13").Value = CMISproConvert.StrToFloat(strJJYZZ[12], 0); sql.ParamByName("pYZZ14").Value = CMISproConvert.StrToFloat(strJJYZZ[13], 0); sql.ParamByName("pYZZ15").Value = CMISproConvert.StrToFloat(strJJYZZ[14], 0); sql.ParamByName("pYZZ16").Value = CMISproConvert.StrToFloat(strJJYZZ[15], 0); sql.ParamByName("pYZZ17").Value = CMISproConvert.StrToFloat(strJJYZZ[16], 0); sql.ParamByName("pYZZ18").Value = CMISproConvert.StrToFloat(strJJYZZ[17], 0); sql.ParamByName("pYZZ19").Value = CMISproConvert.StrToFloat(strJJYZZ[18], 0); sql.ParamByName("pYZZ20").Value = CMISproConvert.StrToFloat(strJJYZZ[19], 0); sql.ParamByName("pYSJDZ").Value = CMISproConvert.StrToFloat(strJJYZZ[20], 0); dberp.ExecSQL(sql); } if (GetField("PFYSQKBZ").ToString().Trim().Equals("Y")) { sql.Clear(); sql.Add("delete from XLXSBJDMXFD where XLXSBJDMXFD_BJDID = :XLXSBJDMXFD_BJDID and XLXSBJDMXFD_BJDXH = :XLXSBJDMXFD_BJDXH"); sql.ParamByName("XLXSBJDMXFD_BJDID").Value = _BJDID; sql.ParamByName("XLXSBJDMXFD_BJDXH").Value = GetField("XLXSBJDMX_XH"); dberp.ExecSQL(sql); sql.Clear(); sql.Add("delete from XLXSBJDMXZP where XLXSBJDMXZP_BJDID = :XLXSBJDMXZP_BJDID and XLXSBJDMXZP_BJDXH = :XLXSBJDMXZP_BJDXH"); sql.ParamByName("XLXSBJDMXZP_BJDID").Value = _BJDID; sql.ParamByName("XLXSBJDMXZP_BJDXH").Value = GetField("XLXSBJDMX_XH"); dberp.ExecSQL(sql); } return base.Inserted(sql); } public override TSQL SetUpdateSql() { TSQL SQL = base.SetUpdateSql(); SQL.Add(" update XLXSBJDMX set "); SQL.Add(" XLXSBJDMX_XH=:XLXSBJDMX_XH,"); SQL.Add(" XLXSBJDMX_XSSX=:XLXSBJDMX_XSSX,"); SQL.Add(" XLXSBJDMX_XLXHID=:XLXSBJDMX_XLXHID,"); SQL.Add(" XLXSBJDMX_XLGGID=:XLXSBJDMX_XLGGID,"); SQL.Add(" XLXSBJDMX_XLBZID=:XLXSBJDMX_XLBZID,"); SQL.Add(" XLXSBJDMX_DYDJID=isnull(:XLXSBJDMX_DYDJID,' '),"); SQL.Add(" XLXSBJDMX_XLYSID=:XLXSBJDMX_XLYSID,"); SQL.Add(" XLXSBJDMX_WLID=:XLXSBJDMX_WLID,"); SQL.Add(" XLXSBJDMX_ZHCPMLMC=:XLXSBJDMX_ZHCPMLMC,"); SQL.Add(" XLXSBJDMX_CPMLMC=:XLXSBJDMX_CPMLMC,"); SQL.Add(" XLXSBJDMX_BJCP=:XLXSBJDMX_BJCP,"); SQL.Add(" XLXSBJDMX_GYKH=:XLXSBJDMX_GYKH,"); SQL.Add(" XLXSBJDMX_PWQDID=:XLXSBJDMX_PWQDID,"); SQL.Add(" XLXSBJDMX_PWQDWLMC=:XLXSBJDMX_PWQDWLMC,"); SQL.Add(" XLXSBJDMX_PWQDMS=:XLXSBJDMX_PWQDMS,"); SQL.Add(" XLXSBJDMX_WGCPBZ=:XLXSBJDMX_WGCPBZ,"); SQL.Add(" XLXSBJDMX_JLDW=:XLXSBJDMX_JLDW,"); SQL.Add(" XLXSBJDMX_BJSL=isnull(:XLXSBJDMX_BJSL,0),"); SQL.Add(" XLXSBJDMX_JGBBJ=isnull(:XLXSBJDMX_JGBBJ,0),"); SQL.Add(" XLXSBJDMX_JGBBJGXSJ=:XLXSBJDMX_JGBBJGXSJ, "); SQL.Add(" XLXSBJDMX_LSJGBBJ=isnull(:XLXSBJDMX_LSJGBBJ,0),"); SQL.Add(" XLXSBJDMX_JMBGS=:XLXSBJDMX_JMBGS, "); SQL.Add(" XLXSBJDMX_CJ=isnull(:XLXSBJDMX_CJ,0),"); SQL.Add(" XLXSBJDMX_TZQCPBJ=isnull(:XLXSBJDMX_TZQCPBJ,0),"); SQL.Add(" XLXSBJDMX_TZCPBJ=isnull(:XLXSBJDMX_TZCPBJ,0),"); SQL.Add(" XLXSBJDMX_CPBJ=isnull(:XLXSBJDMX_CPBJ,0),"); SQL.Add(" XLXSBJDMX_TZQBJJE=isnull(:XLXSBJDMX_TZQBJJE,0),"); SQL.Add(" XLXSBJDMX_TZBJJE=isnull(:XLXSBJDMX_TZBJJE,0),"); SQL.Add(" XLXSBJDMX_BJJE=isnull(:XLXSBJDMX_BJJE,0),"); SQL.Add(" XLXSBJDMX_PJJE=ISNULL(:XLXSBJDMX_PJJE,0),"); SQL.Add(" XLXSBJDMX_JGBJJ=isnull(:XLXSBJDMX_JGBJJ,0),"); SQL.Add(" XLXSBJDMX_CLCB=isnull(:XLXSBJDMX_CLCB,0),"); SQL.Add(" XLXSBJDMX_JGBBJLJJCL=isnull(:XLXSBJDMX_JGBBJLJJCL,0),"); SQL.Add(" XLXSBJDMX_JGBBJJCL=isnull(:XLXSBJDMX_JGBBJJCL,0),"); SQL.Add(" XLXSBJDMX_JGBBJJCE=isnull(:XLXSBJDMX_JGBBJJCE,0),"); SQL.Add(" XLXSBJDMX_YXJG=isnull(:XLXSBJDMX_YXJG,0),"); SQL.Add(" XLXSBJDMX_DZSC=ISNULL(:XLXSBJDMX_DZSC,'N'),"); SQL.Add(" XLXSBJDMX_CLZL=isnull(:XLXSBJDMX_CLZL,0),"); SQL.Add(" XLXSBJDMX_YXJJCL=isnull(:XLXSBJDMX_YXJJCL,0),"); SQL.Add(" XLXSBJDMX_BJDHQCLCB=isnull(:XLXSBJDMX_BJDHQCLCB,0),"); SQL.Add(" XLXSBJDMX_CLCBJCL=isnull(:XLXSBJDMX_CLCBJCL,0),"); SQL.Add(" XLXSBJDMX_BJCPSD=ISNULL(:XLXSBJDMX_BJCPSD,'N'),"); SQL.Add(" XLXSBJDMX_BJSDBZ=ISNULL(:XLXSBJDMX_BJSDBZ,'N'),"); SQL.Add(" XLXSBJDMX_CLCBJCLSDBZ=ISNULL(:XLXSBJDMX_CLCBJCLSDBZ,'N'),"); SQL.Add(" XLXSBJDMX_TZQZDXJ=ISNULL(:XLXSBJDMX_TZQZDXJ,0),"); SQL.Add(" XLXSBJDMX_TZZDXJ=ISNULL(:XLXSBJDMX_TZZDXJ,0),"); SQL.Add(" XLXSBJDMX_ZDXJ=ISNULL(:XLXSBJDMX_ZDXJ,0),"); SQL.Add(" XLXSBJDMX_ZDXJJCL=ISNULL(:XLXSBJDMX_ZDXJJCL,0),"); SQL.Add(" XLXSBJDMX_JSJG=ISNULL(:XLXSBJDMX_JSJG,0),"); SQL.Add(" XLXSBJDMX_JSJJE=ISNULL(:XLXSBJDMX_JSJJE,0),"); SQL.Add(" XLXSBJDMX_JSJJCL=ISNULL(:XLXSBJDMX_JSJJCL,0),"); SQL.Add(" XLXSBJDMX_YSCP=:XLXSBJDMX_YSCP,"); SQL.Add(" XLXSBJDMX_KHWLID=:XLXSBJDMX_KHWLID,"); SQL.Add(" XLXSBJDMX_YZ=:XLXSBJDMX_YZ, "); SQL.Add(" XLXSBJDMX_FBH=:XLXSBJDMX_FBH, "); SQL.Add(" XLXSBJDMX_CPBJXJ=:XLXSBJDMX_CPBJXJ, "); SQL.Add(" XLXSBJDMX_BJXJKD=:XLXSBJDMX_BJXJKD, "); SQL.Add(" XLXSBJDMX_BJXJJJ=:XLXSBJDMX_BJXJJJ, "); SQL.Add(" XLXSBJDMX_BJJEXJ=:XLXSBJDMX_BJJEXJ, "); SQL.Add(" XLXSBJDMX_BZ=:XLXSBJDMX_BZ, "); SQL.Add(" XLXSBJDMX_BJLY=:XLXSBJDMX_BJLY, "); SQL.Add(" XLXSBJDMX_BJTJCZ=:XLXSBJDMX_BJTJCZ, "); SQL.Add(" XLXSBJDMX_BJDHQCLCBTZ=:XLXSBJDMX_BJDHQCLCBTZ, "); SQL.Add(" XLXSBJDMX_ZDXJBJDID=:XLXSBJDMX_ZDXJBJDID, "); SQL.Add(" XLXSBJDMX_ZDXJBJDXH=:XLXSBJDMX_ZDXJBJDXH, "); SQL.Add(" XLXSBJDMX_XDXLBZID=:XLXSBJDMX_XDXLBZID, "); SQL.Add(" XLXSBJDMX_XDXLXHID=:XLXSBJDMX_XDXLXHID, "); SQL.Add(" XLXSBJDMX_JGBBJTZ=:XLXSBJDMX_JGBBJTZ, "); SQL.Add(" XLXSBJDMX_JGFBZ=:XLXSBJDMX_JGFBZ, "); SQL.Add(" XLXSBJDMX_WHRID=:XLXSBJDMX_WHRID, "); SQL.Add(" XLXSBJDMX_WHR=:XLXSBJDMX_WHR, "); SQL.Add(" XLXSBJDMX_WHSJ=:XLXSBJDMX_WHSJ "); SQL.Add(" where XLXSBJDMX_BJDID = :XLXSBJDMX_BJDID"); SQL.Add(" and XLXSBJDMX_XH = :OLD_XLXSBJDMX_XH "); return SQL; } public override TSQL SetDeleteSql() { TSQL SQL = base.SetDeleteSql(); SQL.Add("delete from XLXSBJDMX where XLXSBJDMX_BJDID = :XLXSBJDMX_BJDID and XLXSBJDMX_XH = :XLXSBJDMX_XH"); return SQL; } public override bool Updating(TSQL sql) { SetNullToZero(); SetField("XLXSBJDMX_BJDID", _BJDID); if (XLXSBJDMX_XSSX.Equals("0")) { XLXSBJDMX_XSSX = GetNewNo(_BJDID, "XLXSBJDMX_XSSX").ToString(); } if (GetField("XLXSBJDMX_XH").ToString().Trim().Equals("0")) { WarningMsg = "明细数据序号不允许为空！"; return false; } if (GetField("XLXSBJDMX_XLXHID").ToString().Trim().Equals("")) { WarningMsg = "型号不允许为空！"; return false; } if (GetField("XLXSBJDMX_XLGGID").ToString().Trim().Equals("")) { WarningMsg = "规格不允许为空！"; return false; } if (GetField("XLXSBJDMX_XLBZID").ToString().Trim().Equals(" ")) { SetField("XLXSBJDMX_XLBZID", ""); } if (GetField("XLXSBJDMX_DYDJID").ToString().Trim().Equals(" ")) { SetField("XLXSBJDMX_DYDJID", ""); } if (GetField("XLXSBJDMX_XLYSID").ToString().Trim().Contains("|")) { SetField("XLXSBJDMX_XLYSID", GetField("XLXSBJDMX_XLYSID").ToString().Trim().Split('|')[0]); } if (CMISproConvert.StrToFloat(GetField("XLXSBJDMX_BJSL").ToString().Trim(), 0) < 0) { WarningMsg = "报价数量不允许小于0！"; return false; } return base.Updating(sql); } public override bool Updated(TSQL sql) { TDatabase dberp = TContextDatabases.GetDatabase("DBERP"); sql.Clear(); sql.Add("update XLXSBJDYZZ0 set XLXSBJDYZZ0_XH=:pBJDXH,XLXSBJDYZZ0_YZZ01=:pYZZ01,XLXSBJDYZZ0_YZZ02=:pYZZ02,XLXSBJDYZZ0_YZZ03=:pYZZ03,XLXSBJDYZZ0_YZZ04=:pYZZ04,XLXSBJDYZZ0_YZZ05=:pYZZ05,"); sql.Add(" XLXSBJDYZZ0_YZZ06=:pYZZ06,XLXSBJDYZZ0_YZZ07=:pYZZ07,XLXSBJDYZZ0_YZZ08=:pYZZ08,XLXSBJDYZZ0_YZZ09=:pYZZ09,XLXSBJDYZZ0_YZZ10=:pYZZ10, "); sql.Add(" XLXSBJDYZZ0_YZZ11=:pYZZ11,XLXSBJDYZZ0_YZZ12=:pYZZ12,XLXSBJDYZZ0_YZZ13=:pYZZ13,XLXSBJDYZZ0_YZZ14=:pYZZ14,XLXSBJDYZZ0_YZZ15=:pYZZ15,"); sql.Add(" XLXSBJDYZZ0_YZZ16=:pYZZ16,XLXSBJDYZZ0_YZZ17=:pYZZ17,XLXSBJDYZZ0_YZZ18=:pYZZ18,XLXSBJDYZZ0_YZZ19=:pYZZ19,XLXSBJDYZZ0_YZZ20=:pYZZ20 "); sql.Add(" where XLXSBJDYZZ0_BJDID=:pBJDID and XLXSBJDYZZ0_XH=:OLD_XLXSBJDMX_XH"); sql.ParamByName("pBJDID").Value = _BJDID; sql.ParamByName("OLD_XLXSBJDMX_XH").Value = GetField("OLD_XLXSBJDMX_XH"); sql.ParamByName("pBJDXH").Value = GetField("XLXSBJDMX_XH"); sql.ParamByName("pYZZ01").Value = GetField("TZYZ_BJ01"); sql.ParamByName("pYZZ02").Value = GetField("TZYZ_BJ02"); sql.ParamByName("pYZZ03").Value = GetField("TZYZ_BJ03"); sql.ParamByName("pYZZ04").Value = GetField("TZYZ_BJ04"); sql.ParamByName("pYZZ05").Value = GetField("TZYZ_BJ05"); sql.ParamByName("pYZZ06").Value = GetField("TZYZ_BJ06"); sql.ParamByName("pYZZ07").Value = GetField("TZYZ_BJ07"); sql.ParamByName("pYZZ08").Value = GetField("TZYZ_BJ08"); sql.ParamByName("pYZZ09").Value = GetField("TZYZ_BJ09"); sql.ParamByName("pYZZ10").Value = GetField("TZYZ_BJ10"); sql.ParamByName("pYZZ11").Value = GetField("TZYZ_BJ11"); sql.ParamByName("pYZZ12").Value = GetField("TZYZ_BJ12"); sql.ParamByName("pYZZ13").Value = GetField("TZYZ_BJ13"); sql.ParamByName("pYZZ14").Value = GetField("TZYZ_BJ14"); sql.ParamByName("pYZZ15").Value = GetField("TZYZ_BJ15"); sql.ParamByName("pYZZ16").Value = GetField("TZYZ_BJ16"); sql.ParamByName("pYZZ17").Value = GetField("TZYZ_BJ17"); sql.ParamByName("pYZZ18").Value = GetField("TZYZ_BJ18"); sql.ParamByName("pYZZ19").Value = GetField("TZYZ_BJ19"); sql.ParamByName("pYZZ20").Value = GetField("TZYZ_BJ20"); dberp.ExecSQL(sql); if (!GetField("UpdJJYZList").ToString().Trim().Equals("")) { string[] strJJYZZ = GetField("UpdJJYZList").ToString().Trim().Split('|'); sql.Clear(); sql.Add("update XLXSBJDJJYZ set XLXSBJDJJYZ_XH=:pBJDXH,XLXSBJDJJYZ_YZZ01=:pYZZ01,XLXSBJDJJYZ_YZZ02=:pYZZ02,XLXSBJDJJYZ_YZZ03=:pYZZ03,XLXSBJDJJYZ_YZZ04=:pYZZ04,XLXSBJDJJYZ_YZZ05=:pYZZ05,"); sql.Add(" XLXSBJDJJYZ_YZZ06=:pYZZ06,XLXSBJDJJYZ_YZZ07=:pYZZ07,XLXSBJDJJYZ_YZZ08=:pYZZ08,XLXSBJDJJYZ_YZZ09=:pYZZ09,XLXSBJDJJYZ_YZZ10=:pYZZ10,XLXSBJDJJYZ_YZZ11=:pYZZ11,XLXSBJDJJYZ_YZZ12=:pYZZ12,XLXSBJDJJYZ_YZZ13=:pYZZ13,XLXSBJDJJYZ_YZZ14=:pYZZ14,XLXSBJDJJYZ_YZZ15=:pYZZ15,XLXSBJDJJYZ_YZZ16=:pYZZ16,XLXSBJDJJYZ_YZZ17=:pYZZ17,XLXSBJDJJYZ_YZZ18=:pYZZ18,XLXSBJDJJYZ_YZZ19=:pYZZ19,XLXSBJDJJYZ_YZZ20=:pYZZ20,XLXSBJDJJYZ_YSJDZ=:pYSJDZ "); sql.Add(" where XLXSBJDJJYZ_BJDID=:pBJDID and XLXSBJDJJYZ_XH=:OLD_XLXSBJDMX_XH"); sql.ParamByName("pBJDID").Value = _BJDID; sql.ParamByName("OLD_XLXSBJDMX_XH").Value = GetField("OLD_XLXSBJDMX_XH"); sql.ParamByName("pBJDXH").Value = GetField("XLXSBJDMX_XH"); sql.ParamByName("pYZZ01").Value = CMISproConvert.StrToFloat(strJJYZZ[0], 0); sql.ParamByName("pYZZ02").Value = CMISproConvert.StrToFloat(strJJYZZ[1], 0); sql.ParamByName("pYZZ03").Value = CMISproConvert.StrToFloat(strJJYZZ[2], 0); sql.ParamByName("pYZZ04").Value = CMISproConvert.StrToFloat(strJJYZZ[3], 0); sql.ParamByName("pYZZ05").Value = CMISproConvert.StrToFloat(strJJYZZ[4], 0); sql.ParamByName("pYZZ06").Value = CMISproConvert.StrToFloat(strJJYZZ[5], 0); sql.ParamByName("pYZZ07").Value = CMISproConvert.StrToFloat(strJJYZZ[6], 0); sql.ParamByName("pYZZ08").Value = CMISproConvert.StrToFloat(strJJYZZ[7], 0); sql.ParamByName("pYZZ09").Value = CMISproConvert.StrToFloat(strJJYZZ[8], 0); sql.ParamByName("pYZZ10").Value = CMISproConvert.StrToFloat(strJJYZZ[9], 0); sql.ParamByName("pYZZ11").Value = CMISproConvert.StrToFloat(strJJYZZ[10], 0); sql.ParamByName("pYZZ12").Value = CMISproConvert.StrToFloat(strJJYZZ[11], 0); sql.ParamByName("pYZZ13").Value = CMISproConvert.StrToFloat(strJJYZZ[12], 0); sql.ParamByName("pYZZ14").Value = CMISproConvert.StrToFloat(strJJYZZ[13], 0); sql.ParamByName("pYZZ15").Value = CMISproConvert.StrToFloat(strJJYZZ[14], 0); sql.ParamByName("pYZZ16").Value = CMISproConvert.StrToFloat(strJJYZZ[15], 0); sql.ParamByName("pYZZ17").Value = CMISproConvert.StrToFloat(strJJYZZ[16], 0); sql.ParamByName("pYZZ18").Value = CMISproConvert.StrToFloat(strJJYZZ[17], 0); sql.ParamByName("pYZZ19").Value = CMISproConvert.StrToFloat(strJJYZZ[18], 0); sql.ParamByName("pYZZ20").Value = CMISproConvert.StrToFloat(strJJYZZ[19], 0); sql.ParamByName("pYSJDZ").Value = CMISproConvert.StrToFloat(strJJYZZ[20], 0); dberp.ExecSQL(sql); } if (GetField("PFYSQKBZ").ToString().Trim().Equals("Y")) { sql.Clear(); sql.Add("delete from XLXSBJDMXFD where XLXSBJDMXFD_BJDID = :XLXSBJDMXFD_BJDID and XLXSBJDMXFD_BJDXH = :XLXSBJDMXFD_BJDXH"); sql.ParamByName("XLXSBJDMXFD_BJDID").Value = _BJDID; sql.ParamByName("XLXSBJDMXFD_BJDXH").Value = GetField("XLXSBJDMX_XH"); dberp.ExecSQL(sql); sql.Clear(); sql.Add("delete from XLXSBJDMXZP where XLXSBJDMXZP_BJDID = :XLXSBJDMXZP_BJDID and XLXSBJDMXZP_BJDXH = :XLXSBJDMXZP_BJDXH"); sql.ParamByName("XLXSBJDMXZP_BJDID").Value = _BJDID; sql.ParamByName("XLXSBJDMXZP_BJDXH").Value = GetField("XLXSBJDMX_XH"); dberp.ExecSQL(sql); } return base.Updated(sql); } public override bool Deleted(TSQL sql) { TDatabase dberp = TContextDatabases.GetDatabase("DBERP"); sql.Clear(); sql.Add("delete from XLXSBJDYZZ0 where XLXSBJDYZZ0_BJDID = :XLXSBJDYZZ0_BJDID and XLXSBJDYZZ0_XH = :XLXSBJDYZZ0_XH"); sql.ParamByName("XLXSBJDYZZ0_BJDID").Value = _BJDID; sql.ParamByName("XLXSBJDYZZ0_XH").Value = GetField("XLXSBJDMX_XH"); dberp.ExecSQL(sql); sql.Clear(); sql.Add("delete from XLXSBJDJJYZ where XLXSBJDJJYZ_BJDID = :XLXSBJDJJYZ_BJDID and XLXSBJDJJYZ_XH = :XLXSBJDJJYZ_XH"); sql.ParamByName("XLXSBJDJJYZ_BJDID").Value = _BJDID; sql.ParamByName("XLXSBJDJJYZ_XH").Value = GetField("XLXSBJDMX_XH"); dberp.ExecSQL(sql); sql.Clear(); sql.Add("delete from XLXSBJDMXFD where XLXSBJDMXFD_BJDID = :XLXSBJDMXFD_BJDID and XLXSBJDMXFD_BJDXH = :XLXSBJDMXFD_BJDXH"); sql.ParamByName("XLXSBJDMXFD_BJDID").Value = _BJDID; sql.ParamByName("XLXSBJDMXFD_BJDXH").Value = GetField("XLXSBJDMX_XH"); dberp.ExecSQL(sql); sql.Clear(); sql.Add("delete from XLXSBJDMXZP where XLXSBJDMXZP_BJDID = :XLXSBJDMXZP_BJDID and XLXSBJDMXZP_BJDXH = :XLXSBJDMXZP_BJDXH"); sql.ParamByName("XLXSBJDMXZP_BJDID").Value = _BJDID; sql.ParamByName("XLXSBJDMXZP_BJDXH").Value = GetField("XLXSBJDMX_XH"); dberp.ExecSQL(sql); sql.Clear(); sql.Add("delete from XLXSBJDGYJD where XLXSBJDGYJD_BJDID = :XLXSBJDGYJD_BJDID and XLXSBJDGYJD_BJDXH = :XLXSBJDGYJD_BJDXH"); sql.ParamByName("XLXSBJDGYJD_BJDID").Value = _BJDID; sql.ParamByName("XLXSBJDGYJD_BJDXH").Value = GetField("XLXSBJDMX_XH"); dberp.ExecSQL(sql); return base.Deleted(sql); } private void SetNullToZero() { int RowIndex = ActIndex; for (int i = 0; i < Entites.Rows.Count; i++) { ActIndex = i; foreach (KeyValuePair de in EntityFields) { if (de.Value.DbType == TGtdbType.Float) { object fieldObj = GetField(de.Key); string fieldValue = (fieldObj != null) ? fieldObj.ToString().Trim() : ""; if (string.IsNullOrEmpty(fieldValue)) { SetField(de.Key, "0"); } else if (IsScientificNotation(fieldValue)) { // 处理科学计数法 try { double doubleValue = ParseScientificNotation(fieldValue); // 转换为普通数字格式 string result = doubleValue.ToString("0.####################"); SetField(de.Key, result); } catch { SetField(de.Key, "0"); } } // 确保浮点数格式正确 else if (fieldObj is double || fieldObj is float) { decimal decimalValue = Convert.ToDecimal(fieldObj); SetField(de.Key, decimalValue.ToString("0.##########")); } } } } ActIndex = RowIndex; } //按分隔符拆分简写科学计数法（如"5-7"表示5×10^-7、"5+7"表示5×10^7）；无法拆分返回false private bool TrySplitShorthand(string value, char separator, out string sMantissa, out string sExponent) { sMantissa = ""; sExponent = ""; if (value.Length <= 2) return false; int iFrom = (value[0] == '-') ? 1 : 0; int separatorIndex = value.IndexOf(separator, iFrom); if (separatorIndex <= 0 || separatorIndex >= value.Length - 1) return false; sMantissa = value.Substring(0, separatorIndex); sExponent = value.Substring(separatorIndex + 1); return true; } private bool IsScientificNotation(string value) { if (string.IsNullOrEmpty(value)) return false; // 标准科学计数法：包含e或E if (value.IndexOf('e') >= 0 || value.IndexOf('E') >= 0) { double testValue; return double.TryParse(value, System.Globalization.NumberStyles.Float, System.Globalization.CultureInfo.InvariantCulture, out testValue); } // 简写格式："5-7"=5×10^-7、"5+7"=5×10^7（负号开头时跳过首位再找分隔符） double dMantissa; int iExponent; string sMantissa; string sExponent; if (TrySplitShorthand(value, '-', out sMantissa, out sExponent) && double.TryParse(sMantissa, out dMantissa) && int.TryParse(sExponent, out iExponent)) return true; if (TrySplitShorthand(value, '+', out sMantissa, out sExponent) && double.TryParse(sMantissa, out dMantissa) && int.TryParse(sExponent, out iExponent)) return true; return false; } // 解析科学计数法 private double ParseScientificNotation(string value) { // 标准科学计数法 if (value.IndexOf('e') >= 0 || value.IndexOf('E') >= 0) { return double.Parse(value, System.Globalization.NumberStyles.Float, System.Globalization.CultureInfo.InvariantCulture); } double dMantissa; int iExponent; string sMantissa; string sExponent; // 简写负号分隔："5-7"=5×10^-7 if (TrySplitShorthand(value, '-', out sMantissa, out sExponent) && double.TryParse(sMantissa, out dMantissa) && int.TryParse(sExponent, out iExponent)) return dMantissa * System.Math.Pow(10, -iExponent); // 简写加号分隔："5+7"=5×10^7 if (TrySplitShorthand(value, '+', out sMantissa, out sExponent) && double.TryParse(sMantissa, out dMantissa) && int.TryParse(sExponent, out iExponent)) return dMantissa * System.Math.Pow(10, iExponent); // 如果不是科学计数法，直接返回解析结果 return double.Parse(value); } //取指定列的新序号（最大值+1；查询失败按1处理） private int GetNewNo(string sID, string sField) { try { return CMISproDataBase.GetMaxXH("DBERP", "XLXSBJDMX", sField, "XLXSBJDMX_BJDID = '" + sID.Replace("'", "''") + "'") + 1; } catch { return 1; } } } }