public Tb_Order GetOrderByUser(string Uid)
{
var cmd = new DataCommand();
var cartGo = cmd.Search <Tb_Order>(x => x.UserId.Equals(Uid));
return(cartGo);
}
public Tb_Goods GetGoodsInfoByCode(string code)
{
var cmd = new DataCommand();
var result = cmd.Search <Tb_Goods>(x => x.Code.Equals(code));
return(result);
}
public void StockIn(Tb_Goods goodsIn)
{
var cmd = new DataCommand();
var findIt = cmd.Search <Tb_Goods>(x => x.Code.Equals(goodsIn.Code));
if (findIt != null)
{
findIt.LastUpDateTime = DateTime.Now;
findIt.Numbers += goodsIn.Numbers;
DataCommand.Update(findIt);
}
cmd.Add <Tb_Goods>(goodsIn, false);
//findIt = cmd.Search<Tb_Goods>(x => x.Code.Equals(goodsIn.Code));
//var cmd2=new DataCommand("mySql", "InsertGoodsInfo2");
//cmd2.SetParameters("@GoodsId",$"{ findIt.Id}");
//cmd2.SetParameters("@SalePrice", $"{goodsIn.InnerPrice}");
//cmd2.ExeSqlCmd();
}
public void AddStockToCart(Tb_CartGo cartGo)
{
var cmd = new DataCommand();
var findIt = cmd.Search <Tb_CartGo>(x => x.StockCode.Equals(cartGo.StockCode) && x.UserId.Equals(cartGo.UserId) && x.IsPay != 1);
if (findIt != null)
{
findIt.BuyCnt += cartGo.BuyCnt;
findIt.CurPrice = cartGo.CurPrice;
DataCommand.Update(findIt);
return;
}
cmd = new DataCommand("mySql", "InsertGoodsCartGo");
cmd.SetParameters("@UserId", cartGo.UserId);
cmd.SetParameters("@StockCode", cartGo.StockCode);
cmd.SetParameters("@BuyCnt", $"{cartGo.BuyCnt}");
cmd.SetParameters("@CurPrice", $"{cartGo.CurPrice}");
cmd.SetParameters("@TempUser", $"{cartGo.TempUser}");
cmd.SetParameters("@CreateTime", cartGo.CreateTime.ToString("yyyy-MM-dd HH:mm:ss"));
cmd.ExeSqlCmd();
}