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 = "XLGGB", Umid = 101421010, IsWorkFlow = false, UseWhr = false, IsAttach = false,

       QuerySelSql = "select XLGGB_XLGGID,XLXXJGB_XXJGID,XLDTJMZHB_DTJMZHID,XLXXJGB_SFXD1,XLXXJGB_SL1,XLXXJGB_SFXD2,XLXXJGB_SL2,XLXXJGB_SFXD3,XLXXJGB_SL3,XLXXJGB_SFXD4,XLXXJGB_SL4," + "\r\n"
                   + "       XLDTJMZHB_DTJM1,XLDTJMZHB_DTJM2,XLGGB_XLGGJDGZ,XLGGB_XH,XLGGB_WHR,XLGGB_WHRID,XLGGB_WHSJ,XLGGB_XLGGDW,XLGGB_XLGGJDGZ,XLGGB_GGZXS," + "\r\n"
                   + "       XLDTJMZHB_DTJM3,XLDTJMZHB_DTJM4,XLGGB_XH,XLGGB_XLGGDW,XLGGB_GGZXS,XLXXJGB_SFXD5,XLXXJGB_SL5,XLDTJMZHB_DTJM5,XLGGB_GGZJM  " + "\r\n"
                   + "  from XLGGB  " + "\r\n"
                   + "  left join XLXXJGB on XLXXJGB_XXJGID=XLGGB_XXJGID " + "\r\n"
                   + "  left join XLDTJMZHB on XLDTJMZHB_DTJMZHID=XLGGB_DTJMZHID " + "\r\n"
                   + "  where 1=1 " + "\r\n"
                   + "  order by XLGGB_XLGGID,XLXXJGB_XXJGID,XLDTJMZHB_DTJMZHID ",

      EntitySelSql = "select XLGGB_XLGGID,XLXXJGB_XXJGID,XLDTJMZHB_DTJMZHID,XLGGB_XH,XLGGB_WHR,XLGGB_WHRID,XLGGB_WHSJ,XLGGB_XLGGDW,XLGGB_XLGGJDGZ,XLGGB_GGZXS, " + "\r\n"
                   + "  XLXXJGB_SFXD1,XLXXJGB_SL1,XLXXJGB_SFXD2,XLXXJGB_SL2,XLXXJGB_SFXD3,XLXXJGB_SL3,XLXXJGB_SFXD4,XLXXJGB_SL4," + "\r\n"
                   + "       XLDTJMZHB_DTJM1,XLDTJMZHB_DTJM2,XLGGB_XLGGJDGZ," + "\r\n"
                   + "       XLDTJMZHB_DTJM3,XLDTJMZHB_DTJM4,XLGGB_XH,XLGGB_XLGGDW,XLGGB_GGZXS,XLXXJGB_SFXD5,XLXXJGB_SL5,XLDTJMZHB_DTJM5,XLGGB_GGZJM  " + "\r\n"
                   + "  from XLGGB  " + "\r\n"
                   + "  left join XLXXJGB on XLXXJGB_XXJGID=XLGGB_XXJGID " + "\r\n"
                   + "  left join XLDTJMZHB on XLDTJMZHB_DTJMZHID=XLGGB_DTJMZHID " + "\r\n"
                   + "  where XLGGB_XLGGID=:XLGGB_XLGGID  and  XLGGB_XLGGJDGZ=:XLGGB_XLGGJDGZ " + "\r\n"
                   + "  order by XLGGB_XLGGID,XLXXJGB_XXJGID,XLDTJMZHB_DTJMZHID ",

        InsertSql = "  ",

       UpdateSql = "  update XLGGB set XLGGB_XLGGJDGZ=:XLGGB_XLGGJDGZ,XLGGB_GGZJM=:XLGGB_GGZJM," + "\r\n"
                 + "         XLGGB_WHR=:XLGGB_WHR,XLGGB_WHRID=:XLGGB_WHRID,XLGGB_WHSJ=:XLGGB_WHSJ,XLGGB_XH=:XLGGB_XH,XLGGB_XLGGDW=:XLGGB_XLGGDW,XLGGB_GGZXS=:XLGGB_GGZXS " + "\r\n"
                 + "         where XLGGB_XLGGID=:OLDXLGGB_XLGGID  and  XLGGB_XLGGJDGZ=:OLDXLGGB_XLGGJDGZ ",

        DeleteSql = "")]

    public class XLXLGG : EntityManager
    {
        #region 字段级映射
        private string _XLGGB_XLGGJDGZ;
        [ColumnMap(DbField = "XLGGB_XLGGJDGZ", CtrlName = "hidXLGGJDGZ", Type = FieldType.HiddenField,
        DbTitle = "线缆规格解读规则", DefaultValue = "",
        IsAllowNull = true, IsKey = true, Length = 20)]
        public string XLGGB_XLGGJDGZ
        {
            get { return _XLGGB_XLGGJDGZ; }
            set { _XLGGB_XLGGJDGZ = value; }
        }
        private string _XLGGB_XLGGID;
        [ColumnMap(DbField = "XLGGB_XLGGID", CtrlName = "txtXLGGID", Type = FieldType.C,
        DbTitle = "规格", DefaultValue = "",
        IsAllowNull = false, IsKey = true, Length = 60)]
        public string XLGGB_XLGGID
        {
            get { return _XLGGB_XLGGID; }
            set { _XLGGB_XLGGID = value; }
        }
        private string _XLXXJGB_XXJGID;
        [ColumnMap(DbField = "XLXXJGB_XXJGID", CtrlName = "txtXXJGID", Type = FieldType.C,
        DbTitle = "芯线结构", DefaultValue = "",
       IsAllowNull = true, IsKey = false, Length = 30)]
        public string XLXXJGB_XXJGID
        {
            get { return _XLXXJGB_XXJGID; }
            set { _XLXXJGB_XXJGID = value; }
        }
        private string _XLDTJMZHB_DTJMZHID;
        [ColumnMap(DbField = "XLDTJMZHB_DTJMZHID", CtrlName = "txtDTJMZHID", Type = FieldType.C,
        DbTitle = "导体截面组合", DefaultValue = "",
       IsAllowNull = true, IsKey = false, Length = 40)]
        public string XLDTJMZHB_DTJMZHID
        {
            get { return _XLDTJMZHB_DTJMZHID; }
            set { _XLDTJMZHB_DTJMZHID = value; }
        }
        private string _XLGGB_XH;
        [ColumnMap(DbField = "XLGGB_XH", CtrlName = "txtXH", Type = FieldType.F,
         DbTitle = "序号", DefaultValue = "0",
         IsAllowNull = true, IsKey = false, Length = 0)]
        public string XLGGB_XH
        {
            get { return _XLGGB_XH; }
            set { _XLGGB_XH = value; }
        }
        private string _XLGGB_GGZXS;
        [ColumnMap(DbField = "XLGGB_GGZXS", CtrlName = "txtGGZXS", Type = FieldType.F,
         DbTitle = "规格总芯数", DefaultValue = "0",
         IsAllowNull = true, IsKey = false, Length = 0)]
        public string XLGGB_GGZXS
        {
            get { return _XLGGB_GGZXS; }
            set { _XLGGB_GGZXS = value; }
        }
        private string _XLGGB_XLGGDW;
        [ColumnMap(DbField = "XLGGB_XLGGDW", CtrlName = "cbxXLGGDW", Type = FieldType.CBX,
         DbTitle = "线缆规格单位", DefaultValue = "",
         IsAllowNull = true, IsKey = false, Length = 10)]
        public string XLGGB_XLGGDW
        {
            get { return _XLGGB_XLGGDW; }
            set { _XLGGB_XLGGDW = value; }
        }
        // 私有变量维护人
        private string _XLGGB_WHR;
        [ColumnMap(DbField = "XLGGB_WHR", CtrlName = "txtWHR", Type = FieldType.C,
         DbTitle = "维护人", DefaultValue = "",
         IsAllowNull = true, IsKey = false, Length = 30)]
        public string XLGGB_WHR
        {
            get { return _XLGGB_WHR; }
            set { _XLGGB_WHR = value; }
        }

        // 私有变量维护人编码
        private string _XLGGB_WHRID;
        [ColumnMap(DbField = "XLGGB_WHRID", CtrlName = "hidWHRID", Type = FieldType.HiddenField,
         DbTitle = "维护人工号", DefaultValue = "",
         IsAllowNull = true, IsKey = false, Length = 10)]
        public string XLGGB_WHRID
        {
            get { return _XLGGB_WHRID; }
            set { _XLGGB_WHRID = value; }
        }

        // 私有变量维护时间
        private string _XLGGB_WHSJ;
        [ColumnMap(DbField = "XLGGB_WHSJ", CtrlName = "datWHSJ", Type = FieldType.DT,
         DbTitle = "维护时间", DefaultValue = "",
         IsAllowNull = true, IsKey = false, Length = 0)]
        public string XLGGB_WHSJ
        {
            get { return _XLGGB_WHSJ; }
            set { _XLGGB_WHSJ = value; }
        }
        private string _XLXXJGB_SFXD1;
        [ColumnMap(DbField = "XLXXJGB_SFXD1", CtrlName = "txtSFXD1", Type = FieldType.F,
         DbTitle = "线组数1", DefaultValue = "0",
         IsAllowNull = true, IsKey = false, Length = 0)]
        public string XLXXJGB_SFXD1
        {
            get { return _XLXXJGB_SFXD1; }
            set { _XLXXJGB_SFXD1 = value; }
        }
        private string _XLXXJGB_SL1;
        [ColumnMap(DbField = "XLXXJGB_SL1", CtrlName = "txtSL1", Type = FieldType.F,
         DbTitle = "导体根数1", DefaultValue = "0",
         IsAllowNull = true, IsKey = false, Length = 0)]
        public string XLXXJGB_SL1
        {
            get { return _XLXXJGB_SL1; }
            set { _XLXXJGB_SL1 = value; }
        }
        private string _XLDTJMZHB_DTJM1;
        [ColumnMap(DbField = "XLDTJMZHB_DTJM1", CtrlName = "txtDTJM1", Type = FieldType.F,
         DbTitle = "导体截面1", DefaultValue = "0",
         IsAllowNull = true, IsKey = false, Length = 0)]
        public string XLDTJMZHB_DTJM1
        {
            get { return _XLDTJMZHB_DTJM1; }
            set { _XLDTJMZHB_DTJM1 = value; }
        }
        private string _XLXXJGB_SFXD2;
        [ColumnMap(DbField = "XLXXJGB_SFXD2", CtrlName = "txtSFXD2", Type = FieldType.F,
         DbTitle = "线组数2", DefaultValue = "0",
         IsAllowNull = true, IsKey = false, Length = 0)]
        public string XLXXJGB_SFXD2
        {
            get { return _XLXXJGB_SFXD2; }
            set { _XLXXJGB_SFXD2 = value; }
        }
        private string _XLXXJGB_SL2;
        [ColumnMap(DbField = "XLXXJGB_SL2", CtrlName = "txtSL2", Type = FieldType.F,
         DbTitle = "导体根数2", DefaultValue = "0",
         IsAllowNull = true, IsKey = false, Length = 0)]
        public string XLXXJGB_SL2
        {
            get { return _XLXXJGB_SL2; }
            set { _XLXXJGB_SL2 = value; }
        }
        private string _XLDTJMZHB_DTJM2;
        [ColumnMap(DbField = "XLDTJMZHB_DTJM2", CtrlName = "txtDTJM2", Type = FieldType.F,
         DbTitle = "导体截面2", DefaultValue = "0",
         IsAllowNull = true, IsKey = false, Length = 0)]
        public string XLDTJMZHB_DTJM2
        {
            get { return _XLDTJMZHB_DTJM2; }
            set { _XLDTJMZHB_DTJM2 = value; }
        }
        private string _XLXXJGB_SFXD3;
        [ColumnMap(DbField = "XLXXJGB_SFXD3", CtrlName = "txtSFXD3", Type = FieldType.F,
         DbTitle = "线组数3", DefaultValue = "0",
         IsAllowNull = true, IsKey = false, Length = 0)]
        public string XLXXJGB_SFXD3
        {
            get { return _XLXXJGB_SFXD3; }
            set { _XLXXJGB_SFXD3 = value; }
        }
        private string _XLXXJGB_SL3;
        [ColumnMap(DbField = "XLXXJGB_SL3", CtrlName = "txtSL3", Type = FieldType.F,
         DbTitle = "导体根数3", DefaultValue = "0",
         IsAllowNull = true, IsKey = false, Length = 0)]
        public string XLXXJGB_SL3
        {
            get { return _XLXXJGB_SL3; }
            set { _XLXXJGB_SL3 = value; }
        }
        private string _XLDTJMZHB_DTJM3;
        [ColumnMap(DbField = "XLDTJMZHB_DTJM3", CtrlName = "txtDTJM3", Type = FieldType.F,
         DbTitle = "导体截面3", DefaultValue = "0",
         IsAllowNull = true, IsKey = false, Length = 0)]
        public string XLDTJMZHB_DTJM3
        {
            get { return _XLDTJMZHB_DTJM3; }
            set { _XLDTJMZHB_DTJM3 = value; }
        }
        private string _XLXXJGB_SFXD4;
        [ColumnMap(DbField = "XLXXJGB_SFXD4", CtrlName = "txtSFXD4", Type = FieldType.F,
         DbTitle = "线组数4", DefaultValue = "0",
         IsAllowNull = true, IsKey = false, Length = 0)]
        public string XLXXJGB_SFXD4
        {
            get { return _XLXXJGB_SFXD4; }
            set { _XLXXJGB_SFXD4 = value; }
        }
        private string _XLXXJGB_SL4;
        [ColumnMap(DbField = "XLXXJGB_SL4", CtrlName = "txtSL4", Type = FieldType.F,
         DbTitle = "导体根数4", DefaultValue = "0",
         IsAllowNull = true, IsKey = false, Length = 0)]
        public string XLXXJGB_SL4
        {
            get { return _XLXXJGB_SL4; }
            set { _XLXXJGB_SL4 = value; }
        }
        private string _XLDTJMZHB_DTJM4;
        [ColumnMap(DbField = "XLDTJMZHB_DTJM4", CtrlName = "txtDTJM4", Type = FieldType.F,
         DbTitle = "导体截面4", DefaultValue = "0",
         IsAllowNull = true, IsKey = false, Length = 0)]
        public string XLDTJMZHB_DTJM4
        {
            get { return _XLDTJMZHB_DTJM4; }
            set { _XLDTJMZHB_DTJM4 = value; }
        }  private string _XLXXJGB_SFXD5;
        [ColumnMap(DbField = "XLXXJGB_SFXD5", CtrlName = "txtSFXD5", Type = FieldType.F,
         DbTitle = "线组数5", DefaultValue = "0",
         IsAllowNull = true, IsKey = false, Length = 0)]
        public string XLXXJGB_SFXD5
        {
            get { return _XLXXJGB_SFXD5; }
            set { _XLXXJGB_SFXD5 = value; }
        }
        private string _XLXXJGB_SL5;
        [ColumnMap(DbField = "XLXXJGB_SL5", CtrlName = "txtSL5", Type = FieldType.F,
         DbTitle = "导体根数5", DefaultValue = "0",
         IsAllowNull = true, IsKey = false, Length = 0)]
        public string XLXXJGB_SL5
        {
            get { return _XLXXJGB_SL5; }
            set { _XLXXJGB_SL5 = value; }
        }
        private string _XLDTJMZHB_DTJM5;
        [ColumnMap(DbField = "XLDTJMZHB_DTJM5", CtrlName = "txtDTJM5", Type = FieldType.F,
         DbTitle = "导体截面5", DefaultValue = "0",
         IsAllowNull = true, IsKey = false, Length = 0)]
        public string XLDTJMZHB_DTJM5
        {
            get { return _XLDTJMZHB_DTJM5; }
            set { _XLDTJMZHB_DTJM5 = value; }
        }
        private string _XLGGB_GGZJM;
        [ColumnMap(DbField = "XLGGB_GGZJM", CtrlName = "txtGGZJM", Type = FieldType.F,
         DbTitle = "规格总截面", DefaultValue = "0",
         IsAllowNull = true, IsKey = false, Length = 0)]
        public string XLGGB_GGZJM
        {
            get { return _XLGGB_GGZJM; }
            set { _XLGGB_GGZJM = value; }
        }
        #endregion
    }
}