public ActionResult GetList(OrderDetailCauseSearch req) { if (req.ListType == 1) { req.offset = (req.offset - 1) * req.limit; } var list = _orderDetailCauseRepository.GetList(out int total, req); return(NewtonSoftJson(new { rows = list, total = total, code = 0, msg = "" }, JsonRequestBehavior.AllowGet)); }
public List <OrderDetailCauseListDTO> GetList(out int total, OrderDetailCauseSearch req) { var companyId = OperatorProvider.Provider.GetCurrent().CompanyId.ToInt(); using (var db = new SqlSugarClient(Connection)) { int totalCount = 0; string order = string.Empty; List <OrderDetailCauseListDTO> list = new List <OrderDetailCauseListDTO>(); if (!string.IsNullOrEmpty(req.Sort)) { if (req.Sort.Equals("id", StringComparison.OrdinalIgnoreCase)) { order = "Id desc"; } else { order = string.Format("{0} {1}", req.Sort, req.Order); } } var data = db.Sqlable() .From <R_OrderDetailCause>("") .Where("IsDelete = 0 "); if (req.CauseType > 0) { data = data.Where("CauseType=" + req.CauseType); } totalCount = data.Count(); list = data.SelectToPageList <OrderDetailCauseListDTO>( @"*,(CASE CauseType WHEN 1 THEN '赠送' WHEN 2 THEN '退菜' end) AS CauseTypeName", order, (req.offset / req.limit) + 1, req.limit, null); total = totalCount; return(list); } }