N_XLXSBJ----MX/TZYZBJ2.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_XLXSBJ
{
    [TableMap(DB = "DBERP", DbTableName = "XLXSBJDYZZ2", Umid = 100860021, IsWorkFlow = false, IsAttach = false, UseWhr = true,

EntitySelSql = " select XLXSBJDYZZ2_JGBID,XLXSBJDYZZ2_YZID,XLXSTZYZ_JJFS,XLXSBJDYZZ2_DTCLID,XLXSBJDYZZ2_DYSX,XLXSBJDYZZ2_DYXX,XLXSBJDYZZ2_DYJLDW," + "\r\n"
            + "    XLXSBJDYZZ2_BJSLSX,XLXSBJDYZZ2_BJSLXX,XLXSBJDYZZ2_YZZ,XLXSBJDYZZ2_WHR,XLXSBJDYZZ2_WHRID,XLXSBJDYZZ2_WHSJ " + "\r\n"
            + " from XLXSBJDYZZ2 left join XLXSTZYZ on XLXSTZYZ_YZID=XLXSBJDYZZ2_YZID and XLXSTZYZ_MXBH='BJD' " + "\r\n"
    + " where XLXSBJDYZZ2_JGBID =:XLXSBJDYZZ2_JGBID and XLXSBJDYZZ2_YZID =:XLXSBJDYZZ2_YZID and XLXSBJDYZZ2_DYSX=:XLXSBJDYZZ2_DYSX and XLXSBJDYZZ2_DYXX=:XLXSBJDYZZ2_DYXX "
    + " and XLXSBJDYZZ2_BJSLSX=:XLXSBJDYZZ2_BJSLSX and XLXSBJDYZZ2_BJSLXX=:XLXSBJDYZZ2_BJSLXX and XLXSBJDYZZ2_DTCLID=:XLXSBJDYZZ2_DTCLID",

    UpdateSql = " update XLXSBJDYZZ2 " + "\r\n"
    + " set XLXSBJDYZZ2_JGBID = :XLXSBJDYZZ2_JGBID, XLXSBJDYZZ2_DTCLID=:XLXSBJDYZZ2_DTCLID, XLXSBJDYZZ2_DYSX=:XLXSBJDYZZ2_DYSX, XLXSBJDYZZ2_DYXX=:XLXSBJDYZZ2_DYXX, XLXSBJDYZZ2_DYJLDW=:XLXSBJDYZZ2_DYJLDW, " + "\r\n"
    + " XLXSBJDYZZ2_BJSLSX=:XLXSBJDYZZ2_BJSLSX, XLXSBJDYZZ2_BJSLXX=:XLXSBJDYZZ2_BJSLXX,"
    + "  XLXSBJDYZZ2_YZZ = isnull(:XLXSBJDYZZ2_YZZ,0), XLXSBJDYZZ2_WHR= :XLXSBJDYZZ2_WHR, XLXSBJDYZZ2_WHRID = :XLXSBJDYZZ2_WHRID, XLXSBJDYZZ2_WHSJ=:XLXSBJDYZZ2_WHSJ "
    + " where XLXSBJDYZZ2_JGBID =:XLXSBJDYZZ2_JGBID and XLXSBJDYZZ2_DYSX=:OLD_XLXSBJDYZZ2_DYSX and XLXSBJDYZZ2_DYXX=:OLD_XLXSBJDYZZ2_DYXX "
    + " and XLXSBJDYZZ2_BJSLSX=:OLD_XLXSBJDYZZ2_BJSLSX and XLXSBJDYZZ2_BJSLXX=:OLD_XLXSBJDYZZ2_BJSLXX and XLXSBJDYZZ2_DTCLID=:OLD_XLXSBJDYZZ2_DTCLID",

  InsertSql = " select XLXSBJDYZZ2_JGBID from XLXSBJDYZZ2 where 1 <> 1 ",

DeleteSql = " delete from XLXSBJDYZZ2 where XLXSBJDYZZ2_JGBID =:XLXSBJDYZZ2_JGBID and XLXSBJDYZZ2_DYSX=:XLXSBJDYZZ2_DYSX and XLXSBJDYZZ2_DYXX=:XLXSBJDYZZ2_DYXX and XLXSBJDYZZ2_BJSLSX=:XLXSBJDYZZ2_BJSLSX and XLXSBJDYZZ2_BJSLXX=:XLXSBJDYZZ2_BJSLXX and XLXSBJDYZZ2_DTCLID=:XLXSBJDYZZ2_DTCLID ")]

    public class TZYZBJ2 : EntityManager
    {
        private string _XLXSBJDYZZ2_JGBID;
        [ColumnMap(DbField = "XLXSBJDYZZ2_JGBID", CtrlName = "txtJGBID", DbTitle = "调价表编号", Type = FieldType.HiddenField, DefaultValue = "",
            IsAllowNull = false, IsKey = true, Length = 8)]
        public string XLXSBJDYZZ2_JGBID
        {
            get { return _XLXSBJDYZZ2_JGBID; }
            set { _XLXSBJDYZZ2_JGBID = value; }
        }

        private string _XLXSBJDYZZ2_YZID;
        [ColumnMap(DbField = "XLXSBJDYZZ2_YZID", CtrlName = "cbxYZID", DbTitle = "调价因子", Type = FieldType.CBX, DefaultValue = "",
           IsAllowNull = true, IsKey = true, Length = 10)]
        public string XLXSBJDYZZ2_YZID
        {
            get { return _XLXSBJDYZZ2_YZID; }
            set { _XLXSBJDYZZ2_YZID = value; }
        }

        private string _OLD_XLXSBJDYZZ2_YZID;
        [ColumnMap(DbField = "OLD_XLXSBJDYZZ2_YZID", CtrlName = "txtOLD_YZID", DbTitle = "原调价因子编码", Type = FieldType.HiddenField, DefaultValue = "",
            IsAllowNull = true, IsKey = false, Length = 10)]
        public string OLD_XLXSBJDYZZ2_YZID
        {
            get { return _OLD_XLXSBJDYZZ2_YZID; }
            set { _OLD_XLXSBJDYZZ2_YZID = value; }
        }

        private string _XLXSBJDYZZ2_DTCLID;
        [ColumnMap(DbField = "XLXSBJDYZZ2_DTCLID", CtrlName = "cbxDTCLID", DbTitle = "导体材料", Type = FieldType.CBX, DefaultValue = "",
           IsAllowNull = true, IsKey = true, Length = 10)]
        public string XLXSBJDYZZ2_DTCLID
        {
            get { return _XLXSBJDYZZ2_DTCLID; }
            set { _XLXSBJDYZZ2_DTCLID = value; }
        }

        private string _OLD_XLXSBJDYZZ2_DTCLID;
        [ColumnMap(DbField = "OLD_XLXSBJDYZZ2_DTCLID", CtrlName = "txtOLD_DTCLID", DbTitle = "原导体材料", Type = FieldType.HiddenField, DefaultValue = "",
          IsAllowNull = true, IsKey = false, Length = 10, PrintVisible = false)]
        public string OLD_XLXSBJDYZZ2_DTCLID
        {
            get { return _OLD_XLXSBJDYZZ2_DTCLID; }
            set { _OLD_XLXSBJDYZZ2_DTCLID = value; }
        }


        private string _XLXSBJDYZZ2_DYSX;
        [ColumnMap(DbField = "XLXSBJDYZZ2_DYSX", CtrlName = "txtDYSX", DbTitle = "电压上限", Type = FieldType.HiddenField, DefaultValue = "0",
            IsAllowNull = false, IsKey = true, Length = 0)]
        public string XLXSBJDYZZ2_DYSX
        {
            get { return _XLXSBJDYZZ2_DYSX; }
            set { _XLXSBJDYZZ2_DYSX = value; }
        }

        private string _OLD_XLXSBJDYZZ2_DYSX;
        [ColumnMap(DbField = "OLD_XLXSBJDYZZ2_DYSX", CtrlName = "txtOLD_DYSX", DbTitle = "原电压上限", Type = FieldType.HiddenField, DefaultValue = "0",
            IsAllowNull = true, IsKey = false, Length = 0)]
        public string OLD_XLXSBJDYZZ2_DYSX
        {
            get { return _OLD_XLXSBJDYZZ2_DYSX; }
            set { _OLD_XLXSBJDYZZ2_DYSX = value; }
        }

        private string _XLXSBJDYZZ2_DYXX;
        [ColumnMap(DbField = "XLXSBJDYZZ2_DYXX", CtrlName = "txtDYXX", DbTitle = "电压下限", Type = FieldType.HiddenField, DefaultValue = "0",
            IsAllowNull = false, IsKey = true, Length = 0)]
        public string XLXSBJDYZZ2_DYXX
        {
            get { return _XLXSBJDYZZ2_DYXX; }
            set { _XLXSBJDYZZ2_DYXX = value; }
        }

        private string _OLD_XLXSBJDYZZ2_DYXX;
        [ColumnMap(DbField = "OLD_XLXSBJDYZZ2_DYXX", CtrlName = "txtOLD_DYXX", DbTitle = "原电压下限", Type = FieldType.HiddenField, DefaultValue = "0",
            IsAllowNull = true, IsKey = false, Length = 0)]
        public string OLD_XLXSBJDYZZ2_DYXX
        {
            get { return _OLD_XLXSBJDYZZ2_DYXX; }
            set { _OLD_XLXSBJDYZZ2_DYXX = value; }
        }

        private string _XLXSBJDYZZ2_DYJLDW;
        [ColumnMap(DbField = "XLXSBJDYZZ2_DYJLDW", CtrlName = "cbxDYJLDW", DbTitle = "电压计量单位", Type = FieldType.CBX, DefaultValue = "",
           IsAllowNull = false, IsKey = false, Length = 8)]
        public string XLXSBJDYZZ2_DYJLDW
        {
            get { return _XLXSBJDYZZ2_DYJLDW; }
            set { _XLXSBJDYZZ2_DYJLDW = value; }
        }

        private string _XLXSBJDYZZ2_BJSLSX;
        [ColumnMap(DbField = "XLXSBJDYZZ2_BJSLSX", CtrlName = "txtBJSLSX", DbTitle = "报价数量上限", Type = FieldType.F, DefaultValue = "0",
            IsAllowNull = false, IsKey = true, Length = 0)]
        public string XLXSBJDYZZ2_BJSLSX
        {
            get { return _XLXSBJDYZZ2_BJSLSX; }
            set { _XLXSBJDYZZ2_BJSLSX = value; }
        }

        private string _OLD_XLXSBJDYZZ2_BJSLSX;
        [ColumnMap(DbField = "OLD_XLXSBJDYZZ2_BJSLSX", CtrlName = "txtOLD_BJSLSX", DbTitle = "原报价数量上限", Type = FieldType.HiddenField, DefaultValue = "0",
            IsAllowNull = true, IsKey = false, Length = 0)]
        public string OLD_XLXSBJDYZZ2_BJSLSX
        {
            get { return _OLD_XLXSBJDYZZ2_BJSLSX; }
            set { _OLD_XLXSBJDYZZ2_BJSLSX = value; }
        }

        private string _XLXSBJDYZZ2_BJSLXX;
        [ColumnMap(DbField = "XLXSBJDYZZ2_BJSLXX", CtrlName = "txtBJSLXX", DbTitle = "报价数量下限", Type = FieldType.F, DefaultValue = "0",
            IsAllowNull = false, IsKey = true, Length = 0)]
        public string XLXSBJDYZZ2_BJSLXX
        {
            get { return _XLXSBJDYZZ2_BJSLXX; }
            set { _XLXSBJDYZZ2_BJSLXX = value; }
        }

        private string _OLD_XLXSBJDYZZ2_BJSLXX;
        [ColumnMap(DbField = "OLD_XLXSBJDYZZ2_BJSLXX", CtrlName = "txtOLD_BJSLXX", DbTitle = "原报价数量下限", Type = FieldType.HiddenField, DefaultValue = "0",
            IsAllowNull = true, IsKey = false, Length = 0)]
        public string OLD_XLXSBJDYZZ2_BJSLXX
        {
            get { return _OLD_XLXSBJDYZZ2_BJSLXX; }
            set { _OLD_XLXSBJDYZZ2_BJSLXX = value; }
        }

        private string _XLXSTZYZ_JJFS;
        [ColumnMap(DbField = "XLXSTZYZ_JJFS", CtrlName = "cbxJJFS", DbTitle = "调价方式", Type = FieldType.CBX, DefaultValue = "",
          IsAllowNull = true, IsKey = false, Length = 2)]
        public string XLXSTZYZ_JJFS
        {
            get { return _XLXSTZYZ_JJFS; }
            set { _XLXSTZYZ_JJFS = value; }
        }

        private string _XLXSBJDYZZ2_YZZ;
        [ColumnMap(DbField = "XLXSBJDYZZ2_YZZ", CtrlName = "txtYZZ", Type = FieldType.F, DbTitle = "因子值", DefaultValue = "0",
            IsAllowNull = true, IsKey = false, Length = 0)]
        public string XLXSBJDYZZ2_YZZ
        {
            get { return _XLXSBJDYZZ2_YZZ; }
            set { _XLXSBJDYZZ2_YZZ = value; }
        }

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

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

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