private string AddHistory(BaseWorkFlowCurrentEntity workFlowCurrentEntity) { BaseWorkFlowHistoryEntity workFlowHistoryEntity = new BaseWorkFlowHistoryEntity(); // 这些是待审核信息 workFlowHistoryEntity.CurrentFlowId = workFlowCurrentEntity.Id; workFlowHistoryEntity.WorkFlowId = workFlowCurrentEntity.WorkFlowId; workFlowHistoryEntity.ActivityId = workFlowCurrentEntity.ActivityId; workFlowHistoryEntity.ActivityFullName = workFlowCurrentEntity.ActivityFullName; workFlowHistoryEntity.ToUserId = workFlowCurrentEntity.ToUserId; workFlowHistoryEntity.ToUserRealName = workFlowCurrentEntity.ToUserRealName; workFlowHistoryEntity.ToRoleId = workFlowCurrentEntity.ToRoleId; workFlowHistoryEntity.ToRoleRealName = workFlowCurrentEntity.ToRoleRealName; if (string.IsNullOrEmpty(workFlowCurrentEntity.ToDepartmentId)) { workFlowHistoryEntity.ToDepartmentId = this.UserInfo.DepartmentId; workFlowHistoryEntity.ToDepartmentName = this.UserInfo.DepartmentName; } else { workFlowHistoryEntity.ToDepartmentId = workFlowCurrentEntity.ToDepartmentId; workFlowHistoryEntity.ToDepartmentName = workFlowCurrentEntity.ToDepartmentName; } workFlowHistoryEntity.AuditUserId = workFlowCurrentEntity.AuditUserId; workFlowHistoryEntity.AuditUserRealName = workFlowCurrentEntity.AuditUserRealName; workFlowHistoryEntity.AuditIdea = workFlowCurrentEntity.AuditIdea; workFlowHistoryEntity.AuditStatus = workFlowCurrentEntity.AuditStatus; workFlowHistoryEntity.AuditStatusName = workFlowCurrentEntity.AuditStatusName; workFlowHistoryEntity.SendDate = workFlowCurrentEntity.AuditDate; workFlowHistoryEntity.AuditDate = DateTime.Now; workFlowHistoryEntity.Description = workFlowCurrentEntity.Description; workFlowHistoryEntity.SortCode = workFlowCurrentEntity.SortCode; workFlowHistoryEntity.DeletionStateCode = workFlowCurrentEntity.DeletionStateCode; workFlowHistoryEntity.Enabled = workFlowCurrentEntity.Enabled; BaseWorkFlowHistoryManager workFlowHistoryManager = new BaseWorkFlowHistoryManager(DbHelper, UserInfo); return(workFlowHistoryManager.AddEntity(workFlowHistoryEntity)); }
private string AddHistory(BaseWorkFlowCurrentEntity workFlowCurrentEntity) { BaseWorkFlowHistoryEntity workFlowHistoryEntity = new BaseWorkFlowHistoryEntity(); // 这些是待审核信息 workFlowHistoryEntity.CurrentFlowId = workFlowCurrentEntity.Id; workFlowHistoryEntity.WorkFlowId = workFlowCurrentEntity.WorkFlowId; workFlowHistoryEntity.ActivityId = workFlowCurrentEntity.ActivityId; workFlowHistoryEntity.ActivityFullName = workFlowCurrentEntity.ActivityFullName; workFlowHistoryEntity.ToUserId = workFlowCurrentEntity.ToUserId; workFlowHistoryEntity.ToUserRealName = workFlowCurrentEntity.ToUserRealName; workFlowHistoryEntity.ToRoleId = workFlowCurrentEntity.ToRoleId; workFlowHistoryEntity.ToRoleRealName = workFlowCurrentEntity.ToRoleRealName; if (string.IsNullOrEmpty(workFlowCurrentEntity.ToDepartmentId)) { workFlowHistoryEntity.ToDepartmentId = this.UserInfo.DepartmentId; workFlowHistoryEntity.ToDepartmentName = this.UserInfo.DepartmentName; } else { workFlowHistoryEntity.ToDepartmentId = workFlowCurrentEntity.ToDepartmentId; workFlowHistoryEntity.ToDepartmentName = workFlowCurrentEntity.ToDepartmentName; } workFlowHistoryEntity.AuditUserId = workFlowCurrentEntity.AuditUserId; workFlowHistoryEntity.AuditUserRealName = workFlowCurrentEntity.AuditUserRealName; workFlowHistoryEntity.AuditIdea = workFlowCurrentEntity.AuditIdea; workFlowHistoryEntity.AuditStatus = workFlowCurrentEntity.AuditStatus; workFlowHistoryEntity.AuditStatusName = workFlowCurrentEntity.AuditStatusName; workFlowHistoryEntity.SendDate = workFlowCurrentEntity.AuditDate; workFlowHistoryEntity.AuditDate = DateTime.Now; workFlowHistoryEntity.Description = workFlowCurrentEntity.Description; workFlowHistoryEntity.SortCode = workFlowCurrentEntity.SortCode; workFlowHistoryEntity.DeletionStateCode = workFlowCurrentEntity.DeletionStateCode; workFlowHistoryEntity.Enabled = workFlowCurrentEntity.Enabled; BaseWorkFlowHistoryManager workFlowHistoryManager = new BaseWorkFlowHistoryManager(DbHelper, UserInfo); return workFlowHistoryManager.AddEntity(workFlowHistoryEntity); }
/// <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 returnValue = 0; lock (WorkFlowCurrentLock) { // using (TransactionScope transactionScope = new TransactionScope()) //{ try { BaseWorkFlowCurrentEntity workFlowCurrentEntity = this.GetEntity(currentId); // 判断是是否是自由流(自由流这个为空) if (workFlowCurrentEntity.WorkFlowId != null && workFlowCurrentEntity.WorkFlowId != 0) { // 若都已经被退回到彻底了,不能再被退回了,意思是已经退回到创建人了 if (workFlowCurrentEntity.ActivityId == null) { return returnValue; } } // 只有待审核状态的,才可以退回,还需要能持续退回 if ( //workFlowCurrentEntity.AuditStatus.Equals(AuditStatus.AuditComplete.ToString()) || workFlowCurrentEntity.AuditStatus.Equals(AuditStatus.AuditQuash.ToString())) { return returnValue; } /* 彻底退回的处理 if (activityId == null) { // 发送给当初发起这个工作流的创建者 sendToUserId = workFlowCurrentEntity.CreateUserId; } else { BaseWorkFlowActivityManager workFlowActivityManager = new BaseWorkFlowActivityManager(this.DbHelper, this.UserInfo); BaseWorkFlowActivityEntity workFlowActivityEntity = workFlowActivityManager.GetEntity(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 returnValue; } // 一个审核者不能持续退回,但是发给自己的,还可以持续退回 if (workFlowCurrentEntity.AuditUserId.ToString().Equals(this.UserInfo.Id) && workFlowCurrentEntity.AuditStatus.Equals(AuditStatus.AuditReject.ToString()) && (!workFlowCurrentEntity.ToUserId.ToString().Equals(this.UserInfo.Id))) { return returnValue; } } // 默认是自由工作流 string workFlowId = "0"; List<KeyValuePair<string, object>> parameters = new List<KeyValuePair<string, object>>(); DataTable dataTable = null; BaseWorkFlowHistoryManager workFlowHistoryManager = new BaseWorkFlowHistoryManager(this.DbHelper, this.UserInfo); string rejectToActivityId = string.Empty; // 工作流主键 if (workFlowCurrentEntity.WorkFlowId != null && workFlowCurrentEntity.WorkFlowId != 0) { workFlowId = workFlowCurrentEntity.WorkFlowId.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.FieldWorkFlowId, workFlowId)); parameters.Add(new KeyValuePair<string, object>(BaseWorkFlowStepEntity.FieldEnabled, 1)); parameters.Add(new KeyValuePair<string, object>(BaseWorkFlowStepEntity.FieldDeletionStateCode, 0)); dataTable = workFlowStepManager.GetDataTable(parameters, BaseWorkFlowStepEntity.FieldSortCode); if (dataTable.Rows.Count > 0) { dataTable.Columns.Remove(BaseWorkFlowStepEntity.FieldId); dataTable.Columns[BaseWorkFlowStepEntity.FieldActivityId].ColumnName = BaseWorkFlowStepEntity.FieldId; } else { // 判断是是否是自由流(自由流这个为空) if (workFlowCurrentEntity.WorkFlowId != null && workFlowCurrentEntity.WorkFlowId != 0) { return returnValue; } } if (!string.IsNullOrEmpty(historyId)) { BaseWorkFlowHistoryEntity workFlowHistoryEntity = workFlowHistoryManager.GetEntity(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.FieldWorkFlowId, 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) { dataTable = dataTableActivity; } string activityId = string.Empty; if (workFlowCurrentEntity.ActivityId != null) { activityId = workFlowCurrentEntity.ActivityId.ToString(); } if (!string.IsNullOrEmpty(activityId)) { rejectToActivityId = BaseSortLogic.GetPreviousId(dataTable, activityId.ToString()); } else { if (dataTable.Rows.Count > 0) { rejectToActivityId = dataTable.Rows[0][BaseWorkFlowActivityEntity.FieldId].ToString(); } } if (string.IsNullOrEmpty(rejectToActivityId)) { // 这里已经是最后一步,发出者这里了 // 已经到自己手里的,没必要再继续退回了 if (this.UserInfo.Id.Equals(workFlowCurrentEntity.CreateUserId)) { return returnValue; } } } } // 这里不应该是发给所有的人,审核过的人,才可以看到才对。 string[] userIds = workFlowHistoryManager.GetProperties(new KeyValuePair<string, object>(BaseWorkFlowCurrentEntity.FieldWorkFlowId, workFlowCurrentEntity.Id), 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); DataTable dt = workFlowActivityManager.GetBackToDT(workFlowCurrentEntity); userIds = BaseBusinessLogic.FieldToArray(dt, BaseWorkFlowActivityEntity.FieldAuditUserId); } */ // 都给谁发送退回的消息 workFlowManager.SendRemindMessage(workFlowCurrentEntity, AuditStatus.AuditReject, userIds, workFlowCurrentEntity.ToDepartmentId, workFlowCurrentEntity.ToRoleId); } returnValue = 1; } else { // 数据可能被删除 this.ReturnStatusCode = StatusCode.ErrorDeleted.ToString(); } // 应该给创建者一个提醒消息 this.ReturnStatusMessage = this.GetStateMessage(this.ReturnStatusCode); } catch (System.Exception ex) { // 在本地记录异常 FileUtil.WriteException(UserInfo, ex); } finally { } // transactionScope.Complete(); // } } return returnValue; }
/// <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 returnValue = 0; lock (WorkFlowCurrentLock) { // using (TransactionScope transactionScope = new TransactionScope()) //{ try { BaseWorkFlowCurrentEntity workFlowCurrentEntity = this.GetEntity(currentId); // 判断是是否是自由流(自由流这个为空) if (workFlowCurrentEntity.WorkFlowId != null && workFlowCurrentEntity.WorkFlowId != 0) { // 若都已经被退回到彻底了,不能再被退回了,意思是已经退回到创建人了 if (workFlowCurrentEntity.ActivityId == null) { return(returnValue); } } // 只有待审核状态的,才可以退回,还需要能持续退回 if ( //workFlowCurrentEntity.AuditStatus.Equals(AuditStatus.AuditComplete.ToString()) || workFlowCurrentEntity.AuditStatus.Equals(AuditStatus.AuditQuash.ToString())) { return(returnValue); } /* 彻底退回的处理 * if (activityId == null) * { * // 发送给当初发起这个工作流的创建者 * sendToUserId = workFlowCurrentEntity.CreateUserId; * } * else * { * BaseWorkFlowActivityManager workFlowActivityManager = new BaseWorkFlowActivityManager(this.DbHelper, this.UserInfo); * BaseWorkFlowActivityEntity workFlowActivityEntity = workFlowActivityManager.GetEntity(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(returnValue); } // 一个审核者不能持续退回,但是发给自己的,还可以持续退回 if (workFlowCurrentEntity.AuditUserId.ToString().Equals(this.UserInfo.Id) && workFlowCurrentEntity.AuditStatus.Equals(AuditStatus.AuditReject.ToString()) && (!workFlowCurrentEntity.ToUserId.ToString().Equals(this.UserInfo.Id))) { return(returnValue); } } // 默认是自由工作流 string workFlowId = "0"; List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >(); DataTable dataTable = null; BaseWorkFlowHistoryManager workFlowHistoryManager = new BaseWorkFlowHistoryManager(this.DbHelper, this.UserInfo); string rejectToActivityId = string.Empty; // 工作流主键 if (workFlowCurrentEntity.WorkFlowId != null && workFlowCurrentEntity.WorkFlowId != 0) { workFlowId = workFlowCurrentEntity.WorkFlowId.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.FieldWorkFlowId, workFlowId)); parameters.Add(new KeyValuePair <string, object>(BaseWorkFlowStepEntity.FieldEnabled, 1)); parameters.Add(new KeyValuePair <string, object>(BaseWorkFlowStepEntity.FieldDeletionStateCode, 0)); dataTable = workFlowStepManager.GetDataTable(parameters, BaseWorkFlowStepEntity.FieldSortCode); if (dataTable.Rows.Count > 0) { dataTable.Columns.Remove(BaseWorkFlowStepEntity.FieldId); dataTable.Columns[BaseWorkFlowStepEntity.FieldActivityId].ColumnName = BaseWorkFlowStepEntity.FieldId; } else { // 判断是是否是自由流(自由流这个为空) if (workFlowCurrentEntity.WorkFlowId != null && workFlowCurrentEntity.WorkFlowId != 0) { return(returnValue); } } if (!string.IsNullOrEmpty(historyId)) { BaseWorkFlowHistoryEntity workFlowHistoryEntity = workFlowHistoryManager.GetEntity(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.FieldWorkFlowId, 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) { dataTable = dataTableActivity; } string activityId = string.Empty; if (workFlowCurrentEntity.ActivityId != null) { activityId = workFlowCurrentEntity.ActivityId.ToString(); } if (!string.IsNullOrEmpty(activityId)) { rejectToActivityId = BaseSortLogic.GetPreviousId(dataTable, activityId.ToString()); } else { if (dataTable.Rows.Count > 0) { rejectToActivityId = dataTable.Rows[0][BaseWorkFlowActivityEntity.FieldId].ToString(); } } if (string.IsNullOrEmpty(rejectToActivityId)) { // 这里已经是最后一步,发出者这里了 // 已经到自己手里的,没必要再继续退回了 if (this.UserInfo.Id.Equals(workFlowCurrentEntity.CreateUserId)) { return(returnValue); } } } } // 这里不应该是发给所有的人,审核过的人,才可以看到才对。 string[] userIds = workFlowHistoryManager.GetProperties(new KeyValuePair <string, object>(BaseWorkFlowCurrentEntity.FieldWorkFlowId, workFlowCurrentEntity.Id), 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); * DataTable dt = workFlowActivityManager.GetBackToDT(workFlowCurrentEntity); * userIds = BaseBusinessLogic.FieldToArray(dt, BaseWorkFlowActivityEntity.FieldAuditUserId); * } */ // 都给谁发送退回的消息 workFlowManager.SendRemindMessage(workFlowCurrentEntity, AuditStatus.AuditReject, userIds, workFlowCurrentEntity.ToDepartmentId, workFlowCurrentEntity.ToRoleId); } returnValue = 1; } else { // 数据可能被删除 this.ReturnStatusCode = StatusCode.ErrorDeleted.ToString(); } // 应该给创建者一个提醒消息 this.ReturnStatusMessage = this.GetStateMessage(this.ReturnStatusCode); } catch (System.Exception ex) { // 在本地记录异常 FileUtil.WriteException(UserInfo, ex); } finally { } // transactionScope.Complete(); // } } return(returnValue); }