From b18a7c8e54b51a5caa400e55cb8cc428c0301a0c Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期五, 21 一月 2022 17:27:22 +0800
Subject: [PATCH] 数据库连接
---
CY_ECommercePlatform/CY.SQLDAL/Database.cs | 34 ++++++++++++++++++++++++++++------
1 files changed, 28 insertions(+), 6 deletions(-)
diff --git a/CY_ECommercePlatform/CY.SQLDAL/Database.cs b/CY_ECommercePlatform/CY.SQLDAL/Database.cs
index 0364c1a..3c0837d 100644
--- a/CY_ECommercePlatform/CY.SQLDAL/Database.cs
+++ b/CY_ECommercePlatform/CY.SQLDAL/Database.cs
@@ -454,9 +454,21 @@
using (IDataReader reader = QueryDataReader("sp_CurrencyPage", CommandType.StoredProcedure, parameters))
{
- result = ReadDataToModel<T>(reader);
- reader.Close();
- Close();
+ try
+ {
+ result = ReadDataToModel<T>(reader);
+ }
+ catch (System.Data.SqlClient.SqlException e)
+ {
+ throw e;
+ }
+ finally
+ {
+ reader.Close();
+ Close();
+ }
+
+
}
int? resultValue = CY.Infrastructure.Common.MyConvert.ConvertToInt32(parameters[8].Value);
pagination.RecordCount = resultValue.HasValue ? resultValue.Value : 0;
@@ -549,9 +561,19 @@
return null;
using (IDataReader reader = QueryDataReader("sp_SelectModel", CommandType.StoredProcedure, parameters))
{
- result = ReadDataToModel<T>(reader);
- reader.Close();
- Close();
+ try
+ {
+ result = ReadDataToModel<T>(reader);
+ }
+ catch (System.Data.SqlClient.SqlException e)
+ {
+ throw e;
+ }
+ finally
+ {
+ reader.Close();
+ Close();
+ }
}
return result;
--
Gitblit v1.9.1