93 lines
3.8 KiB
C#
93 lines
3.8 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_XLXSBJ
|
|
{
|
|
[TableMap(DB = "DBERP", DbTableName = "XLXHCPTXWH", Umid = 100860166, IsWorkFlow = false, UseWhr = true,
|
|
|
|
QuerySelSql = @" select XLXHCPTXWH_XLXHID,XLXHCPTXWH_XLXHFJSX,
|
|
XLXHCPTXWH_WHR,XLXHCPTXWH_WHRID,XLXHCPTXWH_WHSJ
|
|
from XLXHCPTXWH
|
|
where 1=1",
|
|
|
|
|
|
EntitySelSql = @" select XLXHCPTXWH_XLXHID,XLXHCPTXWH_XLXHFJSX,
|
|
XLXHCPTXWH_WHR,XLXHCPTXWH_WHRID,XLXHCPTXWH_WHSJ
|
|
from XLXHCPTXWH
|
|
where XLXHCPTXWH_XLXHID=:XLXHCPTXWH_XLXHID and XLXHCPTXWH_XLXHFJSX=:XLXHCPTXWH_XLXHFJSX ",
|
|
|
|
|
|
|
|
UpdateSql = @" update XLXHCPTXWH set XLXHCPTXWH_WHR=:XLXHCPTXWH_WHR,
|
|
XLXHCPTXWH_WHRID=:XLXHCPTXWH_WHRID,
|
|
XLXHCPTXWH_WHSJ=:XLXHCPTXWH_WHSJ
|
|
where XLXHCPTXWH_XLXHID=:XLXHCPTXWH_XLXHID and XLXHCPTXWH_XLXHFJSX=:XLXHCPTXWH_XLXHFJSX ",
|
|
|
|
InsertSql = @" insert into XLXHCPTXWH(XLXHCPTXWH_XLXHID,XLXHCPTXWH_XLXHFJSX,
|
|
XLXHCPTXWH_WHR,XLXHCPTXWH_WHRID,XLXHCPTXWH_WHSJ)
|
|
values(:XLXHCPTXWH_XLXHID,:XLXHCPTXWH_XLXHFJSX,
|
|
:XLXHCPTXWH_WHR,:XLXHCPTXWH_WHRID,:XLXHCPTXWH_WHSJ)",
|
|
|
|
DeleteSql = " delete from XLXHCPTXWH where XLXHCPTXWH_XLXHID=:XLXHCPTXWH_XLXHID and XLXHCPTXWH_XLXHFJSX=:XLXHCPTXWH_XLXHFJSX ")]
|
|
public class XLXHCPTXWH : EntityManager
|
|
{
|
|
|
|
private string _XLXHCPTXWH_XLXHID;
|
|
[ColumnMap(DbField = "XLXHCPTXWH_XLXHID", CtrlName = "cbxXLXHID", DbTitle = "型号", Type = FieldType.CBX, DefaultValue = "",
|
|
IsAllowNull = false, IsKey = true, Length = 40)]
|
|
public string XLXHCPTXWH_XLXHID
|
|
{
|
|
get { return _XLXHCPTXWH_XLXHID; }
|
|
set { _XLXHCPTXWH_XLXHID = value; }
|
|
}
|
|
|
|
private string _XLXHCPTXWH_XLXHFJSX;
|
|
[ColumnMap(DbField = "XLXHCPTXWH_XLXHFJSX", CtrlName = "txtXLXHFJSX", DbTitle = "附加属性", Type = FieldType.C, DefaultValue = "",
|
|
IsAllowNull = false, IsKey = true, Length = 50)]
|
|
public string XLXHCPTXWH_XLXHFJSX
|
|
{
|
|
get { return _XLXHCPTXWH_XLXHFJSX; }
|
|
set { _XLXHCPTXWH_XLXHFJSX = value; }
|
|
}
|
|
|
|
// 私有变量维护人
|
|
private string _XLXHCPTXWH_WHR;
|
|
[ColumnMap(DbField = "XLXHCPTXWH_WHR", CtrlName = "txtWHR", Type = FieldType.C, DbTitle = "维护人", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 30)]
|
|
public string XLXHCPTXWH_WHR
|
|
{
|
|
get { return _XLXHCPTXWH_WHR; }
|
|
set { _XLXHCPTXWH_WHR = value; }
|
|
}
|
|
|
|
// 私有变量维护人工号
|
|
private string _XLXHCPTXWH_WHRID;
|
|
[ColumnMap(DbField = "XLXHCPTXWH_WHRID", CtrlName = "txtWHRID", Type = FieldType.HiddenField, DbTitle = "维护人ID", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 10)]
|
|
public string XLXHCPTXWH_WHRID
|
|
{
|
|
get { return _XLXHCPTXWH_WHRID; }
|
|
set { _XLXHCPTXWH_WHRID = value; }
|
|
}
|
|
|
|
// 私有变量维护时间
|
|
private string _XLXHCPTXWH_WHSJ;
|
|
[ColumnMap(DbField = "XLXHCPTXWH_WHSJ", CtrlName = "datWHSJ", Type = FieldType.DT, DbTitle = "维护时间", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 18)]
|
|
public string XLXHCPTXWH_WHSJ
|
|
{
|
|
get { return _XLXHCPTXWH_WHSJ; }
|
|
set { _XLXHCPTXWH_WHSJ = value; }
|
|
}
|
|
|
|
}
|
|
}
|