private Dictionary <int, QLMamNon.Dao.QLMamNonDs.ViewBangThuTienRow> evaluatePrevMonthViewBangThuTienTable(DateTime ngayTinh, int hocSinhId)
{
ViewBangThuTienTableAdapter viewBangThuTienTableAdapter = (ViewBangThuTienTableAdapter)StaticDataFacade.Get(StaticDataKeys.AdapterViewBangThuTien);
BangThuTienKhoanThuTableAdapter bangThuTienKhoanThuTableAdapter = (BangThuTienKhoanThuTableAdapter)StaticDataFacade.Get(StaticDataKeys.AdapterBangThuTienKhoanThu);
PhieuThuTableAdapter phieuThuTableAdapter = (PhieuThuTableAdapter)StaticDataFacade.Get(StaticDataKeys.AdapterPhieuThu);
Dictionary <int, QLMamNon.Dao.QLMamNonDs.ViewBangThuTienRow> prevMonthRowDictionary = null;
QLMamNon.Dao.QLMamNonDs.ViewBangThuTienDataTable prevMonthBangThuTienTable = viewBangThuTienTableAdapter.GetDataByNgayTinhAndHocSinhId(ngayTinh, hocSinhId);
List <int> prevMonthBangThuTienIds = new List <int>(prevMonthBangThuTienTable.Rows.Count);
foreach (QLMamNon.Dao.QLMamNonDs.ViewBangThuTienRow row in prevMonthBangThuTienTable)
{
prevMonthBangThuTienIds.Add(row.BangThuTienId);
}
if (!ListUtil.IsEmpty(prevMonthBangThuTienIds))
{
QLMamNon.Dao.QLMamNonDs.BangThuTienKhoanThuDataTable prevMonthBTTKTDataTable = bangThuTienKhoanThuTableAdapter.GetBangThuTienKhoanThuByBangThuTienIds(String.Join(",", prevMonthBangThuTienIds));
QLMamNon.Dao.QLMamNonDs.PhieuThuDataTable prevMonthPhieuThuDataTable = phieuThuTableAdapter.GetDataByHocSinhIdAndNgayTinh(-1, ngayTinh);
prevMonthRowDictionary = new Dictionary <int, Dao.QLMamNonDs.ViewBangThuTienRow>();
foreach (QLMamNon.Dao.QLMamNonDs.ViewBangThuTienRow row in prevMonthBangThuTienTable)
{
BangThuTienUtil.EvaluateValuesForViewBangThuTienRow(row, null, prevMonthBTTKTDataTable, prevMonthPhieuThuDataTable, true, false, true);
prevMonthRowDictionary.Add(row.HocSinhId, row);
}
}
return(prevMonthRowDictionary);
}
public static void EvaluateValuesForViewBangThuTienRow(QLMamNon.Dao.QLMamNonDs.ViewBangThuTienRow row,
QLMamNon.Dao.QLMamNonDs.ViewBangThuTienRow bangThuTienThangTruocRow,
QLMamNon.Dao.QLMamNonDs.BangThuTienKhoanThuDataTable bTTKTDataTable,
QLMamNon.Dao.QLMamNonDs.PhieuThuDataTable phieuThuDataTable,
bool ignoreTruyThu, bool isCalculateAnSangAnToi, bool isCalculateHocPhi)
{
evaluateValuesForAdditionalFields(row, bTTKTDataTable, isCalculateAnSangAnToi, isCalculateHocPhi);
evaluateValuesForTienNop(row, phieuThuDataTable);
if (!ignoreTruyThu)
{
row.SoTienTruyThu = BangThuTienUtil.CalculateTruyThu(row, bangThuTienThangTruocRow);
}
CalculateSummaryFields(row);
}
private void updateSoTienTruyThuForBangThuTienNextMonths(DateTime ngay, int hocSinhId)
{
ViewBangThuTienTableAdapter viewBangThuTienTableAdapter = (ViewBangThuTienTableAdapter)StaticDataFacade.Get(StaticDataKeys.AdapterViewBangThuTien);
BangThuTienKhoanThuTableAdapter bangThuTienKhoanThuTableAdapter = (BangThuTienKhoanThuTableAdapter)StaticDataFacade.Get(StaticDataKeys.AdapterBangThuTienKhoanThu);
PhieuThuTableAdapter phieuThuTableAdapter = (PhieuThuTableAdapter)StaticDataFacade.Get(StaticDataKeys.AdapterPhieuThu);
QLMNDaoJobInvoker qlmnDaoJobInvoker = new QLMNDaoJobInvoker();
qlmnDaoJobInvoker.UpdateSoTienTruyThuOfBangThuTienCommand = new UpdateSoTienTruyThuOfBangThuTienCommand();
qlmnDaoJobInvoker.UpdateSoTienTruyThuOfBangThuTienCommand.CommandParameter.Add(UpdateSoTienTruyThuOfBangThuTienCommand.ParameterViewBangThuTienTableAdapter, viewBangThuTienTableAdapter);
QLMamNon.Dao.QLMamNonDs.ViewBangThuTienDataTable table = viewBangThuTienTableAdapter.GetDataByNgayTinhAndHocSinhId(ngay.AddMonths(1), hocSinhId);
if (ListUtil.IsEmpty(table.Rows))
{
return;
}
QLMamNon.Dao.QLMamNonDs.ViewBangThuTienRow viewBangThuTienRow = table[0];
QLMamNon.Dao.QLMamNonDs.BangThuTienKhoanThuDataTable bTTKTDataTable = bangThuTienKhoanThuTableAdapter.GetBangThuTienKhoanThuByBangThuTienIds(viewBangThuTienRow.BangThuTienId.ToString());
QLMamNon.Dao.QLMamNonDs.PhieuThuDataTable phieuThuDataTable = phieuThuTableAdapter.GetDataByHocSinhIdAndNgayTinh(-1, ngay);
Dictionary <int, QLMamNon.Dao.QLMamNonDs.ViewBangThuTienRow> prevMonthRowDictionary = evaluatePrevMonthViewBangThuTienTable(ngay.AddMonths(-1), hocSinhId);
BangThuTienUtil.EvaluateValuesForViewBangThuTienRow(viewBangThuTienRow,
prevMonthRowDictionary != null && prevMonthRowDictionary.ContainsKey(viewBangThuTienRow.HocSinhId) ? prevMonthRowDictionary[viewBangThuTienRow.HocSinhId] : null,
bTTKTDataTable, phieuThuDataTable, false, false, true);
if (viewBangThuTienRow[ViewBangThuTienFieldName.ThanhTien, DataRowVersion.Original] != DBNull.Value && viewBangThuTienRow[ViewBangThuTienFieldName.ThanhTien, DataRowVersion.Current] != DBNull.Value)
{
long originalVersionToCompare = (long)viewBangThuTienRow[ViewBangThuTienFieldName.ThanhTien, DataRowVersion.Original];
long currentVersionToCompare = (long)viewBangThuTienRow[ViewBangThuTienFieldName.ThanhTien, DataRowVersion.Current];
if (originalVersionToCompare != currentVersionToCompare)
{
qlmnDaoJobInvoker.UpdateSoTienTruyThuOfBangThuTienCommand.CommandParameter.Remove(UpdateSoTienTruyThuOfBangThuTienCommand.ParameterCurrentViewBangThuTien);
qlmnDaoJobInvoker.UpdateSoTienTruyThuOfBangThuTienCommand.CommandParameter.Remove(UpdateSoTienTruyThuOfBangThuTienCommand.ParameterSoTienAdded);
qlmnDaoJobInvoker.UpdateSoTienTruyThuOfBangThuTienCommand.CommandParameter.Add(UpdateSoTienTruyThuOfBangThuTienCommand.ParameterCurrentViewBangThuTien, viewBangThuTienRow);
qlmnDaoJobInvoker.UpdateSoTienTruyThuOfBangThuTienCommand.CommandParameter.Add(UpdateSoTienTruyThuOfBangThuTienCommand.ParameterSoTienAdded, currentVersionToCompare - originalVersionToCompare);
qlmnDaoJobInvoker.UpdateSoTienTruyThuOfBangThuTien();
}
}
}
private List <ViewBangThuTienRow> loadViewBangThuTiensToanTruong(DateTime toDate, int?lopId)
{
ViewBangThuTienTableAdapter viewBangThuTienTableAdapter = (ViewBangThuTienTableAdapter)StaticDataFacade.Get(StaticDataKeys.AdapterViewBangThuTien);
BangThuTienKhoanThuTableAdapter bangThuTienKhoanThuTableAdapter = (BangThuTienKhoanThuTableAdapter)StaticDataFacade.Get(StaticDataKeys.AdapterBangThuTienKhoanThu);
PhieuThuTableAdapter phieuThuTableAdapter = (PhieuThuTableAdapter)StaticDataFacade.Get(StaticDataKeys.AdapterPhieuThu);
ViewBangThuTienDataTable table = viewBangThuTienTableAdapter.GetViewBangThuTienByNgayTinhAndLop(toDate, lopId);
List <int> bangThuTienIds = new List <int>(table.Rows.Count);
foreach (ViewBangThuTienRow row in table)
{
bangThuTienIds.Add(row.BangThuTienId);
}
if (!ListUtil.IsEmpty(bangThuTienIds))
{
QLMamNon.Dao.QLMamNonDs.BangThuTienKhoanThuDataTable bTTKTDataTable = bangThuTienKhoanThuTableAdapter.GetBangThuTienKhoanThuByBangThuTienIds(String.Join(",", bangThuTienIds));
QLMamNon.Dao.QLMamNonDs.PhieuThuDataTable phieuThuDataTable = phieuThuTableAdapter.GetDataByHocSinhIdAndNgayTinh(-1, toDate);
Dictionary <int, ViewBangThuTienRow> prevMonthRowDictionary = this.EvaluatePrevMonthViewBangThuTienTable(toDate.AddMonths(-1), lopId);
HocSinhDataTable hocSinhDataTable = this.getHocSinhData();
foreach (ViewBangThuTienRow row in table)
{
row.HoTen = StaticDataUtil.GetHocSinhFullNameByHocSinhId(hocSinhDataTable, row.HocSinhId);
BangThuTienUtil.EvaluateValuesForViewBangThuTienRow(row,
prevMonthRowDictionary != null && prevMonthRowDictionary.ContainsKey(row.HocSinhId) ? prevMonthRowDictionary[row.HocSinhId] : null,
bTTKTDataTable, phieuThuDataTable, false, false, true);
}
}
List <ViewBangThuTienRow> viewBangThuTienRows = new List <Dao.QLMamNonDs.ViewBangThuTienRow>();
foreach (ViewBangThuTienRow row in table)
{
viewBangThuTienRows.Add(row);
}
return(viewBangThuTienRows);
}
private void loadViewBangThuTiens(DateTime ngayTinh, int lop)
{
if (this.isNeedToGenerateSoThuTiens(ngayTinh, lop, false))
{
this.showFormGenerateSoThuTiens(true);
return;
}
ViewBangThuTienDataTable table = viewBangThuTienTableAdapter.GetViewBangThuTienByNgayTinhAndLop(ngayTinh, lop);
List <int> bangThuTienIds = new List <int>(table.Rows.Count);
foreach (ViewBangThuTienRow row in table)
{
bangThuTienIds.Add(row.BangThuTienId);
}
if (!ListUtil.IsEmpty(bangThuTienIds))
{
bTTKTDataTable = bangThuTienKhoanThuTableAdapter.GetBangThuTienKhoanThuByBangThuTienIds(String.Join(",", bangThuTienIds));
phieuThuDataTable = phieuThuTableAdapter.GetDataByHocSinhIdAndNgayTinh(-1, ngayTinh);
SoThuTienService soThuTienService = new SoThuTienService();
prevMonthRowDictionary = soThuTienService.EvaluatePrevMonthViewBangThuTienTable(ngayTinh.AddMonths(-1), lop);
foreach (ViewBangThuTienRow row in table)
{
row.HoTen = StaticDataUtil.GetHocSinhFullNameByHocSinhId(hocSinhDataTable, row.HocSinhId);
BangThuTienUtil.EvaluateValuesForViewBangThuTienRow(row,
prevMonthRowDictionary != null && prevMonthRowDictionary.ContainsKey(row.HocSinhId) ? prevMonthRowDictionary[row.HocSinhId] : null,
bTTKTDataTable, phieuThuDataTable, false, false, true);
row.AcceptChanges();
}
}
this.viewBangThuTienRowBindingSource.DataSource = table;
this.DataTable = table;
}
private static void evaluateValuesForAdditionalFields(QLMamNon.Dao.QLMamNonDs.ViewBangThuTienRow row,
QLMamNon.Dao.QLMamNonDs.BangThuTienKhoanThuDataTable bTTKTDataTable,
bool isCalculateAnSangAnToi, bool isCalculateHocPhi)
{
if (isCalculateHocPhi)
{
row.TienAnSua = 0;
row.PhuPhi = 0;
row.BanTru = 0;
row.HocPhi = 0;
}
if (isCalculateAnSangAnToi)
{
row.SoTienAnSangThangNay = 0;
row.SoTienAnToiThangNay = 0;
}
QLMamNon.Dao.QLMamNonDs.BangThuTienKhoanThuRow[] bangThuTienKhoanThuRows = bTTKTDataTable.Select(String.Format("BangThuTienId={0}", row.BangThuTienId)) as QLMamNon.Dao.QLMamNonDs.BangThuTienKhoanThuRow[];
if (!ListUtil.IsEmpty(bangThuTienKhoanThuRows))
{
foreach (QLMamNon.Dao.QLMamNonDs.BangThuTienKhoanThuRow bangThuTienKhoanThuRow in bangThuTienKhoanThuRows)
{
switch (bangThuTienKhoanThuRow.KhoanThuId)
{
case BangThuTienConstant.KhoanThuIdTienAnSua:
if (isCalculateHocPhi)
{
row.TienAnSua = bangThuTienKhoanThuRow.SoTien;
}
break;
case BangThuTienConstant.KhoanThuIdPhuPhi:
if (isCalculateHocPhi)
{
row.PhuPhi = bangThuTienKhoanThuRow.SoTien;
}
break;
case BangThuTienConstant.KhoanThuIdBanTru:
if (isCalculateHocPhi)
{
row.BanTru = bangThuTienKhoanThuRow.SoTien;
}
break;
case BangThuTienConstant.KhoanThuIdHocPhi:
if (isCalculateHocPhi)
{
row.HocPhi = bangThuTienKhoanThuRow.SoTien;
}
break;
case BangThuTienConstant.KhoanThuIdAnSang:
if (isCalculateAnSangAnToi)
{
row.SoTienAnSangThangNay = bangThuTienKhoanThuRow.SoTien;
}
break;
case BangThuTienConstant.KhoanThuIdAnToi:
if (isCalculateAnSangAnToi)
{
row.SoTienAnToiThangNay = bangThuTienKhoanThuRow.SoTien;
}
break;
default:
break;
}
}
}
}
protected override void onSaving()
{
ViewBangThuTienDataTable table = this.DataTable as ViewBangThuTienDataTable;
List <int> bangThuTienIds = new List <int>();
foreach (ViewBangThuTienRow viewBangThuTienRow in table)
{
viewBangThuTienRow.SoTienSXThangTruoc = BangThuTienUtil.SXToSoTienSX(viewBangThuTienRow.SXThangTruoc, Settings.Default.TienAnChinh);
viewBangThuTienRow.SoTienAnSangThangTruoc = BangThuTienUtil.SXAnSangToSoTienAnSang(viewBangThuTienRow.AnSangThangTruoc, Settings.Default.TienAnSang);
viewBangThuTienRow.SoTienAnToiThangTruoc = BangThuTienUtil.SXAnToiToSoTienAnToi(viewBangThuTienRow.AnToiThangTruoc, Settings.Default.TienAnToi);
if (this.isNeedToUpdateBangThuTienKhoanThu(viewBangThuTienRow))
{
bangThuTienIds.Add(viewBangThuTienRow.BangThuTienId);
}
}
if (!ListUtil.IsEmpty(bangThuTienIds))
{
QLMamNon.Dao.QLMamNonDs.BangThuTienKhoanThuDataTable bangThuTienKhoanThuDataTable = bangThuTienKhoanThuTableAdapter.GetBangThuTienKhoanThuByBangThuTienIds(StringUtil.Join(bangThuTienIds, ","));
foreach (QLMamNon.Dao.QLMamNonDs.BangThuTienKhoanThuRow bangThuTienKhoanThuRow in bangThuTienKhoanThuDataTable)
{
ViewBangThuTienRow[] viewBangThuTienRows = (ViewBangThuTienRow[])table.Select(String.Format("BangThuTienId={0}", bangThuTienKhoanThuRow.BangThuTienId));
ViewBangThuTienRow viewBangThuTienRow = viewBangThuTienRows[0];
switch (bangThuTienKhoanThuRow.KhoanThuId)
{
case BangThuTienConstant.KhoanThuIdTienAnSua:
bangThuTienKhoanThuRow.SoTien = viewBangThuTienRow.TienAnSua;
break;
case BangThuTienConstant.KhoanThuIdPhuPhi:
bangThuTienKhoanThuRow.SoTien = viewBangThuTienRow.PhuPhi;
break;
case BangThuTienConstant.KhoanThuIdBanTru:
bangThuTienKhoanThuRow.SoTien = viewBangThuTienRow.BanTru;
break;
case BangThuTienConstant.KhoanThuIdHocPhi:
bangThuTienKhoanThuRow.SoTien = viewBangThuTienRow.HocPhi;
break;
case BangThuTienConstant.KhoanThuIdAnSang:
bangThuTienKhoanThuRow.SoTien = viewBangThuTienRow.SoTienAnSangThangNay;
break;
case BangThuTienConstant.KhoanThuIdAnToi:
bangThuTienKhoanThuRow.SoTien = viewBangThuTienRow.SoTienAnToiThangNay;
break;
default:
break;
}
}
bangThuTienKhoanThuTableAdapter.Update(bangThuTienKhoanThuDataTable);
}
// Start Updating SoTienTruyThu for each BangThuTienRow
QLMNDaoJobInvoker qlmnDaoJobInvoker = new QLMNDaoJobInvoker();
qlmnDaoJobInvoker.UpdateSoTienTruyThuOfBangThuTienCommand = new UpdateSoTienTruyThuOfBangThuTienCommand();
qlmnDaoJobInvoker.UpdateSoTienTruyThuOfBangThuTienCommand.CommandParameter.Add(UpdateSoTienTruyThuOfBangThuTienCommand.ParameterViewBangThuTienTableAdapter, this.viewBangThuTienTableAdapter);
foreach (ViewBangThuTienRow viewBangThuTienRow in table)
{
if (viewBangThuTienRow[ViewBangThuTienFieldName.ThanhTien, DataRowVersion.Original] != DBNull.Value && viewBangThuTienRow[ViewBangThuTienFieldName.ThanhTien, DataRowVersion.Current] != DBNull.Value)
{
long originalVersionToCompare = (long)viewBangThuTienRow[ViewBangThuTienFieldName.ThanhTien, DataRowVersion.Original];
long currentVersionToCompare = (long)viewBangThuTienRow[ViewBangThuTienFieldName.ThanhTien, DataRowVersion.Current];
if (originalVersionToCompare != currentVersionToCompare)
{
qlmnDaoJobInvoker.UpdateSoTienTruyThuOfBangThuTienCommand.CommandParameter.Remove(UpdateSoTienTruyThuOfBangThuTienCommand.ParameterCurrentViewBangThuTien);
qlmnDaoJobInvoker.UpdateSoTienTruyThuOfBangThuTienCommand.CommandParameter.Remove(UpdateSoTienTruyThuOfBangThuTienCommand.ParameterSoTienAdded);
qlmnDaoJobInvoker.UpdateSoTienTruyThuOfBangThuTienCommand.CommandParameter.Add(UpdateSoTienTruyThuOfBangThuTienCommand.ParameterCurrentViewBangThuTien, viewBangThuTienRow);
qlmnDaoJobInvoker.UpdateSoTienTruyThuOfBangThuTienCommand.CommandParameter.Add(UpdateSoTienTruyThuOfBangThuTienCommand.ParameterSoTienAdded, currentVersionToCompare - originalVersionToCompare);
qlmnDaoJobInvoker.UpdateSoTienTruyThuOfBangThuTien();
}
}
}
// Finished Updating SoTienTruyThu for each BangThuTien
base.onSaving();
}
