272 lines
13 KiB
C#
272 lines
13 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 = "XLXSBJDYZZI", Umid = 100860149, IsWorkFlow = false, IsAttach = false, UseWhr = false,
|
|
QuerySelSql = " select XLXSBJDYZZI_JGBID, XLXSBJDYZZI_YZID,XLXSBJDYZZI_GYFLBM,XLXSBJDYZZI_DTLX,XLXSBJDYZZI_DYDJID,XLXSBJDYZZI_ZXJMSX,XLXSBJDYZZI_ZXJMXX, " + "\r\n"
|
|
+ " XLXSBJDYZZI_XHBHZF1,XLXSBJDYZZI_XHBHZF2,XLXSBJDYZZI_XHBBHZF, XLXSBJDYZZI_YZZ, XLXSBJDYZZI_WHR, XLXSBJDYZZI_WHRID, XLXSBJDYZZI_WHSJ " + "\r\n"
|
|
+ " from XLXSBJDYZZI " + "\r\n"
|
|
+ " where 1=1 ",
|
|
|
|
EntitySelSql = " select XLXSBJDYZZI_JGBID, XLXSBJDYZZI_YZID, XLXSTZYZ_JJFS, "
|
|
+ " XLXSBJDYZZI_GYFLBM, XLXSBJDYZZI_ZXJMSX, XLXSBJDYZZI_ZXJMXX, XLXSBJDYZZI_DTLX, XLXSBJDYZZI_XHBHZF1,XLXSBJDYZZI_DYDJID,XLXSBJDYZZI_XHBHZF2, "
|
|
+ "XLXSBJDYZZI_XHBBHZF, XLXSBJDYZZI_YZZ, XLXSBJDYZZI_WHR, XLXSBJDYZZI_WHRID, XLXSBJDYZZI_WHSJ "
|
|
+ " from XLXSBJDYZZI left join XLXSTZYZ on XLXSTZYZ_YZID=XLXSBJDYZZI_YZID and XLXSTZYZ_MXBH='BJD' "
|
|
+ " where XLXSBJDYZZI_JGBID =:XLXSBJDYZZI_JGBID and XLXSBJDYZZI_YZID =:XLXSBJDYZZI_YZID "
|
|
+ " and XLXSBJDYZZI_GYFLBM =:XLXSBJDYZZI_GYFLBM and XLXSBJDYZZI_DTLX =:XLXSBJDYZZI_DTLX and XLXSBJDYZZI_DYDJID =:XLXSBJDYZZI_DYDJID "
|
|
+ " and XLXSBJDYZZI_ZXJMSX=:XLXSBJDYZZI_ZXJMSX and XLXSBJDYZZI_ZXJMXX=:XLXSBJDYZZI_ZXJMXX "
|
|
+ " and XLXSBJDYZZI_XHBHZF1=:XLXSBJDYZZI_XHBHZF1 and XLXSBJDYZZI_XHBHZF2=:XLXSBJDYZZI_XHBHZF2 and XLXSBJDYZZI_XHBBHZF=:XLXSBJDYZZI_XHBBHZF",
|
|
|
|
UpdateSql = " update XLXSBJDYZZI "
|
|
+ " set XLXSBJDYZZI_JGBID =:XLXSBJDYZZI_JGBID , XLXSBJDYZZI_YZID =:XLXSBJDYZZI_YZID "
|
|
+ " , XLXSBJDYZZI_GYFLBM =:XLXSBJDYZZI_GYFLBM , XLXSBJDYZZI_DYDJID =:XLXSBJDYZZI_DYDJID , XLXSBJDYZZI_DTLX =:XLXSBJDYZZI_DTLX"
|
|
+ " , XLXSBJDYZZI_ZXJMSX=:XLXSBJDYZZI_ZXJMSX , XLXSBJDYZZI_ZXJMXX=:XLXSBJDYZZI_ZXJMXX "
|
|
+ " , XLXSBJDYZZI_XHBHZF1=:XLXSBJDYZZI_XHBHZF1 , XLXSBJDYZZI_XHBHZF2=:XLXSBJDYZZI_XHBHZF2 , XLXSBJDYZZI_XHBBHZF=:XLXSBJDYZZI_XHBBHZF,XLXSBJDYZZI_YZZ=:XLXSBJDYZZI_YZZ,"
|
|
+ " XLXSBJDYZZI_WHR=:XLXSBJDYZZI_WHR,XLXSBJDYZZI_WHRID=:XLXSBJDYZZI_WHRID,XLXSBJDYZZI_WHSJ=:XLXSBJDYZZI_WHSJ "
|
|
+ " where XLXSBJDYZZI_JGBID =:XLXSBJDYZZI_JGBID and XLXSBJDYZZI_YZID =:OLD_XLXSBJDYZZI_YZID "
|
|
+ " and XLXSBJDYZZI_GYFLBM =:OLD_XLXSBJDYZZI_GYFLBM and XLXSBJDYZZI_DTLX =:OLD_XLXSBJDYZZI_DTLX and XLXSBJDYZZI_DYDJID =:OLD_XLXSBJDYZZI_DYDJID "
|
|
+ " and XLXSBJDYZZI_ZXJMSX=:OLD_XLXSBJDYZZI_ZXJMSX and XLXSBJDYZZI_ZXJMXX=:OLD_XLXSBJDYZZI_ZXJMXX "
|
|
+ " and XLXSBJDYZZI_XHBHZF1=:OLD_XLXSBJDYZZI_XHBHZF1 and XLXSBJDYZZI_XHBHZF2=:OLD_XLXSBJDYZZI_XHBHZF2 and XLXSBJDYZZI_XHBBHZF=:OLD_XLXSBJDYZZI_XHBBHZF",
|
|
|
|
|
|
InsertSql = " select XLXSBJDYZZI_JGBID from XLXSBJDYZZI where 1 <> 1 ",
|
|
|
|
DeleteSql = " delete from XLXSBJDYZZI "
|
|
+ " where XLXSBJDYZZI_JGBID =:XLXSBJDYZZI_JGBID and XLXSBJDYZZI_YZID =:XLXSBJDYZZI_YZID "
|
|
+ " and XLXSBJDYZZI_GYFLBM =:XLXSBJDYZZI_GYFLBM and XLXSBJDYZZI_DTLX =:XLXSBJDYZZI_DTLX and XLXSBJDYZZI_DYDJID =:XLXSBJDYZZI_DYDJID"
|
|
+ " and XLXSBJDYZZI_ZXJMSX=:XLXSBJDYZZI_ZXJMSX and XLXSBJDYZZI_ZXJMXX=:XLXSBJDYZZI_ZXJMXX "
|
|
+ " and XLXSBJDYZZI_XHBHZF1=:XLXSBJDYZZI_XHBHZF1 and XLXSBJDYZZI_XHBHZF2=:XLXSBJDYZZI_XHBHZF2 and XLXSBJDYZZI_XHBBHZF=:XLXSBJDYZZI_XHBBHZF")]
|
|
|
|
public class TZYZBJI : EntityManager
|
|
{
|
|
private string _XLXSBJDYZZI_JGBID;
|
|
[ColumnMap(DbField = "XLXSBJDYZZI_JGBID", CtrlName = "txtJGBID", DbTitle = "调价表编号", Type = FieldType.HiddenField, DefaultValue = "",
|
|
IsAllowNull = false, IsKey = true, Length = 8)]
|
|
public string XLXSBJDYZZI_JGBID
|
|
{
|
|
get { return _XLXSBJDYZZI_JGBID; }
|
|
set { _XLXSBJDYZZI_JGBID = value; }
|
|
}
|
|
|
|
private string _XLXSBJDYZZI_GYFLBM;
|
|
[ColumnMap(DbField = "XLXSBJDYZZI_GYFLBM", CtrlName = "cbxGYFLBM", DbTitle = "工艺分类编码", Type = FieldType.CBX, DefaultValue = "",
|
|
IsAllowNull = true, IsKey = true, Length = 20)]
|
|
public string XLXSBJDYZZI_GYFLBM
|
|
{
|
|
get { return _XLXSBJDYZZI_GYFLBM; }
|
|
set { _XLXSBJDYZZI_GYFLBM = value; }
|
|
}
|
|
|
|
private string _OLD_XLXSBJDYZZI_GYFLBM;
|
|
[ColumnMap(DbField = "OLD_XLXSBJDYZZI_GYFLBM", CtrlName = "txtOLD_GYFLBM", DbTitle = "原工艺分类编码", Type = FieldType.HiddenField, DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 20, PrintVisible = false)]
|
|
public string OLD_XLXSBJDYZZI_GYFLBM
|
|
{
|
|
get { return _OLD_XLXSBJDYZZI_GYFLBM; }
|
|
set { _OLD_XLXSBJDYZZI_GYFLBM = value; }
|
|
}
|
|
|
|
private string _XLXSBJDYZZI_DYDJID;
|
|
[ColumnMap(DbField = "XLXSBJDYZZI_DYDJID", CtrlName = "cbxDYDJID", DbTitle = "电压等级", Type = FieldType.CBX, DefaultValue = "",
|
|
IsAllowNull = true, IsKey = true, Length = 20)]
|
|
public string XLXSBJDYZZI_DYDJID
|
|
{
|
|
get { return _XLXSBJDYZZI_DYDJID; }
|
|
set { _XLXSBJDYZZI_DYDJID = value; }
|
|
}
|
|
|
|
private string _OLD_XLXSBJDYZZI_DYDJID;
|
|
[ColumnMap(DbField = "OLD_XLXSBJDYZZI_DYDJID", CtrlName = "txtOLD_DYDJID", DbTitle = "原电压等级ID", Type = FieldType.HiddenField, DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 20, PrintVisible = false)]
|
|
public string OLD_XLXSBJDYZZI_DYDJID
|
|
{
|
|
get { return _OLD_XLXSBJDYZZI_DYDJID; }
|
|
set { _OLD_XLXSBJDYZZI_DYDJID = value; }
|
|
}
|
|
|
|
private string _XLXSBJDYZZI_DTLX;
|
|
[ColumnMap(DbField = "XLXSBJDYZZI_DTLX", CtrlName = "cbxDTLX", DbTitle = "导体类型", Type = FieldType.CBX, DefaultValue = "",
|
|
IsAllowNull = true, IsKey = true, Length = 10)]
|
|
public string XLXSBJDYZZI_DTLX
|
|
{
|
|
get { return _XLXSBJDYZZI_DTLX; }
|
|
set { _XLXSBJDYZZI_DTLX = value; }
|
|
}
|
|
|
|
private string _OLD_XLXSBJDYZZI_DTLX;
|
|
[ColumnMap(DbField = "OLD_XLXSBJDYZZI_DTLX", CtrlName = "txtOLD_DTLX", DbTitle = "原导体类型", Type = FieldType.HiddenField, DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 10, PrintVisible = false)]
|
|
public string OLD_XLXSBJDYZZI_DTLX
|
|
{
|
|
get { return _OLD_XLXSBJDYZZI_DTLX; }
|
|
set { _OLD_XLXSBJDYZZI_DTLX = value; }
|
|
}
|
|
|
|
private string _XLXSBJDYZZI_ZXJMSX;
|
|
[ColumnMap(DbField = "XLXSBJDYZZI_ZXJMSX", CtrlName = "txtZXJMSX", DbTitle = "主芯截面上限", Type = FieldType.F, DefaultValue = "0",
|
|
IsAllowNull = false, IsKey = true, Length = 0)]
|
|
public string XLXSBJDYZZI_ZXJMSX
|
|
{
|
|
get { return _XLXSBJDYZZI_ZXJMSX; }
|
|
set { _XLXSBJDYZZI_ZXJMSX = value; }
|
|
}
|
|
|
|
private string _OLD_XLXSBJDYZZI_ZXJMSX;
|
|
[ColumnMap(DbField = "OLD_XLXSBJDYZZI_ZXJMSX", CtrlName = "txtOLD_ZXJMSX", DbTitle = "原主芯截面上限", Type = FieldType.HiddenField, DefaultValue = "0",
|
|
IsAllowNull = true, IsKey = false, Length = 0)]
|
|
public string OLD_XLXSBJDYZZI_ZXJMSX
|
|
{
|
|
get { return _OLD_XLXSBJDYZZI_ZXJMSX; }
|
|
set { _OLD_XLXSBJDYZZI_ZXJMSX = value; }
|
|
}
|
|
|
|
private string _XLXSBJDYZZI_ZXJMXX;
|
|
[ColumnMap(DbField = "XLXSBJDYZZI_ZXJMXX", CtrlName = "txtZXJMXX", DbTitle = "主芯截面下限", Type = FieldType.F, DefaultValue = "0",
|
|
IsAllowNull = false, IsKey = true, Length = 0)]
|
|
public string XLXSBJDYZZI_ZXJMXX
|
|
{
|
|
get { return _XLXSBJDYZZI_ZXJMXX; }
|
|
set { _XLXSBJDYZZI_ZXJMXX = value; }
|
|
}
|
|
|
|
private string _OLD_XLXSBJDYZZI_ZXJMXX;
|
|
[ColumnMap(DbField = "OLD_XLXSBJDYZZI_ZXJMXX", CtrlName = "txtOLD_ZXJMXX", DbTitle = "原主芯截面下限", Type = FieldType.HiddenField, DefaultValue = "0",
|
|
IsAllowNull = true, IsKey = false, Length = 0)]
|
|
public string OLD_XLXSBJDYZZI_ZXJMXX
|
|
{
|
|
get { return _OLD_XLXSBJDYZZI_ZXJMXX; }
|
|
set { _OLD_XLXSBJDYZZI_ZXJMXX = value; }
|
|
}
|
|
|
|
private string _XLXSBJDYZZI_XHBHZF1;
|
|
[ColumnMap(DbField = "XLXSBJDYZZI_XHBHZF1", CtrlName = "txtXHBHZF1", DbTitle = "型号包含", Type = FieldType.C, DefaultValue = "",
|
|
IsAllowNull = true, IsKey = true, Length = 250)]
|
|
public string XLXSBJDYZZI_XHBHZF1
|
|
{
|
|
get { return _XLXSBJDYZZI_XHBHZF1; }
|
|
set { _XLXSBJDYZZI_XHBHZF1 = value; }
|
|
}
|
|
|
|
private string _OLD_XLXSBJDYZZI_XHBHZF1;
|
|
[ColumnMap(DbField = "OLD_XLXSBJDYZZI_XHBHZF1", CtrlName = "txtOLD_XHBHZF1", DbTitle = "原型号包含", Type = FieldType.HiddenField, DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 250)]
|
|
public string OLD_XLXSBJDYZZI_XHBHZF1
|
|
{
|
|
get { return _OLD_XLXSBJDYZZI_XHBHZF1; }
|
|
set { _OLD_XLXSBJDYZZI_XHBHZF1 = value; }
|
|
}
|
|
|
|
|
|
private string _XLXSBJDYZZI_XHBHZF2;
|
|
[ColumnMap(DbField = "XLXSBJDYZZI_XHBHZF2", CtrlName = "txtXHBHZF2", DbTitle = "型号包含", Type = FieldType.C, DefaultValue = "",
|
|
IsAllowNull = true, IsKey = true, Length = 250)]
|
|
public string XLXSBJDYZZI_XHBHZF2
|
|
{
|
|
get { return _XLXSBJDYZZI_XHBHZF2; }
|
|
set { _XLXSBJDYZZI_XHBHZF2 = value; }
|
|
}
|
|
|
|
private string _OLD_XLXSBJDYZZI_XHBHZF2;
|
|
[ColumnMap(DbField = "OLD_XLXSBJDYZZI_XHBHZF2", CtrlName = "txtOLD_XHBHZF2", DbTitle = "原型号包含", Type = FieldType.HiddenField, DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 250)]
|
|
public string OLD_XLXSBJDYZZI_XHBHZF2
|
|
{
|
|
get { return _OLD_XLXSBJDYZZI_XHBHZF2; }
|
|
set { _OLD_XLXSBJDYZZI_XHBHZF2 = value; }
|
|
}
|
|
|
|
private string _XLXSBJDYZZI_XHBBHZF;
|
|
[ColumnMap(DbField = "XLXSBJDYZZI_XHBBHZF", CtrlName = "txtXHBBHZF", DbTitle = "型号不包含", Type = FieldType.C, DefaultValue = "",
|
|
IsAllowNull = true, IsKey = true, Length = 250)]
|
|
public string XLXSBJDYZZI_XHBBHZF
|
|
{
|
|
get { return _XLXSBJDYZZI_XHBBHZF; }
|
|
set { _XLXSBJDYZZI_XHBBHZF = value; }
|
|
}
|
|
|
|
private string _OLD_XLXSBJDYZZI_XHBBHZF;
|
|
[ColumnMap(DbField = "OLD_XLXSBJDYZZI_XHBBHZF", CtrlName = "txtOLD_XHBBHZF", DbTitle = "原型号不包含", Type = FieldType.HiddenField, DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 250)]
|
|
public string OLD_XLXSBJDYZZI_XHBBHZF
|
|
{
|
|
get { return _OLD_XLXSBJDYZZI_XHBBHZF; }
|
|
set { _OLD_XLXSBJDYZZI_XHBBHZF = value; }
|
|
}
|
|
|
|
|
|
|
|
|
|
private string _XLXSBJDYZZI_YZID;
|
|
[ColumnMap(DbField = "XLXSBJDYZZI_YZID", CtrlName = "cbxYZID", DbTitle = "调价因子编码", Type = FieldType.CBX, DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 10)]
|
|
public string XLXSBJDYZZI_YZID
|
|
{
|
|
get { return _XLXSBJDYZZI_YZID; }
|
|
set { _XLXSBJDYZZI_YZID = value; }
|
|
}
|
|
|
|
private string _OLD_XLXSBJDYZZI_YZID;
|
|
[ColumnMap(DbField = "OLD_XLXSBJDYZZI_YZID", CtrlName = "txtOLD_YZID", DbTitle = "原调价因子编码", Type = FieldType.HiddenField, DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 10)]
|
|
public string OLD_XLXSBJDYZZI_YZID
|
|
{
|
|
get { return _OLD_XLXSBJDYZZI_YZID; }
|
|
set { _OLD_XLXSBJDYZZI_YZID = value; }
|
|
}
|
|
|
|
private string _XLXSTZYZ_JJFS;
|
|
[ColumnMap(DbField = "XLXSTZYZ_JJFS", CtrlName = "cbxJJFS", DbTitle = "调价方式", Type = FieldType.CBX, DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 2)]
|
|
public string XLXSTZYZ_JJFS
|
|
{
|
|
get { return _XLXSTZYZ_JJFS; }
|
|
set { _XLXSTZYZ_JJFS = value; }
|
|
}
|
|
|
|
private string _XLXSBJDYZZI_YZZ;
|
|
[ColumnMap(DbField = "XLXSBJDYZZI_YZZ", CtrlName = "txtYZZ", Type = FieldType.F, DbTitle = "因子值", DefaultValue = "0",
|
|
IsAllowNull = true, IsKey = false, Length = 0)]
|
|
public string XLXSBJDYZZI_YZZ
|
|
{
|
|
get { return _XLXSBJDYZZI_YZZ; }
|
|
set { _XLXSBJDYZZI_YZZ = value; }
|
|
}
|
|
|
|
private string _XLXSBJDYZZI_WHR;
|
|
[ColumnMap(DbField = "XLXSBJDYZZI_WHR", CtrlName = "txtWHR", DbTitle = "维护人", Type = FieldType.C, DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 30)]
|
|
public string XLXSBJDYZZI_WHR
|
|
{
|
|
get { return _XLXSBJDYZZI_WHR; }
|
|
set { _XLXSBJDYZZI_WHR = value; }
|
|
}
|
|
|
|
private string _XLXSBJDYZZI_WHRID;
|
|
[ColumnMap(DbField = "XLXSBJDYZZI_WHRID", CtrlName = "txtWHRID", DbTitle = "维护人工号", Type = FieldType.HiddenField, DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 10)]
|
|
public string XLXSBJDYZZI_WHRID
|
|
{
|
|
get { return _XLXSBJDYZZI_WHRID; }
|
|
set { _XLXSBJDYZZI_WHRID = value; }
|
|
}
|
|
|
|
private string _XLXSBJDYZZI_WHSJ;
|
|
[ColumnMap(DbField = "XLXSBJDYZZI_WHSJ", CtrlName = "datWHSJ", DbTitle = "维护时间", Type = FieldType.DT, DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 10)]
|
|
public string XLXSBJDYZZI_WHSJ
|
|
{
|
|
get { return _XLXSBJDYZZI_WHSJ; }
|
|
set { _XLXSBJDYZZI_WHSJ = value; }
|
|
}
|
|
}
|
|
}
|