public JsonResult LoadData(int type, string keyword, int pageIndex, int pageSize) { string str = NonUnicode.RemoveUnicode(keyword).ToLower(); var model = new MenuTypeDao().ListAll(); switch (type) { case 0: model = model.Where(x => NonUnicode.RemoveUnicode(x.Name.ToLower()).Contains(str)); break; } int totalRow = model.Count(); model = model.OrderByDescending(x => x.ID) .Skip((pageIndex - 1) * pageSize) .Take(pageSize); int totalRowCurent = model.Count(); return(Json(new { data = model, total = totalRow, totalCurent = totalRowCurent, status = true }, JsonRequestBehavior.AllowGet)); }
public JsonResult LoadData(int type, string keyword, int status, int pageIndex, int pageSize) { string str = NonUnicode.RemoveUnicode(keyword).ToLower(); var model = new OrderDao().ListAll(); switch (type) { case 0: model = model.Where(x => NonUnicode.RemoveUnicode(x.NameAccount.ToLower()).Contains(str) || x.ShipMobile.ToString().Contains(str) || NonUnicode.RemoveUnicode(x.ShipName.ToLower()).Contains(str) || NonUnicode.RemoveUnicode(x.ShipAddress.ToLower()).Contains(str) ); break; case 1: model = model.Where(x => NonUnicode.RemoveUnicode(x.NameAccount.ToLower()).Contains(str)); break; case 2: model = model.Where(x => NonUnicode.RemoveUnicode(x.ShipName.ToLower()).Contains(str)); break; case 3: model = model.Where(x => x.ShipMobile.ToString().Contains(str)); break; case 4: model = model.Where(x => NonUnicode.RemoveUnicode(x.ShipAddress.ToLower()).Contains(str)); break; } switch (status) { case 0: break; //tất cả case 1: model = model.Where(x => x.Status == 1); break; //đơn mới case 2: model = model.Where(x => x.Status == 2); break; //đang giao case 3: model = model.Where(x => x.Status == 3); break; //đã giao } int totalRow = model.Count(); model = model.OrderByDescending(x => x.ID) .Skip((pageIndex - 1) * pageSize) .Take(pageSize); int totalRowCurent = model.Count(); return(Json(new { data = model, total = totalRow, totalCurent = totalRowCurent, status = true }, JsonRequestBehavior.AllowGet)); }
public JsonResult LoadData(int type, string keyword, bool status, int pageIndex, int pageSize) { string str = NonUnicode.RemoveUnicode(keyword).ToLower(); var model = new ProductDao().ListAll(); switch (type) { case 0: model = model.Where( x => NonUnicode.RemoveUnicode(x.Name).ToLower().Contains(str) || NonUnicode.RemoveUnicode(x.ProductCategoryName).ToLower().Contains(str) || NonUnicode.RemoveUnicode(x.UnitName).ToLower().Contains(str) ); break; case 1: model = model.Where(x => NonUnicode.RemoveUnicode(x.Name).ToLower().Contains(str)); break; case 2: model = model.Where(x => NonUnicode.RemoveUnicode(x.ProductCategoryName).ToLower().Contains(str)); break; case 3: model = model.Where(x => NonUnicode.RemoveUnicode(x.UnitName).ToLower().Contains(str)); break; } if (status) { model = model.Where(x => x.Status == true); } else { model = model.Where(x => x.Status == false); } int totalRow = model.Count(); model = model.OrderByDescending(x => x.ID) .Skip((pageIndex - 1) * pageSize) .Take(pageSize); int totalRowCurent = model.Count(); return(Json(new { data = model, total = totalRow, totalCurent = totalRowCurent, status = true }, JsonRequestBehavior.AllowGet)); }
public JsonResult LoadData(int type, string keyword, int pageIndex, int pageSize) { string str = NonUnicode.RemoveUnicode(keyword).ToLower(); var model = new ProductCategoryDao().ListAll(); switch (type) { case 0: model = model.Where(x => NonUnicode.RemoveUnicode(x.Name.ToLower()).Contains(str)); break; } int totalRow = model.Count(); //Sắp xếp theo danh mục cha var list = new List <ProductCategory>(); model = model.OrderBy(x => x.DisplayOrder); foreach (var item in model) { if (item.ParentID == null) { list.Add(item); var child = model.Where(x => x.ParentID == item.ID); foreach (var subitem in child) { list.Add(subitem); } } } ////Kết thúc sắp xếp. model = list .Skip((pageIndex - 1) * pageSize) .Take(pageSize); int totalRowCurent = model.Count(); return(Json(new { data = model, total = totalRow, totalCurent = totalRowCurent, status = true }, JsonRequestBehavior.AllowGet)); }