public ActionResult GetPackages(PackageSearchDTO req)
{
int total = 0;
var list = PackageRepository.GetList(out total, req);
return(Json(new { rows = list, total = total }, JsonRequestBehavior.AllowGet));
}
public ActionResult GetPackages(PackageSearchDTO req)
{
if (req.ListType == 1)
{
req.offset = (req.offset - 1) * req.limit;
}
var list = _packageRepository.GetList(out int total, req);
return(Json(new { rows = list, total = total, code = 0, msg = "" }, JsonRequestBehavior.AllowGet));
}
public List <PackageListDTO> GetList(out int total, PackageSearchDTO req)
{
var companyId = OperatorProvider.Provider.GetCurrent().CompanyId.ToInt();
using (var db = new SqlSugarClient(Connection))
{
List <PackageListDTO> list = new List <PackageListDTO>();
int totalCount = 0;
string order = "s1.Id desc";
var data = db.Sqlable().From <R_Package>("s1").Where(" s1.IsDelete = 0 ");
data = data.Where("s1.R_Company_Id=" + companyId);
if (!string.IsNullOrEmpty(req.Name))
{
data = data.Where("s1.Name like '%" + req.Name + "%'");
}
if (req.MinPrice > 0)
{
data = data.Where("s1.Price>=" + req.MinPrice);
}
if (req.MaxPrice > 0)
{
data = data.Where("s1.Price <= " + req.MaxPrice);
}
if (!string.IsNullOrEmpty(req.Sort))
{
if (req.Sort.Equals("id", StringComparison.OrdinalIgnoreCase))
{
order = "s1.Id desc";
}
else
{
order = string.Format("{0} {1}", req.Sort, req.Order);
}
}
totalCount = data.Count();
list = data.SelectToPageList <PackageListDTO>(
"s1.*", order, (req.offset / req.limit) + 1, req.limit, null);
total = totalCount;
return(list);
}
}
