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));
}
