/// <summary> /// 预占资产 /// </summary> /// <returns></returns> public ActionResult PreholdAsset() { string dbpath = HttpContext.Server.MapPath("~/App_Data/DB/demo.db"); string orderNo = Request.QueryString["OrderNo"]; string cabinetNo = Request.QueryString["CabinetNo"]; string layerCount = Request.QueryString["CabinetLayer"]; SqliteHelper.BLL.Cabinet cabintbll = new SqliteHelper.BLL.Cabinet(dbpath); SqliteHelper.BLL.Asset assetbll = new SqliteHelper.BLL.Asset(dbpath); //获取待预占的资产 var assetModel = assetbll.GetModel(int.Parse(orderNo)); var assetListOfCabinet = assetbll.GetModelList(string.Format("CabinetNo='{0}' and State in ('1','2')", cabinetNo)); assetModel.State = "1"; assetModel.StartLayer = int.Parse(layerCount); assetbll.Update(assetModel); //预占完了之后,插入一条changelog SqliteHelper.BLL.ChangeLog changelogBll = new SqliteHelper.BLL.ChangeLog(dbpath); var model = new SqliteHelper.Model.ChangeLog(); model.AssetNo = assetModel.OrderNo; model.CabinetNo = 1; model.CreateTime = DateTime.Now; model.OperationDetail = string.Format("{0},{1}预占到第{2}U", assetModel.Type, assetModel.BM, layerCount); model.OperationType = "1"; changelogBll.Add(model); return(Content("1")); }
/// <summary> /// 获取资产的类型 /// </summary> /// <returns></returns> public ActionResult GetAssetType() { string dbpath = HttpContext.Server.MapPath("~/App_Data/DB/demo.db"); var resultList = new List <ChartItem>(); SqliteHelper.BLL.Asset assetbll = new SqliteHelper.BLL.Asset(dbpath); var modellist = assetbll.GetModelList("CabinetNo='1' and State in ('1','2')"); var typeList = modellist.Select(m => m.Type).Distinct(); foreach (var type in typeList) { var deviceOfType = modellist.FindAll(m => m.Type == type); if (deviceOfType != null && deviceOfType.Count > 0) { resultList.Add(new ChartItem() { ItemText = type, ItemValue = deviceOfType.Count }); } } JsonResult js = new JsonResult() { JsonRequestBehavior = JsonRequestBehavior.AllowGet }; js.Data = resultList; return(js); }
/// <summary> /// 获取资产盘点列表 /// </summary> /// <returns></returns> public ActionResult GetAssetInventory() { string dbpath = HttpContext.Server.MapPath("~/App_Data/DB/demo.db"); int page = 1; //页码 int rows = 10; //每页显示行数 //获取分页信息 if (Request.QueryString["offset"] != null) { page = Convert.ToInt32(Request.QueryString["offset"].ToString()); } if (Request.QueryString["pageSize"] != null) { rows = Convert.ToInt32(Request.QueryString["pageSize"].ToString()); } if (rows > 0) { page = page / rows + 1; } SqliteHelper.BLL.Asset bll = new SqliteHelper.BLL.Asset(dbpath); List <SqliteHelper.Model.Asset> list = new List <SqliteHelper.Model.Asset>(); list = bll.GetModelList("state ='2' and cabinetNo='1'"); SqliteHelper.BLL.RealTimeData realDataBll = new SqliteHelper.BLL.RealTimeData(dbpath); var realTimeData = realDataBll.GetModelList(string.Format("cabinetNo='1'")); foreach (var asset in list) { var realList = realTimeData.Find(m => m.RFID == asset.RfidId && m.LayerIndex == asset.StartLayer); if (realList != null) { asset.CabinetState = "盘点到"; } else { asset.CabinetState = "未盘点到"; } } List <SqliteHelper.Model.Asset> listPage; JsonResult js = new JsonResult(); if (list == null || list.Count == 0) { list = new List <SqliteHelper.Model.Asset>(); js = Json(new { total = list.Count, rows = list }, JsonRequestBehavior.AllowGet); return(js); } //分页操作 没有进行排序,使用的默认排序 listPage = list.Skip((page - 1) * rows).Take(rows).ToList(); try { js = Json(new { total = list.Count, rows = listPage }, JsonRequestBehavior.AllowGet); } catch (Exception ex) { throw new Exception(ex.Message, ex); } return(js); }
/// <summary> /// 获取机柜内的资产列表 /// </summary> /// <returns></returns> public ActionResult GetAssetInfo() { string dbpath = HttpContext.Server.MapPath("~/App_Data/DB/demo.db"); string cabinetNo = Request.QueryString["CabinetNo"]; SqliteHelper.BLL.Asset assetbll = new SqliteHelper.BLL.Asset(dbpath); var assetList = assetbll.GetModelList(string.Format("CabinetNo='{0}' and State in ('1','2')", cabinetNo)); JsonResult js = Json(assetList, JsonRequestBehavior.AllowGet); return(js); }
/// <summary> /// 获取定位资产 /// </summary> /// <returns></returns> public ActionResult GetAssetLocation() { string dbpath = HttpContext.Server.MapPath("~/App_Data/DB/demo.db"); int page = 1; //页码 int rows = 10; //每页显示行数 //获取分页信息 if (Request.QueryString["offset"] != null) { page = Convert.ToInt32(Request.QueryString["offset"].ToString()); } if (Request.QueryString["pageSize"] != null) { rows = Convert.ToInt32(Request.QueryString["pageSize"].ToString()); } if (rows > 0) { page = page / rows + 1; } SqliteHelper.BLL.Asset bll = new SqliteHelper.BLL.Asset(dbpath); List <SqliteHelper.Model.Asset> list = new List <SqliteHelper.Model.Asset>(); list = bll.GetModelList("state in ('1','2') and cabinetNo='1'"); List <SqliteHelper.Model.Asset> listPage; JsonResult js = new JsonResult(); if (list == null || list.Count == 0) { list = new List <SqliteHelper.Model.Asset>(); js = Json(new { total = list.Count, rows = list }, JsonRequestBehavior.AllowGet); return(js); } //分页操作 没有进行排序,使用的默认排序 listPage = list.Skip((page - 1) * rows).Take(rows).ToList(); try { js = Json(new { total = list.Count, rows = listPage }, JsonRequestBehavior.AllowGet); } catch (Exception ex) { throw new Exception(ex.Message, ex); } return(js); }
/// <summary> /// 获取可用层位 /// </summary> /// <returns></returns> public ActionResult GetUsefulLayer() { string dbpath = HttpContext.Server.MapPath("~/App_Data/DB/demo.db"); string cabinetNo = Request.QueryString["CabinetNo"]; //首先查询对应机柜内的资产情况,已经放了资产的,不能继续存放 SqliteHelper.BLL.Cabinet cabintbll = new SqliteHelper.BLL.Cabinet(dbpath); SqliteHelper.BLL.Asset assetbll = new SqliteHelper.BLL.Asset(dbpath); var assetListOfCabinet = assetbll.GetModelList(string.Format("CabinetNo='{0}' and State in ('1','2')", cabinetNo)); Dictionary <int, bool> cabinetLayerStateDic = new Dictionary <int, bool>(); //先初始化cabinetLayerStateDic for (int i = 0; i < 42; i++) { cabinetLayerStateDic[i] = false; } foreach (var asset in assetListOfCabinet) { var layEnd = (int)asset.StartLayer + (int)asset.UsedLayer - 1; for (int i = ((int)asset.StartLayer); i <= layEnd; i++) { cabinetLayerStateDic[i - 1] = true; } } List <int> resultLayer = new List <int>(); foreach (var key in cabinetLayerStateDic.Keys) { if (!cabinetLayerStateDic[key]) { resultLayer.Add(key + 1); } } JsonResult js = Json(resultLayer, JsonRequestBehavior.AllowGet); return(js); }
/// <summary> /// 获取机柜内的资产列表 /// </summary> /// <returns></returns> public ActionResult GetCabinetAssetInfo() { //if ((DateTime.Now - lastDatetime).TotalSeconds < 2) //{ // return Content("-1"); //} //lastDatetime = DateTime.Now; string dbpath = HttpContext.Server.MapPath("~/App_Data/DB/demo.db"); NLog.LogManager.GetCurrentClassLogger().Debug(dbpath); string cabinetNo = Request.QueryString["CabinetNo"]; SqliteHelper.BLL.Asset assetbll = new SqliteHelper.BLL.Asset(dbpath); var assetList = assetbll.GetModelList(string.Format("CabinetNo='{0}' and State in ('1','2')", cabinetNo)); var assetAll = assetbll.GetModelList("1=1"); SqliteHelper.BLL.RealTimeData realDataBll = new SqliteHelper.BLL.RealTimeData(dbpath); var realTimeData = realDataBll.GetModelList(string.Format("cabinetNo='1'")); foreach (var asset in assetList) { //遍历每个资产,判断资产状态 if (asset.State == "1") { var list = realTimeData.Find(m => m.RFID == asset.RfidId && m.LayerIndex == asset.StartLayer); if (list == null) { //如果资产是已预占,且没有检测到信息 asset.CabinetState = "预占"; } else { //如果资产是已预占,检测到信息 asset.CabinetState = "在架"; //预占的资产,如果上架了,自动变为已上架 asset.State = "2"; assetbll.Update(asset); //上架成功后,插入一条上架ChangeLog var dtime = DateTime.Now; SqliteHelper.BLL.ChangeLog changelogBll = new SqliteHelper.BLL.ChangeLog(dbpath); var model = new SqliteHelper.Model.ChangeLog(); model.AssetNo = asset.OrderNo; model.CabinetNo = 1; model.CreateTime = dtime; model.OperationDetail = string.Format("{0},{1}上架到第{2}U", asset.Type, asset.BM, asset.StartLayer); model.OperationType = "2"; var datalist = changelogBll.GetModelList(string.Format("CreateTime>='{0}' and CreateTime<'{1}' and cabinetNo='1' and AssetNo='{2}' and OperationType='2'", dtime.AddSeconds(-1).ToString("yyyy-MM-dd HH:mm:ss"), dtime.AddSeconds(1).ToString("yyyy-MM-dd HH:mm:ss"), model.AssetNo)); if (datalist.Count == 0) { changelogBll.Add(model); } } } else if (asset.State == "2") { var list = realTimeData.Find(m => m.RFID == asset.RfidId && m.LayerIndex == asset.StartLayer); if (list == null) { //如果资产是已预占,且没有检测到信息 asset.CabinetState = "遗失"; } else { //如果资产是已预占,检测到信息 asset.CabinetState = "在架"; } } } foreach (var realItem in realTimeData) { var asset = assetList.Find(m => m.StartLayer == realItem.LayerIndex); //如果当前层位没有资产, if (asset == null) { var otherAsset = assetAll.Find(m => m.RfidId == realItem.RFID); otherAsset.CabinetState = "非法"; otherAsset.StartLayer = realItem.LayerIndex; assetList.Add(otherAsset); } else { if (asset.RfidId != realItem.RFID) { assetList.Remove(asset);//移除机柜内该层位的资产,显示非法的资产优先级高 var otherAsset = assetAll.Find(m => m.RfidId == realItem.RFID); otherAsset.CabinetState = "非法"; otherAsset.StartLayer = realItem.LayerIndex; assetList.Add(otherAsset); } } } //从RealData中获取 JsonResult js = Json(assetList, 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); }