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.U20261363_N_XLXSBJ
{
    [TableMap(DB = "DBERP", DbTableName = "StandardMatchRule", Umid = 100860174, IsWorkFlow = false, UseWhr = false, IsAttach = false,

QuerySelSql = "select ID, HeaderStd, DbStd, Priority, case when IsActive=1 then 'Y' else 'N' end as IsActive, Remark, CreateTime from dbo.StandardMatchRule where 1=1  ",

EntitySelSql = "select ID, HeaderStd, DbStd, Priority, case when IsActive=1 then 'Y' else 'N' end as IsActive, Remark, CreateTime from dbo.StandardMatchRule "
            + " where ID=:ID ",

UpdateSql = "update dbo.StandardMatchRule set HeaderStd=:HeaderStd, DbStd=:DbStd, Priority=:Priority, "
          + " IsActive=case when :IsActive in ('Y','1') then 1 else 0 end, Remark=:Remark "
          + " where ID=:ID ",

InsertSql = "insert into dbo.StandardMatchRule(HeaderStd, DbStd, Priority, IsActive, Remark) "
          + "values(:HeaderStd, :DbStd, :Priority, case when :IsActive in ('Y','1') then 1 else 0 end, :Remark) ",

DeleteSql = "delete from dbo.StandardMatchRule where ID=:ID ")]

    public class XLBJD_WBBJDMX_BBPPGZWH : EntityManager
    {
        #region 字段属性
        //关键字
        private string _ID;
        [ColumnMap(DbField = "ID", CtrlName = "txtID", Type = FieldType.HiddenField, DbTitle = "ID", DefaultValue = "",
                  IsAllowNull = true, IsKey = true, Length = 10)]
        public string ID
        {
            get { return _ID; }
            set { _ID = value; }
        }

        private string _HeaderStd;
        [ColumnMap(DbField = "HeaderStd", CtrlName = "txtHeaderStd", Type = FieldType.C, DbTitle = "表头指定标准", DefaultValue = "",
                  IsAllowNull = false, IsKey = false, Length = 50)]
        public string HeaderStd
        {
            get { return _HeaderStd; }
            set { _HeaderStd = value; }
        }

        private string _DbStd;
        [ColumnMap(DbField = "DbStd", CtrlName = "txtDbStd", Type = FieldType.CBX, DbTitle = "匹配标准", DefaultValue = "",
                  IsAllowNull = false, IsKey = false, Length = 50)]
        public string DbStd
        {
            get { return _DbStd; }
            set { _DbStd = value; }
        }

        private string _Priority;
        [ColumnMap(DbField = "Priority", CtrlName = "txtPriority", Type = FieldType.F, DbTitle = "优先级", DefaultValue = "1",
                  IsAllowNull = false, IsKey = false, Length = 8)]
        public string Priority
        {
            get { return _Priority; }
            set { _Priority = value; }
        }

        private string _IsActive;
        [ColumnMap(DbField = "IsActive", CtrlName = "chkIsActive", Type = FieldType.Y, DbTitle = "是否启用", DefaultValue = "Y",
                  IsAllowNull = false, IsKey = false, Length = 1)]
        public string IsActive
        {
            get { return _IsActive; }
            set { _IsActive = value; }
        }

        private string _Remark;
        [ColumnMap(DbField = "Remark", CtrlName = "txtRemark", Type = FieldType.C, DbTitle = "备注说明", DefaultValue = "",
                  IsAllowNull = true, IsKey = false, Length = 200)]
        public string Remark
        {
            get { return _Remark; }
            set { _Remark = value; }
        }

        private string _CreateTime;
        [ColumnMap(DbField = "CreateTime", CtrlName = "datCreateTime", Type = FieldType.DT, DbTitle = "创建时间", DefaultValue = "",
                  IsAllowNull = true, IsKey = false, Length = 18)]
        public string CreateTime
        {
            get { return _CreateTime; }
            set { _CreateTime = value; }
        }
        #endregion

    }
}