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.
69 lines
2.0 KiB
Plaintext
69 lines
2.0 KiB
Plaintext
9 months ago
|
using System.Data;
|
||
|
|
using BP.DA;
|
||
|
|
using BP.En;
|
||
|
|
namespace BP.WF.DTS
|
||
|
|
{
|
||
|
|
/// <summary>
|
||
|
|
/// 升级ccflow6 要执行的调度
|
||
|
|
/// </summary>
|
||
|
|
public class UpTrack : Method
|
||
|
|
{
|
||
|
|
/// <summary>
|
||
|
|
/// 不带有参数的方法
|
||
|
|
/// </summary>
|
||
|
|
public UpTrack()
|
||
|
|
{
|
||
|
|
this.Title = "升级ccflow6要执行的调度(仅仅处理了wf_track部分,不可反复执行.)";
|
||
|
|
this.Help = "执行此过程把ccflow4 升级到ccflow6 此过程仅解决wf_track表的问题.";
|
||
|
|
}
|
||
|
|
/// <summary>
|
||
|
|
/// 设置执行变量
|
||
|
|
/// </summary>
|
||
|
|
/// <returns></returns>
|
||
|
|
public override void Init()
|
||
|
|
{
|
||
|
|
}
|
||
|
|
/// <summary>
|
||
|
|
/// 当前的操纵员是否可以执行这个方法
|
||
|
|
/// </summary>
|
||
|
|
public override bool IsCanDo
|
||
|
|
{
|
||
|
|
get
|
||
|
|
{
|
||
|
|
if (BP.Web.WebUser.No.Equals("admin")==true)
|
||
|
|
return true;
|
||
|
|
else
|
||
|
|
return false;
|
||
|
|
}
|
||
|
|
}
|
||
|
|
/// <summary>
|
||
|
|
/// 执行
|
||
|
|
/// </summary>
|
||
|
|
/// <returns>返回执行结果</returns>
|
||
|
|
public override object Do()
|
||
|
|
{
|
||
|
|
Flows fls = new Flows();
|
||
|
|
fls.RetrieveAllFromDBSource();
|
||
|
|
|
||
|
|
string info = "";
|
||
|
|
foreach (Flow fl in fls)
|
||
|
|
{
|
||
|
|
// 检查报表.
|
||
|
|
Track.CreateOrRepairTrackTable(fl.No);
|
||
|
|
|
||
|
|
// 查询.
|
||
|
|
string sql = "SELECT * FROM WF_Track WHERE FK_Flow='" + fl.No + "'";
|
||
|
|
DataTable dt = DBAccess.RunSQLReturnTable(sql);
|
||
|
|
for (int i = 0; i < dt.Rows.Count; i++)
|
||
|
|
{
|
||
|
|
Track tk = new Track();
|
||
|
|
tk.FK_Flow = fl.No;
|
||
|
|
tk.Row.LoadDataTable(dt, dt.Rows[0]);
|
||
|
|
tk.DoInsert(0); // 执行insert.
|
||
|
|
}
|
||
|
|
}
|
||
|
|
return "执行完成，您不能在执行它了，否则就会出现重复的轨迹数据。";
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|