public void GenerateSoThuTienByHocSinhAndLopAndNgayTinh(int hocSinhId, int lopId, DateTime ngayTinh, int stt, ViewBangThuTienRow preMonthViewBangThuTien)
{
BangThuTienTableAdapter bangThuTienTableAdapter = (BangThuTienTableAdapter)StaticDataFacade.Get(StaticDataKeys.AdapterBangThuTien);
LopKhoiTableAdapter lopKhoiTableAdapter = (LopKhoiTableAdapter)StaticDataFacade.Get(StaticDataKeys.AdapterLopKhoi);
int sXThangTruoc = 0;
long soTienSXThangTruoc = 0;
int anSangThangTruoc = 0;
long soTienAnSangThangTruoc = 0;
long soTienAnSangThangNay = 0;
int anToiThangTruoc = 0;
long soTienAnToiThangTruoc = 0;
long soTienAnToiThangNay = 0;
long soTienNangKhieu = 0;
long soTienTruyThu = 0;
long soTienDieuHoa = 0;
long soTienDoDung = 0;
String ghiChu = "";
bangThuTienTableAdapter.Insert(hocSinhId, lopId, sXThangTruoc, soTienSXThangTruoc, anSangThangTruoc, soTienAnSangThangTruoc, soTienAnSangThangNay, soTienAnToiThangTruoc, anToiThangTruoc, soTienAnToiThangNay, soTienDoDung, soTienNangKhieu, soTienTruyThu, soTienDieuHoa, ngayTinh, stt, 0, DateTime.Now, ghiChu);
int bangThuTienId = (int)bangThuTienTableAdapter.Adapter.InsertCommand.LastInsertedId;
int khoiId = StaticDataUtil.GetKhoiIdByLopId(lopKhoiTableAdapter, lopId).Value;
this.generateBangThuTienKhoanThu(bangThuTienId, khoiId, ngayTinh, preMonthViewBangThuTien);
}
public static int?GetKhoiIdByLopId(LopKhoiTableAdapter lopKhoiTableAdapter, Int32 lopId)
{
if (lopId < 0)
{
return(null);
}
QLMamNon.Dao.QLMamNonDs.LopKhoiDataTable table = lopKhoiTableAdapter.GetDataByLopId(lopId);
if (table != null && table.Rows.Count > 0)
{
QLMamNon.Dao.QLMamNonDs.LopKhoiRow row = table[0];
return(row.KhoiId);
}
return(null);
}
public static void RecalculateBangThuTienKhoanThuList(LopKhoiTableAdapter lopKhoiTableAdapter,
KhoanThuHangNamTableAdapter khoanThuHangNamTableAdapter,
QLMamNon.Dao.QLMamNonDs.ViewBangThuTienRow viewBangThuTienRow)
{
int khoiId = StaticDataUtil.GetKhoiIdByLopId(lopKhoiTableAdapter, viewBangThuTienRow.LopId).Value;
int[] khoanThuIds = new int[] { BangThuTienConstant.KhoanThuIdBanTru, BangThuTienConstant.KhoanThuIdHocPhi, BangThuTienConstant.KhoanThuIdPhuPhi, BangThuTienConstant.KhoanThuIdTienAnSua, BangThuTienConstant.KhoanThuIdAnSang, BangThuTienConstant.KhoanThuIdAnToi };
QLMamNon.Dao.QLMamNonDs.KhoanThuHangNamDataTable khoanThuHangNamTable = khoanThuHangNamTableAdapter.GetKhoanThuHangNamByParams(String.Join(",", khoanThuIds), khoiId, viewBangThuTienRow.NgayTinh);
foreach (QLMamNon.Dao.QLMamNonDs.KhoanThuHangNamRow row in khoanThuHangNamTable)
{
long soTien = BangThuTienUtil.CalculateSoTienPhi(khoiId, viewBangThuTienRow.SXThangTruoc, row.SoTien, row.KhoanThuId);
switch (row.KhoanThuId)
{
case BangThuTienConstant.KhoanThuIdTienAnSua:
viewBangThuTienRow.TienAnSua = soTien;
break;
case BangThuTienConstant.KhoanThuIdPhuPhi:
viewBangThuTienRow.PhuPhi = soTien;
break;
case BangThuTienConstant.KhoanThuIdBanTru:
viewBangThuTienRow.BanTru = soTien;
break;
case BangThuTienConstant.KhoanThuIdHocPhi:
viewBangThuTienRow.HocPhi = soTien;
break;
default:
break;
}
}
viewBangThuTienRow.KhoanThuChinh = viewBangThuTienRow.TienAnSua + viewBangThuTienRow.PhuPhi + viewBangThuTienRow.BanTru + viewBangThuTienRow.HocPhi;
viewBangThuTienRow.ThanhTien = BangThuTienUtil.CalculateThanhTien(viewBangThuTienRow);
}
