/// <summary>
/// 计算父节点每个月份要支付的成本
/// </summary>
/// <param name="costAccounts"></param>
/// <param name="months"></param>
private void CalcParentMonthCost(List <BsonDocument> costAccounts, List <string> months)
{
CostBll costBll = CostBll._(_ctx);
foreach (var month in months)
{
costBll.CalcParentValue(costAccounts, month);
}
}
/// <summary>
/// 初始化现金流的相关信息
/// </summary>
/// <param name="projId">项目Id</param>
/// <param name="versionId">版本Id</param>
/// <returns></returns>
public BsonDocument InitCashFlowInfo(string projId, string versionId)
{
var costBll = CostBll._(_ctx);
var cashInfo = new BsonDocument();
var costAccounts = GetCostDirList(projId, versionId); //获取所有成本科目Id
costBll.Init(costAccounts, projId, versionId); //初始化
//cashInfo.Add("costAccounts", costAccounts);
return(cashInfo);
}
/// <summary>
/// 计算父节点每个季度份要支付的成本
/// </summary>
/// <param name="costAccounts"></param>
/// <param name="months"></param>
private void CalcParentSeasonCost(List <BsonDocument> costAccounts, Season season)
{
CostBll costBll = CostBll._(_ctx);
foreach (var seasonMonth in season.SeasonMonth)//遍历季度
{
string key = seasonMonth.key;
costBll.CalcParentValue(costAccounts, key);
}
}
/// <summary>
/// 创建决策版本
/// </summary>
/// <param name="projId"></param>
/// <param name="type">1:引用模板创建新版本 0或2：从旧数据中创建新模板</param>
/// <returns></returns>
public void CreateVersion(string projId, string remark, int type)
{
//ProjNode MarketingArea DesignArea Finance Cost
lock (ObjPad)
{
var versionId = string.Empty;
try
{
var count = _ctx.FindAllByQuery(PolicyVersion, Query.EQ("projId", projId)).Count();
var costBll = CostBll._(_ctx);
var latestVersionId = GetLatestVersionId(projId);
var version = CreateOriginalVersion(projId, remark, (count + 1).ToString());
versionId = version.String("versionId");
if ((count == 0 && latestVersionId == 0) || type == 1)
{
CopyPolicyDateFromTemplate(PolicyDept.ProjNode, "项目节点", projId, versionId, new string[] { "name" });
CopyPolicyDateFromTemplate(PolicyDept.MarketingArea, "营销面积", projId, versionId, new string[] { "name", "unit" });
CopyPolicyDateFromTemplate(PolicyDept.DesignArea, "设计面积", projId, versionId, new string[] { "name", "unit" });
CreateFinance(projId, versionId);
costBll.CopyFromTemplate(PolicyDept.Cost, "成本科目", projId, versionId, new string[] { "name", "quota", "costType", "rate", "remark", "unit", "subType", "belong" });
if (type == 1)
{
var preVerStr = latestVersionId.ToString();
CopyDataFromOldVersion(PolicyDept.ProjNode, projId, preVerStr, versionId, new string[] { "completeDate" }); //项目节点
CopyDataFromOldVersion(PolicyDept.MarketingArea, projId, preVerStr, versionId, new string[] { "areaValue", "maxVal", "minVal", "commonVal", }); //营销面积
CopyDataFromOldVersion(PolicyDept.DesignArea, projId, preVerStr, versionId, new string[] { "areaValue", }); //设计面积
CopyDataFromOldVersion(PolicyDept.Cost, projId, preVerStr, versionId, new string[] { "quota", "rate", "amount" }); //成本科目
CopyCostRate(projId, preVerStr, versionId, "srcId", false);
CopyRepayDetails(preVerStr, versionId); //还款计划
CopySellDetails(preVerStr, versionId); //销售回款计划
}
else
{
CopyCostRate(projId, "", versionId, "templateId", true);
}
}
else
{
var preVerStr = latestVersionId.ToString();
CreateVersionFromPre(PolicyDept.ProjNode, "项目节点", projId, preVerStr, versionId, new string[] { "name", "completeDate", "templateId" });
CreateVersionFromPre(PolicyDept.MarketingArea, "营销面积", projId, preVerStr, versionId, new string[] { "name", "areaValue", "unit", "maxVal", "minVal", "commonVal", "templateId" });
CreateVersionFromPre(PolicyDept.DesignArea, "设计面积", projId, preVerStr, versionId, new string[] { "name", "areaValue", "unit", "templateId" });
CopyFinance(projId, preVerStr, versionId);//拷贝财务数据
costBll.CopyFromPreVersion(PolicyDept.Cost, "成本科目", projId, preVerStr, versionId, new string[] { "name", "quota", "costType", "amount", "rate", "remark", "unit", "subType", "belong", "templateId" });
CopyCostRate(projId, preVerStr, versionId, "srcId", false);
CopyRepayDetails(preVerStr, versionId); //还款计划
CopySellDetails(preVerStr, versionId); //销售回款计划
//有新模板时但不使用新模板加提醒
var tempNotice = _ctx.FindOneByQuery("ProjVersionNotice", Query.And(Query.EQ("projId", projId), Query.EQ("versionId", latestVersionId.ToString())));
if (tempNotice != null)
{
tempNotice["versionId"] = versionId;
tempNotice["versionOrder"] = version.String("versionOrder");
tempNotice["remark"] = tempNotice["remark"] + ",再次通知";
_ctx.Update("ProjVersionNotice", Query.EQ("projVerNoticeId", tempNotice.String("projVerNoticeId")), tempNotice);
}
}
_ctx.Insert("ConflictInfo", new BsonDocument {
{ "versionId", versionId }
}); //初始化一个冲突决策表单信息
_ctx.Insert("CashDoc", new BsonDocument {
{ "versionId", versionId }, { "projId", projId }
}); //现金流文件
_ctx.Insert("ConflictDoc", new BsonDocument {
{ "versionId", versionId }, { "projId", projId }
}); //冲突决策文件
_ctx.Insert("WeightsDoc", new BsonDocument {
{ "versionId", versionId }, { "projId", projId }
}); //权重决策文件
_ctx.Insert("CEOPolicyDesign", new BsonDocument {
{ "versionId", versionId }, { "projId", projId }
}); //权重决策文件
}
catch
{
if (!string.IsNullOrEmpty(versionId))
{
_ctx.Delete("PolicyVersion", Query.EQ("versionId", versionId));
Rollback(versionId);
}
throw;
}
}
}
/// <summary>
/// 计算冲突决策所需要的值
/// </summary>
/// <param name="projId"></param>
/// <returns></returns>
public BsonDocument CalcConflictData(string projId, string versionId)
{
//项目节点
PolicyVersionBll versionBll = PolicyVersionBll._(_ctx);
CostBll costBll = CostBll._(_ctx);
decimal projCycle = 0m;
DateTime start, end;//项目开始结束时间
versionBll.GetStartEndDate(versionId, out start, out end);
projCycle = (end - start).Days / 30;
var costDirs = versionBll.GetTableDirs(PolicyDept.Cost, projId, versionId);//成本科目
TreeHandle.CalcLeafNode(costDirs);
costBll.CalcTotalCost(costDirs, projId, versionId);
//decimal totalCost = costBll.CalcCost(costDirs,projId,versionId);//计算成本总值
decimal totalCost = costDirs.LeafNode().Where(s => s.Int("subType") == 0).Sum(s => s.Decimal("value"));
decimal mintotalCost = costDirs.LeafNode().Where(s => s.Int("subType") == 0).Sum(s => s.Decimal("minvalue")); //悲观情况
decimal comtotalCost = costDirs.LeafNode().Where(s => s.Int("subType") == 0).Sum(s => s.Decimal("comvalue")); //客观情况
//融资周期、资本利息、销售周期、销售费用
var repayList = _ctx.FindAllByQuery("RepayDetail", Query.EQ("versionId", versionId)).ToList(); //获取还款计划
var sellList = _ctx.FindAllByQuery("SellDetail", Query.EQ("versionId", versionId)).ToList(); //销售计划
repayList = repayList.Where(s => DateTimeHelper.LTE(start, s.Date("date")) && DateTimeHelper.LTE(s.Date("date"), end)).ToList();
sellList = sellList.Where(s => DateTimeHelper.LTE(start, s.Date("date")) && DateTimeHelper.LTE(s.Date("date"), end)).ToList();
var financeList = repayList.Where(s => s.Decimal("loan") > 0m || s.Decimal("repayVal") > 0m || s.Decimal("interest") > 0m);//融资周期
var financeCycle = financeList.Count();
//悲观融资周期
var minfinanceList = repayList.Where(s => s.Decimal("minLoan") > 0m || s.Decimal("minRepayVal") > 0m || s.Decimal("minInterest") > 0m);//融资周期
var minfinanceCycle = minfinanceList.Count();
//客观融资周期
var comfinanceList = repayList.Where(s => s.Decimal("comLoan") > 0m || s.Decimal("comRepayVal") > 0m || s.Decimal("comInterest") > 0m);//融资周期
var comfinanceCycle = comfinanceList.Count();
var sells = sellList.Where(s => s.Decimal("salesVal") > 0m).ToList();//销售周期
var sellCycle = sells.Count;
//悲观销售周期
var minsells = sellList.Where(s => s.Decimal("minSalesVal") > 0m).ToList();//销售周期
var minsellCycle = minsells.Count;
//客观销售周期
var comsells = sellList.Where(s => s.Decimal("comSalesVal") > 0m).ToList();//销售周期
var comsellCycle = comsells.Count;
var totalInterest = repayList.Sum(s => s.Decimal("interest")); //总利息
//悲观总利息
var mintotalInterest = repayList.Sum(s => s.Decimal("minInterest")); //总利息
//客观总利息
var comtotalInterest = repayList.Sum(s => s.Decimal("comInterest")); //总利息
//var totalSell = sellList.Sum(s => s.Decimal("salesVal"));//总销售额
var totalIn = costDirs.LeafNode().Where(s => s.Int("subType") == 1).Sum(s => s.Decimal("value")); //总收入
var mintotalIn = costDirs.LeafNode().Where(s => s.Int("subType") == 1).Sum(s => s.Decimal("minvalue")); //悲观总收入
var comtotalIn = costDirs.LeafNode().Where(s => s.Int("subType") == 1).Sum(s => s.Decimal("comvalue")); //客观总收入
// List<BsonDocument> ttt = costDirs.Where(s => s.String("销售费用") == "销售费用").ToList();
var sellCost = costDirs.FirstOrDefault(s => s.String("name") == "销售费用").Decimal("value");
var minsellCost = costDirs.FirstOrDefault(s => s.String("name") == "销售费用").Decimal("minvalue"); //悲观销售费用
var comsellCost = costDirs.FirstOrDefault(s => s.String("name") == "销售费用").Decimal("comvalue"); //悲观销售费用
//利润率
var profitRate = 0m;
var totalFee = totalCost;//总支出
if (totalIn > 0m)
{
profitRate = (totalIn - totalFee) / totalIn; //净利润率 = 利润/总投资收入
}
//悲观利润率
var minprofitRate = 0m;
var mintotalFee = mintotalCost;//总支出
if (mintotalIn > 0m)
{
minprofitRate = (mintotalIn - mintotalFee) / mintotalIn; //净利润率 = 利润/总投资收入
}
//客观利润率
var comprofitRate = 0m;
var comtotalFee = comtotalCost;//总支出
if (comtotalIn > 0m)
{
comprofitRate = (comtotalIn - comtotalFee) / comtotalIn; //净利润率 = 利润/总投资收入
}
//面积相关
var decisionList = versionBll.GetTableDirsByVersionId(PolicyDept.DesignArea, versionId); //设计面积
var marketingList = versionBll.GetTableDirsByVersionId(PolicyDept.MarketingArea, versionId); //市场面积
var totalArea = decisionList.Where(s => s.String("name") == "总建筑面积").OrderBy(s => s.String("nodeKey")).FirstOrDefault().Decimal("areaValue"); //总建筑面积
var upArea = decisionList.Where(s => s.String("name") == "地上建筑面积").OrderBy(s => s.String("nodeKey")).FirstOrDefault().Decimal("areaValue");
var downArea = decisionList.Where(s => s.String("name") == "地下建筑面积").OrderBy(s => s.String("nodeKey")).FirstOrDefault().Decimal("areaValue");
var jirongArea = decisionList.Where(s => s.String("name") == "计容建筑面积").OrderBy(s => s.String("nodeKey")).FirstOrDefault().Decimal("areaValue");
var bujirongArea = totalArea - jirongArea;
var sellArea = marketingList.SingleOrDefault(s => s.String("name") == "总销售面积").Decimal("areaValue");//可售面积
var noSellArea = totalArea - sellArea;
//产品配置价格
var jingguang = costDirs.FirstOrDefault(s => s.String("name") == "景观工程").Decimal("quota"); //景观工程
var gonggong = costDirs.FirstOrDefault(s => s.String("name") == "公共区域装修工程").Decimal("quota"); //公共区域装修工程
var wailimian = costDirs.FirstOrDefault(s => s.String("name").Trim() == "外墙装修（专业）").Decimal("quota"); //公共区域装修工程
return(new BsonDocument {
{ "projCycle", projCycle.ToString() }, { "totalCost", totalCost.ToString() }, { "financeCycle", financeCycle.ToString() }, { "minfinanceCycle", minfinanceCycle.ToString() }, { "comfinanceCycle", comfinanceCycle.ToString() },
{ "sellCycle", sellCycle.ToString() }, { "minsellCycle", minsellCycle.ToString() }, { "comsellCycle", comsellCycle.ToString() },
{ "sellCost", sellCost.ToString() }, { "minsellCost", minsellCost.ToString() }, { "comsellCost", comsellCost.ToString() },
{ "upArea", upArea.ToString() }, { "downArea", downArea.ToString() }, { "totalArea", totalArea.ToString() }, { "jirongArea", jirongArea.ToString() },
{ "sellArea", sellArea.ToString() }, { "noSellArea", noSellArea.ToString() }, { "bujirongArea", bujirongArea.ToString() },
{ "profitRate", profitRate.ToString() }, { "minprofitRate", minprofitRate.ToString() }, { "comprofitRate", comprofitRate.ToString() },
{ "totalInterest", totalInterest.ToString() }, { "mintotalInterest", mintotalInterest.ToString() }, { "comtotalInterest", comtotalInterest.ToString() },
{ "jingguang", jingguang.ToString() }, { "gonggong", gonggong.ToString() }, { "wailimian", wailimian.ToString() }
});
}