406 lines
19 KiB
C#
406 lines
19 KiB
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.Linq;
|
|
using System.Web;
|
|
using System.Web.UI;
|
|
using System.Web.UI.WebControls;
|
|
using System.Data;
|
|
using System.Data.SqlClient;
|
|
using BLL;
|
|
using System.IO;
|
|
using System.Text;
|
|
using AspNet = System.Web.UI.WebControls;
|
|
|
|
namespace FineUIPro.Web.ZHGL.ManagementReport
|
|
{
|
|
public partial class ReportCheck : PageBase
|
|
{
|
|
#region 加载页面
|
|
/// <summary>
|
|
/// 加载页面
|
|
/// </summary>
|
|
/// <param name="sender"></param>
|
|
/// <param name="e"></param>
|
|
protected void Page_Load(object sender, EventArgs e)
|
|
{
|
|
// 表头过滤
|
|
//FilterDataRowItem = FilterDataRowItemImplement;
|
|
if (!IsPostBack)
|
|
{
|
|
this.txtReportDate.Text = string.Format("{0:yyyy-MM}", DateTime.Now);
|
|
// 绑定表格
|
|
//BindGrid();
|
|
}
|
|
}
|
|
|
|
private bool IsShow(string projectId)
|
|
{
|
|
DateTime startTime = Funs.GetNewDateTimeOrNow(this.txtReportDate.Text + "-01");
|
|
DateTime endTime = startTime.AddMonths(1);
|
|
bool b = false;
|
|
Model.Manager_MonthReportB monthReport = BLL.MonthReportBService.GetMonthReportsByMonthsAndProjectId(startTime, projectId);
|
|
if (monthReport != null)
|
|
{
|
|
b = true;
|
|
}
|
|
else //项目当月未生成月报且完工，但有数据
|
|
{
|
|
Model.Base_ProjectSate projectSate = (from x in Funs.DB.Base_ProjectSate
|
|
where x.ProjectId == projectId
|
|
orderby x.CompileDate descending
|
|
select x).FirstOrDefault();
|
|
if (projectSate != null)
|
|
{
|
|
if (projectSate.CompileDate >= startTime && projectSate.CompileDate < endTime)
|
|
{
|
|
b = true;
|
|
}
|
|
}
|
|
}
|
|
return b;
|
|
}
|
|
|
|
/// <summary>
|
|
/// 绑定数据
|
|
/// </summary>
|
|
private void BindGrid()
|
|
{
|
|
DateTime months = Convert.ToDateTime(this.txtReportDate.Text + "-01");
|
|
//项目信息集合
|
|
var projects = from x in Funs.DB.Base_Project orderby x.ProjectCode descending select x;
|
|
//施工中项目集合
|
|
List<Model.Base_Project> dataProjects = BLL.ProjectService.GetProjectDropDownListByState("1", months.AddMonths(1));
|
|
List<string> dataProjectIds = dataProjects.Select(x => x.ProjectId).ToList();
|
|
List<string> showProjectIds = new List<string>();
|
|
foreach (Model.Base_Project project in projects)
|
|
{
|
|
if (dataProjectIds.Contains(project.ProjectId) || IsShow(project.ProjectId))
|
|
{
|
|
showProjectIds.Add(project.ProjectId);
|
|
}
|
|
}
|
|
//项目月报记录集合
|
|
var monthReports = from x in Funs.DB.Manager_MonthReportB
|
|
join y in Funs.DB.Base_Project
|
|
on x.ProjectId equals y.ProjectId
|
|
where x.Months == months
|
|
orderby y.ProjectCode descending
|
|
select x;
|
|
//本部百万工时记录
|
|
var millionsMonthlyReportItems = from x in Funs.DB.Information_MillionsMonthlyReportItem
|
|
join y in Funs.DB.Information_MillionsMonthlyReport
|
|
on x.MillionsMonthlyReportId equals y.MillionsMonthlyReportId
|
|
where y.Year == months.Year && y.Month == months.Month && x.Affiliation != "本月合计"
|
|
select x;
|
|
//项目百万工时记录集合
|
|
var projectMillionsMonthlyReports = from x in Funs.DB.InformationProject_MillionsMonthlyReport
|
|
where x.Year == months.Year && x.Month == months.Month
|
|
&& x.States == BLL.Const.State_2
|
|
select x;
|
|
//本部职工伤亡记录
|
|
var accidentCauseReport = (from x in Funs.DB.Information_AccidentCauseReport
|
|
where x.Year == months.Year && x.Month == months.Month
|
|
select x).FirstOrDefault();
|
|
//项目职工伤亡记录集合
|
|
var projectAccidentCauseReports = from x in Funs.DB.InformationProject_AccidentCauseReport
|
|
where x.Year == months.Year && x.Month == months.Month
|
|
&& x.States == BLL.Const.State_2
|
|
select x;
|
|
string accidentDef = string.Empty;
|
|
//项目事故记录集合
|
|
List<Model.Manager_AccidentDetailSortB> details = new List<Model.Manager_AccidentDetailSortB>();
|
|
foreach (var item in monthReports)
|
|
{
|
|
details.AddRange(BLL.AccidentDetailSortBService.GetAccidentDetailSortsByMonthReportId(item.MonthReportId));
|
|
}
|
|
foreach (var detail in details)
|
|
{
|
|
accidentDef += detail.AccidentType + ",";
|
|
}
|
|
if (!string.IsNullOrEmpty(accidentDef))
|
|
{
|
|
accidentDef = accidentDef.Substring(0, accidentDef.LastIndexOf(","));
|
|
}
|
|
DataTable table = new DataTable();
|
|
table.Columns.Add("Id", typeof(string));
|
|
table.Columns.Add("ProjectCode", typeof(string));
|
|
table.Columns.Add("ProjectName", typeof(string));
|
|
table.Columns.Add("ManHours1", typeof(string));
|
|
table.Columns.Add("SafeManHours1", typeof(string));
|
|
table.Columns.Add("Check1", typeof(string));
|
|
table.Columns.Add("ManCount1", typeof(string));
|
|
table.Columns.Add("ManHours2", typeof(string));
|
|
table.Columns.Add("Check2", typeof(string));
|
|
table.Columns.Add("ManCount2", typeof(string));
|
|
table.Columns.Add("Check3", typeof(string));
|
|
table.Columns.Add("ManHours3", typeof(string));
|
|
table.Columns.Add("Check4", typeof(string));
|
|
table.Columns.Add("ManCount3", typeof(string));
|
|
table.Columns.Add("Check5", typeof(string));
|
|
table.Columns.Add("AccidentDef", typeof(string));
|
|
table.Columns.Add("View", typeof(string));
|
|
DataRow row = table.NewRow();
|
|
row["Id"] = 0;
|
|
row["ProjectCode"] = "本部管理";
|
|
row["ProjectName"] = "各项目综合";
|
|
row["ManHours1"] = monthReports.Sum(x => x.Manhours) ?? 0;
|
|
row["SafeManHours1"] = monthReports.Sum(x => x.HseManhours) ?? 0;
|
|
row["Check1"] = Funs.GetNewIntOrZero(row["ManHours1"].ToString()) == Funs.GetNewIntOrZero(row["SafeManHours1"].ToString()) ? "相同" : "不同";
|
|
row["ManCount1"] = monthReports.Sum(x => x.TotalManNum) ?? 0;
|
|
decimal totalWorkNum = 0;
|
|
foreach (var millionsMonthlyReportItem in millionsMonthlyReportItems)
|
|
{
|
|
if (millionsMonthlyReportItem != null && millionsMonthlyReportItem.TotalWorkNum != null)
|
|
{
|
|
totalWorkNum += Funs.GetNewDecimalOrZero(millionsMonthlyReportItem.TotalWorkNum.ToString());
|
|
}
|
|
}
|
|
row["ManHours2"] = (totalWorkNum * 10000).ToString("0.##");
|
|
row["Check2"] = Funs.GetNewIntOrZero(row["ManHours1"].ToString()) == Funs.GetNewDecimalOrZero(row["ManHours2"].ToString()) ? "相同" : "不同";
|
|
int sumPersonNum = 0;
|
|
foreach (var millionsMonthlyReportItem in millionsMonthlyReportItems)
|
|
{
|
|
if (millionsMonthlyReportItem != null && millionsMonthlyReportItem.SumPersonNum != null)
|
|
{
|
|
sumPersonNum += Funs.GetNewIntOrZero(millionsMonthlyReportItem.SumPersonNum.ToString());
|
|
}
|
|
}
|
|
row["ManCount2"] = sumPersonNum;
|
|
row["Check3"] = Funs.GetNewIntOrZero(row["ManCount1"].ToString()) == Funs.GetNewIntOrZero(row["ManCount2"].ToString()) ? "相同" : "不同";
|
|
row["ManHours3"] = (accidentCauseReport != null ? (accidentCauseReport.AverageTotalHours ?? 0) : 0).ToString("0.##");
|
|
row["Check4"] = Funs.GetNewIntOrZero(row["ManHours1"].ToString()) == Funs.GetNewDecimalOrZero(row["ManHours3"].ToString()) ? "相同" : "不同";
|
|
row["ManCount3"] = accidentCauseReport != null ? (accidentCauseReport.AverageManHours ?? 0) : 0;
|
|
row["Check5"] = Funs.GetNewIntOrZero(row["ManCount1"].ToString()) == Funs.GetNewIntOrZero(row["ManCount3"].ToString()) ? "相同" : "不同";
|
|
row["AccidentDef"] = accidentDef;
|
|
table.Rows.Add(row);
|
|
int i = 1;
|
|
foreach (var showProjectId in showProjectIds)
|
|
{
|
|
Model.Manager_MonthReportB monthReport = monthReports.FirstOrDefault(x => x.ProjectId == showProjectId);
|
|
DataRow rowItem = table.NewRow();
|
|
Model.Base_Project project = projects.FirstOrDefault(x => x.ProjectId == showProjectId);
|
|
rowItem["Id"] = i;
|
|
rowItem["ProjectCode"] = project != null ? project.ProjectCode : "";
|
|
rowItem["ProjectName"] = project != null ? project.ProjectName : "";
|
|
rowItem["ManHours1"] = monthReport != null ? (monthReport.Manhours ?? 0) : 0;
|
|
rowItem["SafeManHours1"] = monthReport != null ? (monthReport.HseManhours ?? 0) : 0;
|
|
rowItem["Check1"] = Funs.GetNewIntOrZero(rowItem["ManHours1"].ToString()) == Funs.GetNewIntOrZero(rowItem["SafeManHours1"].ToString()) ? "相同" : "不同";
|
|
rowItem["ManCount1"] = monthReport != null ? (monthReport.TotalManNum ?? 0) : 0;
|
|
var projectMillionsMonthlyReport = projectMillionsMonthlyReports.FirstOrDefault(x => x.ProjectId == showProjectId);
|
|
rowItem["ManHours2"] = ((projectMillionsMonthlyReport != null ? (projectMillionsMonthlyReport.TotalWorkNum ?? 0) : 0) * 10000).ToString("0.##");
|
|
rowItem["Check2"] = Funs.GetNewIntOrZero(rowItem["ManHours1"].ToString()) == Funs.GetNewDecimalOrZero(rowItem["ManHours2"].ToString()) ? "相同" : "不同";
|
|
rowItem["ManCount2"] = projectMillionsMonthlyReport != null ? (projectMillionsMonthlyReport.SumPersonNum ?? 0) : 0;
|
|
rowItem["Check3"] = Funs.GetNewIntOrZero(rowItem["ManCount1"].ToString()) == Funs.GetNewIntOrZero(rowItem["ManCount2"].ToString()) ? "相同" : "不同";
|
|
var projectAccidentCauseReport = projectAccidentCauseReports.FirstOrDefault(x => x.ProjectId == showProjectId);
|
|
rowItem["ManHours3"] = (projectAccidentCauseReport != null ? (projectAccidentCauseReport.AverageTotalHours ?? 0) : 0).ToString("0.##");
|
|
rowItem["Check4"] = Funs.GetNewIntOrZero(rowItem["ManHours1"].ToString()) == Funs.GetNewDecimalOrZero(rowItem["ManHours3"].ToString()) ? "相同" : "不同";
|
|
rowItem["ManCount3"] = projectAccidentCauseReport != null ? (projectAccidentCauseReport.AverageManHours ?? 0) : 0;
|
|
rowItem["Check5"] = Funs.GetNewIntOrZero(rowItem["ManCount1"].ToString()) == Funs.GetNewIntOrZero(rowItem["ManCount3"].ToString()) ? "相同" : "不同";
|
|
string itemAccidentDef = string.Empty;
|
|
//项目事故记录集合
|
|
List<Model.Manager_AccidentDetailSortB> itemDetails = new List<Model.Manager_AccidentDetailSortB>();
|
|
itemDetails.AddRange(BLL.AccidentDetailSortBService.GetAccidentDetailSortsByMonthReportId(showProjectId));
|
|
foreach (var detail in itemDetails)
|
|
{
|
|
itemAccidentDef += detail.AccidentType + ",";
|
|
}
|
|
if (!string.IsNullOrEmpty(itemAccidentDef))
|
|
{
|
|
itemAccidentDef = itemAccidentDef.Substring(0, itemAccidentDef.LastIndexOf(","));
|
|
}
|
|
rowItem["AccidentDef"] = itemAccidentDef;
|
|
rowItem["View"] = "查看月报";
|
|
table.Rows.Add(rowItem);
|
|
i++;
|
|
}
|
|
|
|
Grid1.RecordCount = table.Rows.Count;
|
|
Grid1.DataSource = table;
|
|
Grid1.DataBind();
|
|
for (int j = 0; j < this.Grid1.Rows.Count; j++)
|
|
{
|
|
if (this.Grid1.Rows[j].Values[6].ToString() == "不同")
|
|
{
|
|
this.Grid1.Rows[j].CellCssClasses[6] = "color";
|
|
}
|
|
if (this.Grid1.Rows[j].Values[10].ToString() == "不同")
|
|
{
|
|
this.Grid1.Rows[j].CellCssClasses[10] = "color";
|
|
}
|
|
if (this.Grid1.Rows[j].Values[12].ToString() == "不同")
|
|
{
|
|
this.Grid1.Rows[j].CellCssClasses[12] = "color";
|
|
}
|
|
if (this.Grid1.Rows[j].Values[15].ToString() == "不同")
|
|
{
|
|
this.Grid1.Rows[j].CellCssClasses[15] = "color";
|
|
}
|
|
if (this.Grid1.Rows[j].Values[17].ToString() == "不同")
|
|
{
|
|
this.Grid1.Rows[j].CellCssClasses[17] = "color";
|
|
}
|
|
}
|
|
}
|
|
#endregion
|
|
|
|
#region 查询
|
|
/// <summary>
|
|
/// 查询
|
|
/// </summary>
|
|
/// <param name="sender"></param>
|
|
/// <param name="e"></param>
|
|
protected void TextBox_TextChanged(object sender, EventArgs e)
|
|
{
|
|
this.BindGrid();
|
|
}
|
|
#endregion
|
|
|
|
#region 过滤表头、排序、分页、关闭窗口
|
|
/// <summary>
|
|
/// 过滤表头
|
|
/// </summary>
|
|
/// <param name="sender"></param>
|
|
/// <param name="e"></param>
|
|
protected void Grid1_FilterChange(object sender, EventArgs e)
|
|
{
|
|
BindGrid();
|
|
}
|
|
|
|
/// <summary>
|
|
/// 分页
|
|
/// </summary>
|
|
/// <param name="sender"></param>
|
|
/// <param name="e"></param>
|
|
protected void Grid1_PageIndexChange(object sender, GridPageEventArgs e)
|
|
{
|
|
Grid1.PageIndex = e.NewPageIndex;
|
|
BindGrid();
|
|
}
|
|
|
|
/// <summary>
|
|
/// 排序
|
|
/// </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();
|
|
}
|
|
#endregion
|
|
|
|
#region 校对
|
|
/// <summary>
|
|
/// 校对
|
|
/// </summary>
|
|
/// <param name="sender"></param>
|
|
/// <param name="e"></param>
|
|
protected void BtnAnalyse_Click(object sender, EventArgs e)
|
|
{
|
|
if (!string.IsNullOrEmpty(this.txtReportDate.Text.Trim()))
|
|
{
|
|
BindGrid();
|
|
}
|
|
else
|
|
{
|
|
Alert.ShowInTop("请选择月份！", MessageBoxIcon.Warning);
|
|
return;
|
|
}
|
|
}
|
|
#endregion
|
|
|
|
#region 导出按钮
|
|
/// 导出按钮
|
|
/// </summary>
|
|
/// <param name="sender"></param>
|
|
/// <param name="e"></param>
|
|
protected void btnOut_Click(object sender, EventArgs e)
|
|
{
|
|
Response.ClearContent();
|
|
string filename = Funs.GetNewFileName();
|
|
Response.AddHeader("content-disposition", "attachment; filename=" + System.Web.HttpUtility.UrlEncode("月报与集团报表校对" + filename, System.Text.Encoding.UTF8) + ".xls");
|
|
Response.ContentType = "application/excel";
|
|
Response.ContentEncoding = System.Text.Encoding.UTF8;
|
|
this.Grid1.PageSize = 500;
|
|
this.BindGrid();
|
|
Response.Write(GetGridTableHtml(Grid1));
|
|
Response.End();
|
|
}
|
|
|
|
/// <summary>
|
|
/// 导出方法
|
|
/// </summary>
|
|
/// <param name="grid"></param>
|
|
/// <returns></returns>
|
|
private string GetGridTableHtml(Grid grid)
|
|
{
|
|
StringBuilder sb = new StringBuilder();
|
|
sb.Append("<meta http-equiv=\"content-type\" content=\"application/excel; charset=UTF-8\"/>");
|
|
sb.Append("<table cellspacing=\"0\" rules=\"all\" border=\"1\" style=\"border-collapse:collapse;\">");
|
|
sb.Append("<tr>");
|
|
foreach (GridColumn column in grid.Columns)
|
|
{
|
|
sb.AppendFormat("<td>{0}</td>", column.HeaderText);
|
|
}
|
|
sb.Append("</tr>");
|
|
foreach (GridRow row in grid.Rows)
|
|
{
|
|
sb.Append("<tr>");
|
|
foreach (GridColumn column in grid.Columns)
|
|
{
|
|
string html = row.Values[column.ColumnIndex].ToString();
|
|
if (column.ColumnID == "tfNumber")
|
|
{
|
|
html = (row.FindControl("lblNumber") as AspNet.Label).Text;
|
|
}
|
|
if (column.ColumnID == "tfSee")
|
|
{
|
|
html = (row.FindControl("lbtnSee") as AspNet.LinkButton).Text;
|
|
}
|
|
sb.AppendFormat("<td>{0}</td>", html);
|
|
}
|
|
|
|
sb.Append("</tr>");
|
|
}
|
|
|
|
sb.Append("</table>");
|
|
|
|
return sb.ToString();
|
|
}
|
|
#endregion
|
|
|
|
#region Grid点击事件
|
|
/// <summary>
|
|
/// Grid1行点击事件
|
|
/// </summary>
|
|
/// <param name="sender"></param>
|
|
/// <param name="e"></param>
|
|
protected void Grid1_RowCommand(object sender, GridCommandEventArgs e)
|
|
{
|
|
string projectCode = this.Grid1.Rows[e.RowIndex].DataKeys[1].ToString();
|
|
if (e.CommandName == "View")
|
|
{
|
|
if (string.IsNullOrEmpty(this.txtReportDate.Text.Trim()))
|
|
{
|
|
ShowNotify("请选择月份！", MessageBoxIcon.Warning);
|
|
return;
|
|
}
|
|
Model.Base_Project project = (from x in Funs.DB.Base_Project where x.ProjectCode == projectCode select x).FirstOrDefault();
|
|
if (project == null)
|
|
{
|
|
ShowNotify("该项目信息不存在！", MessageBoxIcon.Warning);
|
|
return;
|
|
}
|
|
Model.Manager_MonthReportB monthReport = BLL.MonthReportBService.GetMonthReportByMonth(Convert.ToDateTime(this.txtReportDate.Text.Trim() + "-01"), project.ProjectId);
|
|
if (monthReport == null)
|
|
{
|
|
ShowNotify("该项目当前月报不存在！", MessageBoxIcon.Warning);
|
|
return;
|
|
}
|
|
PageContext.RegisterStartupScript(Window1.GetShowReference(String.Format("../../HSSE/Manager/MonthReportBView.aspx?MonthReportId={0}", monthReport.MonthReportId, "查看 - ")));
|
|
}
|
|
}
|
|
#endregion
|
|
}
|
|
} |