public int ExcelOutResult()
{
TargetValues = mTargetProjectInfoArray;
mExcel.AddWorksheet(StartMonth + "-" + EndMonth + "汇总");
int Row = 1;
float ProjectTotalMoney = (float)0.0;
List <float> SingelSumList = new List <float>();
for (int i = 0; i < mTargetProjectInfoArray.Count; i++)
{
if (mTargetProjectInfoArray[i].ProjectId.IndexOf("项目名称") != -1)
{
mExcel.SetCell(Row, 1, mTargetProjectInfoArray[i].ProjectName + splitchar);
}
else
{
mExcel.SetCell(Row, 1, mTargetProjectInfoArray[i].ProjectName + splitchar + mTargetProjectInfoArray[i].ProjectId);
}
mExcel.SetRangeBackground(Row, 1, Row, 8, 33);
mExcel.SetCell(++Row, 1, "姓名");
mExcel.SetCell(Row, 2, "部门");
mExcel.SetCell(Row, 3, "加班费");
mExcel.SetRangeBackground(Row, 3, Row, 3, 6);
float sum = (float)0.000;
for (int j = 0; j < mTargetProjectInfoArray[i].MyProjectDetailCollection.Count; j++)
{
sum += mTargetProjectInfoArray[i].MyProjectDetailCollection[j].ProjectStaffMoney;
mExcel.SetCell(++Row, 1, mTargetProjectInfoArray[i].MyProjectDetailCollection[j].ProjectStaffName);
mExcel.SetCell(Row, 2, mTargetProjectInfoArray[i].MyProjectDetailCollection[j].ProjectStaffDep);
mExcel.SetCell(Row, 3, mTargetProjectInfoArray[i].MyProjectDetailCollection[j].ProjectStaffMoney.ToString());
}
SingelSumList.Add(sum);
ProjectTotalMoney += sum;
mExcel.SetCell(++Row, 1, "总计：");
mExcel.SetCell(Row, 3, sum.ToString());
mExcel.SetRangeBackground(Row, 1, Row, 3, 34);
mExcel.SetCell(++Row, 1, "费用百分比:");
mExcel.SetRangeBackground(Row, 1, Row, 3, 34);
++Row;
++Row;
}
mExcel.SetCell(++Row, 1, "项目总数： " + mTargetProjectInfoArray.Count);
mExcel.SetRangeBackground(Row, 1, Row, 5, 48);
mExcel.SetCell(++Row, 1, "项目全部支出： " + ProjectTotalMoney.ToString());
mExcel.SetRangeBackground(Row, 1, Row, 5, 48);
Row = 1;
for (int i = 0; i < mTargetProjectInfoArray.Count; i++)
{
float precentproject = (SingelSumList[i] / ProjectTotalMoney) * (float)100.00;
Row = GetPrecentRow(Row, mTargetProjectInfoArray[i]);
mExcel.SetCell(Row, 3, precentproject.ToString() + "%");
Row += 2;
}
MessageBox.Show("合并完成！");
mExcel.Visible = true;
return(1);
}
public int ExcelOutResult()
{
TargetValues = mTargetProjectInfoArray;
mExcel.AddWorksheet(StartMonth + "-" + EndMonth + "汇总");
int Row = 1;
float ProjectTotalMoney = (float)0.0;
List <float> SingelSumList = new List <float>();
mExcel.SetCell(Row, 1, StartMonth + "-" + EndMonth + " 项目总数： " + mTargetProjectInfoArray.Count + "个");
mExcel.SetCell(Row, 6, StartMonth + "-" + EndMonth + " 项目全部支出： " + TotalMoneyOnAllProject.ToString() + "元");
mExcel.SetRangeBackground(Row, 1, Row, 16, 48);
mExcel.SetRangeFontColor(Row, 1, Row, 16, 2);
++Row;
++Row;
for (int i = 0; i < mTargetProjectInfoArray.Count; i++)
{
if (mTargetProjectInfoArray[i].ProjectId.IndexOf("项目名称") != -1)
{
mExcel.SetCell(Row, 1, "No " + (i + 1).ToString() + ". " + mTargetProjectInfoArray[i].ProjectName + splitchar);
}
else
{
mExcel.SetCell(Row, 1, "No " + (i + 1).ToString() + ". " + mTargetProjectInfoArray[i].ProjectName + splitchar + mTargetProjectInfoArray[i].ProjectId);
}
mExcel.SetRangeBackground(Row, 1, Row, 16, 33);
mExcel.SetCell(++Row, 1, "姓名");
mExcel.SetCell(Row, 2, "部门");
mExcel.SetCell(Row, 3, "加班费");
mExcel.SetRangeBackground(Row, 3, Row, 3, 6);
for (int j = 0; j < mTargetProjectInfoArray[i].MyProjectDetailCollection.Count; j++)
{
mExcel.SetCell(++Row, 1, mTargetProjectInfoArray[i].MyProjectDetailCollection[j].ProjectStaffName);
mExcel.SetCell(Row, 2, mTargetProjectInfoArray[i].MyProjectDetailCollection[j].ProjectStaffDep);
mExcel.SetCell(Row, 3, mTargetProjectInfoArray[i].MyProjectDetailCollection[j].ProjectStaffMoney.ToString());
}
mExcel.SetCell(++Row, 1, "项目人数：");
mExcel.SetCell(Row, 3, mTargetProjectInfoArray[i].MyProjectDetailCollection.Count.ToString() + "人");
mExcel.SetRangeBackground(Row, 1, Row, 3, 34);
mExcel.SetCell(++Row, 1, "项目费用：");
mExcel.SetCell(Row, 3, mTargetProjectInfoArray[i].TotalMoney.ToString() + "元");
mExcel.SetRangeBackground(Row, 1, Row, 3, 34);
mExcel.SetCell(++Row, 1, "费用百分比:");
mExcel.SetCell(Row, 3, mTargetProjectInfoArray[i].TotalPercent.ToString() + "%");
mExcel.SetRangeBackground(Row, 1, Row, 3, 34);
++Row;
++Row;
}
return(1);
}
