using System;
using GThinking.N_MODEL.Page;

namespace GThinking.N_XLXSBJ
{
    [TableMap(DB = "DBERP", DbTableName = "XLXSBJDXYCLGZ", Umid = 100860043, IsWorkFlow = false, IsAttach = false,
        QuerySelSql = "select XLXSBJDXYCLGZ_YCLLX, XLXSBJDXYCLGZ_YCLGZ, XLXSBJDXYCLGZ_ZXSX, XLXSBJDXYCLGZ_TYBZ, XLXSBJDXYCLGZ_BZ, "
            + " XLXSBJDXYCLGZ_WHR, XLXSBJDXYCLGZ_WHRID, XLXSBJDXYCLGZ_WHSJ, XLXSBJDXYCLGZ_TYRQ, XLXSBJDXYCLGZ_QYRQ "
            + " from XLXSBJDXYCLGZ where 1=1 order by XLXSBJDXYCLGZ_YCLLX, XLXSBJDXYCLGZ_ZXSX ",
        EntitySelSql = "select XLXSBJDXYCLGZ_YCLLX, XLXSBJDXYCLGZ_YCLGZ, XLXSBJDXYCLGZ_ZXSX, XLXSBJDXYCLGZ_TYBZ, XLXSBJDXYCLGZ_BZ, "
            + " XLXSBJDXYCLGZ_WHR, XLXSBJDXYCLGZ_WHRID, XLXSBJDXYCLGZ_WHSJ, XLXSBJDXYCLGZ_TYRQ, XLXSBJDXYCLGZ_QYRQ "
            + " from XLXSBJDXYCLGZ where XLXSBJDXYCLGZ_YCLLX=:XLXSBJDXYCLGZ_YCLLX and XLXSBJDXYCLGZ_YCLGZ=:XLXSBJDXYCLGZ_YCLGZ ",
        UpdateSql = "update XLXSBJDXYCLGZ set XLXSBJDXYCLGZ_ZXSX=:XLXSBJDXYCLGZ_ZXSX, XLXSBJDXYCLGZ_TYBZ=:XLXSBJDXYCLGZ_TYBZ, "
            + " XLXSBJDXYCLGZ_BZ=:XLXSBJDXYCLGZ_BZ, XLXSBJDXYCLGZ_WHR=:XLXSBJDXYCLGZ_WHR, XLXSBJDXYCLGZ_WHRID=:XLXSBJDXYCLGZ_WHRID, "
            + " XLXSBJDXYCLGZ_WHSJ=:XLXSBJDXYCLGZ_WHSJ, XLXSBJDXYCLGZ_TYRQ=:XLXSBJDXYCLGZ_TYRQ, XLXSBJDXYCLGZ_QYRQ=:XLXSBJDXYCLGZ_QYRQ "
            + " where XLXSBJDXYCLGZ_YCLLX=:XLXSBJDXYCLGZ_YCLLX and XLXSBJDXYCLGZ_YCLGZ=:XLXSBJDXYCLGZ_YCLGZ ",
        InsertSql = "insert into XLXSBJDXYCLGZ(XLXSBJDXYCLGZ_YCLLX, XLXSBJDXYCLGZ_YCLGZ, XLXSBJDXYCLGZ_ZXSX, XLXSBJDXYCLGZ_TYBZ, "
            + " XLXSBJDXYCLGZ_BZ, XLXSBJDXYCLGZ_WHR, XLXSBJDXYCLGZ_WHRID, XLXSBJDXYCLGZ_WHSJ, XLXSBJDXYCLGZ_TYRQ, XLXSBJDXYCLGZ_QYRQ) "
            + " values(:XLXSBJDXYCLGZ_YCLLX, :XLXSBJDXYCLGZ_YCLGZ, :XLXSBJDXYCLGZ_ZXSX, :XLXSBJDXYCLGZ_TYBZ, "
            + " :XLXSBJDXYCLGZ_BZ, :XLXSBJDXYCLGZ_WHR, :XLXSBJDXYCLGZ_WHRID, :XLXSBJDXYCLGZ_WHSJ, :XLXSBJDXYCLGZ_TYRQ, :XLXSBJDXYCLGZ_QYRQ) ",
        DeleteSql = "delete from XLXSBJDXYCLGZ where XLXSBJDXYCLGZ_YCLLX=:XLXSBJDXYCLGZ_YCLLX and XLXSBJDXYCLGZ_YCLGZ=:XLXSBJDXYCLGZ_YCLGZ ")]
    public class XLBJD_WBBJDXYCLGZ : EntityManager
    {
        private string _XLXSBJDXYCLGZ_YCLLX;
        [ColumnMap(DbField = "XLXSBJDXYCLGZ_YCLLX", CtrlName = "txtYCLLX", Type = FieldType.C, DbTitle = "预处理类型", DefaultValue = "",
            IsAllowNull = false, IsKey = true, Length = 20)]
        public string XLXSBJDXYCLGZ_YCLLX
        {
            get { return _XLXSBJDXYCLGZ_YCLLX; }
            set { _XLXSBJDXYCLGZ_YCLLX = value; }
        }

        private string _XLXSBJDXYCLGZ_YCLGZ;
        [ColumnMap(DbField = "XLXSBJDXYCLGZ_YCLGZ", CtrlName = "txtYCLGZ", Type = FieldType.C, DbTitle = "预处理规则", DefaultValue = "",
            IsAllowNull = false, IsKey = true, Length = 4000)]
        public string XLXSBJDXYCLGZ_YCLGZ
        {
            get { return _XLXSBJDXYCLGZ_YCLGZ; }
            set { _XLXSBJDXYCLGZ_YCLGZ = value; }
        }

        private string _XLXSBJDXYCLGZ_ZXSX;
        [ColumnMap(DbField = "XLXSBJDXYCLGZ_ZXSX", CtrlName = "txtZXSX", Type = FieldType.F, DbTitle = "执行顺序", DefaultValue = "0",
            IsAllowNull = true, IsKey = false, Length = 8)]
        public string XLXSBJDXYCLGZ_ZXSX
        {
            get { return _XLXSBJDXYCLGZ_ZXSX; }
            set { _XLXSBJDXYCLGZ_ZXSX = value; }
        }

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

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

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

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

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

        private string _XLXSBJDXYCLGZ_TYRQ;
        [ColumnMap(DbField = "XLXSBJDXYCLGZ_TYRQ", CtrlName = "datTYRQ", Type = FieldType.D, DbTitle = "停用日期", DefaultValue = "",
            IsAllowNull = true, IsKey = false, Length = 10)]
        public string XLXSBJDXYCLGZ_TYRQ
        {
            get { return _XLXSBJDXYCLGZ_TYRQ; }
            set { _XLXSBJDXYCLGZ_TYRQ = value; }
        }

        private string _XLXSBJDXYCLGZ_QYRQ;
        [ColumnMap(DbField = "XLXSBJDXYCLGZ_QYRQ", CtrlName = "datQYRQ", Type = FieldType.D, DbTitle = "启用日期", DefaultValue = "",
            IsAllowNull = true, IsKey = false, Length = 10)]
        public string XLXSBJDXYCLGZ_QYRQ
        {
            get { return _XLXSBJDXYCLGZ_QYRQ; }
            set { _XLXSBJDXYCLGZ_QYRQ = value; }
        }
    }
}