public ActionResult Edit(ViewItemMaintenance view)
{
var userinfo = LoginUserInfo.GetUserInfo();
ResultInfo resultInfo;
try
{
resultInfo = ResultInfo.Parse(
Proc.ProcUpdateItem(
db,
view.CN_ITEM_CODE,
view.CN_NAME,
view.CN_WEIGHT,
view.CN_UNIT,
view.CN_PRODUCTLINECODE,
view.CN_TYPEIDS,
userinfo)
);
}
catch (Exception ex)
{
resultInfo = ResultInfo.Fail(ex.Message);
}
return(Json(resultInfo));
}
public JsonResult MaintenancePageList(ViewItemMaintenance view, int page = 1, int rows = 10)
{
var query = db.ViewItemMaintenances.AsQueryable();
if (!string.IsNullOrWhiteSpace(view.CN_CODE))
{
query = query.Where(obj => obj.CN_CODE.Contains(view.CN_CODE));
}
if (!string.IsNullOrWhiteSpace(view.CN_ITEM_CODE))
{
query = query.Where(obj => obj.CN_ITEM_CODE.Contains(view.CN_ITEM_CODE));
}
if (!string.IsNullOrWhiteSpace(view.CN_NAME))
{
query = query.Where(obj => obj.CN_NAME.Contains(view.CN_NAME));
}
if (!string.IsNullOrWhiteSpace(view.CN_TYPENAMES) && view.CN_TYPENAMES != "无")
{
query = query.Where(obj => obj.CN_TYPENAMES.Contains(view.CN_TYPENAMES));
}
if (view.CN_TYPENAMES == "无")
{
query = query.Where(obj => obj.CN_TYPENAMES == null || obj.CN_TYPENAMES.Trim() == string.Empty);
}
if (view.CN_IS_TOERP > -1)
{
query = query.Where(obj => obj.CN_IS_TOERP == view.CN_IS_TOERP);
}
var list = query.OrderByDescending(obj => obj.CN_DT_TOERP).Skip((page - 1) * rows).Take(rows).ToList();
var count = query.Count();
return(Json(ResultInfo.Success(new { rows = list, total = count })));
}
