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()); }
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)); }
// Navega hacia una nueva página cuando haces click en un elemento private void LView_ItemTapped(object sender, ItemTappedEventArgs e) { CustomChart selectedItem = lView.SelectedItem as CustomChart; selectedItem.ChartPage.NavigationPage = _master.GetNavigationPage; _master.GetNavigationPage.PushAsync(selectedItem.ChartPage); }
public object GetTopUseItem(string duration) { try { if (Session["CompanyId"] == null) { return(new { Error = "You sessin has expired" }); } int companyId = int.Parse(Session["CompanyId"].ToString()); var reportList = new List <StockHistory>(); var inventoryList = _db.Inventories.Where(m => m.CompanyId == companyId); var chartObjList = new List <CustomChart>(); foreach (var useItem in inventoryList) { if (duration == "month") { var monthDate = DateTime.Now.Month; reportList = _db.StockHistories.OrderByDescending(m => m.Quantity).Where(m => m.DateCreated.Month == monthDate && m.CompanyId == companyId && m.InventoryId == useItem.InventoryId).ToList(); } else if (duration == "year") { var yearDate = DateTime.Now.Year; reportList = _db.StockHistories.OrderByDescending(m => m.Quantity).Where(m => m.DateCreated.Year == yearDate && m.CompanyId == companyId && m.InventoryId == useItem.InventoryId).ToList(); } else { reportList = _db.StockHistories.OrderByDescending(m => m.Quantity).Where(m => m.CompanyId == companyId && m.InventoryId == useItem.InventoryId).ToList(); } var chartObj = new CustomChart { name = useItem.Stock.Name, z = reportList.Count() }; chartObjList.Add(chartObj); } return(new { ReportList = chartObjList.OrderByDescending(m => m.z).Take(5) }); } catch (Exception ex) { return(new { Error = "An error occurred , Please contact administrator" }); } }
/// <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)); }
public ActionResult DeleteChart(int id) { CustomChart mode = new CustomChart(); mode.id = id; CustomChartService.GetInstance().Remove(mode); return(Content("success")); }
public CustomChartView(CustomChart chart, CustomNavigationPage navPage) { this.Content = chart.ChartView; this.Title = chart.Name; this._chart = chart; this._navPage = navPage; this._customChartSettingsPage = new CustomChartSettingsPage(_chart, _navPage); InitializeToolbarItems(); }
public object StockByCategoryPie(string duration) { try { if (Session["CompanyId"] == null) { return(new { Error = "You sessin has expired" }); } int companyId = int.Parse(Session["CompanyId"].ToString()); var customPgharmList = new List <CustomChart>(); foreach (var categoryObj in _db.Categories) { var stockList = new List <Stock>(); if (duration == "month") { var monthDate = DateTime.Now.Month; stockList = _db.Stocks.Where(m => m.DateCreated.Month == monthDate && m.CompanyId == companyId && m.CategoryId == categoryObj.CategoryId).ToList(); } else if (duration == "year") { var yearDate = DateTime.Now.Year; stockList = _db.Stocks.Where(m => m.DateCreated.Year == yearDate && m.CompanyId == companyId && m.CategoryId == categoryObj.CategoryId).ToList(); } else { stockList = _db.Stocks.Where(m => m.CompanyId == companyId && m.CategoryId == categoryObj.CategoryId).ToList(); } var customStd1 = new CustomChart(); customStd1.name = categoryObj.Name.ToString(); customStd1.x = stockList.Count(); customPgharmList.Add(customStd1); } var js = new JavaScriptSerializer(); return(new { catJson = js.Serialize(customPgharmList) }); } catch (Exception ex) { return(new { Error = "An error occurred , Please contact administrator" }); } }
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 CustomChartSettingsPage(CustomChart myChart, CustomNavigationPage navBar) { this.Title = "Chart Settings"; _navPage = navBar; _customChart = myChart; Xamarin.Forms.PlatformConfiguration.AndroidSpecific.TabbedPage.SetToolbarPlacement(this, Xamarin.Forms.PlatformConfiguration.AndroidSpecific.ToolbarPlacement.Top); Xamarin.Forms.PlatformConfiguration.AndroidSpecific.TabbedPage.SetIsSwipePagingEnabled(this, false); BuildView(); }
/// <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(','); } } }
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)); }
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 Preview(CustomChart customReport) { string ret = ""; CustomChart crt = new CustomChart(); if (customReport != null) { crt = customReport; } ret = GetCustomReport(crt); return(Content(ret)); }
public ActionResult CustomChartPage2() { int id = int.Parse(Session["customID"].ToString()); ViewData["cid"] = id; CustomChart cc = CustomChartService.GetInstance().Get(new CustomChart() { id = id }); ViewData["gid"] = cc.groupId; ViewData["customChart"] = cc; FillYearsList(); return(View("CustomChartPage")); }
/// <summary> /// Восстановить сохранненые значения. /// </summary> public void RestoreSettings(CustomChart chart) { chart.ClipGauges = ClipGauges; chart.Depth = Depth; chart.ExplodedSliceAmount = ExplodedSliceAmount; chart.DefaultSeries.GaugeType = GaugeType; chart.PaletteName = PaletteName; chart.PieLabelMode = PieLabelMode; chart.DefaultSeries.Type = SeriesType; chart.ShadingEffectMode = ShadingEffectMode; chart.DefaultSeries.Line.Width = GraphLineWidth; chart.Use3D = Use3D; ChartArea.RestoreSettings(chart.ChartArea); Background.RestoreSettings(chart.Background); DefaultElement.RestoreSettings(chart.ChartArea.DefaultElement); }
public object StockByCategoryPie(string type) { try { var customPgharmList = new List <CustomChart>(); foreach (var categoryObj in _db.Categories) { var pharmacies = new List <Stock>(); //if (type == "1") //{ // pharmacies = _db.Tickets.Where(m => m.Status == (int)status).ToList(); //} //else if (type == "2") //{ // pharmacies = _db.Tickets.Where(m => m.Status == (int)status).ToList(); //} //else if (type == "3") //{ // pharmacies = _db.Tickets.Where(m => m.Status == (int)status).ToList(); //} //else //{ pharmacies = _db.Stocks.Where(m => m.CategoryId == categoryObj.CategoryId).ToList(); // } var customStd1 = new CustomChart(); customStd1.name = categoryObj.Name.ToString(); customStd1.x = pharmacies.Count(); customPgharmList.Add(customStd1); } var js = new JavaScriptSerializer(); return(new { catJson = js.Serialize(customPgharmList) }); } catch (Exception ex) { return(new { Error = "An error occurred , Please contact administrator" }); } }
public ChartSettingsWrapper(CustomChart chart) { ClipGauges = chart.ClipGauges; Depth = chart.Depth; ExplodedSliceAmount = chart.ExplodedSliceAmount; GaugeType = chart.DefaultSeries.GaugeType; PaletteName = chart.PaletteName; PieLabelMode = chart.PieLabelMode; SeriesType = (SeriesType)chart.DefaultSeries.Type; ShadingEffectMode = chart.ShadingEffectMode; GraphLineWidth = chart.DefaultSeries.Line.Width; Use3D = chart.Use3D; ChartArea = new ChartAreaSettingsWrapper(chart.ChartArea); Background = new BackgroundSettingsWrapper(chart.Background); DefaultElement = new DefaultElementSettingsWrapper(chart.ChartArea.DefaultElement); }
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)); }
/// <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)); }
/// <summary> /// Permet eliminar un chart /// </summary> /// <param name="chart">CustomChart que es vol eliminar</param> public void Remove(CustomChart chart) { try { _customCharts.Remove(chart); } catch (Exception exception) { throw new Exception(exception.Message); } }
/// <summary> /// 修改自定义报表 /// </summary> /// <returns>设备表ID</returns> public CustomChart Get(CustomChart customReport) { return(_CustomReportDao.Get(customReport)); }
/// <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); }
/// <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); }
/// <summary> /// 插入自定义报表 /// </summary> /// <returns>设备表ID</returns> public int Insert(CustomChart customReport) { return(_CustomReportDao.Insert(customReport)); }
/// <summary> /// 插入自定义报表 /// </summary> /// <returns>设备表ID</returns> public int Remove(CustomChart customReport) { return(_CustomReportDao.Remove(customReport)); }
/// <summary> /// 修改自定义报表 /// </summary> /// <returns>设备表ID</returns> public int Update(CustomChart customReport) { return(_CustomReportDao.Update(customReport)); }
public int Add(CustomChart.ChartItem value) { return base.List.Add(value); }
public bool Contains(CustomChart.ChartItem value) { return base.List.Contains(value); }
/// <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); }
public int IndexOf(CustomChart.ChartItem value) { return base.List.IndexOf(value); }
public void Remove(CustomChart.ChartItem value) { base.List.Remove(value); }