public ActionResult GetList(PrinterSearchDTO req) { if (req.ListType == 1) { req.offset = (req.offset - 1) * req.limit; } var list = _printerRepository.GetList(req, out int total); return(Json(new { rows = list, total = total, code = 0, msg = "" }, JsonRequestBehavior.AllowGet)); }
public List <PrinterDTO> GetList(PrinterSearchDTO req, out int total) { using (var db = new SqlSugarClient(Connection)) { //string order = "Id desc"; List <PrinterDTO> list = new List <PrinterDTO>(); var models = db.Queryable <Printer>().Where(p => p.IsDelete == false).ToList(); list = ConvertToInfoList(models); total = list.Count; return(list.Skip(req.offset).Take(req.limit).ToList()); } }