184 lines
8.5 KiB
C#
184 lines
8.5 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 GThinking.N_MISPRO.Utility;
|
|
|
|
namespace GThinking.N_XLJC
|
|
{
|
|
[TableMap(DB = "DBERP", DbTableName = "XLXHJGCZBML", Umid = 101421008, IsWorkFlow = false, IsAttach = false, UseWhr = false,
|
|
QuerySelSql = @"select XLXHJGCZBML_JGCZBID,XLXHJGCZBML_JGCZBXH,XLXHJGCZBML_XLXHID,XLXHJGCZBML_DYDJID,
|
|
XLXHJGCZBML_XLBZID,XLXHJGCZBML_XLBZBH,
|
|
XLXHJGCZBML_WHRID,XLXHJGCZBML_WHR,XLXHJGCZBML_WHSJ
|
|
from XLXHJGCZBML
|
|
where 1 = 1 order by XLXHJGCZBML_JGCZBID",
|
|
|
|
EntitySelSql = @"select XLXHJGCZBML_JGCZBID,XLXHJGCZBML_JGCZBXH,XLXHJGCZBML_XLXHID,XLXHJGCZBML_DYDJID,
|
|
XLXHJGCZBML_XLBZID,XLXHJGCZBML_XLBZBH,
|
|
XLXHJGCZBML_WHRID,XLXHJGCZBML_WHR,XLXHJGCZBML_WHSJ
|
|
from XLXHJGCZBML
|
|
where XLXHJGCZBML_JGCZBID = :XLXHJGCZBML_JGCZBID and XLXHJGCZBML_JGCZBXH=:XLXHJGCZBML_JGCZBXH",
|
|
|
|
InsertSql = @"insert into XLXHJGCZBML (XLXHJGCZBML_JGCZBID,XLXHJGCZBML_JGCZBXH,XLXHJGCZBML_XLXHID,XLXHJGCZBML_DYDJID,
|
|
XLXHJGCZBML_XLBZID,XLXHJGCZBML_XLBZBH,
|
|
XLXHJGCZBML_WHRID,XLXHJGCZBML_WHR,XLXHJGCZBML_WHSJ )
|
|
values(:XLXHJGCZBML_JGCZBID,:XLXHJGCZBML_JGCZBXH,:XLXHJGCZBML_XLXHID,:XLXHJGCZBML_DYDJID,
|
|
:XLXHJGCZBML_XLBZID,:XLXHJGCZBML_XLBZBH,
|
|
:XLXHJGCZBML_WHRID,:XLXHJGCZBML_WHR,:XLXHJGCZBML_WHSJ )",
|
|
|
|
UpdateSql = @"update XLXHJGCZBML set XLXHJGCZBML_JGCZBID=:XLXHJGCZBML_JGCZBID,XLXHJGCZBML_JGCZBXH=:XLXHJGCZBML_JGCZBXH,
|
|
XLXHJGCZBML_XLXHID=:XLXHJGCZBML_XLXHID,XLXHJGCZBML_DYDJID=:XLXHJGCZBML_DYDJID,
|
|
XLXHJGCZBML_XLBZID=:XLXHJGCZBML_XLBZID,XLXHJGCZBML_XLBZBH=:XLXHJGCZBML_XLBZBH,
|
|
XLXHJGCZBML_WHRID=:XLXHJGCZBML_WHRID,XLXHJGCZBML_WHR=:XLXHJGCZBML_WHR,XLXHJGCZBML_WHSJ=:XLXHJGCZBML_WHSJ
|
|
where XLXHJGCZBML_JGCZBID = :XLXHJGCZBML_JGCZBID and XLXHJGCZBML_JGCZBXH=:XLXHJGCZBML_JGCZBXH ",
|
|
|
|
DeleteSql = @"delete from XLXHJGCZBML where XLXHJGCZBML_JGCZBID = :XLXHJGCZBML_JGCZBID and XLXHJGCZBML_JGCZBXH=:XLXHJGCZBML_JGCZBXH")]
|
|
|
|
public class XLJGCZB_XHML : EntityManager
|
|
{
|
|
|
|
private string _XLXHJGCZBML_JGCZBID;
|
|
[ColumnMap(DbField = "XLXHJGCZBML_JGCZBID", CtrlName = "txtJGCZBID", DbTitle = "表号", Type = FieldType.HiddenField, DefaultValue = "",
|
|
IsAllowNull = false, IsKey = true, Length = 10)]
|
|
public string XLXHJGCZBML_JGCZBID
|
|
{
|
|
get { return _XLXHJGCZBML_JGCZBID; }
|
|
set { _XLXHJGCZBML_JGCZBID = value; }
|
|
}
|
|
|
|
private string _XLXHJGCZBML_JGCZBXH;
|
|
[ColumnMap(DbField = "XLXHJGCZBML_JGCZBXH", CtrlName = "txtJGCZBXH", DbTitle = "序号", Type = FieldType.F, DefaultValue = "0",
|
|
IsAllowNull = false, IsKey = false, Length = 0)]
|
|
public string XLXHJGCZBML_JGCZBXH
|
|
{
|
|
get { return _XLXHJGCZBML_JGCZBXH; }
|
|
set { _XLXHJGCZBML_JGCZBXH = value; }
|
|
}
|
|
|
|
private string _XLXHJGCZBML_XLXHID;
|
|
[ColumnMap(DbField = "XLXHJGCZBML_XLXHID", CtrlName = "cbxXLXHID", Type = FieldType.CBX, DbTitle = "线缆型号", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 40)]
|
|
public string XLXHJGCZBML_XLXHID
|
|
{
|
|
get { return _XLXHJGCZBML_XLXHID; }
|
|
set { _XLXHJGCZBML_XLXHID = value; }
|
|
}
|
|
|
|
private string _XLXHJGCZBML_DYDJID;
|
|
[ColumnMap(DbField = "XLXHJGCZBML_DYDJID", CtrlName = "cbxDYDJID", DbTitle = "电压等级", Type = FieldType.CBX, DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 20)]
|
|
public string XLXHJGCZBML_DYDJID
|
|
{
|
|
get { return _XLXHJGCZBML_DYDJID; }
|
|
set { _XLXHJGCZBML_DYDJID = value; }
|
|
}
|
|
|
|
private string _XLXHJGCZBML_XLBZID;
|
|
[ColumnMap(DbField = "XLXHJGCZBML_XLBZID", CtrlName = "cbxXLBZID", DbTitle = "线缆标准", Type = FieldType.CBX, DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 10)]
|
|
public string XLXHJGCZBML_XLBZID
|
|
{
|
|
get { return _XLXHJGCZBML_XLBZID; }
|
|
set { _XLXHJGCZBML_XLBZID = value; }
|
|
}
|
|
|
|
private string _XLXHJGCZBML_XLBZBH;
|
|
[ColumnMap(DbField = "XLXHJGCZBML_XLBZBH", CtrlName = "cbxXLBZBH", DbTitle = "线缆标准编号", Type = FieldType.CBX, DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 60)]
|
|
public string XLXHJGCZBML_XLBZBH
|
|
{
|
|
get { return _XLXHJGCZBML_XLBZBH; }
|
|
set { _XLXHJGCZBML_XLBZBH = value; }
|
|
}
|
|
|
|
private string _XLXHJGCZBML_WHR;
|
|
[ColumnMap(DbField = "XLXHJGCZBML_WHR", CtrlName = "txtWHR", Type = FieldType.C, DbTitle = "维护人", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 30)]
|
|
public string XLXHJGCZBML_WHR
|
|
{
|
|
get { return _XLXHJGCZBML_WHR; }
|
|
set { _XLXHJGCZBML_WHR = value; }
|
|
}
|
|
|
|
private string _XLXHJGCZBML_WHRID;
|
|
[ColumnMap(DbField = "XLXHJGCZBML_WHRID", CtrlName = "txtWHRID", Type = FieldType.HiddenField, DbTitle = "维护人工号", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 10, PrintVisible = false)]
|
|
public string XLXHJGCZBML_WHRID
|
|
{
|
|
get { return _XLXHJGCZBML_WHRID; }
|
|
set { _XLXHJGCZBML_WHRID = value; }
|
|
}
|
|
|
|
private string _XLXHJGCZBML_WHSJ;
|
|
[ColumnMap(DbField = "XLXHJGCZBML_WHSJ", CtrlName = "datWHSJ", Type = FieldType.DT, DbTitle = "维护时间", DefaultValue = "",
|
|
IsAllowNull = true, IsKey = false, Length = 8)]
|
|
public string XLXHJGCZBML_WHSJ
|
|
{
|
|
get { return _XLXHJGCZBML_WHSJ; }
|
|
set { _XLXHJGCZBML_WHSJ = value; }
|
|
}
|
|
|
|
|
|
public static int getNewXH(string sID)
|
|
{
|
|
TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
|
|
TSQL SQL = new TSQL(dberp);
|
|
SQL.Clear();
|
|
SQL.Add("select top 1 XLXHJGCZBML_JGCZBXH from XLXHJGCZBML ");
|
|
SQL.Add(" where XLXHJGCZBML_JGCZBID=:pID and XLXHJGCZBML_JGCZBXH<0 ");
|
|
SQL.Add(" order by XLXHJGCZBML_JGCZBXH ");
|
|
SQL.ParamByName("pID").Value = sID;
|
|
DataSet ds = dberp.OpenDataSet(SQL);
|
|
if (ds.Tables[0].Rows.Count > 0)
|
|
{
|
|
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0][0].ToString().Trim()))
|
|
{
|
|
return CMISproConvert.StrToInt(ds.Tables[0].Rows[0][0].ToString()) - 1;
|
|
}
|
|
else
|
|
{
|
|
return -1;
|
|
}
|
|
}
|
|
else
|
|
{
|
|
return -1;
|
|
}
|
|
}
|
|
|
|
//以线缆型号，电压等级，标准，工艺分类，标准编号 五个因素判断重复 ----返回 结构尺重表|结构尺重表名称【序号：XX】
|
|
public static string ReJudge(string sXLXHID, string sDYDJID, string sXLBZID, string sGYFLBM, string sXLBZBH, string sJGCZBID)
|
|
{
|
|
sGYFLBM = sGYFLBM.Equals("") ? " " : sGYFLBM;
|
|
TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
|
|
TSQL SQL = new TSQL(dberp);
|
|
SQL.Clear();
|
|
string sSQL = string.Format("select XLXHJGCZBML_JGCZBID,XLJGCZBML_JGCZBMC,ABS(XLXHJGCZBML_JGCZBXH) as XLXHJGCZBML_JGCZBXH from XLXHJGCZBML "
|
|
+ " left join XLJGCZBML on XLJGCZBML_JGCZBID = XLXHJGCZBML_JGCZBID WHERE XLXHJGCZBML_JGCZBXH < 0 "
|
|
+ " and XLXHJGCZBML_XLXHID='{0}' and XLXHJGCZBML_DYDJID = '{1}' "
|
|
+ " and XLXHJGCZBML_XLBZID='{2}' and isnull(XLJGCZBML_GYFLBM,' ') = '{3}'"
|
|
+ " and XLXHJGCZBML_XLBZBH='{4}' ", sXLXHID, sDYDJID, sXLBZID, sGYFLBM, sXLBZBH);
|
|
SQL.Add(sSQL);
|
|
DataSet dsXLXHJGCZBML = dberp.OpenDataSet(SQL);
|
|
if (dsXLXHJGCZBML.Tables[0].Rows.Count > 0)
|
|
{
|
|
return dsXLXHJGCZBML.Tables[0].Rows[0][0].ToString().Trim() + "|" + dsXLXHJGCZBML.Tables[0].Rows[0][1].ToString().Trim() + "【序号：" + dsXLXHJGCZBML.Tables[0].Rows[0][2].ToString().Trim() + "】";
|
|
}
|
|
else
|
|
{
|
|
return "";
|
|
}
|
|
}
|
|
|
|
}
|
|
|
|
|
|
}
|