/// <summary>
/// 维修统计明细
/// </summary>
/// <param name="SelectYear">年份</param>
/// <param name="RepairProject">维修项目</param>
/// <returns></returns>
public JsonResult GetRepairProjectDetail(int SelectYear, string RepairProject)
{
var repairProjectViewModel = new RepairProjectViewModel();
try
{
var projectList = rp.GetRepairListByProjectAndYear(RepairProject, xxid, SelectYear);
if (projectList.Any())
{
foreach (var pro in projectList)
{
pro.Remark = pro.RepairTime.Value.ToString("yyyy-MM-dd");
pro.RepairFk = pro.BaoXiuTime.Value.ToString("yyyy-MM-dd");
DateTime repStart = new DateTime(Convert.ToInt32(pro.BaoXiuTime.Value.Year), Convert.ToInt32(pro.BaoXiuTime.Value.Month), Convert.ToInt32(pro.BaoXiuTime.Value.Day));
DateTime repEnd = new DateTime(Convert.ToInt32(pro.RepairTime.Value.Year), Convert.ToInt32(pro.RepairTime.Value.Month), Convert.ToInt32(pro.RepairTime.Value.Day));
int days = new TimeSpan(repEnd.Ticks - repStart.Ticks).Days;
pro.RepairFankui = days.ToString();
}
repairProjectViewModel.RepairProjectList = projectList;
}
}
catch (Exception)
{
throw;
}
return(Json(repairProjectViewModel, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 维修统计
/// </summary>
/// <param name="repairType">维修类型</param>
/// <param name="selectYear">年份</param>
/// <returns></returns>
public ActionResult GetRepairProject(string repairType, int selectYear)
{
var repairProjectViewModel = new RepairProjectViewModel();
List <Series> serList = new List <Series>();
try
{
var projectList = rp.GetRepair_DistictList(xxid, repairType);
if (projectList.Any())
{
string[] projectNames = new string[projectList.Count];
for (int j = 0; j < projectList.Count; j++)
{
projectNames[j] = projectList[j].RepairProjectName;
}
repairProjectViewModel.ProjectNames = projectNames;
var repairProjectList = rp.GetRepairListByYear(xxid, selectYear);
for (int i = 1; i < 13; i++)
{
Series s = new Series();
s.id = i;
s.type = "column";
s.name = i + "月";
float?[] d = new float?[projectList.Count];
for (int j = 0; j < projectList.Count; j++)
{
var proCount =
repairProjectList.Count(
w =>
w.BaoXiuProject == projectList[j].RepairProjectName &&
w.RepairTime.Value.Month == i);
d[j] = proCount;
}
s.data = d;
serList.Add(s);
}
repairProjectViewModel.SeriesList = serList;
}
}
catch (Exception)
{
throw;
}
return(Json(NewtonsoftJson(repairProjectViewModel)));
}
public ActionResult GetRepairProjectTwo(int selectYear)
{
var repairProjectViewModel = new RepairProjectViewModel();
try
{
var projectList = rp.GetRepairTypeList();
var Sum = rp.GetRepair_DistictListTwo(xxid, selectYear);
var totalcount1 = 0;
var totalcount2 = 0;
if (projectList.Any())
{
string[] CodeName = new string[projectList.Count];
List <int> list1 = new List <int>();
List <int> list2 = new List <int>();
string[] type2 = new string[Sum.Count];
for (int j = 0; j < projectList.Count; j++)
{
CodeName[j] = projectList[j].CodeName;
totalcount1 = Sum.Count(r => r.DongLou == CodeName[j]);
totalcount2 = Sum.Count(r => r.DongLou == CodeName[j] && r.RepairStatus == "已处理");
list1.Add(totalcount1);
list2.Add(totalcount2);
}
//类型
repairProjectViewModel.ProjectNames = CodeName;
//保修总数
repairProjectViewModel.SumCount = list1;
//已维修总数
// var repairProjectList = rp.GetRepairListByYearTwo(xxid,selectYear);
repairProjectViewModel.HaveSumCount = list2;
}
}
catch (Exception)
{
throw;
}
return(Json(NewtonsoftJson(repairProjectViewModel)));
}
