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

QuerySelSql = "select XLXSBJDYZZF_JGBID, XLXSBJDYZZF_DYDJID, XLXSBJDYZZF_XXJGID,XLXSBJDYZZF_DTCLID, XLXSBJDYZZF_BJSLSX, XLXSBJDYZZF_BJSLXX, " + "\r\n"
                + " XLXSBJDYZZF_YZID, XLXSBJDYZZF_YZZ, XLXSBJDYZZF_WHR, XLXSBJDYZZF_WHRID, XLXSBJDYZZF_WHSJ " + "\r\n"
               + " from XLXSBJDYZZF " + "\r\n"
                + " where 1=1 ",

EntitySelSql = " select XLXSBJDYZZF_JGBID, XLXSBJDYZZF_YZID,XLXSBJDYZZF_YZID AS OLD_XLXSBJDYZZF_YZID,"
             + " XLXSBJDYZZF_DYDJID,XLXSBJDYZZF_DYDJID AS  OLD_XLXSBJDYZZF_DYDJID, XLXSBJDYZZF_XXJGID,XLXSBJDYZZF_DTCLID, XLXSBJDYZZF_XXJGID AS OLD_XLXSBJDYZZF_XXJGID,XLXSBJDYZZF_DTCLID AS OLD_XLXSBJDYZZF_DTCLID,"
                + " XLXSBJDYZZF_BJSLSX, XLXSBJDYZZF_BJSLSX AS OLD_XLXSBJDYZZF_BJSLSX,XLXSBJDYZZF_BJSLXX,XLXSBJDYZZF_BJSLXX AS OLD_XLXSBJDYZZF_BJSLXX,"
                + " XLXSBJDYZZF_YZZ, XLXSBJDYZZF_WHR, XLXSBJDYZZF_WHRID, XLXSBJDYZZF_WHSJ "
                + " from XLXSBJDYZZF left join XLXSTZYZ on XLXSTZYZ_YZID=XLXSBJDYZZF_YZID and XLXSTZYZ_MXBH='BJD' "
        + " where XLXSBJDYZZF_JGBID =:XLXSBJDYZZF_JGBID and XLXSBJDYZZF_YZID =:XLXSBJDYZZF_YZID  "
        + " and XLXSBJDYZZF_DYDJID=:XLXSBJDYZZF_DYDJID "
     + " and XLXSBJDYZZF_XXJGID =:XLXSBJDYZZF_XXJGID and XLXSBJDYZZF_DTCLID =:XLXSBJDYZZF_DTCLID and XLXSBJDYZZF_BJSLSX=:XLXSBJDYZZF_BJSLSX and XLXSBJDYZZF_BJSLXX=:XLXSBJDYZZF_BJSLXX ",

     UpdateSql = " update XLXSBJDYZZF "
        + " set XLXSBJDYZZF_JGBID = :XLXSBJDYZZF_JGBID, "
        + " XLXSBJDYZZF_DYDJID=:XLXSBJDYZZF_DYDJID,  "
     + " XLXSBJDYZZF_XXJGID =:XLXSBJDYZZF_XXJGID,XLXSBJDYZZF_DTCLID =:XLXSBJDYZZF_DTCLID, XLXSBJDYZZF_BJSLSX=isnull(:XLXSBJDYZZF_BJSLSX,0), XLXSBJDYZZF_BJSLXX=isnull(:XLXSBJDYZZF_BJSLXX,0),XLXSBJDYZZF_YZZ=isnull(:XLXSBJDYZZF_YZZ,0), "
        + " XLXSBJDYZZF_WHR=:XLXSBJDYZZF_WHR, XLXSBJDYZZF_WHRID=:XLXSBJDYZZF_WHRID, XLXSBJDYZZF_WHSJ=:XLXSBJDYZZF_WHSJ "
        + " where XLXSBJDYZZF_JGBID =:XLXSBJDYZZF_JGBID "
        + " and XLXSBJDYZZF_DYDJID=:OLD_XLXSBJDYZZF_DYDJID "
     + " and XLXSBJDYZZF_XXJGID =:OLD_XLXSBJDYZZF_XXJGID and XLXSBJDYZZF_DTCLID =:OLD_XLXSBJDYZZF_DTCLID and XLXSBJDYZZF_BJSLSX=:OLD_XLXSBJDYZZF_BJSLSX and XLXSBJDYZZF_BJSLXX=:OLD_XLXSBJDYZZF_BJSLXX ",


   InsertSql = " select XLXSBJDYZZF_JGBID from XLXSBJDYZZF where 1 <> 1 ",
DeleteSql = " delete from XLXSBJDYZZF where XLXSBJDYZZF_JGBID =:XLXSBJDYZZF_JGBID "
      + " and XLXSBJDYZZF_DYDJID=isnull(:XLXSBJDYZZF_DYDJID,' ') and XLXSBJDYZZF_XXJGID=isnull(:XLXSBJDYZZF_XXJGID,' ') and XLXSBJDYZZF_DTCLID=isnull(:XLXSBJDYZZF_DTCLID,' ')"
        + " and XLXSBJDYZZF_BJSLSX=:XLXSBJDYZZF_BJSLSX and XLXSBJDYZZF_BJSLXX=:XLXSBJDYZZF_BJSLXX ")]

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

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

        private string _OLD_XLXSBJDYZZF_DYDJID;
        [ColumnMap(DbField = "OLD_XLXSBJDYZZF_DYDJID", CtrlName = "txtOLD_DYDJID", DbTitle = "原电压等级", Type = FieldType.HiddenField, DefaultValue = "",
           IsAllowNull = true, IsKey = false, Length = 20, PrintVisible = false)]
        public string OLD_XLXSBJDYZZF_DYDJID
        {
            get { return _OLD_XLXSBJDYZZF_DYDJID; }
            set { _OLD_XLXSBJDYZZF_DYDJID = value; }
        }

        private string _XLXSBJDYZZF_XXJGID;
        [ColumnMap(DbField = "XLXSBJDYZZF_XXJGID", CtrlName = "txtXXJGID", DbTitle = "芯线结构", Type = FieldType.C, DefaultValue = " ",
      IsAllowNull = true, IsKey = false, Length = 20)]
        public string XLXSBJDYZZF_XXJGID
        {
            get { return _XLXSBJDYZZF_XXJGID; }
            set { _XLXSBJDYZZF_XXJGID = value; }
        }

        private string _OLD_XLXSBJDYZZF_XXJGID;
        [ColumnMap(DbField = "OLD_XLXSBJDYZZF_XXJGID", CtrlName = "txtOLD_XXJGID", DbTitle = "原芯线结构", Type = FieldType.HiddenField, DefaultValue = "",
           IsAllowNull = true, IsKey = false, Length = 20, PrintVisible = false)]
        public string OLD_XLXSBJDYZZF_XXJGID
        {
            get { return _OLD_XLXSBJDYZZF_XXJGID; }
            set { _OLD_XLXSBJDYZZF_XXJGID = value; }
        }

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

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

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

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

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

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

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

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

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

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

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

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