927 lines
44 KiB
C#
927 lines
44 KiB
C#
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.Collections.Generic;
|
|
using GThinking.N_MISPRO.Data;
|
|
|
|
namespace GThinking.N_XLXSBJ
|
|
{
|
|
[TableMap(DB = "DBERP", DbTableName = "XLXSBJFL", Umid = 100860023, IsWorkFlow = false, UseWhr = true, IsAttach = true, DOCGRPIDFieldName = "XLXSBJFL_JGMBGRPID", DOCFJSFieldName = "XLXSBJFL_JGMBFJS",
|
|
|
|
QuerySelSql = " select XLXSBJFL_BJFLID,XLXSBJFL_BJFLMC,XLXSBJFL_BJFLTZM,XLXSBJFL_XSXH,XLXSBJFL_JGBTJYSS,XLXSBJFL_JGBIDS,XLXSBJFL_XSQYIDS, "
|
|
+ " XLXSBJFL_CPMLID,XLXSBJFL_SDJGBCLHQFW,XLXSBJFL_XSJGBJJ, XLXSBJFL_XSJGBBJJCE, XLXSBJFL_BJJCLLX,XLXSBJFL_TZCLHQ,XLXSBJFL_TZJGBBJ,XLXSBJFL_TZBJBJBB,XLXSBJFL_TZBJDHQLJ,XLXSBJFL_TZBJ, "
|
|
+ " XLXSBJFL_ZDXJQZBJDFL,XLXSBJFL_ZDXJGS,XLXSBJFL_JSJGS,XLXSBJFL_JLRBJCP,XLXSBJFL_JGBBJBM,XLXSBJFL_BJDHQLJBM,XLXSBJFL_BJBM,XLXSBJFL_BABZFGDY,XLXSBJFL_JJZJGBXH,"
|
|
+ " XLXSBJFL_BJDHQLY,XLXSBJFL_LJJCLLX,XLXSBJFL_BJLJJCLLX,XLXSBJFL_XHGGYMHJS,XLXSBJFL_XSTZZDXJ,XLXSBJFL_ABJDHQJSBJ, "
|
|
+ " XLXSBJFL_XSTZCPBJ,XLXSBJFL_XSTZBJJE,XLXSBJFL_XTCPBJYZ,XLXSBJFL_TLJTZGXQTCL,XLXSBJFL_XSCPBJXJ,"
|
|
+ " XLXSBJFL_BJCPFZJS,XLXSBJFL_XHABJCSDP,XLXSBJFL_LJJCLPLTJFW,XLXSBJFL_XSYXJ,XLXSBJFL_XSYZ,XLXSBJFL_XSFBH,XLXSBJFL_XSYSCP,"
|
|
+ " XLXSBJFL_JYF,XLXSBJFL_YFWLID,XLXSBJFL_BJHYF,XLXSBJFL_JLBJDHQ,XLXSBJFL_YXJJCLLX,XLXSBJFL_XSYLRYZID,XLXSBJFL_XSYKJJGHJ,XLXSBJFL_XSYKJJGLM,"
|
|
+ " XLXSBJFL_QYRQ,XLXSBJFL_TYBZ,XLXSBJFL_TYRQ,XLXSBJFL_BZ,XLXSBJFL_WHR,XLXSBJFL_WHRID,XLXSBJFL_WHSJ,XLXSBJFL_MRCKC, "
|
|
+ " XLXSBJFL_MXBH,XLXSBJFL_TBJCLID,XLXSBJFL_LBJCLID,XLXSBJFL_ZLGZCLS,XLXSBJFL_BJDYBJTXS,XLXSBJFL_BJQSTXS,XLXSBJFL_ZDXJJCLXX,XLXSBJFL_ZDXJJCLTXS,XLXSBJFL_CPBJMRXSWS,XLXSBJFL_TZWLHQ,XLXSBJFL_XSZDXJ,XLXSBJFL_ZDXJJCLLX,XLXSBJFL_JMBGSYZID,XLXSBJFL_JGMBGRPID"
|
|
+ " from XLXSBJFL where 1=1",
|
|
|
|
|
|
EntitySelSql = " select XLXSBJFL_BJFLID, XLXSBJFL_BJFLID as OLDBJFLID,XLXSBJFL_BJFLMC,XLXSBJFL_BJFLTZM,XLXSBJFL_XSXH,XLXSBJFL_JGBTJYSS,XLXSBJFL_JGBIDS,XLXSBJFL_XSQYIDS, "
|
|
+ " XLXSBJFL_CPMLID,XLXSBJFL_SDJGBCLHQFW,XLXSBJFL_XSJGBJJ,XLXSBJFL_XSJGBBJJCE,XLXSBJFL_BJJCLLX,XLXSBJFL_TZCLHQ,XLXSBJFL_TZBJBJBB,XLXSBJFL_TZJGBBJ,XLXSBJFL_TZBJDHQLJ,XLXSBJFL_TZBJ, "
|
|
+ " XLXSBJFL_ZDXJQZBJDFL,XLXSBJFL_ZDXJGS,XLXSBJFL_JSJGS,XLXSBJFL_JLRBJCP,XLXSBJFL_JGBBJBM,XLXSBJFL_BJDHQLJBM,XLXSBJFL_BJBM,XLXSBJFL_BABZFGDY,XLXSBJFL_JJZJGBXH,"
|
|
+ " XLXSBJFL_BJDHQLY,XLXSBJFL_LJJCLLX,XLXSBJFL_BJLJJCLLX,XLXSBJFL_XHGGYMHJS,XLXSBJFL_XSTZZDXJ,XLXSBJFL_ABJDHQJSBJ, "
|
|
+ " XLXSBJFL_XSTZCPBJ,XLXSBJFL_XSTZBJJE,XLXSBJFL_XTCPBJYZ,XLXSBJFL_TLJTZGXQTCL,XLXSBJFL_XSCPBJXJ,"
|
|
+ " XLXSBJFL_BJCPFZJS,XLXSBJFL_XHABJCSDP,XLXSBJFL_LJJCLPLTJFW,XLXSBJFL_XSYXJ,XLXSBJFL_XSYZ,XLXSBJFL_XSFBH,XLXSBJFL_XSYSCP,"
|
|
+ " XLXSBJFL_JYF,XLXSBJFL_YFWLID,XLXSBJFL_BJHYF,XLXSBJFL_JLBJDHQ,XLXSBJFL_YXJJCLLX,XLXSBJFL_XSYLRYZID,XLXSBJFL_XSYKJJGHJ,XLXSBJFL_XSYKJJGLM,"
|
|
+ " XLXSBJFL_QYRQ,XLXSBJFL_TYBZ,XLXSBJFL_TYRQ,XLXSBJFL_BZ,XLXSBJFL_WHR,XLXSBJFL_WHRID,XLXSBJFL_WHSJ,XLXSBJFL_MRCKC, "
|
|
+ " XLXSBJFL_MXBH,XLXSBJFL_TBJCLID,XLXSBJFL_LBJCLID,XLXSBJFL_ZLGZCLS,XLXSBJFL_BJDYBJTXS,XLXSBJFL_BJQSTXS,XLXSBJFL_ZDXJJCLXX,XLXSBJFL_ZDXJJCLTXS,XLXSBJFL_CPBJMRXSWS,XLXSBJFL_TZWLHQ,XLXSBJFL_XSZDXJ,XLXSBJFL_ZDXJJCLLX,XLXSBJFL_JMBGSYZID,XLXSBJFL_JGMBGRPID "
|
|
+ " from XLXSBJFL where XLXSBJFL_BJFLID=:XLXSBJFL_BJFLID",
|
|
|
|
|
|
UpdateSql = " update XLXSBJFL set XLXSBJFL_BJFLID=:XLXSBJFL_BJFLID,XLXSBJFL_BJFLMC=:XLXSBJFL_BJFLMC,XLXSBJFL_XSXH=:XLXSBJFL_XSXH,XLXSBJFL_JGBTJYSS=:XLXSBJFL_JGBTJYSS,XLXSBJFL_JGBIDS=:XLXSBJFL_JGBIDS,XLXSBJFL_XSQYIDS=:XLXSBJFL_XSQYIDS, "
|
|
+ " XLXSBJFL_CPMLID=:XLXSBJFL_CPMLID,XLXSBJFL_SDJGBCLHQFW=:XLXSBJFL_SDJGBCLHQFW,XLXSBJFL_XSJGBJJ=:XLXSBJFL_XSJGBJJ,XLXSBJFL_XSJGBBJJCE=:XLXSBJFL_XSJGBBJJCE,XLXSBJFL_BJJCLLX=:XLXSBJFL_BJJCLLX,XLXSBJFL_TZCLHQ=:XLXSBJFL_TZCLHQ,XLXSBJFL_ABJDHQJSBJ=:XLXSBJFL_ABJDHQJSBJ, "
|
|
+ " XLXSBJFL_TZJGBBJ=:XLXSBJFL_TZJGBBJ,XLXSBJFL_TZBJ=:XLXSBJFL_TZBJ,XLXSBJFL_TZBJDHQLJ=:XLXSBJFL_TZBJDHQLJ,XLXSBJFL_ZDXJQZBJDFL=:XLXSBJFL_ZDXJQZBJDFL,XLXSBJFL_ZDXJGS=:XLXSBJFL_ZDXJGS,XLXSBJFL_JSJGS=:XLXSBJFL_JSJGS,XLXSBJFL_LJJCLLX=:XLXSBJFL_LJJCLLX,XLXSBJFL_BJLJJCLLX=:XLXSBJFL_BJLJJCLLX,XLXSBJFL_XHGGYMHJS=:XLXSBJFL_XHGGYMHJS,XLXSBJFL_XSTZZDXJ=:XLXSBJFL_XSTZZDXJ,XLXSBJFL_BABZFGDY=:XLXSBJFL_BABZFGDY, "
|
|
+ " XLXSBJFL_BJDHQLY=:XLXSBJFL_BJDHQLY,XLXSBJFL_XSTZCPBJ=:XLXSBJFL_XSTZCPBJ,XLXSBJFL_XSTZBJJE=:XLXSBJFL_XSTZBJJE,XLXSBJFL_XTCPBJYZ=:XLXSBJFL_XTCPBJYZ,XLXSBJFL_TLJTZGXQTCL=:XLXSBJFL_TLJTZGXQTCL,XLXSBJFL_JJZJGBXH=:XLXSBJFL_JJZJGBXH,"
|
|
+ " XLXSBJFL_BJCPFZJS=:XLXSBJFL_BJCPFZJS,XLXSBJFL_XHABJCSDP=:XLXSBJFL_XHABJCSDP,XLXSBJFL_LJJCLPLTJFW=:XLXSBJFL_LJJCLPLTJFW,XLXSBJFL_XSYXJ=:XLXSBJFL_XSYXJ,XLXSBJFL_XSYZ=:XLXSBJFL_XSYZ,XLXSBJFL_XSFBH=:XLXSBJFL_XSFBH,XLXSBJFL_XSYSCP=:XLXSBJFL_XSYSCP,XLXSBJFL_JLRBJCP=:XLXSBJFL_JLRBJCP,XLXSBJFL_JGBBJBM=:XLXSBJFL_JGBBJBM,XLXSBJFL_BJDHQLJBM=:XLXSBJFL_BJDHQLJBM,XLXSBJFL_BJBM=:XLXSBJFL_BJBM,"
|
|
+ " XLXSBJFL_JYF=:XLXSBJFL_JYF,XLXSBJFL_YFWLID=:XLXSBJFL_YFWLID,XLXSBJFL_BJHYF=:XLXSBJFL_BJHYF,XLXSBJFL_JLBJDHQ=:XLXSBJFL_JLBJDHQ,XLXSBJFL_YXJJCLLX=:XLXSBJFL_YXJJCLLX,XLXSBJFL_XSYLRYZID=:XLXSBJFL_XSYLRYZID,XLXSBJFL_XSYKJJGHJ=:XLXSBJFL_XSYKJJGHJ,XLXSBJFL_XSYKJJGLM=:XLXSBJFL_XSYKJJGLM,"
|
|
+ " XLXSBJFL_QYRQ=:XLXSBJFL_QYRQ,XLXSBJFL_TYBZ=:XLXSBJFL_TYBZ,XLXSBJFL_TYRQ=:XLXSBJFL_TYRQ,XLXSBJFL_BJFLTZM=:XLXSBJFL_BJFLTZM,XLXSBJFL_TZBJBJBB=:XLXSBJFL_TZBJBJBB," + "\r\n"
|
|
+ " XLXSBJFL_BZ=:XLXSBJFL_BZ, XLXSBJFL_WHR=:XLXSBJFL_WHR,XLXSBJFL_WHRID=:XLXSBJFL_WHRID,XLXSBJFL_WHSJ=:XLXSBJFL_WHSJ,XLXSBJFL_MRCKC=:XLXSBJFL_MRCKC,XLXSBJFL_XSCPBJXJ=:XLXSBJFL_XSCPBJXJ, " + "\r\n"
|
|
+ " XLXSBJFL_MXBH=:XLXSBJFL_MXBH,XLXSBJFL_TBJCLID=:XLXSBJFL_TBJCLID,XLXSBJFL_LBJCLID=:XLXSBJFL_LBJCLID,XLXSBJFL_ZLGZCLS=:XLXSBJFL_ZLGZCLS,XLXSBJFL_BJDYBJTXS=:XLXSBJFL_BJDYBJTXS,XLXSBJFL_BJQSTXS=:XLXSBJFL_BJQSTXS,XLXSBJFL_ZDXJJCLXX=:XLXSBJFL_ZDXJJCLXX,XLXSBJFL_ZDXJJCLTXS=:XLXSBJFL_ZDXJJCLTXS," + "\r\n"
|
|
+ " XLXSBJFL_CPBJMRXSWS=:XLXSBJFL_CPBJMRXSWS,XLXSBJFL_TZWLHQ=:XLXSBJFL_TZWLHQ,XLXSBJFL_XSZDXJ=:XLXSBJFL_XSZDXJ,XLXSBJFL_ZDXJJCLLX=:XLXSBJFL_ZDXJJCLLX,XLXSBJFL_JMBGSYZID=:XLXSBJFL_JMBGSYZID,XLXSBJFL_JGMBGRPID=:XLXSBJFL_JGMBGRPID "
|
|
+ " where XLXSBJFL_BJFLID=:OLDBJFLID ",
|
|
|
|
InsertSql = " insert into XLXSBJFL(XLXSBJFL_BJFLID,XLXSBJFL_BJFLMC,XLXSBJFL_BJFLTZM,XLXSBJFL_XSXH,XLXSBJFL_JGBTJYSS,XLXSBJFL_JGBIDS,XLXSBJFL_XSQYIDS, "
|
|
+ " XLXSBJFL_CPMLID,XLXSBJFL_SDJGBCLHQFW,XLXSBJFL_XSJGBJJ,XLXSBJFL_XSJGBBJJCE,XLXSBJFL_BJJCLLX,XLXSBJFL_TZCLHQ,XLXSBJFL_TZJGBBJ,XLXSBJFL_TZBJDHQLJ,XLXSBJFL_TZBJ,XLXSBJFL_JGBBJBM,XLXSBJFL_BJDHQLJBM,XLXSBJFL_BJBM, "
|
|
+ " XLXSBJFL_ZDXJQZBJDFL,XLXSBJFL_ZDXJGS,XLXSBJFL_JSJGS,XLXSBJFL_JLRBJCP,XLXSBJFL_BABZFGDY,XLXSBJFL_JJZJGBXH,XLXSBJFL_TZBJBJBB,"
|
|
+ " XLXSBJFL_BJDHQLY,XLXSBJFL_LJJCLLX,XLXSBJFL_BJLJJCLLX,XLXSBJFL_XHGGYMHJS,XLXSBJFL_XSTZZDXJ,XLXSBJFL_ABJDHQJSBJ,XLXSBJFL_XSCPBJXJ, "
|
|
+ " XLXSBJFL_XSTZCPBJ,XLXSBJFL_XSTZBJJE,XLXSBJFL_XTCPBJYZ,XLXSBJFL_TLJTZGXQTCL,XLXSBJFL_YXJJCLLX,XLXSBJFL_XSYLRYZID,XLXSBJFL_XSYKJJGHJ,XLXSBJFL_XSYKJJGLM,"
|
|
+ " XLXSBJFL_BJCPFZJS,XLXSBJFL_XHABJCSDP,XLXSBJFL_LJJCLPLTJFW,XLXSBJFL_XSYXJ,XLXSBJFL_XSYZ,XLXSBJFL_XSFBH,XLXSBJFL_XSYSCP,XLXSBJFL_JLBJDHQ,"
|
|
+ " XLXSBJFL_JYF,XLXSBJFL_YFWLID,XLXSBJFL_BJHYF,XLXSBJFL_XSZDXJ,XLXSBJFL_ZDXJJCLLX,XLXSBJFL_JMBGSYZID,XLXSBJFL_JGMBGRPID,"
|
|
+ " XLXSBJFL_QYRQ,XLXSBJFL_TYBZ,XLXSBJFL_TYRQ,XLXSBJFL_BZ,XLXSBJFL_WHR,XLXSBJFL_WHRID,XLXSBJFL_WHSJ,XLXSBJFL_MRCKC,XLXSBJFL_MXBH,XLXSBJFL_TBJCLID,XLXSBJFL_LBJCLID,XLXSBJFL_ZLGZCLS,XLXSBJFL_BJDYBJTXS,XLXSBJFL_BJQSTXS,XLXSBJFL_ZDXJJCLXX,XLXSBJFL_ZDXJJCLTXS,XLXSBJFL_CPBJMRXSWS,XLXSBJFL_TZWLHQ) " + "\r\n"
|
|
+ " values(:XLXSBJFL_BJFLID,:XLXSBJFL_BJFLMC,:XLXSBJFL_BJFLTZM,:XLXSBJFL_XSXH,:XLXSBJFL_JGBTJYSS,:XLXSBJFL_JGBIDS,:XLXSBJFL_XSQYIDS, "
|
|
+ " :XLXSBJFL_CPMLID,:XLXSBJFL_SDJGBCLHQFW,:XLXSBJFL_XSJGBJJ,:XLXSBJFL_XSJGBBJJCE,:XLXSBJFL_BJJCLLX,:XLXSBJFL_TZCLHQ,:XLXSBJFL_TZJGBBJ,:XLXSBJFL_TZBJDHQLJ,:XLXSBJFL_TZBJ,:XLXSBJFL_JGBBJBM,:XLXSBJFL_BJDHQLJBM,:XLXSBJFL_BJBM, "
|
|
+ " :XLXSBJFL_ZDXJQZBJDFL,:XLXSBJFL_ZDXJGS,:XLXSBJFL_JSJGS,:XLXSBJFL_JLRBJCP,:XLXSBJFL_BABZFGDY,:XLXSBJFL_JJZJGBXH,:XLXSBJFL_TZBJBJBB,"
|
|
+ " :XLXSBJFL_BJDHQLY,:XLXSBJFL_LJJCLLX,:XLXSBJFL_BJLJJCLLX,:XLXSBJFL_XHGGYMHJS,:XLXSBJFL_XSTZZDXJ,:XLXSBJFL_ABJDHQJSBJ,XLXSBJFL_XSCPBJXJ, "
|
|
+ " :XLXSBJFL_XSTZCPBJ,:XLXSBJFL_XSTZBJJE,:XLXSBJFL_XTCPBJYZ,:XLXSBJFL_TLJTZGXQTCL,:XLXSBJFL_YXJJCLLX,:XLXSBJFL_XSYLRYZID,:XLXSBJFL_XSYKJJGHJ,:XLXSBJFL_XSYKJJGLM,"
|
|
+ " :XLXSBJFL_BJCPFZJS,:XLXSBJFL_XHABJCSDP,:XLXSBJFL_LJJCLPLTJFW,:XLXSBJFL_XSYXJ,:XLXSBJFL_XSYZ,:XLXSBJFL_XSFBH,:XLXSBJFL_XSYSCP,:XLXSBJFL_JLBJDHQ,"
|
|
+ " :XLXSBJFL_JYF,:XLXSBJFL_YFWLID,:XLXSBJFL_BJHYF,:XLXSBJFL_XSZDXJ,:XLXSBJFL_ZDXJJCLLX,:XLXSBJFL_JMBGSYZID,:XLXSBJFL_JGMBGRPID,"
|
|
+ " :XLXSBJFL_QYRQ,:XLXSBJFL_TYBZ,:XLXSBJFL_TYRQ,:XLXSBJFL_BZ, :XLXSBJFL_WHR,:XLXSBJFL_WHRID,:XLXSBJFL_WHSJ,:XLXSBJFL_MRCKC,:XLXSBJFL_MXBH,:XLXSBJFL_TBJCLID,:XLXSBJFL_LBJCLID,:XLXSBJFL_ZLGZCLS,:XLXSBJFL_BJDYBJTXS,:XLXSBJFL_BJQSTXS,:XLXSBJFL_ZDXJJCLXX,:XLXSBJFL_ZDXJJCLTXS,:XLXSBJFL_CPBJMRXSWS,:XLXSBJFL_TZWLHQ)",
|
|
|
|
DeleteSql = " delete from XLXSBJFL where XLXSBJFL_BJFLID=:XLXSBJFL_BJFLID ")]
|
|
|
|
public class XLXSBJFL : EntityManager
|
|
{
|
|
|
|
private string _XLXSBJFL_BJFLID;
|
|
[ColumnMap(DbField = "XLXSBJFL_BJFLID", CtrlName = "txtBJFLID", Type = FieldType.C, DbTitle = "报价分类号", DefaultValue = "",
|
|
IsAllowNull = false, IsKey = true, Length = 8)]
|
|
public string XLXSBJFL_BJFLID
|
|
{
|
|
get { return _XLXSBJFL_BJFLID; }
|
|
set { _XLXSBJFL_BJFLID = value; }
|
|
}
|
|
|
|
private string _OLDBJFLID;
|
|
[ColumnMap(DbField = "OLDBJFLID", CtrlName = "txtOLDBJFLID", Type = FieldType.HiddenField, DbTitle = "报价分类号", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 8)]
|
|
public string OLDBJFLID
|
|
{
|
|
get { return _OLDBJFLID; }
|
|
set { _OLDBJFLID = value; }
|
|
}
|
|
|
|
private string _XLXSBJFL_XSXH;
|
|
[ColumnMap(DbField = "XLXSBJFL_XSXH", CtrlName = "txtXSXH", Type = FieldType.F, DbTitle = "显示序号", DefaultValue = "0",
|
|
IsAllowNull = false, IsKey = false, Length = 22)]
|
|
public string XLXSBJFL_XSXH
|
|
{
|
|
get { return _XLXSBJFL_XSXH; }
|
|
set { _XLXSBJFL_XSXH = value; }
|
|
}
|
|
|
|
private string _XLXSBJFL_BJFLMC;
|
|
[ColumnMap(DbField = "XLXSBJFL_BJFLMC", CtrlName = "txtBJFLMC", Type = FieldType.C, DbTitle = "报价分类名称", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 30)]
|
|
public string XLXSBJFL_BJFLMC
|
|
{
|
|
get { return _XLXSBJFL_BJFLMC; }
|
|
set { _XLXSBJFL_BJFLMC = value; }
|
|
}
|
|
|
|
private string _XLXSBJFL_BJFLTZM;
|
|
[ColumnMap(DbField = "XLXSBJFL_BJFLTZM", CtrlName = "txtBJFLTZM", Type = FieldType.C, DbTitle = "报价分类特征码", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 10)]
|
|
public string XLXSBJFL_BJFLTZM
|
|
{
|
|
get { return _XLXSBJFL_BJFLTZM; }
|
|
set { _XLXSBJFL_BJFLTZM = value; }
|
|
}
|
|
|
|
private string _XLXSBJFL_MXBH;
|
|
[ColumnMap(DbField = "XLXSBJFL_MXBH", CtrlName = "cbxMXBH", Type = FieldType.CBX, DbTitle = "价格表类型", DefaultValue = "",
|
|
IsAllowNull = false, IsKey = false, Length = 3)]
|
|
public string XLXSBJFL_MXBH
|
|
{
|
|
get { return _XLXSBJFL_MXBH; }
|
|
set { _XLXSBJFL_MXBH = value; }
|
|
}
|
|
|
|
private string _XLXSBJFL_JGBTJYSS;
|
|
[ColumnMap(DbField = "XLXSBJFL_JGBTJYSS", CtrlName = "cbxJGBTJYSS", Type = FieldType.CL, DbTitle = "价格表调价因素", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 250)]
|
|
public string XLXSBJFL_JGBTJYSS
|
|
{
|
|
get { return _XLXSBJFL_JGBTJYSS; }
|
|
set { _XLXSBJFL_JGBTJYSS = value; }
|
|
}
|
|
|
|
private string _XLXSBJFL_JGBIDS;
|
|
[ColumnMap(DbField = "XLXSBJFL_JGBIDS", CtrlName = "cbxJGBIDS", Type = FieldType.CL, DbTitle = "适用价格表", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 250)]
|
|
public string XLXSBJFL_JGBIDS
|
|
{
|
|
get { return _XLXSBJFL_JGBIDS; }
|
|
set { _XLXSBJFL_JGBIDS = value; }
|
|
}
|
|
|
|
private string _XLXSBJFL_XSQYIDS;
|
|
[ColumnMap(DbField = "XLXSBJFL_XSQYIDS", CtrlName = "cbxXSQYIDS", Type = FieldType.CL, DbTitle = "适用销售区域", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 250)]
|
|
public string XLXSBJFL_XSQYIDS
|
|
{
|
|
get { return _XLXSBJFL_XSQYIDS; }
|
|
set { _XLXSBJFL_XSQYIDS = value; }
|
|
}
|
|
|
|
private string _XLXSBJFL_MRCKC;
|
|
[ColumnMap(DbField = "XLXSBJFL_MRCKC", CtrlName = "chkMRCKC", Type = FieldType.Y, DbTitle = "默认查库存", DefaultValue = "N",
|
|
IsAllowNull = true, IsKey = false, Length = 1)]
|
|
public string XLXSBJFL_MRCKC
|
|
{
|
|
get { return _XLXSBJFL_MRCKC; }
|
|
set { _XLXSBJFL_MRCKC = value; }
|
|
}
|
|
|
|
private string _XLXSBJFL_BJDYBJTXS;
|
|
[ColumnMap(DbField = "XLXSBJFL_BJDYBJTXS", CtrlName = "txtBJDYBJTXS", Type = FieldType.HiddenField, DbTitle = "报价低于表价提醒色", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 10)]
|
|
public string XLXSBJFL_BJDYBJTXS
|
|
{
|
|
get { return _XLXSBJFL_BJDYBJTXS; }
|
|
set { _XLXSBJFL_BJDYBJTXS = value; }
|
|
}
|
|
|
|
private string _XLXSBJFL_BJQSTXS;
|
|
[ColumnMap(DbField = "XLXSBJFL_BJQSTXS", CtrlName = "txtBJQSTXS", Type = FieldType.HiddenField, DbTitle = "表价缺失提醒色", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 10)]
|
|
public string XLXSBJFL_BJQSTXS
|
|
{
|
|
get { return _XLXSBJFL_BJQSTXS; }
|
|
set { _XLXSBJFL_BJQSTXS = value; }
|
|
}
|
|
|
|
private string _XLXSBJFL_ZDXJJCLXX;
|
|
[ColumnMap(DbField = "XLXSBJFL_ZDXJJCLXX", CtrlName = "txtZDXJJCLXX", Type = FieldType.F, DbTitle = "最低限价价差率下限", DefaultValue = "0",
|
|
IsAllowNull = true, IsKey = false, Length = 0)]
|
|
public string XLXSBJFL_ZDXJJCLXX
|
|
{
|
|
get { return _XLXSBJFL_ZDXJJCLXX; }
|
|
set { _XLXSBJFL_ZDXJJCLXX = value; }
|
|
}
|
|
|
|
|
|
private string _XLXSBJFL_ZDXJJCLTXS;
|
|
[ColumnMap(DbField = "XLXSBJFL_ZDXJJCLTXS", CtrlName = "txtZDXJJCLTXS", Type = FieldType.HiddenField, DbTitle = "超限提醒色", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 10)]
|
|
public string XLXSBJFL_ZDXJJCLTXS
|
|
{
|
|
get { return _XLXSBJFL_ZDXJJCLTXS; }
|
|
set { _XLXSBJFL_ZDXJJCLTXS = value; }
|
|
}
|
|
|
|
|
|
private string _XLXSBJFL_CPMLID;
|
|
[ColumnMap(DbField = "XLXSBJFL_CPMLID", CtrlName = "cbxCPMLID", Type = FieldType.CBX, DbTitle = "产品目录", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 2)]
|
|
public string XLXSBJFL_CPMLID
|
|
{
|
|
get { return _XLXSBJFL_CPMLID; }
|
|
set { _XLXSBJFL_CPMLID = value; }
|
|
}
|
|
|
|
//锁定价格表材料行情范围
|
|
private string _XLXSBJFL_SDJGBCLHQFW;
|
|
[ColumnMap(DbField = "XLXSBJFL_SDJGBCLHQFW", CtrlName = "chkSDJGBCLHQFW", Type = FieldType.Y, DbTitle = "锁定价格表材料行情范围", DefaultValue = "N",
|
|
IsAllowNull = true, IsKey = false, Length = 1)]
|
|
public string XLXSBJFL_SDJGBCLHQFW
|
|
{
|
|
get { return _XLXSBJFL_SDJGBCLHQFW; }
|
|
set { _XLXSBJFL_SDJGBCLHQFW = value; }
|
|
}
|
|
|
|
//显示价格表行情料价_XSLJ
|
|
|
|
//显示基价
|
|
private string _XLXSBJFL_XSJGBJJ;
|
|
[ColumnMap(DbField = "XLXSBJFL_XSJGBJJ", CtrlName = "chkXSJGBJJ", Type = FieldType.Y, DbTitle = "显示价格表基价", DefaultValue = "N",
|
|
IsAllowNull = true, IsKey = false, Length = 1)]
|
|
public string XLXSBJFL_XSJGBJJ
|
|
{
|
|
get { return _XLXSBJFL_XSJGBJJ; }
|
|
set { _XLXSBJFL_XSJGBJJ = value; }
|
|
}
|
|
|
|
//XLXSBJFL_XSJGBBJJCE
|
|
private string _XLXSBJFL_XSJGBBJJCE;
|
|
[ColumnMap(DbField = "XLXSBJFL_XSJGBBJJCE", CtrlName = "chkXSJGBBJJCE", Type = FieldType.Y, DbTitle = "显示价格表表价价差额", DefaultValue = "N",
|
|
IsAllowNull = true, IsKey = false, Length = 1)]
|
|
public string XLXSBJFL_XSJGBBJJCE
|
|
{
|
|
get { return _XLXSBJFL_XSJGBBJJCE; }
|
|
set { _XLXSBJFL_XSJGBBJJCE = value; }
|
|
}
|
|
|
|
//显示表价价差率_XSJCL
|
|
|
|
//表价价差率类型
|
|
private string _XLXSBJFL_BJJCLLX;
|
|
[ColumnMap(DbField = "XLXSBJFL_BJJCLLX", CtrlName = "cbxBJJCLLX", Type = FieldType.CBX, DbTitle = "表价价差率公式", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 1)]
|
|
public string XLXSBJFL_BJJCLLX
|
|
{
|
|
get { return _XLXSBJFL_BJJCLLX; }
|
|
set { _XLXSBJFL_BJJCLLX = value; }
|
|
}
|
|
|
|
//意向价价差率类型
|
|
private string _XLXSBJFL_YXJJCLLX;
|
|
[ColumnMap(DbField = "XLXSBJFL_YXJJCLLX", CtrlName = "cbxYXJJCLLX", Type = FieldType.CBX, DbTitle = "意向价价差率公式", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 1)]
|
|
public string XLXSBJFL_YXJJCLLX
|
|
{
|
|
get { return _XLXSBJFL_YXJJCLLX; }
|
|
set { _XLXSBJFL_YXJJCLLX = value; }
|
|
}
|
|
|
|
|
|
private string _XLXSBJFL_XSYLRYZID;
|
|
[ColumnMap(DbField = "XLXSBJFL_XSYLRYZID", CtrlName = "cbxLRYZ", Type = FieldType.CBX, DbTitle = "录入因子", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 10)]
|
|
public string XLXSBJFL_XSYLRYZID
|
|
{
|
|
get { return _XLXSBJFL_XSYLRYZID; }
|
|
set { _XLXSBJFL_XSYLRYZID = value; }
|
|
}
|
|
|
|
private string _XLXSBJFL_XSYKJJGHJ;
|
|
[ColumnMap(DbField = "XLXSBJFL_XSYKJJGHJ", CtrlName = "cbxKJJGHJ", Type = FieldType.CL, DbTitle = "可见价格环节", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 60)]
|
|
public string XLXSBJFL_XSYKJJGHJ
|
|
{
|
|
get { return _XLXSBJFL_XSYKJJGHJ; }
|
|
set { _XLXSBJFL_XSYKJJGHJ = value; }
|
|
}
|
|
|
|
private string _XLXSBJFL_XSYKJJGLM;
|
|
[ColumnMap(DbField = "XLXSBJFL_XSYKJJGLM", CtrlName = "cbxKJJGLM", Type = FieldType.CL, DbTitle = "可见价格栏目", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 30)]
|
|
public string XLXSBJFL_XSYKJJGLM
|
|
{
|
|
get { return _XLXSBJFL_XSYKJJGLM; }
|
|
set { _XLXSBJFL_XSYKJJGLM = value; }
|
|
}
|
|
|
|
private string _XLXSBJFL_TZCLHQ;
|
|
[ColumnMap(DbField = "XLXSBJFL_TZCLHQ", CtrlName = "chkTZCLHQ", Type = FieldType.Y, DbTitle = "调整材料行情", DefaultValue = "N",
|
|
IsAllowNull = true, IsKey = false, Length = 1)]
|
|
public string XLXSBJFL_TZCLHQ
|
|
{
|
|
get { return _XLXSBJFL_TZCLHQ; }
|
|
set { _XLXSBJFL_TZCLHQ = value; }
|
|
}
|
|
|
|
private string _XLXSBJFL_TZWLHQ;
|
|
[ColumnMap(DbField = "XLXSBJFL_TZWLHQ", CtrlName = "chkTZWLHQ", Type = FieldType.Y, DbTitle = "调整物料行情", DefaultValue = "N",
|
|
IsAllowNull = true, IsKey = false, Length = 1)]
|
|
public string XLXSBJFL_TZWLHQ
|
|
{
|
|
get { return _XLXSBJFL_TZWLHQ; }
|
|
set { _XLXSBJFL_TZWLHQ = value; }
|
|
}
|
|
|
|
//调整价格表表价
|
|
private string _XLXSBJFL_TZJGBBJ;
|
|
[ColumnMap(DbField = "XLXSBJFL_TZJGBBJ", CtrlName = "cbxTZJGBBJ", Type = FieldType.CBX, DbTitle = "调整价格表表价", DefaultValue = "1",
|
|
IsAllowNull = true, IsKey = false, Length = 1)]
|
|
public string XLXSBJFL_TZJGBBJ
|
|
{
|
|
get { return _XLXSBJFL_TZJGBBJ; }
|
|
set { _XLXSBJFL_TZJGBBJ = value; }
|
|
}
|
|
|
|
private string _XLXSBJFL_TZBJBJBB;
|
|
[ColumnMap(DbField = "XLXSBJFL_TZBJBJBB", CtrlName = "chkTZBJBJBB", Type = FieldType.Y, DbTitle = "调整表价报价不变", DefaultValue = "N",
|
|
IsAllowNull = true, IsKey = false, Length = 1)]
|
|
public string XLXSBJFL_TZBJBJBB
|
|
{
|
|
get { return _XLXSBJFL_TZBJBJBB; }
|
|
set { _XLXSBJFL_TZBJBJBB = value; }
|
|
}
|
|
|
|
private string _XLXSBJFL_TZBJDHQLJ;
|
|
[ColumnMap(DbField = "XLXSBJFL_TZBJDHQLJ", CtrlName = "cbxTZBJDHQLJ", Type = FieldType.CBX, DbTitle = "调整报价单行情料价", DefaultValue = "1",
|
|
IsAllowNull = true, IsKey = false, Length = 1)]
|
|
public string XLXSBJFL_TZBJDHQLJ
|
|
{
|
|
get { return _XLXSBJFL_TZBJDHQLJ; }
|
|
set { _XLXSBJFL_TZBJDHQLJ = value; }
|
|
}
|
|
|
|
private string _XLXSBJFL_TZBJ;
|
|
[ColumnMap(DbField = "XLXSBJFL_TZBJ", CtrlName = "cbxTZBJ", Type = FieldType.CBX, DbTitle = "调整报价", DefaultValue = "1",
|
|
IsAllowNull = true, IsKey = false, Length = 1)]
|
|
public string XLXSBJFL_TZBJ
|
|
{
|
|
get { return _XLXSBJFL_TZBJ; }
|
|
set { _XLXSBJFL_TZBJ = value; }
|
|
}
|
|
|
|
private string _XLXSBJFL_JGBBJBM;
|
|
[ColumnMap(DbField = "XLXSBJFL_JGBBJBM", CtrlName = "txtJGBBJBM", Type = FieldType.C, DbTitle = "价格表表价别名", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 30)]
|
|
public string XLXSBJFL_JGBBJBM
|
|
{
|
|
get { return _XLXSBJFL_JGBBJBM; }
|
|
set { _XLXSBJFL_JGBBJBM = value; }
|
|
}
|
|
|
|
private string _XLXSBJFL_BJDHQLJBM;
|
|
[ColumnMap(DbField = "XLXSBJFL_BJDHQLJBM", CtrlName = "txtBJDHQLJBM", Type = FieldType.C, DbTitle = "报价单行情料价别名", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 30)]
|
|
public string XLXSBJFL_BJDHQLJBM
|
|
{
|
|
get { return _XLXSBJFL_BJDHQLJBM; }
|
|
set { _XLXSBJFL_BJDHQLJBM = value; }
|
|
}
|
|
|
|
private string _XLXSBJFL_BJBM;
|
|
[ColumnMap(DbField = "XLXSBJFL_BJBM", CtrlName = "txtBJBM", Type = FieldType.C, DbTitle = "报价别名", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 30)]
|
|
public string XLXSBJFL_BJBM
|
|
{
|
|
get { return _XLXSBJFL_BJBM; }
|
|
set { _XLXSBJFL_BJBM = value; }
|
|
}
|
|
|
|
|
|
private string _XLXSBJFL_ZDXJQZBJDFL;
|
|
[ColumnMap(DbField = "XLXSBJFL_ZDXJQZBJDFL", CtrlName = "cbxZDXJQZBJDFL", Type = FieldType.CBX, DbTitle = "最低限价取自报价的分类", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 10)]
|
|
public string XLXSBJFL_ZDXJQZBJDFL
|
|
{
|
|
get { return _XLXSBJFL_ZDXJQZBJDFL; }
|
|
set { _XLXSBJFL_ZDXJQZBJDFL = value; }
|
|
}
|
|
|
|
private string _XLXSBJFL_ZDXJGS;
|
|
[ColumnMap(DbField = "XLXSBJFL_ZDXJGS", CtrlName = "txtValue", Type = FieldType.HiddenField, DbTitle = "最低限价公式", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 250)]
|
|
public string XLXSBJFL_ZDXJGS
|
|
{
|
|
get { return _XLXSBJFL_ZDXJGS; }
|
|
set { _XLXSBJFL_ZDXJGS = value; }
|
|
}
|
|
|
|
private string _XLXSBJFL_JSJGS;
|
|
[ColumnMap(DbField = "XLXSBJFL_JSJGS", CtrlName = "txtJSJGSValue", Type = FieldType.HiddenField, DbTitle = "结算价公式", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 250)]
|
|
public string XLXSBJFL_JSJGS
|
|
{
|
|
get { return _XLXSBJFL_JSJGS; }
|
|
set { _XLXSBJFL_JSJGS = value; }
|
|
}
|
|
|
|
//报价单行情来源
|
|
private string _XLXSBJFL_BJDHQLY;
|
|
[ColumnMap(DbField = "XLXSBJFL_BJDHQLY", CtrlName = "cbxBJDHQLY", Type = FieldType.CBX, DbTitle = "报价单行情来源", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 1)]
|
|
public string XLXSBJFL_BJDHQLY
|
|
{
|
|
get { return _XLXSBJFL_BJDHQLY; }
|
|
set { _XLXSBJFL_BJDHQLY = value; }
|
|
}
|
|
|
|
private string _XLXSBJFL_CPBJMRXSWS;
|
|
[ColumnMap(DbField = "XLXSBJFL_CPBJMRXSWS", CtrlName = "txtCPBJMRXSWS", Type = FieldType.F, DbTitle = "报价默认小数位数", DefaultValue = "0",
|
|
IsAllowNull = true, IsKey = false, Length = 0)]
|
|
public string XLXSBJFL_CPBJMRXSWS
|
|
{
|
|
get { return _XLXSBJFL_CPBJMRXSWS; }
|
|
set { _XLXSBJFL_CPBJMRXSWS = value; }
|
|
}
|
|
|
|
|
|
//报价产品辅助检索
|
|
private string _XLXSBJFL_BJCPFZJS;
|
|
[ColumnMap(DbField = "XLXSBJFL_BJCPFZJS", CtrlName = "cbxBJCPFZJS", Type = FieldType.CBX, DbTitle = "报价产品辅助检索", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 1)]
|
|
public string XLXSBJFL_BJCPFZJS
|
|
{
|
|
get { return _XLXSBJFL_BJCPFZJS; }
|
|
set { _XLXSBJFL_BJCPFZJS = value; }
|
|
}
|
|
|
|
//不按标准覆盖电压
|
|
private string _XLXSBJFL_BABZFGDY;
|
|
[ColumnMap(DbField = "XLXSBJFL_BABZFGDY", CtrlName = "chkBABZFGDY", Type = FieldType.Y, DbTitle = "不按标准覆盖电压", DefaultValue = "N",
|
|
IsAllowNull = true, IsKey = false, Length = 1)]
|
|
public string XLXSBJFL_BABZFGDY
|
|
{
|
|
get { return _XLXSBJFL_BABZFGDY; }
|
|
set { _XLXSBJFL_BABZFGDY = value; }
|
|
}
|
|
|
|
//仅加载价格型号
|
|
private string _XLXSBJFL_JJZJGBXH;
|
|
[ColumnMap(DbField = "XLXSBJFL_JJZJGBXH", CtrlName = "chkJJZJGBXH", Type = FieldType.Y, DbTitle = "仅加载价格型号", DefaultValue = "N",
|
|
IsAllowNull = true, IsKey = false, Length = 1)]
|
|
public string XLXSBJFL_JJZJGBXH
|
|
{
|
|
get { return _XLXSBJFL_JJZJGBXH; }
|
|
set { _XLXSBJFL_JJZJGBXH = value; }
|
|
}
|
|
|
|
//型号按报价次数倒排
|
|
private string _XLXSBJFL_XHABJCSDP;
|
|
[ColumnMap(DbField = "XLXSBJFL_XHABJCSDP", CtrlName = "chkXHABJCSDP", Type = FieldType.Y, DbTitle = "型号按报价次数倒排", DefaultValue = "N",
|
|
IsAllowNull = true, IsKey = false, Length = 1)]
|
|
public string XLXSBJFL_XHABJCSDP
|
|
{
|
|
get { return _XLXSBJFL_XHABJCSDP; }
|
|
set { _XLXSBJFL_XHABJCSDP = value; }
|
|
}
|
|
|
|
//料价价差率批量调价范围
|
|
private string _XLXSBJFL_LJJCLPLTJFW;
|
|
[ColumnMap(DbField = "XLXSBJFL_LJJCLPLTJFW", CtrlName = "cbxLJJCLPLTJFW", Type = FieldType.CL, DbTitle = "料价价差率批量调价范围", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 30)]
|
|
public string XLXSBJFL_LJJCLPLTJFW
|
|
{
|
|
get { return _XLXSBJFL_LJJCLPLTJFW; }
|
|
set { _XLXSBJFL_LJJCLPLTJFW = value; }
|
|
}
|
|
|
|
//铜铝价调整默认更新其他材料
|
|
private string _XLXSBJFL_TLJTZGXQTCL;
|
|
[ColumnMap(DbField = "XLXSBJFL_TLJTZGXQTCL", CtrlName = "chkTLJTZGXQTCL", Type = FieldType.Y, DbTitle = "铜铝价调整默认更新其他材料", DefaultValue = "N",
|
|
IsAllowNull = true, IsKey = false, Length = 1)]
|
|
public string XLXSBJFL_TLJTZGXQTCL
|
|
{
|
|
get { return _XLXSBJFL_TLJTZGXQTCL; }
|
|
set { _XLXSBJFL_TLJTZGXQTCL = value; }
|
|
}
|
|
|
|
//显示意向价
|
|
private string _XLXSBJFL_XSYXJ;
|
|
[ColumnMap(DbField = "XLXSBJFL_XSYXJ", CtrlName = "chkXSYXJ", Type = FieldType.Y, DbTitle = "显示意向价", DefaultValue = "N",
|
|
IsAllowNull = true, IsKey = false, Length = 1)]
|
|
public string XLXSBJFL_XSYXJ
|
|
{
|
|
get { return _XLXSBJFL_XSYXJ; }
|
|
set { _XLXSBJFL_XSYXJ = value; }
|
|
}
|
|
|
|
//显示印字
|
|
private string _XLXSBJFL_XSYZ;
|
|
[ColumnMap(DbField = "XLXSBJFL_XSYZ", CtrlName = "chkXSYZ", Type = FieldType.Y, DbTitle = "显示印字", DefaultValue = "N",
|
|
IsAllowNull = true, IsKey = false, Length = 1)]
|
|
public string XLXSBJFL_XSYZ
|
|
{
|
|
get { return _XLXSBJFL_XSYZ; }
|
|
set { _XLXSBJFL_XSYZ = value; }
|
|
}
|
|
|
|
//显示包号
|
|
private string _XLXSBJFL_XSFBH;
|
|
[ColumnMap(DbField = "XLXSBJFL_XSFBH", CtrlName = "chkXSBH", Type = FieldType.Y, DbTitle = "显示包号", DefaultValue = "N",
|
|
IsAllowNull = true, IsKey = false, Length = 1)]
|
|
public string XLXSBJFL_XSFBH
|
|
{
|
|
get { return _XLXSBJFL_XSFBH; }
|
|
set { _XLXSBJFL_XSFBH = value; }
|
|
}
|
|
|
|
//显示产品报价限价
|
|
private string _XLXSBJFL_XSCPBJXJ;
|
|
[ColumnMap(DbField = "XLXSBJFL_XSCPBJXJ", CtrlName = "chkXSCPBJXJ", Type = FieldType.Y, DbTitle = "显示产品报价限价", DefaultValue = "N",
|
|
IsAllowNull = true, IsKey = false, Length = 1)]
|
|
public string XLXSBJFL_XSCPBJXJ
|
|
{
|
|
get { return _XLXSBJFL_XSCPBJXJ; }
|
|
set { _XLXSBJFL_XSCPBJXJ = value; }
|
|
}
|
|
|
|
//显示原产品
|
|
private string _XLXSBJFL_XSYSCP;
|
|
[ColumnMap(DbField = "XLXSBJFL_XSYSCP", CtrlName = "chkXSYSCP", Type = FieldType.Y, DbTitle = "显示原产品", DefaultValue = "N",
|
|
IsAllowNull = true, IsKey = false, Length = 1)]
|
|
public string XLXSBJFL_XSYSCP
|
|
{
|
|
get { return _XLXSBJFL_XSYSCP; }
|
|
set { _XLXSBJFL_XSYSCP = value; }
|
|
}
|
|
|
|
//型号规格右模糊检索
|
|
private string _XLXSBJFL_XHGGYMHJS;
|
|
[ColumnMap(DbField = "XLXSBJFL_XHGGYMHJS", CtrlName = "chkXHGGYMHJS", Type = FieldType.Y, DbTitle = "型号规格右模糊检索", DefaultValue = "N",
|
|
IsAllowNull = true, IsKey = false, Length = 1)]
|
|
public string XLXSBJFL_XHGGYMHJS
|
|
{
|
|
get { return _XLXSBJFL_XHGGYMHJS; }
|
|
set { _XLXSBJFL_XHGGYMHJS = value; }
|
|
}
|
|
|
|
//料价价差率类型
|
|
private string _XLXSBJFL_LJJCLLX;
|
|
[ColumnMap(DbField = "XLXSBJFL_LJJCLLX", CtrlName = "cbxLJJCLLX", Type = FieldType.CBX, DbTitle = "料价价差率类型", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 1)]
|
|
public string XLXSBJFL_LJJCLLX
|
|
{
|
|
get { return _XLXSBJFL_LJJCLLX; }
|
|
set { _XLXSBJFL_LJJCLLX = value; }
|
|
}
|
|
|
|
//表价料价价差率公式
|
|
private string _XLXSBJFL_BJLJJCLLX;
|
|
[ColumnMap(DbField = "XLXSBJFL_BJLJJCLLX", CtrlName = "cbxBJLJJCL", Type = FieldType.CBX, DbTitle = "表价料价价差率公式", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 1)]
|
|
public string XLXSBJFL_BJLJJCLLX
|
|
{
|
|
get { return _XLXSBJFL_BJLJJCLLX; }
|
|
set { _XLXSBJFL_BJLJJCLLX = value; }
|
|
}
|
|
|
|
//显示调整报价
|
|
private string _XLXSBJFL_XSTZCPBJ;
|
|
[ColumnMap(DbField = "XLXSBJFL_XSTZCPBJ", CtrlName = "chkXSTZCPBJ", Type = FieldType.Y, DbTitle = "显示调整报价", DefaultValue = "N",
|
|
IsAllowNull = true, IsKey = false, Length = 1)]
|
|
public string XLXSBJFL_XSTZCPBJ
|
|
{
|
|
get { return _XLXSBJFL_XSTZCPBJ; }
|
|
set { _XLXSBJFL_XSTZCPBJ = value; }
|
|
}
|
|
|
|
//显示调整最低限价
|
|
private string _XLXSBJFL_XSTZZDXJ;
|
|
[ColumnMap(DbField = "XLXSBJFL_XSTZZDXJ", CtrlName = "chkXSTZZDXJ", Type = FieldType.Y, DbTitle = "显示调整最低限价", DefaultValue = "N",
|
|
IsAllowNull = true, IsKey = false, Length = 1)]
|
|
public string XLXSBJFL_XSTZZDXJ
|
|
{
|
|
get { return _XLXSBJFL_XSTZZDXJ; }
|
|
set { _XLXSBJFL_XSTZZDXJ = value; }
|
|
}
|
|
|
|
|
|
|
|
//显示调整报价金额
|
|
private string _XLXSBJFL_XSTZBJJE;
|
|
[ColumnMap(DbField = "XLXSBJFL_XSTZBJJE", CtrlName = "chkXSTZBJJE", Type = FieldType.Y, DbTitle = "显示调整报价金额", DefaultValue = "N",
|
|
IsAllowNull = true, IsKey = false, Length = 1)]
|
|
public string XLXSBJFL_XSTZBJJE
|
|
{
|
|
get { return _XLXSBJFL_XSTZBJJE; }
|
|
set { _XLXSBJFL_XSTZBJJE = value; }
|
|
}
|
|
|
|
//报价一致校验
|
|
private string _XLXSBJFL_XTCPBJYZ;
|
|
[ColumnMap(DbField = "XLXSBJFL_XTCPBJYZ", CtrlName = "cbxBJYZJY", Type = FieldType.CBX, DbTitle = "报价一致校验", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 1)]
|
|
public string XLXSBJFL_XTCPBJYZ
|
|
{
|
|
get { return _XLXSBJFL_XTCPBJYZ; }
|
|
set { _XLXSBJFL_XTCPBJYZ = value; }
|
|
}
|
|
|
|
private string _XLXSBJFL_TBJCLID;
|
|
[ColumnMap(DbField = "XLXSBJFL_TBJCLID", CtrlName = "cbxTBJCLID", Type = FieldType.CBX, DbTitle = "铜报价材料", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 20)]
|
|
public string XLXSBJFL_TBJCLID
|
|
{
|
|
get { return _XLXSBJFL_TBJCLID; }
|
|
set { _XLXSBJFL_TBJCLID = value; }
|
|
}
|
|
|
|
private string _XLXSBJFL_LBJCLID;
|
|
[ColumnMap(DbField = "XLXSBJFL_LBJCLID", CtrlName = "cbxLBJCLID", Type = FieldType.CBX, DbTitle = "铝报价材料", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 20)]
|
|
public string XLXSBJFL_LBJCLID
|
|
{
|
|
get { return _XLXSBJFL_LBJCLID; }
|
|
set { _XLXSBJFL_LBJCLID = value; }
|
|
}
|
|
|
|
private string _XLXSBJFL_JYF;
|
|
[ColumnMap(DbField = "XLXSBJFL_JYF", CtrlName = "chkJYF", Type = FieldType.Y, DbTitle = "计运费", DefaultValue = "N",
|
|
IsAllowNull = true, IsKey = false, Length = 1)]
|
|
public string XLXSBJFL_JYF
|
|
{
|
|
get { return _XLXSBJFL_JYF; }
|
|
set { _XLXSBJFL_JYF = value; }
|
|
}
|
|
|
|
private string _XLXSBJFL_YFWLID;
|
|
[ColumnMap(DbField = "XLXSBJFL_YFWLID", CtrlName = "cbxYFWLID", Type = FieldType.CBX, DbTitle = "运费物料ID", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 20)]
|
|
public string XLXSBJFL_YFWLID
|
|
{
|
|
get { return _XLXSBJFL_YFWLID; }
|
|
set { _XLXSBJFL_YFWLID = value; }
|
|
}
|
|
|
|
private string _XLXSBJFL_BJHYF;
|
|
[ColumnMap(DbField = "XLXSBJFL_BJHYF", CtrlName = "chkBJHYF", Type = FieldType.Y, DbTitle = "报价含运费", DefaultValue = "N",
|
|
IsAllowNull = true, IsKey = false, Length = 1)]
|
|
public string XLXSBJFL_BJHYF
|
|
{
|
|
get { return _XLXSBJFL_BJHYF; }
|
|
set { _XLXSBJFL_BJHYF = value; }
|
|
}
|
|
|
|
private string _XLXSBJFL_JLBJDHQ;
|
|
[ColumnMap(DbField = "XLXSBJFL_JLBJDHQ", CtrlName = "chkJLBJDHQ", Type = FieldType.Y, DbTitle = "记录报价单行情", DefaultValue = "N",
|
|
IsAllowNull = true, IsKey = false, Length = 1)]
|
|
public string XLXSBJFL_JLBJDHQ
|
|
{
|
|
get { return _XLXSBJFL_JLBJDHQ; }
|
|
set { _XLXSBJFL_JLBJDHQ = value; }
|
|
}
|
|
|
|
private string _XLXSBJFL_ABJDHQJSBJ;
|
|
[ColumnMap(DbField = "XLXSBJFL_ABJDHQJSBJ", CtrlName = "chkABJDHQJSBJ", Type = FieldType.Y, DbTitle = "按报价单行情计算表价", DefaultValue = "N",
|
|
IsAllowNull = true, IsKey = false, Length = 1)]
|
|
public string XLXSBJFL_ABJDHQJSBJ
|
|
{
|
|
get { return _XLXSBJFL_ABJDHQJSBJ; }
|
|
set { _XLXSBJFL_ABJDHQJSBJ = value; }
|
|
}
|
|
|
|
|
|
private string _XLXSBJFL_ZLGZCLS;
|
|
[ColumnMap(DbField = "XLXSBJFL_ZLGZCLS", CtrlName = "cbxZLGZCLS", DbTitle = "重量关注材料", Type = FieldType.CL, DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 250)]
|
|
public string XLXSBJFL_ZLGZCLS
|
|
{
|
|
get { return _XLXSBJFL_ZLGZCLS; }
|
|
set { _XLXSBJFL_ZLGZCLS = value; }
|
|
}
|
|
|
|
private string _XLXSBJFL_ZDXJJCLLX;
|
|
[ColumnMap(DbField = "XLXSBJFL_ZDXJJCLLX", CtrlName = "cbxZDXJJCLLX", DbTitle = "最低限价价差率公式", Type = FieldType.CBX, DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 1)]
|
|
public string XLXSBJFL_ZDXJJCLLX
|
|
{
|
|
get { return _XLXSBJFL_ZDXJJCLLX; }
|
|
set { _XLXSBJFL_ZDXJJCLLX = value; }
|
|
}
|
|
|
|
private string _XLXSBJFL_JMBGSYZID;
|
|
[ColumnMap(DbField = "XLXSBJFL_JMBGSYZID", CtrlName = "cbxJMBGSYZID", DbTitle = "截面比公式适用因子", Type = FieldType.CBX, DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 10)]
|
|
public string XLXSBJFL_JMBGSYZID
|
|
{
|
|
get { return _XLXSBJFL_JMBGSYZID; }
|
|
set { _XLXSBJFL_JMBGSYZID = value; }
|
|
}
|
|
|
|
private string _XLXSBJFL_XSZDXJ;
|
|
[ColumnMap(DbField = "XLXSBJFL_XSZDXJ", CtrlName = "chkXSDZXJ", Type = FieldType.Y, DbTitle = "显示最低限价", DefaultValue = "N",
|
|
IsAllowNull = true, IsKey = false, Length = 1)]
|
|
public string XLXSBJFL_XSZDXJ
|
|
{
|
|
get { return _XLXSBJFL_XSZDXJ; }
|
|
set { _XLXSBJFL_XSZDXJ = value; }
|
|
}
|
|
|
|
|
|
// 私有变量启用日期
|
|
private string _XLXSBJFL_QYRQ;
|
|
[ColumnMap(DbField = "XLXSBJFL_QYRQ", CtrlName = "datQYSJ", Type=FieldType.D, DbTitle = "启用日期",DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 10)]
|
|
public string XLXSBJFL_QYRQ
|
|
{
|
|
get { return _XLXSBJFL_QYRQ; }
|
|
set { _XLXSBJFL_QYRQ = value; }
|
|
}
|
|
|
|
// 私有变量停用标志
|
|
private string _XLXSBJFL_TYBZ;
|
|
[ColumnMap(DbField = "XLXSBJFL_TYBZ", CtrlName = "chkTYBZ", Type=FieldType.Y, DbTitle = "停用标志",DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 1)]
|
|
public string XLXSBJFL_TYBZ
|
|
{
|
|
get { return _XLXSBJFL_TYBZ; }
|
|
set { _XLXSBJFL_TYBZ = value; }
|
|
}
|
|
|
|
// 私有变量停用日期
|
|
private string _XLXSBJFL_TYRQ;
|
|
[ColumnMap(DbField = "XLXSBJFL_TYRQ", CtrlName = "datTYSJ", Type=FieldType.D, DbTitle = "停用日期",DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 10)]
|
|
public string XLXSBJFL_TYRQ
|
|
{
|
|
get { return _XLXSBJFL_TYRQ; }
|
|
set { _XLXSBJFL_TYRQ = value; }
|
|
}
|
|
|
|
private string _XLXSBJFL_BZ;
|
|
[ColumnMap(DbField = "XLXSBJFL_BZ", CtrlName = "txtBZ", DbTitle = "备注", Type = FieldType.C, DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 250)]
|
|
public string XLXSBJFL_BZ
|
|
{
|
|
get { return _XLXSBJFL_BZ; }
|
|
set { _XLXSBJFL_BZ = value; }
|
|
}
|
|
|
|
//仅录入报价产品
|
|
private string _XLXSBJFL_JLRBJCP;
|
|
[ColumnMap(DbField = "XLXSBJFL_JLRBJCP", CtrlName = "chkJLRBJCP", Type = FieldType.Y, DbTitle = "仅录入报价产品", DefaultValue = "N",
|
|
IsAllowNull = true, IsKey = false, Length = 1)]
|
|
public string XLXSBJFL_JLRBJCP
|
|
{
|
|
get { return _XLXSBJFL_JLRBJCP; }
|
|
set { _XLXSBJFL_JLRBJCP = value; }
|
|
}
|
|
|
|
// 私有变量维护人
|
|
private string _XLXSBJFL_WHR;
|
|
[ColumnMap(DbField = "XLXSBJFL_WHR", CtrlName = "txtWHR", Type=FieldType.C, DbTitle = "维护人",DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 30)]
|
|
public string XLXSBJFL_WHR
|
|
{
|
|
get { return _XLXSBJFL_WHR; }
|
|
set { _XLXSBJFL_WHR = value; }
|
|
}
|
|
|
|
// 私有变量维护人工号
|
|
private string _XLXSBJFL_WHRID;
|
|
[ColumnMap(DbField = "XLXSBJFL_WHRID", CtrlName = "txtWHRID", Type = FieldType.HiddenField, DbTitle = "维护人ID", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 10)]
|
|
public string XLXSBJFL_WHRID
|
|
{
|
|
get { return _XLXSBJFL_WHRID; }
|
|
set { _XLXSBJFL_WHRID = value; }
|
|
}
|
|
|
|
// 私有变量维护时间
|
|
private string _XLXSBJFL_WHSJ;
|
|
[ColumnMap(DbField = "XLXSBJFL_WHSJ", CtrlName = "datWHSJ", Type=FieldType.DT, DbTitle = "维护时间",DefaultValue = "",
|
|
IsAllowNull = false, IsKey =true, Length = 18)]
|
|
public string XLXSBJFL_WHSJ
|
|
{
|
|
get { return _XLXSBJFL_WHSJ; }
|
|
set { _XLXSBJFL_WHSJ = value; }
|
|
}
|
|
|
|
//私有变量价格模板GRPID
|
|
private string _XLXSBJFL_JGMBGRPID;
|
|
[ColumnMap(DbField = "XLXSBJFL_JGMBGRPID", CtrlName = "txtDOCGRPID", DbTitle = "文档分组号", Type = FieldType.HiddenField, DefaultValue = "0",
|
|
IsAllowNull = true, IsKey = false, Length = 10)]
|
|
public string XLXSBJFL_JGMBGRPID
|
|
{
|
|
get { return _XLXSBJFL_JGMBGRPID; }
|
|
set { _XLXSBJFL_JGMBGRPID = value; }
|
|
}
|
|
|
|
|
|
private string _XLXSBJFL_JGMBFJS;
|
|
[ColumnMap(DbField = "XLXSBJFL_JGMBFJS", CtrlName = "txtFJS", DbTitle = "附件数", Type = FieldType.HiddenField, DefaultValue = "0",
|
|
IsAllowNull = true, IsKey = false, Length = 10)]
|
|
public string XLXSBJFL_JGMBFJS
|
|
{
|
|
get { return _XLXSBJFL_JGMBFJS; }
|
|
set { _XLXSBJFL_JGMBFJS = value; }
|
|
}
|
|
|
|
|
|
/// <summary>
|
|
/// 根据RGB编码获取颜色名称
|
|
/// </summary>
|
|
/// <param name="sColorID"></param>
|
|
/// <returns></returns>
|
|
public static string GetColourMCByID(string sColorID)
|
|
{
|
|
string sName = "";
|
|
switch (sColorID)
|
|
{
|
|
case "#FFFFFF":
|
|
sName = "白色";
|
|
break;
|
|
case "#FF0000":
|
|
sName = "红色";
|
|
break;
|
|
case "#FF6262":
|
|
sName = "浅红色";
|
|
break;
|
|
case "#FF00FF":
|
|
sName = "紫红色";
|
|
break;
|
|
case "#FFFF00":
|
|
sName = "黄色";
|
|
break;
|
|
case "#F5DEB3":
|
|
sName = "浅黄色";
|
|
break;
|
|
case "#008000":
|
|
sName = "绿色";
|
|
break;
|
|
case "#00FFFF":
|
|
sName = "浅绿色";
|
|
break;
|
|
case "#0000FF":
|
|
sName = "蓝色";
|
|
break;
|
|
case "#8784F0":
|
|
sName = "浅蓝色";
|
|
break;
|
|
case "#F0FFFF":
|
|
sName = "天蓝色";
|
|
break;
|
|
case "#808000":
|
|
sName = "橄榄色";
|
|
break;
|
|
case "#800080":
|
|
sName = "紫色";
|
|
break;
|
|
case "#D4D0C8":
|
|
sName = "灰色";
|
|
break;
|
|
case "无":
|
|
sName = "无";
|
|
break;
|
|
}
|
|
return sName;
|
|
}
|
|
|
|
/// <summary>
|
|
/// 公式编码=>公式名称的转换
|
|
/// </summary>
|
|
/// <param name="sZDXJGS"></param>
|
|
/// <returns></returns>
|
|
public static string GetZDXJGSMC(string sZDXJGS)
|
|
{
|
|
string sReturn = sZDXJGS;
|
|
Dictionary<string, string> dic = XLBJDUtils.GetALLYZIDDic();
|
|
|
|
dic.Add("CLCB", "成本");
|
|
dic.Add("JGBJJ", "基价");
|
|
dic.Add("JGBBJ", "表价");
|
|
dic.Add("CPBJ", "报价");
|
|
dic.Add("ZDXJ", "最低限价");
|
|
|
|
foreach (KeyValuePair<string, string> kvp in dic)
|
|
{
|
|
sReturn = sReturn.Replace(kvp.Key, kvp.Value);
|
|
}
|
|
|
|
return sReturn;
|
|
}
|
|
|
|
/// <summary>
|
|
/// >公式名称=>公式编码的转换
|
|
/// </summary>
|
|
/// <param name="sZDXJGS"></param>
|
|
/// <returns></returns>
|
|
public static string GetZDXJGSBM(string sZDXJGS)
|
|
{
|
|
string sReturn = sZDXJGS;
|
|
Dictionary<string, string> Yzdic = XLBJDUtils.GetALLYZIDDic();
|
|
Dictionary<string, string> dic = new Dictionary<string, string>();
|
|
dic.Clear();
|
|
|
|
foreach (string sYZID in Yzdic.Keys)
|
|
{
|
|
if (!dic.ContainsKey(Yzdic[sYZID]))
|
|
{
|
|
dic.Add(Yzdic[sYZID], sYZID);
|
|
}
|
|
}
|
|
dic.Add("成本", "CLCB");
|
|
dic.Add("基价", "JGBJJ");
|
|
dic.Add("表价", "JGBBJ");
|
|
dic.Add("报价", "CPBJ");
|
|
dic.Add("最低限价", "ZDXJ");
|
|
|
|
foreach (KeyValuePair<string, string> kvp in dic)
|
|
{
|
|
sReturn = sReturn.Replace(kvp.Key, kvp.Value);
|
|
}
|
|
|
|
return sReturn;
|
|
}
|
|
|
|
|
|
}
|
|
}
|