/// <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"));
}