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_XLXSBJ
{
    #region 数据表级映射
    [TableMap(DB = "DBERP", DbTableName = "XLXSBJYFJZQJ", Umid = 100860071, IsWorkFlow = false, IsAttach = false, UseWhr = true,

   EntitySelSql = " select XLXSBJYFJZQJ_YFJZQH,XLXSBJYFJZQJ_YFJZQJMC,XLXSBJYFJZQJ_YFJZXX,XLXSBJYFJZQJ_YFJZSX, " + "\r\n"
                + " XLXSBJYFJZQJ_YFJSGS,XLXSBJYFJZQJ_YFJSGS3,XLXSBJYFJZQJ_WHR,XLXSBJYFJZQJ_WHRID,XLXSBJYFJZQJ_WHSJ " + "\r\n"
                 + " from XLXSBJYFJZQJ " + "\r\n"
                 + " where XLXSBJYFJZQJ_YFJZQH =:OLD_XLXSBJYFJZQJ_YFJZQH ",

     UpdateSql = " update XLXSBJYFJZQJ " + "\r\n"
+ " set XLXSBJYFJZQJ_YFJZQH = :XLXSBJYFJZQJ_YFJZQH, XLXSBJYFJZQJ_YFJZQJMC = :XLXSBJYFJZQJ_YFJZQJMC, XLXSBJYFJZQJ_YFJZXX = :XLXSBJYFJZQJ_YFJZXX, XLXSBJYFJZQJ_YFJZSX= :XLXSBJYFJZQJ_YFJZSX," + "\r\n"
+ "     XLXSBJYFJZQJ_YFJSGS = :XLXSBJYFJZQJ_YFJSGS, XLXSBJYFJZQJ_YFJSGS3 = :XLXSBJYFJZQJ_YFJSGS3, XLXSBJYFJZQJ_WHR = :XLXSBJYFJZQJ_WHR, XLXSBJYFJZQJ_WHRID=:XLXSBJYFJZQJ_WHRID,XLXSBJYFJZQJ_WHSJ=:XLXSBJYFJZQJ_WHSJ "
             + " where XLXSBJYFJZQJ_YFJZQH =:OLD_XLXSBJYFJZQJ_YFJZQH ",

     InsertSql = " insert into XLXSBJYFJZQJ( " + "\r\n"
               + "   XLXSBJYFJZQJ_YFJZQH,XLXSBJYFJZQJ_YFJZQJMC,XLXSBJYFJZQJ_YFJZXX,XLXSBJYFJZQJ_YFJZSX, " + "\r\n"
              + "   XLXSBJYFJZQJ_YFJSGS,XLXSBJYFJZQJ_YFJSGS3,XLXSBJYFJZQJ_WHR,XLXSBJYFJZQJ_WHRID,XLXSBJYFJZQJ_WHSJ) " + "\r\n"
                  + " values( " + "\r\n"
               + "   :XLXSBJYFJZQJ_YFJZQH,:XLXSBJYFJZQJ_YFJZQJMC,:XLXSBJYFJZQJ_YFJZXX,:XLXSBJYFJZQJ_YFJZSX, " + "\r\n"
              + "   :XLXSBJYFJZQJ_YFJSGS,:XLXSBJYFJZQJ_YFJSGS3,:XLXSBJYFJZQJ_WHR,:XLXSBJYFJZQJ_WHRID,:XLXSBJYFJZQJ_WHSJ) ",

DeleteSql = " delete from XLXSBJYFJZQJ where XLXSBJYFJZQJ_YFJZQH =:XLXSBJYFJZQJ_YFJZQH ")]
    #endregion

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

        private string _XLXSBJYFJZQJ_YFJZQH;
        [ColumnMap(DbField = "XLXSBJYFJZQJ_YFJZQH", CtrlName = "txtYFJZQH", DbTitle = "计重区号", Type = FieldType.C, DefaultValue = "",
            IsAllowNull = false, IsKey = true, Length = 10)]
        public string XLXSBJYFJZQJ_YFJZQH
        {
            get { return _XLXSBJYFJZQJ_YFJZQH; }
            set { _XLXSBJYFJZQJ_YFJZQH = value; }
        }

        private string _OLD_XLXSBJYFJZQJ_YFJZQH;
        [ColumnMap(DbField = "OLD_XLXSBJYFJZQJ_YFJZQH", CtrlName = "txtOLD_YFJZQH", DbTitle = "原计重区号", Type = FieldType.HiddenField, DefaultValue = "",
            IsAllowNull = true, IsKey = false, Length = 10, PrintVisible = false)]
        public string OLD_XLXSBJYFJZQJ_YFJZQH
        {
            get { return _OLD_XLXSBJYFJZQJ_YFJZQH; }
            set { _OLD_XLXSBJYFJZQJ_YFJZQH = value; }
        }

        private string _XLXSBJYFJZQJ_YFJZQJMC;
        [ColumnMap(DbField = "XLXSBJYFJZQJ_YFJZQJMC", CtrlName = "txtYFJZQJMC", DbTitle = "区间名称", Type = FieldType.C, DefaultValue = "",
            IsAllowNull = false, IsKey = false, Length = 30)]
        public string XLXSBJYFJZQJ_YFJZQJMC
        {
            get { return _XLXSBJYFJZQJ_YFJZQJMC; }
            set { _XLXSBJYFJZQJ_YFJZQJMC = value; }
        }

        private string _XLXSBJYFJZQJ_YFJZXX;
        [ColumnMap(DbField = "XLXSBJYFJZQJ_YFJZXX", CtrlName = "txtYFJZXX", DbTitle = "计重区间下限", Type = FieldType.F, DefaultValue = "0",
            IsAllowNull = true, IsKey = false, Length = 0)]
        public string XLXSBJYFJZQJ_YFJZXX
        {
            get { return _XLXSBJYFJZQJ_YFJZXX; }
            set { _XLXSBJYFJZQJ_YFJZXX = value; }
        }

        private string _XLXSBJYFJZQJ_YFJZSX;
        [ColumnMap(DbField = "XLXSBJYFJZQJ_YFJZSX", CtrlName = "txtYFJZSX", DbTitle = "计重区间上限", Type = FieldType.F, DefaultValue = "0",
            IsAllowNull = true, IsKey = false, Length = 0)]
        public string XLXSBJYFJZQJ_YFJZSX
        {
            get { return _XLXSBJYFJZQJ_YFJZSX; }
            set { _XLXSBJYFJZQJ_YFJZSX = value; }
        }

        private string _XLXSBJYFJZQJ_YFJSGS;
        [ColumnMap(DbField = "XLXSBJYFJZQJ_YFJSGS", CtrlName = "txtYFJSGS", DbTitle = "计算公式", Type = FieldType.C, DefaultValue = "",
            IsAllowNull = true, IsKey = false, Length = 60)]
        public string XLXSBJYFJZQJ_YFJSGS
        {
            get { return _XLXSBJYFJZQJ_YFJSGS; }
            set { _XLXSBJYFJZQJ_YFJSGS = value; }
        }

        private string _XLXSBJYFJZQJ_YFJSGS3;
        [ColumnMap(DbField = "XLXSBJYFJZQJ_YFJSGS3", CtrlName = "txtYFJSGS3", DbTitle = "计算公式3", Type = FieldType.C, DefaultValue = "",
            IsAllowNull = true, IsKey = false, Length = 60)]
        public string XLXSBJYFJZQJ_YFJSGS3
        {
            get { return _XLXSBJYFJZQJ_YFJSGS3; }
            set { _XLXSBJYFJZQJ_YFJSGS3 = value; }
        }

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

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

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

        #endregion
    }

    [TableMap(DB = "DBERP", DbTableName = "XLXSBJYFJZQJ", Umid = 100860071, IsWorkFlow = false, IsAttach = false,

QuerySelSql = " ",

EntitySelSql = " ",

UpdateSql = " ",

InsertSql = " ",

DeleteSql = " ")]

    public class BJYFJZQJ_ZDXJGS : EntityManager
    {


    }

    #region 数据表级映射
    [TableMap(DB = "DBERP", DbTableName = "XLXSBJYFJJQJ", Umid = 100860071, IsWorkFlow = false, IsAttach = false, UseWhr = true,

  EntitySelSql = " select XLXSBJYFJJQJ_YFJJQH,XLXSBJYFJJQJ_YFJJQJMC,XLXSBJYFJJQJ_PJWJXX,XLXSBJYFJJQJ_PJWJSX, XLXSBJYFJJQJ_PJCZ," + "\r\n"
                 + " XLXSBJYFJJQJ_YFJSGS,XLXSBJYFJJQJ_WHR,XLXSBJYFJJQJ_WHRID,XLXSBJYFJJQJ_WHSJ " + "\r\n"
                 + " from XLXSBJYFJJQJ " + "\r\n"
                 + " where XLXSBJYFJJQJ_YFJJQH =:OLD_XLXSBJYFJJQJ_YFJJQH ",

     UpdateSql = " update XLXSBJYFJJQJ " + "\r\n"
+ " set XLXSBJYFJJQJ_YFJJQH = :XLXSBJYFJJQJ_YFJJQH, XLXSBJYFJJQJ_YFJJQJMC = :XLXSBJYFJJQJ_YFJJQJMC, XLXSBJYFJJQJ_PJWJXX = :XLXSBJYFJJQJ_PJWJXX, XLXSBJYFJJQJ_PJWJSX= :XLXSBJYFJJQJ_PJWJSX," + "\r\n"
+ "     XLXSBJYFJJQJ_PJCZ = :XLXSBJYFJJQJ_PJCZ, XLXSBJYFJJQJ_YFJSGS = :XLXSBJYFJJQJ_YFJSGS, XLXSBJYFJJQJ_WHR = :XLXSBJYFJJQJ_WHR, XLXSBJYFJJQJ_WHRID=:XLXSBJYFJJQJ_WHRID,XLXSBJYFJJQJ_WHSJ=:XLXSBJYFJJQJ_WHSJ "
             + " where XLXSBJYFJJQJ_YFJJQH =:OLD_XLXSBJYFJJQJ_YFJJQH ",

     InsertSql = " insert into XLXSBJYFJJQJ( " + "\r\n"
              + "   XLXSBJYFJJQJ_YFJJQH,XLXSBJYFJJQJ_YFJJQJMC,XLXSBJYFJJQJ_PJWJXX,XLXSBJYFJJQJ_PJWJSX,XLXSBJYFJJQJ_PJCZ, " + "\r\n"
               + "   XLXSBJYFJJQJ_YFJSGS,XLXSBJYFJJQJ_WHR,XLXSBJYFJJQJ_WHRID,XLXSBJYFJJQJ_WHSJ) " + "\r\n"
                  + " values( " + "\r\n"
              + "   :XLXSBJYFJJQJ_YFJJQH,:XLXSBJYFJJQJ_YFJJQJMC,:XLXSBJYFJJQJ_PJWJXX,:XLXSBJYFJJQJ_PJWJSX,:XLXSBJYFJJQJ_PJCZ, " + "\r\n"
               + "   :XLXSBJYFJJQJ_YFJSGS,:XLXSBJYFJJQJ_WHR,:XLXSBJYFJJQJ_WHRID,:XLXSBJYFJJQJ_WHSJ) ",

DeleteSql = " delete from XLXSBJYFJJQJ where XLXSBJYFJJQJ_YFJJQH =:XLXSBJYFJJQJ_YFJJQH ")]
    #endregion

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

        private string _XLXSBJYFJJQJ_YFJJQH;
        [ColumnMap(DbField = "XLXSBJYFJJQJ_YFJJQH", CtrlName = "txtYFJJQH", DbTitle = "计件区号", Type = FieldType.C, DefaultValue = "",
            IsAllowNull = false, IsKey = true, Length = 10)]
        public string XLXSBJYFJJQJ_YFJJQH
        {
            get { return _XLXSBJYFJJQJ_YFJJQH; }
            set { _XLXSBJYFJJQJ_YFJJQH = value; }
        }

        private string _OLD_XLXSBJYFJJQJ_YFJJQH;
        [ColumnMap(DbField = "OLD_XLXSBJYFJJQJ_YFJJQH", CtrlName = "txtOLD_YFJJQH", DbTitle = "原计件区号", Type = FieldType.HiddenField, DefaultValue = "",
            IsAllowNull = true, IsKey = false, Length = 10, PrintVisible = false)]
        public string OLD_XLXSBJYFJJQJ_YFJJQH
        {
            get { return _OLD_XLXSBJYFJJQJ_YFJJQH; }
            set { _OLD_XLXSBJYFJJQJ_YFJJQH = value; }
        }

        private string _XLXSBJYFJJQJ_YFJJQJMC;
        [ColumnMap(DbField = "XLXSBJYFJJQJ_YFJJQJMC", CtrlName = "txtYFJJQJMC", DbTitle = "区间名称", Type = FieldType.C, DefaultValue = "",
            IsAllowNull = false, IsKey = false, Length = 30)]
        public string XLXSBJYFJJQJ_YFJJQJMC
        {
            get { return _XLXSBJYFJJQJ_YFJJQJMC; }
            set { _XLXSBJYFJJQJ_YFJJQJMC = value; }
        }

        private string _XLXSBJYFJJQJ_PJCZ;
        [ColumnMap(DbField = "XLXSBJYFJJQJ_PJCZ", CtrlName = "cbxPJCZ", DbTitle = "盘具材质", Type = FieldType.CBX, DefaultValue = "",
            IsAllowNull = false, IsKey = false, Length = 30)]
        public string XLXSBJYFJJQJ_PJCZ
        {
            get { return _XLXSBJYFJJQJ_PJCZ; }
            set { _XLXSBJYFJJQJ_PJCZ = value; }
        }

        private string _XLXSBJYFJJQJ_PJWJXX;
        [ColumnMap(DbField = "XLXSBJYFJJQJ_PJWJXX", CtrlName = "txtPJWJXX", DbTitle = "盘具外径下限", Type = FieldType.F, DefaultValue = "0",
            IsAllowNull = true, IsKey = false, Length = 0)]
        public string XLXSBJYFJJQJ_PJWJXX
        {
            get { return _XLXSBJYFJJQJ_PJWJXX; }
            set { _XLXSBJYFJJQJ_PJWJXX = value; }
        }

        private string _XLXSBJYFJJQJ_PJWJSX;
        [ColumnMap(DbField = "XLXSBJYFJJQJ_PJWJSX", CtrlName = "txtPJWJSX", DbTitle = "盘具外径上限", Type = FieldType.F, DefaultValue = "0",
            IsAllowNull = true, IsKey = false, Length = 0)]
        public string XLXSBJYFJJQJ_PJWJSX
        {
            get { return _XLXSBJYFJJQJ_PJWJSX; }
            set { _XLXSBJYFJJQJ_PJWJSX = value; }
        }

        private string _XLXSBJYFJJQJ_YFJSGS;
        [ColumnMap(DbField = "XLXSBJYFJJQJ_YFJSGS", CtrlName = "txtYFJSGS", DbTitle = "计算公式", Type = FieldType.C, DefaultValue = "",
            IsAllowNull = true, IsKey = false, Length = 60)]
        public string XLXSBJYFJJQJ_YFJSGS
        {
            get { return _XLXSBJYFJJQJ_YFJSGS; }
            set { _XLXSBJYFJJQJ_YFJSGS = value; }
        }

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

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

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

        #endregion
    }
}