2096 lines
112 KiB
C#
2096 lines
112 KiB
C#
using BLL;
|
||
using Newtonsoft.Json.Linq;
|
||
using System;
|
||
using System.Collections.Generic;
|
||
using System.Linq;
|
||
using System.Web.UI.WebControls;
|
||
|
||
namespace FineUIPro.Web.JDGL.WBSPlan
|
||
{
|
||
public partial class WBSPlanAudit :PageBase
|
||
{
|
||
#region 定义项
|
||
private static List<string> noApproveInstallationIds = new List<string>();
|
||
private static List<string> noApproveCnProfessionIds = new List<string>();
|
||
private static List<string> noApproveUnitProjectIds = new List<string>();
|
||
private static List<string> noApproveWbsSetIds = new List<string>();
|
||
#endregion
|
||
|
||
#region 页面加载
|
||
/// <summary>
|
||
/// 页面加载
|
||
/// </summary>
|
||
/// <param name="sender"></param>
|
||
/// <param name="e"></param>
|
||
protected void Page_Load(object sender, EventArgs e)
|
||
{
|
||
if (!IsPostBack)
|
||
{
|
||
if (this.CurrUser.Account == BLL.Const.sysglyId || BLL.CommonService.GetAllButtonPowerList(this.CurrUser.LoginProjectId, this.CurrUser.UserId, Const.WBSPlanAuditMenuId, "一键保存"))
|
||
{
|
||
this.btnSaveInstrallion.Hidden = false;
|
||
}
|
||
InitTreeMenu();
|
||
}
|
||
else
|
||
{
|
||
if (GetRequestEventArgument() == "UPDATE_SUMMARY")
|
||
{
|
||
// 页面要求重新计算合计行的值
|
||
OutputSummaryData();
|
||
}
|
||
}
|
||
}
|
||
#endregion
|
||
|
||
#region 计算合计
|
||
/// <summary>
|
||
/// 计算合计
|
||
/// </summary>
|
||
private void OutputSummaryData()
|
||
{
|
||
decimal totalValue = 0, totalRate = 0, moneys = 0;
|
||
int i = 0;
|
||
JArray mergedData = Grid1.GetMergedData();
|
||
if (mergedData.Count > 0)
|
||
{
|
||
JObject firstValues = mergedData[0].Value<JObject>("values");
|
||
|
||
if (!string.IsNullOrEmpty(firstValues.Value<string>("WeightsMoney")))
|
||
{
|
||
moneys = Convert.ToDecimal(firstValues.Value<string>("WeightsMoney"));
|
||
moneys = decimal.Round(moneys, 2);
|
||
}
|
||
foreach (JObject mergedRow in mergedData)
|
||
{
|
||
JObject values = mergedRow.Value<JObject>("values");
|
||
if (!string.IsNullOrEmpty(values.Value<string>("PlanValue")))
|
||
{
|
||
totalValue += Convert.ToDecimal(values.Value<string>("PlanValue"));
|
||
}
|
||
else
|
||
{
|
||
totalValue += 0;
|
||
}
|
||
|
||
if (moneys != 0)
|
||
{
|
||
totalRate = decimal.Round(totalValue / moneys * 100, 2);
|
||
}
|
||
else
|
||
{
|
||
totalRate = 0;
|
||
}
|
||
this.Grid1.Rows[i].Values[1] = values.Value<string>("PlanValue");
|
||
this.Grid1.Rows[i].Values[2] = totalValue;
|
||
this.Grid1.Rows[i].Values[3] = totalRate;
|
||
i++;
|
||
}
|
||
|
||
JObject summary = new JObject();
|
||
summary.Add("YearsMonthsStr", "未分配费用余额：");
|
||
summary.Add("PlanValue", moneys - totalValue);
|
||
Grid1.SummaryData = summary;
|
||
}
|
||
}
|
||
#endregion
|
||
|
||
#region 加载树
|
||
/// <summary>
|
||
/// 加载树
|
||
/// </summary>
|
||
private void InitTreeMenu()
|
||
{
|
||
this.trWBS.Nodes.Clear();
|
||
this.trWBS.ShowBorder = false;
|
||
this.trWBS.ShowHeader = false;
|
||
this.trWBS.EnableIcons = true;
|
||
this.trWBS.AutoScroll = true;
|
||
this.trWBS.EnableSingleClickExpand = true;
|
||
var installations = from x in Funs.DB.Project_Installation where x.ProjectId == this.CurrUser.LoginProjectId && x.SuperInstallationId == "0" orderby x.InstallationCode select x;
|
||
foreach (var installation in installations)
|
||
{
|
||
TreeNode rootNode = new TreeNode();
|
||
if (noApproveInstallationIds.Contains(installation.InstallationId))
|
||
{
|
||
rootNode.Text = "<font color='#FF0000'>" + installation.InstallationName + "</font>";
|
||
}
|
||
else
|
||
{
|
||
rootNode.Text = installation.InstallationName;
|
||
}
|
||
rootNode.NodeID = installation.InstallationId;
|
||
rootNode.CommandName = "installation";
|
||
rootNode.CommandArgument = installation.Weights == null ? null : installation.Weights.ToString();
|
||
rootNode.ToolTip = installation.InstallationCode;
|
||
rootNode.EnableExpandEvent = true;
|
||
rootNode.EnableClickEvent = true;
|
||
this.trWBS.Nodes.Add(rootNode);
|
||
TreeNode emptyNode = new TreeNode();
|
||
emptyNode.Text = "";
|
||
emptyNode.NodeID = "";
|
||
rootNode.Nodes.Add(emptyNode);
|
||
}
|
||
}
|
||
#endregion
|
||
|
||
#region 展开树
|
||
/// <summary>
|
||
/// 展开树
|
||
/// </summary>
|
||
/// <param name="sender"></param>
|
||
/// <param name="e"></param>
|
||
protected void trWBS_NodeExpand(object sender, TreeNodeEventArgs e)
|
||
{
|
||
e.Node.Nodes.Clear();
|
||
if (e.Node.CommandName == "installation") //展开装置/单元节点
|
||
{
|
||
var installations = from x in Funs.DB.Project_Installation
|
||
where x.SuperInstallationId == e.Node.NodeID
|
||
orderby x.InstallationCode
|
||
select x;
|
||
if (installations.Count() > 0)
|
||
{
|
||
foreach (var installation in installations)
|
||
{
|
||
TreeNode newNode = new TreeNode();
|
||
if (noApproveInstallationIds.Contains(installation.InstallationId))
|
||
{
|
||
newNode.Text = "<font color='#FF0000'>" + installation.InstallationName + "</font>";
|
||
}
|
||
else
|
||
{
|
||
newNode.Text = installation.InstallationName;
|
||
}
|
||
newNode.NodeID = installation.InstallationId;
|
||
newNode.CommandName = "installation";
|
||
newNode.CommandArgument = installation.Weights == null ? null : installation.Weights.ToString();
|
||
newNode.ToolTip = installation.InstallationCode;
|
||
newNode.EnableExpandEvent = true;
|
||
newNode.EnableClickEvent = true;
|
||
e.Node.Nodes.Add(newNode);
|
||
TreeNode emptyNode = new TreeNode();
|
||
emptyNode.Text = "";
|
||
emptyNode.NodeID = "";
|
||
newNode.Nodes.Add(emptyNode);
|
||
}
|
||
}
|
||
else
|
||
{
|
||
var cnProfessions = from x in Funs.DB.WBS_CnProfession where x.InstallationId == e.Node.NodeID orderby x.OldId select x;
|
||
if (cnProfessions.Count() > 0) //普通装置主项
|
||
{
|
||
foreach (var cnProfession in cnProfessions)
|
||
{
|
||
var unitProjects = from x in Funs.DB.Wbs_UnitProject where x.CnProfessionId == cnProfession.CnProfessionId && x.IsApprove == true select x;
|
||
if (unitProjects.Count() > 0)
|
||
{
|
||
TreeNode newNode = new TreeNode();
|
||
if (noApproveCnProfessionIds.Contains(cnProfession.CnProfessionId))
|
||
{
|
||
newNode.Text = "<font color='#FF0000'>" + cnProfession.CnProfessionName + "</font>";
|
||
}
|
||
else
|
||
{
|
||
newNode.Text = cnProfession.CnProfessionName;
|
||
}
|
||
newNode.NodeID = cnProfession.CnProfessionId;
|
||
newNode.CommandName = "cnProfession";
|
||
newNode.CommandArgument = cnProfession.Weights == null ? null : cnProfession.Weights.ToString();
|
||
newNode.ToolTip = cnProfession.CnProfessionCode;
|
||
newNode.EnableExpandEvent = true;
|
||
newNode.EnableClickEvent = true;
|
||
e.Node.Nodes.Add(newNode);
|
||
TreeNode emptyNode = new TreeNode();
|
||
emptyNode.Text = "";
|
||
emptyNode.NodeID = "";
|
||
newNode.Nodes.Add(emptyNode);
|
||
}
|
||
}
|
||
}
|
||
else //总图
|
||
{
|
||
var unitProjects = from x in Funs.DB.Wbs_UnitProject where x.InstallationId == e.Node.NodeID && x.SuperUnitProjectId == null orderby x.SortIndex, x.UnitProjectCode select x;
|
||
foreach (var unitProject in unitProjects)
|
||
{
|
||
var wbsSets = from x in Funs.DB.Wbs_WbsSet where x.UnitProjectId == unitProject.UnitProjectId && x.IsApprove == true select x;
|
||
if (wbsSets.Count() > 0)
|
||
{
|
||
TreeNode newNode = new TreeNode();
|
||
if (noApproveUnitProjectIds.Contains(unitProject.UnitProjectId))
|
||
{
|
||
newNode.Text = "<font color='#FF0000'>" + unitProject.UnitProjectName + "</font>";
|
||
}
|
||
else
|
||
{
|
||
newNode.Text = unitProject.UnitProjectName;
|
||
}
|
||
newNode.NodeID = unitProject.UnitProjectId;
|
||
newNode.CommandName = "unitProject";
|
||
newNode.CommandArgument = unitProject.Weights == null ? null : unitProject.Weights.ToString();
|
||
newNode.ToolTip = unitProject.UnitProjectCode;
|
||
newNode.EnableExpandEvent = true;
|
||
newNode.EnableClickEvent = true;
|
||
e.Node.Nodes.Add(newNode);
|
||
TreeNode emptyNode = new TreeNode();
|
||
emptyNode.Text = "";
|
||
emptyNode.NodeID = "";
|
||
newNode.Nodes.Add(emptyNode);
|
||
}
|
||
}
|
||
}
|
||
}
|
||
}
|
||
else if (e.Node.CommandName == "cnProfession") //展开专业节点
|
||
{
|
||
var unitProjects = from x in Funs.DB.Wbs_UnitProject where x.CnProfessionId == e.Node.NodeID && x.SuperUnitProjectId == null && x.IsApprove == true orderby x.SortIndex, x.UnitProjectCode select x;
|
||
foreach (var unitProject in unitProjects)
|
||
{
|
||
TreeNode newNode = new TreeNode();
|
||
if (noApproveUnitProjectIds.Contains(unitProject.UnitProjectId))
|
||
{
|
||
newNode.Text = "<font color='#FF0000'>" + unitProject.UnitProjectName + "</font>";
|
||
}
|
||
else
|
||
{
|
||
newNode.Text = unitProject.UnitProjectName;
|
||
}
|
||
newNode.NodeID = unitProject.UnitProjectId;
|
||
newNode.CommandName = "unitProject";
|
||
newNode.CommandArgument = unitProject.Weights == null ? null : unitProject.Weights.ToString();
|
||
newNode.ToolTip = unitProject.UnitProjectCode;
|
||
newNode.EnableExpandEvent = true;
|
||
newNode.EnableClickEvent = true;
|
||
e.Node.Nodes.Add(newNode);
|
||
TreeNode emptyNode = new TreeNode();
|
||
emptyNode.Text = "";
|
||
emptyNode.NodeID = "";
|
||
newNode.Nodes.Add(emptyNode);
|
||
}
|
||
}
|
||
else if (e.Node.CommandName == "unitProject") //展开单位工程节点
|
||
{
|
||
var childUnitProjects = from x in Funs.DB.Wbs_UnitProject where x.SuperUnitProjectId == e.Node.NodeID && x.IsApprove == true orderby x.SortIndex, x.UnitProjectCode select x;
|
||
if (childUnitProjects.Count() > 0) //存在子单位工程
|
||
{
|
||
foreach (var childUnitProject in childUnitProjects)
|
||
{
|
||
TreeNode newNode = new TreeNode();
|
||
if (noApproveUnitProjectIds.Contains(childUnitProject.UnitProjectId))
|
||
{
|
||
newNode.Text = "<font color='#FF0000'>" + childUnitProject.UnitProjectName + "</font>";
|
||
}
|
||
else
|
||
{
|
||
newNode.Text = childUnitProject.UnitProjectName;
|
||
}
|
||
newNode.NodeID = childUnitProject.UnitProjectId;
|
||
newNode.CommandName = "childUnitProject";
|
||
newNode.CommandArgument = childUnitProject.Weights == null ? null : childUnitProject.Weights.ToString();
|
||
newNode.ToolTip = childUnitProject.UnitProjectCode;
|
||
newNode.EnableExpandEvent = true;
|
||
newNode.EnableClickEvent = true;
|
||
e.Node.Nodes.Add(newNode);
|
||
TreeNode emptyNode = new TreeNode();
|
||
emptyNode.Text = "";
|
||
emptyNode.NodeID = "";
|
||
newNode.Nodes.Add(emptyNode);
|
||
}
|
||
}
|
||
else //不存在子单位工程，加载分部工程
|
||
{
|
||
var wbsSet1s = from x in Funs.DB.Wbs_WbsSet where x.SuperWbsSetId == null && x.UnitProjectId == e.Node.NodeID && x.IsApprove == true && x.NoShow == null orderby x.SortIndex, x.WbsSetCode select x;
|
||
if (wbsSet1s.Count() > 0)
|
||
{
|
||
foreach (var wbsSet1 in wbsSet1s)
|
||
{
|
||
TreeNode newNode = new TreeNode();
|
||
if (noApproveWbsSetIds.Contains(wbsSet1.WbsSetId))
|
||
{
|
||
newNode.Text = "<font color='#FF0000'>" + wbsSet1.WbsSetName + "</font>";
|
||
}
|
||
else
|
||
{
|
||
newNode.Text = wbsSet1.WbsSetName;
|
||
}
|
||
newNode.NodeID = wbsSet1.WbsSetId;
|
||
newNode.CommandName = "wbsSet";
|
||
newNode.CommandArgument = wbsSet1.Weights == null ? null : wbsSet1.Weights.ToString();
|
||
newNode.ToolTip = wbsSet1.WbsSetCode;
|
||
newNode.EnableExpandEvent = true;
|
||
newNode.EnableClickEvent = true;
|
||
e.Node.Nodes.Add(newNode);
|
||
var childWbsSets2 = BLL.WbsSetService.GetApproveWbsSetsBySuperWbsSetId(newNode.NodeID);
|
||
if (childWbsSets2.Count() > 0)
|
||
{
|
||
TreeNode emptyNode = new TreeNode();
|
||
emptyNode.Text = "";
|
||
emptyNode.NodeID = "";
|
||
newNode.Nodes.Add(emptyNode);
|
||
}
|
||
}
|
||
}
|
||
else //单位工程下直接是分项内容，如质量行为
|
||
{
|
||
var wbsSet3s = from x in Funs.DB.Wbs_WbsSet where x.SuperWbsSetId == null && x.UnitProjectId == e.Node.NodeID && x.IsApprove == true && x.NoShow == null orderby x.SortIndex, x.WbsSetCode select x;
|
||
if (wbsSet3s.Count() > 0)
|
||
{
|
||
foreach (var wbsSet3 in wbsSet3s)
|
||
{
|
||
TreeNode newNode = new TreeNode();
|
||
if (noApproveWbsSetIds.Contains(wbsSet3.WbsSetId))
|
||
{
|
||
newNode.Text = "<font color='#FF0000'>" + wbsSet3.WbsSetName + "</font>";
|
||
}
|
||
else
|
||
{
|
||
newNode.Text = wbsSet3.WbsSetName;
|
||
}
|
||
newNode.NodeID = wbsSet3.WbsSetId;
|
||
newNode.CommandName = "wbsSet";
|
||
newNode.CommandArgument = wbsSet3.Weights == null ? null : wbsSet3.Weights.ToString();
|
||
newNode.ToolTip = wbsSet3.WbsSetCode;
|
||
newNode.EnableExpandEvent = true;
|
||
newNode.EnableClickEvent = true;
|
||
e.Node.Nodes.Add(newNode);
|
||
var childWbsSets2 = BLL.WbsSetService.GetApproveWbsSetsBySuperWbsSetId(newNode.NodeID);
|
||
if (childWbsSets2.Count() > 0)
|
||
{
|
||
TreeNode emptyNode = new TreeNode();
|
||
emptyNode.Text = "";
|
||
emptyNode.NodeID = "";
|
||
newNode.Nodes.Add(emptyNode);
|
||
}
|
||
}
|
||
}
|
||
}
|
||
}
|
||
}
|
||
else if (e.Node.CommandName == "childUnitProject") //展开子单位工程节点
|
||
{
|
||
var wbsSet1s = from x in Funs.DB.Wbs_WbsSet where x.SuperWbsSetId == null && x.UnitProjectId == e.Node.NodeID && x.IsApprove == true && x.NoShow == null orderby x.SortIndex, x.WbsSetCode select x;
|
||
foreach (var wbsSet1 in wbsSet1s)
|
||
{
|
||
TreeNode newNode = new TreeNode();
|
||
if (noApproveWbsSetIds.Contains(wbsSet1.WbsSetId))
|
||
{
|
||
newNode.Text = "<font color='#FF0000'>" + wbsSet1.WbsSetName + "</font>";
|
||
}
|
||
else
|
||
{
|
||
newNode.Text = wbsSet1.WbsSetName;
|
||
}
|
||
newNode.NodeID = wbsSet1.WbsSetId;
|
||
newNode.CommandName = "wbsSet";
|
||
newNode.CommandArgument = wbsSet1.Weights == null ? null : wbsSet1.Weights.ToString();
|
||
newNode.ToolTip = wbsSet1.WbsSetCode;
|
||
newNode.EnableExpandEvent = true;
|
||
newNode.EnableClickEvent = true;
|
||
e.Node.Nodes.Add(newNode);
|
||
var childWbsSets2 = BLL.WbsSetService.GetApproveWbsSetsBySuperWbsSetId(newNode.NodeID);
|
||
if (childWbsSets2.Count() > 0)
|
||
{
|
||
TreeNode emptyNode = new TreeNode();
|
||
emptyNode.Text = "";
|
||
emptyNode.NodeID = "";
|
||
newNode.Nodes.Add(emptyNode);
|
||
}
|
||
}
|
||
}
|
||
else if (e.Node.CommandName == "wbsSet") //展开分部/子分部/分项/子分项工程节点
|
||
{
|
||
var childWbsSets = BLL.WbsSetService.GetApproveWbsSetsBySuperWbsSetId(e.Node.NodeID);
|
||
foreach (var wbsSet in childWbsSets)
|
||
{
|
||
TreeNode newNode = new TreeNode();
|
||
if (noApproveWbsSetIds.Contains(wbsSet.WbsSetId))
|
||
{
|
||
newNode.Text = "<font color='#FF0000'>" + wbsSet.WbsSetName + "</font>";
|
||
}
|
||
else
|
||
{
|
||
newNode.Text = wbsSet.WbsSetName;
|
||
}
|
||
newNode.NodeID = wbsSet.WbsSetId;
|
||
newNode.CommandName = "wbsSet";
|
||
newNode.CommandArgument = wbsSet.Weights == null ? null : wbsSet.Weights.ToString();
|
||
newNode.ToolTip = wbsSet.WbsSetCode;
|
||
newNode.EnableExpandEvent = true;
|
||
newNode.EnableClickEvent = true;
|
||
e.Node.Nodes.Add(newNode);
|
||
var childWbsSets2 = BLL.WbsSetService.GetApproveWbsSetsBySuperWbsSetId(newNode.NodeID);
|
||
if (childWbsSets2.Count() > 0)
|
||
{
|
||
TreeNode emptyNode = new TreeNode();
|
||
emptyNode.Text = "";
|
||
emptyNode.NodeID = "";
|
||
newNode.Nodes.Add(emptyNode);
|
||
}
|
||
}
|
||
}
|
||
}
|
||
#endregion
|
||
|
||
#region Tree点击事件
|
||
/// <summary>
|
||
/// Tree点击事件
|
||
/// </summary>
|
||
/// <param name="sender"></param>
|
||
/// <param name="e"></param>
|
||
protected void trWBS_NodeCommand(object sender, TreeCommandEventArgs e)
|
||
{
|
||
this.Grid1.Title = string.Empty;
|
||
string title = string.Empty;
|
||
string nodeTooltip = string.Empty;
|
||
string nodeText = string.Empty;
|
||
TreeNode parent1 = new TreeNode();
|
||
if (this.trWBS.SelectedNode != null)
|
||
{
|
||
nodeTooltip = this.trWBS.SelectedNode.ToolTip;
|
||
nodeText = this.trWBS.SelectedNode.Text;
|
||
parent1 = this.trWBS.SelectedNode.ParentNode;
|
||
}
|
||
if (parent1 != null)
|
||
{
|
||
TreeNode parent2 = parent1.ParentNode;
|
||
if (parent2 != null)
|
||
{
|
||
TreeNode parent3 = parent2.ParentNode;
|
||
if (parent3 != null)
|
||
{
|
||
TreeNode parent4 = parent3.ParentNode;
|
||
if (parent4 != null)
|
||
{
|
||
TreeNode parent5 = parent4.ParentNode;
|
||
if (parent5 != null)
|
||
{
|
||
TreeNode parent6 = parent5.ParentNode;
|
||
if (parent6 != null)
|
||
{
|
||
title = parent6.ToolTip + "-" + parent5.ToolTip + "-" + nodeTooltip + "/" + parent6.Text + "-" + parent5.Text + "-" + parent4.Text + "-" + parent3.Text + "-" + parent2.Text + "-" + parent1.Text + "-" + nodeText;
|
||
}
|
||
else
|
||
{
|
||
if (parent5.CommandName == "installation")
|
||
{
|
||
title = parent5.ToolTip + "-" + parent4.ToolTip + "-" + nodeTooltip + "/" + parent5.Text + "-" + parent4.Text + "-" + parent3.Text + "-" + parent2.Text + "-" + parent1.Text + "-" + nodeText;
|
||
}
|
||
}
|
||
}
|
||
else
|
||
{
|
||
if (parent4.CommandName == "installation")
|
||
{
|
||
title = parent4.ToolTip + "-" + parent3.ToolTip + "-" + nodeTooltip + "/" + parent4.Text + "-" + parent3.Text + "-" + parent2.Text + "-" + parent1.Text + "-" + nodeText;
|
||
}
|
||
}
|
||
}
|
||
else
|
||
{
|
||
if (parent3.CommandName == "installation")
|
||
{
|
||
title = parent3.ToolTip + "-" + parent2.ToolTip + "-" + nodeTooltip + "/" + parent3.Text + "-" + parent2.Text + "-" + parent1.Text + "-" + nodeText;
|
||
}
|
||
}
|
||
}
|
||
else
|
||
{
|
||
if (parent2.CommandName == "installation")
|
||
{
|
||
title = parent2.ToolTip + "-" + parent1.ToolTip + "-" + nodeTooltip + "/" + parent2.Text + "-" + parent1.Text + "-" + nodeText;
|
||
}
|
||
}
|
||
}
|
||
else
|
||
{
|
||
if (parent1.CommandName == "installation")
|
||
{
|
||
title = parent1.ToolTip + "-" + nodeTooltip + "/" + parent1.Text + "-" + nodeText;
|
||
}
|
||
}
|
||
}
|
||
else
|
||
{
|
||
title = nodeTooltip + "/" + nodeText;
|
||
}
|
||
this.Grid1.Title = title;
|
||
|
||
BindGrid();
|
||
OutputSummaryData();
|
||
}
|
||
#endregion
|
||
|
||
#region 保存方法
|
||
/// <summary>
|
||
/// 保存方法
|
||
/// </summary>
|
||
/// <param name="message"></param>
|
||
private void SaveData()
|
||
{
|
||
if (this.Grid1.Rows.Count > 0)
|
||
{
|
||
if (!string.IsNullOrEmpty(this.Grid1.Rows[0].Values[10].ToString()))
|
||
{
|
||
decimal totalValue = 0, totalRate = 0;
|
||
decimal moneys = Convert.ToDecimal(this.Grid1.Rows[0].Values[10].ToString());
|
||
for (int i = 0; i < this.Grid1.Rows.Count; i++)
|
||
{
|
||
if (!string.IsNullOrEmpty(this.Grid1.Rows[i].Values[1].ToString()))
|
||
{
|
||
decimal rate = 0;
|
||
totalValue += Convert.ToDecimal(this.Grid1.Rows[i].Values[1].ToString());
|
||
if (moneys != 0)
|
||
{
|
||
rate = decimal.Round(Convert.ToDecimal(this.Grid1.Rows[i].Values[1].ToString()) / moneys * 100, 2);
|
||
}
|
||
|
||
totalRate += rate;
|
||
this.Grid1.Rows[i].Values[2] = totalValue;
|
||
this.Grid1.Rows[i].Values[3] = totalRate;
|
||
if (i == this.Grid1.Rows.Count - 1)
|
||
{
|
||
if (moneys == totalValue)
|
||
{
|
||
this.Grid1.Rows[i].Values[3] = 100;
|
||
}
|
||
}
|
||
}
|
||
}
|
||
if (totalValue != moneys)
|
||
{
|
||
Alert.ShowInTop("金额分配不符合要求！", MessageBoxIcon.Warning);
|
||
return;
|
||
}
|
||
}
|
||
if (this.Grid1.Rows[this.Grid1.Rows.Count - 1].Values[3].ToString() != "100")
|
||
{
|
||
Alert.ShowInTop("占比值不是100%！", MessageBoxIcon.Warning);
|
||
return;
|
||
}
|
||
}
|
||
|
||
Model.Wbs_WbsSet wbsSet = BLL.WbsSetService.GetWbsSetByWbsSetId(this.trWBS.SelectedNodeID);
|
||
wbsSet.IsPlanApprove = true;
|
||
if (string.IsNullOrEmpty(wbsSet.VersionNum))
|
||
{
|
||
wbsSet.VersionNum = "V1.0";
|
||
}
|
||
else
|
||
{
|
||
string version = wbsSet.VersionNum.Substring(1, wbsSet.VersionNum.Length - 3);
|
||
wbsSet.VersionNum = "V" + (Convert.ToInt32(version) + 1) + ".0";
|
||
}
|
||
|
||
BLL.WbsSetService.UpdateWbsSet(wbsSet);
|
||
for (int i = 0; i < this.Grid1.Rows.Count; i++)
|
||
{
|
||
string type = this.trWBS.SelectedNode.CommandName;
|
||
if (type == "wbsSet")
|
||
{
|
||
var childWbsSets = BLL.WbsSetService.GetApproveWbsSetsBySuperWbsSetId(this.trWBS.SelectedNodeID);
|
||
if (childWbsSets.Count == 0) //当前为末级
|
||
{
|
||
Model.WbsDetail detail = new Model.WbsDetail();
|
||
detail.WbsDetailId = this.Grid1.Rows[i].Values[4].ToString();
|
||
detail.ToWbs = this.Grid1.Rows[i].Values[5].ToString();
|
||
detail.ToFlag = Convert.ToInt32(this.Grid1.Rows[i].Values[6].ToString());
|
||
detail.Way = this.Grid1.Rows[i].Values[7].ToString();
|
||
detail.Months = Convert.ToDateTime(this.Grid1.Rows[i].Values[9].ToString());
|
||
if (!string.IsNullOrEmpty(this.Grid1.Rows[i].Values[1].ToString()))
|
||
{
|
||
detail.PlanValue = Convert.ToDecimal(this.Grid1.Rows[i].Values[1].ToString());
|
||
if (Convert.ToDecimal(this.Grid1.Rows[i].Values[10].ToString()) != 0)
|
||
{
|
||
detail.PlanValueRate = decimal.Round(Convert.ToDecimal(detail.PlanValue) / Convert.ToDecimal(this.Grid1.Rows[i].Values[10].ToString()) * 100, 2);
|
||
}
|
||
else
|
||
{
|
||
detail.PlanValueRate = 0;
|
||
}
|
||
}
|
||
var oldDetail = BLL.WbsDetailService.GetWbsDetailByWbsDetailId(detail.WbsDetailId);
|
||
if (oldDetail == null)
|
||
{
|
||
BLL.WbsDetailService.AddWbsDetail(detail);
|
||
|
||
}
|
||
else
|
||
{
|
||
decimal? oldValue = oldDetail.PlanValue;
|
||
detail.CompleteValue = oldDetail.CompleteValue;
|
||
detail.CompleteValueRate = oldDetail.CompleteValueRate;
|
||
detail.RealValue = oldDetail.RealValue;
|
||
detail.RealValueRate = oldDetail.RealValueRate;
|
||
BLL.WbsDetailService.UpdateWbsDetail(detail);
|
||
|
||
}
|
||
}
|
||
}
|
||
}
|
||
//BLL.Sys_LogService.AddLog(BLL.Const.System_9, this.CurrUser.LoginProjectId, this.CurrUser.UserId, "审核计划值");
|
||
ShowNotify("保存成功！", MessageBoxIcon.Success);
|
||
}
|
||
#endregion
|
||
|
||
#region 保存方法2(用于展开末级项时的自动保存)
|
||
/// <summary>
|
||
/// 保存方法2(用于展开末级项时的自动保存)
|
||
/// </summary>
|
||
/// <param name="message"></param>
|
||
private void SaveData2()
|
||
{
|
||
Model.Wbs_WbsSet wbsSet = BLL.WbsSetService.GetWbsSetByWbsSetId(this.trWBS.SelectedNodeID);
|
||
for (int i = 0; i < this.Grid1.Rows.Count; i++)
|
||
{
|
||
string type = this.trWBS.SelectedNode.CommandName;
|
||
if (type == "wbsSet")
|
||
{
|
||
var childWbsSets = BLL.WbsSetService.GetApproveWbsSetsBySuperWbsSetId(this.trWBS.SelectedNodeID);
|
||
if (childWbsSets.Count == 0) //当前为末级
|
||
{
|
||
Model.WbsDetail detail = new Model.WbsDetail();
|
||
detail.WbsDetailId = this.Grid1.Rows[i].Values[4].ToString();
|
||
detail.ToWbs = this.Grid1.Rows[i].Values[5].ToString();
|
||
detail.ToFlag = Convert.ToInt32(this.Grid1.Rows[i].Values[6].ToString());
|
||
detail.Way = this.Grid1.Rows[i].Values[7].ToString();
|
||
detail.Months = Convert.ToDateTime(this.Grid1.Rows[i].Values[9].ToString());
|
||
if (!string.IsNullOrEmpty(this.Grid1.Rows[i].Values[1].ToString()))
|
||
{
|
||
detail.PlanValue = Convert.ToDecimal(this.Grid1.Rows[i].Values[1].ToString());
|
||
if (this.Grid1.Rows[i].Values[10].ToString() != "0")
|
||
{
|
||
detail.PlanValueRate = decimal.Round(Convert.ToDecimal(detail.PlanValue) / Convert.ToDecimal(this.Grid1.Rows[i].Values[10].ToString()) * 100, 2);
|
||
}
|
||
}
|
||
var oldDetail = BLL.WbsDetailService.GetWbsDetailByWbsDetailId(detail.WbsDetailId);
|
||
if (oldDetail == null)
|
||
{
|
||
BLL.WbsDetailService.AddWbsDetail(detail);
|
||
|
||
}
|
||
}
|
||
}
|
||
}
|
||
//BLL.Sys_LogService.AddLog(BLL.Const.System_9, this.CurrUser.LoginProjectId, this.CurrUser.UserId, "审核计划值");
|
||
}
|
||
#endregion
|
||
|
||
#region 增加分部分项
|
||
/// <summary>
|
||
/// 增加分部分项
|
||
/// </summary>
|
||
/// <param name="years"></param>
|
||
/// <param name="months"></param>
|
||
/// <param name="planValue"></param>
|
||
/// <param name="parentId"></param>
|
||
private void AddWbsParentDetail(DateTime months, decimal? planValue, string parentId, decimal? completeValue, decimal? realValue)
|
||
{
|
||
Model.Wbs_WbsSet parentWbsSet1 = BLL.WbsSetService.GetWbsSetByWbsSetId(parentId);
|
||
if (parentWbsSet1 != null)
|
||
{
|
||
if (parentWbsSet1.WeightsMoney != null)
|
||
{
|
||
if (parentWbsSet1.SuperWbsSetId != null) //父节点不是分部节点
|
||
{
|
||
Model.WbsDetail detail1 = BLL.WbsDetailService.GetWbsDetailByWbsFlagYearMonth(parentWbsSet1.WbsSetId, 4, months);
|
||
if (detail1 == null)
|
||
{
|
||
Model.WbsDetail newDetail1 = new Model.WbsDetail();
|
||
newDetail1.WbsDetailId = SQLHelper.GetNewID(typeof(Model.WbsDetail));
|
||
newDetail1.ToWbs = parentWbsSet1.WbsSetId;
|
||
newDetail1.ToFlag = 4;
|
||
newDetail1.Way = parentWbsSet1.Way;
|
||
newDetail1.Months = months;
|
||
newDetail1.PlanValue = planValue ?? 0;
|
||
newDetail1.CompleteValue = completeValue ?? 0;
|
||
newDetail1.RealValue = realValue ?? 0;
|
||
if (parentWbsSet1.WeightsMoney != null)
|
||
{
|
||
newDetail1.PlanValueRate = decimal.Round(Convert.ToDecimal(newDetail1.PlanValue) / Convert.ToDecimal(parentWbsSet1.WeightsMoney) * 100, 2);
|
||
newDetail1.CompleteValueRate = decimal.Round(Convert.ToDecimal(newDetail1.CompleteValue) / Convert.ToDecimal(parentWbsSet1.WeightsMoney) * 100, 2);
|
||
newDetail1.RealValueRate = decimal.Round(Convert.ToDecimal(newDetail1.RealValue) / Convert.ToDecimal(parentWbsSet1.WeightsMoney) * 100, 2);
|
||
}
|
||
else
|
||
{
|
||
newDetail1.PlanValueRate = 0;
|
||
newDetail1.CompleteValueRate = 0;
|
||
newDetail1.RealValueRate = 0;
|
||
}
|
||
BLL.WbsDetailService.AddWbsDetail(newDetail1);
|
||
}
|
||
else
|
||
{
|
||
detail1.PlanValue += planValue ?? 0;
|
||
detail1.CompleteValue += completeValue ?? 0;
|
||
detail1.RealValue += realValue ?? 0;
|
||
if (parentWbsSet1.WeightsMoney != null)
|
||
{
|
||
detail1.PlanValueRate = decimal.Round(Convert.ToDecimal(detail1.PlanValue) / Convert.ToDecimal(parentWbsSet1.WeightsMoney) * 100, 2);
|
||
detail1.CompleteValueRate = decimal.Round(Convert.ToDecimal(detail1.CompleteValue) / Convert.ToDecimal(parentWbsSet1.WeightsMoney) * 100, 2);
|
||
detail1.RealValueRate = decimal.Round(Convert.ToDecimal(detail1.RealValue) / Convert.ToDecimal(parentWbsSet1.WeightsMoney) * 100, 2);
|
||
}
|
||
else
|
||
{
|
||
detail1.PlanValueRate = 0;
|
||
detail1.CompleteValueRate = 0;
|
||
detail1.RealValueRate = 0;
|
||
}
|
||
BLL.WbsDetailService.UpdateWbsDetail(detail1);
|
||
}
|
||
AddWbsParentDetail(months, planValue, parentWbsSet1.SuperWbsSetId, completeValue, realValue);
|
||
}
|
||
else
|
||
{
|
||
Model.WbsDetail detail1 = BLL.WbsDetailService.GetWbsDetailByWbsFlagYearMonth(parentWbsSet1.WbsSetId, 4, months);
|
||
if (detail1 == null)
|
||
{
|
||
Model.WbsDetail newDetail1 = new Model.WbsDetail();
|
||
newDetail1.WbsDetailId = SQLHelper.GetNewID(typeof(Model.WbsDetail));
|
||
newDetail1.ToWbs = parentWbsSet1.WbsSetId;
|
||
newDetail1.ToFlag = 4;
|
||
newDetail1.Way = parentWbsSet1.Way;
|
||
newDetail1.Months = months;
|
||
newDetail1.PlanValue = planValue;
|
||
newDetail1.CompleteValue = completeValue ?? 0;
|
||
newDetail1.RealValue = realValue ?? 0;
|
||
if (parentWbsSet1.WeightsMoney != null)
|
||
{
|
||
newDetail1.PlanValueRate = decimal.Round(Convert.ToDecimal(newDetail1.PlanValue) / Convert.ToDecimal(parentWbsSet1.WeightsMoney) * 100, 2);
|
||
newDetail1.CompleteValueRate = decimal.Round(Convert.ToDecimal(newDetail1.CompleteValue) / Convert.ToDecimal(parentWbsSet1.WeightsMoney) * 100, 2);
|
||
newDetail1.RealValueRate = decimal.Round(Convert.ToDecimal(newDetail1.RealValue) / Convert.ToDecimal(parentWbsSet1.WeightsMoney) * 100, 2);
|
||
}
|
||
else
|
||
{
|
||
newDetail1.PlanValueRate = 0;
|
||
newDetail1.CompleteValueRate = 0;
|
||
newDetail1.RealValueRate = 0;
|
||
}
|
||
BLL.WbsDetailService.AddWbsDetail(newDetail1);
|
||
}
|
||
else
|
||
{
|
||
detail1.PlanValue += planValue;
|
||
detail1.CompleteValue += completeValue ?? 0;
|
||
detail1.RealValue += realValue ?? 0;
|
||
if (parentWbsSet1.WeightsMoney != null)
|
||
{
|
||
detail1.PlanValueRate = decimal.Round(Convert.ToDecimal(detail1.PlanValue) / Convert.ToDecimal(parentWbsSet1.WeightsMoney) * 100, 2);
|
||
detail1.CompleteValueRate = decimal.Round(Convert.ToDecimal(detail1.CompleteValue) / Convert.ToDecimal(parentWbsSet1.WeightsMoney) * 100, 2);
|
||
detail1.RealValueRate = decimal.Round(Convert.ToDecimal(detail1.RealValue) / Convert.ToDecimal(parentWbsSet1.WeightsMoney) * 100, 2);
|
||
}
|
||
else
|
||
{
|
||
detail1.PlanValueRate = 0;
|
||
detail1.CompleteValueRate = 0;
|
||
detail1.RealValueRate = 0;
|
||
}
|
||
BLL.WbsDetailService.UpdateWbsDetail(detail1);
|
||
}
|
||
}
|
||
}
|
||
}
|
||
}
|
||
#endregion
|
||
|
||
#region 更新分部分项
|
||
/// <summary>
|
||
/// 更新分部分项
|
||
/// </summary>
|
||
/// <param name="years"></param>
|
||
/// <param name="months"></param>
|
||
/// <param name="planValue"></param>
|
||
/// <param name="parentId"></param>
|
||
private void UpdateWbsParentDetail(DateTime months, decimal? planValue, decimal? oldPlanValue, string parentId)
|
||
{
|
||
Model.Wbs_WbsSet parentWbsSet1 = BLL.WbsSetService.GetWbsSetByWbsSetId(parentId);
|
||
if (parentWbsSet1 != null)
|
||
{
|
||
Model.WbsDetail detail1 = BLL.WbsDetailService.GetWbsDetailByWbsFlagYearMonth(parentWbsSet1.WbsSetId, 4, months);
|
||
if (detail1 != null)
|
||
{
|
||
if (parentWbsSet1.SuperWbsSetId != null) //父节点不是分部节点
|
||
{
|
||
detail1.PlanValue += ((planValue ?? 0) - (oldPlanValue ?? 0));
|
||
detail1.PlanValueRate = decimal.Round(Convert.ToDecimal(detail1.PlanValue) / Convert.ToDecimal(parentWbsSet1.WeightsMoney) * 100, 2);
|
||
BLL.WbsDetailService.UpdateWbsDetail(detail1);
|
||
UpdateWbsParentDetail(months, planValue, oldPlanValue, parentWbsSet1.SuperWbsSetId);
|
||
}
|
||
else
|
||
{
|
||
detail1.PlanValue += ((planValue ?? 0) - (oldPlanValue ?? 0));
|
||
detail1.PlanValueRate = decimal.Round(Convert.ToDecimal(detail1.PlanValue) / Convert.ToDecimal(parentWbsSet1.WeightsMoney) * 100, 2);
|
||
BLL.WbsDetailService.UpdateWbsDetail(detail1);
|
||
}
|
||
}
|
||
}
|
||
}
|
||
#endregion
|
||
|
||
#region 提交、保存按钮
|
||
/// <summary>
|
||
/// 提交
|
||
/// </summary>
|
||
/// <param name="sender"></param>
|
||
/// <param name="e"></param>
|
||
protected void btnSave_Click(object sender, EventArgs e)
|
||
{
|
||
if (this.Grid1.Rows.Count > 0)
|
||
{
|
||
SaveData();
|
||
}
|
||
else
|
||
{
|
||
Alert.ShowInTop("请至少选择一条记录！", MessageBoxIcon.Warning);
|
||
return;
|
||
}
|
||
}
|
||
|
||
#endregion
|
||
|
||
#region 查看之前版本
|
||
/// <summary>
|
||
/// 查看之前版本
|
||
/// </summary>
|
||
/// <param name="sender"></param>
|
||
/// <param name="e"></param>
|
||
protected void btnSee_Click(object sender, EventArgs e)
|
||
{
|
||
PageContext.RegisterStartupScript(Window1.GetShowReference(String.Format("SeeDetailHistory.aspx?ToWbs={0}", this.trWBS.SelectedNodeID, "编辑 - ")));
|
||
}
|
||
#endregion
|
||
|
||
#region 绑定数据
|
||
/// <summary>
|
||
/// 绑定数据
|
||
/// </summary>
|
||
/// <param name="sender"></param>
|
||
/// <param name="e"></param>
|
||
protected void Grid1_FilterChange(object sender, EventArgs e)
|
||
{
|
||
BindGrid();
|
||
}
|
||
|
||
protected void Grid1_PageIndexChange(object sender, GridPageEventArgs e)
|
||
{
|
||
Grid1.PageIndex = e.NewPageIndex;
|
||
BindGrid();
|
||
}
|
||
|
||
/// <summary>
|
||
/// Grid1排序
|
||
/// </summary>
|
||
/// <param name="sender"></param>
|
||
/// <param name="e"></param>
|
||
protected void Grid1_Sort(object sender, GridSortEventArgs e)
|
||
{
|
||
Grid1.SortDirection = e.SortDirection;
|
||
Grid1.SortField = e.SortField;
|
||
BindGrid();
|
||
}
|
||
|
||
/// <summary>
|
||
/// 加载Grid
|
||
/// </summary>
|
||
private void BindGrid()
|
||
{
|
||
this.btnSave.Hidden = true;
|
||
this.btnSee.Hidden = true;
|
||
DateTime startDate, endDate, startMonth, endMonth, parentStartDate, parentEndDate, parentStartMonth, parentEndMonth;
|
||
List<Model.WBSDetailItem> items = new List<Model.WBSDetailItem>();
|
||
List<DateTime> months = new List<DateTime>();
|
||
string column0 = string.Empty;
|
||
decimal totalValue = 0, totalRate = 0;
|
||
RenderField column = Grid1.FindColumn("PlanValue") as RenderField;
|
||
column.EnableColumnEdit = false;
|
||
this.lbIsAudit.Text = string.Empty;
|
||
if (this.trWBS.SelectedNode != null)
|
||
{
|
||
#region 分部分项
|
||
if (this.trWBS.SelectedNode.CommandName == "wbsSet")
|
||
{
|
||
Model.Wbs_WbsSet wbsSet = BLL.WbsSetService.GetWbsSetByWbsSetId(this.trWBS.SelectedNode.NodeID);
|
||
if (wbsSet != null)
|
||
{
|
||
var childWbsSets = BLL.WbsSetService.GetApproveWbsSetsBySuperWbsSetId(wbsSet.WbsSetId);
|
||
if (childWbsSets.Count() == 0) //当前为末级
|
||
{
|
||
BLL.WbsSetService.UpdateWbsSetIsPlanApprove(wbsSet, true);
|
||
this.lbIsAudit.Text = "已审核！";
|
||
}
|
||
startDate = Convert.ToDateTime(wbsSet.StartDate);
|
||
endDate = Convert.ToDateTime(wbsSet.EndDate);
|
||
startMonth = Convert.ToDateTime(startDate.Year + "-" + startDate.Month + "-01");
|
||
endMonth = Convert.ToDateTime(endDate.Year + "-" + endDate.Month + "-01");
|
||
do
|
||
{
|
||
months.Add(startMonth);
|
||
startMonth = startMonth.AddMonths(1);
|
||
} while (startMonth <= endMonth);
|
||
column0 = "进度计划开始日期：" + string.Format("{0:yyyy-MM-dd}", startDate) + "<br/>进度计划结束日期：" + string.Format("{0:yyyy-MM-dd}", endDate);
|
||
this.Grid1.Columns[0].HeaderText = column0;
|
||
|
||
if (childWbsSets.Count == 0) //当前为末级
|
||
{
|
||
//获取父级节点的月份集合
|
||
List<DateTime> parentMonths = new List<DateTime>(); //父级节点的月份集合
|
||
string parentId = this.trWBS.SelectedNode.ParentNode.NodeID;
|
||
Model.Wbs_WbsSet parentWbsSet = BLL.WbsSetService.GetWbsSetByWbsSetId(parentId);
|
||
if (parentWbsSet != null) //父级为分部
|
||
{
|
||
parentStartDate = Convert.ToDateTime(parentWbsSet.StartDate);
|
||
parentEndDate = Convert.ToDateTime(parentWbsSet.EndDate);
|
||
parentStartMonth = Convert.ToDateTime(parentStartDate.Year + "-" + parentStartDate.Month + "-01");
|
||
parentEndMonth = Convert.ToDateTime(parentEndDate.Year + "-" + parentEndDate.Month + "-01");
|
||
do
|
||
{
|
||
parentMonths.Add(parentStartMonth);
|
||
parentStartMonth = parentStartMonth.AddMonths(1);
|
||
} while (parentStartMonth <= parentEndMonth);
|
||
}
|
||
else //父级为质量行为
|
||
{
|
||
Model.Wbs_UnitProject unitProject = BLL.UnitProjectService.GetUnitProjectByUnitProjectId(parentId);
|
||
if (unitProject != null)
|
||
{
|
||
parentStartDate = Convert.ToDateTime(unitProject.StartDate);
|
||
parentEndDate = Convert.ToDateTime(unitProject.EndDate);
|
||
parentStartMonth = Convert.ToDateTime(parentStartDate.Year + "-" + parentStartDate.Month + "-01");
|
||
parentEndMonth = Convert.ToDateTime(parentEndDate.Year + "-" + parentEndDate.Month + "-01");
|
||
do
|
||
{
|
||
parentMonths.Add(parentStartMonth);
|
||
parentStartMonth = parentStartMonth.AddMonths(1);
|
||
} while (parentStartMonth <= parentEndMonth);
|
||
}
|
||
}
|
||
|
||
RenderField columnPlanValue = Grid1.FindColumn("PlanValue") as RenderField;
|
||
columnPlanValue.EnableColumnEdit = true;
|
||
if (BLL.CommonService.GetAllButtonPowerList(this.CurrUser.LoginProjectId, this.CurrUser.UserId, Const.WBSPlanAuditMenuId, Const.BtnSave))
|
||
{
|
||
this.btnSave.Hidden = false;
|
||
this.btnSee.Hidden = false;
|
||
}
|
||
if (BLL.CommonService.GetAllButtonPowerList(this.CurrUser.LoginProjectId, this.CurrUser.UserId, Const.WBSPlanAuditMenuId, Const.BtnAuditing))
|
||
{
|
||
this.btnSee.Hidden = false;
|
||
}
|
||
for (int i = 0; i < months.Count; i++)
|
||
{
|
||
Model.WbsDetail detail = BLL.WbsDetailService.GetWbsDetailByWbsFlagYearMonth(wbsSet.WbsSetId, 4, months[i]);
|
||
if (detail == null)
|
||
{
|
||
Model.WBSDetailItem item = new Model.WBSDetailItem();
|
||
item.WbsDetailId = SQLHelper.GetNewID(typeof(Model.WbsDetail));
|
||
item.ToWbs = wbsSet.WbsSetId;
|
||
item.ToFlag = 4; //分部分项
|
||
item.Way = wbsSet.Way;
|
||
item.Months = months[i];
|
||
item.YearsMonthsStr = months[i].Year + "年" + months[i].Month + "月";
|
||
item.WeightsMoney = wbsSet.WeightsMoney;
|
||
if (wbsSet.WeightsMoney != null)
|
||
{
|
||
decimal moneys = decimal.Round(Convert.ToDecimal(wbsSet.WeightsMoney), 2);
|
||
if (i == months.Count - 1)
|
||
{
|
||
decimal lastPlanValue = decimal.Round(Convert.ToDecimal(wbsSet.WeightsMoney - totalValue), 2);
|
||
if (lastPlanValue >= 0)
|
||
{
|
||
item.PlanValue = lastPlanValue;
|
||
}
|
||
}
|
||
else
|
||
{
|
||
item.PlanValue = WbsDetailService.GetMonthPlanValueByMonthCountAndMonthNumAndWeightMonth(months.Count, i + 1, Convert.ToDecimal(wbsSet.WeightsMoney));
|
||
}
|
||
if (wbsSet.WeightsMoney != 0)
|
||
{
|
||
item.PlanValueRate = decimal.Round(Convert.ToDecimal(item.PlanValue / wbsSet.WeightsMoney * 100), 2);
|
||
}
|
||
else
|
||
{
|
||
item.PlanValueRate = 0;
|
||
}
|
||
totalValue += item.PlanValue != null ? item.PlanValue.Value : 0;
|
||
totalRate += item.PlanValueRate != null ? item.PlanValueRate.Value : 0;
|
||
item.PlanValueTotal = totalValue;
|
||
item.PlanValueRateTotal = totalRate;
|
||
if (i == months.Count - 1)
|
||
{
|
||
if (wbsSet.WeightsMoney == totalValue)
|
||
{
|
||
item.PlanValueRateTotal = 100;
|
||
}
|
||
}
|
||
}
|
||
items.Add(item);
|
||
}
|
||
else
|
||
{
|
||
Model.WBSDetailItem item = new Model.WBSDetailItem();
|
||
item.WbsDetailId = detail.WbsDetailId;
|
||
item.ToWbs = detail.ToWbs;
|
||
item.ToFlag = 4; //分部分项
|
||
item.Way = detail.Way;
|
||
item.Months = months[i];
|
||
item.YearsMonthsStr = months[i].Year + "年" + months[i].Month + "月";
|
||
item.WeightsMoney = wbsSet.WeightsMoney;
|
||
if (detail.PlanValue != null)
|
||
{
|
||
item.PlanValue = decimal.Round(Convert.ToDecimal(detail.PlanValue), 2);
|
||
item.PlanValueRate = decimal.Round(Convert.ToDecimal(detail.PlanValueRate), 2);
|
||
totalValue += decimal.Round(Convert.ToDecimal(item.PlanValue), 2);
|
||
totalRate += decimal.Round(Convert.ToDecimal(item.PlanValueRate), 2);
|
||
item.PlanValueTotal = totalValue;
|
||
item.PlanValueRateTotal = totalRate;
|
||
if (i == months.Count - 1)
|
||
{
|
||
if (wbsSet.WeightsMoney == totalValue)
|
||
{
|
||
item.PlanValueRateTotal = 100;
|
||
}
|
||
}
|
||
}
|
||
items.Add(item);
|
||
}
|
||
}
|
||
for (int i = 0; i < parentMonths.Count; i++)
|
||
{
|
||
if (!months.Contains(parentMonths[i]))
|
||
{
|
||
Model.WbsDetail detail = (from x in Funs.DB.WbsDetail
|
||
where x.ToWbs == wbsSet.WbsSetId && x.Months == parentMonths[i]
|
||
select x).FirstOrDefault();
|
||
if (detail == null)
|
||
{
|
||
Model.WBSDetailItem item = new Model.WBSDetailItem();
|
||
item.WbsDetailId = SQLHelper.GetNewID(typeof(Model.WbsDetail));
|
||
item.ToWbs = wbsSet.WbsSetId;
|
||
item.ToFlag = 4; //分部分项
|
||
item.Way = wbsSet.Way;
|
||
item.Months = parentMonths[i];
|
||
item.YearsMonthsStr = parentMonths[i].Year + "年" + parentMonths[i].Month + "月";
|
||
item.WeightsMoney = wbsSet.WeightsMoney;
|
||
item.PlanValue = 0;
|
||
item.PlanValueRate = 0;
|
||
items.Add(item);
|
||
}
|
||
else
|
||
{
|
||
Model.WBSDetailItem item = new Model.WBSDetailItem();
|
||
item.WbsDetailId = detail.WbsDetailId;
|
||
item.ToWbs = wbsSet.WbsSetId;
|
||
item.ToFlag = 4; //分部分项
|
||
item.Way = wbsSet.Way;
|
||
item.Months = parentMonths[i];
|
||
item.YearsMonthsStr = parentMonths[i].Year + "年" + parentMonths[i].Month + "月";
|
||
item.WeightsMoney = wbsSet.WeightsMoney;
|
||
item.PlanValue = detail.PlanValue;
|
||
item.PlanValueRate = detail.PlanValueRate;
|
||
items.Add(item);
|
||
}
|
||
}
|
||
}
|
||
items = items.OrderBy(x => x.Months).ToList();
|
||
}
|
||
else //当前不为末级
|
||
{
|
||
for (int i = 0; i < months.Count; i++)
|
||
{
|
||
Model.WbsDetail detail = BLL.WbsDetailService.GetWbsDetailByWbsFlagYearMonth(wbsSet.WbsSetId, 4, months[i]);
|
||
if (detail != null)
|
||
{
|
||
Model.WBSDetailItem item = new Model.WBSDetailItem();
|
||
item.WbsDetailId = detail.WbsDetailId;
|
||
item.ToWbs = detail.ToWbs;
|
||
item.ToFlag = 4; //分部分项
|
||
item.Way = detail.Way;
|
||
item.Months = months[i];
|
||
item.YearsMonthsStr = months[i].Year + "年" + months[i].Month + "月";
|
||
item.WeightsMoney = wbsSet.WeightsMoney;
|
||
if (detail.PlanValue != null)
|
||
{
|
||
item.PlanValue = decimal.Round(Convert.ToDecimal(detail.PlanValue), 2);
|
||
item.PlanValueRate = decimal.Round(Convert.ToDecimal(detail.PlanValueRate), 2);
|
||
totalValue += decimal.Round(Convert.ToDecimal(item.PlanValue), 2);
|
||
totalRate += decimal.Round(Convert.ToDecimal(item.PlanValueRate), 2);
|
||
item.PlanValueTotal = totalValue;
|
||
item.PlanValueRateTotal = totalRate;
|
||
if (i == months.Count - 1)
|
||
{
|
||
if (wbsSet.WeightsMoney == totalValue)
|
||
{
|
||
item.PlanValueRateTotal = 100;
|
||
}
|
||
}
|
||
}
|
||
items.Add(item);
|
||
}
|
||
}
|
||
}
|
||
}
|
||
}
|
||
#endregion
|
||
#region 单位工程/子单位工程
|
||
else if (this.trWBS.SelectedNode.CommandName == "unitProject" || this.trWBS.SelectedNode.CommandName == "childUnitProject")
|
||
{
|
||
Model.Wbs_UnitProject unitProject = BLL.UnitProjectService.GetUnitProjectByUnitProjectId(this.trWBS.SelectedNode.NodeID);
|
||
if (unitProject != null)
|
||
{
|
||
startDate = Convert.ToDateTime(unitProject.StartDate);
|
||
endDate = Convert.ToDateTime(unitProject.EndDate);
|
||
startMonth = Convert.ToDateTime(startDate.Year + "-" + startDate.Month + "-01");
|
||
endMonth = Convert.ToDateTime(endDate.Year + "-" + endDate.Month + "-01");
|
||
do
|
||
{
|
||
months.Add(startMonth);
|
||
startMonth = startMonth.AddMonths(1);
|
||
} while (startMonth <= endMonth);
|
||
column0 = "进度计划开始日期：" + string.Format("{0:yyyy-MM-dd}", startDate) + "<br/>进度计划结束日期：" + string.Format("{0:yyyy-MM-dd}", endDate);
|
||
this.Grid1.Columns[0].HeaderText = column0;
|
||
for (int i = 0; i < months.Count; i++)
|
||
{
|
||
Model.WbsDetail detail = BLL.WbsDetailService.GetWbsDetailByWbsFlagYearMonth(unitProject.UnitProjectId, 3, months[i]);
|
||
if (detail != null)
|
||
{
|
||
Model.WBSDetailItem item = new Model.WBSDetailItem();
|
||
item.WbsDetailId = detail.WbsDetailId;
|
||
item.ToWbs = detail.ToWbs;
|
||
item.ToFlag = 3; //单位工程/子单位工程
|
||
item.Way = detail.Way;
|
||
item.Months = months[i];
|
||
item.YearsMonthsStr = months[i].Year + "年" + months[i].Month + "月";
|
||
item.WeightsMoney = unitProject.WeightsMoney;
|
||
if (detail.PlanValue != null)
|
||
{
|
||
item.PlanValue = decimal.Round(Convert.ToDecimal(detail.PlanValue), 2);
|
||
item.PlanValueRate = decimal.Round(Convert.ToDecimal(detail.PlanValueRate), 2);
|
||
totalValue += decimal.Round(Convert.ToDecimal(item.PlanValue), 2);
|
||
totalRate += decimal.Round(Convert.ToDecimal(item.PlanValueRate), 2);
|
||
item.PlanValueTotal = totalValue;
|
||
item.PlanValueRateTotal = totalRate;
|
||
if (i == months.Count - 1)
|
||
{
|
||
if (unitProject.WeightsMoney == totalValue)
|
||
{
|
||
item.PlanValueRateTotal = 100;
|
||
}
|
||
}
|
||
}
|
||
items.Add(item);
|
||
}
|
||
}
|
||
}
|
||
}
|
||
#endregion
|
||
#region 专业
|
||
else if (this.trWBS.SelectedNode.CommandName == "cnProfession")
|
||
{
|
||
Model.WBS_CnProfession cnProfession = BLL.CnProfessionService.GetCnProfessionByCnProfessionId(this.trWBS.SelectedNode.NodeID);
|
||
if (cnProfession != null)
|
||
{
|
||
startDate = Convert.ToDateTime(cnProfession.StartDate);
|
||
endDate = Convert.ToDateTime(cnProfession.EndDate);
|
||
startMonth = Convert.ToDateTime(startDate.Year + "-" + startDate.Month + "-01");
|
||
endMonth = Convert.ToDateTime(endDate.Year + "-" + endDate.Month + "-01");
|
||
do
|
||
{
|
||
months.Add(startMonth);
|
||
startMonth = startMonth.AddMonths(1);
|
||
} while (startMonth <= endMonth);
|
||
column0 = "进度计划开始日期：" + string.Format("{0:yyyy-MM-dd}", startDate) + "<br/>进度计划结束日期：" + string.Format("{0:yyyy-MM-dd}", endDate);
|
||
this.Grid1.Columns[0].HeaderText = column0;
|
||
for (int i = 0; i < months.Count; i++)
|
||
{
|
||
Model.WbsDetail detail = BLL.WbsDetailService.GetWbsDetailByWbsFlagYearMonth(cnProfession.CnProfessionId, 2, months[i]);
|
||
if (detail != null)
|
||
{
|
||
Model.WBSDetailItem item = new Model.WBSDetailItem();
|
||
item.WbsDetailId = detail.WbsDetailId;
|
||
item.ToWbs = detail.ToWbs;
|
||
item.ToFlag = 2; //专业
|
||
item.Way = detail.Way;
|
||
item.Months = months[i];
|
||
item.YearsMonthsStr = months[i].Year + "年" + months[i].Month + "月";
|
||
item.WeightsMoney = cnProfession.WeightsMoney;
|
||
if (detail.PlanValue != null)
|
||
{
|
||
item.PlanValue = decimal.Round(Convert.ToDecimal(detail.PlanValue), 2);
|
||
item.PlanValueRate = decimal.Round(Convert.ToDecimal(detail.PlanValueRate), 2);
|
||
totalValue += decimal.Round(Convert.ToDecimal(item.PlanValue), 2);
|
||
totalRate += decimal.Round(Convert.ToDecimal(item.PlanValueRate), 2);
|
||
item.PlanValueTotal = totalValue;
|
||
item.PlanValueRateTotal = totalRate;
|
||
if (i == months.Count - 1)
|
||
{
|
||
if (cnProfession.WeightsMoney == totalValue)
|
||
{
|
||
item.PlanValueRateTotal = 100;
|
||
}
|
||
}
|
||
}
|
||
items.Add(item);
|
||
}
|
||
}
|
||
}
|
||
}
|
||
#endregion
|
||
#region 装置
|
||
else if (this.trWBS.SelectedNode.CommandName == "installation")
|
||
{
|
||
Model.Project_Installation installation = BLL.Project_InstallationService.GetInstallationByInstallationId(this.trWBS.SelectedNode.NodeID);
|
||
if (installation != null)
|
||
{
|
||
startDate = Convert.ToDateTime(installation.StartDate);
|
||
endDate = Convert.ToDateTime(installation.EndDate);
|
||
startMonth = Convert.ToDateTime(startDate.Year + "-" + startDate.Month + "-01");
|
||
endMonth = Convert.ToDateTime(endDate.Year + "-" + endDate.Month + "-01");
|
||
do
|
||
{
|
||
months.Add(startMonth);
|
||
startMonth = startMonth.AddMonths(1);
|
||
} while (startMonth <= endMonth);
|
||
column0 = "进度计划开始日期：" + string.Format("{0:yyyy-MM-dd}", startDate) + "<br/>进度计划结束日期：" + string.Format("{0:yyyy-MM-dd}", endDate);
|
||
this.Grid1.Columns[0].HeaderText = column0;
|
||
for (int i = 0; i < months.Count; i++)
|
||
{
|
||
Model.WbsDetail detail = BLL.WbsDetailService.GetWbsDetailByWbsFlagYearMonth(installation.InstallationId, 1, months[i]);
|
||
if (detail != null)
|
||
{
|
||
Model.WBSDetailItem item = new Model.WBSDetailItem();
|
||
item.WbsDetailId = detail.WbsDetailId;
|
||
item.ToWbs = detail.ToWbs;
|
||
item.ToFlag = 1; //装置
|
||
item.Way = detail.Way;
|
||
item.Months = months[i];
|
||
item.YearsMonthsStr = months[i].Year + "年" + months[i].Month + "月";
|
||
item.WeightsMoney = installation.WeightsMoney;
|
||
if (detail.PlanValue != null)
|
||
{
|
||
item.PlanValue = decimal.Round(Convert.ToDecimal(detail.PlanValue), 2);
|
||
item.PlanValueRate = decimal.Round(Convert.ToDecimal(detail.PlanValueRate), 2);
|
||
totalValue += decimal.Round(Convert.ToDecimal(item.PlanValue), 2);
|
||
totalRate += decimal.Round(Convert.ToDecimal(item.PlanValueRate), 2);
|
||
item.PlanValueTotal = totalValue;
|
||
item.PlanValueRateTotal = totalRate;
|
||
if (i == months.Count - 1)
|
||
{
|
||
if (installation.WeightsMoney == totalValue)
|
||
{
|
||
item.PlanValueRateTotal = 100;
|
||
}
|
||
}
|
||
}
|
||
items.Add(item);
|
||
}
|
||
}
|
||
}
|
||
}
|
||
#endregion
|
||
this.Grid1.DataSource = items;
|
||
this.Grid1.DataBind();
|
||
if (this.trWBS.SelectedNode.CommandName == "wbsSet")
|
||
{
|
||
Model.Wbs_WbsSet wbsSet = BLL.WbsSetService.GetWbsSetByWbsSetId(this.trWBS.SelectedNode.NodeID);
|
||
if (wbsSet != null)
|
||
{
|
||
var childWbsSets = BLL.WbsSetService.GetApproveWbsSetsBySuperWbsSetId(wbsSet.WbsSetId);
|
||
if (childWbsSets.Count == 0) //当前为末级
|
||
{
|
||
SaveData2();
|
||
wbsSet.IsPlanApprove = true;
|
||
if (string.IsNullOrEmpty(wbsSet.VersionNum))
|
||
{
|
||
wbsSet.VersionNum = "V1.0";
|
||
}
|
||
else
|
||
{
|
||
string version = wbsSet.VersionNum.Substring(1, wbsSet.VersionNum.Length - 3);
|
||
wbsSet.VersionNum = "V" + (Convert.ToInt32(version) + 1) + ".0";
|
||
}
|
||
BLL.WbsSetService.UpdateWbsSet(wbsSet);
|
||
}
|
||
}
|
||
}
|
||
}
|
||
}
|
||
#endregion
|
||
|
||
#region 右键重新合计方法
|
||
/// <summary>
|
||
/// 右键修改事件
|
||
/// </summary>
|
||
/// <param name="sender"></param>
|
||
/// <param name="e"></param>
|
||
protected void btnMenuEdit_Click(object sender, EventArgs e)
|
||
{
|
||
if (this.trWBS.SelectedNode != null)
|
||
{
|
||
MergeNextWbsSet(trWBS.SelectedNodeID, trWBS.SelectedNode.CommandName);
|
||
Alert.ShowInTop("计划值合计完成！", MessageBoxIcon.Warning);
|
||
}
|
||
}
|
||
|
||
private void MergeNextWbsSet(string id, string type)
|
||
{
|
||
if (type == "installation")
|
||
{
|
||
var q = from x in Funs.DB.WbsDetail
|
||
join y in Funs.DB.WBS_CnProfession on x.ToWbs equals y.CnProfessionId
|
||
where y.InstallationId == id
|
||
group new { x.PlanValue, x.CompleteValue, x.RealValue } by new { x.Months }
|
||
into g
|
||
select new
|
||
{
|
||
Months = g.Key.Months,
|
||
PlanValue = g.Sum(x => x.PlanValue ?? 0),
|
||
CompleteValue = g.Sum(x => x.CompleteValue ?? 0),
|
||
RealValue = g.Sum(x => x.RealValue ?? 0)
|
||
};
|
||
if (q.Count() > 0)
|
||
{
|
||
foreach (var wbsSet in q)
|
||
{
|
||
AddWbsSetDetail(id, Convert.ToDateTime(wbsSet.Months), Convert.ToDecimal(wbsSet.PlanValue), Convert.ToDecimal(wbsSet.CompleteValue), Convert.ToDecimal(wbsSet.RealValue), 1);
|
||
}
|
||
}
|
||
}
|
||
if (type == "cnProfession")
|
||
{
|
||
var q = from x in Funs.DB.WbsDetail
|
||
join y in Funs.DB.Wbs_UnitProject on x.ToWbs equals y.UnitProjectId
|
||
where y.CnProfessionId == id && y.IsApprove == true
|
||
group new { x.PlanValue, x.CompleteValue, x.RealValue } by new { x.Months }
|
||
into g
|
||
select new
|
||
{
|
||
Months = g.Key.Months,
|
||
PlanValue = g.Sum(x => x.PlanValue ?? 0),
|
||
CompleteValue = g.Sum(x => x.CompleteValue ?? 0),
|
||
RealValue = g.Sum(x => x.RealValue ?? 0)
|
||
};
|
||
if (q.Count() > 0)
|
||
{
|
||
foreach (var wbsSet in q)
|
||
{
|
||
AddWbsSetDetail(id, Convert.ToDateTime(wbsSet.Months), Convert.ToDecimal(wbsSet.PlanValue), Convert.ToDecimal(wbsSet.CompleteValue), Convert.ToDecimal(wbsSet.RealValue), 2);
|
||
}
|
||
}
|
||
}
|
||
if (type == "unitProject")
|
||
{
|
||
var q = from x in Funs.DB.WbsDetail
|
||
join y in Funs.DB.Wbs_WbsSet on x.ToWbs equals y.WbsSetId
|
||
where y.UnitProjectId == id && y.SuperWbsSetId == null && y.IsApprove == true
|
||
group new { x.PlanValue, x.CompleteValue, x.RealValue } by new { x.Months }
|
||
into g
|
||
select new
|
||
{
|
||
Months = g.Key.Months,
|
||
PlanValue = g.Sum(x => x.PlanValue ?? 0),
|
||
CompleteValue = g.Sum(x => x.CompleteValue ?? 0),
|
||
RealValue = g.Sum(x => x.RealValue ?? 0)
|
||
};
|
||
|
||
// 子单位工程
|
||
var c = from x in Funs.DB.WbsDetail
|
||
join y in Funs.DB.Wbs_UnitProject on x.ToWbs equals y.UnitProjectId
|
||
where y.SuperUnitProjectId == id && y.IsApprove == true
|
||
group new { x.PlanValue, x.CompleteValue, x.RealValue } by new { y.SuperUnitProjectId, x.Months }
|
||
into g
|
||
select new
|
||
{
|
||
ToWbs = g.Key.SuperUnitProjectId,
|
||
Months = g.Key.Months,
|
||
PlanValue = g.Sum(x => x.PlanValue ?? 0),
|
||
CompleteValue = g.Sum(x => x.CompleteValue ?? 0),
|
||
RealValue = g.Sum(x => x.RealValue ?? 0)
|
||
};
|
||
|
||
if (q.Count() > 0)
|
||
{
|
||
foreach (var wbsSet in q)
|
||
{
|
||
AddWbsSetDetail(id, Convert.ToDateTime(wbsSet.Months), Convert.ToDecimal(wbsSet.PlanValue), Convert.ToDecimal(wbsSet.CompleteValue), Convert.ToDecimal(wbsSet.RealValue), 3);
|
||
}
|
||
}
|
||
if (c.Count() > 0)
|
||
{
|
||
foreach (var wbsSet in c)
|
||
{
|
||
AddWbsSetDetail(id, Convert.ToDateTime(wbsSet.Months), Convert.ToDecimal(wbsSet.PlanValue), Convert.ToDecimal(wbsSet.CompleteValue), Convert.ToDecimal(wbsSet.RealValue), 3);
|
||
}
|
||
}
|
||
}
|
||
if (type == "childUnitProject")
|
||
{
|
||
var q = from x in Funs.DB.WbsDetail
|
||
join y in Funs.DB.Wbs_WbsSet on x.ToWbs equals y.WbsSetId
|
||
where y.UnitProjectId == id && y.SuperWbsSetId == null && y.IsApprove == true
|
||
group new { x.PlanValue, x.CompleteValue, x.RealValue } by new { x.Months }
|
||
into g
|
||
select new
|
||
{
|
||
Months = g.Key.Months,
|
||
PlanValue = g.Sum(x => x.PlanValue ?? 0),
|
||
CompleteValue = g.Sum(x => x.CompleteValue ?? 0),
|
||
RealValue = g.Sum(x => x.RealValue ?? 0)
|
||
};
|
||
if (q.Count() > 0)
|
||
{
|
||
foreach (var wbsSet in q)
|
||
{
|
||
AddWbsSetDetail(id, Convert.ToDateTime(wbsSet.Months), Convert.ToDecimal(wbsSet.PlanValue), Convert.ToDecimal(wbsSet.CompleteValue), Convert.ToDecimal(wbsSet.RealValue), 3);
|
||
}
|
||
}
|
||
}
|
||
if (type == "wbsSet")
|
||
{
|
||
var q = from x in Funs.DB.WbsDetail
|
||
join y in Funs.DB.Wbs_WbsSet on x.ToWbs equals y.WbsSetId
|
||
where y.SuperWbsSetId == id && y.IsApprove == true
|
||
group new { x.PlanValue, x.CompleteValue, x.RealValue } by new { x.Months }
|
||
into g
|
||
select new
|
||
{
|
||
Months = g.Key.Months,
|
||
PlanValue = g.Sum(x => x.PlanValue ?? 0),
|
||
CompleteValue = g.Sum(x => x.CompleteValue ?? 0),
|
||
RealValue = g.Sum(x => x.RealValue ?? 0)
|
||
};
|
||
if (q.Count() > 0)
|
||
{
|
||
foreach (var wbsSet in q)
|
||
{
|
||
AddWbsSetDetail(id, Convert.ToDateTime(wbsSet.Months), Convert.ToDecimal(wbsSet.PlanValue), Convert.ToDecimal(wbsSet.CompleteValue), Convert.ToDecimal(wbsSet.RealValue), 4);
|
||
}
|
||
}
|
||
}
|
||
}
|
||
#endregion
|
||
|
||
#region 判断装置下权重是否都已审核
|
||
/// <summary>
|
||
/// 判断装置下权重是否都已审核
|
||
/// </summary>
|
||
/// <param name="ins"></param>
|
||
/// <returns></returns>
|
||
private bool IsWeightAudit(string ins)
|
||
{
|
||
int num = 0;
|
||
bool isWeightAudit = true;
|
||
var cn = from x in Funs.DB.WBS_CnProfession
|
||
join y in Funs.DB.Wbs_UnitProject on x.CnProfessionId equals y.CnProfessionId
|
||
where x.InstallationId == ins && y.IsApprove == true
|
||
&& (x.IsWeightsApprove == false || x.IsWeightsApprove == null)
|
||
select x;
|
||
num = cn.Count();
|
||
|
||
var unit = from x in Funs.DB.Wbs_UnitProject
|
||
join y in Funs.DB.WBS_CnProfession on x.CnProfessionId equals y.CnProfessionId
|
||
where y.InstallationId == ins && x.IsApprove == true && (x.IsWeightsApprove == false || x.IsWeightsApprove == null)
|
||
select x;
|
||
num = num + unit.Count();
|
||
|
||
var wbs = from x in Funs.DB.Wbs_WbsSet
|
||
join y in Funs.DB.WBS_CnProfession on x.CnProfessionId equals y.CnProfessionId
|
||
where y.InstallationId == ins && x.IsApprove == true && (x.IsWeightsApprove == false || x.IsWeightsApprove == null)
|
||
select x;
|
||
num = num + wbs.Count();
|
||
|
||
if (num > 0)
|
||
{
|
||
isWeightAudit = false;
|
||
}
|
||
|
||
return isWeightAudit;
|
||
}
|
||
#endregion
|
||
|
||
#region 判断装置下权重是否有负数
|
||
/// <summary>
|
||
/// 判断装置下权重是否有负数
|
||
/// </summary>
|
||
/// <param name="ins"></param>
|
||
/// <returns></returns>
|
||
private bool IsWeightMinus(string ins)
|
||
{
|
||
int num = 0;
|
||
bool isWeightMinus = false;
|
||
var cn = from x in Funs.DB.WBS_CnProfession where x.InstallationId == ins && (x.WeightsMoney <= 0 || x.Weights <= 0) select x;
|
||
num = cn.Count();
|
||
|
||
var unit = from x in Funs.DB.Wbs_UnitProject
|
||
join y in Funs.DB.WBS_CnProfession on x.CnProfessionId equals y.CnProfessionId
|
||
where y.InstallationId == ins && x.IsApprove == true && (x.WeightsMoney <= 0 || x.Weights <= 0)
|
||
select x;
|
||
num = num + unit.Count();
|
||
|
||
var wbs = from x in Funs.DB.Wbs_WbsSet
|
||
join y in Funs.DB.WBS_CnProfession on x.CnProfessionId equals y.CnProfessionId
|
||
where y.InstallationId == ins && x.IsApprove == true && (x.WeightsMoney <= 0 || x.Weights <= 0)
|
||
select x;
|
||
num = num + wbs.Count();
|
||
|
||
if (num > 0)
|
||
{
|
||
isWeightMinus = true;
|
||
}
|
||
|
||
return isWeightMinus;
|
||
}
|
||
#endregion
|
||
|
||
#region 自动审核设置装置末级分项计划值
|
||
/// <summary>
|
||
/// 自动审核设置装置末级分项计划值（按开始结束日期生成末级明细，并根据父级节点增加未包含在子级但包含在父级的月份记录）
|
||
/// </summary>
|
||
/// <param name="sender"></param>
|
||
/// <param name="e"></param>
|
||
protected void btnAuditPlan_Click(object sender, EventArgs e)
|
||
{
|
||
if (this.trWBS.SelectedNode != null)
|
||
{
|
||
if (this.trWBS.SelectedNode.CommandName == "installation")
|
||
{
|
||
if (!IsWeightAudit(this.trWBS.SelectedNodeID))
|
||
{
|
||
Alert.ShowInTop("该装置下有未审核的权重设置！", MessageBoxIcon.Warning);
|
||
return;
|
||
}
|
||
|
||
if (!IsWeightAudit(this.trWBS.SelectedNodeID))
|
||
{
|
||
Alert.ShowInTop("该装置下有权重设置为0或负数！", MessageBoxIcon.Warning);
|
||
return;
|
||
}
|
||
|
||
var cnProfessions = from x in Funs.DB.WBS_CnProfession where x.InstallationId == this.trWBS.SelectedNodeID orderby x.OldId select x;
|
||
foreach (var cnProfession in cnProfessions)
|
||
{
|
||
var wbsSets = from x in Funs.DB.Wbs_WbsSet where x.IsApprove == true && x.CnProfessionId == cnProfession.CnProfessionId select x;
|
||
foreach (var wbsSet in wbsSets)
|
||
{
|
||
DateTime startDate, endDate, startMonth, endMonth, parentStartDate, parentEndDate, parentStartMonth, parentEndMonth;
|
||
List<DateTime> months = new List<DateTime>();
|
||
string column0 = string.Empty;
|
||
decimal totalValue = 0, totalRate = 0;
|
||
var childWbsSets = BLL.WbsSetService.GetApproveWbsSetsBySuperWbsSetId(wbsSet.WbsSetId);
|
||
if (childWbsSets.Count() == 0) //当前为末级
|
||
{
|
||
BLL.WbsSetService.UpdateWbsSetIsPlanApprove(wbsSet, true);
|
||
|
||
startDate = Convert.ToDateTime(wbsSet.StartDate);
|
||
endDate = Convert.ToDateTime(wbsSet.EndDate);
|
||
startMonth = Convert.ToDateTime(startDate.Year + "-" + startDate.Month + "-01");
|
||
endMonth = Convert.ToDateTime(endDate.Year + "-" + endDate.Month + "-01");
|
||
do
|
||
{
|
||
months.Add(startMonth);
|
||
startMonth = startMonth.AddMonths(1);
|
||
}
|
||
while (startMonth <= endMonth);
|
||
|
||
//获取父级节点的月份集合
|
||
List<DateTime> parentMonths = new List<DateTime>(); //父级节点的月份集合
|
||
string parentId = wbsSet.SuperWbsSetId;
|
||
Model.Wbs_WbsSet parentWbsSet = BLL.WbsSetService.GetWbsSetByWbsSetId(parentId);
|
||
if (parentWbsSet != null) //父级为分部
|
||
{
|
||
parentStartDate = Convert.ToDateTime(parentWbsSet.StartDate);
|
||
parentEndDate = Convert.ToDateTime(parentWbsSet.EndDate);
|
||
parentStartMonth = Convert.ToDateTime(parentStartDate.Year + "-" + parentStartDate.Month + "-01");
|
||
parentEndMonth = Convert.ToDateTime(parentEndDate.Year + "-" + parentEndDate.Month + "-01");
|
||
do
|
||
{
|
||
parentMonths.Add(parentStartMonth);
|
||
parentStartMonth = parentStartMonth.AddMonths(1);
|
||
}
|
||
while (parentStartMonth <= parentEndMonth);
|
||
}
|
||
else //父级为质量行为
|
||
{
|
||
Model.Wbs_UnitProject unitProject = BLL.UnitProjectService.GetUnitProjectByUnitProjectId(parentId);
|
||
if (unitProject != null)
|
||
{
|
||
parentStartDate = Convert.ToDateTime(unitProject.StartDate);
|
||
parentEndDate = Convert.ToDateTime(unitProject.EndDate);
|
||
parentStartMonth = Convert.ToDateTime(parentStartDate.Year + "-" + parentStartDate.Month + "-01");
|
||
parentEndMonth = Convert.ToDateTime(parentEndDate.Year + "-" + parentEndDate.Month + "-01");
|
||
do
|
||
{
|
||
parentMonths.Add(parentStartMonth);
|
||
parentStartMonth = parentStartMonth.AddMonths(1);
|
||
}
|
||
while (parentStartMonth <= parentEndMonth);
|
||
}
|
||
}
|
||
for (int i = 0; i < months.Count; i++)
|
||
{
|
||
Model.WbsDetail detail = BLL.WbsDetailService.GetWbsDetailByWbsFlagYearMonth(wbsSet.WbsSetId, 4, months[i]);
|
||
if (detail == null)
|
||
{
|
||
Model.WbsDetail item = new Model.WbsDetail();
|
||
item.WbsDetailId = SQLHelper.GetNewID(typeof(Model.WbsDetail));
|
||
item.ToWbs = wbsSet.WbsSetId;
|
||
item.ToFlag = 4; //分部分项
|
||
item.Way = wbsSet.Way;
|
||
item.Months = months[i];
|
||
if (wbsSet.WeightsMoney != null)
|
||
{
|
||
if (i == months.Count - 1)
|
||
{
|
||
decimal lastPlanValue = decimal.Round(Convert.ToDecimal(wbsSet.WeightsMoney - totalValue), 2);
|
||
if (lastPlanValue >= 0)
|
||
{
|
||
item.PlanValue = lastPlanValue;
|
||
}
|
||
}
|
||
else
|
||
{
|
||
item.PlanValue = WbsDetailService.GetMonthPlanValueByMonthCountAndMonthNumAndWeightMonth(months.Count, i + 1, Convert.ToDecimal(wbsSet.WeightsMoney));
|
||
}
|
||
if (wbsSet.WeightsMoney != 0)
|
||
{
|
||
item.PlanValueRate = decimal.Round(Convert.ToDecimal(item.PlanValue / wbsSet.WeightsMoney * 100), 2);
|
||
}
|
||
else
|
||
{
|
||
item.PlanValueRate = 0;
|
||
}
|
||
totalValue += item.PlanValue != null ? item.PlanValue.Value : 0;
|
||
totalRate += item.PlanValueRate != null ? item.PlanValueRate.Value : 0;
|
||
BLL.WbsDetailService.AddWbsDetail(item);
|
||
}
|
||
}
|
||
}
|
||
for (int i = 0; i < parentMonths.Count; i++)
|
||
{
|
||
if (!months.Contains(parentMonths[i]))
|
||
{
|
||
Model.WbsDetail detail = (from x in Funs.DB.WbsDetail
|
||
where x.ToWbs == wbsSet.WbsSetId && x.Months == parentMonths[i]
|
||
select x).FirstOrDefault();
|
||
if (detail == null)
|
||
{
|
||
Model.WbsDetail item = new Model.WbsDetail();
|
||
item.WbsDetailId = SQLHelper.GetNewID(typeof(Model.WbsDetail));
|
||
item.ToWbs = wbsSet.WbsSetId;
|
||
item.ToFlag = 4; //分部分项
|
||
item.Way = wbsSet.Way;
|
||
item.Months = parentMonths[i];
|
||
item.PlanValue = 0;
|
||
item.PlanValueRate = 0;
|
||
BLL.WbsDetailService.AddWbsDetail(item);
|
||
}
|
||
}
|
||
}
|
||
}
|
||
}
|
||
}
|
||
Alert.ShowInTop("自动分配计划值完成！", MessageBoxIcon.Warning);
|
||
}
|
||
else
|
||
{
|
||
Alert.ShowInTop("请选择一个装置！", MessageBoxIcon.Warning);
|
||
return;
|
||
}
|
||
}
|
||
else
|
||
{
|
||
Alert.ShowInTop("请选择装置！", MessageBoxIcon.Warning);
|
||
return;
|
||
}
|
||
}
|
||
#endregion
|
||
|
||
#region 逐级向上合并计划明细
|
||
/// <summary>
|
||
/// 逐级向上合并计划明细
|
||
/// </summary>
|
||
/// <param name="cnProfessionId"></param>
|
||
private void MergeWbsSetDetail(string cnProfessionId)
|
||
{
|
||
Model.SGGLDB db = Funs.DB;
|
||
// 分部分项
|
||
var wbsSetList4 = from x in db.WbsDetail
|
||
join y in db.Wbs_WbsSet on x.ToWbs equals y.WbsSetId
|
||
where y.CnProfessionId == cnProfessionId && y.IsApprove == true && y.SuperWbsSetId != null
|
||
group new { x.PlanValue, x.CompleteValue, x.RealValue } by new { y.SuperWbsSetId, x.Months }
|
||
into g
|
||
select new
|
||
{
|
||
ToWbs = g.Key.SuperWbsSetId,
|
||
Months = g.Key.Months,
|
||
PlanValue = g.Sum(x => x.PlanValue ?? 0),
|
||
CompleteValue = g.Sum(x => x.CompleteValue ?? 0),
|
||
RealValue = g.Sum(x => x.RealValue ?? 0)
|
||
};
|
||
|
||
if (wbsSetList4.Count() > 0)
|
||
{
|
||
foreach (var wbsSet in wbsSetList4)
|
||
{
|
||
AddWbsSetDetail(wbsSet.ToWbs, Convert.ToDateTime(wbsSet.Months), Convert.ToDecimal(wbsSet.PlanValue), Convert.ToDecimal(wbsSet.CompleteValue), Convert.ToDecimal(wbsSet.RealValue), 4);
|
||
}
|
||
}
|
||
|
||
// 单位工程及子单位工程
|
||
var wbsSetList1 = from x in db.WbsDetail
|
||
join y in db.Wbs_WbsSet on x.ToWbs equals y.WbsSetId
|
||
join z in db.Wbs_UnitProject on y.UnitProjectId equals z.UnitProjectId
|
||
where y.CnProfessionId == cnProfessionId && y.IsApprove == true && z.IsApprove == true && y.SuperWbsSetId == null
|
||
group new { x.PlanValue, x.CompleteValue, x.RealValue } by new { z.UnitProjectId, x.Months }
|
||
into g
|
||
select new
|
||
{
|
||
ToWbs = g.Key.UnitProjectId,
|
||
Months = g.Key.Months,
|
||
PlanValue = g.Sum(x => x.PlanValue ?? 0),
|
||
CompleteValue = g.Sum(x => x.CompleteValue ?? 0),
|
||
RealValue = g.Sum(x => x.RealValue ?? 0)
|
||
};
|
||
if (wbsSetList1.Count() > 0)
|
||
{
|
||
foreach (var wbsSet in wbsSetList1)
|
||
{
|
||
AddWbsSetDetail(wbsSet.ToWbs, Convert.ToDateTime(wbsSet.Months), Convert.ToDecimal(wbsSet.PlanValue), Convert.ToDecimal(wbsSet.CompleteValue), Convert.ToDecimal(wbsSet.RealValue), 3);
|
||
}
|
||
}
|
||
|
||
var wbsSetList0 = from x in db.WbsDetail
|
||
join y in db.Wbs_UnitProject on x.ToWbs equals y.UnitProjectId
|
||
where y.CnProfessionId == cnProfessionId && y.IsApprove == true && y.SuperUnitProjectId != null
|
||
group new { x.PlanValue, x.CompleteValue, x.RealValue } by new { y.SuperUnitProjectId, x.Months }
|
||
into g
|
||
select new
|
||
{
|
||
ToWbs = g.Key.SuperUnitProjectId,
|
||
Months = g.Key.Months,
|
||
PlanValue = g.Sum(x => x.PlanValue ?? 0),
|
||
CompleteValue = g.Sum(x => x.CompleteValue ?? 0),
|
||
RealValue = g.Sum(x => x.RealValue ?? 0)
|
||
};
|
||
if (wbsSetList0.Count() > 0)
|
||
{
|
||
foreach (var wbsSet in wbsSetList0)
|
||
{
|
||
AddWbsSetDetail(wbsSet.ToWbs, Convert.ToDateTime(wbsSet.Months), Convert.ToDecimal(wbsSet.PlanValue), Convert.ToDecimal(wbsSet.CompleteValue), Convert.ToDecimal(wbsSet.RealValue), 3);
|
||
}
|
||
}
|
||
|
||
// 专业
|
||
var wbsSetList5 = from x in db.WbsDetail
|
||
join y in db.Wbs_UnitProject on x.ToWbs equals y.UnitProjectId
|
||
join z in db.WBS_CnProfession on y.CnProfessionId equals z.CnProfessionId
|
||
where y.CnProfessionId == cnProfessionId && y.IsApprove == true && y.SuperUnitProjectId == null
|
||
group new { x.PlanValue, x.CompleteValue, x.RealValue } by new { z.CnProfessionId, x.Months }
|
||
into g
|
||
select new
|
||
{
|
||
ToWbs = g.Key.CnProfessionId,
|
||
Months = g.Key.Months,
|
||
PlanValue = g.Sum(x => x.PlanValue ?? 0),
|
||
CompleteValue = g.Sum(x => x.CompleteValue ?? 0),
|
||
RealValue = g.Sum(x => x.RealValue ?? 0)
|
||
};
|
||
if (wbsSetList5.Count() > 0)
|
||
{
|
||
foreach (var wbsSet in wbsSetList5)
|
||
{
|
||
AddWbsSetDetail(wbsSet.ToWbs, Convert.ToDateTime(wbsSet.Months), Convert.ToDecimal(wbsSet.PlanValue), Convert.ToDecimal(wbsSet.CompleteValue), Convert.ToDecimal(wbsSet.RealValue), 2);
|
||
}
|
||
}
|
||
}
|
||
|
||
/// <summary>
|
||
/// 逐级向上合并计划明细
|
||
/// </summary>
|
||
/// <param name="cnProfessionId"></param>
|
||
private void MergeWbsSetDetail2(string unitProjectId)
|
||
{
|
||
Model.SGGLDB db = Funs.DB;
|
||
// 分部分项
|
||
var wbsSetList4 = from x in db.WbsDetail
|
||
join y in db.Wbs_WbsSet on x.ToWbs equals y.WbsSetId
|
||
where y.UnitProjectId == unitProjectId && y.IsApprove == true && y.SuperWbsSetId != null
|
||
group new { x.PlanValue, x.CompleteValue, x.RealValue } by new { y.SuperWbsSetId, x.Months }
|
||
into g
|
||
select new
|
||
{
|
||
ToWbs = g.Key.SuperWbsSetId,
|
||
Months = g.Key.Months,
|
||
PlanValue = g.Sum(x => x.PlanValue ?? 0),
|
||
CompleteValue = g.Sum(x => x.CompleteValue ?? 0),
|
||
RealValue = g.Sum(x => x.RealValue ?? 0)
|
||
};
|
||
|
||
if (wbsSetList4.Count() > 0)
|
||
{
|
||
foreach (var wbsSet in wbsSetList4)
|
||
{
|
||
AddWbsSetDetail(wbsSet.ToWbs, Convert.ToDateTime(wbsSet.Months), Convert.ToDecimal(wbsSet.PlanValue), Convert.ToDecimal(wbsSet.CompleteValue), Convert.ToDecimal(wbsSet.RealValue), 4);
|
||
}
|
||
}
|
||
// 单位工程及子单位工程
|
||
var wbsSetList1 = from x in db.WbsDetail
|
||
join y in db.Wbs_WbsSet on x.ToWbs equals y.WbsSetId
|
||
join z in db.Wbs_UnitProject on y.UnitProjectId equals z.UnitProjectId
|
||
where y.UnitProjectId == unitProjectId && y.IsApprove == true && z.IsApprove == true && y.SuperWbsSetId == null
|
||
group new { x.PlanValue, x.CompleteValue, x.RealValue } by new { z.UnitProjectId, x.Months }
|
||
into g
|
||
select new
|
||
{
|
||
ToWbs = g.Key.UnitProjectId,
|
||
Months = g.Key.Months,
|
||
PlanValue = g.Sum(x => x.PlanValue ?? 0),
|
||
CompleteValue = g.Sum(x => x.CompleteValue ?? 0),
|
||
RealValue = g.Sum(x => x.RealValue ?? 0)
|
||
};
|
||
if (wbsSetList1.Count() > 0)
|
||
{
|
||
foreach (var wbsSet in wbsSetList1)
|
||
{
|
||
AddWbsSetDetail(wbsSet.ToWbs, Convert.ToDateTime(wbsSet.Months), Convert.ToDecimal(wbsSet.PlanValue), Convert.ToDecimal(wbsSet.CompleteValue), Convert.ToDecimal(wbsSet.RealValue), 3);
|
||
}
|
||
}
|
||
|
||
var wbsSetList0 = from x in db.WbsDetail
|
||
join y in db.Wbs_UnitProject on x.ToWbs equals y.UnitProjectId
|
||
where y.UnitProjectId == unitProjectId && y.IsApprove == true && y.SuperUnitProjectId != null
|
||
group new { x.PlanValue, x.CompleteValue, x.RealValue } by new { y.SuperUnitProjectId, x.Months }
|
||
into g
|
||
select new
|
||
{
|
||
ToWbs = g.Key.SuperUnitProjectId,
|
||
Months = g.Key.Months,
|
||
PlanValue = g.Sum(x => x.PlanValue ?? 0),
|
||
CompleteValue = g.Sum(x => x.CompleteValue ?? 0),
|
||
RealValue = g.Sum(x => x.RealValue ?? 0)
|
||
};
|
||
if (wbsSetList0.Count() > 0)
|
||
{
|
||
foreach (var wbsSet in wbsSetList0)
|
||
{
|
||
AddWbsSetDetail(wbsSet.ToWbs, Convert.ToDateTime(wbsSet.Months), Convert.ToDecimal(wbsSet.PlanValue), Convert.ToDecimal(wbsSet.CompleteValue), Convert.ToDecimal(wbsSet.RealValue), 3);
|
||
}
|
||
}
|
||
}
|
||
|
||
private void AddWbsSetDetail(string toWbs, DateTime months, decimal planValue, decimal completeValue, decimal realValue, int toFlag)
|
||
{
|
||
Model.SGGLDB db = Funs.DB;
|
||
decimal? weight = null;
|
||
if (toFlag == 4)
|
||
{
|
||
weight = BLL.WbsSetService.GetWbsSetByWbsSetId(toWbs).WeightsMoney;
|
||
}
|
||
|
||
if (toFlag == 3)
|
||
{
|
||
weight = BLL.UnitProjectService.GetUnitProjectByUnitProjectId(toWbs).WeightsMoney;
|
||
}
|
||
|
||
if (toFlag == 2)
|
||
{
|
||
weight = BLL.CnProfessionService.GetCnProfessionByCnProfessionId(toWbs).WeightsMoney;
|
||
}
|
||
|
||
if (toFlag == 1)
|
||
{
|
||
weight = BLL.Project_InstallationService.GetInstallationByInstallationId(toWbs).WeightsMoney;
|
||
}
|
||
|
||
if (BLL.WbsDetailService.IsExitWbsDetailByToWbsOrMonth(toWbs, toFlag, months))
|
||
{
|
||
Model.WbsDetail updateDetail = (from x in db.WbsDetail where x.ToWbs == toWbs && x.Months == months && x.ToFlag == toFlag select x).FirstOrDefault();
|
||
updateDetail.PlanValue = planValue;
|
||
updateDetail.CompleteValue = completeValue;
|
||
updateDetail.RealValue = realValue;
|
||
|
||
if (weight != null && weight != 0)
|
||
{
|
||
updateDetail.PlanValueRate = decimal.Round(Convert.ToDecimal(planValue) / Convert.ToDecimal(weight) * 100, 2);
|
||
updateDetail.CompleteValueRate = decimal.Round(Convert.ToDecimal(completeValue) / Convert.ToDecimal(weight) * 100, 2);
|
||
updateDetail.RealValueRate = decimal.Round(Convert.ToDecimal(realValue) / Convert.ToDecimal(weight) * 100, 2);
|
||
}
|
||
db.SubmitChanges();
|
||
}
|
||
else
|
||
{
|
||
Model.WbsDetail newDetail = new Model.WbsDetail();
|
||
newDetail.WbsDetailId = SQLHelper.GetNewID(typeof(Model.WbsDetail));
|
||
newDetail.ToWbs = toWbs;
|
||
newDetail.ToFlag = toFlag;
|
||
newDetail.Way = "A";
|
||
newDetail.Months = months;
|
||
newDetail.PlanValue = planValue;
|
||
if (weight != null && weight != 0)
|
||
{
|
||
newDetail.PlanValueRate = decimal.Round(Convert.ToDecimal(planValue) / Convert.ToDecimal(weight) * 100, 2);
|
||
}
|
||
newDetail.CompleteValue = 0;
|
||
newDetail.RealValue = 0;
|
||
db.WbsDetail.InsertOnSubmit(newDetail);
|
||
db.SubmitChanges();
|
||
}
|
||
}
|
||
#endregion
|
||
|
||
#region 一键保存
|
||
/// <summary>
|
||
/// 一键保存
|
||
/// </summary>
|
||
/// <param name="sender"></param>
|
||
/// <param name="e"></param>
|
||
protected void btnSaveInstrallion_Click(object sender, EventArgs e)
|
||
{
|
||
if (this.trWBS.SelectedNode != null)
|
||
{
|
||
if (this.trWBS.SelectedNode.CommandName == "installation")
|
||
{
|
||
string installationId = this.trWBS.SelectedNodeID;
|
||
Model.Project_Installation installation = BLL.Project_InstallationService.GetInstallationByInstallationId(installationId);
|
||
if (installation.SuperInstallationId == "0")
|
||
{
|
||
//工序
|
||
var installation1s = (from x in Funs.DB.Project_Installation where x.ProjectId == this.CurrUser.LoginProjectId && x.SuperInstallationId == installationId select x).ToList();
|
||
if (installation1s.Count > 0) //非总图装置
|
||
{
|
||
foreach (var installation1 in installation1s)
|
||
{
|
||
//主项
|
||
var installation2s = (from x in Funs.DB.Project_Installation where x.ProjectId == this.CurrUser.LoginProjectId && x.SuperInstallationId == installation1.InstallationId select x).ToList();
|
||
foreach (var installation2 in installation2s)
|
||
{
|
||
//专业
|
||
var profession = BLL.CnProfessionService.GetCnProfessionByInstallation(installation2.InstallationId);
|
||
foreach (var pro in profession)
|
||
{
|
||
MergeWbsSetDetail(pro.CnProfessionId);
|
||
}
|
||
|
||
var insList2 = from x in Funs.DB.WbsDetail
|
||
join y in Funs.DB.WBS_CnProfession on x.ToWbs equals y.CnProfessionId
|
||
where y.InstallationId == installation2.InstallationId
|
||
group new { x.PlanValue, x.CompleteValue, x.RealValue } by new { y.InstallationId, x.Months }
|
||
into g
|
||
select new
|
||
{
|
||
ToWbs = g.Key.InstallationId,
|
||
Months = g.Key.Months,
|
||
PlanValue = g.Sum(x => x.PlanValue ?? 0),
|
||
CompleteValue = g.Sum(x => x.CompleteValue ?? 0),
|
||
RealValue = g.Sum(x => x.RealValue ?? 0)
|
||
};
|
||
if (insList2.Count() > 0)
|
||
{
|
||
foreach (var ins in insList2)
|
||
{
|
||
AddWbsSetDetail(ins.ToWbs, Convert.ToDateTime(ins.Months), Convert.ToDecimal(ins.PlanValue), Convert.ToDecimal(ins.CompleteValue), Convert.ToDecimal(ins.RealValue), 1);
|
||
}
|
||
}
|
||
}
|
||
var insList1 = from x in Funs.DB.WbsDetail
|
||
join y in Funs.DB.Project_Installation on x.ToWbs equals y.InstallationId
|
||
where y.SuperInstallationId == installation1.InstallationId
|
||
group new { x.PlanValue, x.CompleteValue, x.RealValue } by new { y.SuperInstallationId, x.Months }
|
||
into g
|
||
select new
|
||
{
|
||
ToWbs = g.Key.SuperInstallationId,
|
||
Months = g.Key.Months,
|
||
PlanValue = g.Sum(x => x.PlanValue ?? 0),
|
||
CompleteValue = g.Sum(x => x.CompleteValue ?? 0),
|
||
RealValue = g.Sum(x => x.RealValue ?? 0)
|
||
};
|
||
if (insList1.Count() > 0)
|
||
{
|
||
foreach (var ins in insList1)
|
||
{
|
||
AddWbsSetDetail(ins.ToWbs, Convert.ToDateTime(ins.Months), Convert.ToDecimal(ins.PlanValue), Convert.ToDecimal(ins.CompleteValue), Convert.ToDecimal(ins.RealValue), 1);
|
||
}
|
||
}
|
||
}
|
||
var insList = from x in Funs.DB.WbsDetail
|
||
join y in Funs.DB.Project_Installation on x.ToWbs equals y.InstallationId
|
||
where y.SuperInstallationId == installation.InstallationId
|
||
group new { x.PlanValue, x.CompleteValue, x.RealValue } by new { y.SuperInstallationId, x.Months }
|
||
into g
|
||
select new
|
||
{
|
||
ToWbs = g.Key.SuperInstallationId,
|
||
Months = g.Key.Months,
|
||
PlanValue = g.Sum(x => x.PlanValue ?? 0),
|
||
CompleteValue = g.Sum(x => x.CompleteValue ?? 0),
|
||
RealValue = g.Sum(x => x.RealValue ?? 0)
|
||
};
|
||
if (insList.Count() > 0)
|
||
{
|
||
foreach (var ins in insList)
|
||
{
|
||
AddWbsSetDetail(ins.ToWbs, Convert.ToDateTime(ins.Months), Convert.ToDecimal(ins.PlanValue), Convert.ToDecimal(ins.CompleteValue), Convert.ToDecimal(ins.RealValue), 1);
|
||
}
|
||
}
|
||
}
|
||
else
|
||
{
|
||
//专业
|
||
var profession = BLL.CnProfessionService.GetCnProfessionByInstallation(installation.InstallationId);
|
||
foreach (var pro in profession)
|
||
{
|
||
MergeWbsSetDetail(pro.CnProfessionId);
|
||
}
|
||
|
||
//单位工程
|
||
var unitProjects = BLL.UnitProjectService.GetUnitProjectsByInstallationId(installationId);
|
||
foreach (var unitProject in unitProjects)
|
||
{
|
||
MergeWbsSetDetail2(unitProject.UnitProjectId);
|
||
}
|
||
|
||
var insList = from x in Funs.DB.WbsDetail
|
||
join y in Funs.DB.Wbs_UnitProject on x.ToWbs equals y.UnitProjectId
|
||
where y.InstallationId == installationId
|
||
group new { x.PlanValue, x.CompleteValue, x.RealValue } by new { y.InstallationId, x.Months }
|
||
into g
|
||
select new
|
||
{
|
||
ToWbs = g.Key.InstallationId,
|
||
Months = g.Key.Months,
|
||
PlanValue = g.Sum(x => x.PlanValue ?? 0),
|
||
CompleteValue = g.Sum(x => x.CompleteValue ?? 0),
|
||
RealValue = g.Sum(x => x.RealValue ?? 0)
|
||
};
|
||
if (insList.Count() > 0)
|
||
{
|
||
foreach (var ins in insList)
|
||
{
|
||
AddWbsSetDetail(ins.ToWbs, Convert.ToDateTime(ins.Months), Convert.ToDecimal(ins.PlanValue), Convert.ToDecimal(ins.CompleteValue), Convert.ToDecimal(ins.RealValue), 1);
|
||
}
|
||
}
|
||
}
|
||
|
||
Alert.ShowInTop("一键保存成功！", MessageBoxIcon.Success);
|
||
}
|
||
else
|
||
{
|
||
Alert.ShowInTop("请选择一个装置！", MessageBoxIcon.Warning);
|
||
return;
|
||
}
|
||
}
|
||
else
|
||
{
|
||
Alert.ShowInTop("请选择一个装置！", MessageBoxIcon.Warning);
|
||
return;
|
||
}
|
||
}
|
||
else
|
||
{
|
||
Alert.ShowInTop("请选择装置！", MessageBoxIcon.Warning);
|
||
return;
|
||
}
|
||
}
|
||
#endregion
|
||
}
|
||
} |