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 GThinking.N_MISPRO.Utility;
using GThinking.N_MISPRO.Data;
using GThinking.N_MISPRO.TableCache;
using GThinking.N_PUBLIC2;


namespace GThinking.N_XLXSBJ
{
    [TableMap(DB = "DBERP", DbTableName = "TBYSB", Umid = 100860168, IsWorkFlow = true, IsAttach = true,
   DOCGRPIDFieldName = "TBYSB_DOCGRPID", DOCFJSFieldName = "TBYSB_FJS",
    QuerySelSql = "",
    DefaultFilter = " ",
 EntitySelSql = "select TBYSB_SPDH, TBYSB_FQR, TBYSB_SYDWID, TBYSB_XMID, TBYSB_TBJE, TBYSB_XMMC, TBYSB_TBRQ, TBYSB_FJS, \r\n"
           + " TBYSB_DOCGRPID, TBYSB_WFID, TBYSB_WFINST, TBYSB_WPID, TBYSB_WFAWAITER, TBYSB_WFHANDLER, TBYSB_ACTNAME, TBYSB_ZBF, \r\n"
           + " TBYSB_TBDZ, TBYSB_TBJZRQ, TBYSB_XJYQ, TBYSB_BSJFXS, TBYSB_TBBZJJE, TBYSB_TBBZJXS, TBYSB_ZWFKSJ, TBYSB_BMID,TBYSB_TBZT, \r\n"
           + " TBYSB_SQDB, TBYSB_BSJFSJ, TBYSB_GDFKTJ, TBYSB_CNFKTJ, TBYSB_QTYQ, TBYSB_SFXYCADZYS, TBYSB_JSPCNR, \r\n"
           + " TBYSB_WHR,TBYSB_WHRID,TBYSB_WHSJ,TBYSB_GKFZR \r\n"
           + " from TBYSB where TBYSB_SPDH=:TBYSB_SPDH",

    UpdateSql = "update TBYSB set  \r\n"
           + "TBYSB_FQR=:TBYSB_FQR, \r\n"
           + "TBYSB_SYDWID=:TBYSB_SYDWID, \r\n"
           + "TBYSB_XMID=:TBYSB_XMID, \r\n"
           + "TBYSB_TBJE=:TBYSB_TBJE, \r\n"
           + "TBYSB_XMMC=:TBYSB_XMMC, \r\n"
           + "TBYSB_TBRQ=:TBYSB_TBRQ, \r\n"
           + "TBYSB_FJS=:TBYSB_FJS, \r\n"
           + "TBYSB_TBDZ=:TBYSB_TBDZ, \r\n"
           + "TBYSB_DOCGRPID=:TBYSB_DOCGRPID, \r\n"
           + "TBYSB_ZBF=:TBYSB_ZBF, \r\n"
           + "TBYSB_TBJZRQ=:TBYSB_TBJZRQ, \r\n"
           + "TBYSB_XJYQ=:TBYSB_XJYQ, \r\n"
           + "TBYSB_BSJFXS=:TBYSB_BSJFXS, \r\n"
           + "TBYSB_TBBZJJE=:TBYSB_TBBZJJE, \r\n"
           + "TBYSB_TBBZJXS=:TBYSB_TBBZJXS, \r\n"
           + "TBYSB_ZWFKSJ=:TBYSB_ZWFKSJ, \r\n"
           + "TBYSB_BMID=:TBYSB_BMID, \r\n"
           + "TBYSB_TBZT=:TBYSB_TBZT, \r\n"
           + "TBYSB_SQDB=:TBYSB_SQDB, \r\n"
           + "TBYSB_BSJFSJ=:TBYSB_BSJFSJ, \r\n"
           + "TBYSB_GDFKTJ=:TBYSB_GDFKTJ, \r\n"
           + "TBYSB_CNFKTJ=:TBYSB_CNFKTJ, \r\n"
           + "TBYSB_QTYQ=:TBYSB_QTYQ, \r\n"
           + "TBYSB_SFXYCADZYS=:TBYSB_SFXYCADZYS,\r\n"
           + "TBYSB_JSPCNR=:TBYSB_JSPCNR, \r\n"
           + "TBYSB_WHR=:TBYSB_WHR, \r\n"
           + "TBYSB_WHRID=:TBYSB_WHRID, \r\n"
           + "TBYSB_WHSJ=:TBYSB_WHSJ, \r\n"
           + "TBYSB_GKFZR=:TBYSB_GKFZR \r\n"
           + " where TBYSB_SPDH=:TBYSB_SPDH ",

  InsertSql = "insert into TBYSB( TBYSB_SPDH, TBYSB_FQR, TBYSB_SYDWID, TBYSB_XMID, TBYSB_TBJE, TBYSB_XMMC, TBYSB_TBRQ, TBYSB_FJS, \r\n"
        + " TBYSB_DOCGRPID, TBYSB_ZBF, \r\n"
        + " TBYSB_TBDZ, TBYSB_TBJZRQ, TBYSB_XJYQ, TBYSB_BSJFXS, TBYSB_TBBZJJE, TBYSB_TBBZJXS, TBYSB_ZWFKSJ, TBYSB_BMID,TBYSB_TBZT, \r\n"
        + " TBYSB_SQDB, TBYSB_BSJFSJ, TBYSB_GDFKTJ, TBYSB_CNFKTJ, TBYSB_QTYQ, TBYSB_SFXYCADZYS, TBYSB_JSPCNR, \r\n"
        + " TBYSB_WHR,TBYSB_WHRID,TBYSB_WHSJ,TBYSB_GKFZR)\r\n"


        + " values(:TBYSB_SPDH, :TBYSB_FQR, :TBYSB_SYDWID, :TBYSB_XMID, :TBYSB_TBJE, :TBYSB_XMMC, :TBYSB_TBRQ, :TBYSB_FJS, \r\n"
        + " :TBYSB_DOCGRPID, :TBYSB_ZBF, \r\n"
        + " :TBYSB_TBDZ, :TBYSB_TBJZRQ, :TBYSB_XJYQ, :TBYSB_BSJFXS, :TBYSB_TBBZJJE, :TBYSB_TBBZJXS, :TBYSB_ZWFKSJ, :TBYSB_BMID, :TBYSB_TBZT, \r\n"
        + " :TBYSB_SQDB, :TBYSB_BSJFSJ, :TBYSB_GDFKTJ, :TBYSB_CNFKTJ, :TBYSB_QTYQ, :TBYSB_SFXYCADZYS, :TBYSB_JSPCNR, \r\n"
        + " :TBYSB_WHR,  :TBYSB_WHRID,  :TBYSB_WHSJ,  :TBYSB_GKFZR )",

    DeleteSql = "delete from TBYSB where TBYSB_SPDH=:TBYSB_SPDH ")]

    public class TBYS : EntityManager
    {
        #region 字段级映射
        
        private string _TBYSB_SPDH;
        [ColumnMap(DbField = "TBYSB_SPDH", CtrlName = "txtSPDH", DbTitle = "审批单号", Type = FieldType.C, DefaultValue = "",
         IsAllowNull = true, IsKey = true, Length = 20)]
        
        public string TBYSB_SPDH
        {
            get { return _TBYSB_SPDH; }
            set { _TBYSB_SPDH = value; }
        }

        private string _TBYSB_FQR;
        [ColumnMap(DbField = "TBYSB_FQR", CtrlName = "txtFQR", DbTitle = "发起人", Type = FieldType.C, DefaultValue = "",
         IsAllowNull = true, IsKey = false, Length = 30)]
        public string TBYSB_FQR
        {
            get { return _TBYSB_FQR; }
            set { _TBYSB_FQR = value; }
        }

        private string _TBYSB_SYDWID;
        [ColumnMap(DbField = "TBYSB_SYDWID", CtrlName = "cbxSYDWID", DbTitle = "使用单位ID", Type = FieldType.CBX, DefaultValue = "",
         IsAllowNull = true, IsKey = false, Length = 4)]
        public string TBYSB_SYDWID
        {
            get { return _TBYSB_SYDWID; }
            set { _TBYSB_SYDWID = value; }
        }

        private string _TBYSB_XMID;
        [ColumnMap(DbField = "TBYSB_XMID", CtrlName = "txtXMID", DbTitle = "项目ID", Type = FieldType.C, DefaultValue = "",
         IsAllowNull = true, IsKey = false, Length = 10)]
        public string TBYSB_XMID
        {
            get { return _TBYSB_XMID; }
            set { _TBYSB_XMID = value; }
        }

        private decimal _TBYSB_TBJE;
        [ColumnMap(DbField = "TBYSB_TBJE", CtrlName = "txtTBJE", DbTitle = "投标金额", Type = FieldType.F, DefaultValue = "",
         IsAllowNull = true, IsKey = false, Length = 0)]
        public decimal TBYSB_TBJE
        {
            get { return _TBYSB_TBJE; }
            set { _TBYSB_TBJE = value; }
        }

        private string _TBYSB_XMMC;
        [ColumnMap(DbField = "TBYSB_XMMC", CtrlName = "txtXMMC", DbTitle = "项目名称", Type = FieldType.C, DefaultValue = "",
         IsAllowNull = true, IsKey = false, Length = 250)]
        public string TBYSB_XMMC
        {
            get { return _TBYSB_XMMC; }
            set { _TBYSB_XMMC = value; }
        }

        private string _TBYSB_TBRQ;
        [ColumnMap(DbField = "TBYSB_TBRQ", CtrlName = "datTBRQ", DbTitle = "投标日期", Type = FieldType.D, DefaultValue = "",
         IsAllowNull = true, IsKey = false, Length = 23)]
        public string TBYSB_TBRQ
        {
            get { return _TBYSB_TBRQ; }
            set { _TBYSB_TBRQ = value; }
        }

        private decimal _TBYSB_FJS;
        [ColumnMap(DbField = "TBYSB_FJS", CtrlName = "txtFJS", DbTitle = "附件数", Type = FieldType.F, DefaultValue = "",
         IsAllowNull = true, IsKey = false, Length = 8)]
        public decimal TBYSB_FJS
        {
            get { return _TBYSB_FJS; }
            set { _TBYSB_FJS = value; }
        }

        private decimal _TBYSB_DOCGRPID;
        [ColumnMap(DbField = "TBYSB_DOCGRPID", DbTitle = "文档分组号", CtrlName = "txtDOCGRPID", Type = FieldType.HiddenField, DefaultValue = "",
         IsAllowNull = true, IsKey = false, Length = 8)]
        public decimal TBYSB_DOCGRPID
        {
            get { return _TBYSB_DOCGRPID; }
            set { _TBYSB_DOCGRPID = value; }
        }

        private string _TBYSB_WFID;
        [ColumnMap(DbField = "TBYSB_WFID", CtrlName = "txtWFID", DbTitle = "工作流号", Type = FieldType.HiddenField, DefaultValue = "",
         IsAllowNull = true, IsKey = false, Length = 10)]
        public string TBYSB_WFID
        {
            get { return _TBYSB_WFID; }
            set { _TBYSB_WFID = value; }
        }

        private decimal _TBYSB_WFINST;
        [ColumnMap(DbField = "TBYSB_WFINST", CtrlName = "txtWFINST", DbTitle = "工作流实例号", Type = FieldType.HiddenField, DefaultValue = "",
         IsAllowNull = true, IsKey = false, Length = 8)]
        public decimal TBYSB_WFINST
        {
            get { return _TBYSB_WFINST; }
            set { _TBYSB_WFINST = value; }
        }

        private string _TBYSB_WPID;
        [ColumnMap(DbField = "TBYSB_WPID", CtrlName = "txtWPID", DbTitle = "流程状态", Type = FieldType.HiddenField, DefaultValue = "",
         IsAllowNull = true, IsKey = false, Length = 4)]
        public string TBYSB_WPID
        {
            get { return _TBYSB_WPID; }
            set { _TBYSB_WPID = value; }
        }

        private string _TBYSB_WFAWAITER;
        [ColumnMap(DbField = "TBYSB_WFAWAITER", CtrlName = "txtAWAITER", DbTitle = "待处理人", Type = FieldType.HiddenField, DefaultValue = "",
         IsAllowNull = true, IsKey = false, Length = 250)]
        public string TBYSB_WFAWAITER
        {
            get { return _TBYSB_WFAWAITER; }
            set { _TBYSB_WFAWAITER = value; }
        }

        private string _TBYSB_WFHANDLER;
        [ColumnMap(DbField = "TBYSB_WFHANDLER", CtrlName = "txtHANDLER", DbTitle = "已处理人", Type = FieldType.HiddenField, DefaultValue = "",
         IsAllowNull = true, IsKey = false, Length = 250)]
        public string TBYSB_WFHANDLER
        {
            get { return _TBYSB_WFHANDLER; }
            set { _TBYSB_WFHANDLER = value; }
        }

        private string _TBYSB_ACTNAME;
        [ColumnMap(DbField = "TBYSB_ACTNAME", CtrlName = "txtACTNAME", DbTitle = "ACTNAME", Type = FieldType.HiddenField, DefaultValue = "",
         IsAllowNull = true, IsKey = false, Length = 10)]
        public string TBYSB_ACTNAME
        {
            get { return _TBYSB_ACTNAME; }
            set { _TBYSB_ACTNAME = value; }
        }

        private string _TBYSB_ZBF;
        [ColumnMap(DbField = "TBYSB_ZBF", CtrlName = "txtZBF", DbTitle = "招标方", Type = FieldType.C, DefaultValue = "",
         IsAllowNull = true, IsKey = false, Length = 120)]
        public string TBYSB_ZBF
        {
            get { return _TBYSB_ZBF; }
            set { _TBYSB_ZBF = value; }
        }

        private string _TBYSB_TBDZ;
        [ColumnMap(DbField = "TBYSB_TBDZ", CtrlName = "txtTBDZ", DbTitle = "投标地址", Type = FieldType.C, DefaultValue = "",
         IsAllowNull = true, IsKey = false, Length = 250)]
        public string TBYSB_TBDZ
        {
            get { return _TBYSB_TBDZ; }
            set { _TBYSB_TBDZ = value; }
        }

        private string _TBYSB_TBJZRQ;
        [ColumnMap(DbField = "TBYSB_TBJZRQ", CtrlName = "datTBJZRQ", DbTitle = "投标截止日期", Type = FieldType.D, DefaultValue = "",
         IsAllowNull = true, IsKey = false, Length = 23)]
        public string TBYSB_TBJZRQ
        {
            get { return _TBYSB_TBJZRQ; }
            set { _TBYSB_TBJZRQ = value; }
        }

        private string _TBYSB_XJYQ;
        [ColumnMap(DbField = "TBYSB_XJYQ", CtrlName = "txtXJYQ", DbTitle = "限价要求", Type = FieldType.C, DefaultValue = "",
         IsAllowNull = true, IsKey = false, Length = 250)]
        public string TBYSB_XJYQ
        {
            get { return _TBYSB_XJYQ; }
            set { _TBYSB_XJYQ = value; }
        }

        private string _TBYSB_BSJFXS;
        [ColumnMap(DbField = "TBYSB_BSJFXS", CtrlName = "cbxBSJFXS", DbTitle = "标书交付形式", Type = FieldType.CBX, DefaultValue = "",
         IsAllowNull = true, IsKey = false, Length = 1)]
        public string TBYSB_BSJFXS
        {
            get { return _TBYSB_BSJFXS; }
            set { _TBYSB_BSJFXS = value; }
        }

        private decimal _TBYSB_TBBZJJE;
        [ColumnMap(DbField = "TBYSB_TBBZJJE", CtrlName = "txtTBBZJJE", DbTitle = "投标保证金金额", Type = FieldType.F, DefaultValue = "",
         IsAllowNull = false, IsKey = false, Length = 30)]
        public decimal TBYSB_TBBZJJE
        {
            get { return _TBYSB_TBBZJJE; }
            set { _TBYSB_TBBZJJE = value; }
        }

        private string _TBYSB_TBBZJXS;
        [ColumnMap(DbField = "TBYSB_TBBZJXS", CtrlName = "cbxTBBZJXS", DbTitle = "投标保证金形式", Type = FieldType.CBX, DefaultValue = "",
         IsAllowNull = true, IsKey = false, Length = 10)]
        public string TBYSB_TBBZJXS
        {
            get { return _TBYSB_TBBZJXS; }
            set { _TBYSB_TBBZJXS = value; }
        }

        private DateTime _TBYSB_ZWFKSJ;
        [ColumnMap(DbField = "TBYSB_ZWFKSJ", CtrlName = "datZWFKSJ", DbTitle = "最晚付款时间", Type = FieldType.D, DefaultValue = "",
         IsAllowNull = true, IsKey = false, Length = 30)]
        public DateTime TBYSB_ZWFKSJ
        {
            get { return _TBYSB_ZWFKSJ; }
            set { _TBYSB_ZWFKSJ = value; }
        }

        private string _TBYSB_BMID;
        [ColumnMap(DbField = "TBYSB_BMID", CtrlName = "cbxBMID", DbTitle = "部门ID", Type = FieldType.CBX, DefaultValue = "",
         IsAllowNull = true, IsKey = false, Length = 8)]
        public string TBYSB_BMID
        {
            get { return _TBYSB_BMID; }
            set { _TBYSB_BMID = value; }
        }

        private string _TBYSB_TBZT;
        [ColumnMap(DbField = "TBYSB_TBZT", CtrlName = "txtTBZT", DbTitle = "投标主体", Type = FieldType.C, DefaultValue = "",
         IsAllowNull = true, IsKey = false, Length = 120)]
        public string TBYSB_TBZT
        {
            get { return _TBYSB_TBZT; }
            set { _TBYSB_TBZT = value; }
        }

        private string _TBYSB_SQDB;
        [ColumnMap(DbField = "TBYSB_SQDB", CtrlName = "txtSQDB", DbTitle = "授权代表", Type = FieldType.C, DefaultValue = "",
         IsAllowNull = false, IsKey = false, Length = 50)]
        public string TBYSB_SQDB
        {
            get { return _TBYSB_SQDB; }
            set { _TBYSB_SQDB = value; }
        }

        private DateTime _TBYSB_BSJFSJ;
        [ColumnMap(DbField = "TBYSB_BSJFSJ", CtrlName = "datBSJFSJ", DbTitle = "标书交付时间", Type = FieldType.D, DefaultValue = "",
         IsAllowNull = true, IsKey = false, Length = 30)]
        public DateTime TBYSB_BSJFSJ
        {
            get { return _TBYSB_BSJFSJ; }
            set { _TBYSB_BSJFSJ = value; }
        }

        private string _TBYSB_GDFKTJ;
        [ColumnMap(DbField = "TBYSB_GDFKTJ", CtrlName = "txtGDFKTJ", DbTitle = "规定付款条件", Type = FieldType.C, DefaultValue = "",
         IsAllowNull = true, IsKey = false, Length = 1000)]
        public string TBYSB_GDFKTJ
        {
            get { return _TBYSB_GDFKTJ; }
            set { _TBYSB_GDFKTJ = value; }
        }

        private string _TBYSB_CNFKTJ;
        [ColumnMap(DbField = "TBYSB_CNFKTJ", CtrlName = "txtCNFKTJ", DbTitle = "承诺付款条件", Type = FieldType.C, DefaultValue = "",
         IsAllowNull = true, IsKey = false, Length = 1000)]
        public string TBYSB_CNFKTJ
        {
            get { return _TBYSB_CNFKTJ; }
            set { _TBYSB_CNFKTJ = value; }
        }

        private string _TBYSB_QTYQ;
        [ColumnMap(DbField = "TBYSB_QTYQ", CtrlName = "txtQTYQ", DbTitle = "其他要求", Type = FieldType.C, DefaultValue = "",
         IsAllowNull = true, IsKey = false, Length = 1000)]
        public string TBYSB_QTYQ
        {
            get { return _TBYSB_QTYQ; }
            set { _TBYSB_QTYQ = value; }
        }

        private string _TBYSB_SFXYCADZYS;
        [ColumnMap(DbField = "TBYSB_SFXYCADZYS", CtrlName = "cbxSFXYCADZYS", DbTitle = "是否需要CA电子钥匙", Type = FieldType.CBX, DefaultValue = "",
         IsAllowNull = false, IsKey = false, Length = 1)]
        public string TBYSB_SFXYCADZYS
        {
            get { return _TBYSB_SFXYCADZYS; }
            set { _TBYSB_SFXYCADZYS = value; }
        }

        private string _TBYSB_JSPCNR;
        [ColumnMap(DbField = "TBYSB_JSPCNR", CtrlName = "txtJSPCNR", DbTitle = "投标文件的付款方式", Type = FieldType.C, DefaultValue = "",
         IsAllowNull = false, IsKey = false, Length = 1000)]
        public string TBYSB_JSPCNR
        {
            get { return _TBYSB_JSPCNR; }
            set { _TBYSB_JSPCNR = value; }
        }

        private string _TBYSB_WHR;
        [ColumnMap(DbField = "TBYSB_WHR", CtrlName = "txtWHR", DbTitle = "维护人", Type = FieldType.C, DefaultValue = "",
         IsAllowNull = true, IsKey = false, Length = 30)]
        public string TBYSB_WHR
        {
            get { return _TBYSB_WHR; }
            set { _TBYSB_WHR = value; }
        }

        private string _TBYSB_WHRID;
        [ColumnMap(DbField = "TBYSB_WHRID", CtrlName = "txtWHRID", DbTitle = "维护人ID", Type = FieldType.HiddenField, DefaultValue = "",
         IsAllowNull = true, IsKey = false, Length = 10)]
        public string TBYSB_WHRID
        {
            get { return _TBYSB_WHRID; }
            set { _TBYSB_WHRID = value; }
        }

        private DateTime _TBYSB_WHSJ;
        [ColumnMap(DbField = "TBYSB_WHSJ", CtrlName = "datWHSJ", DbTitle = "维护时间", Type = FieldType.DT, DefaultValue = "",
         IsAllowNull = true, IsKey = false, Length = 30)]
        public DateTime TBYSB_WHSJ
        {
            get { return _TBYSB_WHSJ; }
            set { _TBYSB_WHSJ = value; }
        }

        private string _TBYSB_GKFZR;
        [ColumnMap(DbField = "TBYSB_GKFZR", CtrlName = "txtGKFZR", DbTitle = "归口负责人", Type = FieldType.C, DefaultValue = "",
         IsAllowNull = true, IsKey = false, Length = 120)]
        public string TBYSB_GKFZR
        {
            get { return _TBYSB_GKFZR; }
            set { _TBYSB_GKFZR = value; }
        }

        #endregion
    }
}