public static TransactionQueueSr CreateFromDataRow(DataRow dr)
        {
            TransactionQueueSr tqs = new TransactionQueueSr();

            tqs.FillFromDataRow(dr);

            return(tqs);
        }
        public static List <TransactionQueueSr> GetTransactionQueueList()
        {
            var lResult = new List <TransactionQueueSr>();

            using (DataTable dt = DataCopy.GetDataTableWithSqlParams("SELECT * FROM " + TableSpec.TableName, new List <IDbDataParameter>()))
            {
                if (dt != null)
                {
                    foreach (DataRow dr in dt.Rows)
                    {
                        TransactionQueueSr tqs = TransactionQueueSr.CreateFromDataRow(dr);

                        lResult.Add(tqs);
                    }
                }
            }

            return(lResult);
        }