public JsonResult GetServiceResource()
{
var json = new JsonResults();
var rm = new ResultModel();
try
{
int siteId = int.Parse(System.Configuration.ConfigurationManager.AppSettings["SiteId"]);
DataTable dt = CRBIYYBBReportProjectRule.Intance().GetServiceResource();
List <ResourceMonitoringViewModel> list = CRBICommonLib.ModelConvertHelper <ResourceMonitoringViewModel> .ConvertToModel(dt);
if (list.Count <= 0)
{
rm.Message = "未查询到相关数据！";
rm.Status = false;
json.Data = rm;
return(json);
}
ResourceMonitoringViewModel model = list[0];
rm.Result = model;
rm.Status = true;
}
catch (Exception ex)
{
rm.Message = ex.Message;
rm.Status = false;
}
json.Data = rm;
return(json);
}
public JsonResult GetEquipmentPerformance()
{
var json = new JsonResults();
var rm = new ResultModel();
try
{
int siteId = int.Parse(System.Configuration.ConfigurationManager.AppSettings["SiteId"]);
DataTable dt = CRBIYYBBReportProjectRule.Intance().GetEquipmentPerformance(siteId);
List <PerformanceViewModel> list = CRBICommonLib.ModelConvertHelper <PerformanceViewModel> .ConvertToModel(dt);
PerformanceResultViewModel model = new PerformanceResultViewModel();
model.Equipments = list.Select(m => m.EquipmentName).ToList();
model.PerformanceData = new List <PerformanceDataViewModel>();
PerformanceDataViewModel pdvm = GetPerformanceData(list, model, 0);
model.PerformanceData.Add(pdvm);
pdvm = GetPerformanceData(list, model, 1);
model.PerformanceData.Add(pdvm);
pdvm = GetPerformanceData(list, model, 2);
model.PerformanceData.Add(pdvm);
pdvm = GetPerformanceData(list, model, 3);
model.PerformanceData.Add(pdvm);
rm.Result = model;
rm.Status = true;
}
catch (Exception ex)
{
rm.Message = ex.Message;
rm.Status = false;
}
json.Data = rm;
return(json);
}
public JsonResult GetDutyOnDuty()
{
var json = new JsonResults();
var rm = new ResultModel();
try
{
int siteId = int.Parse(System.Configuration.ConfigurationManager.AppSettings["SiteId"]);
DataTable dtDutyOnDuty = CRBIYYBBReportProjectRule.Intance().GetDutyOnDuty(siteId);
DataTable dtDutyOnDutyRemaining = CRBIYYBBReportProjectRule.Intance().GetDutyOnDutyRemaining(siteId);
List <DutyOnDutyViewModel> listdd = CRBICommonLib.ModelConvertHelper <DutyOnDutyViewModel> .ConvertToModel(dtDutyOnDuty);
List <DutyOnDutyRemainingViewModel> listddr = CRBICommonLib.ModelConvertHelper <DutyOnDutyRemainingViewModel> .ConvertToModel(dtDutyOnDutyRemaining);
DutyOnDutyListViewModel dutyOnDutyListViewModel = new DutyOnDutyListViewModel();
dutyOnDutyListViewModel.DutyOnDutyRemainingViewModel = listddr.Where(m => DateTime.Now > DateTime.Parse(m.ExecuteTime).AddDays(-7)).ToList();
dutyOnDutyListViewModel.DutyOnDutyViewModel = listdd.Where(m => DateTime.Now > DateTime.Parse(m.PlanTime).AddDays(-7)).ToList();
rm.Result = dutyOnDutyListViewModel;
rm.Status = true;
}
catch (Exception ex)
{
rm.Message = ex.Message;
rm.Status = false;
}
json.Data = rm;
return(json);
}
// GET: Warning
public ActionResult Index()
{
int siteId = int.Parse(System.Configuration.ConfigurationManager.AppSettings["SiteId"]);
DataTable dt = CRBIYYBBReportProjectRule.Intance().GetY_WarnFault(siteId);
List <Y_WarnFaultViewModels> list = CRBICommonLib.ModelConvertHelper <Y_WarnFaultViewModels> .ConvertToModel(dt);
foreach (var item in list)
{
try
{
using (var httpClient = new HttpClient())
{
var url = new Uri(System.Configuration.ConfigurationManager.AppSettings["Knowledge"]);
var response = httpClient.GetAsync(url + "/GetExpertKnowledge?val=" + item.EventName + "&pageNo=1&pageSize=1&strOrder=CreateTime%20DESC&equipmentCategory=-1&keyWord=").Result;
var data = response.Content.ReadAsStringAsync().Result;
data = "{ExpertKnowledgeViewModel:" + data.Substring(0, data.LastIndexOf(']') + 1).Substring(data.IndexOf('[')) + "}";
data = data.Replace(@"\", "");
var model = JsonConvert.DeserializeObjectAsync <ExpertKnowledgesViewModel>(data).Result;
if (model.ExpertKnowledgeViewModel.Count > 0)
{
item.ExpertAdvice = model.ExpertKnowledgeViewModel[0].Solution ?? "";
}
}
}
catch
{
item.ExpertAdvice = "";
}
}
return(View(list));
}
public ApiResultViewModel <List <Models.Y_EarlyWarningViewModels> > Get()
{
ApiResultViewModel <List <Y_EarlyWarningViewModels> > result = new ApiResultViewModel <List <Y_EarlyWarningViewModels> >();
try
{
string filePath = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "Setting.ini");
IniFile ini = new IniFile(filePath);
var isChecked = bool.Parse(ini.ReadString("PollingBroadcast", "Checked", ""));
if (isChecked)
{
int siteId = int.Parse(System.Configuration.ConfigurationManager.AppSettings["SiteId"]);
DataTable dt = CRBIYYBBReportProjectRule.Intance().GetEarlyWarning(siteId);
List <Y_EarlyWarningViewModels> list = CRBICommonLib.ModelConvertHelper <Y_EarlyWarningViewModels> .ConvertToModel(dt);
if (list.Count <= 0)
{
result.Status = false;
return(result);
}
result.Status = true;
result.Obj = list;
}
else
{
result.Status = false;
}
}
catch (Exception ex)
{
result.Status = false;
result.Message = ex.Message;
}
return(result);
}
public JsonResult GetWarnFault()
{
var json = new JsonResults();
var rm = new ResultModel();
try
{
int siteId = int.Parse(System.Configuration.ConfigurationManager.AppSettings["SiteId"]);
string monday = DateTime.Now.AddDays(-((int)DateTime.Now.DayOfWeek - 1)).ToShortDateString();
string sunday = DateTime.Now.AddDays(7 - ((int)DateTime.Now.DayOfWeek)).ToShortDateString();
DataTable dtWeek = CRBIYYBBReportProjectRule.Intance().GetWarnFault(siteId, monday, sunday);
List <WarnFaultViewModal> listWeek = CRBICommonLib.ModelConvertHelper <WarnFaultViewModal> .ConvertToModel(dtWeek);
WeeklyCurveViewModal modalWeek = GetModal(monday, listWeek);
sunday = DateTime.Now.AddDays(-((int)DateTime.Now.DayOfWeek)).ToShortDateString();
monday = DateTime.Now.AddDays(-((int)DateTime.Now.DayOfWeek)).AddDays(-6).ToShortDateString();
DataTable dtLastWeek = CRBIYYBBReportProjectRule.Intance().GetWarnFault(siteId, monday, sunday);
List <WarnFaultViewModal> listLastWeek = CRBICommonLib.ModelConvertHelper <WarnFaultViewModal> .ConvertToModel(dtLastWeek);
WeeklyCurveViewModal modalLastWeek = GetModal(monday, listLastWeek);
WeeklyCurveResultViewModal modal = new WeeklyCurveResultViewModal();
modal.WeeklyCurveWeek = modalWeek;
modal.WeeklyCurveLastWeek = modalLastWeek;
rm.Result = modal;
rm.Status = true;
}
catch (Exception ex)
{
rm.Message = ex.Message;
rm.Status = false;
}
json.Data = rm;
return(json);
}
// GET: ZeroFaultEquipment
public ActionResult Index()
{
int siteId = int.Parse(System.Configuration.ConfigurationManager.AppSettings["SiteId"]);
DataTable dt = CRBIYYBBReportProjectRule.Intance().GetZeroFaultEquipment(siteId);
List <ZeroFaultEquipmentViewModel> list = CRBICommonLib.ModelConvertHelper <ZeroFaultEquipmentViewModel> .ConvertToModel(dt);
return(View(list));
}
// GET: DailyKnowledge
public ActionResult Index()
{
DataTable dt = CRBIYYBBReportProjectRule.Intance().GetDailyKnowledgePop();
List <TipsViewModel> list = CRBICommonLib.ModelConvertHelper <TipsViewModel> .ConvertToModel(dt);
Random r = new Random();
int i = r.Next(1, list.Count);
return(View(list[i]));
}
public JsonResult GetEngineRoomScoreItem(int scoreId)
{
var json = new JsonResults();
var rm = new ResultModel();
try
{
DataTable dt = CRBIYYBBReportProjectRule.Intance().GetEngineRoomScoreItem(scoreId);
List <Y_EngineRoomScoreItemModel> list = CRBICommonLib.ModelConvertHelper <Y_EngineRoomScoreItemModel> .ConvertToModel(dt);
Y_EngineRoomScoreItemViewModel model = new Y_EngineRoomScoreItemViewModel();
foreach (var item in list)
{
switch ((EngineScoreItem)item.ScoreItemID)
{
case EngineScoreItem.支撑时间:
model.SupportTimeBaseScore = item.BaseScore;
model.SupportTimeScore = item.Score;
break;
case EngineScoreItem.健康状态:
model.HealthStatusBaseScore = item.BaseScore;
model.HealthStatusScore = item.Score;
break;
case EngineScoreItem.供电质量:
model.PowerQualityBaseScore = item.BaseScore;
model.PowerQualityScore = item.Score;
break;
case EngineScoreItem.设备容量富裕量:
model.CapacitySurplusBaseScore = item.BaseScore;
model.CapacitySurplusScore = item.Score;
break;
case EngineScoreItem.接地电阻:
model.EarthResistanceBaseScore = item.BaseScore;
model.EarthResistanceScore = item.Score;
break;
default:
break;
}
}
rm.Result = model;
rm.Status = true;
}
catch (Exception ex)
{
rm.Message = ex.Message;
rm.Status = false;
}
json.Data = rm;
return(json);
}
public bool Get()
{
try
{
int siteId = int.Parse(System.Configuration.ConfigurationManager.AppSettings["SiteId"]);
DataTable dt = CRBIYYBBReportProjectRule.Intance().GetEngineRoomScore(siteId);
}
catch
{
return(false);
}
return(true);
}
public JsonResult GetAlarmStatistics()
{
var json = new JsonResults();
var rm = new ResultModel();
try
{
int siteId = int.Parse(System.Configuration.ConfigurationManager.AppSettings["SiteId"]);
DataTable dt = CRBIYYBBReportProjectRule.Intance().GetAlarmStatistics(siteId);
List <AlarmStatisticsModel> list = CRBICommonLib.ModelConvertHelper <AlarmStatisticsModel> .ConvertToModel(dt);
AlarmStatisticsViewModel asvm = new AlarmStatisticsViewModel();
foreach (var item in list.Where(m => m.EventLevel == "一级告警"))
{
if (item.EventType == 1)
{
asvm.OneMalfunctionNumber = item.Number;
}
if (item.EventType == 0)
{
asvm.OneWarningNumber = item.Number;
}
}
foreach (var item in list.Where(m => m.EventLevel == "二级告警"))
{
if (item.EventType == 1)
{
asvm.TwoMalfunctionNumber = item.Number;
}
if (item.EventType == 0)
{
asvm.TwoWarningNumber = item.Number;
}
}
rm.Result = asvm;
rm.Status = true;
}
catch (Exception ex)
{
rm.Message = ex.Message;
rm.Status = false;
}
json.Data = rm;
return(json);
}
public ApiResultViewModel <bool> Post([FromBody] string postParam)
{
ApiResultViewModel <bool> result = new ApiResultViewModel <bool>();
try
{
PostParamViewModel ppvm = JsonConvert.DeserializeObject <PostParamViewModel>(postParam);
var isDelete = CRBIYYBBReportProjectRule.Intance().DeleteWarnFault(ppvm.ID);
result.Status = true;
result.Obj = isDelete;
}
catch (Exception ex)
{
result.Status = false;
result.Message = ex.Message;
}
return(result);
}
public ApiResultViewModel <EarlyWarningPopViewModel> Get()
{
ApiResultViewModel <EarlyWarningPopViewModel> result = new ApiResultViewModel <EarlyWarningPopViewModel>();
try
{
string filePath = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "Setting.ini");
IniFile ini = new IniFile(filePath);
bool isPop = bool.Parse(ini.ReadString("EarlyWarning", "Pop", ""));
bool isVoice = bool.Parse(ini.ReadString("EarlyWarning", "Voice", ""));
if (isPop)
{
int siteId = int.Parse(System.Configuration.ConfigurationManager.AppSettings["SiteId"]);
DataTable dt = CRBIYYBBReportProjectRule.Intance().GetEarlyWarningPop(siteId);
List <EarlyWarningPopViewModel> list = CRBICommonLib.ModelConvertHelper <EarlyWarningPopViewModel> .ConvertToModel(dt);
if (list.Count <= 0)
{
result.Status = true;
result.Obj = null;
return(result);
}
result.Status = true;
result.Obj = list[0];
if (isVoice)
{
result.Obj.IsVoice = true;
}
}
else
{
result.Status = true;
result.Obj = null;
}
}
catch (Exception ex)
{
result.Status = false;
result.Message = ex.Message;
}
return(result);
}
public ApiResultViewModel <Y_EngineRoomScoreViewModel> Get()
{
ApiResultViewModel <Y_EngineRoomScoreViewModel> result = new ApiResultViewModel <Y_EngineRoomScoreViewModel>();
try
{
int siteId = int.Parse(System.Configuration.ConfigurationManager.AppSettings["SiteId"]);
DataTable dt = CRBIYYBBReportProjectRule.Intance().GetEngineRoomScore(siteId);
List <Y_EngineRoomScoreViewModel> list = CRBICommonLib.ModelConvertHelper <Y_EngineRoomScoreViewModel> .ConvertToModel(dt);
result.Obj = list[0];
result.Status = true;
}
catch (Exception ex)
{
result.Status = false;
result.Message = ex.Message;
}
return(result);
}
public ApiResultViewModel <MonitoringModeViewModel> Get()
{
ApiResultViewModel <MonitoringModeViewModel> result = new ApiResultViewModel <MonitoringModeViewModel>();
try
{
MonitoringModeViewModel model = new MonitoringModeViewModel();
int siteId = int.Parse(System.Configuration.ConfigurationManager.AppSettings["SiteId"]);
int count = 0;
count = CRBIYYBBReportProjectRule.Intance().GetWarnFaultCount(siteId);
if (count == 0)
{
count = CRBIYYBBReportProjectRule.Intance().GetEarlyWarningCount(siteId);
if (count == 0)
{
model.Text = "正常";
model.Count = count;
}
else
{
model.Text = "预警";
model.Count = count;
}
}
else
{
model.Text = "告警";
model.Count = count;
}
result.Status = true;
result.Obj = model;
}
catch (Exception ex)
{
result.Status = false;
result.Message = ex.Message;
}
return(result);
}
public ApiResultViewModel <TipsViewModel> Get()
{
ApiResultViewModel <TipsViewModel> result = new ApiResultViewModel <TipsViewModel>();
try
{
string filePath = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "Setting.ini");
IniFile ini = new IniFile(filePath);
bool isShow = bool.Parse(ini.ReadString("Tips", "Show", ""));
if (isShow)
{
DataTable dt = CRBIYYBBReportProjectRule.Intance().GetDailyKnowledgePop();
List <TipsViewModel> list = CRBICommonLib.ModelConvertHelper <TipsViewModel> .ConvertToModel(dt);
if (list.Count <= 0)
{
result.Status = true;
result.Obj = null;
return(result);
}
result.Status = true;
Random r = new Random();
int i = r.Next(1, list.Count);
result.Obj = list[i];
if (result.Obj == null)
{
result.Status = true;
result.Obj = null;
return(result);
}
}
}
catch (Exception ex)
{
result.Status = false;
result.Message = ex.Message;
}
return(result);
}
public JsonResult GetEngineRoomScore()
{
var json = new JsonResults();
var rm = new ResultModel();
try
{
int siteId = int.Parse(System.Configuration.ConfigurationManager.AppSettings["SiteId"]);
DataTable dt = CRBIYYBBReportProjectRule.Intance().GetEngineRoomScore(siteId);
List <Y_EngineRoomScoreViewModel> list = CRBICommonLib.ModelConvertHelper <Y_EngineRoomScoreViewModel> .ConvertToModel(dt);
Y_EngineRoomScoreViewModel model = list[0];
rm.Result = model;
rm.Status = true;
}
catch (Exception ex)
{
rm.Message = ex.Message;
rm.Status = false;
}
json.Data = rm;
return(json);
}
public JsonResult GetSupportTime()
{
var json = new JsonResults();
var rm = new ResultModel();
try
{
int siteId = int.Parse(System.Configuration.ConfigurationManager.AppSettings["SiteId"]);
int dc = (int)EquipmentTypeEnum.开关电源蓄电池组;
int ups = (int)EquipmentTypeEnum.UPS蓄电池组;
int generator = (int)EquipmentTypeEnum.发电机组;
List <int> typeList = new List <int>();
typeList.Add(dc);
typeList.Add(ups);
typeList.Add(generator);
DataTable dt = CRBIYYBBReportProjectRule.Intance().GetSupportTime(siteId, typeList);
List <SupportTimeModel> list = CRBICommonLib.ModelConvertHelper <SupportTimeModel> .ConvertToModel(dt);
SupportTimeViewModel model = new SupportTimeViewModel();
foreach (var item in list)
{
switch ((EquipmentTypeEnum)item.EquipmentType)
{
case EquipmentTypeEnum.UPS蓄电池组:
if (model.UPSKeepTime == 0 || (item.KeepTime < model.UPSKeepTime && item.KeepTime != 0))
{
model.UPSKeepTime = item.KeepTime;
model.UPSEqName = item.EquipmentName;
model.UPSLifeTime = item.LifeTime;
}
break;
case EquipmentTypeEnum.开关电源蓄电池组:
if (model.DCKeepTime == 0 || (item.KeepTime < model.DCKeepTime && item.KeepTime != 0))
{
model.DCKeepTime = item.KeepTime;
model.DCEqName = item.EquipmentName;
model.DCLifeTime = item.LifeTime;
}
break;
case EquipmentTypeEnum.发电机组:
if (model.GeneratorKeepTime == 0 || (item.KeepTime < model.GeneratorKeepTime && item.KeepTime != 0))
{
model.GeneratorKeepTime = item.KeepTime;
model.GeneratorEqName = item.EquipmentName;
model.GeneratorLifeTime = item.LifeTime;
}
break;
default:
break;
}
}
rm.Result = model;
rm.Status = true;
}
catch (Exception ex)
{
rm.Message = ex.Message;
rm.Status = false;
}
json.Data = rm;
return(json);
}
static void Main(string[] args)
{
string sAppPath = AppDomain.CurrentDomain.BaseDirectory;
DirectoryInfo dirBase = new DirectoryInfo(sAppPath);
DirectoryInfo dirRoot = dirBase.Parent.Parent;
string sRoot = dirRoot.FullName;
Stopwatch timer = new Stopwatch();
timer.Start();
//测试数据
//健康周报
Console.WriteLine(string.Format("CR-BI数据查询框架开始执行：{0}", DateTime.Now.ToString()));
Console.WriteLine("查询健康周报");
CRBIYYBBReportProjectRule.Intance().GetHealthweeklyData();
Console.WriteLine("查询区域级近一周整体健康状态");
CRBIYYBBReportProjectRule.Intance().LoadData_A_7D_ZTJKZT(new CRBIHttpContextQuery()
{
});
Console.WriteLine("区域级告警处理时效性分析");
CRBIYYBBReportProjectRule.Intance().LoadData_A_AlarmDisposeTimes(new CRBIHttpContextQuery());
Console.WriteLine("区域级告警分布");
CRBIYYBBReportProjectRule.Intance().LoadData_A_AlarmDistribution(new CRBIHttpContextQuery());
Console.WriteLine("区域级重点关注下周告警分布");
CRBIYYBBReportProjectRule.Intance().LoadData_A_AlarmDistribution_NextWeek(new CRBIHttpContextQuery());
Console.WriteLine("区域级综合保障能力");
CRBIYYBBReportProjectRule.Intance().LoadData_A_ZHBBNL(new CRBIHttpContextQuery());
Console.WriteLine("站点级综合保障能力");
CRBIYYBBReportProjectRule.Intance().LoadData_S_ZHBBNL(new CRBIHttpContextQuery());
Console.WriteLine("区域级综合评估雷达");
CRBIYYBBReportProjectRule.Intance().LoadData_A_ZHPGLD(new CRBIHttpContextQuery());
Console.WriteLine("站点级综合评估雷达");
CRBIYYBBReportProjectRule.Intance().LoadData_S_ZHPGLD(new CRBIHttpContextQuery());
Console.WriteLine("区域级无故障运行天数");
CRBIYYBBReportProjectRule.Intance().LoadData_A_WGZYXTS(new CRBIHttpContextQuery());
Console.WriteLine("站点级无故障运行天数");
CRBIYYBBReportProjectRule.Intance().LoadData_S_WGZYXTS(new CRBIHttpContextQuery());
Console.WriteLine("获取零故障设备");
CRBIYYBBReportProjectRule.Intance().LoadData_A_S_ZeroBugMachine(new CRBIHttpContextQuery());
Console.WriteLine("获取零故障设备");
CRBIYYBBReportProjectRule.Intance().LoadData_S_ZeroBugMachine(new CRBIHttpContextQuery());
Console.WriteLine("获取区域级零故障设备厂商");
CRBIYYBBReportProjectRule.Intance().LoadData_A_ZeroBugFactory(new CRBIHttpContextQuery());
Console.WriteLine("获取站点级零故障设备厂商");
CRBIYYBBReportProjectRule.Intance().LoadData_S_ZeroBugFactory(new CRBIHttpContextQuery());
Console.WriteLine("区域级告警分布");
CRBIYYBBReportProjectRule.Intance().LoadData_A_AlarmDistribution(new CRBIHttpContextQuery());
Console.WriteLine("站点级告警分布");
CRBIYYBBReportProjectRule.Intance().LoadData_S_AlarmDistribution(new CRBIHttpContextQuery());
Console.WriteLine("站点级获取一周告警分布");
CRBIYYBBReportProjectRule.Intance().LoadData_S_AlarmDistributionByDate_1Week(new CRBIHttpContextQuery());
Console.WriteLine("站点级获取一周活动告警分布");
CRBIYYBBReportProjectRule.Intance().LoadData_S_ActiveAlarmDistributionByDate_1Week(new CRBIHttpContextQuery());
Console.WriteLine("站点级获取各站点历史告警统计");
CRBIYYBBReportProjectRule.Intance().LoadData_S_HistoryAlarmCountByMonth(new CRBIHttpContextQuery());
Console.WriteLine("区域级告警处理时效性分析");
CRBIYYBBReportProjectRule.Intance().LoadData_A_AlarmDisposeTimes(new CRBIHttpContextQuery());
Console.WriteLine("站点级告警处理时效性分析");
CRBIYYBBReportProjectRule.Intance().LoadData_S_AlarmDisposeTimes(new CRBIHttpContextQuery());
Console.WriteLine("区域级重点关注下周告警分布");
CRBIYYBBReportProjectRule.Intance().LoadData_A_AlarmDistribution_NextWeek(new CRBIHttpContextQuery());
Console.WriteLine("站点级重点关注下周告警分布");
CRBIYYBBReportProjectRule.Intance().LoadData_S_AlarmDistribution_NextWeek(new CRBIHttpContextQuery());
Console.WriteLine("站点级重点关注设备");
CRBIYYBBReportProjectRule.Intance().LoadData_S_VIPMachine(new CRBIHttpContextQuery());
Console.WriteLine("站点级维护任务燃尽图");
CRBIYYBBReportProjectRule.Intance().LoadData_S_TaskBrunDownChart(new CRBIHttpContextQuery());
Console.WriteLine("站点级每日知识");
CRBIYYBBReportProjectRule.Intance().LoadData_S_DailyKnowledge(new CRBIHttpContextQuery());
Console.WriteLine("站点级维护计划");
CRBIYYBBReportProjectRule.Intance().LoadData_S_TodoTask(new CRBIHttpContextQuery());
Console.WriteLine("站点设备信息");
CRBIYYBBReportProjectRule.Intance().LoadData_S_MachineInfo(new CRBIHttpContextQuery());
Console.WriteLine("区域级支撑时间");
CRBIYYBBReportProjectRule.Intance().LoadData_A_SupportTime(new CRBIHttpContextQuery());
Console.WriteLine("站点级支撑时间");
CRBIYYBBReportProjectRule.Intance().LoadData_S_SupportTime(new CRBIHttpContextQuery());
Console.WriteLine("服务器信息");
CRBIYYBBReportProjectRule.Intance().LoadData_IMUInfo(new CRBIHttpContextQuery());
Console.WriteLine("当前值机信息");
CRBIYYBBReportProjectRule.Intance().LoadData_CurrentPCinfo(new CRBIHttpContextQuery());
Console.WriteLine("......");
Console.WriteLine(string.Format("CR-BI数据查询框架结束执行：{0}", DateTime.Now.ToString()));
Console.WriteLine("按“Y/y”结束执行");
string str = Console.ReadLine();
if (str.Equals("y") || str.Equals("Y"))
{
Console.WriteLine("结束执行！");
}
else
{
#region 报表相关
//string sDocTemplatePath = Path.Combine(sRoot, "Templates", "专利申请授权情况简报（简版）.docx");
//string sXmlFilePath = Path.Combine(sRoot, "XmlConfigs", "GDPAPatentReport_Simple_Config.XML");
//string sReflectdFuncLib = "GDPASmartReportToolLib.GDPAReflectedFuncLib_Simple";
//专利申请授权情况简报（完整版）.docx 原模板
//1专利申请授权情况简报（完整版）.docm 使用宏更新目录的模板
//2专利申请授权情况简报（完整版） - 副本.docx 修改了XML结构以更新目录的模板
string sDocTemplatePath = Path.Combine(sRoot, "Templates", "专利申请授权情况简报（完整版）.docm");
string sXmlFilePath = Path.Combine(sRoot, "XmlConfigs", "GDPAPatentReport_Complete_Config.XML");
string sReflectdFuncLib = "GDPASmartReportToolLib.GDPAReflectedFuncLib_Complete";
sDocTemplatePath = Path.Combine(sRoot, "Templates", "柯蓝蓄电池充电测试报告.docm");
sXmlFilePath = Path.Combine(sRoot, "XmlConfigs", "CRBIReport_Charge_1_Config.XML");
sReflectdFuncLib = "CRBISmartReportToolLib.CRBIReflectedFunction_Charge_1";
string sExcelTemplatePath = Path.Combine(sRoot, "Templates", "GDPATempExcelTemplate.xlsx");
string sReportSaveDir = "d:\\OpenXmlTest";
CRBIConst.SetDateTime(DateTime.Parse("2017-1-1"), DateTime.Parse("2017-9"));
CRBIConst.const_LogPath = Path.Combine(sReportSaveDir, CRBIConst.const_LogParentDir, CRBIConst.const_LogName);
//CRBIDocumentProcessor processor = new CRBIDocumentProcessor
// (sDocTemplatePath, sXmlFilePath, sExcelTemplatePath, sReflectdFuncLib, true, sReportSaveDir);
//processor.GenerateDocx();
#endregion
}
timer.Stop();
Console.WriteLine(string.Format("用时{0}毫秒", timer.ElapsedMilliseconds));
Console.ReadKey();
}
public ApiResultViewModel <WarnFaultPopViewModel> Get()
{
ApiResultViewModel <WarnFaultPopViewModel> result = new ApiResultViewModel <WarnFaultPopViewModel>();
try
{
string filePath = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "Setting.ini");
IniFile ini = new IniFile(filePath);
bool isPop = bool.Parse(ini.ReadString("Warning", "Pop", ""));
bool isVoice = bool.Parse(ini.ReadString("Warning", "Voice", ""));
if (isPop)
{
int siteId = int.Parse(System.Configuration.ConfigurationManager.AppSettings["SiteId"]);
DataTable dt = CRBIYYBBReportProjectRule.Intance().GetWarnFaultPop(siteId);
List <WarnFaultPopViewModel> list = CRBICommonLib.ModelConvertHelper <WarnFaultPopViewModel> .ConvertToModel(dt);
if (list.Count <= 0)
{
result.Status = true;
result.Obj = null;
return(result);
}
try
{
using (var httpClient = new HttpClient())
{
var url = new Uri(System.Configuration.ConfigurationManager.AppSettings["Knowledge"]);
var response = httpClient.GetAsync(url + "/GetExpertKnowledge?val=" + list[0].EventName + "&pageNo=1&pageSize=1&strOrder=CreateTime%20DESC&equipmentCategory=-1&keyWord=").Result;
var data = response.Content.ReadAsStringAsync().Result;
data = "{ExpertKnowledgeViewModel:" + data.Substring(0, data.LastIndexOf(']') + 1).Substring(data.IndexOf('[')) + "}";
data = data.Replace(@"\", "");
var model = JsonConvert.DeserializeObjectAsync <ExpertKnowledgesViewModel>(data).Result;
if (model.ExpertKnowledgeViewModel.Count > 0)
{
list[0].ExpertAdvice = model.ExpertKnowledgeViewModel[0].Solution ?? "";
}
}
}
catch
{
list[0].ExpertAdvice = "";
}
result.Status = true;
result.Obj = list[0];
if (isVoice)
{
result.Obj.IsVoice = true;
}
}
else
{
result.Status = true;
result.Obj = null;
}
}
catch (Exception ex)
{
result.Status = false;
result.Message = ex.Message;
}
return(result);
}
public ApiResultViewModel <List <Y_WarnFaultViewModels> > Get()
{
ApiResultViewModel <List <Y_WarnFaultViewModels> > result = new ApiResultViewModel <List <Y_WarnFaultViewModels> >();
try
{
string filePath = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "Setting.ini");
IniFile ini = new IniFile(filePath);
var isChecked = bool.Parse(ini.ReadString("PollingBroadcast", "Checked", ""));
if (isChecked)
{
int siteId = int.Parse(System.Configuration.ConfigurationManager.AppSettings["SiteId"]);
DataTable dt = CRBIYYBBReportProjectRule.Intance().GetY_WarnFault(siteId);
List <Y_WarnFaultViewModels> list = CRBICommonLib.ModelConvertHelper <Y_WarnFaultViewModels> .ConvertToModel(dt);
//string existItem = ini.ReadString("PollingBroadcast", "ExistItem", "");
//if (!string.IsNullOrEmpty(existItem))
//{
// List<string> existItems = existItem.Split(',').ToList();
// list = list.Where(m => !existItem.Contains(m.ID.ToString())).ToList();
//}
if (list.Count <= 0)
{
result.Status = false;
return(result);
}
foreach (var item in list)
{
//string strTemp = ini.ReadString("PollingBroadcast", "ExistItem", "");
//ini.WriteString("PollingBroadcast", "ExistItem", (strTemp == "" ? "" : (strTemp + ",")) + item.ID.ToString());
try
{
using (var httpClient = new HttpClient())
{
var url = new Uri(System.Configuration.ConfigurationManager.AppSettings["Knowledge"]);
var response = httpClient.GetAsync(url + "/GetExpertKnowledge?val=" + item.EventName + "&pageNo=1&pageSize=1&strOrder=CreateTime%20DESC&equipmentCategory=-1&keyWord=").Result;
var data = response.Content.ReadAsStringAsync().Result;
data = "{ExpertKnowledgeViewModel:" + data.Substring(0, data.LastIndexOf(']') + 1).Substring(data.IndexOf('[')) + "}";
data = data.Replace(@"\", "");
var model = JsonConvert.DeserializeObjectAsync <ExpertKnowledgesViewModel>(data).Result;
if (model.ExpertKnowledgeViewModel.Count > 0)
{
item.ExpertAdvice = model.ExpertKnowledgeViewModel[0].Solution ?? "";
}
}
}
catch
{
item.ExpertAdvice = "";
}
}
result.Status = true;
result.Obj = list;
}
else
{
result.Status = false;
//result.Message = "";
return(result);
}
}
catch (Exception ex)
{
result.Status = false;
result.Message = ex.Message;
}
return(result);
}
public JsonResult GetMonthCurve()
{
var json = new JsonResults();
var rm = new ResultModel();
try
{
int siteId = int.Parse(System.Configuration.ConfigurationManager.AppSettings["SiteId"]);
string firstday = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1).ToShortDateString();
string lastday = DateTime.Parse(firstday).AddMonths(1).AddDays(-1).ToShortDateString();
DataTable dt = CRBIYYBBReportProjectRule.Intance().GetMonthCurve(siteId, firstday, lastday);
List <MonthCurveViewModal> list = CRBICommonLib.ModelConvertHelper <MonthCurveViewModal> .ConvertToModel(dt);
MonthCurveResultModal modal = new MonthCurveResultModal();
modal.WarnTime = GetWarnTime(firstday, lastday);
//modal.EqType = new List<string>();
List <int> eqTypeTemp = new List <int>();
foreach (var eqType in list.Select(m => m.EqType).Distinct().ToList())
{
//modal.EqType.Add(Enum.GetName(typeof(EquipmentTypeEnum), eqType));
eqTypeTemp.Add(eqType);
}
modal.MonthCurveDataModal = new List <MonthCurveDataModal>();
foreach (var eqType in eqTypeTemp)
{
MonthCurveDataModal mcdm = new MonthCurveDataModal();
switch ((EquipmentTypeEnum)eqType)
{
case EquipmentTypeEnum.设备列表:
mcdm = GetMonthCurveDataModal(list, modal, eqType);
modal.MonthCurveDataModal.Add(mcdm);
break;
case EquipmentTypeEnum.ATS:
mcdm = GetMonthCurveDataModal(list, modal, eqType);
modal.MonthCurveDataModal.Add(mcdm);
break;
case EquipmentTypeEnum.交流配电柜:
mcdm = GetMonthCurveDataModal(list, modal, eqType);
modal.MonthCurveDataModal.Add(mcdm);
break;
case EquipmentTypeEnum.直流配电柜:
mcdm = GetMonthCurveDataModal(list, modal, eqType);
modal.MonthCurveDataModal.Add(mcdm);
break;
case EquipmentTypeEnum.交流列头柜:
mcdm = GetMonthCurveDataModal(list, modal, eqType);
modal.MonthCurveDataModal.Add(mcdm);
break;
case EquipmentTypeEnum.直流列头柜:
mcdm = GetMonthCurveDataModal(list, modal, eqType);
modal.MonthCurveDataModal.Add(mcdm);
break;
case EquipmentTypeEnum.UPS蓄电池组:
mcdm = GetMonthCurveDataModal(list, modal, eqType);
modal.MonthCurveDataModal.Add(mcdm);
break;
case EquipmentTypeEnum.开关电源蓄电池组:
mcdm = GetMonthCurveDataModal(list, modal, eqType);
modal.MonthCurveDataModal.Add(mcdm);
break;
case EquipmentTypeEnum.发电机组:
mcdm = GetMonthCurveDataModal(list, modal, eqType);
modal.MonthCurveDataModal.Add(mcdm);
break;
case EquipmentTypeEnum.开关电源:
mcdm = GetMonthCurveDataModal(list, modal, eqType);
modal.MonthCurveDataModal.Add(mcdm);
break;
case EquipmentTypeEnum.高频开关:
mcdm = GetMonthCurveDataModal(list, modal, eqType);
modal.MonthCurveDataModal.Add(mcdm);
break;
case EquipmentTypeEnum.主输出断路器:
mcdm = GetMonthCurveDataModal(list, modal, eqType);
modal.MonthCurveDataModal.Add(mcdm);
break;
case EquipmentTypeEnum.逆变电源:
mcdm = GetMonthCurveDataModal(list, modal, eqType);
modal.MonthCurveDataModal.Add(mcdm);
break;
case EquipmentTypeEnum.AS03:
mcdm = GetMonthCurveDataModal(list, modal, eqType);
modal.MonthCurveDataModal.Add(mcdm);
break;
case EquipmentTypeEnum.AS05:
mcdm = GetMonthCurveDataModal(list, modal, eqType);
modal.MonthCurveDataModal.Add(mcdm);
break;
case EquipmentTypeEnum.UPS设备:
mcdm = GetMonthCurveDataModal(list, modal, eqType);
modal.MonthCurveDataModal.Add(mcdm);
break;
case EquipmentTypeEnum.其它:
mcdm = GetMonthCurveDataModal(list, modal, eqType);
modal.MonthCurveDataModal.Add(mcdm);
break;
case EquipmentTypeEnum.接地电阻:
mcdm = GetMonthCurveDataModal(list, modal, eqType);
modal.MonthCurveDataModal.Add(mcdm);
break;
default:
break;
}
}
rm.Result = modal;
rm.Status = true;
}
catch (Exception ex)
{
rm.Message = ex.Message;
rm.Status = false;
}
json.Data = rm;
return(json);
}
