/// <summary> /// 获取列表 /// </summary> /// <param name="queryJson">查询参数</param> /// <returns>返回列表</returns> public IEnumerable <Ku_LocationEntity> GetList(string queryJson) { var queryParam = queryJson.ToJObject(); //限坐标表 string strOrder = ""; string strSql = ""; string des = OperatorProvider.Provider.Current().Description; //string des = "兰山区"; string locationSql = LocationHelper.GetLocationSql(des); //假如有微信坐标的话 if (!queryParam["wxLon"].IsEmpty() && !queryParam["wxLat"].IsEmpty()) { string wxLon = queryParam["wxLon"].ToString(); string wxLat = queryParam["wxLat"].ToString(); strSql = "select top 100 id,wxlon,wxlat,regeoname,address,count,dbo.f_GetDistance(" + wxLon + "," + wxLat + ",wxlon,wxlat) as description,picture FROM " + locationSql + " t where 1=1"; strOrder = " order by dbo.f_GetDistance(" + wxLon + "," + wxLat + ",wxlon,wxlat) asc"; } else { strSql = "select top 100 id,wxlon,wxlat,regeoname,address,count from " + locationSql + " where 1 = 1 "; strOrder = " ORDER BY CreateDate desc"; } //店铺名 if (!queryParam["SearchName"].IsEmpty()) { string OfficeName = queryParam["SearchName"].ToString(); strSql += " and regeoname = '" + OfficeName + "'"; } strSql += strOrder; return(this.BaseRepository().FindList(strSql.ToString())); }
/// <summary> /// 获取列表自动补全公司名称 /// </summary> /// <param name="CompanyName">查询参数</param> /// <returns>返回列表</returns> public IEnumerable <Ku_CompanyEntity> GetListByName(string CompanyName) { string des = OperatorProvider.Provider.Current().Description; string locationSql = LocationHelper.GetLocationSql(des); string strSql = $"select top 5 c.Id,c.CompanyName from Ku_Company c LEFT JOIN {locationSql} l ON l.Id=c.LocationId where ManageState=1 AND LocationId>0 AND c.District!='' "; //公司名 if (!CompanyName.IsEmpty()) { strSql += " and c.CompanyName like '%" + CompanyName + "%'"; } return(this.BaseRepository().FindList(strSql.ToString())); }
/// <summary> /// 获取列表自动补全公司名称(私池) /// </summary> /// <param name="CompanyName">查询参数</param> /// <returns>返回列表</returns> public IEnumerable <Ku_CompanyEntity> GetListByNameSi(string CompanyName) { string des = OperatorProvider.Provider.Current().Description; string locationSql = LocationHelper.GetLocationSql(des); string strSql = $"select top 5 c.CompanyName from Ku_Company c LEFT JOIN {locationSql} l ON l.Id=c.LocationId where ObtainState=1 and ManageState=1 AND LocationId>0 AND c.District!='' "; //公司名 if (!CompanyName.IsEmpty()) { strSql += " and c.CompanyName like '%" + CompanyName + "%'"; } if (!OperatorProvider.Provider.Current().IsSystem) { string dataAutor = string.Format(OperatorProvider.Provider.Current().DataAuthorize.ReadAutorize, OperatorProvider.Provider.Current().UserId); strSql += " and (c.ObtainUserId in (" + dataAutor + "))"; } return(this.BaseRepository().FindList(strSql.ToString())); }
/// <summary> /// 获取列表 /// </summary> /// <param name="pagination">分页</param> /// <param name="queryJson">查询参数</param> /// <returns>返回分页列表</returns> public IEnumerable <Ku_CompanyEntity> GetPageList(Pagination pagination, string queryJson) { var expression = LinqExtensions.True <Ku_CompanyEntity>(); var queryParam = queryJson.ToJObject(); string des = OperatorProvider.Provider.Current().Description; string locationSql = LocationHelper.GetLocationSql(des); string strSql = $"select c.* from Ku_Company c LEFT JOIN {locationSql} l ON l.Id=c.LocationId where ManageState=1 AND LocationId>0 AND c.District!='' ";//在营公海显示被获取公司 ObtainState=0 //坐标位置商圈ID存在的话,不以输入的商圈文字搜索 if (!queryParam["LocationId"].IsEmpty()) { string LocationId = queryParam["LocationId"].ToString(); strSql += " and LocationId = " + LocationId; } else if (!queryParam["RegeoName"].IsEmpty()) { string RegeoName = queryParam["RegeoName"].ToString(); strSql += " and c.RegeoName like '%" + RegeoName + "%' "; } //位置ID if (!queryParam["LocationIds"].IsEmpty()) { string LocationIds = queryParam["LocationIds"].ToString(); strSql += " and LocationId in (" + LocationIds + ")"; } //单据日期 if (!queryParam["StartTime"].IsEmpty() && !queryParam["EndTime"].IsEmpty()) { DateTime startTime = queryParam["StartTime"].ToDate(); DateTime endTime = queryParam["EndTime"].ToDate().AddDays(1); strSql += " and BuildTime >= '" + startTime + "' and BuildTime < '" + endTime + "'"; } //公司名 if (!queryParam["CompanyName"].IsEmpty()) { string CompanyName = queryParam["CompanyName"].ToString(); strSql += " and c.CompanyName like '%" + CompanyName + "%' "; } //经营范围 if (!queryParam["Scope"].IsEmpty()) { string Scope = queryParam["Scope"].ToString(); strSql += " and c.Scope like '%" + Scope + "%' "; } //行业 if (!queryParam["Sector"].IsEmpty()) { string Sector = queryParam["Sector"].ToString(); Sector = Sector.Replace("[", "").Replace("]", "").Replace("\"", "'"); strSql += " and c.Sector in(" + Sector + ")"; } //区域 if (!queryParam["District"].IsEmpty()) { string District = queryParam["District"].ToString(); District = District.Replace("[", "").Replace("]", "").Replace("\"", "'"); strSql += " and c.District in(" + District + ")"; } //POI分布 if (!queryParam["TypeName"].IsEmpty()) { string TypeName = queryParam["TypeName"].ToString(); TypeName = TypeName.Replace("[", "").Replace("]", "").Replace("\"", "'"); strSql += " and l.TypeName in(" + TypeName + ")"; } //销售人 if (!queryParam["ObtainUserId"].IsEmpty()) { string ObtainUserId = queryParam["ObtainUserId"].ToString(); strSql += " and c.ObtainUserId = '" + ObtainUserId + "'"; } //状态 if (!queryParam["FollowState"].IsEmpty()) { string FollowState = queryParam["FollowState"].ToString(); strSql += " and c.FollowState = '" + FollowState + "'"; } //排序楼层,房间 if (pagination.sidx == "Floor") { pagination.sidx = "Floor " + pagination.sord + ",Room " + pagination.sord; } return(this.BaseRepository().FindList(strSql.ToString(), pagination)); }