/// <summary> /// /// </summary> /// <param name="debitMoney"></param> /// <param name="debitPeroid"></param> /// <returns></returns> public static DataProviderResultModel GetInterestRateByDebitStyle(float debitMoney, int debitPeriod) { DataBaseOperator dbo = null; DataProviderResultModel result = new DataProviderResultModel(); try { dbo = new DataBaseOperator(); ParamCollections pc = new ParamCollections(); string sqlStr = "select interestRate,overdueDayInterest from IFDebitStyle where money = @dDebitMoney and period = @iDebitPeriod;"; pc.Add("@dDebitMoney", debitMoney); pc.Add("@iDebitPeriod", debitPeriod); Hashtable table = new Hashtable(); DataRow rates = dbo.GetRow(sqlStr, pc.GetParams()); if (null != rates) { result.result = Result.SUCCESS; float rate = 0f; float overdueRate = 0f; float.TryParse(Convert.ToString(rates[0]), out rate); float.TryParse(Convert.ToString(rates[1]), out overdueRate); result.data = new List <float> { rate, overdueRate }; } else { result.result = MainErrorModels.NO_SUCH_DEBIT_COMBINATION; result.message = "There is no such combination."; } return(result); } catch (Exception ex) { result.result = MainErrorModels.DATABASE_REQUEST_ERROR; result.message = "The database logic error."; Log.WriteErrorLog("DebitProvider::GetUserBankInfo", "获取失败:{0},{1},异常:{2}", debitMoney, debitPeriod, ex.Message); } finally { if (null != dbo) { dbo.Close(); dbo = null; } } return(result); }