N_XLJC--MX/BJCPWH.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 = "BJCPXX", Umid = 101421013, IsWorkFlow = false, UseWhr = false, IsAttach = false,

      EntitySelSql = @" select BJCPXX_XLXHID,BJCPXX_XLGGID,BJCPXX_XLBZID,BJCPXX_DYDJID,BJCPXX_DTJGXX,BJCPXX_WJ, BJCPXX_ZXWQBS,BJCPXX_WHR,BJCPXX_WHRID,BJCPXX_WHSJ,rtrim(XLBZ_XLBZLXMC)||'|'||XLBZ_XLBZID as XLBZ, 
                               BJCPXX_XLXHID as OLD_XLXHID,BJCPXX_XLGGID as OLD_XLGGID,BJCPXX_XLBZID as OLD_XLBZID,BJCPXX_DYDJID as OLD_DYDJID
                        from BJCPXX 
                        left join XLBZ on XLBZ_XLBZID=BJCPXX_XLBZID
                        where BJCPXX_XLXHID=:OLD_XLXHID  and  BJCPXX_XLGGID=:OLD_XLGGID and BJCPXX_XLBZID=:OLD_XLBZID  and  BJCPXX_DYDJID=:OLD_DYDJID  ",

      InsertSql = @"insert into BJCPXX (BJCPXX_XLXHID, BJCPXX_XLGGID, BJCPXX_XLBZID, BJCPXX_DYDJID, BJCPXX_DTJGXX, BJCPXX_WJ, BJCPXX_ZXWQBS,
                                        BJCPXX_WHR, BJCPXX_WHRID, BJCPXX_WHSJ)
                                        values (:BJCPXX_XLXHID, :BJCPXX_XLGGID, :BJCPXX_XLBZID, :BJCPXX_DYDJID, :BJCPXX_DTJGXX, :BJCPXX_WJ, :BJCPXX_ZXWQBS,
                                        :BJCPXX_WHR, :BJCPXX_WHRID, :BJCPXX_WHSJ)",

      UpdateSql = @"update  BJCPXX set
                            BJCPXX_XLXHID=:BJCPXX_XLXHID,
                            BJCPXX_XLGGID=:BJCPXX_XLGGID,
                            BJCPXX_XLBZID=:BJCPXX_XLBZID,
                            BJCPXX_DYDJID=:BJCPXX_DYDJID,
                            BJCPXX_DTJGXX=:BJCPXX_DTJGXX,
                            BJCPXX_WJ=:BJCPXX_WJ,
                            BJCPXX_ZXWQBS=:BJCPXX_ZXWQBS,
                            BJCPXX_WHR=:BJCPXX_WHR,
                            BJCPXX_WHRID=:BJCPXX_WHRID,
                            BJCPXX_WHSJ=:BJCPXX_WHSJ 
                    where   BJCPXX_XLXHID=:OLD_XLXHID  and  BJCPXX_XLGGID=:OLD_XLGGID and BJCPXX_XLBZID=:OLD_XLBZID  and  BJCPXX_DYDJID=:OLD_DYDJID  ",


      DeleteSql = "DELETE FROM BJCPXX  where BJCPXX_XLXHID=:OLD_XLXHID  and  BJCPXX_XLGGID=:OLD_XLGGID and BJCPXX_XLBZID=:OLD_XLBZID  and  BJCPXX_DYDJID=:OLD_DYDJID  ")]
    public class BJCPWH : EntityManager
    {
        #region 字段级映射
        private string _BJCPXX_XLXHID;
        [ColumnMap(DbField = "BJCPXX_XLXHID", CtrlName = "cbxXH", Type = FieldType.CBX,
        DbTitle = "型号", DefaultValue = "",
        IsAllowNull = false, IsKey = false, Length = 20)]
        public string BJCPXX_XLXHID
        {
            get { return _BJCPXX_XLXHID; }
            set { _BJCPXX_XLXHID = value; }
        }
        private string _BJCPXX_XLGGID;
        [ColumnMap(DbField = "BJCPXX_XLGGID", CtrlName = "txtGG", Type = FieldType.C,
        DbTitle = "规格", DefaultValue = "",
        IsAllowNull = false, IsKey = false, Length = 60)]
        public string BJCPXX_XLGGID
        {
            get { return _BJCPXX_XLGGID; }
            set { _BJCPXX_XLGGID = value; }
        }
        private string _BJCPXX_XLBZID;
        [ColumnMap(DbField = "BJCPXX_XLBZID", CtrlName = "cbxBZ", Type = FieldType.CBX,
        DbTitle = "标准", DefaultValue = "",
        IsAllowNull = false, IsKey = false, Length = 10)]
        public string BJCPXX_XLBZID
        {
            get { return _BJCPXX_XLBZID; }
            set { _BJCPXX_XLBZID = value; }
        }
        private string _BJCPXX_DYDJID;
        [ColumnMap(DbField = "BJCPXX_DYDJID", CtrlName = "cbxDYDJ", Type = FieldType.CBX,
        DbTitle = "电压等级", DefaultValue = "",
        IsAllowNull = false, IsKey = false, Length = 20)]
        public string BJCPXX_DYDJID
        {
            get { return _BJCPXX_DYDJID; }
            set { _BJCPXX_DYDJID = value; }
        }
        private string _OLD_XLXHID;
        [ColumnMap(DbField = "OLD_XLXHID", CtrlName = "txtOLDXH", Type = FieldType.HiddenField, PrintVisible = false,
        DbTitle = "原型号", DefaultValue = "",
        IsAllowNull = true, IsKey = false, Length = 20)]
        public string OLD_XLXHID
        {
            get { return _OLD_XLXHID; }
            set { _OLD_XLXHID = value; }
        }
        private string _OLD_XLGGID;
        [ColumnMap(DbField = "OLD_XLGGID", CtrlName = "txtOLDGG", Type = FieldType.HiddenField, PrintVisible = false,
        DbTitle = "原规格", DefaultValue = "",
       IsAllowNull = true, IsKey = false, Length = 60)]
        public string OLD_XLGGID
        {
            get { return _OLD_XLGGID; }
            set { _OLD_XLGGID = value; }
        }
        private string _OLD_XLBZID;
        [ColumnMap(DbField = "OLD_XLBZID", CtrlName = "txtOLDBZ", Type = FieldType.HiddenField, PrintVisible = false,
        DbTitle = "原标准", DefaultValue = "",
       IsAllowNull = true, IsKey = false, Length = 10)]
        public string OLD_XLBZID
        {
            get { return _OLD_XLBZID; }
            set { _OLD_XLBZID = value; }
        }
        private string _OLD_DYDJID;
        [ColumnMap(DbField = "OLD_DYDJID", CtrlName = "txtOLDDYDJ", Type = FieldType.HiddenField, PrintVisible = false,
        DbTitle = "原电压等级", DefaultValue = "",
       IsAllowNull = true, IsKey = false, Length = 20)]
        public string OLD_DYDJID
        {
            get { return _OLD_DYDJID; }
            set { _OLD_DYDJID = value; }
        }

        private string _BJCPXX_WJ;
        [ColumnMap(DbField = "BJCPXX_WJ", CtrlName = "txtWJ", Type = FieldType.F,
         DbTitle = "外径", DefaultValue = "0",
         IsAllowNull = true, IsKey = false, Length = 0)]
        public string BJCPXX_WJ
        {
            get { return _BJCPXX_WJ; }
            set { _BJCPXX_WJ = value; }
        }
        private string _BJCPXX_ZXWQBS;
        [ColumnMap(DbField = "BJCPXX_ZXWQBS", CtrlName = "txtZXWQBS", Type = FieldType.F,
         DbTitle = "最小弯曲倍数", DefaultValue = "0",
         IsAllowNull = true, IsKey = false, Length = 0)]
        public string BJCPXX_ZXWQBS
        {
            get { return _BJCPXX_ZXWQBS; }
            set { _BJCPXX_ZXWQBS = value; }
        }

        //导体结构信息
        private string _BJCPXX_DTJGXX;
        [ColumnMap(DbField = "BJCPXX_DTJGXX", CtrlName = "txtDTJGXX", Type = FieldType.C,
       DbTitle = "导体结构信息", DefaultValue = "",
        IsAllowNull = true, IsKey = false, Length = 250)]
        public string BJCPXX_DTJGXX
        {
            get { return _BJCPXX_DTJGXX; }
            set { _BJCPXX_DTJGXX = value; }
        }
        // 私有变量维护人
        private string _BJCPXX_WHR;
        [ColumnMap(DbField = "BJCPXX_WHR", CtrlName = "txtWHR", Type = FieldType.C,
         DbTitle = "维护人", DefaultValue = "",
         IsAllowNull = true, IsKey = false, Length = 30)]
        public string BJCPXX_WHR
        {
            get { return _BJCPXX_WHR; }
            set { _BJCPXX_WHR = value; }
        }

        // 私有变量维护人编码
        private string _BJCPXX_WHRID;
        [ColumnMap(DbField = "BJCPXX_WHRID", CtrlName = "txtWHRID", Type = FieldType.HiddenField,
         DbTitle = "维护人工号", DefaultValue = "",
         IsAllowNull = true, IsKey = false, Length = 10)]
        public string BJCPXX_WHRID
        {
            get { return _BJCPXX_WHRID; }
            set { _BJCPXX_WHRID = value; }
        }

        // 私有变量维护时间
        private string _BJCPXX_WHSJ;
        [ColumnMap(DbField = "BJCPXX_WHSJ", CtrlName = "datWHSJ", Type = FieldType.DT,
         DbTitle = "维护时间", DefaultValue = "",
         IsAllowNull = true, IsKey = false, Length = 0)]
        public string BJCPXX_WHSJ
        {
            get { return _BJCPXX_WHSJ; }
            set { _BJCPXX_WHSJ = value; }
        }
        #endregion
    }
}