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 Insert(ArrearsDetails ArrearsDetails)
{
var sql = $@"insert into ArrearsDetails(
Goods_ID,
Goods_Name,
Arrears_ID,
SalesShipmentsData_ID,
Quantity,
UnitPrice,
ArrearsAmount,
Sum)
VALUES (
@GoodsID,
@GoodsName,
@ArrearsID,
@SalesShipmentsDataID,
@Quantity,
@UnitPrice,
@ArrearsAmount,
@Sum)";
_context.Execute(sql, new
{
GoodsID = ArrearsDetails.GoodsID,
GoodsName = ArrearsDetails.GoodsName,
ArrearsID = ArrearsDetails.ArrearsID,
SalesShipmentsDataID = ArrearsDetails.SalesShipmentsDataID,
Quantity = ArrearsDetails.Quantity,
UnitPrice = ArrearsDetails.UnitPrice,
ArrearsAmount = ArrearsDetails.ArrearsAmount,
Sum = ArrearsDetails.Sum
});
}
public void Update(ArrearsDetails ArrearsDetails)
{
var sql = $@"update ArrearsDetails set
Goods_ID=@GoodsID,
Goods_Name=@GoodsName,
Arrears_ID=@ArrearsID,
SalesShipmentsData_ID=@SalesShipmentsDataID,
Quantity=@Quantity,
UnitPrice=@UnitPrice,
ArrearsAmount=@ArrearsAmount,
Sum=@Sum
where ID=@ID";
_context.Execute(sql, new
{
GoodsID = ArrearsDetails.GoodsID,
GoodsName = ArrearsDetails.GoodsName,
ArrearsID = ArrearsDetails.ArrearsID,
SalesShipmentsDataID = ArrearsDetails.SalesShipmentsDataID,
Quantity = ArrearsDetails.Quantity,
UnitPrice = ArrearsDetails.UnitPrice,
ArrearsAmount = ArrearsDetails.ArrearsAmount,
Sum = ArrearsDetails.Sum
});
}
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);
}
}
