using System;
using GThinking.N_MODEL.Page;

namespace GThinking.N_XLXSBJ
{
    /// <summary>
    /// 线缆报价等效替换（XLXSBJDXTHDZQD）在 100860043 下的维护实体，替换类型由页面固定为 ThLx。
    /// </summary>
    [TableMap(DB = "DBERP", DbTableName = "XLXSBJDXTHDZQD", Umid = 100860043, IsWorkFlow = false, IsAttach = false,
        QuerySelSql = "select XLXSBJDXTHDZQD_XH, XLXSBJDXTHDZQD_THLX, XLXSBJDXTHDZQD_THYXJ, XLXSBJDXTHDZQD_THQXHZF, XLXSBJDXTHDZQD_THHXHZF, "
            + " XLXSBJDXTHDZQD_THQGGZF, XLXSBJDXTHDZQD_THHGGZF, XLXSBJDXTHDZQD_THQDYDJZF, XLXSBJDXTHDZQD_THHDYDJZF, "
            + " XLXSBJDXTHDZQD_BZ, XLXSBJDXTHDZQD_WHR, XLXSBJDXTHDZQD_WHRID, XLXSBJDXTHDZQD_WHSJ, isnull(XLXSBJDXTHDZQD_SFYXL,'N') as XLXSBJDXTHDZQD_SFYXL, "
            + " isnull(XLXSBJDXTHDZQD_TYBZ,'N') as XLXSBJDXTHDZQD_TYBZ from XLXSBJDXTHDZQD where 1=0 ",
        EntitySelSql = "select XLXSBJDXTHDZQD_XH, XLXSBJDXTHDZQD_THLX, XLXSBJDXTHDZQD_THYXJ, XLXSBJDXTHDZQD_THQXHZF, XLXSBJDXTHDZQD_THHXHZF, "
            + " XLXSBJDXTHDZQD_THQGGZF, XLXSBJDXTHDZQD_THHGGZF, XLXSBJDXTHDZQD_THQDYDJZF, XLXSBJDXTHDZQD_THHDYDJZF, "
            + " XLXSBJDXTHDZQD_BZ, XLXSBJDXTHDZQD_WHR, XLXSBJDXTHDZQD_WHRID, XLXSBJDXTHDZQD_WHSJ, isnull(XLXSBJDXTHDZQD_SFYXL,'N') as XLXSBJDXTHDZQD_SFYXL, "
            + " isnull(XLXSBJDXTHDZQD_TYBZ,'N') as XLXSBJDXTHDZQD_TYBZ from XLXSBJDXTHDZQD "
            + " where XLXSBJDXTHDZQD_XH=:XLXSBJDXTHDZQD_XH and XLXSBJDXTHDZQD_THLX=:XLXSBJDXTHDZQD_THLX ",
        UpdateSql = "update XLXSBJDXTHDZQD set XLXSBJDXTHDZQD_THQXHZF=:XLXSBJDXTHDZQD_THQXHZF, XLXSBJDXTHDZQD_THHXHZF=:XLXSBJDXTHDZQD_THHXHZF, "
            + " XLXSBJDXTHDZQD_THQGGZF=:XLXSBJDXTHDZQD_THQGGZF, XLXSBJDXTHDZQD_THHGGZF=:XLXSBJDXTHDZQD_THHGGZF, "
            + " XLXSBJDXTHDZQD_THQDYDJZF=:XLXSBJDXTHDZQD_THQDYDJZF, XLXSBJDXTHDZQD_THHDYDJZF=:XLXSBJDXTHDZQD_THHDYDJZF, "
            + " XLXSBJDXTHDZQD_BZ=:XLXSBJDXTHDZQD_BZ, "
            + " XLXSBJDXTHDZQD_WHR=:XLXSBJDXTHDZQD_WHR, XLXSBJDXTHDZQD_WHRID=:XLXSBJDXTHDZQD_WHRID, XLXSBJDXTHDZQD_WHSJ=:XLXSBJDXTHDZQD_WHSJ, "
            + " XLXSBJDXTHDZQD_SFYXL=:XLXSBJDXTHDZQD_SFYXL, XLXSBJDXTHDZQD_TYBZ=:XLXSBJDXTHDZQD_TYBZ "
            + " where XLXSBJDXTHDZQD_XH=:XLXSBJDXTHDZQD_XH and XLXSBJDXTHDZQD_THLX=:XLXSBJDXTHDZQD_THLX ",
        InsertSql = "insert into XLXSBJDXTHDZQD(XLXSBJDXTHDZQD_XH, XLXSBJDXTHDZQD_THLX, XLXSBJDXTHDZQD_THYXJ, "
            + " XLXSBJDXTHDZQD_THQXHZF, XLXSBJDXTHDZQD_THHXHZF, XLXSBJDXTHDZQD_THQGGZF, XLXSBJDXTHDZQD_THHGGZF, "
            + " XLXSBJDXTHDZQD_THQDYDJZF, XLXSBJDXTHDZQD_THHDYDJZF, XLXSBJDXTHDZQD_BZ, XLXSBJDXTHDZQD_WHR, XLXSBJDXTHDZQD_WHRID, XLXSBJDXTHDZQD_WHSJ, "
            + " XLXSBJDXTHDZQD_SFYXL, XLXSBJDXTHDZQD_TYBZ, XLXSBJDXTHDZQD_TYRQ, XLXSBJDXTHDZQD_QYRQ) "
            + " values(:XLXSBJDXTHDZQD_XH, :XLXSBJDXTHDZQD_THLX, :XLXSBJDXTHDZQD_THYXJ, "
            + " :XLXSBJDXTHDZQD_THQXHZF, :XLXSBJDXTHDZQD_THHXHZF, :XLXSBJDXTHDZQD_THQGGZF, :XLXSBJDXTHDZQD_THHGGZF, "
            + " :XLXSBJDXTHDZQD_THQDYDJZF, :XLXSBJDXTHDZQD_THHDYDJZF, :XLXSBJDXTHDZQD_BZ, :XLXSBJDXTHDZQD_WHR, :XLXSBJDXTHDZQD_WHRID, :XLXSBJDXTHDZQD_WHSJ, "
            + " :XLXSBJDXTHDZQD_SFYXL, :XLXSBJDXTHDZQD_TYBZ, null, null) ",
        DeleteSql = "delete from XLXSBJDXTHDZQD where XLXSBJDXTHDZQD_XH=:XLXSBJDXTHDZQD_XH and XLXSBJDXTHDZQD_THLX=:XLXSBJDXTHDZQD_THLX ")]
    public class XLBJD_WBBJDDX : EntityManager
    {
        private string _XLXSBJDXTHDZQD_XH;
        [ColumnMap(DbField = "XLXSBJDXTHDZQD_XH", CtrlName = "txtXH", Type = FieldType.HiddenField, DbTitle = "序号", DefaultValue = "0",
            IsAllowNull = false, IsKey = true, Length = 8)]
        public string XLXSBJDXTHDZQD_XH
        {
            get { return _XLXSBJDXTHDZQD_XH; }
            set { _XLXSBJDXTHDZQD_XH = value; }
        }

        private string _XLXSBJDXTHDZQD_THLX;
        [ColumnMap(DbField = "XLXSBJDXTHDZQD_THLX", CtrlName = "txtTHLX", Type = FieldType.HiddenField, DbTitle = "替换类型", DefaultValue = "",
            IsAllowNull = false, IsKey = true, Length = 30)]
        public string XLXSBJDXTHDZQD_THLX
        {
            get { return _XLXSBJDXTHDZQD_THLX; }
            set { _XLXSBJDXTHDZQD_THLX = value; }
        }

        private string _XLXSBJDXTHDZQD_THYXJ;
        [ColumnMap(DbField = "XLXSBJDXTHDZQD_THYXJ", CtrlName = "txtTHYXJ", Type = FieldType.HiddenField, DbTitle = "优先级", DefaultValue = "0",
            IsAllowNull = true, IsKey = false, Length = 20)]
        public string XLXSBJDXTHDZQD_THYXJ
        {
            get { return _XLXSBJDXTHDZQD_THYXJ; }
            set { _XLXSBJDXTHDZQD_THYXJ = value; }
        }

        private string _XLXSBJDXTHDZQD_THQXHZF;
        [ColumnMap(DbField = "XLXSBJDXTHDZQD_THQXHZF", CtrlName = "txtTHQXHZF", Type = FieldType.C, DbTitle = "替换前型号", DefaultValue = "",
            IsAllowNull = true, IsKey = false, Length = 500)]
        public string XLXSBJDXTHDZQD_THQXHZF
        {
            get { return _XLXSBJDXTHDZQD_THQXHZF; }
            set { _XLXSBJDXTHDZQD_THQXHZF = value; }
        }

        private string _XLXSBJDXTHDZQD_THHXHZF;
        [ColumnMap(DbField = "XLXSBJDXTHDZQD_THHXHZF", CtrlName = "txtTHHXHZF", Type = FieldType.C, DbTitle = "替换后型号", DefaultValue = "",
            IsAllowNull = true, IsKey = false, Length = 500)]
        public string XLXSBJDXTHDZQD_THHXHZF
        {
            get { return _XLXSBJDXTHDZQD_THHXHZF; }
            set { _XLXSBJDXTHDZQD_THHXHZF = value; }
        }

        private string _XLXSBJDXTHDZQD_THQGGZF;
        [ColumnMap(DbField = "XLXSBJDXTHDZQD_THQGGZF", CtrlName = "txtTHQGGZF", Type = FieldType.C, DbTitle = "替换前规格", DefaultValue = "",
            IsAllowNull = true, IsKey = false, Length = 500)]
        public string XLXSBJDXTHDZQD_THQGGZF
        {
            get { return _XLXSBJDXTHDZQD_THQGGZF; }
            set { _XLXSBJDXTHDZQD_THQGGZF = value; }
        }

        private string _XLXSBJDXTHDZQD_THHGGZF;
        [ColumnMap(DbField = "XLXSBJDXTHDZQD_THHGGZF", CtrlName = "txtTHHGGZF", Type = FieldType.C, DbTitle = "替换后规格", DefaultValue = "",
            IsAllowNull = true, IsKey = false, Length = 500)]
        public string XLXSBJDXTHDZQD_THHGGZF
        {
            get { return _XLXSBJDXTHDZQD_THHGGZF; }
            set { _XLXSBJDXTHDZQD_THHGGZF = value; }
        }

        private string _XLXSBJDXTHDZQD_THQDYDJZF;
        [ColumnMap(DbField = "XLXSBJDXTHDZQD_THQDYDJZF", CtrlName = "txtTHQDYDJZF", Type = FieldType.C, DbTitle = "替换前电压等级", DefaultValue = "",
            IsAllowNull = true, IsKey = false, Length = 200)]
        public string XLXSBJDXTHDZQD_THQDYDJZF
        {
            get { return _XLXSBJDXTHDZQD_THQDYDJZF; }
            set { _XLXSBJDXTHDZQD_THQDYDJZF = value; }
        }

        private string _XLXSBJDXTHDZQD_THHDYDJZF;
        [ColumnMap(DbField = "XLXSBJDXTHDZQD_THHDYDJZF", CtrlName = "txtTHHDYDJZF", Type = FieldType.C, DbTitle = "替换后电压等级", DefaultValue = "",
            IsAllowNull = true, IsKey = false, Length = 200)]
        public string XLXSBJDXTHDZQD_THHDYDJZF
        {
            get { return _XLXSBJDXTHDZQD_THHDYDJZF; }
            set { _XLXSBJDXTHDZQD_THHDYDJZF = value; }
        }

        private string _XLXSBJDXTHDZQD_BZ;
        [ColumnMap(DbField = "XLXSBJDXTHDZQD_BZ", CtrlName = "txtBZ", Type = FieldType.C, DbTitle = "备注", DefaultValue = "",
            IsAllowNull = true, IsKey = false, Length = 2000)]
        public string XLXSBJDXTHDZQD_BZ
        {
            get { return _XLXSBJDXTHDZQD_BZ; }
            set { _XLXSBJDXTHDZQD_BZ = value; }
        }

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

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

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

        private string _XLXSBJDXTHDZQD_SFYXL;
        [ColumnMap(DbField = "XLXSBJDXTHDZQD_SFYXL", CtrlName = "txtSFYXL", Type = FieldType.HiddenField, DbTitle = "是否预训练", DefaultValue = "N",
            IsAllowNull = true, IsKey = false, Length = 1)]
        public string XLXSBJDXTHDZQD_SFYXL
        {
            get { return _XLXSBJDXTHDZQD_SFYXL; }
            set { _XLXSBJDXTHDZQD_SFYXL = value; }
        }

        private string _XLXSBJDXTHDZQD_TYBZ;
        [ColumnMap(DbField = "XLXSBJDXTHDZQD_TYBZ", CtrlName = "txtTYBZ", Type = FieldType.HiddenField, DbTitle = "停用", DefaultValue = "N",
            IsAllowNull = true, IsKey = false, Length = 1)]
        public string XLXSBJDXTHDZQD_TYBZ
        {
            get { return _XLXSBJDXTHDZQD_TYBZ; }
            set { _XLXSBJDXTHDZQD_TYBZ = value; }
        }
    }
}