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;

namespace GThinking.N_XLJC
{
    [TableMap(DB = "DBERP", DbTableName = "XLJGCZBML", Umid = 101421008, IsWorkFlow = false, UseWhr = true, IsAttach = false,

     QuerySelSql = @"SELECT XLJGCZBML_JGCZBID, XLJGCZBML_JGCZBID as OLD_XLJGCZBML_JGCZBID, XLJGCZBML_JGCZBMC,XLJGCZBML_FZR,XLJGCZBML_CZBJLDW,
                        XLJGCZBML_XLGGDW,XLJGCZBML_CZBLX,XLJGCZBML_GGHLX,
                        XLJGCZBML_XLBZBN,XLJGCZBML_DYDJBN,XLJGCZBML_XLXHBN,XLJGCZBML_GYFLBM,
                        XLJGCZBML_JGCZBBBID,XLJGCZBML_EXCEL,XLJGCZBML_SHEET,XLJGCZBBB_GYFLBBID,
                        XLJGCZBML_CPMLID,XLJGCZBML_WHRID,XLJGCZBML_WHR,XLJGCZBML_WHSJ
                        from XLJGCZBML 
                        left join XLJGCZBBB on XLJGCZBBB_JGCZBBBID=XLJGCZBML_JGCZBBBID and XLJGCZBBB_JGCZBID=XLJGCZBML_JGCZBID          
                        where 1 = 1 order by XLJGCZBML_JGCZBID",

      EntitySelSql = @"SELECT XLJGCZBML_JGCZBID,  XLJGCZBML_JGCZBID as OLD_XLJGCZBML_JGCZBID, XLJGCZBML_JGCZBMC, XLJGCZBML_FZR,XLJGCZBML_CZBJLDW,
                        XLJGCZBML_XLGGDW,XLJGCZBML_CZBLX,XLJGCZBML_GGHLX,
                        XLJGCZBML_XLBZBN,XLJGCZBML_DYDJBN,XLJGCZBML_XLXHBN,XLJGCZBML_GYFLBM,
                        XLJGCZBML_JGCZBBBID,XLJGCZBML_EXCEL,XLJGCZBML_SHEET,XLJGCZBBB_GYFLBBID,
                        XLJGCZBML_CPMLID,XLJGCZBML_WHRID,XLJGCZBML_WHR,XLJGCZBML_WHSJ
                        from XLJGCZBML
                        left join XLJGCZBBB on XLJGCZBBB_JGCZBBBID=XLJGCZBML_JGCZBBBID and XLJGCZBBB_JGCZBID=XLJGCZBML_JGCZBID           
                        where XLJGCZBML_JGCZBID = :XLJGCZBML_JGCZBID",

       InsertSql = @"insert into XLJGCZBML (XLJGCZBML_JGCZBID,XLJGCZBML_JGCZBMC,XLJGCZBML_FZR,XLJGCZBML_CZBJLDW,
                        XLJGCZBML_XLGGDW,XLJGCZBML_CZBLX,XLJGCZBML_GGHLX,
                        XLJGCZBML_XLBZBN,XLJGCZBML_DYDJBN,XLJGCZBML_XLXHBN,XLJGCZBML_GYFLBM,
                        XLJGCZBML_JGCZBBBID,XLJGCZBML_EXCEL,XLJGCZBML_SHEET,
                        XLJGCZBML_CPMLID,XLJGCZBML_WHRID,XLJGCZBML_WHR,XLJGCZBML_WHSJ )
                 values(:XLJGCZBML_JGCZBID,:XLJGCZBML_JGCZBMC, :XLJGCZBML_FZR,:XLJGCZBML_CZBJLDW,
                        :XLJGCZBML_XLGGDW,:XLJGCZBML_CZBLX,:XLJGCZBML_GGHLX,
                        :XLJGCZBML_XLBZBN,:XLJGCZBML_DYDJBN,:XLJGCZBML_XLXHBN,:XLJGCZBML_GYFLBM,
                        :XLJGCZBML_JGCZBBBID,:XLJGCZBML_EXCEL,:XLJGCZBML_SHEET,
                        :XLJGCZBML_CPMLID,:XLJGCZBML_WHRID,:XLJGCZBML_WHR,:XLJGCZBML_WHSJ )",

        UpdateSql = @"update XLJGCZBML set  XLJGCZBML_JGCZBID=:XLJGCZBML_JGCZBID,XLJGCZBML_JGCZBMC=:XLJGCZBML_JGCZBMC,XLJGCZBML_FZR=:XLJGCZBML_FZR,
                        XLJGCZBML_CZBJLDW=:XLJGCZBML_CZBJLDW,XLJGCZBML_XLGGDW=:XLJGCZBML_XLGGDW,XLJGCZBML_CZBLX=:XLJGCZBML_CZBLX,
                        XLJGCZBML_GGHLX=:XLJGCZBML_GGHLX,
                        XLJGCZBML_XLBZBN=:XLJGCZBML_XLBZBN,XLJGCZBML_DYDJBN=:XLJGCZBML_DYDJBN,XLJGCZBML_XLXHBN=:XLJGCZBML_XLXHBN,XLJGCZBML_GYFLBM=:XLJGCZBML_GYFLBM,
                        XLJGCZBML_JGCZBBBID=:XLJGCZBML_JGCZBBBID,XLJGCZBML_EXCEL=:XLJGCZBML_EXCEL,XLJGCZBML_SHEET=:XLJGCZBML_SHEET,
                        XLJGCZBML_CPMLID=:XLJGCZBML_CPMLID,XLJGCZBML_WHRID=:XLJGCZBML_WHRID,XLJGCZBML_WHR=:XLJGCZBML_WHR,XLJGCZBML_WHSJ=:XLJGCZBML_WHSJ
                                where XLJGCZBML_JGCZBID = :OLD_XLJGCZBML_JGCZBID",

        DeleteSql = @"delete from XLJGCZBML where XLJGCZBML_JGCZBID = :XLJGCZBML_JGCZBID")]

    public class XLJGCZB : EntityManager
    {
        #region 字段级映射

        private string _XLJGCZBML_JGCZBID;
        [ColumnMap(DbField = "XLJGCZBML_JGCZBID", CtrlName = "txtJGCZBID", DbTitle = "表号", Type = FieldType.C, DefaultValue = "",
           IsAllowNull = true, IsKey = true, Length = 10)]
        public string XLJGCZBML_JGCZBID
        {
            get { return _XLJGCZBML_JGCZBID; }
            set { _XLJGCZBML_JGCZBID = value; }
        }

        private string _OLD_XLJGCZBML_JGCZBID;
        [ColumnMap(DbField = "OLD_XLJGCZBML_JGCZBID", CtrlName = "txtOLDJGCZBID", Type = FieldType.HiddenField,
        DbTitle = "结构尺重表ID", DefaultValue = "", PrintVisible = false,
         IsAllowNull = true, IsKey = false, Length = 10)]
        public string OLD_XLJGCZBML_JGCZBID
        {
            get { return _OLD_XLJGCZBML_JGCZBID; }
            set { _OLD_XLJGCZBML_JGCZBID = value; }
        }

        private string _XLJGCZBML_JGCZBMC;
        [ColumnMap(DbField = "XLJGCZBML_JGCZBMC", CtrlName = "txtJGCZBMC", DbTitle = "表名", Type = FieldType.C, DefaultValue = "",
          IsAllowNull = false, IsKey = false, Length = 100)]
        public string XLJGCZBML_JGCZBMC
        {
            get { return _XLJGCZBML_JGCZBMC; }
            set { _XLJGCZBML_JGCZBMC = value; }
        }

        private string _XLJGCZBML_JGCZBBBID;
        [ColumnMap(DbField = "XLJGCZBML_JGCZBBBID", CtrlName = "txtJGCZBBBID", DbTitle = "尺重表版本", Type = FieldType.C, DefaultValue = "",
           IsAllowNull = true, IsKey = false, Length = 10)]
        public string XLJGCZBML_JGCZBBBID
        {
            get { return _XLJGCZBML_JGCZBBBID; }
            set { _XLJGCZBML_JGCZBBBID = value; }
        }

        private string _XLJGCZBML_FZR;
        [ColumnMap(DbField = "XLJGCZBML_FZR", CtrlName = "txtFZR", DbTitle = "负责人", Type = FieldType.C, DefaultValue = "",
           IsAllowNull = true, IsKey = false, Length = 30)]
        public string XLJGCZBML_FZR
        {
            get { return _XLJGCZBML_FZR; }
            set { _XLJGCZBML_FZR = value; }
        }

        private string _XLJGCZBML_CZBJLDW;
        [ColumnMap(DbField = "XLJGCZBML_CZBJLDW", CtrlName = "cbxCZBJLDW", DbTitle = "尺重表计量单位", Type = FieldType.CBX, DefaultValue = "",
           IsAllowNull = true, IsKey = false, Length = 1)]
        public string XLJGCZBML_CZBJLDW
        {
            get { return _XLJGCZBML_CZBJLDW; }
            set { _XLJGCZBML_CZBJLDW = value; }
        }

        private string _XLJGCZBML_XLGGDW;
        [ColumnMap(DbField = "XLJGCZBML_XLGGDW", CtrlName = "cbxXLGGDW", DbTitle = "线缆规格单位", Type = FieldType.CBX, DefaultValue = "",
           IsAllowNull = true, IsKey = false, Length = 10)]
        public string XLJGCZBML_XLGGDW
        {
            get { return _XLJGCZBML_XLGGDW; }
            set { _XLJGCZBML_XLGGDW = value; }
        }

        private string _XLJGCZBML_CZBLX;
        [ColumnMap(DbField = "XLJGCZBML_CZBLX", CtrlName = "cbxCZBLX", DbTitle = "尺重表类型", Type = FieldType.CBX, DefaultValue = "",
           IsAllowNull = true, IsKey = false, Length = 1)]
        public string XLJGCZBML_CZBLX
        {
            get { return _XLJGCZBML_CZBLX; }
            set { _XLJGCZBML_CZBLX = value; }
        }

        private string _XLJGCZBML_GGHLX;
        [ColumnMap(DbField = "XLJGCZBML_GGHLX", CtrlName = "cbxGGHLX", DbTitle = "规格行类型", Type = FieldType.CBX, DefaultValue = "",
            IsAllowNull = true, IsKey = false, Length = 1)]
        public string XLJGCZBML_GGHLX
        {
            get { return _XLJGCZBML_GGHLX; }
            set { _XLJGCZBML_GGHLX = value; }
        }


        private string _XLJGCZBML_XLBZBN;
        [ColumnMap(DbField = "XLJGCZBML_XLBZBN", CtrlName = "cbxXLBZBN", Type = FieldType.CBX, DbTitle = "线缆标准表内", DefaultValue = "",
            IsAllowNull = true, IsKey = false, Length = 1)]
        public string XLJGCZBML_XLBZBN
        {
            get { return _XLJGCZBML_XLBZBN; }
            set { _XLJGCZBML_XLBZBN = value; }
        }

        private string _XLJGCZBML_DYDJBN;
        [ColumnMap(DbField = "XLJGCZBML_DYDJBN", CtrlName = "cbxDYDJBN", DbTitle = "电压等级表内", Type = FieldType.CBX, DefaultValue = "",
           IsAllowNull = true, IsKey = false, Length = 1)]
        public string XLJGCZBML_DYDJBN
        {
            get { return _XLJGCZBML_DYDJBN; }
            set { _XLJGCZBML_DYDJBN = value; }
        }

        private string _XLJGCZBML_XLXHBN;
        [ColumnMap(DbField = "XLJGCZBML_XLXHBN", CtrlName = "cbxXLXHBN", DbTitle = "线缆型号表内", Type = FieldType.CBX, DefaultValue = "",
           IsAllowNull = true, IsKey = false, Length = 1)]
        public string XLJGCZBML_XLXHBN
        {
            get { return _XLJGCZBML_XLXHBN; }
            set { _XLJGCZBML_XLXHBN = value; }
        }

        private string _XLJGCZBML_GYFLBM;
        [ColumnMap(DbField = "XLJGCZBML_GYFLBM", CtrlName = "cbxGYFLBM", DbTitle = "工艺分类编码", Type = FieldType.CBX, DefaultValue = "",
           IsAllowNull = true, IsKey = false, Length = 20)]
        public string XLJGCZBML_GYFLBM
        {
            get { return _XLJGCZBML_GYFLBM; }
            set { _XLJGCZBML_GYFLBM = value; }
        }

        //需要单独处理
        private string _XLJGCZBBB_GYFLBBID;
        [ColumnMap(DbField = "XLJGCZBBB_GYFLBBID", CtrlName = "cbxGYFLBBID", DbTitle = "工艺分类版本", Type = FieldType.CBX, DefaultValue = "",
           IsAllowNull = true, IsKey = false, Length = 10)]
        public string XLJGCZBBB_GYFLBBID
        {
            get { return _XLJGCZBBB_GYFLBBID; }
            set { _XLJGCZBBB_GYFLBBID = value; }
        }

        private string _XLJGCZBML_CPMLID;
        [ColumnMap(DbField = "XLJGCZBML_CPMLID", CtrlName = "cbxCPMLID", DbTitle = "产品目录ID", Type = FieldType.CBX, DefaultValue = "",
           IsAllowNull = true, IsKey = false, Length = 2)]
        public string XLJGCZBML_CPMLID
        {
            get { return _XLJGCZBML_CPMLID; }
            set { _XLJGCZBML_CPMLID = value; }
        }
        
        private string _XLJGCZBML_EXCEL;
        [ColumnMap(DbField = "XLJGCZBML_EXCEL", CtrlName = "txtEXCEL", DbTitle = "EXCEL", Type = FieldType.C, DefaultValue = "",
           IsAllowNull = true, IsKey = false, Length = 60)]
        public string XLJGCZBML_EXCEL
        {
            get { return _XLJGCZBML_EXCEL; }
            set { _XLJGCZBML_EXCEL = value; }
        }

        private string _XLJGCZBML_SHEET;
        [ColumnMap(DbField = "XLJGCZBML_SHEET", CtrlName = "txtSHEET", DbTitle = "SHEET", Type = FieldType.C, DefaultValue = "",
           IsAllowNull = true, IsKey = false, Length = 40)]
        public string XLJGCZBML_SHEET
        {
            get { return _XLJGCZBML_SHEET; }
            set { _XLJGCZBML_SHEET = value; }
        }

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

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

        private string _XLJGCZBML_WHSJ;
        [ColumnMap(DbField = "XLJGCZBML_WHSJ", CtrlName = "datWHSJ", Type = FieldType.DT, DbTitle = "维护时间", DefaultValue = "",
                   IsAllowNull = true, IsKey = false, Length = 8)]
        public string XLJGCZBML_WHSJ
        {
            get { return _XLJGCZBML_WHSJ; }
            set { _XLJGCZBML_WHSJ = value; }
        }
        #endregion
    }
}