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.
383 lines
11 KiB
Plaintext
383 lines
11 KiB
Plaintext
9 months ago
|
using System;
|
||
|
|
using System.Collections;
|
||
|
|
using System.Data;
|
||
|
|
using BP.DA;
|
||
|
|
using BP.En;
|
||
|
|
using BP.Web;
|
||
|
|
using Newtonsoft.Json;
|
||
|
|
|
||
|
|
namespace BP.Sys
|
||
|
|
{
|
||
|
|
/// <summary>
|
||
|
|
/// 实体版本号属性
|
||
|
|
/// </summary>
|
||
|
|
public class EnVerAttr : EntityMyPKAttr
|
||
|
|
{
|
||
|
|
/// <summary>
|
||
|
|
/// 实体类
|
||
|
|
/// </summary>
|
||
|
|
public const string FrmID = "FrmID";
|
||
|
|
/// <summary>
|
||
|
|
/// 关联主键
|
||
|
|
/// </summary>
|
||
|
|
public const string RefPK = "RefPK";
|
||
|
|
/// <summary>
|
||
|
|
/// 实体类名称
|
||
|
|
/// </summary>
|
||
|
|
public const string Name = "Name";
|
||
|
|
/// <summary>
|
||
|
|
/// 主键值
|
||
|
|
/// </summary>
|
||
|
|
public const string PKValue = "PKValue";
|
||
|
|
/// <summary>
|
||
|
|
/// 版本号
|
||
|
|
/// </summary>
|
||
|
|
public const string EnVer = "EnVer";
|
||
|
|
/// <summary>
|
||
|
|
/// 说明
|
||
|
|
/// </summary>
|
||
|
|
public const string MyNote = "MyNote";
|
||
|
|
/// <summary>
|
||
|
|
/// 记录人
|
||
|
|
/// </summary>
|
||
|
|
public const string RecNo = "RecNo";
|
||
|
|
/// <summary>
|
||
|
|
/// 记录人名字
|
||
|
|
/// </summary>
|
||
|
|
public const string RecName = "RecName";
|
||
|
|
/// <summary>
|
||
|
|
/// 记录日期
|
||
|
|
/// </summary>
|
||
|
|
public const string RDT = "RDT";
|
||
|
|
|
||
|
|
public const string EnPKValue = "EnPKValue";
|
||
|
|
/// <summary>
|
||
|
|
/// DBJSON
|
||
|
|
/// </summary>
|
||
|
|
public const string DBJSON = "DBJSON";
|
||
|
|
}
|
||
|
|
/// <summary>
|
||
|
|
/// 实体版本号
|
||
|
|
/// </summary>
|
||
|
|
public class EnVer : EntityMyPK
|
||
|
|
{
|
||
|
|
#region 方法.
|
||
|
|
/// <summary>
|
||
|
|
/// 创建新版本
|
||
|
|
/// </summary>
|
||
|
|
/// <returns></returns>
|
||
|
|
public static string NewVer(Entity myen)
|
||
|
|
{
|
||
|
|
string frmID = myen.ToString();
|
||
|
|
string frmName = myen.EnDesc;
|
||
|
|
string pkval = myen.PKVal.ToString();
|
||
|
|
// 获得最大的版本号.
|
||
|
|
int maxVer = DBAccess.RunSQLReturnValInt("SELECT MAX(EnVer) as Num FROM Sys_EnVer WHERE FrmID='" + frmID + "' AND EnPKValue='" + pkval + "'", 0);
|
||
|
|
//最大版本号>1,存在历史版本，获取上一个版本的数据
|
||
|
|
string oldStr = "";
|
||
|
|
EnVer oldVer = null;
|
||
|
|
if (maxVer >0)
|
||
|
|
{
|
||
|
|
string mypk = frmID + "_" + pkval + "_" + (maxVer);
|
||
|
|
oldVer = new EnVer();
|
||
|
|
oldVer.MyPK = mypk;
|
||
|
|
if (oldVer.RetrieveFromDBSources() != 0)
|
||
|
|
{
|
||
|
|
oldStr = DBAccess.GetBigTextFromDB("Sys_EnVer", "MyPK", mypk, EnVerAttr.DBJSON);
|
||
|
|
}
|
||
|
|
if (oldStr.Equals(myen.ToJson()))
|
||
|
|
return "";
|
||
|
|
}
|
||
|
|
//创建实体.
|
||
|
|
EnVer ev = new EnVer();
|
||
|
|
|
||
|
|
ev.RecNo = WebUser.No;
|
||
|
|
ev.RecName = WebUser.Name;
|
||
|
|
ev.RDT = DataType.CurrentDateTime;
|
||
|
|
ev.FrmID = frmID;
|
||
|
|
ev.EnPKValue = pkval;
|
||
|
|
ev.MyNote = "";
|
||
|
|
ev.Name = frmName;
|
||
|
|
|
||
|
|
|
||
|
|
ev.Ver = maxVer + 1; //设置版本号.
|
||
|
|
ev.MyPK= ev.FrmID + "_"+ ev.EnPKValue + "_"+ ev.Ver;
|
||
|
|
ev.Insert(); //执行插入.
|
||
|
|
//存储数据JSON
|
||
|
|
DBAccess.SaveBigTextToDB(myen.ToJson(), "Sys_EnVer", "MyPK", ev.MyPK, EnVerAttr.DBJSON);
|
||
|
|
|
||
|
|
return "版本创建成功.";
|
||
|
|
}
|
||
|
|
#endregion 方法.
|
||
|
|
|
||
|
|
#region 属性
|
||
|
|
public string DBJSON
|
||
|
|
{
|
||
|
|
get
|
||
|
|
{
|
||
|
|
return this.GetValStrByKey(EnVerAttr.DBJSON);
|
||
|
|
}
|
||
|
|
set
|
||
|
|
{
|
||
|
|
this.SetValByKey(EnVerAttr.DBJSON, value);
|
||
|
|
}
|
||
|
|
}
|
||
|
|
/// <summary>
|
||
|
|
/// 实体类名称
|
||
|
|
/// </summary>
|
||
|
|
public string Name
|
||
|
|
{
|
||
|
|
get
|
||
|
|
{
|
||
|
|
return this.GetValStrByKey(EnVerAttr.Name);
|
||
|
|
}
|
||
|
|
set
|
||
|
|
{
|
||
|
|
this.SetValByKey(EnVerAttr.Name, value);
|
||
|
|
}
|
||
|
|
}
|
||
|
|
public string EnPKValue
|
||
|
|
{
|
||
|
|
get
|
||
|
|
{
|
||
|
|
return this.GetValStrByKey(EnVerAttr.EnPKValue);
|
||
|
|
}
|
||
|
|
set
|
||
|
|
{
|
||
|
|
this.SetValByKey(EnVerAttr.EnPKValue, value);
|
||
|
|
}
|
||
|
|
}
|
||
|
|
/// <summary>
|
||
|
|
/// 版本号
|
||
|
|
/// </summary>
|
||
|
|
public int Ver
|
||
|
|
{
|
||
|
|
get
|
||
|
|
{
|
||
|
|
return this.GetValIntByKey(EnVerAttr.EnVer);
|
||
|
|
}
|
||
|
|
set
|
||
|
|
{
|
||
|
|
this.SetValByKey(EnVerAttr.EnVer, value);
|
||
|
|
}
|
||
|
|
}
|
||
|
|
/// <summary>
|
||
|
|
/// 修改人
|
||
|
|
/// </summary>
|
||
|
|
public string RecNo
|
||
|
|
{
|
||
|
|
get
|
||
|
|
{
|
||
|
|
return this.GetValStrByKey(EnVerAttr.RecNo);
|
||
|
|
}
|
||
|
|
set
|
||
|
|
{
|
||
|
|
this.SetValByKey(EnVerAttr.RecNo, value);
|
||
|
|
}
|
||
|
|
}
|
||
|
|
public string RecName
|
||
|
|
{
|
||
|
|
get
|
||
|
|
{
|
||
|
|
return this.GetValStrByKey(EnVerAttr.RecName);
|
||
|
|
}
|
||
|
|
set
|
||
|
|
{
|
||
|
|
this.SetValByKey(EnVerAttr.RecName, value);
|
||
|
|
}
|
||
|
|
}
|
||
|
|
public string MyNote
|
||
|
|
{
|
||
|
|
get
|
||
|
|
{
|
||
|
|
return this.GetValStrByKey(EnVerAttr.MyNote);
|
||
|
|
}
|
||
|
|
set
|
||
|
|
{
|
||
|
|
this.SetValByKey(EnVerAttr.MyNote, value);
|
||
|
|
}
|
||
|
|
}
|
||
|
|
public string FrmID
|
||
|
|
{
|
||
|
|
get
|
||
|
|
{
|
||
|
|
return this.GetValStrByKey(EnVerAttr.FrmID);
|
||
|
|
}
|
||
|
|
set
|
||
|
|
{
|
||
|
|
this.SetValByKey(EnVerAttr.FrmID, value);
|
||
|
|
}
|
||
|
|
}
|
||
|
|
/// <summary>
|
||
|
|
/// 修改日期
|
||
|
|
/// </summary>
|
||
|
|
public string RDT
|
||
|
|
{
|
||
|
|
get
|
||
|
|
{
|
||
|
|
return this.GetValStrByKey(EnVerAttr.RDT);
|
||
|
|
}
|
||
|
|
set
|
||
|
|
{
|
||
|
|
this.SetValByKey(EnVerAttr.RDT, value);
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
/// <summary>
|
||
|
|
/// 主键值
|
||
|
|
/// </summary>
|
||
|
|
public string PKValue
|
||
|
|
{
|
||
|
|
get
|
||
|
|
{
|
||
|
|
return this.GetValStrByKey(EnVerAttr.PKValue);
|
||
|
|
}
|
||
|
|
set
|
||
|
|
{
|
||
|
|
this.SetValByKey(EnVerAttr.PKValue, value);
|
||
|
|
}
|
||
|
|
}
|
||
|
|
#endregion
|
||
|
|
|
||
|
|
#region 构造函数
|
||
|
|
/// <summary>
|
||
|
|
/// 实体版本号
|
||
|
|
/// </summary>
|
||
|
|
public EnVer() { }
|
||
|
|
public EnVer(string mypk)
|
||
|
|
{
|
||
|
|
this.setMyPK(mypk);
|
||
|
|
this.Retrieve();
|
||
|
|
}
|
||
|
|
|
||
|
|
#endregion
|
||
|
|
|
||
|
|
#region 重写方法
|
||
|
|
public override UAC HisUAC
|
||
|
|
{
|
||
|
|
get
|
||
|
|
{
|
||
|
|
UAC uac = new UAC();
|
||
|
|
uac.OpenForSysAdmin();
|
||
|
|
uac.IsDelete = false;
|
||
|
|
uac.IsInsert = false;
|
||
|
|
uac.IsUpdate = false;
|
||
|
|
return uac;
|
||
|
|
}
|
||
|
|
}
|
||
|
|
/// <summary>
|
||
|
|
/// Map
|
||
|
|
/// </summary>
|
||
|
|
public override Map EnMap
|
||
|
|
{
|
||
|
|
get
|
||
|
|
{
|
||
|
|
if (this._enMap != null)
|
||
|
|
return this._enMap;
|
||
|
|
|
||
|
|
Map map = new Map("Sys_EnVer", "实体版本号");
|
||
|
|
map.EnDBUrl = new DBUrl(DBUrlType.AppCenterDSN); //连接到的那个数据库上. (默认的是: AppCenterDSN )
|
||
|
|
|
||
|
|
map.AddMyPK();
|
||
|
|
|
||
|
|
map.AddTBString(EnVerAttr.FrmID, null, "实体类", true, true, 1, 50, 20, true);
|
||
|
|
map.AddTBString(EnVerAttr.Name, null, "实体名", true, true, 0, 100, 30, true);
|
||
|
|
|
||
|
|
map.AddTBString(EnVerAttr.EnPKValue, null, "主键值", true, true, 0, 40, 100);
|
||
|
|
map.AddTBInt(EnVerAttr.EnVer, 0, "版本号", true, true);
|
||
|
|
|
||
|
|
map.AddTBString(EnVerAttr.RecNo, null, "修改人账号", true, true, 0, 100, 30);
|
||
|
|
map.AddTBString(EnVerAttr.RecName, null, "修改人名称", true, true, 0, 100, 30);
|
||
|
|
|
||
|
|
//需要存储二进制文件.
|
||
|
|
//map.AddTBString(EnVerAttr.DBJSON, null, "数据JSON", true, true, 0, 4000, 30);
|
||
|
|
|
||
|
|
map.AddTBString(EnVerAttr.MyNote, null, "备注", true, true, 0, 100, 30);
|
||
|
|
|
||
|
|
map.AddTBDateTime(EnVerAttr.RDT, null, "创建日期", true, true);
|
||
|
|
|
||
|
|
RefMethod rm = new RefMethod();
|
||
|
|
rm.Title = "快照";
|
||
|
|
rm.ClassMethodName = this.ToString() + ".ShowVer";
|
||
|
|
rm.RefMethodType = RefMethodType.RightFrameOpen;
|
||
|
|
map.AddRefMethod(rm);
|
||
|
|
|
||
|
|
//数据.
|
||
|
|
map.AddDtl(new EnVerDtls(), EnVerAttr.RefPK, null, DtlEditerModel.DtlSearch, null);
|
||
|
|
|
||
|
|
map.DTSearchKey = "RDT";
|
||
|
|
map.DTSearchWay = DTSearchWay.ByDateTime;
|
||
|
|
map.DTSearchLabel = "日期";
|
||
|
|
|
||
|
|
this._enMap = map;
|
||
|
|
|
||
|
|
return this._enMap;
|
||
|
|
}
|
||
|
|
}
|
||
|
|
#endregion
|
||
|
|
|
||
|
|
public string ShowVer()
|
||
|
|
{
|
||
|
|
return "/WF/CCBill/OptComponents/DataVer.htm?FrmID=" + this.FrmID + "&WorkID=" + this.EnPKValue;
|
||
|
|
}
|
||
|
|
|
||
|
|
protected override bool beforeInsert()
|
||
|
|
{
|
||
|
|
return base.beforeInsert();
|
||
|
|
}
|
||
|
|
protected override void afterDelete()
|
||
|
|
{
|
||
|
|
//删除数据.
|
||
|
|
EnVerDtls dtls = new EnVerDtls();
|
||
|
|
dtls.Delete(EnVerDtlAttr.RefPK, this.MyPK);
|
||
|
|
base.afterDelete();
|
||
|
|
}
|
||
|
|
}
|
||
|
|
/// <summary>
|
||
|
|
///实体版本号s
|
||
|
|
/// </summary>
|
||
|
|
public class EnVers : EntitiesMyPK
|
||
|
|
{
|
||
|
|
/// <summary>
|
||
|
|
/// 得到一个新实体
|
||
|
|
/// </summary>
|
||
|
|
public override Entity GetNewEntity
|
||
|
|
{
|
||
|
|
get
|
||
|
|
{
|
||
|
|
return new EnVer();
|
||
|
|
}
|
||
|
|
}
|
||
|
|
/// <summary>
|
||
|
|
/// 实体版本号集合
|
||
|
|
/// </summary>
|
||
|
|
public EnVers()
|
||
|
|
{
|
||
|
|
}
|
||
|
|
|
||
|
|
#region 为了适应自动翻译成java的需要,把实体转换成List.
|
||
|
|
/// <summary>
|
||
|
|
/// 转化成 java list,C#不能调用.
|
||
|
|
/// </summary>
|
||
|
|
/// <returns>List</returns>
|
||
|
|
public System.Collections.Generic.IList<EnVer> ToJavaList()
|
||
|
|
{
|
||
|
|
return (System.Collections.Generic.IList<EnVer>)this;
|
||
|
|
}
|
||
|
|
/// <summary>
|
||
|
|
/// 转化成list
|
||
|
|
/// </summary>
|
||
|
|
/// <returns>List</returns>
|
||
|
|
public System.Collections.Generic.List<EnVer> Tolist()
|
||
|
|
{
|
||
|
|
System.Collections.Generic.List<EnVer> list = new System.Collections.Generic.List<EnVer>();
|
||
|
|
for (int i = 0; i < this.Count; i++)
|
||
|
|
{
|
||
|
|
list.Add((EnVer)this[i]);
|
||
|
|
}
|
||
|
|
return list;
|
||
|
|
}
|
||
|
|
#endregion 为了适应自动翻译成java的需要,把实体转换成List.
|
||
|
|
}
|
||
|
|
}
|