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.U20261363_N_XLXSBJ
{

    [TableMap(DB = "DBERP", DbTableName = "MRDYWH", Umid = 100860174, IsWorkFlow = false, UseWhr = false,

EntitySelSql = "select XLXHID, XLXHID as OLDXLXHID,ZXJMS,ZXJMS as OLDZXJMS,ZXJMZ,ZXJMZ as OLDZXJMZ, DYDJID"
            + " from MRDYWH where XLXHID=:XLXHID and ZXJMS =:ZXJMS and ZXJMZ =:ZXJMZ ",


UpdateSql = " update MRDYWH set XLXHID=:XLXHID,ZXJMS=:ZXJMS,ZXJMZ=:ZXJMZ,DYDJID=isnull(:DYDJID,' ')"
         + " where XLXHID=:OLDXLXHID and ZXJMS = :OLDZXJMS and ZXJMZ = :OLDZXJMZ ",

InsertSql = " insert into MRDYWH(XLXHID,ZXJMS,ZXJMZ,DYDJID) "
         + " values(:XLXHID,:ZXJMS,:ZXJMZ,isnull(:DYDJID,' '))",

DeleteSql = " delete from MRDYWH where XLXHID=:XLXHID and ZXJMS=:ZXJMS and ZXJMZ=:ZXJMZ ")]

    public class XLBJD_WBBJDMX_MRDYWH : EntityManager
    {
        #region 数据实体
        private string _XLXHID;
        [ColumnMap(DbField = "XLXHID", CtrlName = "cbxXLXHID", Type = FieldType.CBX, DbTitle = "线缆型号ID", DefaultValue = "",
                    IsAllowNull = true, IsKey = true, Length = 40)]
        public string XLXHID
        {
            get { return _XLXHID; }
            set { _XLXHID = value; }
        }

        private string _OLDXLXHID;
        [ColumnMap(DbField = "OLDXLXHID", CtrlName = "txtOLDXLXHID", Type = FieldType.HiddenField, DbTitle = "原线缆型号ID", DefaultValue = "",
                    IsAllowNull = true, IsKey = false, Length = 40)]
        public string OLDXLXHID
        {
            get { return _OLDXLXHID; }
            set { _OLDXLXHID = value; }
        }

        private string _ZXJMS;
        [ColumnMap(DbField = "ZXJMS", CtrlName = "txtZXJMS", Type = FieldType.F, DbTitle = "主芯截面始", DefaultValue = "0",
                    IsAllowNull = true, IsKey = true, Length = 0)]
        public string ZXJMS
        {
            get { return _ZXJMS; }
            set { _ZXJMS = value; }
        }

        private string _OLDZXJMS;
        [ColumnMap(DbField = "OLDZXJMS", CtrlName = "txtOLDZXJMS", Type = FieldType.HiddenField, DbTitle = "原主芯截面始", DefaultValue = "",
                    IsAllowNull = true, IsKey = false, Length = 0)]
        public string OLDZXJMS
        {
            get { return _OLDZXJMS; }
            set { _OLDZXJMS = value; }
        }

        private string _ZXJMZ;
        [ColumnMap(DbField = "ZXJMZ", CtrlName = "txtZXJMZ", Type = FieldType.F, DbTitle = "主芯截面止", DefaultValue = "0",
                    IsAllowNull = true, IsKey = true, Length = 0)]
        public string ZXJMZ
        {
            get { return _ZXJMZ; }
            set { _ZXJMZ = value; }
        }

        private string _OLDZXJMZ;
        [ColumnMap(DbField = "OLDZXJMZ", CtrlName = "txtOLDZXJMZ", Type = FieldType.HiddenField, DbTitle = "原主芯截面止", DefaultValue = "",
                    IsAllowNull = true, IsKey = false, Length = 0)]
        public string OLDZXJMZ
        {
            get { return _OLDZXJMZ; }
            set { _OLDZXJMZ = value; }
        }

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