public void TestOverAllSearchGetRegion_Month()
{
OverAllSearchService service = new OverAllSearchService();
DateTime today = DateTime.Now;
OverAllSearchViewModel model = service.GetViewModel("MM", "Region", "食堂", "000001G001", "01000", today.ToString("yyyy-MM-dd"));
Console.WriteLine(UtilTest.GetJson(model));
}
public void TestOverAllSearchGetDetp_Quarter()
{
OverAllSearchService service = new OverAllSearchService();
DateTime today = DateTime.Now;
OverAllSearchViewModel model = service.GetViewModel("QQ", "Dept", "2F", "000001G001", "01000", today.ToString("yyyy-MM-dd"));
Console.WriteLine(UtilTest.GetJson(model));
}
public void TestOverAllSearchGetCircuit_Day()
{
OverAllSearchService service = new OverAllSearchService();
DateTime today = DateTime.Now;
OverAllSearchViewModel model = service.GetViewModel("DD", "Circuit", "办公", "000001G001", "01000", today.ToString("yyyy-MM-dd"));
Console.WriteLine(UtilTest.GetJson(model));
}
/// <summary>
/// 获取搜索结果
/// </summary>
/// <param name="timeType">天："DD"；月份："MM"; 季度："QQ"</param>
/// <param name="type">支路："Circuit"；部门："Dept";区域："Region"</param>
/// <param name="keyWord">搜索内容</param>
/// <param name="endDay">结束时间（"yyyy-MM-dd"）</param>
public OverAllSearchViewModel GetViewModel(string timeType, string type, string keyWord, string buildID, string energyCode, string date)
{
DateTime inputDate = Util.ConvertString2DateTime(date, "yyyy-MM-dd");;
//每月第一天
string startDay = inputDate.ToString("yyyy-MM") + "-01";
//每月最后一天
string endDay = inputDate.AddMonths(1).AddDays(-inputDate.Day).ToString("yyyy-MM-dd");
List <EMSValue> timeDataList = new List <EMSValue>();
List <CompareData> momDataList = new List <CompareData>();
List <EnergyAverage> monthAverageList = new List <EnergyAverage>();
List <EnergyAverage> yearAverageList = new List <EnergyAverage>();
switch (timeType)
{
case "DD":
timeDataList = context.GetDayList(type, keyWord, buildID, energyCode, inputDate.ToString("yyyy-MM-dd"));
momDataList = context.GetMomMonthList(type, keyWord, buildID, energyCode, startDay, endDay);
monthAverageList = context.GetMonthAverageList(type, keyWord, buildID, energyCode, startDay, endDay);
yearAverageList = context.GetYearAverageList(type, keyWord, buildID, energyCode, inputDate.ToString("yyyy-01") + "-01", endDay);
break;
case "MM":
timeDataList = context.GetMonthList(type, keyWord, buildID, energyCode, endDay);
momDataList = context.GetMomMonthList(type, keyWord, buildID, energyCode, startDay, endDay);
monthAverageList = context.GetMonthAverageList(type, keyWord, buildID, energyCode, startDay, endDay);
yearAverageList = context.GetYearAverageList(type, keyWord, buildID, energyCode, inputDate.ToString("yyyy-01") + "-01", endDay);
break;
case "QQ":
startDay = inputDate.AddDays(-inputDate.Day + 1).AddMonths(-2).ToString("yyyy-MM-dd");
endDay = inputDate.AddMonths(1).AddDays(-inputDate.Day).ToString("yyyy-MM-dd");
timeDataList = context.GetQuarterList(type, keyWord, buildID, energyCode, startDay, endDay);
momDataList = context.GetMomQuarterList(type, keyWord, buildID, energyCode, startDay, endDay);
monthAverageList = context.GetMonthAverageList(type, keyWord, buildID, energyCode, inputDate.ToString("yyyy-MM") + "-01", endDay);
yearAverageList = context.GetYearAverageList(type, keyWord, buildID, energyCode, inputDate.ToString("yyyy-01") + "-01", endDay);
break;
default:
return(null);
}
OverAllSearchViewModel viewModel = new OverAllSearchViewModel();
viewModel.TimeData = timeDataList;
viewModel.MomData = momDataList;
viewModel.MonthAverageData = monthAverageList;
viewModel.YearAverageData = yearAverageList;
return(viewModel);
}
public OverAllSearchViewModel GetViewModelByUserName(string userName)
{
List <BuildViewModel> builds = context.GetBuildsByUserName(userName);
string buildId;
if (builds.Count > 0)
{
buildId = builds.First().BuildID;
}
else
{
buildId = "";
}
List <EnergyItemDict> energys = context.GetEnergyItemDictByBuild(buildId);
OverAllSearchViewModel viewModel = new OverAllSearchViewModel();
viewModel.Builds = builds;
viewModel.Energys = energys;
return(viewModel);
}
