/// <summary> /// 添加设备 /// </summary> /// <param name="entity"></param> /// <returns></returns> public int AddEquipment(EquipmentEntity entity) { entity.IsDelete = (int)EIsDelete.NotDelete; entity.CreateTime = DateTime.Now; entity.IncludeAll(); int line = this.Equipment.Add(entity); if (line > 0) { CacheHelper.Remove(CacheKey.JOOSHOW_EQUIPMENT_CACHE); } return line; }
/// <summary> /// 删除 /// </summary> /// <param name="snNum"></param> /// <returns></returns> public int Delete(string snNum) { EquipmentEntity entity = new EquipmentEntity(); entity.IsDelete = (int)EIsDelete.Deleted; entity.IncludeIsDelete(true); entity.Where(a => a.SnNum == snNum); int line = this.Equipment.Update(entity); if (line > 0) { CacheHelper.Remove(CacheKey.JOOSHOW_EQUIPMENT_CACHE); } return line; }
public static Equipment_CE ToCE(EquipmentEntity item) { Equipment_CE target = new Equipment_CE(); target.ID=item.ID; target.SnNum=item.SnNum; target.EquipmentName=item.EquipmentName; target.EquipmentNum=item.EquipmentNum; target.IsImpower=item.IsImpower; target.Flag=item.Flag; target.IsDelete=item.IsDelete; target.Status=item.Status; target.CreateUser=item.CreateUser; target.CreateTime=item.CreateTime; target.Remark=item.Remark; return target; }
/// <summary> /// 修改 /// </summary> /// <param name="entity"></param> /// <returns></returns> public int Update(EquipmentEntity entity) { entity.Include(a => new { a.SnNum, a.EquipmentName, a.IsImpower, a.Flag, a.IsDelete, a.Remark,a.Status }); entity.Where(a => a.SnNum == entity.SnNum); int line = this.Equipment.Update(entity); if (line > 0) { CacheHelper.Remove(CacheKey.JOOSHOW_EQUIPMENT_CACHE); } return line; }
/// <summary> /// 分页查询设备信息 /// </summary> /// <param name="entity"></param> /// <param name="pageInfo"></param> /// <returns></returns> public List<EquipmentEntity> GetList(EquipmentEntity entity, ref PageInfo pageInfo) { entity.IncludeAll(); entity.OrderBy(a => a.ID, EOrderBy.DESC); entity.Where(a => a.IsDelete == (int)EIsDelete.NotDelete); int rowCount = 0; List<EquipmentEntity> listResult = this.Equipment.GetList(entity, pageInfo.PageSize, pageInfo.PageIndex, out rowCount); pageInfo.RowCount = rowCount; return listResult; }
/// <summary> /// 获得所有设备信息 /// </summary> /// <returns></returns> public List<EquipmentEntity> GetList() { List<EquipmentEntity> listResult = CacheHelper.Get(CacheKey.JOOSHOW_EQUIPMENT_CACHE) as List<EquipmentEntity>; if (!listResult.IsNullOrEmpty()) { return listResult; } EquipmentEntity entity = new EquipmentEntity(); entity.IncludeAll(); entity.OrderBy(a => a.ID, EOrderBy.DESC); entity.Where(a => a.IsDelete == (int)EIsDelete.NotDelete); listResult = this.Equipment.GetList(entity); if (!listResult.IsNullOrEmpty()) { CacheHelper.Insert(CacheKey.JOOSHOW_EQUIPMENT_CACHE, listResult); } return listResult; }
public ActionResult GetEquipmentList() { int pageIndex = WebUtil.GetFormValue<int>("pageIndex", 1); int pageSize = WebUtil.GetFormValue<int>("pageSize", 15); string EquipmentName = WebUtil.GetFormValue<string>("EquipmentName", string.Empty); int Status = WebUtil.GetFormValue<int>("Status", 0); PageInfo pageInfo = new PageInfo() { PageIndex = pageIndex, PageSize = pageSize }; EquipmentProvider provider = new EquipmentProvider(); EquipmentEntity entity = new EquipmentEntity(); if (!EquipmentName.IsEmpty()) { entity.Begin<EquipmentEntity>() .Where<EquipmentEntity>("SnNum", ECondition.Like, "%" + EquipmentName + "%") .Or<EquipmentEntity>("EquipmentName", ECondition.Like, "%" + EquipmentName + "%") .End<EquipmentEntity>(); } if (Status != 0) { entity.Where<EquipmentEntity>(a => a.Status == Status); } List<EquipmentEntity> list = provider.GetList(entity, ref pageInfo); string json = ConvertJson.ListToJson<EquipmentEntity>(list, "List"); this.ReturnJson.AddProperty("Data", new JsonObject(json)); this.ReturnJson.AddProperty("RowCount", list.Count); return Content(this.ReturnJson.ToString()); }