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