public HttpResponseMessage Get(string MarkersId, string sendOpenId) { var model = FeedbackDapper.Query("select * from Feedback where MarkersId=@MarkersId and sendOpenId=@sendOpenId", new { MarkersId, sendOpenId }).FirstOrDefault(); //序列化对象 JsonSerializerSettings settings = new JsonSerializerSettings(); settings.ContractResolver = new CamelCasePropertyNamesContractResolver(); string str = JsonConvert.SerializeObject(model, settings); var obj = JsonConvert.DeserializeObject(str); return(Request.CreateResponse(HttpStatusCode.OK, new { status = "OK", data = obj }, Configuration.Formatters.JsonFormatter)); }
public HttpResponseMessage Post([FromBody] Feedback model) { string status = "error"; if (ModelState.IsValid) { status = "OK"; if (model.Id == null) { model.Id = Guid.NewGuid().ToString(); FeedbackDapper.Add(model); } else { FeedbackDapper.Update(model); } } return(Request.CreateResponse(HttpStatusCode.OK, new { status = status, data = model.Id }, Configuration.Formatters.JsonFormatter)); }
public HttpResponseMessage FeedbackList([FromBody] PageModel pageModel) { if (ModelState.IsValid) { pageModel.PageSize = 5; //根据type判断是接收还是发送 var t = pageModel.Type == "0" ? "SendOpenId" : "ReceiveOpenId"; pageModel.Search = "%" + pageModel.Search + "%"; var modelList = FeedbackDapper.Query("select * from (select row_number()over(order by id) as rownumber,* from feedback where " + t + "=@openId and IsDel=0 and status in (" + pageModel.State + ")) a " + " where rownumber between @minnum and @maxNum", pageModel).OrderByDescending(o => o.CreateTime);; var count = FeedbackDapper.GetCount(" SendOpenId=@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); } return(Request.CreateResponse(HttpStatusCode.OK, new { status = "error", errorMsg = "参数错误" }, Configuration.Formatters.JsonFormatter)); }
public IHttpActionResult GetList([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 = FeedbackDapper.Query("select * from (select row_number()over(order by id) as rownumber,* from feedback where IsDel=0 and markersName like @search) a " + " where rownumber between @minnum and @maxNum", pagemodel).OrderByDescending(o => o.CreateTime); foreach (var model in modelList) { var send = WeChatUserDapper.Query("select * from wechatUser where openid='" + model.SendOpenId + "'").FirstOrDefault(); if (send != null) { model.SendOpenId = send.NickName; } var receive = WeChatUserDapper.Query("select * from wechatUser where openid='" + model.ReceiveOpenId + "'").FirstOrDefault(); if (receive != null) { model.ReceiveOpenId = receive.NickName; } } var count = FeedbackDapper.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 FeedbackAction([FromBody] JObject obj) { string status = "error"; var data = -1; string Id = obj["Id"].ToString(); string type = obj["type"].ToString(); if (Id != null) { status = "OK"; //拒绝 if (type == "reject") { FeedbackDapper.Update("update feedback set Status=2 where Id=@Id", new Feedback { Id = Id }); } //接受 else if (type == "receive") { var dic = new Dictionary <string, string>(); dic.Add("@feedbackId", Id); data = Convert.ToInt32(FeedbackDapper.Transaction("receiveFeedback", dic)); } //查看 else if (type == "view") { FeedbackDapper.Update("update feedback set Status=1 where Id=@Id", new Feedback { Id = Id }); } } HttpResponseMessage result = Request.CreateResponse(HttpStatusCode.OK, new { status, data }, Configuration.Formatters.JsonFormatter); return(result); }