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