/// <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);
}
