예제 #1
0
        public ImportSummary ImportQueueSummaryGet(int importQueueId)
        {
            ImportSummary retVal = new EmptyImportSummary();

            using (IDbConnection conn = DbHelper.GetDBConnection())
            {
                try
                {
                    var para = new DynamicParameters();
                    para.Add("@FdpImportQueueId", importQueueId, DbType.Int32);

                    var results = conn.Query <ImportSummary>("dbo.Fdp_ImportQueueSummary_Get", para, commandType: CommandType.StoredProcedure);
                    if (results.Any())
                    {
                        retVal = results.First();
                    }
                }
                catch (Exception ex)
                {
                    Log.Error(ex);
                    throw;
                }
            }

            return(retVal);
        }
        public ImportSummary ImportQueueSummaryGet(int importQueueId)
        {
            ImportSummary retVal = new EmptyImportSummary();

            using (IDbConnection conn = DbHelper.GetDBConnection())
            {
                try
                {
                    var para = new DynamicParameters();
                    para.Add("@FdpImportQueueId", importQueueId, DbType.Int32);

                    var results = conn.Query<ImportSummary>("dbo.Fdp_ImportQueueSummary_Get", para, commandType: CommandType.StoredProcedure);
                    if (results.Any())
                    {
                        retVal = results.First();
                    }
                }
                catch (Exception ex)
                {
                    Log.Error(ex);
                    throw;
                }
            }

            return retVal;
        }