public IQueryable <RemindRegister> PostQueryList(RemindRegisterCondition condition)
{
//从多少页开始取数据
var skipSize = condition.PageSize * (condition.PageIndex - 1);
var list = db.RemindRegister;
IQueryable <RemindRegister> result = list.Where(c => true);
if (!string.IsNullOrEmpty(condition.Name))
{
result = result.Where(c => c.Name == condition.Name);
}
if (!string.IsNullOrEmpty(condition.Code))
{
result = result.Where(c => c.Code == condition.Code);
}
if (!string.IsNullOrEmpty(condition.ModuleCode))
{
result = result.Where(c => c.ModuleCode == condition.ModuleCode);
}
if (!string.IsNullOrEmpty(condition.ModuleName))
{
result = result.Where(c => c.ModuleName == condition.ModuleName);
}
result = result.OrderBy(c => c.Sequence)
.Skip(skipSize)
.Take(condition.PageSize);
return(result);
}
public IHttpActionResult Delete(RemindRegisterCondition entity)
{
var sql = string.Format("DELETE FROM [dbo].[RemindRegister] WHERE ID IN({0})", entity.Ids);
var result = db.Database.ExecuteSqlCommand(sql);
return(Ok(result));
}
