public override IModel CreateModel(SqlDataReader dr) { Task task = new Task(); int indexTaskId = dr.GetOrdinal("TaskId"); task.TaskId = Convert.ToInt32(dr[indexTaskId]); int indexMasterId = dr.GetOrdinal("MasterId"); if (dr["MasterId"] != DBNull.Value) { task.MasterId = Convert.ToInt32(dr[indexMasterId]); } int indexTaskName = dr.GetOrdinal("TaskName"); if (dr["TaskName"] != DBNull.Value) { task.TaskName = Convert.ToString(dr[indexTaskName]); } int indexTaskConnext = dr.GetOrdinal("TaskConnext"); if (dr["TaskConnext"] != DBNull.Value) { task.TaskConnext = Convert.ToString(dr[indexTaskConnext]); } int indexTaskStatus = dr.GetOrdinal("TaskStatus"); if (dr["TaskStatus"] != DBNull.Value) { task.TaskStatus = (Common.StatusEnum)Convert.ToInt32(dr[indexTaskStatus]); } int indexDataSourceId = dr.GetOrdinal("DataSourceId"); if (dr["DataSourceId"] != DBNull.Value) { task.DataSourceId = Convert.ToInt32(dr[indexDataSourceId]); } int indexTaskType = dr.GetOrdinal("TaskType"); if (dr["TaskType"] != DBNull.Value) { task.TaskType = Convert.ToInt32(dr[indexTaskType]); } return task; }
public ResultModel GetTaskByDataSourceId(UserModel user, int dataSourceId) { ResultModel result = new ResultModel(); SqlDataReader dr = null; try { string sql = string.Format("select * from dbo.Wf_Task where DataSourceId = {0}", dataSourceId); dr = SqlHelper.ExecuteReader(ConnectString, CommandType.Text, sql, null); Task task = new Task(); if (dr.Read()) { int indexTaskId = dr.GetOrdinal("TaskId"); task.TaskId = Convert.ToInt32(dr[indexTaskId]); int indexMasterId = dr.GetOrdinal("MasterId"); if (dr["MasterId"] != DBNull.Value) { task.MasterId = Convert.ToInt32(dr[indexMasterId]); } int indexTaskName = dr.GetOrdinal("TaskName"); if (dr["TaskName"] != DBNull.Value) { task.TaskName = Convert.ToString(dr[indexTaskName]); } int indexTaskConnext = dr.GetOrdinal("TaskConnext"); if (dr["TaskConnext"] != DBNull.Value) { task.TaskConnext = Convert.ToString(dr[indexTaskConnext]); } int indexTaskStatus = dr.GetOrdinal("TaskStatus"); if (dr["TaskStatus"] != DBNull.Value) { task.TaskStatus = (Common.StatusEnum)Enum.Parse(typeof(Common.StatusEnum), dr[indexTaskStatus].ToString()); } int indexDataSourceId = dr.GetOrdinal("DataSourceId"); if (dr["DataSourceId"] != DBNull.Value) { task.DataSourceId = Convert.ToInt32(dr[indexDataSourceId]); } int indexTaskType = dr.GetOrdinal("TaskType"); if (dr["TaskType"] != DBNull.Value) { task.TaskType = Convert.ToInt32(dr[indexTaskType]); } result.AffectCount = 1; result.Message = "读取成功"; result.ResultStatus = 0; result.ReturnValue = task; } else { result.Message = "读取失败或无数据"; result.AffectCount = 0; } } catch (Exception ex) { result.Message = ex.Message; } finally { if (dr != null) dr.Dispose(); } 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="task"></param> /// <param name="nodeLevel"></param> /// <param name="source"></param> /// <returns></returns> private ResultModel JudgeSameLevelSuccessHandle(UserModel user, Task task, int nodeLevel, DataSource source) { ResultModel result = new ResultModel(); TaskDAL taskDAL = new TaskDAL(); DataSourceDAL dataSourceDAL = new DataSourceDAL(); try { //判断同级节点是否全部通过 result = IsSameLevelNodeSuccess(user, task, nodeLevel); if (result.ResultStatus != 0) return result; bool allSuccess = (bool)result.ReturnValue; if (allSuccess) { //判断所在流程模版中是否有下一级节点或是否为最终节点 NodeDAL nodeDAL = new NodeDAL(); result = nodeDAL.Load(user, new SelectModel() { ColumnName = "NodeId", TableName = "Wf_Node", WhereStr = string.Format("MasterId = {0} and NodeLevel = {1} and NodeStatus = {2}", task.MasterId, nodeLevel + 1, (int)StatusEnum.已生效), OrderStr = "NodeId", PageIndex = 1, PageSize = 20 }); if (result.ResultStatus != 0) return result; DataTable dt = result.ReturnValue as DataTable; //如果存在下一级节点,则生成相应的任务节点 if (dt != null && dt.Rows.Count > 0) { result = this.CreateTaskNodes(user, task, nodeLevel + 1, 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 = this.RequestCallBackUrl(user, source, true); if (result.ResultStatus != 0) return result; } } else { result.Message = "同级中存在未审核节点"; result.ReturnValue = false; } } catch (Exception e) { result.ResultStatus = -1; result.Message = e.Message; } return result; }
/// <summary> /// 提交审核并创建任务和提醒消息 /// </summary> /// <param name="user">用户</param> /// <param name="model">提交审核数据实体</param> /// <param name="master">模版</param> /// <param name="source">数据源</param> /// <param name="task">任务</param> /// <returns></returns> public ResultModel AuditAndCreateTask(UserModel user, IModel model, FlowMaster master, DataSource source, Task task) { ResultModel result = new ResultModel(); try { using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required)) { DataSourceDAL dataSourceDAL = new DataSourceDAL(); result = dataSourceDAL.CheckHasSource(new DataSource() { TableCode = model.TableName, RowId = model.Id }); if (result.ResultStatus != 0 || result.AffectCount > 0) { result.Message = "不能重复提交审核"; result.ResultStatus = -1; return result; } Common.Operate operate = Common.Operate.CreateOperate(model, true); if (operate == null) { result.Message = "模版不存在"; result.ResultStatus = -1; return result; } result = operate.Get(user, model.Id); if (result.ResultStatus != 0) return result; IModel resultModel = result.ReturnValue as IModel; if (resultModel == null || resultModel.Id <= 0) { result.ResultStatus = -1; result.Message = "数据不存在,不能提交审核"; return result; } //判断是否可以直接审核通过 FlowMasterConfigDAL flowMasterConfigDAL = new FlowMasterConfigDAL(); result = flowMasterConfigDAL.GetByMasterId(user, master.MasterId); if (result.ResultStatus == 0) { FlowMasterConfig flowMasterConfig = result.ReturnValue as FlowMasterConfig; if (flowMasterConfig != null && flowMasterConfig.ConfigId > 0 && flowMasterConfig.CanPassAudit) { result = RequestCallBackUrlForPass(user, source, true); if (result.ResultStatus != 0) return result; if (result.ResultStatus == 0) scope.Complete(); return result; } } result = operate.Submit(user, resultModel); if (result.ResultStatus != 0) return result; result = this.CreateTask(user, master, source, task); if (result.ResultStatus != 0) return result; int taskId = (int)result.ReturnValue; string aids = string.Empty; AttachBLL attachBLL = new AttachBLL(); result = attachBLL.GetAttachIds(user, resultModel); if (result.ResultStatus == 0) { DataTable dt = result.ReturnValue as DataTable; if (dt != null && dt.Rows.Count > 0) { aids = dt.Rows.Cast<DataRow>().Aggregate(aids, (current, dr) => current + (dr["AttachId"].ToString() + ",")); if (!string.IsNullOrEmpty(aids)) aids = aids.Substring(0, aids.Length - 1); } TaskAttachBLL taskAttachBLL = new TaskAttachBLL(); result = taskAttachBLL.InsertAttach(user, taskId, aids); if (result.ResultStatus != 0) return result; } else result.ResultStatus = 0; scope.Complete(); } } catch (Exception ex) { result.Message = ex.Message; result.ResultStatus = -1; } return result; }