/// <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 OffLineAsset() { string dbpath = HttpContext.Server.MapPath("~/App_Data/DB/demo.db"); string orderNo = Request.QueryString["OrderNo"]; SqliteHelper.BLL.Asset assetbll = new SqliteHelper.BLL.Asset(dbpath); //获取待预占的资产 var assetModel = assetbll.GetModel(int.Parse(orderNo)); assetModel.State = "0"; 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, assetModel.StartLayer); model.OperationType = "3"; changelogBll.Add(model); return(Content("1")); }