public void DeleteMaterial(List<int> ids)
{
using (var dbContext = new BasedataDbContext())
{
dbContext.Materials.Where(u => ids.Contains(u.ID)).Delete();
}
}
public Material GetMaterial(int id)
{
using (var dbContext = new BasedataDbContext())
{
return dbContext.Find<Material>(id);
}
}
public IEnumerable<Material> GetMaterialList(MaterialRequest request = null)
{
request = request ?? new MaterialRequest();
using (var dbContext = new BasedataDbContext())
{
IQueryable<Material> materials = dbContext.Materials;
if (!string.IsNullOrEmpty(request.MaterialName))
materials = materials.Where(u => u.MaterialName.Contains(request.MaterialName));
return materials.OrderByDescending(u => u.ID).ToPagedList(request.PageIndex, request.PageSize);
}
}
public void SaveMaterial(Material material)
{
using (var dbContext = new BasedataDbContext())
{
if (material.ID > 0)
{
dbContext.Update<Material>(material);
}
else
{
dbContext.Insert<Material>(material);
}
}
}