public ActionResult Information(tongs_entityRequest request)//信息查询
{
request.Workcell = LoginInfo.Workcell;
var result = this.ToolManageService.Gettongs_entityList(request);
return(View(result));
}
public IEnumerable <tongs_entity> Gettongs_entityList(tongs_entityRequest request = null)
{
request = request ?? new tongs_entityRequest();
using (var dbContext = new ToolManageDbContext())
{
IQueryable <tongs_entity> tongs_entitys = dbContext.tongs_entitys;
if (request != null)
{
if (!string.IsNullOrEmpty(request.Code))
{
tongs_entitys = tongs_entitys.Where(u => u.Code.Contains(request.Code));
}
if (request.SeqID != 0)
{
tongs_entitys = tongs_entitys.Where(u => u.SeqID == request.SeqID);
}
if (!string.IsNullOrEmpty(request.State))
{
tongs_entitys = tongs_entitys.Where(u => u.State.Contains(request.State));
}
if (request.Workcell != 0)
{
tongs_entitys = tongs_entitys.Where(u => u.Workcell == request.Workcell);
}
}
return(tongs_entitys.OrderByDescending(u => u.ID).ToPagedList(request.PageIndex, request.PageSize));
}
}
public ActionResult In(tongs_entityRequest request)//入库管理
{
var result = this.ToolManageService.Gettongs_entityList(request);
return(View(result));
}
