/// <summary> /// 列表 /// </summary> /// <param name="search"></param> /// <param name="view"></param> /// <returns></returns> public PagedList <STORES_EXCEL> QueryExcels(ExcelSearch search, PageView view) { string wherestr = "AND B.NAME IS NOT NULL GROUP BY B.ID,B.NAME,B.POS_CODE"; return(base.PageGet <STORES_EXCEL>(view, @" B.ID STORE_ID,replace(B.NAME,' ','') STORE_NAME,B.POS_CODE STORE_CODE, COUNT(0) FANS_COUNT, SUM(CASE WHEN C.ID IS NULL THEN 0 ELSE 1 END) MEMBER_COUNT ", @" dbo.WXCUST_FANS A LEFT JOIN dbo.BCJ_STORES B ON A.STORE_CODE = B.POS_CODE LEFT JOIN CUST_MEMBER C ON A.ID = C.FANS_ID ", wherestr, " B.ID ", "order by B.ID")); }
public JsonResult GetDetail(ExcelSearch search, FormCollection form) { PageView view = new PageView(form); try { if (search == null) { search = new ExcelSearch(); } string colkey = form["colkey"]; string colsinfo = form["colsinfo"]; PagedList <STORES_EXCEL> pList = _bcjStore.QueryExcels(search, view); JsonQTable fdata = JsonQTable.ConvertFromPagedList <STORES_EXCEL>(pList, colkey, colsinfo.Split(',')); return(Json(fdata)); } catch (Exception ex) { throw new Exception(ex.Message); } }
/// <summary> /// 报错信息 /// </summary> /// <param name="search"></param> /// <param name="view"></param> /// <returns></returns> public PagedList <STORES_EXCEL> QueryExcels(ExcelSearch search, PageView view) { return(_bcjstor.QueryExcels(search, view)); }