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 void SaveMaterial(Material material)
{
using (var dbContext = new BasedataDbContext())
{
if (material.ID > 0)
{
dbContext.Update <Material>(material);
}
else
{
dbContext.Insert <Material>(material);
}
}
}
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));
}
}
