public IHttpActionResult MarkersListInfo([FromBody] JObject objModel)
{
NewPageModel pagemodel = new NewPageModel();
pagemodel.Length = Convert.ToInt32(objModel["length"]);
pagemodel.PageCount = Convert.ToInt32(objModel["pageCount"]);
pagemodel.Search = "%" + objModel["search"].First.First.ToString() + "%";
pagemodel.Start = Convert.ToInt32(objModel["start"]);
var modelList = MarkersDapper.Query("select * from (select row_number()over(order by id) as rownumber,* from MarkersInformation where IsDel=0 and areaName like @search) a " +
" where rownumber between @minnum and @maxNum", pagemodel).OrderByDescending(o => o.CreateTime).Select(o => new MarkersModel {
AcceptNum = o.AcceptNum, CoverImage = o.CoverImage, Status = o.Status,
Id = o.Id, AreaName = o.AreaName, CreateTime = o.CreateTime.ToString("yyyy-MM-dd"), Remark = o.Remark, UserName = WechatUserDpper.Query("select NickName from WechatUser where openId='" + o.OpenId + "'").FirstOrDefault().NickName
});
var count = MarkersDapper.GetCount(" isdel=0");
JsonSerializerSettings settings = new JsonSerializerSettings();
settings.ContractResolver = new CamelCasePropertyNamesContractResolver();
string str = JsonConvert.SerializeObject(modelList, settings);
var obj = JsonConvert.DeserializeObject(str);
//返回参数集合
Dictionary <string, object> map = new Dictionary <string, object>();
map.Add("iTotalRecords", pagemodel.Start);
map.Add("iTotalDisplayRecords", count);//总数据个数
map.Add("aData", obj);
return(Json(map));
}
public HttpResponseMessage AcceptList([FromBody] PageModel pageModel)
{
pageModel.PageSize = 6;
pageModel.Search = "%" + pageModel.Search + "%";
var modelList = MarkersDapper.Query("select * from (select row_number()over(order by id) as rownumber,* from MarkersInformation where Id in (select markersId from [dbo].[Accept] where OpenId=@openId and IsDel=0) and IsDel=0 and areaName like @search) a " +
" where rownumber between @minnum and @maxNum", pageModel).OrderByDescending(o => o.CreateTime);
var count = MarkersDapper.GetCount(" openId=@openId", new { openId = pageModel.OpenId });
JsonSerializerSettings settings = new JsonSerializerSettings();
settings.ContractResolver = new CamelCasePropertyNamesContractResolver();
string str = JsonConvert.SerializeObject(modelList, settings);
var obj = JsonConvert.DeserializeObject(str);
HttpResponseMessage result =
Request.CreateResponse(HttpStatusCode.OK, new { status = "OK", data = new { modelList = obj, isMax = count < pageModel.MaxNum } }, Configuration.Formatters.JsonFormatter);
return(result);
}
