/// 获取参数
/// </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));
}
