314 lines
14 KiB
C#
314 lines
14 KiB
C#
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 = "XLXHB", Umid = 101421000, IsWorkFlow = false, UseWhr = true, IsAttach = false,
|
|
|
|
QuerySelSql = @"select XLXHB_XLJBXHID,XLXHB_XLXHID,XLXHB_XLXHID as XLXHID_OLD,XLXHB_XLXHBH,XLXHB_XLXHMC,XLXHB_XLTXID,XLXHB_NWDJID,XLXHB_DTCLID,XLXHB_JYCLID,
|
|
XLXHB_HTCLID,XLXHB_KZCLID,XLXHB_WHCLID,XLXHB_PBCLID,XLXHB_QYRQ,XLXHB_TYBZ,XLXHB_TYRQ,XLXHB_BZ,XLXHB_WHR,XLXHB_WHRID,XLXHB_WHSJ,
|
|
XLXHB_FPCLID,XLXHB_CPYT,XLXHB_NYDJID,XLXHB_WXDJID,XLXHB_JQCLID,XLXHB_XLGGJDGZ
|
|
from XLXHB
|
|
where 1 = 1 order by XLXHB_XLXHID",
|
|
|
|
EntitySelSql = @"select XLXHB_XLJBXHID,XLXHB_XLXHID,XLXHB_XLXHID as XLXHID_OLD,XLXHB_XLXHBH,XLXHB_XLXHMC,XLXHB_XLTXID,XLXHB_NWDJID,XLXHB_DTCLID,XLXHB_JYCLID,
|
|
XLXHB_HTCLID,XLXHB_KZCLID,XLXHB_WHCLID,XLXHB_PBCLID,XLXHB_QYRQ,XLXHB_TYBZ,XLXHB_TYRQ,XLXHB_BZ,XLXHB_WHR,XLXHB_WHRID,XLXHB_WHSJ,
|
|
XLXHB_FPCLID,XLXHB_CPYT,XLXHB_NYDJID,XLXHB_WXDJID,XLXHB_JQCLID,XLXHB_XLGGJDGZ
|
|
from XLXHB
|
|
where XLXHB_XLXHID = :XLXHB_XLXHID",
|
|
|
|
InsertSql = @"insert into XLXHB (XLXHB_XLJBXHID,XLXHB_XLXHID,XLXHB_XLXHBH,XLXHB_XLXHMC,XLXHB_XLTXID,XLXHB_NWDJID,XLXHB_DTCLID,XLXHB_JYCLID,
|
|
XLXHB_HTCLID,XLXHB_KZCLID,XLXHB_WHCLID,XLXHB_PBCLID,XLXHB_QYRQ,XLXHB_TYBZ,XLXHB_TYRQ,XLXHB_BZ,XLXHB_WHR,XLXHB_WHRID,XLXHB_WHSJ,
|
|
XLXHB_FPCLID,XLXHB_CPYT,XLXHB_NYDJID,XLXHB_WXDJID,XLXHB_JQCLID,XLXHB_XLGGJDGZ )
|
|
values(:XLXHB_XLJBXHID,:XLXHB_XLXHID,:XLXHB_XLXHBH, :XLXHB_XLXHMC,:XLXHB_XLTXID,:XLXHB_NWDJID,:XLXHB_DTCLID,:XLXHB_JYCLID,
|
|
:XLXHB_HTCLID,:XLXHB_KZCLID,:XLXHB_WHCLID,:XLXHB_PBCLID,:XLXHB_QYRQ,:XLXHB_TYBZ,:XLXHB_TYRQ,:XLXHB_BZ,:XLXHB_WHR,:XLXHB_WHRID,:XLXHB_WHSJ,
|
|
:XLXHB_FPCLID,:XLXHB_CPYT,:XLXHB_NYDJID,:XLXHB_WXDJID,:XLXHB_JQCLID,:XLXHB_XLGGJDGZ )",
|
|
|
|
UpdateSql = @"update XLXHB set XLXHB_XLJBXHID = :XLXHB_XLJBXHID,
|
|
XLXHB_XLXHID = :XLXHB_XLXHID,
|
|
XLXHB_XLXHBH = :XLXHB_XLXHBH,
|
|
XLXHB_XLXHMC = :XLXHB_XLXHMC,
|
|
XLXHB_XLTXID = :XLXHB_XLTXID,
|
|
XLXHB_NWDJID = :XLXHB_NWDJID,
|
|
XLXHB_DTCLID = :XLXHB_DTCLID,
|
|
XLXHB_JYCLID = :XLXHB_JYCLID,
|
|
XLXHB_HTCLID = :XLXHB_HTCLID,
|
|
XLXHB_KZCLID = :XLXHB_KZCLID,
|
|
XLXHB_WHCLID = :XLXHB_WHCLID,
|
|
XLXHB_PBCLID = :XLXHB_PBCLID,
|
|
XLXHB_QYRQ = :XLXHB_QYRQ,
|
|
XLXHB_TYBZ = :XLXHB_TYBZ,
|
|
XLXHB_TYRQ = :XLXHB_TYRQ,
|
|
XLXHB_BZ = :XLXHB_BZ,
|
|
XLXHB_WHR = :XLXHB_WHR,
|
|
XLXHB_WHRID = :XLXHB_WHRID,
|
|
XLXHB_WHSJ = :XLXHB_WHSJ,
|
|
XLXHB_FPCLID = :XLXHB_FPCLID,
|
|
XLXHB_CPYT = :XLXHB_CPYT,
|
|
XLXHB_WXDJID = :XLXHB_WXDJID,
|
|
XLXHB_JQCLID = :XLXHB_JQCLID,
|
|
XLXHB_XLGGJDGZ = :XLXHB_XLGGJDGZ
|
|
where XLXHB_XLXHID = :XLXHID_OLD",
|
|
|
|
DeleteSql = @"delete from XLXHB where XLXHB_XLXHID = :XLXHB_XLXHID")]
|
|
|
|
public class XLXHB : EntityManager
|
|
{
|
|
#region 字段级映射
|
|
|
|
private string _XLXHB_XLXHID;
|
|
[ColumnMap(DbField = "XLXHB_XLXHID", CtrlName = "txtXLXHID", DbTitle = "型号编码", Type = FieldType.C, DefaultValue = "",
|
|
IsAllowNull = false, IsKey = true, Length = 40)]
|
|
public string XLXHB_XLXHID
|
|
{
|
|
get { return _XLXHB_XLXHID; }
|
|
set { _XLXHB_XLXHID = value; }
|
|
}
|
|
|
|
private string _XLXHID_OLD;
|
|
[ColumnMap(DbField = "XLXHID_OLD", CtrlName = "txtXLXHID_OLD", Type = FieldType.HiddenField,
|
|
DbTitle = "隐藏线缆型号ID", DefaultValue = "", PrintVisible = false,
|
|
IsAllowNull = true, IsKey = false, Length = 40)]
|
|
public string XLXHID_OLD
|
|
{
|
|
get { return _XLXHID_OLD; }
|
|
set { _XLXHID_OLD = value; }
|
|
}
|
|
|
|
private string _XLXHB_XLXHMC;
|
|
[ColumnMap(DbField = "XLXHB_XLXHMC", CtrlName = "txtXLXHMC", DbTitle = "线缆型号名称", Type = FieldType.C, DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 250)]
|
|
public string XLXHB_XLXHMC
|
|
{
|
|
get { return _XLXHB_XLXHMC; }
|
|
set { _XLXHB_XLXHMC = value; }
|
|
}
|
|
|
|
private string _XLXHB_XLTXID;
|
|
[ColumnMap(DbField = "XLXHB_XLTXID", CtrlName = "txtXLTXID", DbTitle = "线缆特性ID", Type = FieldType.C, DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 20)]
|
|
public string XLXHB_XLTXID
|
|
{
|
|
get { return _XLXHB_XLTXID; }
|
|
set { _XLXHB_XLTXID = value; }
|
|
}
|
|
|
|
private string _XLXHB_NWDJID;
|
|
[ColumnMap(DbField = "XLXHB_NWDJID", CtrlName = "cbxNWDJID", DbTitle = "耐温等级ID", Type = FieldType.CBX, DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 20)]
|
|
public string XLXHB_NWDJID
|
|
{
|
|
get { return _XLXHB_NWDJID; }
|
|
set { _XLXHB_NWDJID = value; }
|
|
}
|
|
|
|
private string _XLXHB_DJRQ;
|
|
[ColumnMap(DbField = "XLXHB_DJRQ", CtrlName = "datDJRQ", DbTitle = "登记日期", Type = FieldType.D, DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 0)]
|
|
public string XLXHB_DJRQ
|
|
{
|
|
get { return _XLXHB_DJRQ; }
|
|
set { _XLXHB_DJRQ = value; }
|
|
}
|
|
|
|
private string _XLXHB_DTCLID;
|
|
[ColumnMap(DbField = "XLXHB_DTCLID", CtrlName = "cbxDTCLID", DbTitle = "导体材料ID", Type = FieldType.CBX, DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 10)]
|
|
public string XLXHB_DTCLID
|
|
{
|
|
get { return _XLXHB_DTCLID; }
|
|
set { _XLXHB_DTCLID = value; }
|
|
}
|
|
|
|
private string _XLXHB_JYCLID;
|
|
[ColumnMap(DbField = "XLXHB_JYCLID", CtrlName = "cbxJYCLID", Type = FieldType.CBX, DbTitle = "绝缘材料ID", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 10)]
|
|
public string XLXHB_JYCLID
|
|
{
|
|
get { return _XLXHB_JYCLID; }
|
|
set { _XLXHB_JYCLID = value; }
|
|
}
|
|
|
|
private string _XLXHB_HTCLID;
|
|
[ColumnMap(DbField = "XLXHB_HTCLID", CtrlName = "cbxHTCLID", DbTitle = "护套材料ID", Type = FieldType.CBX, DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 10)]
|
|
public string XLXHB_HTCLID
|
|
{
|
|
get { return _XLXHB_HTCLID; }
|
|
set { _XLXHB_HTCLID = value; }
|
|
}
|
|
|
|
private string _XLXHB_KZCLID;
|
|
[ColumnMap(DbField = "XLXHB_KZCLID", CtrlName = "cbxKZCLID", DbTitle = "铠装材料ID", Type = FieldType.CBX, DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 10)]
|
|
public string XLXHB_KZCLID
|
|
{
|
|
get { return _XLXHB_KZCLID; }
|
|
set { _XLXHB_KZCLID = value; }
|
|
}
|
|
|
|
private string _XLXHB_WHCLID;
|
|
[ColumnMap(DbField = "XLXHB_WHCLID", CtrlName = "cbxWHCLID", DbTitle = "外护材料ID", Type = FieldType.CBX, DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 10)]
|
|
public string XLXHB_WHCLID
|
|
{
|
|
get { return _XLXHB_WHCLID; }
|
|
set { _XLXHB_WHCLID = value; }
|
|
}
|
|
|
|
private string _XLXHB_PBCLID;
|
|
[ColumnMap(DbField = "XLXHB_PBCLID", CtrlName = "txtPBCLID", DbTitle = "屏蔽材料ID", Type = FieldType.CBX, DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 10)]
|
|
public string XLXHB_PBCLID
|
|
{
|
|
get { return _XLXHB_PBCLID; }
|
|
set { _XLXHB_PBCLID = value; }
|
|
}
|
|
|
|
private string _XLXHB_XLGGJDGZ;
|
|
[ColumnMap(DbField = "XLXHB_XLGGJDGZ", CtrlName = "cbxGGJDGZ", DbTitle = "线缆规格解读规则", Type = FieldType.CBX, DefaultValue = "0",
|
|
IsAllowNull = true, IsKey = false, Length = 1)]
|
|
public string XLXHB_XLGGJDGZ
|
|
{
|
|
get { return _XLXHB_XLGGJDGZ; }
|
|
set { _XLXHB_XLGGJDGZ = value; }
|
|
}
|
|
|
|
private string _XLXHB_QYRQ;
|
|
[ColumnMap(DbField = "XLXHB_QYRQ", CtrlName = "datQYRQ", DbTitle = "启用日期", Type = FieldType.D, DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 0)]
|
|
public string XLXHB_QYRQ
|
|
{
|
|
get { return _XLXHB_QYRQ; }
|
|
set { _XLXHB_QYRQ = value; }
|
|
}
|
|
|
|
private string _XLXHB_TYBZ;
|
|
[ColumnMap(DbField = "XLXHB_TYBZ", CtrlName = "chkTY", DbTitle = "停用标志", Type = FieldType.Y, DefaultValue = "N",
|
|
IsAllowNull = true, IsKey = false, Length = 1)]
|
|
public string XLXHB_TYBZ
|
|
{
|
|
get { return _XLXHB_TYBZ; }
|
|
set { _XLXHB_TYBZ = value; }
|
|
}
|
|
|
|
private string _XLXHB_TYRQ;
|
|
[ColumnMap(DbField = "XLXHB_TYRQ", CtrlName = "datTYRQ", DbTitle = "停用日期", Type = FieldType.D, DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 0)]
|
|
public string XLXHB_TYRQ
|
|
{
|
|
get { return _XLXHB_TYRQ; }
|
|
set { _XLXHB_TYRQ = value; }
|
|
}
|
|
|
|
|
|
private string _XLXHB_WHR;
|
|
[ColumnMap(DbField = "XLXHB_WHR", CtrlName = "txtWHR", Type = FieldType.C, DbTitle = "维护人", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 30)]
|
|
public string XLXHB_WHR
|
|
{
|
|
get { return _XLXHB_WHR; }
|
|
set { _XLXHB_WHR = value; }
|
|
}
|
|
|
|
private string _XLXHB_WHRID;
|
|
[ColumnMap(DbField = "XLXHB_WHRID", CtrlName = "txtWHRID", Type = FieldType.HiddenField, DbTitle = "维护人工号", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 10, PrintVisible = false)]
|
|
public string XLXHB_WHRID
|
|
{
|
|
get { return _XLXHB_WHRID; }
|
|
set { _XLXHB_WHRID = value; }
|
|
}
|
|
|
|
private string _XLXHB_WHSJ;
|
|
[ColumnMap(DbField = "XLXHB_WHSJ", CtrlName = "datWHSJ", Type = FieldType.DT, DbTitle = "维护时间", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 8)]
|
|
public string XLXHB_WHSJ
|
|
{
|
|
get { return _XLXHB_WHSJ; }
|
|
set { _XLXHB_WHSJ = value; }
|
|
}
|
|
|
|
private string _XLXHB_BZ;
|
|
[ColumnMap(DbField = "XLXHB_BZ", CtrlName = "txtBZ", Type = FieldType.C, DbTitle = "备注", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 250)]
|
|
public string XLXHB_BZ
|
|
{
|
|
get { return _XLXHB_BZ; }
|
|
set { _XLXHB_BZ = value; }
|
|
}
|
|
private string _XLXHB_XLXHBH;
|
|
[ColumnMap(DbField = "XLXHB_XLXHBH", CtrlName = "txtXLXHBH", DbTitle = "线缆型号编号", Type = FieldType.C, DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 4)]
|
|
public string XLXHB_XLXHBH
|
|
{
|
|
get { return _XLXHB_XLXHBH; }
|
|
set { _XLXHB_XLXHBH = value; }
|
|
}
|
|
|
|
////NONE
|
|
private string _XLXHB_XLJBXHID;
|
|
[ColumnMap(DbField = "XLXHB_XLJBXHID", CtrlName = "txtXLJBXHID", DbTitle = "线缆基本型号ID", Type = FieldType.C, DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 40)]
|
|
public string XLXHB_XLJBXHID
|
|
{
|
|
get { return _XLXHB_XLJBXHID; }
|
|
set { _XLXHB_XLJBXHID = value; }
|
|
}
|
|
|
|
private string _XLXHB_FPCLID;
|
|
[ColumnMap(DbField = "XLXHB_FPCLID", CtrlName = "txtFPCLID", DbTitle = "分屏材料ID", Type = FieldType.C, DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 10)]
|
|
public string XLXHB_FPCLID
|
|
{
|
|
get { return _XLXHB_FPCLID; }
|
|
set { _XLXHB_FPCLID = value; }
|
|
}
|
|
|
|
private string _XLXHB_CPYT;
|
|
[ColumnMap(DbField = "XLXHB_CPYT", CtrlName = "cbxCPYT", DbTitle = "产品用途", Type = FieldType.CBX, DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 4)]
|
|
public string XLXHB_CPYT
|
|
{
|
|
get { return _XLXHB_CPYT; }
|
|
set { _XLXHB_CPYT = value; }
|
|
}
|
|
|
|
private string _XLXHB_WXDJID;
|
|
[ColumnMap(DbField = "XLXHB_WXDJID", CtrlName = "txtWXDJID", DbTitle = "危险等级ID", Type = FieldType.C, DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 20)]
|
|
public string XLXHB_WXDJID
|
|
{
|
|
get { return _XLXHB_WXDJID; }
|
|
set { _XLXHB_WXDJID = value; }
|
|
}
|
|
|
|
private string _XLXHB_NYDJID;
|
|
[ColumnMap(DbField = "XLXHB_NYDJID", CtrlName = "txtNYDJID", DbTitle = "耐油等级ID", Type = FieldType.C, DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 20)]
|
|
public string XLXHB_NYDJID
|
|
{
|
|
get { return _XLXHB_NYDJID; }
|
|
set { _XLXHB_NYDJID = value; }
|
|
}
|
|
|
|
private string _XLXHB_JQCLID;
|
|
[ColumnMap(DbField = "XLXHB_JQCLID", CtrlName = "txtJQCLID", DbTitle = "加强材料ID", Type = FieldType.C, DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 10)]
|
|
public string XLXHB_JQCLID
|
|
{
|
|
get { return _XLXHB_JQCLID; }
|
|
set { _XLXHB_JQCLID = value; }
|
|
}
|
|
#endregion
|
|
}
|
|
}
|