public ActionResult Analysis(int xm_id, int xm_type)
{
AnalysisResult result = new AnalysisResult();
switch(xm_type)
{
case (int)CaseTypes.Financing:
result = GetFinancingAnalysisResult(xm_id, result);
break;
case (int)CaseTypes.Investment:
result = GetInvestmentAnalysisResult(xm_id, result);
break;
}
return PartialView(result);
}
private AnalysisResult GetInvestmentAnalysisResult(int investment_id, AnalysisResult result)
{
var investment = db.T_XM_Investment.Find(investment_id);
var investment_list = db.T_XM_Investment
.Where(i => i.AimIndustry.IndexOf((String)investment.AimIndustry) >= 0 && i.TeamworkType.IndexOf((String)investment.TeamworkType) >= 0)
.ToList();
result.Turnover = (Decimal)investment_list.Average(m => m.Investment);
result.ReturnRatio = (Double)investment_list.Average(m => m.ReturnRatio);
result.Num = investment_list.Count();
result.TurnoverRatio = investment_list.Count() % db.T_XM_Financing.Where(f => f.IsValid == true).Count();
return result;
}
private AnalysisResult GetFinancingAnalysisResult(int finacial_id, AnalysisResult result)
{
//to-do:
//添加成交项目的判断
var finacial = db.T_XM_Financing.Find(finacial_id);
var finacial_list = db.T_XM_Financing
.Where(f => f.ItemType == finacial.ItemType && f.Industry == finacial.Industry && f.IsValid == true)
.ToList();
result.Turnover = (Decimal)finacial_list.Average(m => m.TotalInvestment);
result.ReturnRatio = (Double)finacial_list.Average(m => m.ReturnRatio);
result.Num = finacial_list.Count();
result.TurnoverRatio = finacial_list.Count() % db.T_XM_Financing.Where(f => f.IsValid == true).Count();
return result;
}