public ResultModel AuditTaskNode(UserModel user, int taskNodeId, bool isPass, string memo, string logResult, string aids)
{
ResultModel result = new ResultModel();
using (System.Transactions.TransactionScope scope = new System.Transactions.TransactionScope(System.Transactions.TransactionScopeOption.Required))
{
NFMT.WorkFlow.DAL.TaskNodeDAL taskNodeDAL = new NFMT.WorkFlow.DAL.TaskNodeDAL();
result = taskNodeDAL.Get(user, taskNodeId);
if (result.ResultStatus != 0)
return result;
NFMT.WorkFlow.Model.TaskNode taskNode = result.ReturnValue as NFMT.WorkFlow.Model.TaskNode;
if (taskNode == null || taskNode.TaskNodeId <= 0)
{
result.ResultStatus = -1;
result.Message = "任务节点不存在";
return result;
}
if (taskNode.NodeStatus != StatusEnum.待审核)
{
result.ResultStatus = -1;
result.Message = "该节点已审核";
return result;
}
NFMT.WorkFlow.Model.TaskOperateLog taskOperateLog = new NFMT.WorkFlow.Model.TaskOperateLog()
{
TaskNodeId = taskNode.TaskNodeId,
EmpId = user.EmpId,
Memo = memo,
LogTime = DateTime.Now,
LogResult = logResult
};
List<NFMT.WorkFlow.Model.TaskAttachOperateLog> taskAttachOperateLogs = new List<TaskAttachOperateLog>();
if (!string.IsNullOrEmpty(aids))
{
foreach (string s in aids.Split(','))
{
taskAttachOperateLogs.Add(new TaskAttachOperateLog()
{
AttachId = Convert.ToInt32(s)
});
}
}
FlowOperate flowOperate = new FlowOperate();
result = flowOperate.AuditTaskNode(user, taskNode, taskOperateLog, taskAttachOperateLogs, isPass);
if (result.ResultStatus != 0)
return result;
scope.Complete();
}
return result;
}
/// <summary>
/// 根据流程模版，创建任务及任务的第一节点，返回任务的id
/// </summary>
/// <param name="user">当前用户</param>
/// <param name="master">流程模版</param>
/// <param name="source">数据源</param>
/// <param name="task">任务</param>
/// <returns></returns>
private ResultModel CreateTask(UserModel user, FlowMaster master, DataSource source, Task task)
{
ResultModel result = new ResultModel();
try
{
//写入DataSource
DataSourceDAL dataSourceDAL = new DataSourceDAL();
result = dataSourceDAL.Insert(user, source);
if (result.ResultStatus != 0)
return result;
int sourceId = Convert.ToInt32(result.ReturnValue);
//写入task
TaskDAL taskDAL = new TaskDAL();
task.DataSourceId = sourceId;
result = taskDAL.Insert(user, task);
if (result.ResultStatus != 0)
return result;
int taskId = Convert.ToInt32(result.ReturnValue);
task.TaskId = taskId;
//在审核流程中添加提交审核人
NodeDAL nodeDAL = new NodeDAL();
result = nodeDAL.Load<Node>(user, CommandType.Text, string.Format("select * from dbo.Wf_Node where MasterId = {0} and NodeStatus = {1}", master.MasterId, (int)StatusEnum.已生效));
if (result.ResultStatus != 0)
return result;
List<Node> nodes = result.ReturnValue as List<Node>;
if (nodes != null)
{
Node firstNode = nodes.OrderBy(a => a.NodeLevel).First();
//如果存在NodeLevel为0（提交人）
if (firstNode.NodeLevel == 0)
{
TaskNodeDAL taskNodeDAL = new TaskNodeDAL();
result = taskNodeDAL.Insert(user, new TaskNode()
{
NodeId = firstNode.NodeId,
TaskId = taskId,
NodeLevel = firstNode.NodeLevel,
NodeStatus = StatusEnum.已生效,
EmpId = source.EmpId,
AuditTime = DefaultValue.DefaultTime
});
int taskNodeId = (int)result.ReturnValue;
TaskOperateLogDAL taskOperateLogDAL = new TaskOperateLogDAL();
result = taskOperateLogDAL.Insert(user, new TaskOperateLog()
{
TaskNodeId = taskNodeId,
EmpId = source.EmpId,
Memo = "",
LogTime = DateTime.Now,
LogResult = ""
});
}
}
result = CreateTaskNodes(user, task, 1, source);
if (result.ResultStatus != 0)
return result;
result.ReturnValue = taskId;
}
catch (Exception ex)
{
result.Message = ex.Message;
result.ResultStatus = -1;
}
return result;
}
/// <summary>
/// 任务同级节点是否有一个通过
/// </summary>
/// <param name="user"></param>
/// <param name="task">任务</param>
/// <param name="nodeLevel">节点级别</param>
/// <returns></returns>
public ResultModel IsSameLevelNodeSuccessOnce(UserModel user, Task task, int nodeLevel)
{
ResultModel result = new ResultModel();
try
{
SelectModel select = new SelectModel();
select.ColumnName = "tn.TaskNodeId";
select.OrderStr = "tn.TaskNodeId";
select.PageIndex = 1;
select.TableName = string.Format(" dbo.Wf_TaskNode tn inner join dbo.Wf_Node n on tn.NodeId = n.NodeId and n.NodeType <> {0} ", DetailProvider.Details(StyleEnum.NodeType)["Notify"].StyleDetailId);
select.WhereStr = string.Format(" tn.NodeLevel ={0} and tn.NodeStatus ={1} and tn.TaskId = {2} ", nodeLevel, (int)StatusEnum.已生效, task.Id);
select.PageSize = 20;
TaskNodeDAL dal = new TaskNodeDAL();
result = dal.Load(user, select);
if (result.ResultStatus != 0)
return result;
DataTable dt = new DataTable();
if (result.ReturnValue != null)
{
dt = (DataTable)result.ReturnValue;
result.AffectCount = dt.Rows.Count;
}
else
{
result.ReturnValue = false;
return result;
}
result.Message = "查询成功";
result.ResultStatus = 0;
if (dt.Rows.Count > 0)
result.ReturnValue = true;
else
result.ReturnValue = false;
}
catch (Exception ex)
{
result.Message = ex.Message;
result.ReturnValue = ex;
}
return result;
}
/// <summary>
/// 创建任务节点
/// </summary>
/// <param name="task">任务</param>
/// <param name="nodeLevel">节点级别</param>
/// <returns></returns>
public ResultModel CreateTaskNodes(UserModel user, Task task, int nodeLevel, DataSource source)
{
ResultModel result = new ResultModel();
bool IsCreate = false;
try
{
//通过外部请求获取当前审核数据源
result = GetConditionUrl(source);
if (result.ResultStatus != 0)
return result;
Dictionary<string, object> conditionDic = result.ReturnValue as Dictionary<string, object>;
NodeDAL nodeDAL = new NodeDAL();
NodeOperateDAL nodeOperateDAL = new NodeOperateDAL();
NodeOperate nodeOperate = null;
TaskOperate taskOperate = null;
DataTable dt = null;
//获取模板中当前层级的所有节点
lock (nodeCollection)
{
string key = string.Format("{0}{1}", task.MasterId, nodeLevel);
if (nodeCollection.ContainsKey(key))
dt = nodeCollection[key];
else
{
SelectModel nodeSelect = new SelectModel();
nodeSelect.ColumnName = "*";
nodeSelect.OrderStr = "NodeId";
nodeSelect.PageIndex = 1;
nodeSelect.PageSize = 500;
nodeSelect.TableName = "dbo.Wf_Node";
nodeSelect.WhereStr = string.Format("MasterId={0} and NodeLevel={1} and NodeStatus = {2}", task.MasterId, nodeLevel, (int)StatusEnum.已生效);
result = nodeDAL.Load(user, nodeSelect);
if (result.ResultStatus != 0)
return result;
dt = result.ReturnValue as DataTable;
nodeCollection.Add(key, dt);
}
}
if (dt != null && dt.Rows.Count > 0)
{
TaskNodeDAL taskNodeDAL = new TaskNodeDAL();
foreach (DataRow dr in dt.Rows)
{
//判断是否符合条件
result = JudgeNodeCondition(Convert.ToInt32(dr["NodeId"]), task.TaskId, conditionDic);
if (result.ResultStatus != 0)
return result;
bool judge = false;
if (result.ResultStatus == 0 && result.ReturnValue != null)
bool.TryParse(result.ReturnValue.ToString(), out judge);
if (judge)
{
int nodeId = Convert.ToInt32(dr["NodeId"]);
//获取该节点
result = nodeDAL.Get(user, nodeId);
if (result.ResultStatus != 0)
return result;
Node node = result.ReturnValue as Node;
if (node == null)
return result;
//判断该节点是否需要操作
result = nodeOperateDAL.GetByNodeId(user, node.NodeId);
if (result.ResultStatus == 0)
nodeOperate = result.ReturnValue as NodeOperate;
//获取审核人
AuditEmpDAL auditEmpDAl = new AuditEmpDAL();
result = auditEmpDAl.GetEmpIdsByAuditEmpId(user, node.AuditEmpId, source);
if (result.ResultStatus != 0)
return result;
DataTable dtvalue = result.ReturnValue as DataTable;
//如果不存在审核人，则转到下一个节点
if (dtvalue == null || dtvalue.Rows.Count < 1)
{
//result.ResultStatus = -1;
//return result;
continue;
}
//如果存在审核人，则生成相应审核节点
foreach (DataRow drValue in dtvalue.Rows)
{
if (Convert.ToInt32(drValue["EmpId"]) <= 0) continue;
TaskNode taskNode = new TaskNode()
{
NodeLevel = nodeLevel,
NodeStatus = StatusEnum.待审核,
TaskId = task.Id,
NodeId = nodeId,
AuditTime = DefaultValue.DefaultTime,
EmpId = Convert.ToInt32(drValue["EmpId"])
};
//如果在一个任务中存在相同的审核人且审核通过，则将新生成的审核人节点状态改为已生效(视为审核通过)
result = taskNodeDAL.GetTaskNodeIdBySameAuditEmp(user, task.TaskId, Convert.ToInt32(drValue["EmpId"]));
DataTable resultDatatable = result.ReturnValue as DataTable;
if (result.ResultStatus == 0 && resultDatatable != null && resultDatatable.Rows.Count > 0 && nodeOperate == null)
{
taskNode.NodeStatus = StatusEnum.已生效;
result = taskNodeDAL.Insert(user, taskNode);
if (result.ResultStatus != 0)
return result;
int taskNodeIdValue = (int)result.ReturnValue;
//插入附言
TaskOperateLogDAL taskOperateLogDAL = new TaskOperateLogDAL();
result = taskOperateLogDAL.GetLogByTaskNodeIdAndEmpId(user, Convert.ToInt32(resultDatatable.Rows[0]["TaskNodeId"]), Convert.ToInt32(drValue["EmpId"]));
if (result.ResultStatus != 0)
return result;
TaskOperateLog taskOperateLog = result.ReturnValue as TaskOperateLog;
if (taskOperateLog != null)
{
taskOperateLog.TaskNodeId = taskNodeIdValue;
result = taskOperateLogDAL.Insert(user, taskOperateLog);
}
if (result.ResultStatus != 0)
return result;
IsCreate = true;
}
else if (result.ResultStatus == 0)//否则添加消息提醒
{
result = taskNodeDAL.Insert(user, taskNode);
if (result.ResultStatus != 0)
return result;
int taskNodeIdValue = (int)result.ReturnValue;
if (nodeOperate != null)
{
taskOperate = new TaskOperate()
{
TaskNodeId = taskNodeIdValue,
OperateUrl = nodeOperate.OperateUrl,
OperateStatus = StatusEnum.已生效
};
TaskOperateDAL taskOperateDAL = new TaskOperateDAL();
result = taskOperateDAL.Insert(user, taskOperate);
if (result.ResultStatus != 0)
return result;
}
//添加消息提醒
Sms.Model.Sms sms = new Sms.Model.Sms()
{
SmsTypeId = 1,//to do list
SmsHead = task.TaskName,
SmsStatus = (int)SmsStatusEnum.待处理消息,
SmsBody = task.TaskConnext,
SmsRelTime = DateTime.Now,
SmsLevel = 1,
SourceId = taskNodeIdValue //taskNodeId
};
List<SmsDetail> smsDetails = new List<SmsDetail>();
smsDetails.Add(new SmsDetail()
{
EmpId = Convert.ToInt32(drValue["EmpId"]),
ReadTime = DefaultValue.DefaultTime
});
SmsDAL smsDAL = new SmsDAL();
result = smsDAL.AddSms(user, sms, smsDetails);
if (result.ResultStatus != 0)
return result;
IsCreate = true;
}
}
}
}
if (!IsCreate)
{
result.Message = "当前审核层级无审核人员";
result.ResultStatus = -1;
//递归生成下级节点
result = CreateTaskNodes(user, task, ++nodeLevel, source);
}
else
{
//如果创建了审核节点，则判断是否所有审核节点都通过了
result = this.JudgeSameLevelSuccessHandle(user, task, nodeLevel, source);
}
}
else
{
result.Message = "不存在下级节点";
result.ResultStatus = -1;
//是否判断在无下级节点后审核流程结束？审核结果为通过？
TaskDAL taskDAL = new TaskDAL();
result = taskDAL.Complete(user, task);
if (result.ResultStatus != 0)
return result;
//修改数据源状态（改为已完成）
DataSourceDAL dataSourceDAL = new DataSourceDAL();
result = dataSourceDAL.DataSourceComplete(user, source);
if (result.ResultStatus != 0)
return result;
result = this.RequestCallBackUrl(user, source, true);
if (result.ResultStatus != 0)
return result;
}
}
catch (Exception ex)
{
result.Message = ex.Message;
result.ReturnValue = ex;
result.ResultStatus = -1;
}
return result;
}
/// <summary>
/// 审核工作流任务
/// </summary>
/// <param name="user">当前审核人</param>
/// <param name="taskNode">任务节点</param>
/// <param name="log">任务操作记录</param>
/// <param name="isPass">true表示通过，false表示不通过</param>
/// <returns></returns>
public ResultModel AuditTaskNode(UserModel user, TaskNode taskNode, TaskOperateLog log, List<TaskAttachOperateLog> taskAttachOperateLogs, bool isPass)
{
ResultModel result = new ResultModel();
try
{
//插入附言
TaskOperateLogDAL taskOperateLogDAL = new TaskOperateLogDAL();
result = taskOperateLogDAL.Insert(user, log);
if (result.ResultStatus != 0)
return result;
int logId = (int)result.ReturnValue;
//任务附件操作记录表
if (taskAttachOperateLogs != null && taskAttachOperateLogs.Any())
{
TaskAttachOperateLogDAL taskAttachOperateLogDAL = new TaskAttachOperateLogDAL();
foreach (TaskAttachOperateLog TaskAttachOperateLog in taskAttachOperateLogs)
{
TaskAttachOperateLog.LogId = logId;
result = taskAttachOperateLogDAL.Insert(user, TaskAttachOperateLog);
if (result.ResultStatus != 0)
return result;
}
}
//修改taskNode状态
TaskNodeDAL taskNodeDAL = new TaskNodeDAL();
result = taskNodeDAL.Audit(user, taskNode, isPass);
if (result.ResultStatus != 0)
return result;
//获取任务节点对应的任务
TaskDAL taskDAL = new TaskDAL();
result = taskDAL.Get(user, taskNode.TaskId);
if (result.ResultStatus != 0)
return result;
Task task = result.ReturnValue as Task;
//获取task对应的datasource
DataSourceDAL dataSourceDAL = new DataSourceDAL();
result = dataSourceDAL.Get(user, task.DataSourceId);
if (result.ResultStatus != 0)
return result;
DataSource source = result.ReturnValue as DataSource;
if (isPass)
{
//获取流程模版配置
FlowMasterConfigDAL flowMasterConfigDAL = new FlowMasterConfigDAL();
result = flowMasterConfigDAL.GetByMasterId(user, task.MasterId);
if (result.ResultStatus == 0)
{
FlowMasterConfig flowMasterConfig = result.ReturnValue as FlowMasterConfig;
//如果同级节点只需一人审核通过就行，则将其他审核人作废
if (!flowMasterConfig.IsSeries)
{
result = taskNodeDAL.UpdateTaskNodeStatusByLevelIdExceptSelf(user, taskNode, StatusEnum.已作废);
//if (result.ResultStatus != 0)
// return result;
}
}
result = this.JudgeSameLevelSuccessHandle(user, task, taskNode.NodeLevel, source);
if (result.ResultStatus != 0)
return result;
}
else
{
//修改任务状态(改为已生效，该任务视为结束)，并审核拒绝回调
result = taskDAL.Complete(user, task);
if (result.ResultStatus != 0)
return result;
////修改数据源状态（改为已完成）
//result = dataSourceDAL.DataSourceComplete(user, source);
//if (result.ResultStatus != 0)
// return result;
result = dataSourceDAL.Audit(user, source, false);
if (result.ResultStatus != 0)
return result;
result = RequestCallBackUrl(user, source, false);
if (result.ResultStatus != 0)
return result;
//获取或新增消息类型
SmsTypeDAL smsTypeDAL = new SmsTypeDAL();
result = smsTypeDAL.InsertOrGet(user, task.MasterId);
if (result.ResultStatus != 0)
return result;
int smsTypeId = (int)result.ReturnValue;
//找到该任务的发起人，给他发消息提醒
Sms.Model.Sms sms = new Sms.Model.Sms()
{
SmsTypeId = smsTypeId,
SmsHead = string.Format("{0}已被退回", task.TaskName),
SmsStatus = (int)SmsStatusEnum.待处理消息,
SmsBody = task.TaskConnext,
SmsRelTime = DateTime.Now,
SmsLevel = 1,
SourceId = source.RowId
};
List<SmsDetail> smsDetails = new List<SmsDetail>
{
new SmsDetail()
{
EmpId = source.EmpId, //任务的发起人
ReadTime = DefaultValue.DefaultTime
}
};
SmsDAL smsDAL = new SmsDAL();
result = smsDAL.AddSms(user, sms, smsDetails);
if (result.ResultStatus != 0)
return result;
}
}
catch (Exception ex)
{
result.ResultStatus = -1;
result.Message = ex.Message;
result.ReturnValue = ex;
}
return result;
}