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; using GThinking.N_MISPRO.Data; using System.Collections.Generic; using GThinking.N_MISPRO.Utility; namespace GThinking.N_XLJC { [TableMap(DB = "DBERP", DbTableName = "XLXSCPML", Umid = 101421007, IsWorkFlow = false, UseWhr = true, QuerySelSql = "select XLXSCPML_CPMLID,XLXSCPML_CPMLMC,XLXSCPML_CPMLLX,XLXSCPML_CPMLIDS,XLXSCPML_SJY,XLXSCPML_BJY,XLXSCPML_TJY,XLXSCPML_XSXH," + " XLXSCPML_QYRQ,XLXSCPML_TYBZ,XLXSCPML_TYRQ,XLXSCPML_BZ,XLXSCPML_WHR,XLXSCPML_WHRID,XLXSCPML_WHSJ,XLXSCPML_FZR" + " from XLXSCPML where 1=1", EntitySelSql = "select XLXSCPML_CPMLID, XLXSCPML_CPMLID as OLDCPMLID,XLXSCPML_CPMLMC,XLXSCPML_CPMLLX,XLXSCPML_CPMLIDS,XLXSCPML_SJY,XLXSCPML_BJY,XLXSCPML_TJY,XLXSCPML_XSXH," + " XLXSCPML_QYRQ,XLXSCPML_TYBZ,XLXSCPML_TYRQ,XLXSCPML_BZ,XLXSCPML_WHR,XLXSCPML_WHRID,XLXSCPML_WHSJ,XLXSCPML_FZR" + " from XLXSCPML where XLXSCPML_CPMLID=:XLXSCPML_CPMLID ", UpdateSql = " update XLXSCPML set XLXSCPML_CPMLID=:XLXSCPML_CPMLID,XLXSCPML_CPMLMC=:XLXSCPML_CPMLMC,XLXSCPML_CPMLLX=:XLXSCPML_CPMLLX,XLXSCPML_CPMLIDS=:XLXSCPML_CPMLIDS,XLXSCPML_SJY=:XLXSCPML_SJY,XLXSCPML_BJY=:XLXSCPML_BJY,XLXSCPML_TJY=:XLXSCPML_TJY," + " XLXSCPML_XSXH=:XLXSCPML_XSXH,XLXSCPML_QYRQ=:XLXSCPML_QYRQ,XLXSCPML_TYBZ=:XLXSCPML_TYBZ,XLXSCPML_TYRQ=:XLXSCPML_TYRQ, XLXSCPML_BZ=:XLXSCPML_BZ, XLXSCPML_WHR=:XLXSCPML_WHR,XLXSCPML_WHRID=:XLXSCPML_WHRID,XLXSCPML_WHSJ=:XLXSCPML_WHSJ,XLXSCPML_FZR=:XLXSCPML_FZR " + "\r\n" + " where XLXSCPML_CPMLID=:OLDCPMLID ", InsertSql = " insert into XLXSCPML(XLXSCPML_CPMLID,XLXSCPML_CPMLMC,XLXSCPML_CPMLLX,XLXSCPML_CPMLIDS,XLXSCPML_SJY,XLXSCPML_BJY, XLXSCPML_TJY,XLXSCPML_FZR," + " XLXSCPML_XSXH,XLXSCPML_QYRQ,XLXSCPML_TYBZ,XLXSCPML_TYRQ,XLXSCPML_BZ,XLXSCPML_WHR,XLXSCPML_WHRID,XLXSCPML_WHSJ) " + " values(:XLXSCPML_CPMLID,:XLXSCPML_CPMLMC,:XLXSCPML_CPMLLX,:XLXSCPML_CPMLIDS,:XLXSCPML_SJY,:XLXSCPML_BJY,:XLXSCPML_TJY,:XLXSCPML_FZR, " + " :XLXSCPML_XSXH, :XLXSCPML_QYRQ,:XLXSCPML_TYBZ,:XLXSCPML_TYRQ,:XLXSCPML_BZ,:XLXSCPML_WHR,:XLXSCPML_WHRID,:XLXSCPML_WHSJ)", DeleteSql = " delete from XLXSCPML where XLXSCPML_CPMLID=:XLXSCPML_CPMLID ")] public class CPML : EntityManager { #region 数据实体 private string _XLXSCPML_CPMLID; [ColumnMap(DbField = "XLXSCPML_CPMLID", CtrlName = "txtCPMLID", Type = FieldType.C, DbTitle = "产品目录编号", DefaultValue = "", IsAllowNull = false, IsKey = true, Length = 2)] public string XLXSCPML_CPMLID { get { return _XLXSCPML_CPMLID; } set { _XLXSCPML_CPMLID = value; } } private string _OLDCPMLID; [ColumnMap(DbField = "OLDCPMLID", CtrlName = "txtOLDCPMLID", Type = FieldType.HiddenField, DbTitle = "原产品目录编号", DefaultValue = "", IsAllowNull = true, IsKey = false, Length = 2)] public string OLDCPMLID { get { return _OLDCPMLID; } set { _OLDCPMLID = value; } } private string _XLXSCPML_CPMLMC; [ColumnMap(DbField = "XLXSCPML_CPMLMC", CtrlName = "txtCPMLMC", Type = FieldType.C, DbTitle = "产品目录名称", DefaultValue = "", IsAllowNull = false, IsKey = false, Length = 100)] public string XLXSCPML_CPMLMC { get { return _XLXSCPML_CPMLMC; } set { _XLXSCPML_CPMLMC = value; } } private string _XLXSCPML_CPMLLX; [ColumnMap(DbField = "XLXSCPML_CPMLLX", CtrlName = "cbxCPMLLX", Type = FieldType.CBX, DbTitle = "产品目录类型", DefaultValue = "", IsAllowNull = false, IsKey = false, Length = 1)] public string XLXSCPML_CPMLLX { get { return _XLXSCPML_CPMLLX; } set { _XLXSCPML_CPMLLX = value; } } private string _XLXSCPML_FZR; [ColumnMap(DbField = "XLXSCPML_FZR", CtrlName = "txtFZR", Type = FieldType.C, DbTitle = "负责人", DefaultValue = "", IsAllowNull = true, IsKey = false, Length = 30)] public string XLXSCPML_FZR { get { return _XLXSCPML_FZR; } set { _XLXSCPML_FZR = value; } } private string _XLXSCPML_CPMLIDS; [ColumnMap(DbField = "XLXSCPML_CPMLIDS", CtrlName = "cbxCPMLIDS", Type = FieldType.CL, DbTitle = "包含产品目录", DefaultValue = "", IsAllowNull = true, IsKey = false, Length = 250)] public string XLXSCPML_CPMLIDS { get { return _XLXSCPML_CPMLIDS; } set { _XLXSCPML_CPMLIDS = value; } } //显示序号 private string _XLXSCPML_XSXH; [ColumnMap(DbField = "XLXSCPML_XSXH", CtrlName = "txtXSXH", Type = FieldType.F, DbTitle = "显示序号", DefaultValue = "0", IsAllowNull = false, IsKey = false, Length = 0)] public string XLXSCPML_XSXH { get { return _XLXSCPML_XSXH; } set { _XLXSCPML_XSXH = value; } } // 私有变量启用日期 private string _XLXSCPML_QYRQ; [ColumnMap(DbField = "XLXSCPML_QYRQ", CtrlName = "datQYSJ", Type = FieldType.D, DbTitle = "启用日期", DefaultValue = "", IsAllowNull = true, IsKey = false, Length = 10)] public string XLXSCPML_QYRQ { get { return _XLXSCPML_QYRQ; } set { _XLXSCPML_QYRQ = value; } } // 私有变量停用标志 private string _XLXSCPML_TYBZ; [ColumnMap(DbField = "XLXSCPML_TYBZ", CtrlName = "chkTYBZ", Type = FieldType.Y, DbTitle = "停用标志", DefaultValue = "", IsAllowNull = true, IsKey = false, Length = 1)] public string XLXSCPML_TYBZ { get { return _XLXSCPML_TYBZ; } set { _XLXSCPML_TYBZ = value; } } // 私有变量停用日期 private string _XLXSCPML_TYRQ; [ColumnMap(DbField = "XLXSCPML_TYRQ", CtrlName = "datTYSJ", Type = FieldType.D, DbTitle = "停用日期", DefaultValue = "", IsAllowNull = true, IsKey = false, Length = 10)] public string XLXSCPML_TYRQ { get { return _XLXSCPML_TYRQ; } set { _XLXSCPML_TYRQ = value; } } private string _XLXSCPML_BZ; [ColumnMap(DbField = "XLXSCPML_BZ", CtrlName = "txtBZ", DbTitle = "备注", Type = FieldType.C, DefaultValue = "", IsAllowNull = true, IsKey = false, Length = 250)] public string XLXSCPML_BZ { get { return _XLXSCPML_BZ; } set { _XLXSCPML_BZ = value; } } // 私有变量设计用 private string _XLXSCPML_SJY; [ColumnMap(DbField = "XLXSCPML_SJY", CtrlName = "chkSJY", Type = FieldType.Y, DbTitle = "设计用", DefaultValue = "", IsAllowNull = true, IsKey = false, Length = 1)] public string XLXSCPML_SJY { get { return _XLXSCPML_SJY; } set { _XLXSCPML_SJY = value; } } // 私有变量报价用 private string _XLXSCPML_BJY; [ColumnMap(DbField = "XLXSCPML_BJY", CtrlName = "chkBJY", Type = FieldType.Y, DbTitle = "报价用", DefaultValue = "", IsAllowNull = true, IsKey = false, Length = 1)] public string XLXSCPML_BJY { get { return _XLXSCPML_BJY; } set { _XLXSCPML_BJY = value; } } // 私有变量调价用 private string _XLXSCPML_TJY; [ColumnMap(DbField = "XLXSCPML_TJY", CtrlName = "chkTJY", Type = FieldType.Y, DbTitle = "调价用", DefaultValue = "", IsAllowNull = true, IsKey = false, Length = 1)] public string XLXSCPML_TJY { get { return _XLXSCPML_TJY; } set { _XLXSCPML_TJY = value; } } // 私有变量维护人 private string _XLXSCPML_WHR; [ColumnMap(DbField = "XLXSCPML_WHR", CtrlName = "txtWHR", Type = FieldType.C, DbTitle = "维护人", DefaultValue = "", IsAllowNull = true, IsKey = false, Length = 30)] public string XLXSCPML_WHR { get { return _XLXSCPML_WHR; } set { _XLXSCPML_WHR = value; } } // 私有变量维护人工号 private string _XLXSCPML_WHRID; [ColumnMap(DbField = "XLXSCPML_WHRID", CtrlName = "txtWHRID", Type = FieldType.HiddenField, DbTitle = "维护人ID", DefaultValue = "", IsAllowNull = true, IsKey = false, Length = 10)] public string XLXSCPML_WHRID { get { return _XLXSCPML_WHRID; } set { _XLXSCPML_WHRID = value; } } // 私有变量维护时间 private string _XLXSCPML_WHSJ; [ColumnMap(DbField = "XLXSCPML_WHSJ", CtrlName = "datWHSJ", Type = FieldType.DT, DbTitle = "维护时间", DefaultValue = "", IsAllowNull = false, IsKey = true, Length = 18)] public string XLXSCPML_WHSJ { get { return _XLXSCPML_WHSJ; } set { _XLXSCPML_WHSJ = value; } } #endregion #region 公用函数 #endregion } }