/// <summary> /// 获取注册情况统计 /// </summary> /// <param name="request"></param> /// <returns></returns> public List <SelectSumAppUserList> GetSelectSumAppUserList(RouteSumAppUser request) { using (var db = DbFactory.Open()) { string userSql = "select COUNT(*) as userCount,a.adcd,a.adcdId,b.adnm,b.parentId from AppAllUserView a left join ADCDInfo b on a.adcdId=b.Id where a.adcdId is not null and a.adcd is not null and RIGHT(a.adcd, 11)!= '00000000000' "; string appSql = "select COUNT(*) as appcount,b.adcd,a.adcdId,b.adnm,b.parentId from AppGetReg a left join ADCDInfo b on a.adcdId=b.Id where a.adcdId is not null and RIGHT(b.adcd, 11)!= '00000000000' "; if (AdcdHelper.GetByAdcdRole(request.adcd) == "省级") { return(GetProvinceList(request.adcd, request.adcdName, db)); //userSql += " and a.adcd like '33%'"; //appSql += " and b.adcd like '33%'"; } if (AdcdHelper.GetByAdcdRole(request.adcd) == "市级") { return(GetCityList(request.adcd, request.adcdName, db)); } if (AdcdHelper.GetByAdcdRole(request.adcd) == "县级") { return(GetCountryList(request.adcd, request.adcdName, db)); //userSql += " and a.adcd like '" + request.adcd.Substring(0, 6) + "%'"; //appSql += " and b.adcd like '" + request.adcd.Substring(0, 6) + "%'"; } if (AdcdHelper.GetByAdcdRole(request.adcd) == "镇级") { return(GetTownList(request.adcd, request.adcdName, db)); //userSql += " and a.adcd like '" + request.adcd.Substring(0, 9) + "%'"; //appSql += " and b.adcd like '" + request.adcd.Substring(0, 9) + "%'"; } if (request.adcdName != null && request.adcdName != "") { userSql += " and b.adnm like '%" + request.adcdName + "%'"; appSql += " and b.adnm like '%" + request.adcdName + "%'"; } userSql += " group by a.adcd,a.adcdId,b.adnm,b.parentId order by a.adcdId"; appSql += " group by b.adcd,a.adcdId,b.adnm,b.parentId order by a.adcdId"; List <SelectSumAppUserList> allList = db.SqlList <SelectSumAppUserList>(userSql); List <SelectSumAppUserList> appList = db.SqlList <SelectSumAppUserList>(appSql); return(GetSumAppUserList(allList, appList, request.adcd)); } }
public List <SelectSumAppUserList> Get(RouteSumAppUser request) { return(logic.GetSelectSumAppUserList(request)); }