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 IHttpActionResult Post([FromBody] NewPageModel pagemodel)
{
pagemodel.Search = "%" + pagemodel.Search + "%";
var modelList = CarInfoDappler.Query("select * from (select row_number()over(order by id) as rownumber,* from carInfo where IsDel=0 ) a " +
" where rownumber between @minnum and @maxNum", pagemodel).OrderByDescending(o => o.CreateTime);
foreach (var model in modelList)
{
var user = WechatDappler.Query("select * from wechatUser where isdel=0 and openid=@openId", new { openId = model.OpenId }).FirstOrDefault();
if (user != null)
{
model.OpenId = user.NickName;
}
else
{
model.OpenId = "";
}
}
var count = CarInfoDappler.GetCount();
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 async Task <ActionResult> NewPage(string username, NewPageModel model)
{
using (ZavrsniEFentities db = new ZavrsniEFentities())
{
var user = db.User.FirstOrDefault(u => u.Username.Equals(username));
var newPage = db.Page.Create();
newPage.name = model.PageTitle;
if (Request["PrivacyDropDown"].Any())
{
var privSel = Request["PrivacyDropDown"];
var privacy = Convert.ToInt32(privSel);
newPage.IDprivacy = privacy;
}
else
{
return(RedirectToAction("NewPage", new { Username = username }));
}
newPage.CreatedAt = DateTime.Now;
newPage.PageView = 0;
db.Page.Add(newPage);
db.SaveChanges();
var newContributor = db.Contributor.Create();
newContributor.IDpage = newPage.IDpage;
newContributor.IDuser = user.IDuser;
newContributor.IsAuthor = true;
db.Contributor.Add(newContributor);
db.SaveChanges();
return(RedirectToAction("Index", new { Username = username }));
}
}
public NewPageModel newScreen()
{
var model = new NewPageModel();
model.Text = "BMI Calculator";
model.button1Text = "Next";
model.button2Text = "Back";
return(model);
}
public ActionResult NewPage(string username)
{
NewPageModel model = new NewPageModel();
using (ZavrsniEFentities db = new ZavrsniEFentities())
{
var query = (from p in db.Privacy
select p).ToList();
model.Privacy = new SelectList(query, "IDprivacy", "description");
model.Username = username;
return(View(model));
}
}
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 IHttpActionResult Post([FromBody] NewPageModel pagemodel)
{
pagemodel.Search = "%" + pagemodel.Search + "%";
var modelList = WechatDapper.Query("select * from (select row_number()over(order by id) as rownumber,* from WechatUser where IsDel=0 ) a " +
" where rownumber between @minnum and @maxNum", pagemodel).OrderByDescending(o => o.CreateTime);
var count = WechatDapper.GetCount();
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));
}
