/// <summary>
/// 计算承接人的年化利率
/// </summary>
/// <returns></returns>
public void GetUndertakeYearRate()
{
Guid subscribeId = Guid.Empty;
Guid.TryParse(Context.Request["subscribeid"], out subscribeId);
int totalShares = 0;
int.TryParse(Context.Request["totalshares"], out totalShares);
decimal totalAmount = 0;
decimal.TryParse(Context.Request["totalamount"], out totalAmount);
string sql = "select isnull(dbo.f_GetCurTransferProjectRate(@SubscribeId,@TotalShares,@TotalAmount),0)";
var whereParas = new Dapper.DynamicParameters();
whereParas.Add("@SubscribeId", subscribeId);
whereParas.Add("@TotalShares", totalShares);
whereParas.Add("@TotalAmount", totalAmount);
decimal yearRate = 0;
try
{
//using (SqlConnection conn = new SqlConnection(TuanDai.Config.BaseConfig.ConnectionString))
//{
// conn.Open();
// yearRate = conn.Query<decimal>(sql, whereParas).Sum();
// conn.Close();
// conn.Dispose();
//}
yearRate = PublicConn.QueryBySqlWrite <decimal>(sql, ref whereParas).Sum();
}
catch (Exception ex)
{
SysLogHelper.WriteErrorLog("计算承接者利率异常", "申购Id:" + subscribeId + "异常:" + ex.Message);
}
finally
{
PrintJson(yearRate.ToString(), "");
}
}