/// <summary>
/// 后台删除某些菜品时，所有骑手库存都要删掉
/// </summary>
/// <param name="foodId"></param>
public void DeleteRsByFoodId(int[] foodIds)
{
var idsStr = string.Join(",", foodIds);
string str = " update riderstock set isdeleted=1 where foodId in (" + idsStr + ")";
SqlHelperHere.ExcuteNon(str);
}
/// <summary>
/// update
/// </summary>
/// <param name="txyInfo"></param>
/// <returns></returns>
public void Update(txyInfo model)
{
var str = GetUpdateStr(model);
var dict = GetParameters(model);
SqlHelperHere.ExcuteNon(str, dict);
}
public void DeleteByTs(string ts)
{
string str = "update coupon set isdeleted=1 where batch=@ts";
var dict = new Dictionary <string, string>();
dict.Add("@ts", ts);
SqlHelperHere.ExcuteNon(str, dict);
}
/// <summary>
/// update
/// </summary>
/// <param name="OrderFoods"></param>
/// <returns></returns>
public void Update(OrderFoods model)
{
//CacheHelper.LockCache("OrderFoods");
var str = GetUpdateStr(model);
var dict = GetParameters(model);
SqlHelperHere.ExcuteNon(str, dict);
//CacheHelper.ReleaseLock("OrderFoods");
}
/// <summary>
/// update
/// </summary>
/// <param name="RiderStock"></param>
/// <returns></returns>
public void Update(RiderStock model)
{
CacheHelper.LockCache("RiderStock");
var str = GetUpdateStr(model);
var dict = GetParameters(model);
SqlHelperHere.ExcuteNon(str, dict);
CacheHelper.ReleaseLock("RiderStock");
}
/// <summary>
/// update
/// </summary>
/// <param name="AllocateRecord"></param>
/// <returns></returns>
public void Update(AllocateRecord model)
{
CacheHelper.LockCache("AllocateRecord");
var str = GetUpdateStr(model);
var dict = GetParameters(model);
SqlHelperHere.ExcuteNon(str, dict);
CacheHelper.ReleaseLock("AllocateRecord");
}
/// <summary>
/// update
/// </summary>
/// <param name="ArticleInfo"></param>
/// <returns></returns>
public void Update(ArticleInfo model)
{
//CacheHelper.LockCache("ArticleInfo");
var str = GetUpdateStr(model);
var dict = GetParameters(model);
SqlHelperHere.ExcuteNon(str, dict);
//CacheHelper.ReleaseLock("ArticleInfo");
}
/// <summary>
/// update
/// </summary>
/// <param name="Suggestion"></param>
/// <returns></returns>
public void Update(Suggestion model)
{
//CacheHelper.LockCache("Suggestion");
var str = GetUpdateStr(model);
var dict = GetParameters(model);
SqlHelperHere.ExcuteNon(str, dict);
//CacheHelper.ReleaseLock("Suggestion");
}
/// <summary>
/// 增加骑手配送次数
/// </summary>
/// <param name="riderId"></param>
public void AddRiderSendCount(int riderId)
{
string str = "update RiderInfo set sendCount=sendCount+1 where id=" + riderId;
SqlHelperHere.ExcuteNon(str);
//var rider = GetById(riderId);
////rider.sendCount += 1;
//var riderHere = new RiderInfo();
//riderHere.id = riderId;
//riderHere.sendCount = rider.sendCount + 1;
//Update(riderHere);
}
public ActionResult Index()
{
if (Session["pfId"] != null)
{
var days = Convert.ToInt32(new SettingRes().couponSaveDays);
//过时的二维码图片和zip删掉
ControllerHelper.Instance.ClearTempQCode(this.Server.MapPath("/Img/coupon"), days);
//过时的优惠券删掉
string str = "update Coupon set isDeleted=1 where DATEDIFF(SECOND, createTime, GETDATE())>" + days * 24 * 3600;
SqlHelperHere.ExcuteNon(str);
var tsDict = CouponOper.Instance.GetTs();
ViewBag.tss = tsDict;
return(View());
}
else
{
return(View("_Login"));
}
}
/// <summary>
/// 后台删除某种菜品时，所有骑手库存都要删掉
/// </summary>
/// <param name="foodId"></param>
public void DeleteRsByFoodId(int foodId)
{
string str = " update riderstock set isdeleted=1 where foodId = " + foodId;
SqlHelperHere.ExcuteNon(str);
}