public void UpdateArrears(int arrearsDetailsId, decimal?arrears, int arrearsID, string remarks) { var sql2 = @"select * from ArrearsData where id = @id"; ArrearsData arrearsDataRes = _context.QuerySingle <ArrearsData>(sql2, new { id = arrearsID }); ArrearsDetails arrearsDetailsIdRes = GetById(arrearsDetailsId); decimal? newArrears = arrearsDataRes.ArrearsAmount - (arrearsDetailsIdRes.ArrearsAmount - arrears); ArrearsData Arrears = _arrearsDataService.GetById(arrearsID); var sql3 = $@"update ArrearsData set ArrearsAmount=@ArrearsAmount, Remarks=@remarks where ID=@ID"; _context.Execute(sql3, new { ArrearsAmount = newArrears, ID = arrearsID, remarks = Arrears.Remarks + remarks }); var sql = $@"update ArrearsDetails set ArrearsAmount=@ArrearsAmount where ID=@ID"; _context.Execute(sql, new { ArrearsAmount = arrears, ID = arrearsDetailsId }); }
public void ArrearsInset(SalesShipmentsDataModel model, int salesShipmentsDataID) { int resID = _arrearsDataService.GetByClientDataIDAndDate(model.ClientDataID, model.Date); if (resID == 0) { ArrearsData arrearsData = new ArrearsData() { ClientDataID = model.ClientDataID, ClientDataName = model.ClientDataName, ArrearsAmount = model.ArrearsAmount, Date = model.Date, Sum = model.ArrearsAmount }; int arrearsID = _arrearsDataService.Insert(arrearsData); ArrearsDetails arrearsDetails = new ArrearsDetails() { Quantity = model.Quantity, UnitPrice = model.UnitPrice, SalesShipmentsDataID = salesShipmentsDataID, Sum = model.ArrearsAmount, ArrearsAmount = model.ArrearsAmount, ArrearsID = arrearsID, GoodsID = model.GoodsID, GoodsName = model.GoodsName }; _arrearsDetailsService.Insert(arrearsDetails); _salesShipmentsDataService.InsertArrearsID(arrearsID, salesShipmentsDataID); } else { ArrearsDetails arrearsDetails = new ArrearsDetails() { Quantity = model.Quantity, UnitPrice = model.UnitPrice, SalesShipmentsDataID = salesShipmentsDataID, Sum = model.ArrearsAmount, ArrearsAmount = model.ArrearsAmount, ArrearsID = resID, GoodsID = model.GoodsID, GoodsName = model.GoodsName }; _arrearsDetailsService.Insert(arrearsDetails); //为主表添加欠款 ArrearsData arrearsData = _arrearsDataService.GetById(resID); decimal? ArrearsAmount = arrearsData.ArrearsAmount + model.ArrearsAmount; decimal? Sum = arrearsData.Sum + model.ArrearsAmount; _arrearsDataService.UpdateArrearsAmountAndSum(ArrearsAmount, Sum, resID); } }
public void Update(ArrearsData ArrearsData) { var sql = $@"update ArrearsData set ClientData_ID=@ClientDataID, ClientData_Name=@ClientDataName, ArrearsAmount=@ArrearsAmount, Date=@Date, Sum=@Sum where ID=@ID"; _context.Execute(sql, new { ID = ArrearsData.ID, ClientDataID = ArrearsData.ClientDataID, ClientDataName = ArrearsData.ClientDataName, ArrearsAmount = ArrearsData.ArrearsAmount, Date = ArrearsData.Date, Sum = ArrearsData.Sum }); }
public int Insert(ArrearsData ArrearsData) { var sql = $@"insert into ArrearsData( ClientData_ID, ClientData_Name, ArrearsAmount, Date, Sum) VALUES ( @ClientDataID, @ClientDataName, @ArrearsAmount, @Date, @Sum) select @@identity"; return(_context.QuerySingle <int>(sql, new { ClientDataID = ArrearsData.ClientDataID, ClientDataName = ArrearsData.ClientDataName, ArrearsAmount = ArrearsData.ArrearsAmount, Date = ArrearsData.Date, Sum = ArrearsData.Sum })); }