public string Update(webReq req) { ResultForWeb r = new ResultForWeb { HttpCode = 200, Message = "", data = "{}" }; string tempImg = req.tempImg; FoodInfo food = new FoodInfo(); var foodName = req.foodName; var foodId = req.foodId; var isThisWeek = Convert.ToBoolean(req.isThisWeek); var secondTag = Convert.ToInt32(req.secondTag); food.secondTag = secondTag; var now = Convert.ToInt32(DateTime.Now.DayOfWeek); var foodTime = DateTime.Now.AddDays(secondTag - now); if (!isThisWeek) { foodTime = foodTime.AddDays(7); } food.FoodTime = foodTime; food.foodName = foodName; food.foodPrice = Convert.ToDecimal(req.foodPrice); food.foodTagId = Convert.ToInt32(req.foodTypeId); food.foodImg = req.foodImg; food.foodText = req.foodText; var stars = Convert.ToDecimal(req.foodStars); stars = stars < 0 ? 0 : stars; stars = stars > 5 ? 5 : stars; food.star = stars; food.id = Convert.ToInt32(foodId); //if (req.isCycle == "0") // food.isCycle = false; //else // food.isCycle = true; food.deposit = Convert.ToDecimal(req.deposit); if (req.isMain == "0") { food.isMain = false; } else { food.isMain = true; } FoodInfoOper.Instance.Update(food); ControllerHelper.Instance.CopyFile(this.Server.MapPath(tempImg), this.Server.MapPath(food.foodImg)); r.data = JsonHelperHere.JsonMsg(true, ""); return(JsonConvert.SerializeObject(r)); }
public string Get(webReq req) { string search = req.search == null ? "" :req.search; //搜索内容 int index = Convert.ToInt32(req.index); //页码 int pages = 0; //总页数 int size = 12; //一页size条数据 var condition = " isdeleted=0 and (areaName like '%" + search + "%' or areaNo like '%" + search + "%' ) "; var listAll = CacheHelper.GetDistinctCount <AreaInfo>("areainfo", condition); if (listAll.Count < 1) { return(JsonHelperHere.EmptyJson()); } var ids = listAll.Skip((index - 1) * size).Take(size).Select(p => p.id).ToArray(); var viewList = CacheHelper.GetByIds <AreaInfo>("AreaInfo", ids); var count = listAll.Count; pages = count / size; //总页数 pages = pages * size == count ? pages : pages + 1; return(JsonHelperHere.JsonResult(pages, viewList, index)); }
public string Update(webReq req) { ResultForWeb r = new ResultForWeb(); r.HttpCode = 200; r.Message = ""; FoodTagInfo tag = new FoodTagInfo(); var tagId = Convert.ToInt32(req.foodTagId); tag.foodTagName = req.foodTagName; var name = req.foodTagName; if (ControllerHelper.Instance.IsExists("foodtaginfo", "foodTagName", name, tagId.ToString())) { r.HttpCode = 500; r.data = JsonHelperHere.JsonMsg(false, "已存在该标签"); return(JsonConvert.SerializeObject(r)); } bool isWeek = true; if (req.isWeek == "0") { isWeek = false; } tag.isWeek = isWeek; tag.id = tagId; FoodTagInfoOper.Instance.Update(tag); r.data = JsonHelperHere.JsonMsg(true, ""); return(JsonConvert.SerializeObject(r)); }
public string Get(webReq req) { int size = 12; int pages = 0; //总页数 string search = req.search == null ? "" : req.search; //搜索内容 int index = req.index; //页码 int tagType = Convert.ToInt32(req.tagType); var condition = " IsDeleted=0 and foodTagName like '%" + search + "%' "; if (tagType != 2) { condition += " and isweek=" + tagType; } var listAll = CacheHelper.GetDistinctCount <FoodTagInfo>("FoodTagInfo", condition); var ids = listAll.Skip((index - 1) * size).Take(size).Select(p => p.id).ToArray(); if (ids.Count() < 1) { return(JsonHelperHere.EmptyJson()); } var idsStr = string.Join(",", ids); //查具体信息 var viewList = CacheHelper.GetByCondition <FoodTagInfo>("FoodTagInfo", " id in (" + idsStr + ")"); var count = listAll.Count; pages = count / size; //总页数 pages = pages * size == count ? pages : pages + 1; return(JsonHelperHere.JsonAddPage(pages, JsonConvert.SerializeObject(viewList.OrderByDescending(p => p.id)), index)); }
/// <summary> /// 后台同意骑手取消 /// </summary> /// <returns></returns> public string AgreeRiderCancel(webReq req) { var orderId = req.orderId; //var orderId = Convert.ToInt32(Request["orderId"]); var order = OrderInfoOper.Instance.GetById(orderId); if (order.status != 99) { return(JsonHelperHere.JsonMsg(false, "订单状态已改变")); } order.status = 5; OrderInfoOper.Instance.Update(order); OrderInfoOper.Instance.OrderCancelDoMoney(order); UPushHelper.Instance.PushUserOrderCancel(order); //用户取消订单,菜品返还给骑手 var list = OrderFoodsOper.Instance.GetByOrderId(order.id); var listFoods = new List <foodId_Amount>(); foreach (var item in list) { foodId_Amount fa = new foodId_Amount(item); listFoods.Add(fa); } RiderStockOper.Instance.AddRs((int)order.riderId, listFoods); return(JsonHelperHere.JsonMsg(true, "")); }
public string GetByAreaId(webReq req) { ResultForWeb r = new ResultForWeb(); r.HttpCode = 200; r.Message = ""; r.data = "{}"; if (Session["pfId"] == null) { r.HttpCode = 300; return(JsonConvert.SerializeObject(r)); } int index = req.index; int pages = 0; //总页数 int size = 12; //一页size条数据 int areaId = req.areaId; List <RiderInfo> list = RiderInfoOper.Instance.GetByAreaId(areaId); list = list.OrderByDescending(p => p.id).Where(p => p.isDeleted == false).ToList(); pages = list.Count / size; pages = pages * size == list.Count ? pages : pages + 1;//总页数 list = list.Skip((index - 1) * size).Take(size).ToList(); r.data = JsonHelperHere.JsonAddPage(pages, JsonConvert.SerializeObject(list), index); return(JsonConvert.SerializeObject(r)); }
/// <summary> /// 添加平台账号 /// </summary> /// <param name="req"></param> /// <returns></returns> public string add(webReq req) { var lv = req.lv; var thisLv = Convert.ToInt32(Session["lv"]); if (thisLv < lv) { return(JsonHelperHere.JsonMsg(false, "权限不够")); } var account = req.account; if (!StringHelperHere.Instance.IsAccountValidate(account)) { return(JsonHelperHere.JsonMsg(false, "账号应为5~16位英文字母、数字")); } if (ControllerHelper.Instance.IsExists("platform", "account", account, "0")) { return(JsonHelperHere.JsonMsg(false, "已存在该账号")); } var pwd = req.pwd; if (!StringHelperHere.Instance.IsPwdValidate(pwd)) { return(JsonHelperHere.JsonMsg(false, "密码应为6~16位英文字母、数字")); } Platform pf = new Platform(); pf.level = lv; pf.account = account; pf.pwd = pwd; PlatformOper.Instance.Add(pf); return(JsonHelperHere.JsonMsg(true, "")); }
public string Get(webReq req) { var set = new SettingRes(); var days = Convert.ToInt32(set.couponSaveDays); int isUse = req.isUse; string search = Request["search"] == null ? "" : Request["search"]; //搜索内容 int index = Convert.ToInt32(Request["index"]); //页码 var batch = Request["batch"]; var isRepeat = Convert.ToInt32(req.isRepeat); int pages = 0; //总页数 int size = 12; //一页size条数据 var condition = " isdeleted=0 and "; if (isUse != 2) { condition += " isuse=" + isUse + " and "; } if (batch != "0") { condition += " batch=" + batch + " and "; } if (isRepeat != 2) { condition += " isRepeat=" + isRepeat + " and "; } condition += " (batch like '%" + search + "%' or couponNo like '%" + search + "%' )"; var listAll = CacheHelper.GetDistinctCount <Coupon>("Coupon", condition); if (listAll.Count < 1) { return(JsonHelperHere.EmptyJson()); } //分页 var ids = listAll.Skip((index - 1) * size).Take(size).Select(p => p.id).ToArray(); if (ids.Length < 1) { return(JsonHelperHere.EmptyJson()); } var idsStr = string.Join(",", ids); //查具体信息 var viewList = CacheHelper.GetByCondition <Coupon>("Coupon", " id in (" + idsStr + ")"); var count = listAll.Count; pages = count / size; //总页数 pages = pages * size == count ? pages : pages + 1; var listR = new List <CouponRes>(); foreach (var item in viewList) { CouponRes t = new CouponRes(item, days); listR.Add(t); } return(JsonHelperHere.JsonAddPage(pages, JsonConvert.SerializeObject(listR.OrderByDescending(p => p.id)), index)); }
public string delete(webReq req) { var id = req.id; Platform pf = new Platform(); pf.id = id; pf.isDeleted = true; PlatformOper.Instance.Update(pf); return(JsonHelperHere.JsonMsg(true, "")); }
public string DownArticle(webReq req) { ArticleInfo article = new ArticleInfo(); article.id = req.articleId; article.status = false; article.lastTime = DateTime.Now; ArticleInfoOper.Instance.Update(article); return(JsonHelperHere.JsonMsg(true, "已撤下")); }
public string Get(webReq req) { var status = req.status; string search = req.search == null ? "" : req.search; //搜索内容 int index = Convert.ToInt32(req.index); //页码 int articleType = Convert.ToInt32(req.articleType); int pages = 0; //总页数 int size = 12; //一页size条数据 var condition = " isdeleted=0 "; if (articleType != 2) { condition += " and isarticle = " + articleType; } if (status != 2) { condition += " and status = " + status; } condition += " and ( articleName like '%" + search + "%' or content like '%" + search + "%' )"; string str = "select id,lasttime,status from articleInfo where " + condition + " order by status desc,lastTime desc"; var listAll = SqlHelperHere.ExecuteGetList <ArticleInfo>(str); if (listAll.Count < 1) { return(JsonHelperHere.EmptyJson()); } var ids = listAll.Skip((index - 1) * size).Take(size).Select(p => p.id).ToArray(); if (ids.Count() < 1) { return(JsonHelperHere.EmptyJson()); } var idsStr = string.Join(",", ids); var list = CacheHelper.GetByCondition <ArticleView>("ArticleView", " id in (" + idsStr + ")"); var count = listAll.Count; pages = count / size; //总页数 pages = pages * size == count ? pages : pages + 1; var listR = new List <ArticleViewForWeb>(); foreach (var item in list) { ArticleViewForWeb temp = new ArticleViewForWeb(item); listR.Add(temp); } return(JsonHelperHere.JsonAddPage(pages, JsonConvert.SerializeObject(listR.OrderByDescending(p => p.status).ThenBy(p => p.lastTime)), index)); }
public string GetDownloadList(webReq req) { ResultForWeb r = new ResultForWeb { HttpCode = 200, Message = "", data = "{}" }; string search = req.search == null ? "" : req.search; //搜索内容 int index = Convert.ToInt32(req.index); //页码 int pages = 0; //总页数 int size = 12; //一页size条数据 var isRepeat = Convert.ToInt32(req.isRepeat); var condition = " "; if (isRepeat != 2) { condition += " isRepeat=" + isRepeat + " and "; } condition += " 1=1 and name like '%" + search + "%' "; string str = "select * from couponView where " + condition + " order by createTime desc"; var listAll = SqlHelperHere.ExecuteGetList <CouponView>(str); if (listAll.Count < 1) { r.data = JsonHelperHere.EmptyJson(); return(JsonConvert.SerializeObject(r)); } //分页 var list2 = listAll.Skip((index - 1) * size).Take(size).ToArray(); if (list2.Length < 1) { r.data = JsonHelperHere.EmptyJson(); return(JsonConvert.SerializeObject(r)); } var count = listAll.Count; pages = count / size; //总页数 pages = pages * size == count ? pages : pages + 1; var listR = new List <DownList>(); foreach (var item in list2) { DownList d = new DownList(item); listR.Add(d); } r.data = JsonHelperHere.JsonAddPage(pages, JsonConvert.SerializeObject(listR), index); return(JsonConvert.SerializeObject(r)); }
/// <summary> /// 获取周标签 /// </summary> /// <returns></returns> public string GetWeekTags(webReq req) { ResultForWeb r = new ResultForWeb { HttpCode = 200, Message = "", data = "{}" }; var list = CacheHelper.GetByCondition <FoodTagInfo>("foodtaginfo", " isdeleted=0 and isWeek=1"); r.data = JsonHelperHere.JsonPlus(true, JsonConvert.SerializeObject(list), ""); return(JsonConvert.SerializeObject(r)); }
public string Get(webReq req) { ResultForWeb r = new ResultForWeb { HttpCode = 200, Message = "", data = "{}" }; var riderType = req.riderType; var areaId = req.areaId; Dictionary <int, string> dict = AreaInfoOper.Instance.GetAreaDict(); string search = req.search ?? ""; //搜索内容 int index = Convert.ToInt32(req.index); //页码 int pages = 0; //总页数 int size = 12; //一页size条数据 var condition = " 1=1 and "; if (riderType != 3) { condition += " ridertype=" + riderType + " and"; } if (areaId != 0) { condition += " riderareaid=" + areaId + " and"; } condition += " ( rideraccount like '%" + search + "%' or name like '%" + search + "%' or areaname like '%" + search + "%' or mapaddress like '%" + search + "%' )"; var listAll = CacheHelper.GetDistinctCount <RiderView>("RiderView", condition); if (listAll.Count < 1) { r.data = JsonHelperHere.EmptyJson(); return(JsonConvert.SerializeObject(r)); } var ids = listAll.Skip((index - 1) * size).Take(size).Select(p => p.id).ToArray(); var idsStr = string.Join(",", ids); var viewList = CacheHelper.GetByCondition <RiderView>("RiderView", " id in (" + idsStr + ")"); var count = listAll.Count; pages = count / size; pages = pages * size == count ? pages : pages + 1;//总页数 r.data = JsonHelperHere.JsonAddPage(pages, JsonConvert.SerializeObject(viewList.OrderByDescending(p => p.id)), index); return(JsonConvert.SerializeObject(r)); }
public string GetDownloadList(webReq req) { string search = Request["search"] == null ? "" : Request["search"]; //搜索内容 int index = Convert.ToInt32(Request["index"]); //页码 int pages = 0; //总页数 int size = 12; //一页size条数据 var isRepeat = Convert.ToInt32(req.isRepeat); var condition = " "; if (isRepeat != 2) { condition += " isRepeat=" + isRepeat + " and "; } condition += " 1=1 and name like '%" + search + "%' "; string str = "select * from couponView where " + condition + " order by createTime desc"; var listAll = SqlHelperHere.ExecuteGetList <CouponView>(str); if (listAll.Count < 1) { return(JsonHelperHere.EmptyJson()); } //分页 var list2 = listAll.Skip((index - 1) * size).Take(size).ToArray(); if (list2.Length < 1) { return(JsonHelperHere.EmptyJson()); } //var idsStr = string.Join(",", ids); //查具体信息 //var viewList = CacheHelper.GetByCondition<CouponView>("CouponView", " name in (" + idsStr + ")"); var count = listAll.Count; pages = count / size; //总页数 pages = pages * size == count ? pages : pages + 1; var listR = new List <DownList>(); foreach (var item in list2) { DownList d = new DownList(item); listR.Add(d); } return(JsonHelperHere.JsonAddPage(pages, JsonConvert.SerializeObject(listR), index)); }
/// <summary> /// 后台指派订单给骑手 /// </summary> public string AssignRider(webReq req) { var orderId = req.orderId; var riderId = req.riderId; //var orderId = Convert.ToInt32(Request["orderId"]); //var riderId = Convert.ToInt32(Request["riderId"]); var msg = OrderInfoOper.Instance.AssignRider(orderId, riderId); if (msg != "") { return(JsonHelperHere.JsonMsg(false, msg)); } return(JsonHelperHere.JsonMsg(true, msg)); }
public string Get(webReq req) { ResultForWeb r = new ResultForWeb(); r.HttpCode = 200; r.Message = ""; r.data = "{}"; if (Session["pfId"] == null) { r.HttpCode = 300; return(JsonConvert.SerializeObject(r)); } string search = req.search ?? ""; //搜索内容 int index = Convert.ToInt32(req.index); //页码 int pages = 0; //总页数 int size = 12; //一页size条数据 var condition = " type = 99 and status = 0 "; condition += " and (takeTypeName like '%" + search + "%' or username like '%" + search + "%' or userphone like '%" + search + "%' ) order by createTime desc "; string str = "select distinct id,createTime from userpayview where 1=1 and " + condition; var dt = SqlHelperHere.ExecuteGetDt(str); var listAll = dt.ConvertToList <UserPayView>(); var ids = listAll.Skip((index - 1) * size).Take(size).Select(p => p.id).ToArray(); var idsStr = string.Join(",", ids); var viewList = CacheHelper.GetByCondition <UserPayView>("UserPayView", " id in (" + idsStr + ")"); var count = listAll.Count; pages = count / size; pages = pages * size == count ? pages : pages + 1;//总页数 var listR = new List <UserPayViewRes>(); foreach (var item in viewList) { UserPayViewRes temp = new UserPayViewRes(item); listR.Add(temp); } r.data = JsonHelperHere.JsonAddPage(pages, JsonConvert.SerializeObject(listR.OrderByDescending(p => p.id)), index); return(JsonConvert.SerializeObject(r)); }
public string Get(webReq req) { ResultForWeb r = new ResultForWeb { HttpCode = 200, Message = "", data = "{}" }; var riderId = Convert.ToInt32(req.riderId); Dictionary <int, string> dict = FoodTagInfoOper.Instance.GetFoodTypeDict(); string search = req.search ?? ""; //搜索内容 int index = Convert.ToInt32(req.index); //页码 int pages = 0; //总页数 int size = 14; //一页size条数据 //查询条件 var condition = " riderId = " + riderId + " and foodName like '%" + search + "%' "; //所有符合条件的记录的id var listAll = CacheHelper.GetDistinctCount <RiderStockView>("RiderStockView", condition); if (listAll.Count < 1) { r.data = JsonHelperHere.EmptyJson(); return(JsonConvert.SerializeObject(r)); } //分页 var ids = listAll.Skip((index - 1) * size).Take(size).Select(p => p.id).ToArray(); var idsStr = string.Join(",", ids); //查具体信息 var viewList = CacheHelper.GetByCondition <RiderStockView>("RiderStockView", " id in (" + idsStr + ")"); List <RiderStockView> list = (List <RiderStockView>)CacheHelper.Get <RiderStockView>("RiderStockView", "Ta_RiderStockView"); list = list.OrderByDescending(p => p.id).Where(p => p.riderId == riderId && p.foodName.Contains(search)).ToList(); pages = list.Count / size; pages = pages * size == list.Count ? pages : pages + 1;//总页数 list = list.Skip((index - 1) * size).Take(size).ToList(); r.data = JsonHelperHere.JsonAddPage(pages, JsonConvert.SerializeObject(list), index); return(JsonConvert.SerializeObject(r)); }
/// <summary> /// 发布文章 /// </summary> /// <param name="req"></param> /// <returns></returns> public string UpArticle(webReq req) { var id = req.articleId; var articleTemp = ArticleInfoOper.Instance.GetById(id); if ((bool)articleTemp.status) { return(JsonHelperHere.JsonMsg(false, "不能重复发布")); } var article = new ArticleInfo(); article.id = id; article.status = true; article.lastTime = DateTime.Now; //article.status = true; //article.lastTime = DateTime.Now; ArticleInfoOper.Instance.Update(article); CacheHelper.SetAllUserArticleNotClick(); return(JsonHelperHere.JsonMsg(true, "发布成功")); }
//public ActionResult _Login() { // LoginOut // return View("_Login"); //} public string Login(webReq req) { var account = req.pAccount; var pwd = req.pPwd; var pf = PlatformOper.Instance.GetByAccount(account); if (pf == null) { return(JsonHelperHere.JsonMsg(false, "没有这个账号")); } if (pf.pwd != pwd) { return(JsonHelperHere.JsonMsg(false, "密码错误")); } Session.Timeout = 60; Session["pfId"] = pf.id; Session["lv"] = pf.level; return(JsonHelperHere.JsonMsg(true, "登录成功")); }
public string Update(webReq req) { string tempImg = req.tempImg; FoodInfo food = new FoodInfo(); var foodName = req.foodName; var foodId = req.foodId; food.foodName = foodName; food.foodPrice = Convert.ToDecimal(req.foodPrice); food.foodTagId = Convert.ToInt32(req.foodTypeId); food.foodImg = req.foodImg; food.foodText = req.foodText; food.id = Convert.ToInt32(foodId); var stars = Convert.ToDecimal(req.foodStars); stars = stars < 0 ? 0 : stars; stars = stars > 5 ? 5 : stars; food.star = stars; //if (req.isCycle == "0") // food.isCycle = false; //else // food.isCycle = true; food.deposit = Convert.ToDecimal(req.deposit); if (req.isMain == "0") { food.isMain = false; } else { food.isMain = true; } food.secondTag = Convert.ToInt32(req.secondTag); FoodInfoOper.Instance.Update(food); ControllerHelper.Instance.CopyFile(this.Server.MapPath(tempImg), this.Server.MapPath(food.foodImg)); return(JsonHelperHere.JsonMsg(true, "")); }
/// <summary> /// 后台同意骑手取消 /// </summary> /// <returns></returns> public string AgreeRiderCancel(webReq req) { ResultForWeb r = new ResultForWeb { HttpCode = 200, Message = "", data = "{}" }; var orderId = req.orderId; var order = OrderInfoOper.Instance.GetById(orderId); if (order.status != 99) { r.Message = "订单状态已改变,不再需要取消"; r.HttpCode = 500; return(JsonConvert.SerializeObject(r)); } order.status = 5; OrderInfoOper.Instance.Update(order); OrderInfoOper.Instance.OrderCancelDoMoney(order); UPushHelper.Instance.PushUserOrderCancel(order); //用户取消订单,菜品返还给骑手 var list = OrderFoodsOper.Instance.GetByOrderId(order.id); var listFoods = new List <foodId_Amount>(); foreach (var item in list) { foodId_Amount fa = new foodId_Amount(item); listFoods.Add(fa); } RiderStockOper.Instance.AddRs((int)order.riderId, listFoods); r.data = JsonHelperHere.JsonMsg(true, ""); return(JsonConvert.SerializeObject(r)); }
public string Add(webReq req) { FoodTagInfo tag = new FoodTagInfo(); tag.foodTagName = req.foodTagName; string name = req.foodTagName; if (ControllerHelper.Instance.IsExists("foodtaginfo", "foodTagName", name, "0")) { return(JsonHelperHere.JsonMsg(false, "已存在该标签")); } bool isWeek = true; if (Request["isWeek"] == "0") { isWeek = false; } tag.isWeek = isWeek; FoodTagInfoOper.Instance.Add(tag); return(JsonHelperHere.JsonMsg(true, "")); }
public string Update(webReq req) { FoodTagInfo tag = new FoodTagInfo(); var tagId = Convert.ToInt32(req.foodTagId); tag.foodTagName = req.foodTagName; var name = req.foodTagName; if (ControllerHelper.Instance.IsExists("foodtaginfo", "foodTagName", name, tagId.ToString())) { return(JsonHelperHere.JsonMsg(false, "已存在该标签")); } bool isWeek = true; if (Request["isWeek"] == "0") { isWeek = false; } tag.isWeek = isWeek; tag.id = tagId; FoodTagInfoOper.Instance.Update(tag); return(JsonHelperHere.JsonMsg(true, "")); }
public string Update(webReq req) { var pwd = req.pwd; if (!StringHelperHere.Instance.IsPwdValidate(pwd)) { return(JsonHelperHere.JsonMsg(false, "密码应为6~16位英文字母、数字")); } var riderId = req.riderId; var lat = req.lat; var lng = req.lng; var mapAddress = req.mapAddress; var riderType = req.riderType; var account = req.account; var riderName = req.riderName; var status = req.status; var areaId = req.riderAreaId; var stars = req.stars; stars = stars < 0 ? 0 : stars; stars = stars > 5 ? 5 : stars; var phone = req.phone; var starCount = req.starCount; var sendCount = req.sendCount; if (RiderInfoOper.Instance.IsHaveAccount(account, riderId)) { return(JsonHelperHere.JsonMsg(false, "已存在这个账号")); } RiderInfo rider = new RiderInfo(); rider.riderAccount = account; rider.riderPwd = pwd; rider.riderType = riderType; rider.riderStatus = Convert.ToBoolean(status); rider.name = riderName; rider.riderAreaId = areaId; rider.id = riderId; rider.phone = phone; rider.avgStars = stars; rider.starCount = starCount; rider.sendCount = sendCount; if (riderType == 2) { rider.lat = lat; rider.lng = lng; rider.mapAddress = mapAddress; var ua = UserAddressOper.Instance.GetByRiderId(riderId); if (ua == null) { ua = new UserAddress(); ua.riderId = riderId; ua.lat = lat; ua.lng = lng; ua.mapAddress = mapAddress; ua.phone = phone; UserAddressOper.Instance.Add(ua); } else { ua.lat = lat; ua.lng = lng; ua.mapAddress = mapAddress; ua.phone = phone; UserAddressOper.Instance.Update(ua); } } else { rider.lat = ""; rider.lng = ""; rider.mapAddress = ""; } RiderInfoOper.Instance.Update(rider); var temp = CacheHelper.GetRiderPosition(riderId); if (riderType != 2) { CacheHelper.SetRiderPosition(riderId, temp.lat, temp.lng, riderType); } else { CacheHelper.SetRiderPosition(riderId, lat, lng, riderType); } return(JsonHelperHere.JsonMsg(true, "")); }
/// <summary> /// 获取周标签 /// </summary> /// <returns></returns> public string GetWeekTags(webReq req) { var list = CacheHelper.GetByCondition <FoodTagInfo>("foodtaginfo", " isdeleted=0 and isWeek=1"); return(JsonHelperHere.JsonPlus(true, JsonConvert.SerializeObject(list), "")); }
public string Get(webReq req)//返回的类型要改一下的 { ResultForWeb r = new ResultForWeb(); r.HttpCode = 200; r.Message = ""; r.data = "{}"; if (Session["pfId"] == null) { r.HttpCode = 300; return(JsonConvert.SerializeObject(r)); } string search = req.search == null ? "" : req.search; int index = req.index; int pages = 0; //总页数 int size = 12; //一页size条数据 var time1 = req.time1; var time2 = req.time2; int pageType = req.pageType; #region 用户信息 if (pageType == 0) { var condition = " isdeleted=0 and (username like '%" + search + "%' or userphone like '%" + search + "%' )"; var listAll = CacheHelper.GetDistinctCount <UserInfo>("UserInfo", condition); if (listAll.Count < 1) { r.data = JsonHelperHere.EmptyJson(); return(JsonConvert.SerializeObject(r)); } //分页 var ids = listAll.Skip((index - 1) * size).Take(size).Select(p => p.id).ToArray(); var idsStr = string.Join(",", ids); var viewList = CacheHelper.GetByCondition <UserInfo>("UserInfo", " id in (" + idsStr + ") order by id desc"); var count = listAll.Count; pages = count / size; //总页数 pages = pages * size == count ? pages : pages + 1; var listR = new List <UserWebRes>(); foreach (var item in viewList) { UserWebRes user = new UserWebRes(item); listR.Add(user); } r.data = JsonHelperHere.JsonAddPage(pages, JsonConvert.SerializeObject(listR), index); return(JsonConvert.SerializeObject(r)); } #endregion #region 用户使用app信息 else if (pageType == 1) { var condition = " 1=1 and ( username like '%" + search + "%') and openTime>'" + time1 + "' and openTime<'" + time2 + "'"; var listAll = CacheHelper.GetDistinctCount <UserOpenView>("UserOpenView", condition); if (listAll.Count < 1) { r.data = JsonHelperHere.EmptyJson(); return(JsonConvert.SerializeObject(r)); } //分页 var ids = listAll.Skip((index - 1) * size).Take(size).Select(p => p.id).ToArray(); var idsStr = string.Join(",", ids); var viewList = CacheHelper.GetByCondition <UserOpenView>("UserOpenView", " id in (" + idsStr + ") order by id desc"); var count = listAll.Count; pages = count / size; //总页数 pages = pages * size == count ? pages : pages + 1; var listR = new List <UserOpenInfoForWeb>(); foreach (var item in viewList) { UserOpenInfoForWeb temp = new UserOpenInfoForWeb(item); listR.Add(temp); } r.data = JsonHelperHere.JsonAddPage(pages, JsonConvert.SerializeObject(listR), index); return(JsonConvert.SerializeObject(r)); } #endregion #region 用户建议 else if (pageType == 2) { var condition = " isdeleted=0 and ( content like '%" + search + "%' or username like '%" + search + "%') and sTime>'" + time1 + "' and sTime<'" + time2 + "'"; var listAll = CacheHelper.GetDistinctCount <SuggestionView>("SuggestionView", condition); if (listAll.Count < 1) { r.data = JsonHelperHere.EmptyJson(); return(JsonConvert.SerializeObject(r)); } //分页 var ids = listAll.Skip((index - 1) * size).Take(size).Select(p => p.id).ToArray(); var idsStr = string.Join(",", ids); var viewList = CacheHelper.GetByCondition <SuggestionView>("SuggestionView", " id in (" + idsStr + ") order by id desc"); var count = listAll.Count; pages = count / size; //总页数 pages = pages * size == count ? pages : pages + 1; var listR = new List <SuggestionRes>(); foreach (var item in viewList) { SuggestionRes t = new SuggestionRes(item); listR.Add(t); } r.data = JsonHelperHere.JsonAddPage(pages, JsonConvert.SerializeObject(listR.OrderByDescending(p => p.id)), index); return(JsonConvert.SerializeObject(r)); } #endregion r.data = JsonHelperHere.EmptyJson(); return(JsonConvert.SerializeObject(r)); }
public string Get(webReq req) { ResultForWeb r = new ResultForWeb { HttpCode = 200, Message = "", data = "{}" }; FoodInfoOper.Instance.ClearWeekFood(); var isOn = req.isOn; var orderStr = req.orderStr; var desc = req.desc; var isDeleted = req.isDeleted; Dictionary <int, string> dict = FoodTagInfoOper.Instance.GetFoodTypeDict(); string search = req.search == null ? "" : req.search;//搜索内容 string isWeekTemp = req.isWeek; var isMainTemp = req.isMain; var weekTag = req.weekTag; var isDeposit = req.isDeposit; int index = req.index; //页码 int pages = 0; //总页数 int size = 12; //一页size条数据 //查询条件 var condition = " 1=1 and (foodname like '%" + search + "%' or foodText like '%" + search + "%' or foodTagName like '%" + search + "%') "; if (!string.IsNullOrEmpty(isMainTemp)) { var isMain = 0; if (isMainTemp == "true") { isMain = 1; } condition += " and ismain=" + isMain; } if (!string.IsNullOrEmpty(isWeekTemp) && isWeekTemp != "2") { condition += " and isweek=" + isWeekTemp; if (isWeekTemp == "1" && isOn != 2) { condition += " and isOn=" + isOn; } } //else condition += " and isdeleted=0 "; if (!string.IsNullOrEmpty(isWeekTemp) && isWeekTemp != "0") { if (weekTag != 0) { condition += " and foodTagId=" + weekTag; } } if (isDeposit == 1) { condition += " and deposit>0"; } else if (isDeposit == 0) { condition += " and deposit=0"; } string str = "select id,isdeleted from foodview where " + condition; string order = " order by isdeleted,id desc"; if (string.IsNullOrEmpty(orderStr)) { str += order; } else { order = " order by " + orderStr; if (desc == 1) { order += " desc"; } order += " ,isdeleted,id desc"; str += order; } var dt = SqlHelperHere.ExecuteGetDt(str); var listAll = dt.ConvertToList <FoodView>(); if (listAll.Count < 1) { r.data = JsonHelperHere.EmptyJson(); return(JsonConvert.SerializeObject(r)); } //分页 var ids = listAll.Skip((index - 1) * size).Take(size).Select(p => p.id).ToArray(); var idsStr = string.Join(",", ids); var viewList = CacheHelper.GetByCondition <FoodView>("FoodView", " id in (" + idsStr + ") " + order); var count = listAll.Count; pages = count / size; //总页数 pages = pages * size == count ? pages : pages + 1; r.data = JsonHelperHere.JsonAddPage(pages, JsonConvert.SerializeObject(viewList), index); return(JsonConvert.SerializeObject(r)); }
/// <summary> /// 根据条件在OrderTryJoin里找到所有的,并distinct出当前页的那些orderid,再去ordertryjoin里找 /// </summary> /// <returns></returns> public string Get(webReq req) { ResultForWeb r = new ResultForWeb { HttpCode = 200, Message = "", data = "{}" }; string search = req.search == null ? "" : req.search; //搜索内容 int index = Convert.ToInt32(req.index); //页码 var status = Convert.ToInt32(req.status); //var condition = ""; int pages = 0; //总页数 int size = 12; //一页size条数据 var isActual = Convert.ToInt32(req.isActual); var condition = " 1=1 and "; if (isActual == 1) { condition += " isactual=1 and"; } else if (isActual == 0) { condition += " isactual=0 and"; } #region 全部或者未支付 if (status == 100 || status == 0)//未支付和全部 { OrderInfoOper.Instance.RemoveOverTime(); var listR = new List <OrderNotPayRes>(); if (status == 0) { condition += " status = 0 and "; } condition += " (orderno='" + search + "' or username like '%" + search + "%' or foodname like '%" + search + "%' or areaname like '%" + search + "%' or mapaddress like '%" + search + "%' or contactPhone like '%" + search + "%' )"; var listAll = CacheHelper.GetDistinctCount <OrderTryJoin>("OrderTryJoin", condition); if (listAll.Count < 1) { r.data = JsonHelperHere.EmptyJson(); return(JsonConvert.SerializeObject(r)); } var ids = listAll.Skip((index - 1) * size).Take(size).Select(p => p.id).ToArray(); var idsStr = string.Join(",", ids); var viewList = CacheHelper.GetByCondition <OrderTryJoin>("OrderTryJoin", " id in (" + idsStr + ")"); foreach (var item in ids) { var listTemp = viewList.Where(p => p.orderId == item).ToList(); OrderNotPayRes res = new OrderNotPayRes(listTemp); listR.Add(res); } var count = listAll.Count; pages = count / size; pages = pages * size == count ? pages : pages + 1;//总页数 //listR = listR.Skip((index - 1) * size).Take(size).ToList(); r.data = JsonHelperHere.JsonAddPage(pages, JsonConvert.SerializeObject(listR), index); return(JsonConvert.SerializeObject(r)); } #endregion #region 待接单 else if (status == 1) {//待接单 var listR = new List <OrderWaitRes>(); //查询条件 condition += " status = 1 and (orderno='" + search + "' or username like '%" + search + "%' or foodname like '%" + search + "%' or areaname like '%" + search + "%' or mapaddress like '%" + search + "%' or contactPhone like '%" + search + "%' )"; //所有符合条件的记录的id var listAll = CacheHelper.GetDistinctCount <OrderTryJoin>("OrderTryJoin", condition); if (listAll.Count < 1) { r.data = JsonHelperHere.EmptyJson(); return(JsonConvert.SerializeObject(r)); } //分页 var ids = listAll.Skip((index - 1) * size).Take(size).Select(p => p.id).ToArray(); var idsStr = string.Join(",", ids); //查具体信息 var viewList = CacheHelper.GetByCondition <OrderTryJoin>("OrderTryJoin", " id in (" + idsStr + ")"); foreach (var item in ids) { var listTemp = viewList.Where(p => p.orderId == item).ToList(); OrderWaitRes res = new OrderWaitRes(listTemp); listR.Add(res); } //总共多少条记录 var count = listAll.Count; pages = count / size; //总页数 pages = pages * size == count ? pages : pages + 1; r.data = JsonHelperHere.JsonAddPage(pages, JsonConvert.SerializeObject(listR), index); return(JsonConvert.SerializeObject(r)); } #endregion #region 配送中 else if (status == 2) {//配送中 var listR = new List <OrderSendingWebRes>(); //查询条件 condition += " status = 2 and (orderno='" + search + "' or username like '%" + search + "%' or foodname like '%" + search + "%' or areaname like '%" + search + "%' or mapaddress like '%" + search + "%' or contactPhone like '%" + search + "%' or riderName like '%" + search + "%')"; //所有符合条件的记录的id var listAll = CacheHelper.GetDistinctCount <OrderTryJoin>("OrderTryJoin", condition); if (listAll.Count < 1) { r.data = JsonHelperHere.EmptyJson(); return(JsonConvert.SerializeObject(r)); } //分页 var ids = listAll.Skip((index - 1) * size).Take(size).Select(p => p.id).ToArray(); var idsStr = string.Join(",", ids); //查具体信息 var viewList = CacheHelper.GetByCondition <OrderTryJoin>("OrderTryJoin", " id in (" + idsStr + ")"); foreach (var item in ids) { var listTemp = viewList.Where(p => p.orderId == item).ToList(); OrderSendingWebRes res = new OrderSendingWebRes(listTemp); listR.Add(res); } //总共多少条记录 var count = listAll.Count; pages = count / size; //总页数 pages = pages * size == count ? pages : pages + 1; r.data = JsonHelperHere.JsonAddPage(pages, JsonConvert.SerializeObject(listR), index); return(JsonConvert.SerializeObject(r)); } #endregion #region 已送达 else if (status == 3) { var listR = new List <OrderArrivalRes>(); //查询条件 condition += " status in (3) and (orderno='" + search + "' or username like '%" + search + "%' or foodname like '%" + search + "%' or areaname like '%" + search + "%' or mapaddress like '%" + search + "%' or contactPhone like '%" + search + "%' or riderName like '%" + search + "%')"; //所有符合条件的记录的id var listAll = CacheHelper.GetDistinctCount <OrderTryJoin>("OrderTryJoin", condition); if (listAll.Count < 1) { r.data = JsonHelperHere.EmptyJson(); return(JsonConvert.SerializeObject(r)); } //分页 var ids = listAll.Skip((index - 1) * size).Take(size).Select(p => p.id).ToArray(); var idsStr = string.Join(",", ids); //查具体信息 var viewList = CacheHelper.GetByCondition <OrderTryJoin>("OrderTryJoin", " id in (" + idsStr + ")"); foreach (var item in ids) { var listTemp = viewList.Where(p => p.orderId == item).ToList(); OrderArrivalRes res = new OrderArrivalRes(listTemp); listR.Add(res); } //总共多少条记录 var count = listAll.Count; pages = count / size; //总页数 pages = pages * size == count ? pages : pages + 1; r.data = JsonHelperHere.JsonAddPage(pages, JsonConvert.SerializeObject(listR), index); return(JsonConvert.SerializeObject(r)); } #endregion #region 已评论 else if (status == 7) { var listR = new List <OrderArrivalRes>(); //查询条件 condition += " status in (7) and (orderno='" + search + "' or username like '%" + search + "%' or foodname like '%" + search + "%' or areaname like '%" + search + "%' or mapaddress like '%" + search + "%' or contactPhone like '%" + search + "%' or riderName like '%" + search + "%')"; //所有符合条件的记录的id var listAll = CacheHelper.GetDistinctCount <OrderTryJoin>("OrderTryJoin", condition); if (listAll.Count < 1) { r.data = JsonHelperHere.EmptyJson(); return(JsonConvert.SerializeObject(r)); } //分页 var ids = listAll.Skip((index - 1) * size).Take(size).Select(p => p.id).ToArray(); var idsStr = string.Join(",", ids); //查具体信息 var viewList = CacheHelper.GetByCondition <OrderTryJoin>("OrderTryJoin", " id in (" + idsStr + ")"); foreach (var item in ids) { var listTemp = viewList.Where(p => p.orderId == item).ToList(); OrderArrivalRes res = new OrderArrivalRes(listTemp); listR.Add(res); } //总共多少条记录 var count = listAll.Count; pages = count / size; //总页数 pages = pages * size == count ? pages : pages + 1; r.data = JsonHelperHere.JsonAddPage(pages, JsonConvert.SerializeObject(listR), index); return(JsonConvert.SerializeObject(r)); } #endregion #region 取消订单 else if (status == 5) {//用户取消 var listR = new List <OrderCancelledRes>(); //查询条件 condition += " status =5 and (orderno='" + search + "' or username like '%" + search + "%' or foodname like '%" + search + "%' or contactPhone like '%" + search + "%')"; //所有符合条件的记录的id var listAll = CacheHelper.GetDistinctCount <OrderTryJoin>("OrderTryJoin", condition); if (listAll.Count < 1) { r.data = JsonHelperHere.EmptyJson(); return(JsonConvert.SerializeObject(r)); } //分页 var ids = listAll.Skip((index - 1) * size).Take(size).Select(p => p.id).ToArray(); var idsStr = string.Join(",", ids); //查具体信息 var viewList = CacheHelper.GetByCondition <OrderTryJoin>("OrderTryJoin", " id in (" + idsStr + ")"); foreach (var item in ids) { var listTemp = viewList.Where(p => p.orderId == item).ToList(); OrderCancelledRes res = new OrderCancelledRes(listTemp); listR.Add(res); } //总共多少条记录 var count = listAll.Count; pages = count / size; //总页数 pages = pages * size == count ? pages : pages + 1; r.data = JsonHelperHere.JsonAddPage(pages, JsonConvert.SerializeObject(listR), index); return(JsonConvert.SerializeObject(r)); } #endregion #region 骑手申请取消 else if (status == 99) { var listR = new List <OrderSendingWebRes>(); //查询条件 condition += " status =99 and (orderno='" + search + "' or username like '%" + search + "%' or foodname like '%" + search + "%' or contactPhone like '%" + search + "%')"; //所有符合条件的记录的id var listAll = CacheHelper.GetDistinctCount <OrderTryJoin>("OrderTryJoin", condition); if (listAll.Count < 1) { r.data = JsonHelperHere.EmptyJson(); return(JsonConvert.SerializeObject(r)); } //分页 var ids = listAll.Skip((index - 1) * size).Take(size).Select(p => p.id).ToArray(); var idsStr = string.Join(",", ids); //查具体信息 var viewList = CacheHelper.GetByCondition <OrderTryJoin>("OrderTryJoin", " id in (" + idsStr + ")"); foreach (var item in ids) { var listTemp = viewList.Where(p => p.orderId == item).ToList(); OrderSendingWebRes res = new OrderSendingWebRes(listTemp); listR.Add(res); } //总共多少条记录 var count = listAll.Count; pages = count / size; //总页数 pages = pages * size == count ? pages : pages + 1; r.data = JsonHelperHere.JsonAddPage(pages, JsonConvert.SerializeObject(listR), index); return(JsonConvert.SerializeObject(r)); } #endregion #region 待回收 else if (status == 8) {//已送达和已评论 3和7都要 var listR = new List <OrderArrivalRes>(); //查询条件 condition += " status in (8) and (orderno='" + search + "' or username like '%" + search + "%' or foodname like '%" + search + "%' or areaname like '%" + search + "%' or mapaddress like '%" + search + "%' or contactPhone like '%" + search + "%' or riderName like '%" + search + "%')"; //所有符合条件的记录的id var listAll = CacheHelper.GetDistinctCount <OrderTryJoin>("OrderTryJoin", condition); if (listAll.Count < 1) { r.data = JsonHelperHere.EmptyJson(); return(JsonConvert.SerializeObject(r)); } //分页 var ids = listAll.Skip((index - 1) * size).Take(size).Select(p => p.id).ToArray(); var idsStr = string.Join(",", ids); //查具体信息 var viewList = CacheHelper.GetByCondition <OrderTryJoin>("OrderTryJoin", " id in (" + idsStr + ")"); foreach (var item in ids) { var listTemp = viewList.Where(p => p.orderId == item).ToList(); OrderArrivalRes res = new OrderArrivalRes(listTemp); listR.Add(res); } //总共多少条记录 var count = listAll.Count; pages = count / size; //总页数 pages = pages * size == count ? pages : pages + 1; r.data = JsonHelperHere.JsonAddPage(pages, JsonConvert.SerializeObject(listR), index); return(JsonConvert.SerializeObject(r)); } #endregion #region 回收中 else if (status == 9) {//已送达和已评论 3和7都要 var listR = new List <OrderArrivalRes>(); //查询条件 condition += " status in (9) and (orderno='" + search + "' or username like '%" + search + "%' or foodname like '%" + search + "%' or areaname like '%" + search + "%' or mapaddress like '%" + search + "%' or contactPhone like '%" + search + "%' or riderName like '%" + search + "%')"; //所有符合条件的记录的id var listAll = CacheHelper.GetDistinctCount <OrderTryJoin>("OrderTryJoin", condition); if (listAll.Count < 1) { r.data = JsonHelperHere.EmptyJson(); return(JsonConvert.SerializeObject(r)); } //分页 var ids = listAll.Skip((index - 1) * size).Take(size).Select(p => p.id).ToArray(); var idsStr = string.Join(",", ids); //查具体信息 var viewList = CacheHelper.GetByCondition <OrderTryJoin>("OrderTryJoin", " id in (" + idsStr + ")"); foreach (var item in ids) { var listTemp = viewList.Where(p => p.orderId == item).ToList(); OrderArrivalRes res = new OrderArrivalRes(listTemp); listR.Add(res); } //总共多少条记录 var count = listAll.Count; pages = count / size; //总页数 pages = pages * size == count ? pages : pages + 1; r.data = JsonHelperHere.JsonAddPage(pages, JsonConvert.SerializeObject(listR), index); return(JsonConvert.SerializeObject(r)); } #endregion return(null); }