You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
158 lines
3.7 KiB
Plaintext
158 lines
3.7 KiB
Plaintext
using System;
|
|
using System.Collections;
|
|
using BP.DA;
|
|
using BP.En;
|
|
namespace BP.Sys
|
|
{
|
|
/// <summary>
|
|
/// 属性
|
|
/// </summary>
|
|
public class SerialAttr
|
|
{
|
|
/// <summary>
|
|
/// 属性Key
|
|
/// </summary>
|
|
public const string EnsName = "EnsName";
|
|
/// <summary>
|
|
/// 工作人员
|
|
/// </summary>
|
|
public const string CfgKey = "CfgKey";
|
|
/// <summary>
|
|
/// 序列号
|
|
/// </summary>
|
|
public const string IntVal = "IntVal";
|
|
}
|
|
/// <summary>
|
|
/// 序列号
|
|
/// </summary>
|
|
public class Serial: Entity
|
|
{
|
|
#region 基本属性
|
|
/// <summary>
|
|
/// 序列号
|
|
/// </summary>
|
|
public string IntVal
|
|
{
|
|
get
|
|
{
|
|
return this.GetValStringByKey(SerialAttr.IntVal ) ;
|
|
}
|
|
set
|
|
{
|
|
this.SetValByKey(SerialAttr.IntVal,value) ;
|
|
}
|
|
}
|
|
/// <summary>
|
|
/// 操作员ID
|
|
/// </summary>
|
|
public string CfgKey
|
|
{
|
|
get
|
|
{
|
|
return this.GetValStringByKey(SerialAttr.CfgKey ) ;
|
|
}
|
|
set
|
|
{
|
|
this.SetValByKey(SerialAttr.CfgKey,value) ;
|
|
}
|
|
}
|
|
#endregion
|
|
|
|
#region 构造方法
|
|
|
|
/// <summary>
|
|
/// 序列号
|
|
/// </summary>
|
|
public Serial()
|
|
{
|
|
}
|
|
/// <summary>
|
|
/// map
|
|
/// </summary>
|
|
public override Map EnMap
|
|
{
|
|
get
|
|
{
|
|
if (this._enMap!=null) return this._enMap;
|
|
Map map = new Map("Sys_Serial", "序列号");
|
|
map.EnType=EnType.Sys;
|
|
map.DepositaryOfEntity=Depositary.None;
|
|
map.AddTBStringPK(SerialAttr.CfgKey,"OID","CfgKey",false,true,1,100,10);
|
|
map.AddTBInt(SerialAttr.IntVal,0,"属性",true,false);
|
|
this._enMap=map;
|
|
return this._enMap;
|
|
}
|
|
}
|
|
#endregion
|
|
|
|
public int Gener(string CfgKey)
|
|
{
|
|
Paras ps = new Paras();
|
|
ps.Add("p", CfgKey);
|
|
|
|
string sql = "SELECT IntVal Sys_Serial WHERE CfgKey="+BP.Difference.SystemConfig.AppCenterDBVarStr+"p";
|
|
int val = DBAccess.RunSQLReturnValInt(sql, 0,ps);
|
|
if (val == 0)
|
|
{
|
|
sql = "INSERT INTO Sys_Serial VALUES(" + BP.Difference.SystemConfig.AppCenterDBVarStr + "p,1)";
|
|
DBAccess.RunSQLReturnVal(sql, ps);
|
|
return 1;
|
|
}
|
|
else
|
|
{
|
|
val++;
|
|
ps.Add("intV", val);
|
|
sql = "UPDATE Sys_Serial SET IntVal="+BP.Difference.SystemConfig.AppCenterDBVarStr+"intV WHERE CfgKey=" + BP.Difference.SystemConfig.AppCenterDBVarStr + "p";
|
|
DBAccess.RunSQLReturnVal(sql);
|
|
return val;
|
|
}
|
|
}
|
|
}
|
|
/// <summary>
|
|
/// 序列号s
|
|
/// </summary>
|
|
public class Serials : Entities
|
|
{
|
|
/// <summary>
|
|
/// 序列号s
|
|
/// </summary>
|
|
public Serials()
|
|
{
|
|
}
|
|
/// <summary>
|
|
/// 得到它的 Entity
|
|
/// </summary>
|
|
public override Entity GetNewEntity
|
|
{
|
|
get
|
|
{
|
|
return new Serial();
|
|
}
|
|
}
|
|
|
|
#region 为了适应自动翻译成java的需要,把实体转换成List.
|
|
/// <summary>
|
|
/// 转化成 java list,C#不能调用.
|
|
/// </summary>
|
|
/// <returns>List</returns>
|
|
public System.Collections.Generic.IList<Serial> ToJavaList()
|
|
{
|
|
return (System.Collections.Generic.IList<Serial>)this;
|
|
}
|
|
/// <summary>
|
|
/// 转化成list
|
|
/// </summary>
|
|
/// <returns>List</returns>
|
|
public System.Collections.Generic.List<Serial> Tolist()
|
|
{
|
|
System.Collections.Generic.List<Serial> list = new System.Collections.Generic.List<Serial>();
|
|
for (int i = 0; i < this.Count; i++)
|
|
{
|
|
list.Add((Serial)this[i]);
|
|
}
|
|
return list;
|
|
}
|
|
#endregion 为了适应自动翻译成java的需要,把实体转换成List.
|
|
}
|
|
}
|