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);
}
