N_XLJC--MX/XLJGCZB_LMSZ.cs

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

      QuerySelSql = @"SELECT XLXHJGCZBML_JGCZBID, ABS(XLXHJGCZBML_JGCZBXH) as XLXHJGCZBML_JGCZBXH, 
                        XLXHJGCZBML_XLXHID,XLXHJGCZBML_DYDJID,XLXHJGCZBML_XLBZID,
                        XLXHJGCZBML_XLBZBH,
                        XLXHJGCZBML_WHRID,XLXHJGCZBML_WHR,XLXHJGCZBML_WHSJ
                        from XLXHJGCZBML           
                        where 1 = 1 order by ABS(XLXHJGCZBML_JGCZBXH) ",

    EntitySelSql = @"SELECT XLXHJGCZBML_JGCZBID, ABS(XLXHJGCZBML_JGCZBXH) as XLXHJGCZBML_JGCZBXH, 
                        XLXHJGCZBML_XLXHID,XLXHJGCZBML_DYDJID,XLXHJGCZBML_XLBZID,
                        XLXHJGCZBML_XLBZBH,
                        XLXHJGCZBML_WHRID,XLXHJGCZBML_WHR,XLXHJGCZBML_WHSJ
                        from XLXHJGCZBML              
                        where XLXHJGCZBML_JGCZBID = :XLXHJGCZBML_JGCZBID and XLXHJGCZBML_JGCZBXH=:XLXHJGCZBML_JGCZBXH ",

     InsertSql = @"insert into XLXHJGCZBML (XLXHJGCZBML_JGCZBID, XLXHJGCZBML_JGCZBXH, 
                        XLXHJGCZBML_XLXHID,XLXHJGCZBML_DYDJID,XLXHJGCZBML_XLBZID,
                        XLXHJGCZBML_XLBZBH,
                        XLXHJGCZBML_WHRID,XLXHJGCZBML_WHR,XLXHJGCZBML_WHSJ)
                 values(:XLXHJGCZBML_JGCZBID, :XLXHJGCZBML_JGCZBXH, 
                        :XLXHJGCZBML_XLXHID,:XLXHJGCZBML_DYDJID,:XLXHJGCZBML_XLBZID,
                        :XLXHJGCZBML_XLBZBH,
                        :XLXHJGCZBML_WHRID,:XLXHJGCZBML_WHR,:XLXHJGCZBML_WHSJ)",

    UpdateSql = @"update XLXHJGCZBML set  XLXHJGCZBML_JGCZBID=:XLXHJGCZBML_JGCZBID, XLXHJGCZBML_JGCZBXH=:XLXHJGCZBML_JGCZBXH, 
                        XLXHJGCZBML_XLXHID=:XLXHJGCZBML_XLXHID,XLXHJGCZBML_DYDJID=:XLXHJGCZBML_DYDJID,XLXHJGCZBML_XLBZID=:XLXHJGCZBML_XLBZID,
                        XLXHJGCZBML_XLBZBH=:XLXHJGCZBML_XLBZBH,
                        XLXHJGCZBML_WHRID=:XLXHJGCZBML_WHRID,XLXHJGCZBML_WHR=:XLXHJGCZBML_WHR,XLXHJGCZBML_WHSJ=:XLXHJGCZBML_WHSJ
                                where XLXHJGCZBML_JGCZBID = :XLXHJGCZBML_JGCZBID and  XLXHJGCZBML_JGCZBXH=:XLXHJGCZBML_JGCZBXH  ",

      DeleteSql = @"delete from XLXHJGCZBML where XLXHJGCZBML_JGCZBID = :XLXHJGCZBML_JGCZBID and XLXHJGCZBML_JGCZBXH=:XLXHJGCZBML_JGCZBXH ")]
    public class XLJGCZB_LMSZ : EntityManager
    {
        #region 字段级映射

        private string _XLXHJGCZBML_JGCZBID;
        [ColumnMap(DbField = "XLXHJGCZBML_JGCZBID", CtrlName = "txtJGCZBID", DbTitle = "表号", Type = FieldType.C, DefaultValue = "",
            IsAllowNull = false, IsKey = true, Length = 10)]
        public string XLXHJGCZBML_JGCZBID
        {
            get { return _XLXHJGCZBML_JGCZBID; }
            set { _XLXHJGCZBML_JGCZBID = value; }
        }

        private string _XLXHJGCZBML_JGCZBXH;
        [ColumnMap(DbField = "XLXHJGCZBML_JGCZBXH", CtrlName = "txtJGCZBXH", Type = FieldType.F, DbTitle = "结构尺重表序号", DefaultValue = "0",
          IsAllowNull = false, IsKey = true, Length = 0)]
        public string XLXHJGCZBML_JGCZBXH
        {
            get { return _XLXHJGCZBML_JGCZBXH; }
            set { _XLXHJGCZBML_JGCZBXH = value; }
        }

        private string _XLXHJGCZBML_XLXHID;
        [ColumnMap(DbField = "XLXHJGCZBML_XLXHID", CtrlName = "cbxXLXHID", DbTitle = "线缆型号", Type = FieldType.CBX, DefaultValue = "",
           IsAllowNull = true, IsKey = false, Length = 40)]
        public string XLXHJGCZBML_XLXHID
        {
            get { return _XLXHJGCZBML_XLXHID; }
            set { _XLXHJGCZBML_XLXHID = value; }
        }

        private string _XLXHJGCZBML_DYDJID;
        [ColumnMap(DbField = "XLXHJGCZBML_DYDJID", CtrlName = "cbxDYDJID", DbTitle = "电压等级", Type = FieldType.CBX, DefaultValue = "",
           IsAllowNull = true, IsKey = false, Length = 20)]
        public string XLXHJGCZBML_DYDJID
        {
            get { return _XLXHJGCZBML_DYDJID; }
            set { _XLXHJGCZBML_DYDJID = value; }
        }

        private string _XLXHJGCZBML_XLBZID;
        [ColumnMap(DbField = "XLXHJGCZBML_XLBZID", CtrlName = "cbxXLBZID", Type = FieldType.CBX, DbTitle = "线缆标准", DefaultValue = "",
            IsAllowNull = true, IsKey = false, Length = 10)]
        public string XLXHJGCZBML_XLBZID
        {
            get { return _XLXHJGCZBML_XLBZID; }
            set { _XLXHJGCZBML_XLBZID = value; }
        }

        private string _XLXHJGCZBML_XLBZBH;
        [ColumnMap(DbField = "XLXHJGCZBML_XLBZBH", CtrlName = "cbxXLBZBH", DbTitle = "标准编号", Type = FieldType.CBX, DefaultValue = "",
           IsAllowNull = true, IsKey = false, Length = 60)]
        public string XLXHJGCZBML_XLBZBH
        {
            get { return _XLXHJGCZBML_XLBZBH; }
            set { _XLXHJGCZBML_XLBZBH = value; }
        }

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

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

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


        #endregion
    }
}