/// <summary>
/// 增加
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public async Task <Result <MaterialInfo> > addAsync(MaterialInfo model)
{
Result <MaterialInfo> result = new Result <MaterialInfo>();
MaterialInfoQuery condition = new MaterialInfoQuery()
{
materialName = model.materialName, mat_size = model.mat_size
};
var isExist = dao.searchCountByCondition(condition);
if (isExist > 0)
{
result.addError("产品已存在");
}
else
{
model.findIndx = BeanHelper.getFistCharUpper(model.materialName);
var resultDAO = await dao.add(model);
if (!resultDAO.success)
{
result.addError(resultDAO.message);
}
}
return(result);
}
public JsonResult list(MaterialInfoQuery condition)
{
ViewBag.condition = condition;
Pager <List <MaterialInfo> > pager = new Pager <List <MaterialInfo> >();
pager = service.searchByCondition(pager, condition);
JsonResult result = Json(pager.data);
return(result);
}
public List <MaterialInfo> searchListByCondition(MaterialInfoQuery t)
{
LayerDbContext context = new LayerDbContext();
var result = context.materialInfos.Where(x => x.id > 0);
result = string.IsNullOrEmpty(t.material) ? result : result.Where(x => x.material == (t.material));
result = string.IsNullOrEmpty(t.materialName) ? result : result.Where(x => x.materialName == (t.materialName));
result = string.IsNullOrEmpty(t.mat_color) ? result : result.Where(x => x.mat_color == t.mat_color);
result = string.IsNullOrEmpty(t.mat_size) ? result : result.Where(x => x.mat_size == t.mat_size);
result = string.IsNullOrEmpty(t.mat_type) ? result : result.Where(x => x.mat_type == t.mat_type);
result = string.IsNullOrEmpty(t.alias) ? result : result.Where(x => x.alias == (t.alias));
result = string.IsNullOrEmpty(t.remark) ? result : result.Where(x => x.remark.Contains(t.remark));
return(result.ToList());
}
/// <summary>
/// 根据条件查询
/// </summary>
/// <param name="pager"></param>
/// <param name="t"></param>
/// <returns></returns>
public List <MaterialInfo> searchByCondition(Pager <List <MaterialInfo> > pager, MaterialInfoQuery t)
{
LayerDbContext context = new LayerDbContext();
int start = (pager.page - 1) * pager.recPerPage;
var result = context.materialInfos.Where(x => x.id > 0);
result = string.IsNullOrEmpty(t.material) ? result : result.Where(x => x.material == (t.material));
result = string.IsNullOrEmpty(t.materialName) ? result : result.Where(x => x.materialName == (t.materialName));
result = string.IsNullOrEmpty(t.mat_color) ? result : result.Where(x => x.mat_color == t.mat_color);
result = string.IsNullOrEmpty(t.mat_size) ? result : result.Where(x => x.mat_size == t.mat_size);
result = string.IsNullOrEmpty(t.mat_type) ? result : result.Where(x => x.mat_type == t.mat_type);
result = string.IsNullOrEmpty(t.alias) ? result : result.Where(x => x.alias == (t.alias));
result = string.IsNullOrEmpty(t.remark) ? result : result.Where(x => x.remark.Contains(t.remark));
result = result.OrderBy(x => x.material);
result = result.Skip(start).Take(pager.recPerPage);
return(result.ToList());
}
/// <summary>
/// 根据条件查询
/// </summary>
/// <param name="pager"></param>
/// <param name="condition"></param>
/// <returns></returns>
public Pager <List <MaterialInfo> > searchByCondition(Pager <List <MaterialInfo> > pager, MaterialInfoQuery condition)
{
Task <List <MaterialInfo> > task = Task.Factory.StartNew(() => dao.searchByCondition(pager, condition));
pager.data = task.Result;
Task <int> countTask = Task.Factory.StartNew(() => dao.searchCountByCondition(condition));
pager.recTotal = countTask.Result;
return(pager);
}
public async Task <List <MaterialInfo> > searchListByCondition(MaterialInfoQuery condition)
{
Task <List <MaterialInfo> > result = Task.Factory.StartNew(() => dao.searchListByCondition(condition));
return(await result);
}
// GET: MaterialInfo
public ActionResult Index(Pager <List <MaterialInfo> > pager, MaterialInfoQuery condition)
{
ViewBag.condition = condition;
pager = service.searchByCondition(pager, condition);
return(View(pager));
}
