/// <summary> /// add /// </summary> /// <param name="AllocateRecord"></param> /// <returns></returns> public int Add(AllocateRecord model) { var str = GetInsertStr(model) + " select @@identity"; var dict = GetParameters(model); return(Convert.ToInt32(SqlHelperHere.ExecuteScalar(str, dict))); }
/// <summary> /// del /// </summary> /// <param name="AllocateRecord"></param> /// <returns></returns> public void Delete(int id) { AllocateRecord model = new AllocateRecord(); model.isDeleted = true; model.id = id; Update(model); }
/// <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> /// 插入 /// </summary> /// <param name="allocaterecord"></param> /// <returns>是否成功</returns> public string GetInsertStr(AllocateRecord allocaterecord) { StringBuilder part1 = new StringBuilder(); StringBuilder part2 = new StringBuilder(); if (allocaterecord.riderId != null) { part1.Append("riderId,"); part2.Append("@riderId,"); } if (allocaterecord.foodId != null) { part1.Append("foodId,"); part2.Append("@foodId,"); } if (allocaterecord.amount != null) { part1.Append("amount,"); part2.Append("@amount,"); } if (allocaterecord.targetRiderId != null) { part1.Append("targetRiderId,"); part2.Append("@targetRiderId,"); } if (allocaterecord.status != null) { part1.Append("status,"); part2.Append("@status,"); } if (allocaterecord.isDeleted != null) { part1.Append("isDeleted,"); part2.Append("@isDeleted,"); } if (allocaterecord.timestamp != null) { part1.Append("timestamp,"); part2.Append("@timestamp,"); } StringBuilder sql = new StringBuilder(); sql.Append("insert into allocaterecord(").Append(part1.ToString().Remove(part1.Length - 1)).Append(") values (").Append(part2.ToString().Remove(part2.Length - 1)).Append(")"); return(sql.ToString()); } /// <summary>
/// 获取参数 /// </summary> /// <param name="allocaterecord"></param> /// <returns></returns> public Dictionary <string, string> GetParameters(AllocateRecord allocaterecord) { Dictionary <string, string> dict = new Dictionary <string, string>(); if (allocaterecord.id != null) { dict.Add("@id", allocaterecord.id.ToString()); } if (allocaterecord.riderId != null) { dict.Add("@riderId", allocaterecord.riderId.ToString()); } if (allocaterecord.foodId != null) { dict.Add("@foodId", allocaterecord.foodId.ToString()); } if (allocaterecord.amount != null) { dict.Add("@amount", allocaterecord.amount.ToString()); } if (allocaterecord.targetRiderId != null) { dict.Add("@targetRiderId", allocaterecord.targetRiderId.ToString()); } if (allocaterecord.status != null) { dict.Add("@status", allocaterecord.status.ToString()); } if (allocaterecord.isDeleted != null) { dict.Add("@isDeleted", allocaterecord.isDeleted.ToString()); } if (allocaterecord.timestamp != null) { dict.Add("@timestamp", allocaterecord.timestamp.ToString()); } return(dict); }
} /// <summary> /// 更新 /// </summary> /// <param name="allocaterecord"></param> /// <returns>是否成功</returns> public string GetUpdateStr(AllocateRecord allocaterecord) { StringBuilder part1 = new StringBuilder(); part1.Append("update allocaterecord set "); if (allocaterecord.riderId != null) { part1.Append("riderId = @riderId,"); } if (allocaterecord.foodId != null) { part1.Append("foodId = @foodId,"); } if (allocaterecord.amount != null) { part1.Append("amount = @amount,"); } if (allocaterecord.targetRiderId != null) { part1.Append("targetRiderId = @targetRiderId,"); } if (allocaterecord.status != null) { part1.Append("status = @status,"); } if (allocaterecord.isDeleted != null) { part1.Append("isDeleted = @isDeleted,"); } if (allocaterecord.timestamp != null) { part1.Append("timestamp = @timestamp,"); } int n = part1.ToString().LastIndexOf(","); part1.Remove(n, 1); part1.Append(" where id= @id "); return(part1.ToString()); }
public HttpResponseMessage ApplyToOtherRider(GiveToOtherRider req) { //-txy 这里要不要判断请求的人够不够呢 var riderId = Convert.ToInt32(req.riderId); var tokenStr = req.Token; Token token = CacheHelper.GetRiderToken(tokenStr); if (token == null) { return(ControllerHelper.Instance.JsonResult(400, "token失效")); } if (token.Payload.UserID != riderId) { return(ControllerHelper.Instance.JsonResult(400, "token错误")); } var list_foods = JsonConvert.DeserializeObject <List <foodId_Amount> >(req.listFoods); var targetRiderId = Convert.ToInt32(req.targetRiderId); var targetListFoods = RiderStockOper.Instance.GetByRiderId(targetRiderId); if (targetListFoods.Count < 1) { return(ControllerHelper.Instance.JsonResult(500, "对方库存不足")); } foreach (var item in list_foods) { var temp = targetListFoods.Where(p => p.foodId == item.foodId).ToList(); if (temp.Count < 1) { return(ControllerHelper.Instance.JsonResult(500, "对方库存不足")); } if (temp.First().amount < item.amount) { return(ControllerHelper.Instance.JsonResult(500, "对方库存不足")); } } var timestamp = StringHelperHere.Instance.GetTimeStamp() + StringHelperHere.Instance.GetLastFiveStr(riderId.ToString()); var allocateId = 0; foreach (var item in list_foods) { AllocateRecord ar = new AllocateRecord(); ar.riderId = riderId; ar.foodId = item.foodId; ar.amount = item.amount; ar.targetRiderId = targetRiderId; ar.status = 0; ar.timestamp = timestamp; allocateId = AllocateRecordOper.Instance.Add(ar); } //推送消息 UPushHelper.Instance.PushRiderApply(targetRiderId, list_foods, riderId, timestamp); return(ControllerHelper.Instance.JsonResult(200, "已发送调配请求")); }