/// 获取参数 /// </summary> /// <param name="riderstock"></param> /// <returns></returns> public Dictionary <string, string> GetParameters(RiderStock riderstock) { Dictionary <string, string> dict = new Dictionary <string, string>(); if (riderstock.id != null) { dict.Add("@id", riderstock.id.ToString()); } if (riderstock.riderId != null) { dict.Add("@riderId", riderstock.riderId.ToString()); } if (riderstock.foodId != null) { dict.Add("@foodId", riderstock.foodId.ToString()); } if (riderstock.amount != null) { dict.Add("@amount", riderstock.amount.ToString()); } if (riderstock.isDeleted != null) { dict.Add("@isDeleted", riderstock.isDeleted.ToString()); } return(dict); }
/// <summary> /// 插入 /// </summary> /// <param name="riderstock"></param> /// <returns>是否成功</returns> public string GetInsertStr(RiderStock riderstock) { StringBuilder part1 = new StringBuilder(); StringBuilder part2 = new StringBuilder(); if (riderstock.riderId != null) { part1.Append("riderId,"); part2.Append("@riderId,"); } if (riderstock.foodId != null) { part1.Append("foodId,"); part2.Append("@foodId,"); } if (riderstock.amount != null) { part1.Append("amount,"); part2.Append("@amount,"); } if (riderstock.isDeleted != null) { part1.Append("isDeleted,"); part2.Append("@isDeleted,"); } StringBuilder sql = new StringBuilder(); sql.Append("insert into riderstock(").Append(part1.ToString().Remove(part1.Length - 1)).Append(") values (").Append(part2.ToString().Remove(part2.Length - 1)).Append(")"); return(sql.ToString()); }
/// <summary> /// 增加库存 /// </summary> /// <param name="riderId"></param> /// <param name="listFoods"></param> /// <returns></returns> public bool AddRs(int riderId, List <foodId_Amount> listFoods) { var list = CacheHelper.GetByCondition <RiderStock>("riderstock", " isdeleted=0 and riderid=" + riderId); foreach (var item in listFoods) { var temp = list.Where(p => p.foodId == item.foodId).ToList(); if (temp.Count < 1) { RiderStock r = new RiderStock { riderId = riderId, foodId = item.foodId, amount = item.amount }; Add(r); } else { var rs = temp.First(); rs.amount += item.amount; if (rs.amount < 0) { return(false); } Update(rs); } } return(true); }
/// <summary> /// add /// </summary> /// <param name="RiderStock"></param> /// <returns></returns> public int Add(RiderStock model) { var str = GetInsertStr(model) + " select @@identity"; var dict = GetParameters(model); return(Convert.ToInt32(SqlHelperHere.ExecuteScalar(str, dict))); }
/// <summary> /// 更新 /// </summary> /// <param name="riderstock"></param> /// <returns>是否成功</returns> public string GetUpdateStr(RiderStock riderstock) { StringBuilder part1 = new StringBuilder(); part1.Append("update riderstock set "); if (riderstock.riderId != null) { part1.Append("riderId = @riderId,"); } if (riderstock.foodId != null) { part1.Append("foodId = @foodId,"); } if (riderstock.amount != null) { part1.Append("amount = @amount,"); } if (riderstock.isDeleted != null) { part1.Append("isDeleted = @isDeleted,"); } int n = part1.ToString().LastIndexOf(","); part1.Remove(n, 1); part1.Append(" where id= @id "); return(part1.ToString()); }
public void Delete(int rsId) { RiderStock rs = new RiderStock(); rs.id = rsId; rs.isDeleted = true; Update(rs); }
/// <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"); }
public void Add(webReq req) { var riderId = Convert.ToInt32(Request["riderId"]); var foodId = Convert.ToInt32(Request["foodId"]); var amount = Convert.ToInt32(Request["amount"]); RiderStock rs = new RiderStock(); rs.foodId = foodId; rs.riderId = riderId; rs.amount = amount; RiderStockOper.Instance.Add(rs); }
public void Update(webReq req) { var id = Convert.ToInt32(Request["id"]); var foodId = Convert.ToInt32(Request["foodId"]); var amount = Convert.ToInt32(Request["amount"]); RiderStock rs = new RiderStock(); rs.id = id; rs.foodId = foodId; rs.amount = amount; RiderStockOper.Instance.Update(rs); }
public string Add(webReq req) { ResultForWeb r = new ResultForWeb { HttpCode = 200, Message = "", data = "{}" }; var riderId = Convert.ToInt32(req.riderId); var foodId = Convert.ToInt32(req.foodId); var amount = Convert.ToInt32(req.amount); RiderStock rs = new RiderStock(); rs.foodId = foodId; rs.riderId = riderId; rs.amount = amount; RiderStockOper.Instance.Add(rs); return(JsonConvert.SerializeObject(r)); }
public string Update(webReq req) { ResultForWeb r = new ResultForWeb { HttpCode = 200, Message = "", data = "{}" }; var id = Convert.ToInt32(req.id); var foodId = Convert.ToInt32(req.foodId); var amount = Convert.ToInt32(req.amount); RiderStock rs = new RiderStock { id = id, foodId = foodId, amount = amount }; RiderStockOper.Instance.Update(rs); return(JsonConvert.SerializeObject(r)); }