Exemplo n.º 1
0
        private static string GetInsertSql(WfPersistQueue pq)
        {
            ORMappingItemCollection mappingInfo = ORMapping.GetMappingInfo(pq.GetType());

            string sql = string.Format("INSERT INTO {0}(PROCESS_ID, UPDATE_TAG, TENANT_CODE) SELECT INSTANCE_ID, UPDATE_TAG, TENANT_CODE FROM WF.PROCESS_INSTANCES WHERE INSTANCE_ID = {1}",
                                       mappingInfo.TableName,
                                       TSqlBuilder.Instance.CheckUnicodeQuotationMark(pq.ProcessID));

            return(sql);
        }
Exemplo n.º 2
0
        public static WfPersistQueue FromProcess(IWfProcess process)
        {
            process.NullCheck("process");

            WfPersistQueue result = new WfPersistQueue();

            result.ProcessID = process.ID;

            return(result);
        }
Exemplo n.º 3
0
        private static string GetUpdatePersistQueueSql(WfPersistQueue pq)
        {
            StringBuilder sql = new StringBuilder();

            //仅仅插入数据
            //sql.Append(GetUpdateSql(pq));
            //sql.Append(TSqlBuilder.Instance.DBStatementSeperator);
            //sql.Append("IF @@ROWCOUNT = 0");
            //sql.Append(TSqlBuilder.Instance.DBStatementBegin);
            sql.Append(GetInsertSql(pq));
            //sql.Append(TSqlBuilder.Instance.DBStatementEnd);

            return(sql.ToString());
        }
Exemplo n.º 4
0
        public void UpdatePersistQueue(IWfProcess process)
        {
            process.NullCheck("process");

            WfPersistQueue pq = WfPersistQueue.FromProcess(process);

            string sql = GetUpdatePersistQueueSql(pq);

            using (TransactionScope scope = TransactionScopeFactory.Create())
            {
                DbHelper.RunSql(sql, GetConnectionName());

                scope.Complete();
            }
        }
Exemplo n.º 5
0
        /// <summary>
        /// 执行一项队列操作
        /// </summary>
        /// <param name="pq"></param>
        public void DoQueueOperation(WfPersistQueue pq)
        {
            pq.NullCheck("pq");

            Dictionary <object, object> context = new Dictionary <object, object>();

            IWfProcess process = WfRuntime.GetProcessByProcessID(pq.ProcessID);

            try
            {
                WfQueuePersistenceSettings.GetConfig().GetPersisters().SaveData(process, context);
            }
            finally
            {
                WfRuntime.ClearCache();
            }
        }
Exemplo n.º 6
0
        private static string GetUpdateSql(WfPersistQueue pq)
        {
            ORMappingItemCollection mappingInfo = ORMapping.GetMappingInfo(pq.GetType());

            UpdateSqlClauseBuilder uBuilder = ORMapping.GetUpdateSqlClauseBuilder(pq, mappingInfo, "UpdateTag");

            uBuilder.AppendItem("UPDATE_TAG", "WF.PROCESS_INSTANCES.UPDATE_TAG", "=", true);

            WhereSqlClauseBuilder wBuilder = new WhereSqlClauseBuilder();

            wBuilder.AppendItem("PROCESS_ID", pq.ProcessID);
            wBuilder.AppendTenantCode();

            string sql = string.Format("UPDATE {0} SET {1} FROM {0} INNER JOIN WF.PROCESS_INSTANCES ON INSTANCE_ID = PROCESS_ID WHERE {2}",
                                       mappingInfo.TableName,
                                       uBuilder.ToSqlString(TSqlBuilder.Instance),
                                       wBuilder.ToSqlString(TSqlBuilder.Instance));

            return(sql);
        }
Exemplo n.º 7
0
        public void MoveQueueItemToArchived(WfPersistQueue pq)
        {
            pq.NullCheck("pq");

            ORMappingItemCollection mappingInfo = ORMapping.GetMappingInfo(typeof(WfPersistQueue));

            InsertSqlClauseBuilder builder = ORMapping.GetInsertSqlClauseBuilder(pq, mappingInfo);

            builder.AppendItem("SORT_ID", pq.SortID);
            builder.AppendItem("PROCESS_TIME", "GETUTCDATE()", "=", true);

            StringBuilder sql = new StringBuilder();

            sql.AppendFormat("DELETE {0} WHERE SORT_ID = {1}", "WF.PERSIST_QUEUE_ARCHIEVED", pq.SortID);
            sql.Append(TSqlBuilder.Instance.DBStatementSeperator);
            sql.AppendFormat("INSERT INTO {0}{1}", "WF.PERSIST_QUEUE_ARCHIEVED", builder.ToSqlString(TSqlBuilder.Instance));
            sql.Append(TSqlBuilder.Instance.DBStatementSeperator);
            sql.AppendFormat("DELETE {0} WHERE PROCESS_ID = {1}", mappingInfo.TableName, TSqlBuilder.Instance.CheckUnicodeQuotationMark(pq.ProcessID));

            DbHelper.RunSqlWithTransaction(sql.ToString(), GetConnectionName());
        }
Exemplo n.º 8
0
        /// <summary>
        /// 执行队列项的操作,并且移动到已完成中
        /// </summary>
        /// <param name="pq"></param>
        public void DoQueueOperationAndMove(WfPersistQueue pq)
        {
            using (TransactionScope scope = TransactionScopeFactory.Create())
            {
                try
                {
                    DoQueueOperation(pq);
                }
                catch (System.Exception ex)
                {
                    if (ex is TransactionException || ex is DbException)
                    {
                        throw;
                    }

                    pq.StatusText = ex.ToString();
                }

                MoveQueueItemToArchived(pq);

                scope.Complete();
            }
        }
Exemplo n.º 9
0
        public WfPersistQueue LoadArchived(string processID)
        {
            ORMappingItemCollection mappingInfo = ORMapping.GetMappingInfo(typeof(WfPersistQueue));

            processID.CheckStringIsNullOrEmpty("processID");

            string sql = string.Format("SELECT * FROM {0} WHERE PROCESS_ID = {1}",
                                       "WF.PERSIST_QUEUE_ARCHIEVED",
                                       TSqlBuilder.Instance.CheckUnicodeQuotationMark(processID)
                                       );

            DataTable table = DbHelper.RunSqlReturnDS(sql, GetConnectionName()).Tables[0];

            WfPersistQueue result = null;

            if (table.Rows.Count > 0)
            {
                result = new WfPersistQueue();

                ORMapping.DataRowToObject(table.Rows[0], result);
            }

            return(result);
        }