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