数据库连接

username@email.com

2022-01-21 b18a7c8e54b51a5caa400e55cb8cc428c0301a0c

 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;