/// <summary>
/// 根据状态获取活动实例
/// </summary>
/// <param name="processInstanceID"></param>
/// <param name="activityGUID"></param>
/// <param name="activityState"></param>
/// <param name="session"></param>
/// <returns></returns>
internal ActivityInstanceEntity GetActivityByState(int processInstanceID,
string activityGUID,
ActivityStateEnum activityState,
IDbSession session)
{
var sql = @"SELECT * FROM WfActivityInstance
WHERE ProcessInstanceID = @processInstanceID
AND ActivityGUID = @activityGUID
AND ActivityState = @state
ORDER BY ID DESC";
var instanceList = Repository.Query <ActivityInstanceEntity>(session.Connection,
sql,
new
{
processInstanceID = processInstanceID,
activityGUID = activityGUID.ToString(),
state = (short)activityState
},
session.Transaction).ToList();
if (instanceList.Count == 1)
{
return(instanceList[0]);
}
else
{
return(null);
}
}
/// <summary>
/// 根据状态获取活动实例
/// </summary>
/// <param name="processInstanceID">流程实例ID</param>
/// <param name="activityGUID">活动GUID</param>
/// <param name="activityState">活动状态</param>
/// <param name="session">会话</param>
/// <returns>活动实例</returns>
internal ActivityInstanceEntity GetActivityByState(int processInstanceID,
string activityGUID,
ActivityStateEnum activityState,
IDbSession session)
{
//activityState: 4-completed（完成）
//var sql = @"SELECT * FROM WfActivityInstance
// WHERE ProcessInstanceID = @processInstanceID
// AND ActivityGUID = @activityGUID
// AND ActivityState = @state
// ORDER BY ID DESC";
ActivityInstanceEntity entity = null;
var repository = session.GetRepository <ActivityInstanceEntity>();
var instanceList = repository.Query(
e => e.ProcessInstanceID == processInstanceID &&
e.ActivityGUID == activityGUID &&
e.ActivityState == (short)activityState)
.OrderByDescending(e => e.ID)
.ToList();
if (instanceList != null && instanceList.Count == 1)
{
entity = instanceList[0];
}
return(entity);
}
/// <summary>
/// 设置活动实例状态
/// </summary>
/// <param name="activityInstanceID"></param>
/// <param name="nodeState"></param>
/// <param name="runner"></param>
/// <param name="session"></param>
private void SetActivityState(int activityInstanceID,
ActivityStateEnum nodeState,
WfAppRunner runner,
IDbSession session)
{
var activityInstance = GetById(activityInstanceID);
activityInstance.ActivityState = (short)nodeState;
activityInstance.LastUpdatedByUserID = runner.UserID;
activityInstance.LastUpdatedByUserName = runner.UserName;
activityInstance.LastUpdatedDateTime = System.DateTime.Now;
Update(activityInstance, session);
}
/// <summary>
/// 设置活动实例状态
/// </summary>
/// <param name="activityInstanceID">活动实例ID</param>
/// <param name="nodeState">节点状态</param>
/// <param name="runner">运行者</param>
/// <param name="session">数据上下文</param>
private void SetActivityState(int activityInstanceID,
ActivityStateEnum nodeState,
WfAppRunner runner,
IDbSession session)
{
var entity = GetById(activityInstanceID);
entity.ActivityState = (short)nodeState;
entity.LastUpdatedByUserID = runner.UserID;
entity.LastUpdatedByUserName = runner.UserName;
entity.LastUpdatedDateTime = System.DateTime.Now;
session.GetRepository <ActivityInstanceEntity>().Update(entity);
session.SaveChanges();
}
internal IEnumerable <TaskViewEntity> GetProcessTasksWithState(int appInstanceID,
int processInstanceID,
ActivityStateEnum state)
{
string whereSql = @"WHERE ApplicationInstaceID=@appInstanceID
AND ProcessInstanceID=@processInstanceID
AND ActivityState=@state";
var list = Repository.Query <TaskViewEntity>(whereSql,
new
{
appInstanceID = appInstanceID,
processInstanceID = processInstanceID,
state = state
});
return(list);
}
/// <summary>
/// 设置状态为完成。
/// </summary>
public void Complete()
{
State = ActivityStateEnum.Processed;
}
/// <summary>
/// 设置状态为完成。
/// </summary>
public void Complete()
{
State = ActivityStateEnum.Processed;
}
/// <summary>
/// 设置活动实例状态
/// </summary>
/// <param name="activityInstanceID"></param>
/// <param name="nodeState"></param>
/// <param name="runner"></param>
/// <param name="session"></param>
private void SetActivityState(int activityInstanceID,
ActivityStateEnum nodeState,
string userID,
string userName,
IDbSession session)
{
var activityInstance = GetById(activityInstanceID);
activityInstance.ActivityState = (short)nodeState;
activityInstance.LastUpdatedByUserID = userID;
activityInstance.LastUpdatedByUserName = userName;
activityInstance.LastUpdatedDateTime = System.DateTime.Now;
Update(activityInstance, session);
}
/// <summary>
/// 根据状态获取活动实例
/// </summary>
/// <param name="processInstanceID"></param>
/// <param name="activityGUID"></param>
/// <param name="activityState"></param>
/// <param name="session"></param>
/// <returns></returns>
internal ActivityInstanceEntity GetActivityByState(int processInstanceID,
string activityGUID,
ActivityStateEnum activityState,
IDbSession session)
{
var sql = @"SELECT * FROM WfActivityInstance
WHERE ProcessInstanceID = @processInstanceID
AND ActivityGUID = @activityGUID
AND ActivityState = @state
ORDER BY ActivityInstanceID DESC";
var instanceList = Repository.Query<ActivityInstanceEntity>(session.Connection,
sql,
new
{
processInstanceID = processInstanceID,
activityGUID = activityGUID.ToString(),
state = (short)activityState
},
session.Transaction).ToList();
if (instanceList.Count == 1)
{
return instanceList[0];
}
else
{
return null;
}
}
internal IEnumerable<TaskViewEntity> GetProcessTasksWithState(int appInstanceID,
int processInstanceID,
ActivityStateEnum state)
{
string whereSql = @"WHERE ApplicationInstaceID=@appInstanceID
AND ProcessInstanceID=@processInstanceID
AND ActivityState=@state";
var list = Repository.Query<TaskViewEntity>(whereSql,
new
{
appInstanceID = appInstanceID,
processInstanceID = processInstanceID,
state = state
});
return list;
}