/// <summary> /// 获取流程信息(对数据库操作) /// </summary> /// <param name="FormID">表单ID</param> /// <param name="FlowGUID">明细ID</param> /// <param name="CheckState">审批状态(同意:1,不同意:0 ,未处理:2,会签同意7,会签不同意8)</param> /// <param name="Flag">审批状态(已审批:1,未审批:0)</param> /// <param name="ModelCode">模块代码</param> /// <param name="CompanyID">创建公司ID</param> /// <param name="EditUserID">操作人</param> /// <param name="FlowType">流程类型(0:审批流程,1:任务流程)</param> /// <returns></returns> public static List<FLOW_FLOWRECORDDETAIL_T> GetFlowInfo(OracleConnection con, string FormID, string FlowGUID, string CheckState, string Flag, string ModelCode, string CompanyID, string EditUserID, List<FlowType> FlowType) { try { List<string> FlowTypeList = new List<string>(); FLOW_FLOWRECORDDETAIL_TDAL Dal = new FLOW_FLOWRECORDDETAIL_TDAL(); var dt = FLOW_FLOWRECORDDETAIL_TDAL.GetFlowRecord(con, FormID, FlowGUID, CheckState, Flag, ModelCode, CompanyID, EditUserID, Utility.FlowTypeListToStringList(FlowType)); if (dt.Count > 0) return dt; return null; } catch (Exception ex) { LogHelper.WriteLog("GetFlowInfo异常信息:" + ex.Message); throw new Exception("GetFlowInfo:" + ex.Message); } }
/// <summary> /// 更新[流程审批明细表] /// </summary> /// <param name="entity">流程审批明细表</param> /// <returns></returns> public FLOW_FLOWRECORDDETAIL_T UpdateFlowRecord2(OracleConnection con, FLOW_FLOWRECORDDETAIL_T entity) { FLOW_FLOWRECORDDETAIL_TDAL Dal = new FLOW_FLOWRECORDDETAIL_TDAL(); entity.FLAG = "1"; FLOW_FLOWRECORDDETAIL_TDAL.Update(con, entity); return entity; }
public DataResult CancelFlow(SubmitData submitData, DataResult dataResult, List<FLOW_FLOWRECORDDETAIL_T> fd) { //WorkflowRuntime workflowRuntime = null; WorkflowInstance instance = null; FLOW_FLOWRECORDDETAIL_T entity = new FLOW_FLOWRECORDDETAIL_T(); #region entity.FLOWRECORDDETAILID = Guid.NewGuid().ToString(); entity.CREATECOMPANYID = submitData.ApprovalUser.CompanyID; entity.CREATEDEPARTMENTID = submitData.ApprovalUser.DepartmentID; entity.CREATEPOSTID = submitData.ApprovalUser.PostID; entity.CREATEUSERID = submitData.ApprovalUser.UserID; entity.CREATEUSERNAME = submitData.ApprovalUser.UserName; entity.EDITDATE = DateTime.Now; entity.CONTENT = submitData.ApprovalContent; entity.CHECKSTATE = "9"; entity.STATECODE = "Cancel"; entity.FLAG = "1"; entity.PARENTSTATEID = entity.FLOWRECORDDETAILID; entity.CREATEDATE = DateTime.Now; entity.EDITDATE = DateTime.Now; entity.EDITUSERID = entity.CREATEUSERID; entity.EDITUSERNAME = entity.CREATEUSERNAME; entity.EDITCOMPANYID = entity.CREATECOMPANYID; entity.EDITDEPARTMENTID = entity.CREATEDEPARTMENTID; entity.EDITPOSTID = entity.CREATEPOSTID; entity.FLOW_FLOWRECORDMASTER_T = fd[0].FLOW_FLOWRECORDMASTER_T; entity.FLOW_FLOWRECORDMASTER_T.FLOW_FLOWRECORDDETAIL_T.Add(entity); entity.FLOW_FLOWRECORDMASTER_T.CHECKSTATE = "9"; //设为撤销 entity.FLOW_FLOWRECORDMASTER_T.EDITUSERID = submitData.ApprovalUser.UserID; entity.FLOW_FLOWRECORDMASTER_T.EDITUSERNAME = submitData.ApprovalUser.UserName; entity.FLOW_FLOWRECORDMASTER_T.EDITDATE = DateTime.Now; #endregion workflowRuntime = SMTWorkFlowManage.CreateWorkFlowRuntime(true); LogHelper.WriteLog("CancelFlow从持久化库在恢复创建工作流实例ID=" + entity.FLOW_FLOWRECORDMASTER_T.INSTANCEID); instance = SMTWorkFlowManage.GetWorkflowInstance(workflowRuntime, entity.FLOW_FLOWRECORDMASTER_T.INSTANCEID); instance.Terminate("0"); FLOW_FLOWRECORDDETAIL_TDAL Dal = new FLOW_FLOWRECORDDETAIL_TDAL(); entity.FLAG = "1"; //Dal.AddFlowRecord(entity); FLOW_FLOWRECORDDETAIL_TDAL.Add(entity); FLOW_FLOWRECORDMASTER_TDAL.Update(entity.FLOW_FLOWRECORDMASTER_T); fd.Where(detail => detail.FLAG == "0").ToList().ForEach(item => { //Dal.Delete(item); //Dal.DeleteFlowRecord(item); FLOW_FLOWRECORDDETAIL_TDAL.Delete(item); }); dataResult.CheckState = "9";// dataResult.FlowResult = FlowResult.SUCCESS; return dataResult; }
public FLOW_FLOWRECORDDETAIL_T UpdateFlowRecord2(FLOW_FLOWRECORDDETAIL_T entity) { FLOW_FLOWRECORDDETAIL_TDAL Dal = new FLOW_FLOWRECORDDETAIL_TDAL(); entity.FLAG = "1"; FLOW_FLOWRECORDDETAIL_TDAL.Update(entity); //Dal.UpdateFlowRecord2(entity); return entity; }
public FLOW_FLOWRECORDDETAIL_T UpdateFlowRecord(FLOW_FLOWRECORDDETAIL_T entity, string NextStateCode, string EditUserId) { FLOW_FLOWRECORDDETAIL_TDAL Dal = new FLOW_FLOWRECORDDETAIL_TDAL(); //List<FLOW_FLOWRECORDDETAIL_T> Temp = Dal.GetFlowRecord("", entity.FLOWRECORDDETAILID, "", "", "", "", ""); //Temp[0].CONTENT = entity.CONTENT; //Temp[0].CHECKSTATE = entity.CHECKSTATE; //Temp[0].FLAG = "1"; //Temp[0].EDITDATE = DateTime.Now; //if (entity.FLOW_FLOWRECORDMASTER_T.CHECKSTATE != null) // Temp[0].FLOW_FLOWRECORDMASTER_T.CHECKSTATE = entity.FLOW_FLOWRECORDMASTER_T.CHECKSTATE; //if (entity.FLOW_FLOWRECORDMASTER_T.EDITUSERID != null) // Temp[0].FLOW_FLOWRECORDMASTER_T.EDITUSERID = entity.FLOW_FLOWRECORDMASTER_T.EDITUSERID; //if (entity.FLOW_FLOWRECORDMASTER_T.EDITUSERNAME != null) // Temp[0].FLOW_FLOWRECORDMASTER_T.EDITUSERNAME = entity.FLOW_FLOWRECORDMASTER_T.EDITUSERNAME; //if (entity.FLOW_FLOWRECORDMASTER_T.EDITDATE != null) // Temp[0].FLOW_FLOWRECORDMASTER_T.EDITDATE = entity.FLOW_FLOWRECORDMASTER_T.EDITDATE; //entity = Temp[0]; // entity.EDITDATE = DateTime.Now; entity.FLAG = "1"; FLOW_FLOWRECORDDETAIL_TDAL.Update(entity); //Dal.UpdateFlowRecord(entity); return entity; }
/// <summary> /// 获取流程信息(对数据库操作) /// </summary> /// <param name="FormID">表单ID</param> /// <param name="FlowGUID">明细ID</param> /// <param name="CheckState">审批状态(同意:1,不同意:0 ,未处理:2,会签同意7,会签不同意8)</param> /// <param name="Flag">审批状态(已审批:1,未审批:0)</param> /// <param name="ModelCode">模块代码</param> /// <param name="CompanyID">创建公司ID</param> /// <param name="EditUserID">操作人</param> /// <param name="FlowType">流程类型(0:审批流程,1:任务流程)</param> /// <returns></returns> public static List<FLOW_FLOWRECORDDETAIL_T> GetFlowInfo( string FormID, string FlowGUID, string CheckState, string Flag, string ModelCode, string CompanyID, string EditUserID, List<FlowType> FlowType) { try { List<string> FlowTypeList = new List<string>(); FLOW_FLOWRECORDDETAIL_TDAL Dal = new FLOW_FLOWRECORDDETAIL_TDAL(); var dt = FLOW_FLOWRECORDDETAIL_TDAL.GetFlowRecord( FormID, FlowGUID, CheckState, Flag, ModelCode, CompanyID, EditUserID, FlowUtility.FlowTypeListToStringList(FlowType)); if (dt.Count > 0) return dt; return null; } catch (Exception ex) { Tracer.Debug("获取流程信息GetFlowInfo异常信息(FormID=" + FormID + ";ModelCode=" + ModelCode + ";CompanyID=" + CompanyID + ";EditUserID=" + EditUserID + "):" + ex.Message); throw new Exception("获取流程信息出错,请联系管理员! \r\n FormID=" + FormID + ""); } }