コード例 #1
0
ファイル: InterfacesOld.cs プロジェクト: uunniie/ctnew
        /// <summary>
        /// 插入并行环节
        /// </summary>
        /// <param name="formId">票单号</param>
        /// <param name="supportInfo">支持人ID>、支持组ID</param>
        /// <param name="instanceEntity"> </param>
        /// <param name="currentDealPerson">当前处理人(id,name)</param>
        /// <returns></returns>
        public static bool InsertParallelStates(Guid formId, Dictionary<string, string> supportInfo, WfInstanceEntity instanceEntity, out Dictionary<string, string> currentDealPerson)
        {
            currentDealPerson = new Dictionary<string, string>();
            try
            {
                var result = false;

                if (supportInfo != null && supportInfo.Count > 0)
                {
                    // var instanceEntity = WfInstanceBusiness.GetWfInstanceBusinessByFormID(formId);

                    foreach (KeyValuePair<string, string> support in supportInfo)
                    {
                        var supportGroup =
                            WfSupportGroupBusiness.GetWfSupportGroup(new Guid(support.Value));
                        var stateEntity = WfInstanceStatesBusiness.GetLastWfInstanceStateByFormID(formId);
                        var supportEntity = WfSupportGroupMembersBusiness.GetEntity(new Guid(support.Value), support.Key);

                        var instanceState = new WfInstanceStatesEntity();

                        instanceState.ID = Guid.NewGuid();
                        instanceState.InstanceID = instanceEntity.InstanceID;
                        instanceState.FormID = formId;
                        instanceState.RunState = instanceEntity.CurrentRunState;
                        instanceState.WfState = instanceEntity.CurrentWfState;
                        //  instanceState.WfDealWayId = Guid.Empty;
                        instanceState.TransactType = string.Empty;
                        instanceState.StateDescription = string.Empty;
                        instanceState.DealPersonLevel = supportGroup.SupportGroupLevel;
                        //    stateEntity.DealDeptLevel = supportGroup.;
                        instanceState.TransactUserID = Guid.Parse(support.Key);
                        instanceState.TransactUserName = supportEntity.GroupMemberName;
                        instanceState.TransactDepartmentID = Guid.Parse(supportGroup.DepartmentID);
                        instanceState.TransactDepartmentName = supportGroup.DepartmentName;
                        //    stateEntity.TransactDepartmentName = supportGroup.;
                        instanceState.CreateTime = stateEntity.CompleteTime;
                        // instanceState.CompleteTime = DateTime.MinValue;

                        instanceState.IsDeleted = false;
                        instanceState.BlankCol1 = string.Empty;
                        instanceState.BlankCol2 = string.Empty;
                        instanceState.BlankCol3 = string.Empty;
                        instanceState.BlankCol4 = string.Empty;

                        currentDealPerson.Add(instanceState.TransactUserID.ToString(), instanceState.TransactUserName);
                        result = WfInstanceStatesBusiness.Add(instanceState);
                    }
                }
                return result;
            }
            catch (Exception exception)
            {
                LogWritter.WriteSystemExceptionLog(exception);
                return false;
            }
        }
コード例 #2
0
ファイル: WfInstanceBusiness.cs プロジェクト: uunniie/ctnew
        /// <summary>
        /// 获取实体信息
        /// </summary>
        /// <param name="row">数据行</param>
        /// <returns></returns>
        public static WfInstanceEntity GetEntity(DataRow row)
        {
            WfInstanceEntity entity = new WfInstanceEntity();

            if (row["InstanceID"] != DBNull.Value)
                entity.InstanceID = Guid.Parse(row["InstanceID"].ToString());
            if (row["TemplateID"] != DBNull.Value)
                entity.TemplateID = Guid.Parse(row["TemplateID"].ToString());
            if (row["FormID"] != DBNull.Value)
                entity.FormID = Guid.Parse(row["FormID"].ToString());
            if (row["StartUserID"] != DBNull.Value)
                entity.StartUserID = Guid.Parse(row["StartUserID"].ToString());
            entity.StartUserName = row["StartUserName"].ToString();
            if (row["StartDepartmentID"] != DBNull.Value)
                entity.StartDepartmentID = Guid.Parse(row["StartDepartmentID"].ToString());
            entity.StartDepartmentName = row["StartDepartmentName"].ToString();
            if (row["StartPreMapDeptID"] != DBNull.Value)
                entity.StartPreMapDeptID = Guid.Parse(row["StartPreMapDeptID"].ToString());
            entity.StartPreMapDeptName = row["StartPreMapDeptName"].ToString();
            entity.StartPreMapDeptAllPathName = row["StartPreMapDeptAllPathName"].ToString();
            if (row["StartTime"] != DBNull.Value)
                entity.StartTime = Convert.ToDateTime(row["StartTime"]);
            entity.CurrentRunState = row["CurrentRunState"].ToString();
            if (row["CurrentWfState"] != DBNull.Value)
                entity.CurrentWfState = Guid.Parse(row["CurrentWfState"].ToString());
            if (row["CurrentDealDeptLevel"] != DBNull.Value)
                entity.CurrentDealDeptLevel = Convert.ToInt32(row["CurrentDealDeptLevel"]);
            if (row["CurrentDealPersonLevel"] != DBNull.Value)
                entity.CurrentDealPersonLevel = Convert.ToInt32(row["CurrentDealPersonLevel"]);
            entity.CurrentDealPersonID = row["CurrentDealPersonID"].ToString();
            entity.CurrentDealPersonName = row["CurrentDealPersonName"].ToString();
            entity.CurrentDealDeptId = row["CurrentDealDeptId"].ToString();
            entity.CurrentDealDeptName = row["CurrentDealDeptName"].ToString();
            if (row["CompleteTime"] != DBNull.Value)
                entity.CompleteTime = Convert.ToDateTime(row["CompleteTime"]);
            if (row["IsDeleted"] != DBNull.Value)
                entity.IsDeleted = Convert.ToBoolean(row["IsDeleted"]);
            if (row["CurrentStateType"] != DBNull.Value)
                entity.CurrentStateType = Convert.ToInt32(row["CurrentStateType"]);
            if (row["CurrentParallelCount"] != DBNull.Value)
                entity.CurrentParallelCount = Convert.ToInt32(row["CurrentParallelCount"]);
            if (row["TemBusiRelationId"] != DBNull.Value)
                entity.TemBusiRelationId = Guid.Parse(row["TemBusiRelationId"].ToString());
            entity.BusinessType = row["BusinessType"].ToString();
            entity.BusinessNo = row["BusinessNo"].ToString();
            if (row["ParentInstanceId"] != DBNull.Value)
                entity.ParentInstanceId = Guid.Parse(row["ParentInstanceId"].ToString());

            return entity;
        }
コード例 #3
0
ファイル: InterfacesOld.cs プロジェクト: uunniie/ctnew
        /// <summary>
        /// 驱动并发的子流程
        /// </summary>
        private static bool ParalleStateDealNew(WfInstanceEntity wfInstanceEntity,
            WfInstanceStatesEntity wfInstanceStatesEntity, List<DealPersonInfo> dealPersonInfo)
        {
            try
            {
                var sql =
                    string.Format(
                        "  select WfInstanceId from WF_Messages with (nolock) where FormID='{0}'  and ReceiveDeptId='{1}' and ReceiveUserId='{2}' and MessageType={3} ",
                        wfInstanceEntity.FormID, wfInstanceStatesEntity.TransactDepartmentID, wfInstanceStatesEntity.TransactUserID, (int)EnumWfMessageType.WaitForDo);
                var instanceId = DataHelper.ExecuteScalar(sql) == null ? Guid.Empty : new Guid(DataHelper.ExecuteScalar(sql).ToString());

                var sb = new StringBuilder();
                if (dealPersonInfo != null && dealPersonInfo.Count > 0)
                {
                    foreach (var personInfo in dealPersonInfo)
                    {
                        sb.Append(personInfo.PersonId + "," + personInfo.PersonName + "," + personInfo.DeptId + "," +
                                  personInfo.DeptName);
                        sb.Append("$");
                    }
                }

                wfInstanceEntity.InstanceID = instanceId;
                wfInstanceStatesEntity.InstanceID = instanceId;
                var flowData = new FlowData
                {
                    WFInstance = wfInstanceEntity,
                    WfInstanceStates = wfInstanceStatesEntity,
                    ParallelBranchesCount = 0,
                    DealPersonInfo = sb.ToString()
                };
                var inputParameter = new Dictionary<string, object>
                                             {
                                                 {"FlowDataParm", flowData},
                                                 {"NextDeptType", ""},
                                                 {  "DealWay",  wfInstanceStatesEntity.WfDealWayId.ToString().ToUpper() }
                                             };

                var cswfTemplateEntity =
                    WfTemplateDataBusiness.GetWfTemplateDataByTemplateID(wfInstanceEntity.TemplateID);

                var activity = GetActivity(cswfTemplateEntity.TemplateData);
                var instance = new WorkflowApplication(activity);
                var instanceStore = new SqlWorkflowInstanceStore(DataHelper.CONNECTION_STRING);
                instanceStore.InstanceLockedExceptionAction = InstanceLockedExceptionAction.AggressiveRetry;
                instanceStore.HostLockRenewalPeriod = TimeSpan.FromSeconds(30); //解决再次load时lock的问题
                instance.InstanceStore = instanceStore;
                instance.PersistableIdle = (waiea) => PersistableIdleAction.Unload;
                instance.Load(wfInstanceEntity.InstanceID);
                instance.ResumeBookmark("GetFlowData", inputParameter);

                return false;
            }
            catch (Exception ex)
            {
                LogWritter.WriteSystemExceptionLog(ex);
                throw ex;
            }
        }
コード例 #4
0
ファイル: InterfacesOld.cs プロジェクト: uunniie/ctnew
        /// <summary>
        /// 转入处理
        /// </summary>
        private static void Snatch(WfInstanceEntity wfInstanceEntity,
            WfInstanceStatesEntity wfInstanceStatesEntity)
        {
            if (wfInstanceEntity.CurrentStateType == (int)EnumWfStateType.Parllel)  //并行状态处理
            {

                var sql =
                    string.Format(
                        " select * from WF_InstanceStates with (nolock) where FormID='{0}' and WfState='{1}' and  UPPER(TransactUserID) in" +
                        " (select UPPER(GroupMemberID)  from WF_SupportGroupMembers with (nolock) " +
                        " where SupportGroupID=(select SupportGroupID  from WF_SupportGroupMembers with (nolock) where GroupMemberID='{2}'))",
                        wfInstanceEntity.FormID, wfInstanceEntity.CurrentWfState, wfInstanceStatesEntity.TransactUserID);

                var dt = DataHelper.ExecuteQuery(sql);

                if (dt != null && dt.Rows.Count > 0)
                {
                    sql =
                   string.Format(
                       " update WF_InstanceStates set TransactUserID='{0}',TransactUserName='******' " +
                       " where InstanceID='{2}' and FormID='{3}' and TransactUserID='{4}' and CompleteTime is null ",
                       wfInstanceStatesEntity.TransactUserID, wfInstanceStatesEntity.TransactUserName,
                       wfInstanceEntity.InstanceID, wfInstanceEntity.FormID, dt.Rows[0]["TransactUserID"]
                       );
                    DataHelper.ExecuteNoneQuery(sql);
                }
            }
            else
            {
                wfInstanceEntity.CurrentDealPersonName = wfInstanceStatesEntity.TransactUserName;
                wfInstanceEntity.CurrentDealPersonID = wfInstanceStatesEntity.TransactUserID.ToString();
                wfInstanceEntity.CurrentDealDeptId = wfInstanceStatesEntity.TransactDepartmentID.ToString();
                wfInstanceEntity.CurrentDealDeptName = wfInstanceStatesEntity.TransactDepartmentName;

                WfInstanceBusiness.UpdateWfInstanceBusiness(wfInstanceEntity);
                //  wfInstanceStatesEntity.StateDescription = "转入票单";
                wfInstanceStatesEntity.CompleteTime = DateTime.Now;
                WfInstanceStatesBusiness.Add(wfInstanceStatesEntity);
            }
        }
コード例 #5
0
ファイル: InterfacesNew.cs プロジェクト: uunniie/ctnew
        private static void DriveWorkFlowNew(WfInstanceEntity wfInstanceEntity,
            WfInstanceStatesEntity wfInstanceStatesEntity, List<DealPersonInfo> dealPersonInfo, List<Guid> parallelDeptGuid)
        {
            try
            {
                var sb = new StringBuilder();
                if (dealPersonInfo != null && dealPersonInfo.Count > 0)
                {
                    foreach (var personInfo in dealPersonInfo)
                    {
                        sb.Append(personInfo.PersonId + "," + personInfo.PersonName + "," + personInfo.DeptId + "," +
                                  personInfo.DeptName);
                        sb.Append("$");
                    }

                }
                var parallelBranchesCount = 0;
                if (wfInstanceEntity.CurrentStateType == (int)EnumWfStateType.Parllel) //并行状态处理
                {
                    if (dealPersonInfo != null && dealPersonInfo.Count > 0)
                    {
                        parallelBranchesCount = dealPersonInfo.Count;
                    }
                }

                //var isContinueWf = true;
                //if (wfInstanceEntity.CurrentStateType == (int) EnumWfStateType.Parllel) //并行状态处理
                //{
                //    isContinueWf = ParalleStateDealNew(wfInstanceEntity, wfInstanceStatesEntity, dealPersonInfo);
                //}

                //if (isContinueWf)
                //{
                var flowData = new FlowData
                {
                    WFInstance = wfInstanceEntity,
                    WfInstanceStates = wfInstanceStatesEntity,
                    ParallelBranchesCount = parallelBranchesCount,
                    DealPersonInfo = sb.ToString()
                };
                var inputParameter = new Dictionary<string, object>
                                             {
                                                 {"FlowDataParm", flowData},
                                                 {"NextDeptType", ""},
                                                 {  "DealWay",  wfInstanceStatesEntity.WfDealWayId.ToString().ToUpper() }
                                             };

                var cswfTemplateEntity =
                    WfTemplateDataBusiness.GetWfTemplateDataByTemplateID(wfInstanceEntity.TemplateID);

                var activity = GetActivity(cswfTemplateEntity.TemplateData);
                var instance = new WorkflowApplication(activity);
                var instanceStore = new SqlWorkflowInstanceStore(Common.GetConnectString());
                instanceStore.InstanceLockedExceptionAction = InstanceLockedExceptionAction.AggressiveRetry;
                instanceStore.HostLockRenewalPeriod = TimeSpan.FromSeconds(30); //解决再次load时lock的问题
                instance.InstanceStore = instanceStore;
                instance.PersistableIdle = (waiea) => PersistableIdleAction.Unload;
                instance.Load(wfInstanceEntity.InstanceID);
                instance.ResumeBookmark("GetFlowData", inputParameter);
                // }
            }
            catch (InstanceLockedException lockedException)
            {
                LogWritter.WriteSystemExceptionLog(lockedException);
            }
            catch (Exception ex)
            {
                LogWritter.WriteSystemExceptionLog(ex);
                throw ex;
            }
        }
コード例 #6
0
ファイル: InterfacesOld.cs プロジェクト: uunniie/ctnew
        private static bool ParalleStateDeal(WfInstanceEntity wfInstanceEntity,
            WfInstanceStatesEntity wfInstanceStatesEntity, Dictionary<string, string> supportInfo)
        {
            var isContinue = false;

            var sql =
                string.Format(
                    " select COUNT(*) from WF_InstanceStates with (nolock) where FormID='{0}' and WfState='{1}' and   CompleteTime is  null ",
                    wfInstanceEntity.FormID, wfInstanceEntity.CurrentWfState);

            var result = (int)DataHelper.ExecuteScalar(sql);

            if (result == 1) //最后一个分支
            {
                isContinue = true;
            }

            using (TransactionScope scope = new TransactionScope())
            {

                sql =
                    string.Format(
                        " update WF_InstanceStates set WfDealWayId='{0}',TransactType='{1}',StateDescription='{2}',TransactDepartmentID='{3}'," +
                        "TransactDepartmentName='{4}',CompleteTime='{5}' where InstanceID='{6}' and FormID='{7}' and TransactUserID='{8}' and CompleteTime is null ",
                        wfInstanceStatesEntity.WfDealWayId, wfInstanceStatesEntity.TransactType,
                        wfInstanceStatesEntity.StateDescription,
                        wfInstanceStatesEntity.TransactDepartmentID, wfInstanceStatesEntity.TransactDepartmentName,
                        DateTime.Now, wfInstanceStatesEntity.InstanceID,
                        wfInstanceStatesEntity.FormID, wfInstanceStatesEntity.TransactUserID);
                DataHelper.ExecuteNoneQuery(sql);

                var newEntity = WfInstanceBusiness.GetWfInstanceBusinessByFormID(wfInstanceEntity.FormID);

                newEntity.CurrentDealPersonID =
                    newEntity.CurrentDealPersonID.Replace(wfInstanceStatesEntity.TransactUserID.ToString(), "");
                newEntity.CurrentDealPersonID = newEntity.CurrentDealPersonID.Replace(",,", ",");
                newEntity.CurrentDealPersonID = newEntity.CurrentDealPersonID.TrimStart(',');
                newEntity.CurrentDealPersonID = newEntity.CurrentDealPersonID.TrimEnd(',');

                newEntity.CurrentDealPersonName =
                    newEntity.CurrentDealPersonName.Replace(wfInstanceStatesEntity.TransactUserName, "");
                newEntity.CurrentDealPersonName = newEntity.CurrentDealPersonName.Replace(",,", ",");
                newEntity.CurrentDealPersonName = newEntity.CurrentDealPersonName.TrimStart(',');
                newEntity.CurrentDealPersonName = newEntity.CurrentDealPersonName.TrimEnd(',');

                sql =
                    string.Format(
                        " update WF_Instance set CurrentDealPersonID='{0}', CurrentDealPersonName='{1}'  where  FormID='{2}' ",
                        newEntity.CurrentDealPersonID, newEntity.CurrentDealPersonName,
                        wfInstanceStatesEntity.FormID);

                DataHelper.ExecuteNoneQuery(sql);

                scope.Complete();

            }

            return isContinue;
        }
コード例 #7
0
ファイル: InterfacesFlow.cs プロジェクト: uunniie/ctnew
        /// <summary>
        /// 启动工作流时候的实体赋值
        /// </summary>
        /// <param name="wfInstance"></param>
        /// <param name="wfInstanceStates"></param>
        /// <param name="formId"></param>
        /// <param name="startUserId"></param>
        /// <param name="startUserName"></param>
        /// <param name="startDeptId"></param>
        /// <param name="startDeptName"></param>
        /// <param name="businessType"></param>
        private static void SetStartWfValue(WfInstanceEntity wfInstance, WfInstanceStatesEntity wfInstanceStates, Guid formId, Guid startUserId, string startUserName, Guid startDeptId,
            string startDeptName)
        {
            wfInstance.FormID = formId;
            wfInstance.StartUserID = startUserId;
            wfInstance.StartUserName = startUserName;
            wfInstance.StartDepartmentID = startDeptId;
            wfInstance.StartDepartmentName = startDeptName;
            wfInstance.StartTime = DateTime.Now;
            wfInstance.IsDeleted = false;

            wfInstanceStates.ID = Guid.NewGuid();
            wfInstanceStates.FormID = formId;
            wfInstanceStates.StateDescription = "流程启动";
            wfInstanceStates.TransactUserID = startUserId;
            wfInstanceStates.TransactUserName = startUserName;
            wfInstanceStates.TransactDepartmentID = startDeptId;
            wfInstanceStates.TransactDepartmentName = startDeptName;
            wfInstanceStates.CreateTime = wfInstance.StartTime;
            wfInstanceStates.CompleteTime = wfInstance.StartTime;
            wfInstanceStates.IsDeleted = false;
            wfInstanceStates.BlankCol1 = string.Empty;
            wfInstanceStates.BlankCol2 = string.Empty;
            wfInstanceStates.BlankCol3 = string.Empty;
            wfInstanceStates.BlankCol4 = string.Empty;
        }
コード例 #8
0
ファイル: InterfacesForOut.cs プロジェクト: uunniie/ctnew
        /// <summary>
        /// 
        /// </summary>
        private static void DriveWorkFlowofChange(WfInstanceEntity wfInstanceEntity,
            WfInstanceStatesEntity wfInstanceStatesEntity)
        {
            var sql = string.Format(" select count(FormId) from WF_ModifyStatesInstance where FormId='{0}'   and  ExcuteState<>{1}  ", wfInstanceEntity.FormID, (int)ExcuteState.Excuted);
            if (Convert.ToInt32(DataHelper.ExecuteScalar(sql)) > 0)
            {
                //var stateId = GetCurrentState(wfInstanceEntity.FormID);
                var res = WfModifyStatesInstanceBusiness.Deal(wfInstanceEntity.FormID.ToString(),
                                                              wfInstanceStatesEntity.WfDealWayId.ToString(),
                                                              wfInstanceStatesEntity.TransactUserID.ToString(),
                                                              wfInstanceStatesEntity.StateDescription);

                var result = DataHelper.ExecuteScalar(sql); //所有状态都执行完了,继续主工作流程
                if (res == 0 || Convert.ToInt32(result) == 0)
                {
                    var flowData = new FlowData
                                       {
                                           WFInstance = wfInstanceEntity,
                                           WfInstanceStates = wfInstanceStatesEntity
                                       };
                    var inputParameter = new Dictionary<string, object>
                                             {
                                                 {"FlowDataParm", flowData},
                                                 {"NextDeptType", ""},
                                                 {"DealWay", wfInstanceStatesEntity.WfDealWayId.ToString().ToUpper()}
                                             };

                    var cswfTemplateEntity =
                        WfTemplateDataBusiness.GetWfTemplateDataByTemplateID(wfInstanceEntity.TemplateID);

                    var activity = GetActivity(cswfTemplateEntity.TemplateData);
                    var instance = new WorkflowApplication(activity);
                    var instanceStore = new SqlWorkflowInstanceStore(Common.GetConnectString());
                    instanceStore.InstanceLockedExceptionAction = InstanceLockedExceptionAction.AggressiveRetry;
                    instanceStore.HostLockRenewalPeriod = TimeSpan.FromSeconds(30); //解决再次load时lock的问题
                    instance.InstanceStore = instanceStore;
                    instance.PersistableIdle = (waiea) => PersistableIdleAction.Unload;
                    instance.Load(wfInstanceEntity.InstanceID);
                    instance.ResumeBookmark("GetFlowData", inputParameter);
                }
            }
            else //按照原来的处理方式处理
            {
                var flowData = new FlowData
                {
                    WFInstance = wfInstanceEntity,
                    WfInstanceStates = wfInstanceStatesEntity
                };
                var inputParameter = new Dictionary<string, object>
                                         {
                                             {"FlowDataParm", flowData},
                                             {"NextDeptType", ""},
                                             {"DealWay", wfInstanceStatesEntity.WfDealWayId.ToString().ToUpper()}
                                         };

                var cswfTemplateEntity =
                    WfTemplateDataBusiness.GetWfTemplateDataByTemplateID(wfInstanceEntity.TemplateID);

                var activity = GetActivity(cswfTemplateEntity.TemplateData);
                var instance = new WorkflowApplication(activity);
                var instanceStore = new SqlWorkflowInstanceStore(Common.GetConnectString());
                instanceStore.InstanceLockedExceptionAction = InstanceLockedExceptionAction.AggressiveRetry;
                instanceStore.HostLockRenewalPeriod = TimeSpan.FromSeconds(30); //解决再次load时lock的问题
                instance.InstanceStore = instanceStore;
                instance.PersistableIdle = (waiea) => PersistableIdleAction.Unload;
                instance.Load(wfInstanceEntity.InstanceID);
                instance.ResumeBookmark("GetFlowData", inputParameter);
            }
        }
コード例 #9
0
ファイル: InterfacesFlow.cs プロジェクト: uunniie/ctnew
 /// <summary>
 /// 启动子流程
 /// </summary>
 /// <param name="formId"></param>
 /// <param name="startUserId"></param>
 /// <param name="startUserName"></param>
 /// <param name="startDeptId"></param>
 /// <param name="startDeptName"></param>
 /// <param name="businessType"></param>
 /// <param name="businessNo"></param>
 /// <param name="parentWfIntanceId"></param>
 /// <param name="wftempalteId"></param>
 /// <param name="dealPersons"></param>
 public static void StartWorkFlow(Guid formId, Guid startUserId, string startUserName, Guid startDeptId,
     string startDeptName, string businessType, string businessNo, Guid parentWfIntanceId, Guid wftempalteId, string dealPersons)
 {
     var wfInstance = new WfInstanceEntity();
     var wfInstanceStates = new WfInstanceStatesEntity();
     SetStartWfValue(wfInstance, wfInstanceStates, formId, startUserId, startUserName, startDeptId, startDeptName);
     wfInstance.BusinessType = businessType;
     wfInstance.BusinessNo = businessNo;
     StartWorkFlow(wftempalteId, wfInstance, wfInstanceStates, parentWfIntanceId, dealPersons);
 }
コード例 #10
0
ファイル: InterfacesFlow.cs プロジェクト: uunniie/ctnew
 /// <summary>
 /// 获取流程实例
 /// </summary>
 /// <param name="inputParameters"></param>
 /// <param name="templateId"></param>
 /// <param name="relationId">模板与业务的关系id </param>
 /// <param name="businessType"></param>
 /// <param name="wfInstance"></param>
 /// <returns></returns>
 private static WorkflowApplication GetStartWorkflowApplicationInstance(
     Dictionary<string, object> inputParameters, out Guid templateId, out Guid relationId, string businessType, WfInstanceEntity wfInstance)
 {
     templateId = Guid.Empty;
     relationId = Guid.Empty;
     try
     {
         var dt = GetTeplateData(businessType, wfInstance.StartDepartmentID);
         if (dt != null && dt.Rows.Count > 0)
         {
             templateId = new Guid(dt.Rows[0]["TemplateID"].ToString());
             relationId = new Guid(dt.Rows[0]["RelationId"].ToString());
             var activity = GetActivity(dt.Rows[0]["TemplateData"].ToString());
             var instance = new WorkflowApplication(activity, inputParameters);
             return instance;
         }
         else
         {
             LogWritter.WriteSystemExceptionLog(new Exception("未找到模板"));
             return null;
         }
     }
     catch (Exception ex)
     {
         LogWritter.WriteSystemExceptionLog(ex);
         return null;
     }
 }
コード例 #11
0
ファイル: InterfacesFlow.cs プロジェクト: uunniie/ctnew
 /// <summary>
 /// 对外提供接口,来启动流程实例(工作流来确定使用哪个模板)
 /// </summary>
 /// <param name="formId">表单号guid</param>
 /// <param name="startUserId">操作人ID</param>
 /// <param name="startUserName">操作人名称</param>
 /// <param name="startDeptId">操作人所在单位id</param>
 /// <param name="startDeptName">操作人所在单位名称</param> 
 /// <param name="businessType">具体业务类型,用来确定要使用的流程模板</param>
 /// <param name="businessNo"> 表单号(给人看的)</param> 
 public static void StartWorkFlow(Guid formId, Guid startUserId, string startUserName, Guid startDeptId,
     string startDeptName, Guid startPreMapDeptID, string startPreMapDeptName, string startPreMapDeptAllPathName, string businessType, string businessNo, string dealPersons)
 {
     var wfInstance = new WfInstanceEntity();
     var wfInstanceStates = new WfInstanceStatesEntity();
     SetStartWfValue(wfInstance, wfInstanceStates, formId, startUserId, startUserName, startDeptId, startDeptName, startPreMapDeptID, startPreMapDeptName, startPreMapDeptAllPathName);
     wfInstance.BusinessType = businessType;
     wfInstance.BusinessNo = businessNo;
     StartWorkFlow(wfInstance, wfInstanceStates, businessType, Guid.Empty, dealPersons);
 }
コード例 #12
0
ファイル: InterfacesForOut.cs プロジェクト: uunniie/ctnew
        /// <summary>
        /// 根据指定模板启动工作流
        /// </summary>
        private static void StartWorkFlow(Guid wfTemplateId, WfInstanceEntity wfInstance, WfInstanceStatesEntity wfInstanceStatesEntity)
        {
            try
            {
                var connectionString = Common.GetConnectString();
                WorkflowApplication instance;

                var flowData = new FlowData() { WFInstance = wfInstance, WfInstanceStates = wfInstanceStatesEntity };

                var inputParameter = new Dictionary<string, object>
                                         {
                                             {"FlowDataParm", flowData},
                                             {"NextDeptType", ""},
                                             {"DealWay", wfInstanceStatesEntity.WfDealWayId.ToString().ToUpper()}
                                         };
                instance = GetStartWorkflowApplicationInstanceByTemplateId(wfTemplateId, inputParameter);
                if (instance != null)
                {
                    ((FlowData)inputParameter["FlowDataParm"]).WFInstance.InstanceID = instance.Id;
                    ((FlowData)inputParameter["FlowDataParm"]).WfInstanceStates.InstanceID = instance.Id;
                    ((FlowData)inputParameter["FlowDataParm"]).WFInstance.TemplateID = wfTemplateId;
                    var instanceStore = new SqlWorkflowInstanceStore(connectionString);
                    InstanceView view = instanceStore.Execute(instanceStore.CreateInstanceHandle(),
                                                              new CreateWorkflowOwnerCommand(),
                                                              TimeSpan.FromSeconds(30));
                    instanceStore.DefaultInstanceOwner = view.InstanceOwner;

                    instance.InstanceStore = instanceStore;
                    instance.PersistableIdle = (waiea) => PersistableIdleAction.Unload;

                    //   instance.Aborted += InstanceAborted;
                    instance.Run();
                }
                else
                {
                    throw new Exception("未找到对应的流程模板!请与系统管理员联系。");
                }

            }
            catch (Exception ex)
            {
                LogWritter.WriteSystemExceptionLog(ex);
                throw new Exception("生成流程异常:" + ex.Message, ex.InnerException);
            }
        }
コード例 #13
0
ファイル: InterfacesForOut.cs プロジェクト: uunniie/ctnew
 /// <summary>
 /// 转入处理
 /// </summary>
 private static void Snatch(WfInstanceEntity wfInstanceEntity,
     WfInstanceStatesEntity wfInstanceStatesEntity)
 {
     wfInstanceEntity.CurrentDealPersonName = wfInstanceStatesEntity.TransactUserName;
     wfInstanceEntity.CurrentDealPersonID = wfInstanceStatesEntity.TransactUserID.ToString();
     wfInstanceEntity.CurrentDealDeptId = wfInstanceStatesEntity.TransactDepartmentID.ToString();
     wfInstanceEntity.CurrentDealDeptName = wfInstanceStatesEntity.TransactDepartmentName;
     WfInstanceBusiness.UpdateWfInstanceBusiness(wfInstanceEntity);
     //  wfInstanceStatesEntity.StateDescription = "转入票单";
     WfInstanceStatesBusiness.Add(wfInstanceStatesEntity);
 }
コード例 #14
0
ファイル: WfInstanceBusiness.cs プロジェクト: uunniie/ctnew
        /// <summary>
        /// 增加工作流当前处理状态基本信息
        /// </summary>
        /// <param name="wfInstance">工作流当前处理状态基本信息对象实体</param>
        public static bool Add(WfInstanceEntity entity)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into WF_Instance (");
            strSql.Append(" InstanceID,  TemplateID,  FormID,  StartUserID,  StartUserName,  StartDepartmentID,  StartDepartmentName,  StartPreMapDeptID,  StartPreMapDeptName,  StartPreMapDeptAllPathName,  StartTime,  CurrentRunState,  CurrentWfState,  CurrentDealDeptLevel,  CurrentDealPersonLevel,  CurrentDealPersonID,  CurrentDealPersonName,  CurrentDealDeptId,  CurrentDealDeptName,  CompleteTime,  IsDeleted,  CurrentStateType,  CurrentParallelCount,  TemBusiRelationId,  BusinessType,  BusinessNo,  ParentInstanceId)");
            strSql.Append(" values ( ");
            strSql.Append("@InstanceID, @TemplateID, @FormID, @StartUserID, @StartUserName, @StartDepartmentID, @StartDepartmentName, @StartPreMapDeptID, @StartPreMapDeptName, @StartPreMapDeptAllPathName, @StartTime, @CurrentRunState, @CurrentWfState, @CurrentDealDeptLevel, @CurrentDealPersonLevel, @CurrentDealPersonID, @CurrentDealPersonName, @CurrentDealDeptId, @CurrentDealDeptName, @CompleteTime, @IsDeleted, @CurrentStateType, @CurrentParallelCount, @TemBusiRelationId, @BusinessType, @BusinessNo, @ParentInstanceId)");

            SqlParameter[] parameters = {
                new SqlParameter("@InstanceID", SqlDbType.UniqueIdentifier),
                new SqlParameter("@TemplateID", SqlDbType.UniqueIdentifier),
                new SqlParameter("@FormID", SqlDbType.UniqueIdentifier),
                new SqlParameter("@StartUserID", SqlDbType.UniqueIdentifier),
                new SqlParameter("@StartUserName", SqlDbType.NVarChar),
                new SqlParameter("@StartDepartmentID", SqlDbType.UniqueIdentifier),
                new SqlParameter("@StartDepartmentName", SqlDbType.NVarChar),
                new SqlParameter("@StartPreMapDeptID", SqlDbType.UniqueIdentifier),
                new SqlParameter("@StartPreMapDeptName", SqlDbType.NVarChar),
                new SqlParameter("@StartPreMapDeptAllPathName", SqlDbType.NVarChar),
                new SqlParameter("@StartTime", SqlDbType.DateTime),
                new SqlParameter("@CurrentRunState", SqlDbType.VarChar),
                new SqlParameter("@CurrentWfState", SqlDbType.UniqueIdentifier),
                new SqlParameter("@CurrentDealDeptLevel", SqlDbType.Int),
                new SqlParameter("@CurrentDealPersonLevel", SqlDbType.Int),
                new SqlParameter("@CurrentDealPersonID", SqlDbType.VarChar),
                new SqlParameter("@CurrentDealPersonName", SqlDbType.NVarChar),
                new SqlParameter("@CurrentDealDeptId", SqlDbType.VarChar),
                new SqlParameter("@CurrentDealDeptName", SqlDbType.NVarChar),
                new SqlParameter("@CompleteTime", SqlDbType.DateTime),
                new SqlParameter("@IsDeleted", SqlDbType.Bit),
                new SqlParameter("@CurrentStateType", SqlDbType.Int),
                new SqlParameter("@CurrentParallelCount", SqlDbType.Int),
                new SqlParameter("@TemBusiRelationId", SqlDbType.UniqueIdentifier),
                new SqlParameter("@BusinessType", SqlDbType.VarChar),
                new SqlParameter("@BusinessNo", SqlDbType.VarChar),
                new SqlParameter("@ParentInstanceId", SqlDbType.UniqueIdentifier)
            };

            int i = 0;
            parameters[i++].Value = entity.InstanceID;
            parameters[i++].Value = entity.TemplateID;
            parameters[i++].Value = entity.FormID;
            parameters[i++].Value = entity.StartUserID;
            parameters[i++].Value = entity.StartUserName;
            parameters[i++].Value = entity.StartDepartmentID;
            parameters[i++].Value = entity.StartDepartmentName;
            parameters[i++].Value = entity.StartPreMapDeptID;
            parameters[i++].Value = entity.StartPreMapDeptName;
            parameters[i++].Value = entity.StartPreMapDeptAllPathName;
            if (entity.StartTime == DateTime.MinValue)
                entity.StartTime = (DateTime)SqlDateTime.MinValue;
            parameters[i++].Value = entity.StartTime;
            parameters[i++].Value = entity.CurrentRunState;
            parameters[i++].Value = entity.CurrentWfState;
            parameters[i++].Value = entity.CurrentDealDeptLevel;
            parameters[i++].Value = entity.CurrentDealPersonLevel;
            parameters[i++].Value = entity.CurrentDealPersonID;
            parameters[i++].Value = entity.CurrentDealPersonName;
            parameters[i++].Value = entity.CurrentDealDeptId;
            parameters[i++].Value = entity.CurrentDealDeptName;
            if (entity.CompleteTime != DateTime.MinValue)
            {
                parameters[i++].Value = entity.CompleteTime;
            }
            else
            {
                i++;
            }
            parameters[i++].Value = entity.IsDeleted;
            parameters[i++].Value = entity.CurrentStateType;
            parameters[i++].Value = entity.CurrentParallelCount;
            parameters[i++].Value = entity.TemBusiRelationId;
            parameters[i++].Value = entity.BusinessType;
            parameters[i++].Value = entity.BusinessNo;
            parameters[i++].Value = entity.ParentInstanceId;

            return DataHelper.ExecuteNoneQuery(strSql.ToString(), parameters) > 0;
        }
コード例 #15
0
ファイル: InterfacesFlow.cs プロジェクト: uunniie/ctnew
        /// <summary>
        /// 根据指定模板启动工作流
        /// </summary>
        private static void StartWorkFlow(Guid wfTemplateId, WfInstanceEntity wfInstance, WfInstanceStatesEntity wfInstanceStatesEntity, Guid parentWfInstaceId, string dealPersons)
        {
            try
            {
                var connectionString = DataHelper.CONNECTION_STRING;
                WorkflowApplication instance;
                var dealPersonInfo = dealPersons;
                var flowData = new FlowData()
                {
                    WFInstance = wfInstance,
                    WfInstanceStates = wfInstanceStatesEntity,
                    DealPersonInfo = dealPersonInfo,
                    ParallelBranchesCount = 0
                };

                var inputParameter = new Dictionary<string, object>
                                         {
                                             {"FlowDataParm", flowData},
                                             {"NextDeptType", ""},
                                             {"DealWay", wfInstanceStatesEntity.WfDealWayId.ToString().ToUpper()}
                                         };
                instance = GetStartWorkflowApplicationInstanceByTemplateId(wfTemplateId, inputParameter);
                if (instance != null)
                {
                    ((FlowData)inputParameter["FlowDataParm"]).WFInstance.InstanceID = instance.Id;
                    ((FlowData)inputParameter["FlowDataParm"]).WfInstanceStates.InstanceID = instance.Id;
                    ((FlowData)inputParameter["FlowDataParm"]).WFInstance.TemplateID = wfTemplateId;
                    var instanceStore = new SqlWorkflowInstanceStore(connectionString);
                    InstanceView view = instanceStore.Execute(instanceStore.CreateInstanceHandle(),
                                                              new CreateWorkflowOwnerCommand(),
                                                              TimeSpan.FromSeconds(30));
                    instanceStore.DefaultInstanceOwner = view.InstanceOwner;

                    instance.InstanceStore = instanceStore;
                    instance.PersistableIdle = (waiea) => PersistableIdleAction.Unload;

                    //   instance.Aborted += InstanceAborted;

                    if (parentWfInstaceId != Guid.Empty)   //写流程实例关系表
                    {
                        //WriteWfInstanceRelation(parentWfInstaceId,instance.Id,wfInstance.FormID);
                        ((FlowData)inputParameter["FlowDataParm"]).WFInstance.ParentInstanceId = parentWfInstaceId;
                    }

                    instance.Run();
                }
                else
                {
                    throw new Exception("未找到对应的流程模板!请与系统管理员联系。");
                }

            }
            catch (Exception ex)
            {
                LogWritter.WriteSystemExceptionLog(ex);
                throw new Exception("生成流程异常:" + ex.Message, ex.InnerException);
            }
        }
コード例 #16
0
ファイル: WfInstanceBusiness.cs プロジェクト: uunniie/ctnew
        public static bool UpdateWfInstanceBusinessByFormId(WfInstanceEntity entity)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update WF_Instance set ");
            strSql.Append("InstanceID = @InstanceID, ");
            strSql.Append("TemplateID = @TemplateID, ");
            strSql.Append("FormID = @FormID, ");
            strSql.Append("StartUserID = @StartUserID, ");
            strSql.Append("StartUserName = @StartUserName, ");
            strSql.Append("StartDepartmentID = @StartDepartmentID, ");
            strSql.Append("StartDepartmentName = @StartDepartmentName, ");
            strSql.Append("StartPreMapDeptID = @StartPreMapDeptID, ");
            strSql.Append("StartPreMapDeptName = @StartPreMapDeptName, ");
            strSql.Append("StartPreMapDeptAllPathName = @StartPreMapDeptAllPathName, ");
            strSql.Append("StartTime = @StartTime, ");
            strSql.Append("CurrentRunState = @CurrentRunState, ");
            strSql.Append("CurrentWfState = @CurrentWfState, ");
            strSql.Append("CurrentDealDeptLevel = @CurrentDealDeptLevel, ");
            strSql.Append("CurrentDealPersonLevel = @CurrentDealPersonLevel, ");
            strSql.Append("CurrentDealPersonID = @CurrentDealPersonID, ");
            strSql.Append("CurrentDealPersonName = @CurrentDealPersonName, ");
            strSql.Append("CurrentDealDeptId = @CurrentDealDeptId, ");
            strSql.Append("CurrentDealDeptName = @CurrentDealDeptName, ");
            strSql.Append("CompleteTime = @CompleteTime, ");
            strSql.Append("IsDeleted = @IsDeleted, ");
            strSql.Append("CurrentStateType = @CurrentStateType, ");
            strSql.Append("CurrentParallelCount = @CurrentParallelCount, ");
            strSql.Append("TemBusiRelationId = @TemBusiRelationId, ");
            strSql.Append("BusinessType = @BusinessType, ");
            strSql.Append("BusinessNo = @BusinessNo, ");
            strSql.Append("ParentInstanceId = @ParentInstanceId");
            strSql.Append(" where ");
            strSql.Append(" FormID = @FormID ");

            SqlParameter[] parameters = {
                new SqlParameter("@InstanceID", SqlDbType.UniqueIdentifier),
                new SqlParameter("@TemplateID", SqlDbType.UniqueIdentifier),
                new SqlParameter("@FormID", SqlDbType.UniqueIdentifier),
                new SqlParameter("@StartUserID", SqlDbType.UniqueIdentifier),
                new SqlParameter("@StartUserName", SqlDbType.NVarChar),
                new SqlParameter("@StartDepartmentID", SqlDbType.UniqueIdentifier),
                new SqlParameter("@StartDepartmentName", SqlDbType.NVarChar),
                new SqlParameter("@StartPreMapDeptID", SqlDbType.UniqueIdentifier),
                new SqlParameter("@StartPreMapDeptName", SqlDbType.NVarChar),
                new SqlParameter("@StartPreMapDeptAllPathName", SqlDbType.NVarChar),
                new SqlParameter("@StartTime", SqlDbType.DateTime),
                new SqlParameter("@CurrentRunState", SqlDbType.VarChar),
                new SqlParameter("@CurrentWfState", SqlDbType.UniqueIdentifier),
                new SqlParameter("@CurrentDealDeptLevel", SqlDbType.Int),
                new SqlParameter("@CurrentDealPersonLevel", SqlDbType.Int),
                new SqlParameter("@CurrentDealPersonID", SqlDbType.VarChar),
                new SqlParameter("@CurrentDealPersonName", SqlDbType.NVarChar),
                new SqlParameter("@CurrentDealDeptId", SqlDbType.VarChar),
                new SqlParameter("@CurrentDealDeptName", SqlDbType.NVarChar),
                new SqlParameter("@CompleteTime", SqlDbType.DateTime),
                new SqlParameter("@IsDeleted", SqlDbType.Bit),
                new SqlParameter("@CurrentStateType", SqlDbType.Int),
                new SqlParameter("@CurrentParallelCount", SqlDbType.Int),
                new SqlParameter("@TemBusiRelationId", SqlDbType.UniqueIdentifier),
                new SqlParameter("@BusinessType", SqlDbType.VarChar),
                new SqlParameter("@BusinessNo", SqlDbType.VarChar),
                new SqlParameter("@ParentInstanceId", SqlDbType.UniqueIdentifier)
            };

            int i = 0;
            parameters[i++].Value = entity.InstanceID;
            parameters[i++].Value = entity.TemplateID;
            parameters[i++].Value = entity.FormID;
            parameters[i++].Value = entity.StartUserID;
            parameters[i++].Value = entity.StartUserName;
            parameters[i++].Value = entity.StartDepartmentID;
            parameters[i++].Value = entity.StartDepartmentName;
            parameters[i++].Value = entity.StartPreMapDeptID;
            parameters[i++].Value = entity.StartPreMapDeptName;
            parameters[i++].Value = entity.StartPreMapDeptAllPathName;
            if (entity.StartTime == DateTime.MinValue)
                entity.StartTime = (DateTime)SqlDateTime.MinValue;
            parameters[i++].Value = entity.StartTime;
            parameters[i++].Value = entity.CurrentRunState;
            parameters[i++].Value = entity.CurrentWfState;
            parameters[i++].Value = entity.CurrentDealDeptLevel;
            parameters[i++].Value = entity.CurrentDealPersonLevel;
            parameters[i++].Value = entity.CurrentDealPersonID;
            parameters[i++].Value = entity.CurrentDealPersonName;
            parameters[i++].Value = entity.CurrentDealDeptId;
            parameters[i++].Value = entity.CurrentDealDeptName;
            if (entity.CompleteTime != DateTime.MinValue)
            {
                parameters[i++].Value = entity.CompleteTime;
            }
            else
            {
                i++;
            }
            parameters[i++].Value = entity.IsDeleted;
            parameters[i++].Value = entity.CurrentStateType;
            parameters[i++].Value = entity.CurrentParallelCount;
            parameters[i++].Value = entity.TemBusiRelationId;
            parameters[i++].Value = entity.BusinessType;
            parameters[i++].Value = entity.BusinessNo;
            parameters[i++].Value = entity.ParentInstanceId;

            return DataHelper.ExecuteNoneQuery(strSql.ToString(), parameters) > 0;
        }
コード例 #17
0
ファイル: InterfacesForOut.cs プロジェクト: uunniie/ctnew
        /// <summary>
        /// 驱动工作流
        /// </summary>
        private static void DriveWorkFlow(WfInstanceEntity wfInstanceEntity,
            WfInstanceStatesEntity wfInstanceStatesEntity)
        {
            try
            {
                //var businessType = wfInstanceEntity.BusinessType;
                //if (businessType == 5 || businessType == 6)
                //{
                //    DriveWorkFlowofChange(wfInstanceEntity, wfInstanceStatesEntity);
                //}
                //else
                //{
                //    if (wfInstanceStatesEntity.WfDealWayId == Guid.Empty) //转入,只更改处理人,不走流程,即:有权限的人把票单改到自己名下处理
                //    {
                //        Snatch(wfInstanceEntity, wfInstanceStatesEntity);
                //    }
                //    else
                //    {
                //        var flowData = new FlowData
                //                           {
                //                               WFInstance = wfInstanceEntity,
                //                               WfInstanceStates = wfInstanceStatesEntity
                //                           };
                //        var inputParameter = new Dictionary<string, object>
                //                                 {
                //                                     {"FlowDataParm", flowData},
                //                                     {"NextDeptType", ""},
                //                                     {
                //                                         "DealWay", wfInstanceStatesEntity.WfDealWayId.ToString().ToUpper()
                //                                     }
                //                                 };

                //        var cswfTemplateEntity =
                //            WfTemplateDataBusiness.GetWfTemplateDataByTemplateID(wfInstanceEntity.TemplateID);

                //        var activity = GetActivity(cswfTemplateEntity.TemplateData);
                //        var instance = new WorkflowApplication(activity);
                //        var instanceStore = new SqlWorkflowInstanceStore(Common.GetConnectString());
                //        instanceStore.InstanceLockedExceptionAction = InstanceLockedExceptionAction.AggressiveRetry;
                //        instanceStore.HostLockRenewalPeriod = TimeSpan.FromSeconds(30); //解决再次load时lock的问题
                //        instance.InstanceStore = instanceStore;
                //        instance.PersistableIdle = (waiea) => PersistableIdleAction.Unload;
                //        instance.Load(wfInstanceEntity.InstanceID);
                //        instance.ResumeBookmark("GetFlowData", inputParameter);
                //    }
                //}
            }
            catch (InstanceLockedException lockedException)
            {
                LogWritter.WriteSystemExceptionLog(lockedException);
            }
            catch (Exception ex)
            {
                LogWritter.WriteSystemExceptionLog(ex);
                throw ex;
            }
        }