private void btnXemBaoCao_Click(object sender, EventArgs e)
{
if (this.dateTuNgay.DateTime == null || this.dateDenNgay.DateTime == null)
{
MessageBox.Show("Xin vui lòng chọn ngày", "Chọn ngày", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
SoThuTienService soThuTienService = new SoThuTienService();
RptBangKeTongHopThuTienHS rpt = new RptBangKeTongHopThuTienHS();
DateTime fromDate = DateTimeUtil.StartOfDate(dateTuNgay.DateTime);
DateTime toDate = DateTimeUtil.EndOfDate(dateDenNgay.DateTime);
rpt.FromDate.Value = fromDate;
rpt.ToDate.Value = toDate;
List <BangKeThuTienItem> allBangKeThuTienItems = soThuTienService.GetBangKeTongHopThuTien(toDate, (int?)cmLop.EditValue);
List <BangKeThuTienItem> displayedBangKeThuTienItems = new List <BangKeThuTienItem>();
int stt = 1;
foreach (BangKeThuTienItem item in allBangKeThuTienItems)
{
if (item.NgayNop >= fromDate && item.NgayNop <= toDate)
{
item.STT = stt++;
displayedBangKeThuTienItems.Add(item);
}
}
rpt.viewBangThuTienRowbindingSource.DataSource = displayedBangKeThuTienItems;
FormMainFacade.ShowReport(rpt);
}
private void fillRptSoThuTienTrang1(RptSoThuTienTrang1 rpt)
{
SoThuTienService soThuTienService = new SoThuTienService();
List <QLMamNon.Dao.QLMamNonDs.ViewBangThuTienRow> rows = soThuTienService.EvaluateViewBangThuTienRowsForReport(this.getViewBangThuTienRowsFromMainGrid(), this.ngayTinh);
rpt.viewBangThuTienRowbindingSource.DataSource = rows;
rpt.Ngay.Value = this.ngayTinh;
}
private void generateSoThuTiens(object sender, DoWorkEventArgs e)
{
this.persistNgayTinhAndLop();
List <QLMamNon.Dao.QLMamNonDs.HocSinhRow> hocSinhRows = e.Argument as List <QLMamNon.Dao.QLMamNonDs.HocSinhRow>;
SoThuTienService soThuTienService = new SoThuTienService();
int generatedRowsCount = soThuTienService.GenerateSoThuTienByHocSinhRows(ngayTinh, hocSinhRows);
this.bangThuTienGenHistoryTableAdapter.Insert(ngayTinh, lop, DateTime.Now, Settings.Default.TienAnSang, Settings.Default.TienAnToi, Settings.Default.TienAnChinh);
}
private decimal findSoTienTonDauKy(DateTime toDate)
{
decimal soTienTonDauKy = txtTon.Value;
if (!chkTon.Checked)
{
SoThuTienService soThuTienService = new SoThuTienService();
soTienTonDauKy = soThuTienService.GetSoTienTonDauKy(toDate);
}
return(soTienTonDauKy);
}
private void fillRptGiayBaoNopTien(RptGiayBaoNopTien rpt)
{
rpt.ShowDieuHoa.Value = Settings.Default.ShowGiayBaoNopTienDieuHoa;
rpt.ShowNote.Value = Settings.Default.ShowGiayBaoNopTienNote;
rpt.NgayLapPhieu.Value = DateTime.Now;
DateTime ngayTinh = this.ngayTinh;
rpt.NgayNop.Value = ngayTinh;
rpt.SoXuat.Value = DateTime.DaysInMonth(ngayTinh.Year, ngayTinh.Month) - DateTimeUtil.GetNumberDayOfWeekInMonth(ngayTinh.Year, ngayTinh.Month, DayOfWeek.Sunday);
List <GiayBaoNopTientem> giayBaoNopTiens = new List <GiayBaoNopTientem>();
SoThuTienService soThuTienService = new SoThuTienService();
List <QLMamNon.Dao.QLMamNonDs.ViewBangThuTienRow> rows = soThuTienService.EvaluateViewBangThuTienRowsForReport(this.getViewBangThuTienRowsFromMainGrid(), this.ngayTinh);
foreach (QLMamNon.Dao.QLMamNonDs.ViewBangThuTienRow viewBangThuTienRow in rows)
{
if (!viewBangThuTienRow.IsNgayNopLan2Null())
{
continue;
}
GiayBaoNopTientem giayBaoNopTien = new GiayBaoNopTientem()
{
HoTen = viewBangThuTienRow.HoTen,
Lop = viewBangThuTienRow.Lop,
Lan = viewBangThuTienRow.IsNgayNopLan1Null() ? 1 : 2,
SoTienAnSang = viewBangThuTienRow.SoTienAnSangThangNay,
SoTienAnToi = viewBangThuTienRow.SoTienAnToiThangNay,
SoTienKhoanThuChinh = viewBangThuTienRow.KhoanThuChinh,
SoTienDieuHoa = viewBangThuTienRow.SoTienDieuHoa,
SoTienNangKhieu = viewBangThuTienRow.SoTienNangKhieu,
SoTienDoDung = viewBangThuTienRow.SoTienDoDung,
SoTienNoThangTruoc = viewBangThuTienRow.SoTienTruyThu,
SoTienAnSangThuaThangTruoc = viewBangThuTienRow.SoTienAnSangThangTruoc,
SoTienAnToiThuaThangTruoc = viewBangThuTienRow.SoTienAnToiThangTruoc,
SoTienAnTruaThuaThangTruoc = viewBangThuTienRow.SoTienSXThangTruoc,
SoXuatAnSangThuaThangTruoc = viewBangThuTienRow.AnSangThangTruoc,
SoXuatAnToiThuaThangTruoc = viewBangThuTienRow.AnToiThangTruoc,
SoXuatAnTruaThuaThangTruoc = viewBangThuTienRow.SXThangTruoc
};
giayBaoNopTiens.Add(giayBaoNopTien);
}
rpt.GiayBaoNopTienDataSource.DataSource = giayBaoNopTiens;
}
protected override void onSaving()
{
if (ControlUtil.IsEditValueNull(this.cmbLopHocDen))
{
MessageBox.Show("Xin vui long chọn Lớp học", "Chọn lớp học", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
List <int> hocSinhIds = new List <int>();
int lop = (int)cmbLopHocDen.EditValue;
QLMamNon.Dao.QLMamNonDs.HocSinhDataTable hocSinhTable = this.hocSinhTableAdapter.GetHocSinhByParams(DateTime.Now, null, lop, null);
foreach (DataRowView rowView in hocSinhRowBindingSourceDen)
{
HocSinhRow hocSinhRow = rowView.Row as QLMamNon.Dao.QLMamNonDs.HocSinhRow;
int hocSinh = hocSinhRow.HocSinhId;
hocSinhIds.Add(hocSinh);
if (hocSinhRow.RowState == DataRowState.Modified || hocSinhRow.RowState == DataRowState.Added)
{
this.hocSinhTableAdapter.InsertHocSinhToLop(hocSinh, lop, hocSinhRow.NgayVaoLop);
}
}
((QLMamNon.Dao.QLMamNonDs.HocSinhDataTable) this.hocSinhRowBindingSourceDen.DataSource).AcceptChanges();
List <int> deletingHocSinhIds = new List <int>();
foreach (QLMamNon.Dao.QLMamNonDs.HocSinhRow hsRow in hocSinhTable)
{
if (!hocSinhIds.Contains(hsRow.HocSinhId))
{
deletingHocSinhIds.Add(hsRow.HocSinhId);
}
}
if (!ListUtil.IsEmpty(deletingHocSinhIds))
{
this.hocSinhLopTableAdapter.DeleteHocSinhLopByHocSinhIds(StringUtil.Join(deletingHocSinhIds, ","), DateTime.Now.AddDays(-1));
SoThuTienService soThuTienService = new SoThuTienService();
soThuTienService.DeleteBangThuTienByHocSinhIdsAndDate(deletingHocSinhIds, DateTimeUtil.DateEndOfMonth(DateTime.Now));
}
FormMainFacade.SetStatusCaption(this.FormKey, StatusCaptions.SavedCaption);
}
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;
}
