/// <summary> /// 取得用户的所有配置 /// </summary> /// <returns>设备表ID</returns> public IList<CustomChart> Getlist(int userId, int groupid) { CustomChart CustomChart = new CustomChart(); CustomChart.userId = userId; CustomChart.groupId = groupid; return _CustomReportDao.Getlist(CustomChart); }
/// <summary> /// 生成自定义图表 /// </summary> /// <returns>自定义报表页面</returns> public ActionResult ChartView(int id, string startTime, string endTime) { string report = ""; DateTime dt = DateTime.Now; switch (id) { default:///自定义 CustomChart crt = new CustomChart(); crt.id = id; crt = CustomChartService.GetInstance().Get(crt); crt.startTime = startTime; crt.endTime = endTime; report = GetCustomReport(crt); break; } return Content(report); }
public ActionResult Save(CustomChart customReport, string cid) { int temp = 0; int.TryParse(cid, out temp); customReport.id = temp; customReport.groupId = 0; string ret = Resources.SunResource.CUSTOM_SAVE_SUCCESSFULLY; if (customReport != null) { if (!customReport.customType.Equals("2") && string.IsNullOrEmpty(customReport.product)) { customReport.product = customReport.ProIdType; } } User user = UserUtil.getCurUser(); if (null != user && UserUtil.demousername.Equals(user.username)) { ret = "Sorry,exampleuser prohibit to save"; return Content(ret); } else if (string.IsNullOrEmpty(customReport.reportName)) { ret = Resources.SunResource.CUSTOMREPORT_SAVE_FAILED_NAME; return Content(ret); } else if (customReport.customType.Trim().Equals("2") && string.IsNullOrEmpty(customReport.product)) { ret = Resources.SunResource.CUSTOMREPORT_SAVE_FAILED_EQUIPMENT; return Content(ret); } else if (customReport.customType.Trim().Equals("3") && string.IsNullOrEmpty(customReport.times)) { ret = Resources.SunResource.CUSTOMREPORT_SAVE_FAILED_TIME; return Content(ret); } int flag = 0; try { if (customReport.id <= 0) { flag = CustomChartService.GetInstance().Insert(customReport); } else if (CustomChartService.GetInstance().Get(customReport) != null) { flag = CustomChartService.GetInstance().Update(customReport); } else { flag = CustomChartService.GetInstance().Insert(customReport); } } catch (Exception ee) { ret = "Save failed!" + ee.Message; return Content(ret); } return Content(ret); }
public ActionResult Preview(CustomChart customReport) { string ret = ""; CustomChart crt = new CustomChart(); if (customReport != null) { crt = customReport; } ret = GetCustomReport(crt); return Content(ret); }
public ActionResult modifyDefined(string id) { CustomChart cus = null; if (!string.IsNullOrEmpty(id)) { cus = new CustomChart(); cus.id = int.Parse(id); cus = CustomChartService.GetInstance().Get(cus); } Plant plant = PlantService.GetInstance().GetPlantInfoById(cus.plantId); SetDeviceList(plant); Analysis(ref cus); ViewData["charts"] = CustomChartService.GetInstance().GetListByPlant(cus.plantId); return View("CustomChart", cus); }
public string GetReportTr(CustomChart cr) { StringBuilder sb = new StringBuilder(); sb.Append(" <tr visible=\"false\">"); sb.Append(" <td>"); sb.Append(" <table width=\"100%\" border=\"0\" cellspacing=\"0\">"); sb.Append(" <tr>"); sb.Append(" <td width=\"54%\" height=\"28\" class=\"bp01 pl40\">"); sb.Append(" " + cr.reportName + ""); sb.Append(" <input id=\"hRepor" + cr.id + "\" type=\"hidden\" value=\"" + cr.id + "\" />"); sb.Append(" </td>"); sb.Append(" <td width=\"23%\" align=\"center\" class=\"bp01\">"); sb.Append(" <a href=\"/CustomReport/Defined/" + cr.id + "\" id=\"aReporEdit" + cr.id + "\" >"); sb.Append(" <img src=\"/images/sub/edit.gif\" width=\"14\" height=\"14\" class=\"imga\" /></a>"); sb.Append(" </td>"); sb.Append(" <td align=\"center\" class=\"bp01\">"); sb.Append(" <a href=\"#\" id=\"aReporDel" + cr.id + "\">"); sb.Append(" <img src=\"/images/sub/del.gif\" width=\"14\" height=\"14\" class=\"imga\" /></a>"); sb.Append(" </td>"); sb.Append(" </tr>"); sb.Append(" </table>"); sb.Append(" </td>"); sb.Append(" </tr>"); return sb.ToString(); }
public string GetReporAjax(CustomChart cr) { StringBuilder sb = new StringBuilder(); sb.Append(" $('#aReporDel" + cr.id + "').click(function() {"); sb.Append(" if (confirm(\"确定删除自定义报表'" + cr.reportName + "'?\") == \"0\") {"); sb.Append(" return;"); sb.Append(" } else {"); sb.Append(" $.ajax({"); sb.Append(" type: \"POST\","); sb.Append(" url: \"/CustomReport/DeleteReport\","); //sb.Append(" data: { id: $('#hRepor" + cr.id + "').val() },"); sb.Append(" data: { id: \"" + cr.id + "\"},"); sb.Append(" success: function(result) {"); sb.Append(" $('#divGroup').empty();"); sb.Append(" $('#divGroup').append(result);"); sb.Append(" }"); sb.Append(" });"); sb.Append(" }"); sb.Append(" });"); //sb.Append(" $('#aReporEdit" + cr.id + "').click(function() {"); //sb.Append(" $.ajax({"); //sb.Append(" type: \"POST\","); //sb.Append(" url: \"/CustomReport/EditReport\","); ////sb.Append(" data: { id: $('#hRepor" + cr.id + "').val() },"); //sb.Append(" data: { id:\"" + cr.id + "\"},"); //sb.Append(" success: function(result) {"); ////sb.Append(" $('#divGroup').empty();"); ////sb.Append(" $('#divGroup').append(result);"); //sb.Append(" }"); //sb.Append(" });"); //sb.Append(" });"); return sb.ToString(); }
/// <summary> /// 插入自定义报表 /// </summary> /// <returns>设备表ID</returns> public int Remove(CustomChart customReport) { return _CustomReportDao.Remove(customReport); }
/// <summary> /// 取得自定义图表的数据 /// </summary> /// <param name="crt"></param> /// <returns></returns> private string GetCustomReport(CustomChart crt) { User user = UserUtil.getCurUser(); DateTime dt = CalenderUtil.curDateWithTimeZone(user.timezone); string ret = "sorry:" + Resources.SunResource.NODATA; if (crt != null) { Analysis(ref crt); ///多设备多测点单时间报表 List<DeviceStuct> list = new List<DeviceStuct>(); list = GetDeviceStucts(crt); string reportName = crt.reportName; switch (crt.timeInterval.Trim().ToUpper()) { case "YEAR": //if (crt.timeSlot.Trim().ToUpper().Equals("YEAR")) //{ ChartData chartData = CompareChartService.GetInstance().compareYearsMultiDeviceMultiMonitor(crt.reportName, list, getWorkYears(list)); ret = JsonUtil.convertToJson(chartData, typeof(ChartData)); //} break; case "MONTH": //if (crt.timeSlot.Trim().ToUpper().Equals("YEAR")) //{ //dtstart = dt.AddYears(-crt.tcounter.Value); //} //else if (crt.timeSlot.Trim().ToUpper().Equals("MONTH")) // { //dtstart = dt.AddMonths(-crt.tcounter.Value); //} chartData = CompareChartService.GetInstance().compareYearMMMultiDeviceMultiMonitor(crt.reportName, GetDeviceStucts(crt), crt.startTime, crt.endTime); ret = JsonUtil.convertToJson(chartData, typeof(ChartData)); break; case "DAY": //if (crt.timeSlot.Trim().ToUpper().Equals("DAY")) //{ //dtstart = dt.AddDays(-crt.tcounter.Value); // } //else if (crt.timeSlot.Trim().ToUpper().Equals("MONTH")) //{ //dtstart = dt.AddMonths(-crt.tcounter.Value); // } chartData = CompareChartService.GetInstance().compareMMDDMultiDeviceMultiMonitor(crt.reportName, GetDeviceStucts(crt), crt.startTime, crt.endTime); ret = JsonUtil.convertToJson(chartData, typeof(ChartData)); break; case "HOUR": //if (crt.timeSlot.Trim().ToUpper().Equals("DAY")) //{ // dtstart = dt.AddDays(-crt.tcounter.Value); //} //else if (crt.timeSlot.Trim().ToUpper().Equals("HOUR")) //{ // dtstart = dt.AddHours(-crt.tcounter.Value); //} int intervalMins = 5; chartData = CompareChartService.GetInstance().compareDayHHMultiDeviceMultiMonitor(crt.reportName, GetDeviceStucts(crt), crt.startTime, crt.endTime, intervalMins); ret = JsonUtil.convertToJson(chartData, typeof(ChartData)); break; default: break; } } return ret; }
public ActionResult DeleteChart(int id) { CustomChart mode = new CustomChart(); mode.id = id; CustomChartService.GetInstance().Remove(mode); return Content("success"); }
public ActionResult Delete(int id, string returnUrl) { CustomChart mode = new CustomChart(); UpdateModel(mode, Request.Form.AllKeys); int flag = CustomChartService.GetInstance().Remove(mode); return new RedirectResult(returnUrl); }
public ActionResult DefinedUserChart() { User user = UserUtil.getCurUser(); SetDeviceList(user.plants); SetMI(null); CustomChart cus = new CustomChart(); cus.groupId = 0; cus.userId = user.id; ViewData["charts"] = CustomChartService.GetInstance().GetListByGroup(user.id, 0); return View("CustomChart", cus); }
public ActionResult DefinedPlantChartList(int id, string cid) { int temp = 0; int.TryParse(cid, out temp); Plant plant = PlantService.GetInstance().GetPlantInfoById(id); SetDeviceList(plant); SetMI(null); CustomChart cus = null; if (string.IsNullOrEmpty(cid)) { cus = new CustomChart(); cus.groupId = 0; cus.plantId = plant.id; } else { cus = CustomChartService.GetInstance().Get(new CustomChart() { id = temp }); Analysis(ref cus); } ViewData["charts"] = CustomChartService.GetInstance().GetListByPlant(cus.plantId); return View("CustomChartList", cus); }
/// <summary> /// 修改自定义报表 /// </summary> /// <returns>设备表ID</returns> public CustomChart Get(CustomChart customReport) { return _CustomReportDao.Get(customReport); }
/// <summary> /// 修改自定义报表 /// </summary> /// <returns>设备表ID</returns> public int Update(CustomChart customReport) { return _CustomReportDao.Update(customReport); }
/// <summary> /// 解析 /// </summary> /// <param name="cr"></param> public void TextTo(ref CustomChart customReport) { if (!string.IsNullOrEmpty(customReport.product)) { string[] strText = customReport.product.Split(';'); foreach (string str in strText) { string[] sss = str.Split(','); } } }
/// <summary> /// 15&Plant,Power&valueType,KW&Unit,Max&cVal; /// 解析定义图表规则 /// </summary> /// <param name="cc"></param> private void Analysis(ref CustomChart cc) { if (cc != null && !string.IsNullOrEmpty(cc.product)) { if (cc.customType.Trim().Equals("1")) { string ss = cc.product.Replace(";", string.Empty); string[] ssa = ss.Split(','); foreach (string s in ssa) { string[] ss0 = s.Split('&'); if (ss0.Length == 2) { switch (ss0[1]) { case "cVal": cc.cVal = ss0[0]; break; case "Unit": cc.units = ss0[0]; break; case "valueType": cc.valueType = ss0[0]; break; case "subType": cc.subType = ss0[0]; break; default: cc.productList = s; cc.ProIdType = s; break; } } } SetMI(cc.ProIdType); } else if (cc.customType.Trim().Equals("3")) { if (!string.IsNullOrEmpty(cc.times)) { List<string> slist = new List<string>(); string[] splis = cc.times.Split(';'); foreach (string ss in splis) { if (!string.IsNullOrEmpty(ss)) { slist.Add(ss); } } ViewData["TimesList"] = slist; } } else { if (!string.IsNullOrEmpty(cc.product)) { List<SelectListItem> slist = new List<SelectListItem>(); string[] splis = cc.product.Split(';'); string[] sproductName = cc.productName.Split(';'); for (int i = 0; i < splis.Length; i++) { SelectListItem sel = new SelectListItem(); if (!string.IsNullOrEmpty(splis[i])) { sel.Value = splis[i]; sel.Text = sproductName[i]; slist.Add(sel); } } ViewData["ProductList"] = slist; } } } SetMI(cc.ProIdType); }
public ActionResult DeleteReport(int id) { CustomChart mode = new CustomChart(); mode.id = id; int flag = CustomChartService.GetInstance().Remove(mode); User user = UserUtil.getCurUser(); string ret = GetHtml(user.id); return RedirectToAction("ReportGroup", ret); }
/// <summary> /// 根据自定义图表,构造设备比较结构 /// </summary> /// <param name="crt"></param> /// <returns></returns> private List<DeviceStuct> GetDeviceStucts(CustomChart crt) { List<DeviceStuct> list = new List<DeviceStuct>(); string[] ss = crt.product.Split(';'); foreach (string ssssss in ss) { if (string.IsNullOrEmpty(ssssss)) continue; string[] ssa = ssssss.Split(','); DeviceStuct dev = new DeviceStuct(); dev.chartType = crt.subType; dev.intervalMins = 5; dev.rate = 1F; foreach (string s in ssa) { string[] ss0 = s.Split('&'); if (ss0.Length == 2) { switch (ss0[1]) { case "subType": dev.chartType = ss0[0]; break; case "cVal": dev.cVal = int.Parse(ss0[0]); break; case "Unit": dev.unit = ss0[0]; break; case "valueType": dev.monitorType = MonitorType.getMonitorTypeByCode(int.Parse(ss0[0])); break; case "0":///DeviceData.PLANT_CODE.ToString() dev.deviceType = ChartDeviceType.PLANT; dev.deviceId = ss0[0]; Plant plant = PlantService.GetInstance().GetPlantInfoById(int.Parse(dev.deviceId)); dev.comareObj = plant.name; break; default: dev.deviceType = ChartDeviceType.DEVICE; dev.deviceId = ss0[0]; Device device = DeviceService.GetInstance().get(int.Parse(dev.deviceId)); dev.comareObj = device.fullName; break; } } } if (!(dev.monitorType.code != MonitorType.PLANT_MONITORITEM_ENERGY_CODE && !crt.timeInterval.Equals("Hour"))) { list.Add(dev); } } return list; }
/// <summary> /// 插入自定义报表 /// </summary> /// <returns>设备表ID</returns> public int Insert(CustomChart customReport) { return _CustomReportDao.Insert(customReport); }