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);
}