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 ResultStockIn GoodsStockIn(QueryGoodsStockIn query) { var result = new ResultStockIn { Exception = new MyException() }; using (var scop = new TransactionScope()) { try { var table = new Tb_Goods { Code = query.Code, LastUpDateTime = DateTime.Now, Name = query.GoodsName, InnerPrice = decimal.Parse(query.Price), Numbers = query.StockInCnt }; //_goodsHandler.StockIn(table); var db = new MySqlContext(); db.TbGoods.Add(table); db.SaveChanges(); var findIt = db.TbGoods.Where(x => x.Code.Equals(query.Code)).FirstOrDefault(); var tableInfo = new Tb_GoodsInfo() { GoodsId = findIt.Id, SalePrice = query.SalePrice, Discount = decimal.Parse(query.Discount) }; _goodsHandler.InsertGoodsInfo(tableInfo); //db.TbGoodsInfos.Add(tableInfo); scop.Complete(); result.Exception.Success = true; } catch (Exception ex) { result.Exception.Success = false; result.Exception.Exmsg = $"{ex.Message} {ex.StackTrace}"; } } return(result); }