public string GetData(HttpContext context)
{
HttpReSultMode resultMode = new HttpReSultMode();
try
{
int pageIndex = int.Parse(context.Request["Pageindex"]);
int pageSize = int.Parse(context.Request["Pagesize"]);
DataSet ds;
#region 条件
StringBuilder Where = new StringBuilder();
Where.Append(" isDeleted=0 and States>0");
if (context.Request["keyWords"] != null)//关键词
{
string KeyWords = FilterTools.FilterSpecial(context.Request["keyWords"].ToString());
Where.Append(" and( TName like '%" + KeyWords + "%'");
Where.Append(" or Address like '%" + KeyWords + "%' ");
Where.Append(" or Details like '%" + KeyWords + "%') ");
}
if (context.Request["Category"] != null)//分类
{
string Category = FilterTools.FilterSpecial(context.Request["Category"].ToString());
Where.Append(" and ( Category like '" + Category + "%')");
}
#endregion
#region 坐标 有距离
if (context.Request["Lng"] != null && context.Request["Lat"] != null)//传有坐标按距离排序
{
string Longitude = context.Request["Lng"].ToString();
string Latitude = context.Request["Lat"].ToString();
//分页 按距离排序
string geohashWhere = Geohash.getsqlGeoHash(5, Latitude, Longitude, "geohash");
string sqlWhere = Where.ToString() + " and " + geohashWhere;//条件加geohash
ds = OPBiz.GetPagingOrderByLL(sqlWhere, pageIndex, pageSize, Longitude, Latitude);
}
else //简单分页无排序
{
ds = OPBiz.GetPagingDataSet(Where.ToString(), pageIndex, pageSize, "CreateTime desc");
}
#endregion
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
resultMode.Code = 11;
resultMode.Msg = "获取成功";
resultMode.Data = JsonHelper.ToJson(ds.Tables[0], true);
}
else
{
resultMode.Code = 0;
resultMode.Msg = "没有数据";
resultMode.Data = "[]";
}
}
catch (Exception ex)
{
resultMode.Code = -11;
resultMode.Data = ex.ToString();
}
string result = JsonHelper.ToJson(resultMode, true);
return(result);
;
}
/// <summary>
/// 分类分页获取
/// </summary>
/// <param name="context"></param>
/// <param name="httpObject"></param>
/// <param name="resultMode"></param>
private void GetByCategory(HttpContext context, JObject httpObject, HttpReSultMode resultMode)
{
int pageIndex = 1;
int pageSize = 10000;
DataSet ds;
#region
if (httpObject["pageIndex"] != null)
{
pageIndex = int.Parse(httpObject["pageIndex"].ToString());
}
if (httpObject["pageSize"] != null)
{
pageSize = int.Parse(httpObject["pageSize"].ToString());
}
#region 条件
StringBuilder Where = new StringBuilder();
Where.Append(" isDeleted=0 and States>=0 ");
if (httpObject["jsonEntity"]["KeyWords"] != null)//关键词
{
string KeyWords = FilterTools.FilterSpecial(httpObject["jsonEntity"]["KeyWords"].ToString());
Where.Append(" and( Title like '%" + KeyWords + "%'");
Where.Append(" or Address like '%" + KeyWords + "%') ");
}
if (httpObject["jsonEntity"]["Category"] != null)//分类
{
string Category = FilterTools.FilterSpecial(httpObject["jsonEntity"]["Category"].ToString());
Where.Append(" and ( Category like '" + Category + "%')");
}
if (httpObject["jsonEntity"]["MinPrice"] != null)//最低价
{
string MinPrice = FilterTools.FilterSpecial(httpObject["jsonEntity"]["MinPrice"].ToString());
Where.Append(" and ( Price >" + MinPrice + ")");
}
if (httpObject["jsonEntity"]["MaxPrice"] != null)//最高价
{
string MaxPrice = FilterTools.FilterSpecial(httpObject["jsonEntity"]["MaxPrice"].ToString());
Where.Append(" and ( Price <" + MaxPrice + ")");
}
if (httpObject["jsonEntity"]["ProvinceCode"] != null)//省
{
string ProvinceCode = FilterTools.FilterSpecial(httpObject["jsonEntity"]["ProvinceCode"].ToString());
Where.Append(" and ( ProvinceCode like '" + ProvinceCode + "%')");
}
if (httpObject["jsonEntity"]["CityCode"] != null)//城市
{
string CityCode = FilterTools.FilterSpecial(httpObject["jsonEntity"]["CityCode"].ToString());
Where.Append(" and ( CityCode like '" + CityCode + "%')");
}
if (httpObject["jsonEntity"]["AreaCode"] != null)//区
{
string AreaCode = FilterTools.FilterSpecial(httpObject["jsonEntity"]["AreaCode"].ToString());
Where.Append(" and ( AreaCode like '" + AreaCode + "%')");
}
#endregion
#region 坐标 有距离
if (httpObject["jsonEntity"]["Longitude"] != null && httpObject["jsonEntity"]["Latitude"] != null)//传有坐标按距离排序
{
string Longitude = httpObject["jsonEntity"]["Longitude"].ToString();
string Latitude = httpObject["jsonEntity"]["Latitude"].ToString();
string geohashWhere = Geohash.getsqlGeoHash(5, Latitude, Longitude, "geohash");
string sqlWhere = Where.ToString() + " and " + geohashWhere; //条件加geohash
if (httpObject["jsonEntity"]["minKM"] != null && httpObject["jsonEntity"]["maxKM"] != null) //有最小最大距离约定，按距离排序， 不分页
{
float minKM = float.Parse(httpObject["jsonEntity"]["minKM"].ToString());
float maxKM = float.Parse(httpObject["jsonEntity"]["maxKM"].ToString());
ds = OPBiz.GetByDistancesOrderByLL("v_TS_Transaction", sqlWhere, minKM, maxKM, Longitude, Latitude);
}
else //分页 按距离排序
{
ds = OPBiz.GetPagingOrderByLL("v_TS_Transaction", sqlWhere, pageIndex, pageSize, Longitude, Latitude);
}
}
else //简单分页无排序
{
ds = OPBiz.GetPagingDataSet("v_TS_Transaction", Where.ToString(), pageIndex, pageSize, "CreateTime desc");
}
#endregion
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
resultMode.Code = 11;
resultMode.Msg = "获取成功";
resultMode.Data = JsonHelper.ToJson(ds.Tables[0], true);
}
else
{
resultMode.Code = 0;
resultMode.Msg = "没有数据";
resultMode.Data = "[]";
}
#endregion
context.Response.Write(JsonHelper.ToJson(resultMode, true));
context.Response.End();
}
