265 lines
11 KiB
C#
265 lines
11 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 = "XLXLB", Umid = 101421012, IsWorkFlow = false, UseWhr = false, IsAttach = false,
|
|
|
|
EntitySelSql = "select XLXLB_XLXHID,XLXLB_XLGGID,XLXLB_XLBZID,XLXLB_DYDJID,XLXLB_XLXHID AS OLD_XLXHID,XLXLB_XLGGID AS OLD_XLGGID,XLXLB_XLBZID AS OLD_XLBZID,XLXLB_DYDJID AS OLD_DYDJID, " + "\r\n"
|
|
+ " XLXLB_XLYSID,XLXLB_XLYSID AS OLD_XLYSID,XLXLB_WLID,XLXLB_WLID as OLD_WLID, WL_MC,WL_GG,WL_TZ,WL_CL,WL_JLDW,XLXLB_WJ,XLXLB_ZXWQBS,XLXLB_WHR,XLXLB_WHRID,XLXLB_WHSJ,XLXLB_DTJGXX" + "\r\n"
|
|
+ " from XLXLB" + "\r\n"
|
|
+ " left join WL on WL_WLID=XLXLB_WLID " + "\r\n"
|
|
+ " where XLXLB_XLXHID=:OLD_XLXHID and XLXLB_XLGGID=:OLD_XLGGID and XLXLB_XLBZID=:OLD_XLBZID and XLXLB_DYDJID=:OLD_DYDJID and ISNULL(XLXLB_WLID, ' ')=:OLD_WLID and ISNULL(XLXLB_XLYSID, ' ')=:OLD_XLYSID ",
|
|
|
|
InsertSql = " insert into XLXLB(" + "\r\n"
|
|
+ " XLXLB_WLID,XLXLB_XLXHID,XLXLB_XLGGID,XLXLB_XLBZID,XLXLB_DYDJID,XLXLB_XLYSID,XLXLB_WJ,XLXLB_ZXWQBS,XLXLB_WHR,XLXLB_WHRID,XLXLB_WHSJ,XLXLB_DTJGXX)" + "\r\n"
|
|
+ " VALUES(" + "\r\n"
|
|
+ " ' ',:XLXLB_XLXHID,:XLXLB_XLGGID,:XLXLB_XLBZID,:XLXLB_DYDJID,:XLXLB_XLYSID,:XLXLB_WJ,:XLXLB_ZXWQBS,:XLXLB_WHR,:XLXLB_WHRID,:XLXLB_WHSJ,:XLXLB_DTJGXX)",
|
|
|
|
UpdateSql = " update XLXLB set XLXLB_XLXHID=:XLXLB_XLXHID,XLXLB_XLGGID=:XLXLB_XLGGID," + "\r\n"
|
|
+ " XLXLB_XLBZID=:XLXLB_XLBZID,XLXLB_DYDJID=:XLXLB_DYDJID,XLXLB_XLYSID=:XLXLB_XLYSID,XLXLB_WLID=:XLXLB_WLID, XLXLB_WJ = :XLXLB_WJ ,XLXLB_ZXWQBS = :XLXLB_ZXWQBS," + "\r\n"
|
|
+ " XLXLB_WHR=:XLXLB_WHR,XLXLB_WHRID=:XLXLB_WHRID,XLXLB_WHSJ=:XLXLB_WHSJ,XLXLB_DTJGXX=:XLXLB_DTJGXX"
|
|
+ " where XLXLB_XLXHID=:OLD_XLXHID and XLXLB_XLGGID=:OLD_XLGGID and XLXLB_XLBZID=:OLD_XLBZID and XLXLB_DYDJID=:OLD_DYDJID and ISNULL(XLXLB_WLID, ' ')=ISNULL(:OLD_WLID,' ') "
|
|
|
|
+ " and ISNULL(XLXLB_XLYSID, ' ')=ISNULL(:OLD_XLYSID,' ') ",
|
|
|
|
|
|
DeleteSql = "DELETE FROM XLXLB WHERE XLXLB_XLXHID=:OLD_XLXHID and XLXLB_XLGGID=:OLD_XLGGID and XLXLB_XLBZID=:OLD_XLBZID and XLXLB_DYDJID=:OLD_DYDJID and ISNULL(XLXLB_WLID, ' ')=ISNULL(:OLD_XLYSID,' ') and ISNULL(XLXLB_XLYSID, ' ')=ISNULL(:OLD_XLYSID,' ') ")]
|
|
|
|
public partial class XLCPWH : EntityManager
|
|
{
|
|
#region 字段级映射
|
|
private string _XLXLB_XLXHID;
|
|
[ColumnMap(DbField = "XLXLB_XLXHID", CtrlName = "cbxXH", Type = FieldType.CBX,
|
|
DbTitle = "型号", DefaultValue = "",
|
|
IsAllowNull = false, IsKey = false, Length = 20)]
|
|
public string XLXLB_XLXHID
|
|
{
|
|
get { return _XLXLB_XLXHID; }
|
|
set { _XLXLB_XLXHID = value; }
|
|
}
|
|
private string _XLXLB_XLGGID;
|
|
[ColumnMap(DbField = "XLXLB_XLGGID", CtrlName = "txtGG", Type = FieldType.C,
|
|
DbTitle = "规格", DefaultValue = "",
|
|
IsAllowNull = false, IsKey = false, Length = 60)]
|
|
public string XLXLB_XLGGID
|
|
{
|
|
get { return _XLXLB_XLGGID; }
|
|
set { _XLXLB_XLGGID = value; }
|
|
}
|
|
private string _XLXLB_XLBZID;
|
|
[ColumnMap(DbField = "XLXLB_XLBZID", CtrlName = "cbxBZ", Type = FieldType.CBX,
|
|
DbTitle = "标准", DefaultValue = "",
|
|
IsAllowNull = false, IsKey = false, Length = 10)]
|
|
public string XLXLB_XLBZID
|
|
{
|
|
get { return _XLXLB_XLBZID; }
|
|
set { _XLXLB_XLBZID = value; }
|
|
}
|
|
private string _XLXLB_DYDJID;
|
|
[ColumnMap(DbField = "XLXLB_DYDJID", CtrlName = "cbxDYDJ", Type = FieldType.CBX,
|
|
DbTitle = "电压等级", DefaultValue = "",
|
|
IsAllowNull = false, IsKey = false, Length = 20)]
|
|
public string XLXLB_DYDJID
|
|
{
|
|
get { return _XLXLB_DYDJID; }
|
|
set { _XLXLB_DYDJID = value; }
|
|
}
|
|
private string _OLD_XLXHID;
|
|
[ColumnMap(DbField = "OLD_XLXHID", CtrlName = "txtOLDXH", Type = FieldType.HiddenField, PrintVisible = false,
|
|
DbTitle = "原型号", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 20)]
|
|
public string OLD_XLXHID
|
|
{
|
|
get { return _OLD_XLXHID; }
|
|
set { _OLD_XLXHID = value; }
|
|
}
|
|
private string _OLD_XLGGID;
|
|
[ColumnMap(DbField = "OLD_XLGGID", CtrlName = "txtOLDGG", Type = FieldType.HiddenField, PrintVisible = false,
|
|
DbTitle = "原规格", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 60)]
|
|
public string OLD_XLGGID
|
|
{
|
|
get { return _OLD_XLGGID; }
|
|
set { _OLD_XLGGID = value; }
|
|
}
|
|
private string _OLD_XLBZID;
|
|
[ColumnMap(DbField = "OLD_XLBZID", CtrlName = "txtOLDBZ", Type = FieldType.HiddenField, PrintVisible = false,
|
|
DbTitle = "原标准", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 10)]
|
|
public string OLD_XLBZID
|
|
{
|
|
get { return _OLD_XLBZID; }
|
|
set { _OLD_XLBZID = value; }
|
|
}
|
|
private string _OLD_DYDJID;
|
|
[ColumnMap(DbField = "OLD_DYDJID", CtrlName = "txtOLDDYDJ", Type = FieldType.HiddenField, PrintVisible = false,
|
|
DbTitle = "原电压等级", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 20)]
|
|
public string OLD_DYDJID
|
|
{
|
|
get { return _OLD_DYDJID; }
|
|
set { _OLD_DYDJID = value; }
|
|
}
|
|
|
|
private string _XLXLB_XLYSID;
|
|
[ColumnMap(DbField = "XLXLB_XLYSID", CtrlName = "cbxXLYSID", Type = FieldType.CBX,
|
|
DbTitle = "线缆颜色ID", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 10)]
|
|
public string XLXLB_XLYSID
|
|
{
|
|
get { return _XLXLB_XLYSID; }
|
|
set { _XLXLB_XLYSID = value; }
|
|
}
|
|
|
|
private string _OLD_XLYSID;
|
|
[ColumnMap(DbField = "OLD_XLYSID", CtrlName = "txtOLDXLYSID", Type = FieldType.HiddenField, PrintVisible = false,
|
|
DbTitle = "原线缆颜色", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 10)]
|
|
public string OLD_XLYSID
|
|
{
|
|
get { return _OLD_XLYSID; }
|
|
set { _OLD_XLYSID = value; }
|
|
}
|
|
|
|
private string _XLXLB_WLID;
|
|
[ColumnMap(DbField = "XLXLB_WLID", CtrlName = "txtWLID", Type = FieldType.C,
|
|
DbTitle = "物料编码", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 20)]
|
|
public string XLXLB_WLID
|
|
{
|
|
get { return _XLXLB_WLID; }
|
|
set { _XLXLB_WLID = value; }
|
|
}
|
|
|
|
private string _OLD_WLID;
|
|
[ColumnMap(DbField = "OLD_WLID", CtrlName = "txtOLDWLID", Type = FieldType.HiddenField,
|
|
DbTitle = "物料编码", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 20)]
|
|
public string OLD_WLID
|
|
{
|
|
get { return _OLD_WLID; }
|
|
set { _OLD_WLID = value; }
|
|
}
|
|
|
|
|
|
private string _WL_MC;
|
|
[ColumnMap(DbField = "WL_MC", CtrlName = "txtWLMC", Type = FieldType.C,
|
|
DbTitle = "物料名称", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 80)]
|
|
public string WL_MC
|
|
{
|
|
get { return _WL_MC; }
|
|
set { _WL_MC = value; }
|
|
}
|
|
private string _WL_GG;
|
|
[ColumnMap(DbField = "WL_GG", CtrlName = "txtGGXH", Type = FieldType.C,
|
|
DbTitle = "规格型号", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 80)]
|
|
public string WL_GG
|
|
{
|
|
get { return _WL_GG; }
|
|
set { _WL_GG = value; }
|
|
}
|
|
private string _WL_TZ;
|
|
[ColumnMap(DbField = "WL_TZ", CtrlName = "txtTH", Type = FieldType.C,
|
|
DbTitle = "图号", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 50)]
|
|
public string WL_TZ
|
|
{
|
|
get { return _WL_TZ; }
|
|
set { _WL_TZ = value; }
|
|
}
|
|
private string _WL_CL;
|
|
[ColumnMap(DbField = "WL_CL", CtrlName = "txtCZ", Type = FieldType.C,
|
|
DbTitle = "材质", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 30)]
|
|
public string WL_CL
|
|
{
|
|
get { return _WL_CL; }
|
|
set { _WL_CL = value; }
|
|
}
|
|
private string _WL_JLDW;
|
|
[ColumnMap(DbField = "WL_JLDW", CtrlName = "txtJLDW", Type = FieldType.C,
|
|
DbTitle = "计量单位", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 8)]
|
|
public string WL_JLDW
|
|
{
|
|
get { return _WL_JLDW; }
|
|
set { _WL_JLDW = value; }
|
|
}
|
|
|
|
private string _XLXLB_WJ;
|
|
[ColumnMap(DbField = "XLXLB_WJ", CtrlName = "txtWJ", Type = FieldType.F,
|
|
DbTitle = "外径", DefaultValue = "0",
|
|
IsAllowNull = true, IsKey = false, Length = 0)]
|
|
public string XLXLB_WJ
|
|
{
|
|
get { return _XLXLB_WJ; }
|
|
set { _XLXLB_WJ = value; }
|
|
}
|
|
private string _XLXLB_ZXWQBS;
|
|
[ColumnMap(DbField = "XLXLB_ZXWQBS", CtrlName = "txtZXWQBS", Type = FieldType.F,
|
|
DbTitle = "最小弯曲倍数", DefaultValue = "0",
|
|
IsAllowNull = true, IsKey = false, Length = 0)]
|
|
public string XLXLB_ZXWQBS
|
|
{
|
|
get { return _XLXLB_ZXWQBS; }
|
|
set { _XLXLB_ZXWQBS = value; }
|
|
}
|
|
|
|
//导体结构信息
|
|
private string _XLXLB_DTJGXX;
|
|
[ColumnMap(DbField = "XLXLB_DTJGXX", CtrlName = "txtDTJGXX", Type = FieldType.C,
|
|
DbTitle = "导体结构信息", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 250)]
|
|
public string XLXLB_DTJGXX
|
|
{
|
|
get { return _XLXLB_DTJGXX; }
|
|
set { _XLXLB_DTJGXX = value; }
|
|
}
|
|
// 私有变量维护人
|
|
private string _XLXLB_WHR;
|
|
[ColumnMap(DbField = "XLXLB_WHR", CtrlName = "txtWHR", Type = FieldType.C,
|
|
DbTitle = "维护人", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 30)]
|
|
public string XLXLB_WHR
|
|
{
|
|
get { return _XLXLB_WHR; }
|
|
set { _XLXLB_WHR = value; }
|
|
}
|
|
|
|
// 私有变量维护人编码
|
|
private string _XLXLB_WHRID;
|
|
[ColumnMap(DbField = "XLXLB_WHRID", CtrlName = "txtWHRID", Type = FieldType.HiddenField,
|
|
DbTitle = "维护人工号", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 10)]
|
|
public string XLXLB_WHRID
|
|
{
|
|
get { return _XLXLB_WHRID; }
|
|
set { _XLXLB_WHRID = value; }
|
|
}
|
|
|
|
// 私有变量维护时间
|
|
private string _XLXLB_WHSJ;
|
|
[ColumnMap(DbField = "XLXLB_WHSJ", CtrlName = "datWHSJ", Type = FieldType.DT,
|
|
DbTitle = "维护时间", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 0)]
|
|
public string XLXLB_WHSJ
|
|
{
|
|
get { return _XLXLB_WHSJ; }
|
|
set { _XLXLB_WHSJ = value; }
|
|
}
|
|
#endregion
|
|
}
|
|
}
|
|
|