221 lines
9.2 KiB
C#
221 lines
9.2 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;
|
|
|
|
namespace GThinking.N_XLJC
|
|
{
|
|
[TableMap(DB = "DBERP", DbTableName = "XLDYDJB", Umid = 101421001, IsWorkFlow = false, IsAttach = false,
|
|
|
|
QuerySelSql = " select XLDYDJB_DYDJID, XLDYDJB_DYJLDW, "
|
|
+ " XLDYDJB_XXLXDY, XLDYDJB_XXXXDY, XLDYDJB_DYDJFL, XLDYDJB_ACDC,XLDYDJB_XH,"
|
|
+ " XLDYDJB_QYRQ, XLDYDJB_TYBZ, XLDYDJB_TYRQ, "
|
|
+ " XLDYDJB_WHR, XLDYDJB_WHRID, XLDYDJB_WHSJ from XLDYDJB where 1 = 1",
|
|
|
|
EntitySelSql = "select XLDYDJB_DYDJID,XLDYDJB_DYDJID AS OLD_XLDYDJB_DYDJID, XLDYDJB_DYJLDW, "
|
|
+ " XLDYDJB_XXLXDY, XLDYDJB_XXXXDY, XLDYDJB_DYDJFL, XLDYDJB_ACDC,XLDYDJB_XH,"
|
|
+ " XLDYDJB_QYRQ, XLDYDJB_TYBZ, XLDYDJB_TYRQ, "
|
|
+ " XLDYDJB_WHR, XLDYDJB_WHRID, XLDYDJB_WHSJ from XLDYDJB where XLDYDJB_DYDJID = :XLDYDJB_DYDJID",
|
|
|
|
InsertSql = "insert into XLDYDJB(XLDYDJB_DYDJID, XLDYDJB_DYJLDW,"
|
|
+ " XLDYDJB_XXLXDY, XLDYDJB_XXXXDY, XLDYDJB_DYDJFL, XLDYDJB_ACDC,"
|
|
+ " XLDYDJB_QYRQ, XLDYDJB_TYBZ, XLDYDJB_TYRQ, "
|
|
+ " XLDYDJB_WHR, XLDYDJB_WHRID, XLDYDJB_WHSJ) "
|
|
+ "values(:XLDYDJB_DYDJID, :XLDYDJB_DYJLDW,"
|
|
+ " :XLDYDJB_XXLXDY, :XLDYDJB_XXXXDY, :XLDYDJB_DYDJFL, :XLDYDJB_ACDC,"
|
|
+ " :XLDYDJB_QYRQ, :XLDYDJB_TYBZ, :XLDYDJB_TYRQ, "
|
|
+ " :XLDYDJB_WHR, :XLDYDJB_WHRID, :XLDYDJB_WHSJ) ",
|
|
|
|
|
|
UpdateSql = " update XLDYDJB set XLDYDJB_DYDJID=:XLDYDJB_DYDJID,"
|
|
+ " XLDYDJB_DYJLDW=:XLDYDJB_DYJLDW, XLDYDJB_XXLXDY=:XLDYDJB_XXLXDY, XLDYDJB_XXXXDY=:XLDYDJB_XXXXDY, "
|
|
+ " XLDYDJB_DYDJFL=:XLDYDJB_DYDJFL, XLDYDJB_ACDC=:XLDYDJB_ACDC, XLDYDJB_XH = :XLDYDJB_XH, XLDYDJB_QYRQ=:XLDYDJB_QYRQ, "
|
|
+ " XLDYDJB_TYBZ=:XLDYDJB_TYBZ, XLDYDJB_TYRQ=:XLDYDJB_TYRQ, XLDYDJB_WHR=:XLDYDJB_WHR,XLDYDJB_WHRID=:XLDYDJB_WHRID, XLDYDJB_WHSJ=:XLDYDJB_WHSJ "
|
|
+ " where XLDYDJB_DYDJID=:OLD_XLDYDJB_DYDJID",
|
|
|
|
DeleteSql = "delete from XLDYDJB where XLDYDJB_DYDJID=:OLD_XLDYDJB_DYDJID"
|
|
)]
|
|
|
|
|
|
public class XLDYDJ : EntityManager
|
|
{
|
|
//电压等级ID-关键字
|
|
|
|
private string _XLDYDJB_DYDJID;
|
|
[ColumnMap(DbField = "XLDYDJB_DYDJID", CtrlName = "txtDYDJID", Type = FieldType.C, DbTitle = "电压等级ID", DefaultValue = "",
|
|
IsAllowNull = false, IsKey = true, Length = 20)]
|
|
public string XLDYDJB_DYDJID
|
|
{
|
|
get { return _XLDYDJB_DYDJID; }
|
|
set { _XLDYDJB_DYDJID = value; }
|
|
}
|
|
|
|
private string _OLD_XLDYDJB_DYDJID;
|
|
[ColumnMap(DbField = "OLD_XLDYDJB_DYDJID", CtrlName = "txtOLDDYDJID", Type = FieldType.HiddenField, DbTitle = "电压等级ID", DefaultValue = "",PrintVisible=false,
|
|
IsAllowNull = true, IsKey = false, Length = 20)]
|
|
public string OLD_XLDYDJB_DYDJID
|
|
{
|
|
get { return _OLD_XLDYDJB_DYDJID; }
|
|
set { _OLD_XLDYDJB_DYDJID = value; }
|
|
}
|
|
|
|
|
|
private string _XLDYDJB_DYJLDW;
|
|
[ColumnMap(DbField = "XLDYDJB_DYJLDW", CtrlName = "cbxDYJLDW", Type = FieldType.CBX, DbTitle = "电压计量单位", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length =8 )]
|
|
public string XLDYDJB_DYJLDW
|
|
{
|
|
get { return _XLDYDJB_DYJLDW; }
|
|
set { _XLDYDJB_DYJLDW = value; }
|
|
}
|
|
|
|
|
|
private string _XLDYDJB_XXLXDY;
|
|
[ColumnMap(DbField = "XLDYDJB_XXLXDY", CtrlName = "txtXXLXDY", Type = FieldType.F, DbTitle = "相线零线电压 ", DefaultValue = "0",
|
|
IsAllowNull = true, IsKey = false, Length = 0)]
|
|
public string XLDYDJB_XXLXDY
|
|
{
|
|
get { return _XLDYDJB_XXLXDY; }
|
|
set { _XLDYDJB_XXLXDY = value; }
|
|
}
|
|
|
|
|
|
private string _XLDYDJB_XXXXDY;
|
|
[ColumnMap(DbField = "XLDYDJB_XXXXDY", CtrlName = "txtXXXXDY", Type = FieldType.F, DbTitle = "相线相线电压", DefaultValue = "0",
|
|
IsAllowNull = true, IsKey = false, Length = 0)]
|
|
public string XLDYDJB_XXXXDY
|
|
{
|
|
get { return _XLDYDJB_XXXXDY; }
|
|
set { _XLDYDJB_XXXXDY = value; }
|
|
}
|
|
|
|
|
|
private string _XLDYDJB_DYDJFL;
|
|
[ColumnMap(DbField = "XLDYDJB_DYDJFL", CtrlName = "cbxDYDJFL", Type = FieldType.CBX, DbTitle = "电压等级分类", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 10)]
|
|
public string XLDYDJB_DYDJFL
|
|
{
|
|
get { return _XLDYDJB_DYDJFL; }
|
|
set { _XLDYDJB_DYDJFL = value; }
|
|
}
|
|
|
|
private string _XLDYDJB_ACDC;
|
|
[ColumnMap(DbField = "XLDYDJB_ACDC", CtrlName = "cbxACDC", Type = FieldType.CBX, DbTitle = "ACDC", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 2)]
|
|
public string XLDYDJB_ACDC
|
|
{
|
|
get { return _XLDYDJB_ACDC; }
|
|
set { _XLDYDJB_ACDC = value; }
|
|
}
|
|
|
|
private string _XLDYDJB_XH;
|
|
[ColumnMap(DbField = "XLDYDJB_XH", CtrlName = "txtXH", Type = FieldType.F, DbTitle = "序号", DefaultValue = "0",
|
|
IsAllowNull = true, IsKey = false, Length = 0)]
|
|
public string XLDYDJB_XH
|
|
{
|
|
get { return _XLDYDJB_XH; }
|
|
set { _XLDYDJB_XH = value; }
|
|
}
|
|
|
|
private string _XLDYDJB_QYRQ;
|
|
[ColumnMap(DbField = "XLDYDJB_QYRQ", CtrlName = "datQYRQ", Type = FieldType.D, DbTitle = "启用日期", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 10)]
|
|
public string XLDYDJB_QYRQ
|
|
{
|
|
get { return _XLDYDJB_QYRQ; }
|
|
set { _XLDYDJB_QYRQ = value; }
|
|
}
|
|
|
|
private string _XLDYDJB_TYBZ;
|
|
[ColumnMap(DbField = "XLDYDJB_TYBZ", CtrlName = "chkTY", Type = FieldType.Y, DbTitle = "停用", DefaultValue = "N",
|
|
IsAllowNull = true, IsKey = false, Length = 1)]
|
|
public string XLDYDJB_TYBZ
|
|
{
|
|
get { return _XLDYDJB_TYBZ; }
|
|
set { _XLDYDJB_TYBZ = value; }
|
|
}
|
|
|
|
private string _XLDYDJB_TYRQ;
|
|
[ColumnMap(DbField = "XLDYDJB_TYRQ", CtrlName = "datTYRQ", Type = FieldType.D, DbTitle = "停用日期", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 10)]
|
|
public string XLDYDJB_TYRQ
|
|
{
|
|
get { return _XLDYDJB_TYRQ; }
|
|
set { _XLDYDJB_TYRQ = value; }
|
|
}
|
|
|
|
private string _XLDYDJB_WHR;
|
|
[ColumnMap(DbField = "XLDYDJB_WHR", CtrlName = "txtWHR", Type = FieldType.C, DbTitle = "维护人", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 30)]
|
|
public string XLDYDJB_WHR
|
|
{
|
|
get { return _XLDYDJB_WHR; }
|
|
set { _XLDYDJB_WHR = value; }
|
|
}
|
|
|
|
|
|
private string _XLDYDJB_WHRID;
|
|
[ColumnMap(DbField = "XLDYDJB_WHRID", CtrlName = "txtWHRID", Type = FieldType.HiddenField, DbTitle = "维护人工号", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 10)]
|
|
public string XLDYDJB_WHRID
|
|
{
|
|
get { return _XLDYDJB_WHRID; }
|
|
set { _XLDYDJB_WHRID = value; }
|
|
}
|
|
|
|
|
|
private string _XLDYDJB_WHSJ;
|
|
[ColumnMap(DbField = "XLDYDJB_WHSJ", CtrlName = "datWHSJ", Type = FieldType.DT, DbTitle = "维护时间", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 0)]
|
|
public string XLDYDJB_WHSJ
|
|
{
|
|
get { return _XLDYDJB_WHSJ; }
|
|
set { _XLDYDJB_WHSJ = value; }
|
|
}
|
|
|
|
public bool CanDelete(string sDYDJID)
|
|
{
|
|
TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
|
|
TSQL SQL = new TSQL(dberp);
|
|
SQL.Clear();
|
|
SQL.Add("select 1 from XLHTCLB where XLHTCLB_DYDJID =:pDYDJID ");
|
|
SQL.Add("union all ");
|
|
SQL.Add("select 1 from XLJYCLB where XLJYCLB_DYDJID =:pDYDJID ");
|
|
SQL.Add("union all ");
|
|
SQL.Add("select 1 from XLWHCLB where XLWHCLB_DYDJID =:pDYDJID ");
|
|
SQL.Add("union all ");
|
|
SQL.Add("select 1 from XLXLB where XLXLB_DYDJID =:pDYDJID ");
|
|
SQL.Add("union all ");
|
|
SQL.Add("select 1 from XLXLPL where XLXLPL_DYDJID =:pDYDJID ");
|
|
SQL.Add("union all ");
|
|
SQL.Add("select 1 from XLLXB where charindex(:pDYDJID,XLLXB_DYDJID)>0 ");
|
|
SQL.Add("union all ");
|
|
SQL.Add("select 1 from XLLXTXB where charindex(:pDYDJID,XLLXTXB_SYDYDJID)>0 ");
|
|
SQL.Add("union all ");
|
|
SQL.Add("select 1 from XLLXPL where charindex(:pDYDJID,XLLXPL_SYDYDJID)>0 ");
|
|
SQL.Add("union all ");
|
|
SQL.Add("select 1 from XLXXB where XLXXB_DYDJID =:pDYDJID ");
|
|
SQL.Add("union all ");
|
|
SQL.Add("select 1 from XLXZB where XLXZB_DYDJID =:pDYDJID ");
|
|
SQL.Add("union all ");
|
|
SQL.Add("select 1 from XLXZPL where XLXZPL_DYDJID =:pDYDJID ");
|
|
SQL.ParamByName("pDYDJID").Value = sDYDJID;
|
|
DataSet ds = dberp.OpenDataSet(SQL);
|
|
if (ds.Tables[0].Rows.Count > 0)
|
|
{
|
|
return false;
|
|
}
|
|
return true;
|
|
}
|
|
|
|
|
|
}
|
|
}
|