/// <summary>
/// 获取审核历史明细
/// </summary>
/// <param name="userInfo">用户</param>
/// <param name="categoryId">单据分类主键</param>
/// <param name="objectId">单据主键</param>
/// <returns>数据权限</returns>
public DataTable GetAuditDetailDT(BaseUserInfo userInfo, string categoryId, string objectId)
{
DataTable dt = null;
var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod());
ServiceUtil.ProcessWorkFlowDb(userInfo, parameter, (dbHelper) =>
{
var workFlowCurrentManager = new BaseWorkFlowCurrentManager(dbHelper, userInfo);
string[] ids = workFlowCurrentManager.GetIds(new KeyValuePair <string, object>(BaseWorkFlowCurrentEntity.FieldCategoryCode, categoryId), new KeyValuePair <string, object>(BaseWorkFlowCurrentEntity.FieldObjectId, objectId));
var workFlowHistoryManager = new BaseWorkFlowHistoryManager(dbHelper, userInfo);
dt = workFlowHistoryManager.GetDataTable(BaseWorkFlowHistoryEntity.FieldCurrentFlowId, ids, BaseWorkFlowHistoryEntity.FieldCreateOn);
dt.TableName = BaseWorkFlowCurrentEntity.TableName;
});
return(dt);
}
private string AddHistory(BaseWorkFlowCurrentEntity workFlowCurrentEntity)
{
BaseWorkFlowHistoryEntity entity = new BaseWorkFlowHistoryEntity();
// 这些是待审核信息
entity.CurrentFlowId = workFlowCurrentEntity.Id;
entity.ProcessId = workFlowCurrentEntity.ProcessId;
entity.ActivityId = workFlowCurrentEntity.ActivityId;
entity.ActivityCode = workFlowCurrentEntity.ActivityCode;
entity.ActivityFullName = workFlowCurrentEntity.ActivityFullName;
entity.ToUserId = workFlowCurrentEntity.ToUserId;
entity.ToUserRealName = workFlowCurrentEntity.ToUserRealName;
entity.ToRoleId = workFlowCurrentEntity.ToRoleId;
entity.ToRoleRealName = workFlowCurrentEntity.ToRoleRealName;
if (string.IsNullOrEmpty(workFlowCurrentEntity.ToDepartmentId))
{
entity.ToDepartmentId = this.UserInfo.DepartmentId;
entity.ToDepartmentName = this.UserInfo.DepartmentName;
}
else
{
entity.ToDepartmentId = workFlowCurrentEntity.ToDepartmentId;
entity.ToDepartmentName = workFlowCurrentEntity.ToDepartmentName;
}
entity.AuditUserId = workFlowCurrentEntity.AuditUserId;
entity.AuditUserRealName = workFlowCurrentEntity.AuditUserRealName;
entity.AuditIdea = workFlowCurrentEntity.AuditIdea;
entity.AuditStatus = workFlowCurrentEntity.AuditStatus;
entity.AuditStatusName = workFlowCurrentEntity.AuditStatusName;
// 这里需要模拟产生的功能
// entity.SendDate = workFlowCurrentEntity.AuditDate;
// entity.AuditDate = DateTime.Now;
entity.SendDate = workFlowCurrentEntity.CreateOn;
entity.AuditDate = workFlowCurrentEntity.AuditDate;
entity.Description = workFlowCurrentEntity.Description;
entity.SortCode = workFlowCurrentEntity.SortCode;
entity.DeletionStateCode = workFlowCurrentEntity.DeletionStateCode;
entity.Enabled = workFlowCurrentEntity.Enabled;
BaseWorkFlowHistoryManager workFlowHistoryManager = new BaseWorkFlowHistoryManager(DbHelper, UserInfo);
return(workFlowHistoryManager.AddObject(entity));
}
/// <summary>
/// 获取审核历史明细
/// </summary>
/// <param name="userInfo">用户</param>
/// <param name="categoryId">单据分类主键</param>
/// <param name="objectId">单据主键</param>
/// <returns>数据权限</returns>
public DataTable GetAuditDetailDT(BaseUserInfo userInfo, string categoryId, string objectId)
{
// 写入调试信息
#if (DEBUG)
int milliStart = BaseBusinessLogic.StartDebug(userInfo, MethodBase.GetCurrentMethod());
#endif
// 加强安全验证防止未授权匿名调用
#if (!DEBUG)
LogOnService.UserIsLogOn(userInfo);
#endif
DataTable dataTable = null;
using (IDbHelper dbHelper = DbHelperFactory.GetHelper(BaseSystemInfo.WorkFlowDbType))
{
try
{
dbHelper.Open(WorkFlowDbConnection);
BaseWorkFlowCurrentManager workFlowCurrentManager = new BaseWorkFlowCurrentManager(dbHelper, userInfo);
string[] ids = workFlowCurrentManager.GetIds(new KeyValuePair <string, object>(BaseWorkFlowCurrentEntity.FieldCategoryCode, categoryId), new KeyValuePair <string, object>(BaseWorkFlowCurrentEntity.FieldObjectId, objectId));
BaseWorkFlowHistoryManager workFlowHistoryManager = new BaseWorkFlowHistoryManager(dbHelper, userInfo);
dataTable = workFlowHistoryManager.GetDataTable(BaseWorkFlowHistoryEntity.FieldCurrentFlowId, ids, BaseWorkFlowHistoryEntity.FieldCreateOn);
dataTable.TableName = BaseWorkFlowCurrentEntity.TableName;
BaseLogManager.Instance.Add(dbHelper, userInfo, this.serviceName, MethodBase.GetCurrentMethod());
}
catch (Exception ex)
{
BaseExceptionManager.LogException(dbHelper, userInfo, ex);
throw ex;
}
finally
{
dbHelper.Close();
}
}
// 写入调试信息
#if (DEBUG)
BaseBusinessLogic.EndDebug(MethodBase.GetCurrentMethod(), milliStart);
#endif
return(dataTable);
}
/// <summary>
/// 审核退回
/// </summary>
/// <param name="currentId">当前主键</param>
/// <param name="auditIdea">批示</param>
/// <param name="historyId">退回到第几步</param>
/// <returns>影响行数</returns>
public int AuditReject(IWorkFlowManager workFlowManager, string currentId, string auditIdea, string historyId = null)
{
int result = 0;
lock (WorkFlowCurrentLock)
{
// using (TransactionScope transactionScope = new TransactionScope())
//{
try
{
BaseWorkFlowCurrentEntity workFlowCurrentEntity = this.GetObject(currentId);
// 判断是是否是自由流（自由流这个为空）
if (workFlowCurrentEntity.ProcessId != null && workFlowCurrentEntity.ProcessId != 0)
{
// 若都已经被退回到彻底了，不能再被退回了，意思是已经退回到创建人了
if (workFlowCurrentEntity.ActivityId == null)
{
return(result);
}
}
// 只有待审核状态的，才可以退回，还需要能持续退回
if ( //workFlowCurrentEntity.AuditStatus.Equals(AuditStatus.AuditComplete.ToString()) ||
workFlowCurrentEntity.AuditStatus.Equals(AuditStatus.AuditQuash.ToString()))
{
return(result);
}
/* 彻底退回的处理
* if (activityId == null)
* {
* // 发送给当初发起这个工作流的创建者
* sendToUserId = workFlowCurrentEntity.CreateUserId;
* }
* else
* {
* BaseWorkFlowActivityManager workFlowActivityManager = new BaseWorkFlowActivityManager(this.DbHelper, this.UserInfo);
* BaseWorkFlowActivityEntity workFlowActivityEntity = workFlowActivityManager.GetObject(activityId.ToString());
* sendToUserId = workFlowActivityEntity.AuditUserId.ToString();
* }
*/
if (!string.IsNullOrEmpty(workFlowCurrentEntity.ToUserId))
{
// 若不是自己应该审核的,不应该能退回,在审核历史里需要控制一下
if (!this.UserInfo.IsAdministrator &&
(!(workFlowCurrentEntity.AuditUserId.ToString().Equals(this.UserInfo.Id) || workFlowCurrentEntity.ToUserId.ToString().Equals(this.UserInfo.Id))))
{
return(result);
}
// 一个审核者不能持续退回,但是发给自己的，还可以持续退回
if (workFlowCurrentEntity.AuditUserId.ToString().Equals(this.UserInfo.Id) &&
workFlowCurrentEntity.AuditStatus.Equals(AuditStatus.AuditReject.ToString()) &&
(!workFlowCurrentEntity.ToUserId.ToString().Equals(this.UserInfo.Id)))
{
return(result);
}
}
// 默认是自由工作流
string workFlowId = "0";
List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >();
DataTable dt = null;
BaseWorkFlowHistoryManager workFlowHistoryManager = new BaseWorkFlowHistoryManager(this.DbHelper, this.UserInfo);
string rejectToActivityId = string.Empty;
// 工作流主键
if (workFlowCurrentEntity.ProcessId != null && workFlowCurrentEntity.ProcessId != 0)
{
workFlowId = workFlowCurrentEntity.ProcessId.ToString();
BaseWorkFlowStepManager workFlowStepManager = new BaseWorkFlowStepManager(this.DbHelper, this.UserInfo);
parameters.Add(new KeyValuePair <string, object>(BaseWorkFlowStepEntity.FieldCategoryCode, workFlowCurrentEntity.CategoryCode));
parameters.Add(new KeyValuePair <string, object>(BaseWorkFlowStepEntity.FieldObjectId, workFlowCurrentEntity.ObjectId));
parameters.Add(new KeyValuePair <string, object>(BaseWorkFlowStepEntity.FieldProcessId, workFlowId));
parameters.Add(new KeyValuePair <string, object>(BaseWorkFlowStepEntity.FieldEnabled, 1));
parameters.Add(new KeyValuePair <string, object>(BaseWorkFlowStepEntity.FieldDeletionStateCode, 0));
dt = workFlowStepManager.GetDataTable(parameters, BaseWorkFlowStepEntity.FieldSortCode);
if (dt.Rows.Count > 0)
{
dt.Columns.Remove(BaseWorkFlowStepEntity.FieldId);
dt.Columns[BaseWorkFlowStepEntity.FieldActivityId].ColumnName = BaseWorkFlowStepEntity.FieldId;
}
else
{
// 判断是是否是自由流（自由流这个为空）
if (workFlowCurrentEntity.ProcessId != null && workFlowCurrentEntity.ProcessId != 0)
{
return(result);
}
}
if (!string.IsNullOrEmpty(historyId))
{
BaseWorkFlowHistoryEntity workFlowHistoryEntity = workFlowHistoryManager.GetObject(historyId);
rejectToActivityId = workFlowHistoryEntity.ActivityId.ToString();
}
else
{
// 2. 从工作流审核模板里选取审核步骤 下一步是多少？按工作流进行查找审核步骤
// 3. 下一步是多少？按工作流进行查找审核步骤
BaseWorkFlowActivityManager workFlowActivityManager = new BaseWorkFlowActivityManager(this.DbHelper, this.UserInfo);
parameters = new List <KeyValuePair <string, object> >();
parameters.Add(new KeyValuePair <string, object>(BaseWorkFlowActivityEntity.FieldProcessId, workFlowId));
parameters.Add(new KeyValuePair <string, object>(BaseWorkFlowActivityEntity.FieldEnabled, 1));
parameters.Add(new KeyValuePair <string, object>(BaseWorkFlowActivityEntity.FieldDeletionStateCode, 0));
DataTable dataTableActivity = workFlowActivityManager.GetDataTable(parameters, BaseWorkFlowActivityEntity.FieldSortCode);
if (dataTableActivity.Rows.Count > 0)
{
dt = dataTableActivity;
}
string activityId = string.Empty;
if (workFlowCurrentEntity.ActivityId != null)
{
activityId = workFlowCurrentEntity.ActivityId.ToString();
}
if (!string.IsNullOrEmpty(activityId))
{
rejectToActivityId = BaseSortLogic.GetPreviousId(dt, activityId.ToString());
}
else
{
if (dt.Rows.Count > 0)
{
rejectToActivityId = dt.Rows[0][BaseWorkFlowActivityEntity.FieldId].ToString();
}
}
if (string.IsNullOrEmpty(rejectToActivityId))
{
// 这里已经是最后一步，发出者这里了
// 已经到自己手里的，没必要再继续退回了
if (this.UserInfo.Id.Equals(workFlowCurrentEntity.CreateUserId))
{
return(result);
}
}
}
}
// 这里不应该是发给所有的人，审核过的人，才可以看到才对。
string[] userIds = workFlowHistoryManager.GetProperties(new KeyValuePair <string, object>(BaseWorkFlowCurrentEntity.FieldProcessId, workFlowCurrentEntity.ProcessId)
, BaseWorkFlowCurrentEntity.FieldAuditUserId);
userIds = StringUtil.Concat(userIds, workFlowCurrentEntity.CreateUserId);
// 进行更新操作
workFlowCurrentEntity = this.StepAuditReject(currentId, auditIdea, workFlowCurrentEntity.CreateUserId, rejectToActivityId);
if (workFlowCurrentEntity.Id != null)
{
// 5.发送提示信息
if (workFlowManager != null)
{
workFlowManager.OnAuditReject(workFlowCurrentEntity);
/*
* // 这个是表明已经彻底退回了，不是退回给指定的一个人了
* if (activityId == null)
* {
* // 已经审核过的人，都需要得到退回的信息
* BaseWorkFlowActivityManager workFlowActivityManager = new BaseWorkFlowActivityManager(this.UserInfo);
* var result = workFlowActivityManager.GetBackToDT(workFlowCurrentEntity);
* userIds = BaseBusinessLogic.FieldToArray(result, BaseWorkFlowActivityEntity.FieldAuditUserId).Distinct<string>().Where(t => !string.IsNullOrEmpty(t)).ToArray();
* }
*/
// 都给谁发送退回的消息
workFlowManager.SendRemindMessage(workFlowCurrentEntity, AuditStatus.AuditReject, userIds, workFlowCurrentEntity.ToDepartmentId, workFlowCurrentEntity.ToRoleId);
}
result = 1;
}
else
{
// 数据可能被删除
this.StatusCode = Status.ErrorDeleted.ToString();
}
// 应该给创建者一个提醒消息
this.StatusMessage = this.GetStateMessage(this.StatusCode);
}
catch (System.Exception ex)
{
// 在本地记录异常
FileUtil.WriteException(UserInfo, ex);
}
finally
{
}
// transactionScope.Complete();
// }
}
return(result);
}
