177 lines
8.4 KiB
C#
177 lines
8.4 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;
|
|
using GThinking.N_MISPRO.Data;
|
|
using System.Collections.Generic;
|
|
using Newtonsoft.Json;
|
|
using GThinking.N_MISPROAS.Net;
|
|
using System.Text;
|
|
|
|
|
|
namespace GThinking.N_XLXSBJ
|
|
{
|
|
[TableMap(DB = "DBERP", DbTableName = "XLBJPJDWZL", Umid = 100860132, IsWorkFlow = false, UseWhr = false,
|
|
QuerySelSql = @"select XLBJPJDWZL_XLXHID , XLBJPJDWZL_DYDJID, XLBJPJDWZL_XLGGID, XLBJPJDWZL_XLBZID,
|
|
XLBJPJDWZL_PJDWZL, XLBJPJDWZL_BJCPJLDW, XLBJPJDWZL_WHR, XLBJPJDWZL_WHRID, XLBJPJDWZL_WHSJ
|
|
from XLBJPJDWZL where 1=1
|
|
order by XLBJPJDWZL_XLXHID",
|
|
|
|
EntitySelSql = @"select XLBJPJDWZL_XLXHID, XLBJPJDWZL_XLXHID as OLD_XLBJPJDWZL_XLXHID,
|
|
XLBJPJDWZL_DYDJID, XLBJPJDWZL_DYDJID as OLD_XLBJPJDWZL_DYDJID,
|
|
XLBJPJDWZL_XLGGID, XLBJPJDWZL_XLGGID as OLD_XLBJPJDWZL_XLGGID,
|
|
XLBJPJDWZL_XLBZID, XLBJPJDWZL_XLBZID as OLD_XLBJPJDWZL_XLBZID,
|
|
XLBJPJDWZL_PJDWZL, XLBJPJDWZL_BJCPJLDW, XLBJPJDWZL_WHR, XLBJPJDWZL_WHRID, XLBJPJDWZL_WHSJ
|
|
from XLBJPJDWZL
|
|
where XLBJPJDWZL_XLXHID=:OLD_XLBJPJDWZL_XLXHID
|
|
and XLBJPJDWZL_DYDJID = :OLD_XLBJPJDWZL_DYDJID
|
|
and XLBJPJDWZL_XLGGID = :OLD_XLBJPJDWZL_XLGGID
|
|
and XLBJPJDWZL_XLBZID = :OLD_XLBJPJDWZL_XLBZID",
|
|
|
|
|
|
UpdateSql = @"update XLBJPJDWZL set XLBJPJDWZL_XLXHID =:XLBJPJDWZL_XLXHID, XLBJPJDWZL_DYDJID =:XLBJPJDWZL_DYDJID,
|
|
XLBJPJDWZL_XLGGID =:XLBJPJDWZL_XLGGID, XLBJPJDWZL_XLBZID =:XLBJPJDWZL_XLBZID,
|
|
XLBJPJDWZL_PJDWZL =:XLBJPJDWZL_PJDWZL, XLBJPJDWZL_BJCPJLDW=:XLBJPJDWZL_BJCPJLDW, XLBJPJDWZL_WHR =:XLBJPJDWZL_WHR,
|
|
XLBJPJDWZL_WHRID =:XLBJPJDWZL_WHRID, XLBJPJDWZL_WHSJ =:XLBJPJDWZL_WHSJ
|
|
where XLBJPJDWZL_XLXHID =:OLD_XLBJPJDWZL_XLXHID
|
|
and XLBJPJDWZL_DYDJID = :OLD_XLBJPJDWZL_DYDJID
|
|
and XLBJPJDWZL_XLGGID = :OLD_XLBJPJDWZL_XLGGID
|
|
and XLBJPJDWZL_XLBZID = :OLD_XLBJPJDWZL_XLBZID",//OLD_U_GXWG_WGXH
|
|
|
|
InsertSql = "insert into XLBJPJDWZL " + "\r\n"
|
|
+ "(XLBJPJDWZL_XLXHID, XLBJPJDWZL_DYDJID, XLBJPJDWZL_XLGGID, XLBJPJDWZL_XLBZID, XLBJPJDWZL_PJDWZL,XLBJPJDWZL_BJCPJLDW, XLBJPJDWZL_WHR, XLBJPJDWZL_WHRID, XLBJPJDWZL_WHSJ)" + "\r\n"
|
|
+ "values" + "\r\n"
|
|
+ "(:XLBJPJDWZL_XLXHID, :XLBJPJDWZL_DYDJID, :XLBJPJDWZL_XLGGID, :XLBJPJDWZL_XLBZID, :XLBJPJDWZL_PJDWZL,:XLBJPJDWZL_BJCPJLDW ,:XLBJPJDWZL_WHR, :XLBJPJDWZL_WHRID, :XLBJPJDWZL_WHSJ)",
|
|
|
|
DeleteSql = "delete from XLBJPJDWZL where XLBJPJDWZL_XLXHID =:OLD_XLBJPJDWZL_XLXHID and XLBJPJDWZL_DYDJID = :OLD_XLBJPJDWZL_DYDJID and XLBJPJDWZL_XLGGID = :OLD_XLBJPJDWZL_XLGGID and XLBJPJDWZL_XLBZID = :OLD_XLBJPJDWZL_XLBZID")]
|
|
public class BJCPPJDWZL : EntityManager
|
|
{
|
|
#region 字段属性
|
|
|
|
private string _XLBJPJDWZL_XLXHID;//线缆型号ID
|
|
[ColumnMap(DbField = "XLBJPJDWZL_XLXHID", CtrlName = "cbxXLXHID", DbTitle = "线缆型号编码", Type = FieldType.CBX, DefaultValue = "",
|
|
IsAllowNull = false, IsKey = true, Length = 40)]
|
|
public string XLBJPJDWZL_XLXHID
|
|
{
|
|
get { return _XLBJPJDWZL_XLXHID; }
|
|
set { _XLBJPJDWZL_XLXHID = value; }
|
|
}
|
|
|
|
private string _OLD_XLBJPJDWZL_XLXHID;
|
|
[ColumnMap(DbField = "OLD_XLBJPJDWZL_XLXHID", CtrlName = "cbxoldXLXHID", DbTitle = "原线缆型号编码", Type = FieldType.HiddenField, DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 40, PrintVisible = false)]
|
|
public string OLD_XLBJPJDWZL_XLXHID
|
|
{
|
|
get { return _OLD_XLBJPJDWZL_XLXHID; }
|
|
set { _OLD_XLBJPJDWZL_XLXHID = value; }
|
|
}
|
|
//
|
|
private string _XLBJPJDWZL_DYDJID;//电压等级ID
|
|
[ColumnMap(DbField = "XLBJPJDWZL_DYDJID", CtrlName = "cbxDYDJID", DbTitle = "电压等级编码", Type = FieldType.CBX, DefaultValue = "",
|
|
IsAllowNull = false, IsKey = true, Length = 40)]
|
|
public string XLBJPJDWZL_DYDJID
|
|
{
|
|
get { return _XLBJPJDWZL_DYDJID; }
|
|
set { _XLBJPJDWZL_DYDJID = value; }
|
|
}
|
|
|
|
private string _OLD_XLBJPJDWZL_DYDJID;
|
|
[ColumnMap(DbField = "OLD_XLBJPJDWZL_DYDJID", CtrlName = "cbxoldDYDJID", DbTitle = "原电压等级编码", Type = FieldType.HiddenField, DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 40, PrintVisible = false)]
|
|
public string OLD_XLBJPJDWZL_DYDJID
|
|
{
|
|
get { return _OLD_XLBJPJDWZL_DYDJID; }
|
|
set { _OLD_XLBJPJDWZL_DYDJID = value; }
|
|
}
|
|
|
|
private string _XLBJPJDWZL_XLGGID;//线缆规格编码ID
|
|
[ColumnMap(DbField = "XLBJPJDWZL_XLGGID", CtrlName = "txtXLGGID", DbTitle = "线缆规格编码", Type = FieldType.C, DefaultValue = "",
|
|
IsAllowNull = false, IsKey = true, Length = 40)]
|
|
public string XLBJPJDWZL_XLGGID
|
|
{
|
|
get { return _XLBJPJDWZL_XLGGID; }
|
|
set { _XLBJPJDWZL_XLGGID = value; }
|
|
}
|
|
|
|
private string _OLD_XLBJPJDWZL_XLGGID;
|
|
[ColumnMap(DbField = "OLD_XLBJPJDWZL_XLGGID", CtrlName = "txtoldXLGGID", DbTitle = "原线缆规格编码", Type = FieldType.HiddenField, DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 40, PrintVisible = false)]
|
|
public string OLD_XLBJPJDWZL_XLGGID
|
|
{
|
|
get { return _OLD_XLBJPJDWZL_XLGGID; }
|
|
set { _OLD_XLBJPJDWZL_XLGGID = value; }
|
|
}
|
|
|
|
private string _XLBJPJDWZL_XLBZID;//线缆标准编码ID
|
|
[ColumnMap(DbField = "XLBJPJDWZL_XLBZID", CtrlName = "cbxXLBZID", DbTitle = "线缆标准编码", Type = FieldType.CBX, DefaultValue = "",
|
|
IsAllowNull = false, IsKey = true, Length = 40)]
|
|
public string XLBJPJDWZL_XLBZID
|
|
{
|
|
get { return _XLBJPJDWZL_XLBZID; }
|
|
set { _XLBJPJDWZL_XLBZID = value; }
|
|
}
|
|
|
|
private string _OLD_XLBJPJDWZL_XLBZID;
|
|
[ColumnMap(DbField = "OLD_XLBJPJDWZL_XLBZID", CtrlName = "cbxoldXLBZID", DbTitle = "原线缆规标准码", Type = FieldType.HiddenField, DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 40, PrintVisible = false)]
|
|
public string OLD_XLBJPJDWZL_XLBZID
|
|
{
|
|
get { return _OLD_XLBJPJDWZL_XLBZID; }
|
|
set { _OLD_XLBJPJDWZL_XLBZID = value; }
|
|
}
|
|
|
|
private string _XLBJPJDWZL_PJDWZL;
|
|
[ColumnMap(DbField = "XLBJPJDWZL_PJDWZL", CtrlName = "txtDWZL", DbTitle = "单位重量", Type = FieldType.F, DefaultValue = "0",
|
|
IsAllowNull = false, IsKey = false, Length = 8)]
|
|
public string XLBJPJDWZL_PJDWZL
|
|
{
|
|
get { return _XLBJPJDWZL_PJDWZL; }
|
|
set { _XLBJPJDWZL_PJDWZL = value; }
|
|
}
|
|
|
|
private string _XLBJPJDWZL_BJCPJLDW;
|
|
[ColumnMap(DbField = "XLBJPJDWZL_BJCPJLDW", CtrlName = "txtBJCPJLDW", DbTitle = "报价产品计量单位", Type = FieldType.C, DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 8)]
|
|
public string XLBJPJDWZL_BJCPJLDW
|
|
{
|
|
get { return _XLBJPJDWZL_BJCPJLDW; }
|
|
set { _XLBJPJDWZL_BJCPJLDW = value; }
|
|
}
|
|
|
|
private string _XLBJPJDWZL_WHR;
|
|
[ColumnMap(DbField = "XLBJPJDWZL_WHR", CtrlName = "txtWHR", DbTitle = "维护人", Type = FieldType.C, DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 30)]
|
|
public string XLBJPJDWZL_WHR
|
|
{
|
|
get { return _XLBJPJDWZL_WHR; }
|
|
set { _XLBJPJDWZL_WHR = value; }
|
|
}
|
|
|
|
private string _XLBJPJDWZL_WHRID;
|
|
[ColumnMap(DbField = "XLBJPJDWZL_WHRID", CtrlName = "txtWHRID", DbTitle = "维护人工号", Type = FieldType.HiddenField, DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 10)]
|
|
public string XLBJPJDWZL_WHRID
|
|
{
|
|
get { return _XLBJPJDWZL_WHRID; }
|
|
set { _XLBJPJDWZL_WHRID = value; }
|
|
}
|
|
|
|
private string _XLBJPJDWZL_WHSJ;
|
|
[ColumnMap(DbField = "XLBJPJDWZL_WHSJ", CtrlName = "datWHSJ", DbTitle = "维护时间", Type = FieldType.DT, DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 30)]
|
|
public string XLBJPJDWZL_WHSJ
|
|
{
|
|
get { return _XLBJPJDWZL_WHSJ; }
|
|
set { _XLBJPJDWZL_WHSJ = value; }
|
|
}
|
|
|
|
#endregion
|
|
}
|
|
}
|