public ActionResult GetCabinetModel() { string dbpath = HttpContext.Server.MapPath("~/App_Data/DB/demo.db"); SqliteHelper.BLL.Cabinet cabintbll = new SqliteHelper.BLL.Cabinet(dbpath); var cabinetModel = cabintbll.GetModel(1); JsonResult js = new JsonResult(); js = Json(cabinetModel, JsonRequestBehavior.AllowGet); return(js); }
/// <summary> /// 获取机柜的容量信息 /// </summary> /// <returns></returns> public ActionResult GetCapacityInfo() { CapacityInfo capacityInfo = new CapacityInfo(); JsonResult js = new JsonResult(); string dbpath = HttpContext.Server.MapPath("~/App_Data/DB/demo.db"); SqliteHelper.BLL.Cabinet cabintbll = new SqliteHelper.BLL.Cabinet(dbpath); var cabinetModel = cabintbll.GetModel(1); SqliteHelper.BLL.Asset assetbll = new SqliteHelper.BLL.Asset(dbpath); var assetList = assetbll.GetModelList(string.Format("cabinetNo=1 and state in ('1','2')")); //层位 var usedLayer = assetList.Sum(m => m.UsedLayer); double doubleRate = 100 * usedLayer.Value / cabinetModel.Space.Value; capacityInfo.progress1Content = string.Format("{0}% ({1}/{2})", Math.Round(doubleRate, 2), usedLayer, cabinetModel.Space); capacityInfo.progress1 = string.Format("{0}%", Math.Round(doubleRate, 2)); if (doubleRate < 30) { capacityInfo.ColorStyle1 = "progress-bar progress-bar-success progress-bar-striped"; } else if (doubleRate < 60) { capacityInfo.ColorStyle1 = "progress-bar progress-bar-info progress-bar-striped"; } else if (doubleRate < 90) { capacityInfo.ColorStyle1 = "progress-bar progress-bar-warning progress-bar-striped"; } else { capacityInfo.ColorStyle1 = "progress-bar progress-bar-danger progress-bar-striped"; } //电力 var usedPower = assetList.Sum(m => m.UsedPower); doubleRate = Convert.ToDouble(100 * usedPower.Value / cabinetModel.Power.Value); capacityInfo.progress2Content = string.Format("{0}% ({1}/{2})", Math.Round(doubleRate, 2), usedPower, cabinetModel.Power); capacityInfo.progress2 = string.Format("{0}%", Math.Round(doubleRate, 2)); if (doubleRate < 30) { capacityInfo.ColorStyle2 = "progress-bar progress-bar-success progress-bar-striped"; } else if (doubleRate < 60) { capacityInfo.ColorStyle2 = "progress-bar progress-bar-info progress-bar-striped"; } else if (doubleRate < 90) { capacityInfo.ColorStyle2 = "progress-bar progress-bar-warning progress-bar-striped"; } else { capacityInfo.ColorStyle2 = "progress-bar progress-bar-danger progress-bar-striped"; } //承重 var usedWeight = assetList.Sum(m => m.UsedWeight); doubleRate = Convert.ToDouble(100 * usedWeight.Value / cabinetModel.Weight.Value); capacityInfo.progress3Content = string.Format("{0}% ({1}/{2})", Math.Round(doubleRate, 2), usedWeight, cabinetModel.Weight); capacityInfo.progress3 = string.Format("{0}%", Math.Round(doubleRate, 2)); if (doubleRate < 30) { capacityInfo.ColorStyle3 = "progress-bar progress-bar-success progress-bar-striped"; } else if (doubleRate < 60) { capacityInfo.ColorStyle3 = "progress-bar progress-bar-info progress-bar-striped"; } else if (doubleRate < 90) { capacityInfo.ColorStyle3 = "progress-bar progress-bar-warning progress-bar-striped"; } else { capacityInfo.ColorStyle3 = "progress-bar progress-bar-danger progress-bar-striped"; } //电口 var usedPowerPort = assetList.Sum(m => m.UsedPowerPort); doubleRate = Convert.ToDouble(100 * usedPowerPort.Value / cabinetModel.PowerPort.Value); capacityInfo.progress4Content = string.Format("{0}% ({1}/{2})", Math.Round(doubleRate, 2), usedPowerPort, cabinetModel.PowerPort); capacityInfo.progress4 = string.Format("{0}%", Math.Round(doubleRate, 2)); if (doubleRate < 30) { capacityInfo.ColorStyle4 = "progress-bar progress-bar-success progress-bar-striped"; } else if (doubleRate < 60) { capacityInfo.ColorStyle4 = "progress-bar progress-bar-info progress-bar-striped"; } else if (doubleRate < 90) { capacityInfo.ColorStyle4 = "progress-bar progress-bar-warning progress-bar-striped"; } else { capacityInfo.ColorStyle4 = "progress-bar progress-bar-danger progress-bar-striped"; } //网口 var usedNetPort = assetList.Sum(m => m.UsedNetPort); doubleRate = Convert.ToDouble(100 * usedNetPort.Value / cabinetModel.NetPort.Value); capacityInfo.progress5Content = string.Format("{0}% ({1}/{2})", Math.Round(doubleRate, 2), usedNetPort, cabinetModel.NetPort); capacityInfo.progress5 = string.Format("{0}%", Math.Round(doubleRate, 2)); if (doubleRate < 30) { capacityInfo.ColorStyle5 = "progress-bar progress-bar-success progress-bar-striped"; } else if (doubleRate < 60) { capacityInfo.ColorStyle5 = "progress-bar progress-bar-info progress-bar-striped"; } else if (doubleRate < 90) { capacityInfo.ColorStyle5 = "progress-bar progress-bar-warning progress-bar-striped"; } else { capacityInfo.ColorStyle5 = "progress-bar progress-bar-danger progress-bar-striped"; } js = Json(capacityInfo, JsonRequestBehavior.AllowGet); return(js); }