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