214 lines
10 KiB
C#
214 lines
10 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 = "XLXSBJYLZDMX", Umid = 100860097, IsWorkFlow = false, UseWhr = true,
|
|
|
|
QuerySelSql = @" select XLXSBJYLZDMX_SQDH,XLXSBJYLZDMX_XH,XLXSBJYLZDMX_BJDXH,
|
|
XLXSBJYLZDMX_BJDXLXHID,XLXSBJYLZDMX_BJDXLGGID,XLXSBJYLZDMX_BJDXLBZID,
|
|
XLXSBJYLZDMX_BJDDYDJID,XLXSBJYLZDMX_XLXHID,XLXSBJYLZDMX_XLGGID,
|
|
XLXSBJYLZDMX_XLBZID,XLXSBJYLZDMX_DYDJID,
|
|
XLXSBJYLZDMX_BZ,XLXSBJYLZDMX_WHR,XLXSBJYLZDMX_WHRID,XLXSBJYLZDMX_WHSJ,XLXSBJYLZDMX_DZSC
|
|
from XLXSBJYLZDMX
|
|
where 1=1",
|
|
|
|
|
|
EntitySelSql = @" select XLXSBJYLZDMX_SQDH,XLXSBJYLZDMX_XH,XLXSBJYLZDMX_BJDXH,
|
|
XLXSBJYLZDMX_BJDXLXHID,XLXSBJYLZDMX_BJDXLGGID,XLXSBJYLZDMX_BJDXLBZID,
|
|
XLXSBJYLZDMX_BJDDYDJID,XLXSBJYLZDMX_XLXHID,XLXSBJYLZDMX_XLGGID,
|
|
XLXSBJYLZDMX_XLBZID,XLXSBJYLZDMX_DYDJID,
|
|
XLXSBJYLZDMX_BZ,XLXSBJYLZDMX_WHR,XLXSBJYLZDMX_WHRID,XLXSBJYLZDMX_WHSJ,XLXSBJYLZDMX_DZSC
|
|
from XLXSBJYLZDMX
|
|
where XLXSBJYLZDMX_SQDH=:XLXSBJYLZDMX_SQDH and XLXSBJYLZDMX_XH=:XLXSBJYLZDMX_XH ",
|
|
|
|
|
|
|
|
UpdateSql = @" update XLXSBJYLZDMX set XLXSBJYLZDMX_BJDXLXHID=:XLXSBJYLZDMX_BJDXLXHID,
|
|
XLXSBJYLZDMX_BJDXLGGID=:XLXSBJYLZDMX_BJDXLGGID,
|
|
XLXSBJYLZDMX_BJDXLBZID=:XLXSBJYLZDMX_BJDXLBZID,
|
|
XLXSBJYLZDMX_BJDDYDJID=:XLXSBJYLZDMX_BJDDYDJID,
|
|
XLXSBJYLZDMX_XLXHID=:XLXSBJYLZDMX_XLXHID,
|
|
XLXSBJYLZDMX_XLGGID=:XLXSBJYLZDMX_XLGGID,
|
|
XLXSBJYLZDMX_XLBZID=:XLXSBJYLZDMX_XLBZID,
|
|
XLXSBJYLZDMX_DYDJID=:XLXSBJYLZDMX_DYDJID,
|
|
XLXSBJYLZDMX_BZ=:XLXSBJYLZDMX_BZ,
|
|
XLXSBJYLZDMX_WHR=:XLXSBJYLZDMX_WHR,
|
|
XLXSBJYLZDMX_WHRID=:XLXSBJYLZDMX_WHRID,
|
|
XLXSBJYLZDMX_WHSJ=:XLXSBJYLZDMX_WHSJ,
|
|
XLXSBJYLZDMX_DZSC=:XLXSBJYLZDMX_DZSC
|
|
where XLXSBJYLZDMX_SQDH=:XLXSBJYLZDMX_SQDH and XLXSBJYLZDMX_XH=:XLXSBJYLZDMX_XH ",
|
|
|
|
InsertSql = @" insert into XLXSBJYLZDMX(XLXSBJYLZDMX_SQDH,XLXSBJYLZDMX_XH,XLXSBJYLZDMX_BJDXH,
|
|
XLXSBJYLZDMX_BJDXLXHID,XLXSBJYLZDMX_BJDXLGGID,XLXSBJYLZDMX_BJDXLBZID,
|
|
XLXSBJYLZDMX_BJDDYDJID,XLXSBJYLZDMX_XLXHID,XLXSBJYLZDMX_XLGGID,
|
|
XLXSBJYLZDMX_XLBZID,XLXSBJYLZDMX_DYDJID,
|
|
XLXSBJYLZDMX_BZ,XLXSBJYLZDMX_WHR,XLXSBJYLZDMX_WHRID,XLXSBJYLZDMX_WHSJ,XLXSBJYLZDMX_DZSC)
|
|
values(:XLXSBJYLZDMX_SQDH,:XLXSBJYLZDMX_XH,:XLXSBJYLZDMX_BJDXH,
|
|
:XLXSBJYLZDMX_BJDXLXHID,:XLXSBJYLZDMX_BJDXLGGID,:XLXSBJYLZDMX_BJDXLBZID,
|
|
:XLXSBJYLZDMX_BJDDYDJID,:XLXSBJYLZDMX_XLXHID,:XLXSBJYLZDMX_XLGGID,
|
|
:XLXSBJYLZDMX_XLBZID,:XLXSBJYLZDMX_DYDJID,
|
|
:XLXSBJYLZDMX_BZ,:XLXSBJYLZDMX_WHR,:XLXSBJYLZDMX_WHRID,:XLXSBJYLZDMX_WHSJ,:XLXSBJYLZDMX_DZSC)",
|
|
|
|
DeleteSql = " delete from XLXSBJYLZDMX where XLXSBJYLZDMX_SQDH=:XLXSBJYLZDMX_SQDH and XLXSBJYLZDMX_XH=:XLXSBJYLZDMX_XH ")]
|
|
public class BJCPXD : EntityManager
|
|
{
|
|
|
|
private string _XLXSBJYLZDMX_SQDH;
|
|
[ColumnMap(DbField = "XLXSBJYLZDMX_SQDH", CtrlName = "txtSQDH", DbTitle = "申请单号", Type = FieldType.HiddenField, DefaultValue = "0000000000",
|
|
IsAllowNull = true, IsKey = true, Length = 10)]
|
|
public string XLXSBJYLZDMX_SQDH
|
|
{
|
|
get { return _XLXSBJYLZDMX_SQDH; }
|
|
set { _XLXSBJYLZDMX_SQDH = value; }
|
|
}
|
|
|
|
|
|
private string _XLXSBJYLZDMX_XH;
|
|
[ColumnMap(DbField = "XLXSBJYLZDMX_XH", CtrlName = "txtXH", DbTitle = "序号", Type = FieldType.F, DefaultValue = "0",
|
|
IsAllowNull = true, IsKey = true, Length = 8)]
|
|
public string XLXSBJYLZDMX_XH
|
|
{
|
|
get { return _XLXSBJYLZDMX_XH; }
|
|
set { _XLXSBJYLZDMX_XH = value; }
|
|
}
|
|
|
|
private string _XLXSBJYLZDMX_BJDXH;
|
|
[ColumnMap(DbField = "XLXSBJYLZDMX_BJDXH", CtrlName = "txtBJDXH", DbTitle = "报价单序号", Type = FieldType.F, DefaultValue = "0",
|
|
IsAllowNull = true, IsKey = true, Length = 8)]
|
|
public string XLXSBJYLZDMX_BJDXH
|
|
{
|
|
get { return _XLXSBJYLZDMX_BJDXH; }
|
|
set { _XLXSBJYLZDMX_BJDXH = value; }
|
|
}
|
|
|
|
private string _XLXSBJYLZDMX_BJDXLXHID;
|
|
[ColumnMap(DbField = "XLXSBJYLZDMX_BJDXLXHID", CtrlName = "cbxXLXHID", DbTitle = "型号", Type = FieldType.CBX, DefaultValue = "",
|
|
IsAllowNull = false, IsKey = false, Length = 40)]
|
|
public string XLXSBJYLZDMX_BJDXLXHID
|
|
{
|
|
get { return _XLXSBJYLZDMX_BJDXLXHID; }
|
|
set { _XLXSBJYLZDMX_BJDXLXHID = value; }
|
|
}
|
|
|
|
private string _XLXSBJYLZDMX_BJDXLGGID;
|
|
[ColumnMap(DbField = "XLXSBJYLZDMX_BJDXLGGID", CtrlName = "txtXLGGID", DbTitle = "规格", Type = FieldType.C, DefaultValue = "",
|
|
IsAllowNull = false, IsKey = false, Length = 60)]
|
|
public string XLXSBJYLZDMX_BJDXLGGID
|
|
{
|
|
get { return _XLXSBJYLZDMX_BJDXLGGID; }
|
|
set { _XLXSBJYLZDMX_BJDXLGGID = value; }
|
|
}
|
|
|
|
private string _XLXSBJYLZDMX_BJDXLBZID;
|
|
[ColumnMap(DbField = "XLXSBJYLZDMX_BJDXLBZID", CtrlName = "cbxST", DbTitle = "标准", Type = FieldType.CBX, DefaultValue = "",
|
|
IsAllowNull = false, IsKey = false, Length = 10)]
|
|
public string XLXSBJYLZDMX_BJDXLBZID
|
|
{
|
|
get { return _XLXSBJYLZDMX_BJDXLBZID; }
|
|
set { _XLXSBJYLZDMX_BJDXLBZID = value; }
|
|
}
|
|
|
|
private string _XLXSBJYLZDMX_BJDDYDJID;
|
|
[ColumnMap(DbField = "XLXSBJYLZDMX_BJDDYDJID", CtrlName = "cbxDYDJ", DbTitle = "电压等级", Type = FieldType.CBX, DefaultValue = "",
|
|
IsAllowNull = false, IsKey = false, Length = 20)]
|
|
public string XLXSBJYLZDMX_BJDDYDJID
|
|
{
|
|
get { return _XLXSBJYLZDMX_BJDDYDJID; }
|
|
set { _XLXSBJYLZDMX_BJDDYDJID = value; }
|
|
}
|
|
|
|
private string _XLXSBJYLZDMX_XLXHID;
|
|
[ColumnMap(DbField = "XLXSBJYLZDMX_XLXHID", CtrlName = "cbxXDXLXHID", DbTitle = "修订型号", Type = FieldType.CBX, DefaultValue = "",
|
|
IsAllowNull = false, IsKey = false, Length = 40)]
|
|
public string XLXSBJYLZDMX_XLXHID
|
|
{
|
|
get { return _XLXSBJYLZDMX_XLXHID; }
|
|
set { _XLXSBJYLZDMX_XLXHID = value; }
|
|
}
|
|
|
|
private string _XLXSBJYLZDMX_XLGGID;
|
|
[ColumnMap(DbField = "XLXSBJYLZDMX_XLGGID", CtrlName = "txtXDXLGGID", DbTitle = "修订规格", Type = FieldType.C, DefaultValue = "",
|
|
IsAllowNull = false, IsKey = false, Length = 60)]
|
|
public string XLXSBJYLZDMX_XLGGID
|
|
{
|
|
get { return _XLXSBJYLZDMX_XLGGID; }
|
|
set { _XLXSBJYLZDMX_XLGGID = value; }
|
|
}
|
|
|
|
private string _XLXSBJYLZDMX_XLBZID;
|
|
[ColumnMap(DbField = "XLXSBJYLZDMX_XLBZID", CtrlName = "cbxXDST", DbTitle = "修订标准", Type = FieldType.CBX, DefaultValue = "",
|
|
IsAllowNull = false, IsKey = false, Length = 10)]
|
|
public string XLXSBJYLZDMX_XLBZID
|
|
{
|
|
get { return _XLXSBJYLZDMX_XLBZID; }
|
|
set { _XLXSBJYLZDMX_XLBZID = value; }
|
|
}
|
|
|
|
private string _XLXSBJYLZDMX_DYDJID;
|
|
[ColumnMap(DbField = "XLXSBJYLZDMX_DYDJID", CtrlName = "cbxXDDYDJ", DbTitle = "修订电压等级", Type = FieldType.CBX, DefaultValue = "",
|
|
IsAllowNull = false, IsKey = false, Length = 20)]
|
|
public string XLXSBJYLZDMX_DYDJID
|
|
{
|
|
get { return _XLXSBJYLZDMX_DYDJID; }
|
|
set { _XLXSBJYLZDMX_DYDJID = value; }
|
|
}
|
|
|
|
private string _XLXSBJYLZDMX_BZ;
|
|
[ColumnMap(DbField = "XLXSBJYLZDMX_BZ", CtrlName = "txtBZ", DbTitle = "备注", Type = FieldType.C, DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 250)]
|
|
public string XLXSBJYLZDMX_BZ
|
|
{
|
|
get { return _XLXSBJYLZDMX_BZ; }
|
|
set { _XLXSBJYLZDMX_BZ = value; }
|
|
}
|
|
// 私有变量维护人
|
|
private string _XLXSBJYLZDMX_WHR;
|
|
[ColumnMap(DbField = "XLXSBJYLZDMX_WHR", CtrlName = "txtWHR", Type = FieldType.C, DbTitle = "维护人", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 30)]
|
|
public string XLXSBJYLZDMX_WHR
|
|
{
|
|
get { return _XLXSBJYLZDMX_WHR; }
|
|
set { _XLXSBJYLZDMX_WHR = value; }
|
|
}
|
|
|
|
// 私有变量维护人工号
|
|
private string _XLXSBJYLZDMX_WHRID;
|
|
[ColumnMap(DbField = "XLXSBJYLZDMX_WHRID", CtrlName = "txtWHRID", Type = FieldType.HiddenField, DbTitle = "维护人ID", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 10)]
|
|
public string XLXSBJYLZDMX_WHRID
|
|
{
|
|
get { return _XLXSBJYLZDMX_WHRID; }
|
|
set { _XLXSBJYLZDMX_WHRID = value; }
|
|
}
|
|
|
|
// 私有变量维护时间
|
|
private string _XLXSBJYLZDMX_WHSJ;
|
|
[ColumnMap(DbField = "XLXSBJYLZDMX_WHSJ", CtrlName = "datWHSJ", Type = FieldType.DT, DbTitle = "维护时间", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = true, Length = 18)]
|
|
public string XLXSBJYLZDMX_WHSJ
|
|
{
|
|
get { return _XLXSBJYLZDMX_WHSJ; }
|
|
set { _XLXSBJYLZDMX_WHSJ = value; }
|
|
}
|
|
|
|
private string _XLXSBJYLZDMX_DZSC;
|
|
[ColumnMap(DbField = "XLXSBJYLZDMX_DZSC", CtrlName = "txtDZSC", Type = FieldType.HiddenField, DbTitle = "定制生产", DefaultValue = "N",
|
|
IsAllowNull = true, IsKey = false, Length = 1)]
|
|
public string XLXSBJYLZDMX_DZSC
|
|
{
|
|
get { return _XLXSBJYLZDMX_DZSC; }
|
|
set { _XLXSBJYLZDMX_DZSC = value; }
|
|
}
|
|
|
|
}
|
|
}
|