private static void fillPhanLoaiChiForPhieuChiRows(PhieuChiTableAdapter phieuChiTableAdapter, QLMamNon.Dao.QLMamNonDs.PhieuChiDataTable table) { foreach (QLMamNon.Dao.QLMamNonDs.PhieuChiRow row in table) { row.PhanLoaiChi = StaticDataUtil.GetMaPhanLoaiChiNameByPhieuChiId(phieuChiTableAdapter, row.PhieuChiId); } }
private void gvMain_CustomColumnDisplayText(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e) { ColumnView view = sender as ColumnView; if (e.Column.FieldName == "KhoiId" && e.ListSourceRowIndex != DevExpress.XtraGrid.GridControl.InvalidRowHandle) { Object khoiIdObj = view.GetListSourceRowCellValue(e.ListSourceRowIndex, "KhoiId"); if (!DBNull.Value.Equals(khoiIdObj)) { int khoiId = (int)khoiIdObj; e.DisplayText = StaticDataUtil.GetKhoiNameByKhoiId(khoiId); } } else if (e.Column.FieldName == "KhoanThuId" && e.ListSourceRowIndex != DevExpress.XtraGrid.GridControl.InvalidRowHandle) { Object khoanThuIdObj = view.GetListSourceRowCellValue(e.ListSourceRowIndex, "KhoanThuId"); if (!DBNull.Value.Equals(khoanThuIdObj)) { int khoanThuId = (int)khoanThuIdObj; e.DisplayText = StaticDataUtil.GetKhoanThuNameByKhoanThuId(khoanThuId); } } }
public List <ViewBangThuTienRow> EvaluateViewBangThuTienRowsForReport(List <ViewBangThuTienRow> viewBangThuTienRows, DateTime toDate) { HashSet <int> hocSinhIds = new HashSet <int>(); foreach (ViewBangThuTienRow viewBangThuTienRow in viewBangThuTienRows) { if (!hocSinhIds.Contains(viewBangThuTienRow.HocSinhId)) { hocSinhIds.Add(viewBangThuTienRow.HocSinhId); } } LoggerFacade.Info(string.Format("EvaluateViewBangThuTienRowsForReport for list HocSinhIds=[{0}]", StringUtil.JoinWithCommas(hocSinhIds.ToList()))); HocSinhLopTableAdapter hocSinhLopTableAdapter = (HocSinhLopTableAdapter)StaticDataFacade.Get(StaticDataKeys.AdapterHocSinhLop); Dictionary <int, QLMamNon.Dao.QLMamNonDs.LopRow> hocSinhIdsToLopNames = StaticDataUtil.GetLopsByHocSinhIds(hocSinhIds.ToList(), toDate); HocSinhDataTable hocSinhDataTable = this.getHocSinhData(); foreach (ViewBangThuTienRow viewBangThuTienRow in viewBangThuTienRows) { viewBangThuTienRow.HoTen = StaticDataUtil.GetHocSinhFullNameByHocSinhId(hocSinhDataTable, viewBangThuTienRow.HocSinhId); if (hocSinhIdsToLopNames.ContainsKey(viewBangThuTienRow.HocSinhId)) { viewBangThuTienRow.Lop = hocSinhIdsToLopNames[viewBangThuTienRow.HocSinhId].Name; } } return(viewBangThuTienRows); }
private void fillReportHocSinh(RptThongTinHocSinh rpt) { List <object> rows = new List <object>(this.GridViewMain.RowCount); for (int i = 0; i < this.GridViewMain.DataRowCount; i++) { object dataRow = this.GridViewMain.GetRow(this.GridViewMain.GetVisibleRowHandle(i)); rows.Add(dataRow); QLMamNon.Dao.QLMamNonDs.HocSinhRow hocSinhRow = (dataRow as DataRowView).Row as QLMamNon.Dao.QLMamNonDs.HocSinhRow; hocSinhRow.STT = i + 1; if (!hocSinhRow.IsPhuongXaIdNull()) { hocSinhRow.PhuongXa = StaticDataUtil.GetPhuongXaById(StaticDataFacade.Get(StaticDataKeys.PhuongXa) as QLMamNon.Dao.QLMamNonDs.PhuongXaDataTable, hocSinhRow.PhuongXaId); } if (!hocSinhRow.IsQuanHuyenIdNull()) { hocSinhRow.QuanHuyen = StaticDataUtil.GetQuanHuyenById(StaticDataFacade.Get(StaticDataKeys.QuanHuyen) as QLMamNon.Dao.QLMamNonDs.QuanHuyenDataTable, hocSinhRow.QuanHuyenId); } } rpt.hocSinhBindingSource.DataSource = rows; }
private static Dictionary <int, Dictionary <int, ViewBangThuTienRow> > buildLopToHocSinhToViewBangThuTienRowsMap(ViewBangThuTienDataTable viewBangThuTienTable, DateTime ngayTinh) { List <int> hocSinhIds = new List <int>(); foreach (ViewBangThuTienRow viewBangThuTienRow in viewBangThuTienTable) { hocSinhIds.Add(viewBangThuTienRow.HocSinhId); } Dictionary <int, HocSinhLopRow> hocSinhIdsToHocSinhLops = StaticDataUtil.GetHocSinhLopsByHocSinhIds(hocSinhIds, ngayTinh); Dictionary <int, Dictionary <int, ViewBangThuTienRow> > lopToHocSinhViewBangThuTienRows = new Dictionary <int, Dictionary <int, ViewBangThuTienRow> >(); foreach (ViewBangThuTienRow viewBangThuTienRow in viewBangThuTienTable) { if (!hocSinhIdsToHocSinhLops.ContainsKey(viewBangThuTienRow.HocSinhId)) { continue; } int lopId = hocSinhIdsToHocSinhLops[viewBangThuTienRow.HocSinhId].LopId; if (!lopToHocSinhViewBangThuTienRows.ContainsKey(lopId)) { lopToHocSinhViewBangThuTienRows.Add(lopId, new Dictionary <int, ViewBangThuTienRow>()); } Dictionary <int, ViewBangThuTienRow> hocSinhToViewBangThuTienRows = lopToHocSinhViewBangThuTienRows[lopId]; hocSinhToViewBangThuTienRows.Add(viewBangThuTienRow.HocSinhId, viewBangThuTienRow); } return(lopToHocSinhViewBangThuTienRows); }
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); }
private void gvMain_CustomColumnDisplayText(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e) { ColumnView view = sender as ColumnView; if (e.Column.FieldName == "GioiTinh" && e.ListSourceRowIndex != DevExpress.XtraGrid.GridControl.InvalidRowHandle) { sbyte gioiTinh = (sbyte)view.GetListSourceRowCellValue(e.ListSourceRowIndex, "GioiTinh"); switch (gioiTinh) { case 0: e.DisplayText = "Nữ"; break; case 1: e.DisplayText = "Nam"; break; } } else if (e.Column.FieldName == "TinhThanhPhoId" && e.ListSourceRowIndex != DevExpress.XtraGrid.GridControl.InvalidRowHandle) { object tinhId = view.GetListSourceRowCellValue(e.ListSourceRowIndex, "TinhThanhPhoId"); if (tinhId != DBNull.Value) { e.DisplayText = StaticDataUtil.GetThanhPhoById(StaticDataFacade.Get(StaticDataKeys.TinhThanhPho) as QLMamNon.Dao.QLMamNonDs.ThanhPhoDataTable, (int)tinhId); } } else if (e.Column.FieldName == "QuanHuyenId" && e.ListSourceRowIndex != DevExpress.XtraGrid.GridControl.InvalidRowHandle) { object quanHuyenId = view.GetListSourceRowCellValue(e.ListSourceRowIndex, "QuanHuyenId"); if (quanHuyenId != DBNull.Value) { e.DisplayText = StaticDataUtil.GetQuanHuyenById(StaticDataFacade.Get(StaticDataKeys.QuanHuyen) as QLMamNon.Dao.QLMamNonDs.QuanHuyenDataTable, (int)quanHuyenId); } } else if (e.Column.FieldName == "PhuongXaId" && e.ListSourceRowIndex != DevExpress.XtraGrid.GridControl.InvalidRowHandle) { object phuongXaId = view.GetListSourceRowCellValue(e.ListSourceRowIndex, "PhuongXaId"); if (phuongXaId != DBNull.Value) { e.DisplayText = StaticDataUtil.GetPhuongXaById(StaticDataFacade.Get(StaticDataKeys.PhuongXa) as QLMamNon.Dao.QLMamNonDs.PhuongXaDataTable, (int)phuongXaId); } } else if (e.Column.FieldName == "NgaySinh" && e.ListSourceRowIndex != DevExpress.XtraGrid.GridControl.InvalidRowHandle && e.Value != DBNull.Value) { DateTime ngaySinh = (DateTime)e.Value; if (e.Column.Caption == "Ngay") { e.DisplayText = ngaySinh.Day.ToString(); } else if (e.Column.Caption == "Thang") { e.DisplayText = ngaySinh.Month.ToString(); } else if (e.Column.Caption == "Nam") { e.DisplayText = ngaySinh.Year.ToString(); } } else if (e.Column.Caption == this.GridViewColumnSequenceName && e.ListSourceRowIndex >= 0) { e.DisplayText = String.Format("{0}", e.ListSourceRowIndex + 1); } }
protected override void onSaving() { if (this.DataTable != null) { List <DataRow> deletedRow = new List <DataRow>(); List <DataRow> addedRow = new List <DataRow>(); List <DataRow> modifiedRow = new List <DataRow>(); foreach (DataRow row in this.DataTable.Rows) { if (row.RowState == DataRowState.Deleted) { deletedRow.Add(row); } else if (row.RowState == DataRowState.Added) { addedRow.Add(row); } if (row.RowState == DataRowState.Modified) { modifiedRow.Add(row); } } base.onSaving(); foreach (DataRow row in deletedRow) { QLMamNon.Dao.QLMamNonDs.LopRow lopRow = row as QLMamNon.Dao.QLMamNonDs.LopRow; this.lopKhoiTableAdapter.DeleteLopKhoiByLopId(lopRow.LopId); } foreach (DataRow row in modifiedRow) { QLMamNon.Dao.QLMamNonDs.LopRow lopRow = row as QLMamNon.Dao.QLMamNonDs.LopRow; int?khoiId = StaticDataUtil.GetKhoiIdByLopId(this.lopKhoiTableAdapter, lopRow.LopId); if (khoiId != null) { this.lopKhoiTableAdapter.DeleteLopKhoiByLopId(lopRow.LopId); } if (!lopRow.IsKhoiIdNull()) { this.lopKhoiTableAdapter.Insert(lopRow.LopId, lopRow.KhoiId); } } foreach (DataRow row in addedRow) { QLMamNon.Dao.QLMamNonDs.LopRow lopRow = row as QLMamNon.Dao.QLMamNonDs.LopRow; if (!lopRow.IsKhoiIdNull()) { this.lopKhoiTableAdapter.Insert(lopRow.LopId, lopRow.KhoiId); } } } }
protected override void fillRelativeMainDataTable() { QLMamNon.Dao.QLMamNonDs.ViewTaiSanDataTable dataTable = (QLMamNon.Dao.QLMamNonDs.ViewTaiSanDataTable) this.viewTaiSanRowBindingSource.DataSource; foreach (QLMamNon.Dao.QLMamNonDs.ViewTaiSanRow row in dataTable) { row.PhanLoaiTaiSan = StaticDataUtil.GetPhanLoaiChiNameByPhieuChiId(this.phieuChiTableAdapter, row.PhieuChiId); } }
private void UCEditFormKhoiHoc_Enter(object sender, EventArgs e) { QLMamNon.Dao.QLMamNonDs.KhoiRow row = this.GridView.GetFocusedDataRow() as QLMamNon.Dao.QLMamNonDs.KhoiRow; if (row != null) { this.cmbTruong.EditValue = StaticDataUtil.GetTruongIdByKhoiId(this.khoiTruongTableAdapter, row.KhoiId); } }
private void UCEditFormLopHoc_Enter(object sender, EventArgs e) { QLMamNon.Dao.QLMamNonDs.LopRow row = this.GridView.GetFocusedDataRow() as QLMamNon.Dao.QLMamNonDs.LopRow; if (row != null) { this.cmbKhoi.EditValue = StaticDataUtil.GetKhoiIdByLopId(this.lopKhoiTableAdapter, row.LopId); } }
public QLMamNon.Dao.QLMamNonDs.PhieuThuDataTable LoadPhieuThuByDateRangeWithGroupPhanLoaiThu(DateTime?fromDate, DateTime?toDate, List <int> phanLoaiThuIds) { PhieuThuTableAdapter phieuThuTableAdapter = (PhieuThuTableAdapter)StaticDataFacade.Get(StaticDataKeys.AdapterPhieuThu); QLMamNon.Dao.QLMamNonDs.PhieuThuDataTable table = phieuThuTableAdapter.GetDataByDateRangeWithGroupPhanLoaiThu(fromDate, toDate, StringUtil.JoinWithCommas(phanLoaiThuIds)); foreach (PhieuThuRow phieuThuRow in table) { phieuThuRow.PhanLoaiThu = StaticDataUtil.GetPhanLoaiThuById(phieuThuRow.PhanLoaiThuId); } return(table); }
private void loadLopData() { QLMamNon.Dao.QLMamNonDs.LopDataTable dataTable = this.lopTableAdapter.GetData(); foreach (QLMamNon.Dao.QLMamNonDs.LopRow row in dataTable) { int?khoiId = StaticDataUtil.GetKhoiIdByLopId(this.lopKhoiTableAdapter, row.LopId); if (khoiId.HasValue) { row.KhoiId = khoiId.Value; } } this.lopRowBindingSource.DataSource = dataTable; }
private void loadKhoiData() { QLMamNon.Dao.QLMamNonDs.KhoiDataTable dataTable = this.khoiTableAdapter.GetData(); foreach (QLMamNon.Dao.QLMamNonDs.KhoiRow row in dataTable) { int?truongId = StaticDataUtil.GetTruongIdByKhoiId(this.khoiTruongTableAdapter, row.KhoiId); if (truongId.HasValue) { row.TruongId = truongId.Value; } } this.khoiRowBindingSource.DataSource = dataTable; }
private void gvMain_CustomColumnDisplayText(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e) { ColumnView view = sender as ColumnView; if (e.Column.FieldName == "GioiTinh" && e.ListSourceRowIndex != DevExpress.XtraGrid.GridControl.InvalidRowHandle) { object objGioiTinh = view.GetListSourceRowCellValue(e.ListSourceRowIndex, "GioiTinh"); if (objGioiTinh != DBNull.Value) { sbyte gioiTinh = (sbyte)objGioiTinh; switch (gioiTinh) { case 0: e.DisplayText = "Nữ"; break; case 1: e.DisplayText = "Nam"; break; } } } else if (e.Column.FieldName == "TinhTPId" && e.ListSourceRowIndex != DevExpress.XtraGrid.GridControl.InvalidRowHandle) { object tinhId = view.GetListSourceRowCellValue(e.ListSourceRowIndex, "TinhTPId"); if (tinhId != DBNull.Value) { e.DisplayText = StaticDataUtil.GetThanhPhoById(StaticDataFacade.Get(StaticDataKeys.TinhThanhPho) as QLMamNon.Dao.QLMamNonDs.ThanhPhoDataTable, (int)tinhId); } } else if (e.Column.FieldName == "QuanHuyenId" && e.ListSourceRowIndex != DevExpress.XtraGrid.GridControl.InvalidRowHandle) { object quanHuyenId = view.GetListSourceRowCellValue(e.ListSourceRowIndex, "QuanHuyenId"); if (quanHuyenId != DBNull.Value) { e.DisplayText = StaticDataUtil.GetQuanHuyenById(StaticDataFacade.Get(StaticDataKeys.QuanHuyen) as QLMamNon.Dao.QLMamNonDs.QuanHuyenDataTable, (int)quanHuyenId); } } else if (e.Column.FieldName == "PhuongXaId" && e.ListSourceRowIndex != DevExpress.XtraGrid.GridControl.InvalidRowHandle) { object phuongXaId = view.GetListSourceRowCellValue(e.ListSourceRowIndex, "PhuongXaId"); if (phuongXaId != DBNull.Value) { e.DisplayText = StaticDataUtil.GetPhuongXaById(StaticDataFacade.Get(StaticDataKeys.PhuongXa) as QLMamNon.Dao.QLMamNonDs.PhuongXaDataTable, (int)phuongXaId); } } }
public QLMamNon.Dao.QLMamNonDs.PhieuThuDataTable LoadPhieuThu(HocSinhDataTable hocSinhTable) { PhieuThuTableAdapter phieuThuTableAdapter = (PhieuThuTableAdapter)StaticDataFacade.Get(StaticDataKeys.AdapterPhieuThu); PhieuThuDataTable table = phieuThuTableAdapter.GetData(); foreach (PhieuThuRow row in table) { if (!row.IsHocSinhIdNull()) { row.HocSinh = StaticDataUtil.GetHocSinhFullNameByHocSinhId(hocSinhTable, row.HocSinhId); } if (!row.IsPhanLoaiThuIdNull()) { row.PhanLoaiThu = StaticDataUtil.GetPhanLoaiThuById(row.PhanLoaiThuId); } } return(table); }
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; }
public int GenerateSoThuTienByHocSinhRows(DateTime ngayTinh, List <HocSinhRow> hocSinhRows) { ViewBangThuTienTableAdapter viewBangThuTienTableAdapter = (ViewBangThuTienTableAdapter)StaticDataFacade.Get(StaticDataKeys.AdapterViewBangThuTien); ViewBangThuTienDataTable viewBangThuTienTable = viewBangThuTienTableAdapter.GetViewBangThuTienByNgayTinhAndLop(ngayTinh, null); List <int> hocSinhIds = new List <int>(); List <HocSinhRow> needToGenerateHocSinhRows = new List <Dao.QLMamNonDs.HocSinhRow>(); foreach (HocSinhRow hocSinh in hocSinhRows) { DataRow[] rows = viewBangThuTienTable.Select(String.Format("HocSinhId={0}", hocSinh.HocSinhId)); if (ArrayUtil.IsEmpty(rows)) { hocSinhIds.Add(hocSinh.HocSinhId); needToGenerateHocSinhRows.Add(hocSinh); } } Dictionary <int, HocSinhLopRow> hocSinhIdsToHocSinhLops = StaticDataUtil.GetHocSinhLopsByHocSinhIds(hocSinhIds, ngayTinh); Dictionary <int, Dictionary <int, ViewBangThuTienRow> > lopToHocSinhToViewBangThuTienRowsMap = buildLopToHocSinhToViewBangThuTienRowsMap(viewBangThuTienTable, ngayTinh); Dictionary <int, Dictionary <int, ViewBangThuTienRow> > prevMonthLopToHocSinhToViewBangThuTienRowsMap = getAndSortPrevMonthViewBangThuTienRows(ngayTinh, viewBangThuTienTableAdapter, hocSinhIds, hocSinhIdsToHocSinhLops, lopToHocSinhToViewBangThuTienRowsMap); Dictionary <int, int> generatedLopToSTTs = buildGeneratedLopIdToSTTMap(lopToHocSinhToViewBangThuTienRowsMap); // Generate SoThuTien for HocSinhs that exist in previous month foreach (HocSinhRow hocSinh in needToGenerateHocSinhRows) { if (hocSinhIdsToHocSinhLops.ContainsKey(hocSinh.HocSinhId)) { int lopId = hocSinhIdsToHocSinhLops[hocSinh.HocSinhId].LopId; ViewBangThuTienRow preMonthViewBangThuTien = null; if (prevMonthLopToHocSinhToViewBangThuTienRowsMap.ContainsKey(lopId)) { Dictionary <int, ViewBangThuTienRow> prevMonthhocSinhToViewBangThuTienRowsMap = prevMonthLopToHocSinhToViewBangThuTienRowsMap[lopId]; if (prevMonthhocSinhToViewBangThuTienRowsMap.ContainsKey(hocSinh.HocSinhId)) { preMonthViewBangThuTien = prevMonthhocSinhToViewBangThuTienRowsMap[hocSinh.HocSinhId]; } } if (preMonthViewBangThuTien != null) { GenerateSoThuTienByHocSinhAndLopAndNgayTinh(hocSinh.HocSinhId, lopId, ngayTinh, preMonthViewBangThuTien.STT, preMonthViewBangThuTien); if (!generatedLopToSTTs.ContainsKey(lopId)) { generatedLopToSTTs.Add(lopId, 0); } int currentSTT = generatedLopToSTTs[lopId]; if (currentSTT < preMonthViewBangThuTien.STT) { generatedLopToSTTs[lopId] = preMonthViewBangThuTien.STT; } } } } // Generate SoThuTien for HocSinhs that NOT exist in previous month foreach (HocSinhRow hocSinh in needToGenerateHocSinhRows) { if (hocSinhIdsToHocSinhLops.ContainsKey(hocSinh.HocSinhId)) { int lopId = hocSinhIdsToHocSinhLops[hocSinh.HocSinhId].LopId; ViewBangThuTienRow preMonthViewBangThuTien = null; if (prevMonthLopToHocSinhToViewBangThuTienRowsMap.ContainsKey(lopId)) { Dictionary <int, ViewBangThuTienRow> prevMonthhocSinhToViewBangThuTienRowsMap = prevMonthLopToHocSinhToViewBangThuTienRowsMap[lopId]; if (prevMonthhocSinhToViewBangThuTienRowsMap.ContainsKey(hocSinh.HocSinhId)) { preMonthViewBangThuTien = prevMonthhocSinhToViewBangThuTienRowsMap[hocSinh.HocSinhId]; } } if (preMonthViewBangThuTien == null) { if (!generatedLopToSTTs.ContainsKey(lopId)) { generatedLopToSTTs.Add(lopId, 0); } int stt = generatedLopToSTTs[lopId] + 1; GenerateSoThuTienByHocSinhAndLopAndNgayTinh(hocSinh.HocSinhId, lopId, ngayTinh, stt, preMonthViewBangThuTien); generatedLopToSTTs[lopId] = stt; } } } return(hocSinhIds.Count); }
private void btnXemBaoCao_Click(object sender, EventArgs e) { if (ControlUtil.IsEditValueNull(this.cmbYear)) { MessageBox.Show("Xin vui lòng chọn năm", "Chọn năm", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } RptSoTheoDoiTaiSan rpt = new RptSoTheoDoiTaiSan(); QLMamNon.Dao.QLMamNonDs.ViewBanGiaoTaiSanDataTable table = this.viewBanGiaoTaiSanTableAdapter.GetDataByYear((int)cmbYear.EditValue); List <SoTheoDoiTaiSanItem> soTheoDoiTaiSan = new List <SoTheoDoiTaiSanItem>(); SoTheoDoiTaiSanItem prevSoTheoDoiTaiSanItem = null; SoTheoDoiTaiSanItem soTheoDoiTaiSanItem = null; foreach (QLMamNon.Dao.QLMamNonDs.ViewBanGiaoTaiSanRow row in table) { row.LopName = StaticDataUtil.GetLopNameByLopId(row.LopId); if (prevSoTheoDoiTaiSanItem != null && prevSoTheoDoiTaiSanItem.TaiSanId == row.TaiSanId) { soTheoDoiTaiSanItem = new SoTheoDoiTaiSanItem() { TaiSanId = row.TaiSanId, GhiChu = CommonConstant.EMPTY, LyDoGiam = "Bàn giao", NgayChungTuGiam = row.NgayChungTu, SoChungTuGiam = row.SoChungTu, SoLuongBanGiao = row.SoLuongBanGiao, SoTienBanGiao = row.DonGia * row.SoLuongBanGiao, }; } else { soTheoDoiTaiSanItem = new SoTheoDoiTaiSanItem() { TaiSanId = row.TaiSanId, Ten = row.Ten, DonGia = row.DonGia, DonViTinh = row.DonViTinh, GhiChu = CommonConstant.EMPTY, LyDoGiam = "Bàn giao", NgayChungTu = row.NgayChungTu, NgayChungTuGiam = row.NgayChungTu, SoChungTu = row.SoChungTu, SoChungTuGiam = row.SoChungTu, SoLuong = row.SoLuong, SoLuongBanGiao = row.SoLuongBanGiao, SoTienBanGiao = row.DonGia * row.SoLuongBanGiao, ThanhTien = row.SoLuong * row.DonGia }; } soTheoDoiTaiSan.Add(soTheoDoiTaiSanItem); prevSoTheoDoiTaiSanItem = soTheoDoiTaiSanItem; } rpt.bindingSource.DataSource = soTheoDoiTaiSan; rpt.Year.Value = this.cmbYear.EditValue; FormMainFacade.ShowReport(rpt); }
private void gvMain_CustomColumnDisplayText(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e) { ColumnView view = sender as ColumnView; if (e.Column.FieldName == "GioiTinh" && e.ListSourceRowIndex != DevExpress.XtraGrid.GridControl.InvalidRowHandle) { object objGioiTinh = view.GetListSourceRowCellValue(e.ListSourceRowIndex, "GioiTinh"); if (objGioiTinh != DBNull.Value) { sbyte gioiTinh = (sbyte)objGioiTinh; switch (gioiTinh) { case 0: e.DisplayText = "Nữ"; break; case 1: e.DisplayText = "Nam"; break; } } } else if (e.Column.FieldName == "ThoiHoc" && e.ListSourceRowIndex != DevExpress.XtraGrid.GridControl.InvalidRowHandle) { Object thoiHoc = view.GetListSourceRowCellValue(e.ListSourceRowIndex, "ThoiHoc"); e.DisplayText = (thoiHoc != null && thoiHoc.Equals(true)) ? "Thôi học" : "Đang học"; } else if (e.Column.FieldName == "TinhThanhPhoId" && e.ListSourceRowIndex != DevExpress.XtraGrid.GridControl.InvalidRowHandle) { object tinhId = view.GetListSourceRowCellValue(e.ListSourceRowIndex, "TinhThanhPhoId"); if (tinhId != DBNull.Value) { e.DisplayText = StaticDataUtil.GetThanhPhoById(StaticDataFacade.Get(StaticDataKeys.TinhThanhPho) as QLMamNon.Dao.QLMamNonDs.ThanhPhoDataTable, (int)tinhId); } } else if (e.Column.FieldName == "QuanHuyenId" && e.ListSourceRowIndex != DevExpress.XtraGrid.GridControl.InvalidRowHandle) { object quanHuyenId = view.GetListSourceRowCellValue(e.ListSourceRowIndex, "QuanHuyenId"); if (quanHuyenId != DBNull.Value) { e.DisplayText = StaticDataUtil.GetQuanHuyenById(StaticDataFacade.Get(StaticDataKeys.QuanHuyen) as QLMamNon.Dao.QLMamNonDs.QuanHuyenDataTable, (int)quanHuyenId); } } else if (e.Column.FieldName == "PhuongXaId" && e.ListSourceRowIndex != DevExpress.XtraGrid.GridControl.InvalidRowHandle) { object phuongXaId = view.GetListSourceRowCellValue(e.ListSourceRowIndex, "PhuongXaId"); if (phuongXaId != DBNull.Value) { e.DisplayText = StaticDataUtil.GetPhuongXaById(StaticDataFacade.Get(StaticDataKeys.PhuongXa) as QLMamNon.Dao.QLMamNonDs.PhuongXaDataTable, (int)phuongXaId); } } else if (e.Column.Caption == "NgaySinh" && e.ListSourceRowIndex != DevExpress.XtraGrid.GridControl.InvalidRowHandle && e.Value != DBNull.Value) { object ngaySinhObj = view.GetListSourceRowCellValue(e.ListSourceRowIndex, "NgaySinh"); if (ngaySinhObj != DBNull.Value) { DateTime ngaySinh = (DateTime)ngaySinhObj; e.DisplayText = ngaySinh.Day.ToString(); } } else if (e.Column.Caption == "ThangSinh" && e.ListSourceRowIndex != DevExpress.XtraGrid.GridControl.InvalidRowHandle && e.Value != DBNull.Value) { object ngaySinhObj = view.GetListSourceRowCellValue(e.ListSourceRowIndex, "NgaySinh"); if (ngaySinhObj != DBNull.Value) { DateTime ngaySinh = (DateTime)ngaySinhObj; e.DisplayText = ngaySinh.Month.ToString(); } } else if (e.Column.Caption == "NamSinh" && e.ListSourceRowIndex != DevExpress.XtraGrid.GridControl.InvalidRowHandle && e.Value != DBNull.Value) { object ngaySinhObj = view.GetListSourceRowCellValue(e.ListSourceRowIndex, "NgaySinh"); if (ngaySinhObj != DBNull.Value) { DateTime ngaySinh = (DateTime)ngaySinhObj; e.DisplayText = ngaySinh.Year.ToString(); } } }
protected override void onSaving() { DataTable table = this.DataTable.GetChanges(); if (table != null) { List <DataRow> deletedRow = new List <DataRow>(); List <DataRow> addedRow = new List <DataRow>(); List <DataRow> modifiedRow = new List <DataRow>(); foreach (DataRow row in table.Rows) { if (row.RowState == DataRowState.Deleted) { deletedRow.Add(row); } else if (row.RowState == DataRowState.Added) { addedRow.Add(row); } if (row.RowState == DataRowState.Modified) { modifiedRow.Add(row); } } base.onSaving(); foreach (DataRow row in deletedRow) { QLMamNon.Dao.QLMamNonDs.KhoiRow khoiRow = row as QLMamNon.Dao.QLMamNonDs.KhoiRow; this.khoiTruongTableAdapter.DeleteKhoiTruongByKhoiId(khoiRow.KhoiId); } foreach (DataRow row in modifiedRow) { QLMamNon.Dao.QLMamNonDs.KhoiRow khoiRow = row as QLMamNon.Dao.QLMamNonDs.KhoiRow; QLMamNon.Dao.QLMamNonDs.KhoiTruongRow khoiTruongRow = StaticDataUtil.GetKhoiTruongByKhoiId(this.khoiTruongTableAdapter, khoiRow.KhoiId); if (khoiTruongRow != null) { this.khoiTruongTableAdapter.DeleteKhoiTruongByKhoiId(khoiRow.KhoiId); } if (!khoiRow.IsTruongIdNull()) { this.khoiTruongTableAdapter.Insert(khoiRow.KhoiId, khoiRow.TruongId); } } foreach (DataRow row in addedRow) { QLMamNon.Dao.QLMamNonDs.KhoiRow khoiRow = row as QLMamNon.Dao.QLMamNonDs.KhoiRow; if (!khoiRow.IsTruongIdNull()) { this.khoiTruongTableAdapter.Insert(khoiRow.KhoiId, khoiRow.TruongId); } } } }
private void addPhieuThuToReport(SortedList soQuyTienMatMap, DateTime fromDate, DateTime toDate, List <int> phanLoaiThuIds) { PhieuThuTableAdapter phieuThuTableAdapter = (PhieuThuTableAdapter)StaticDataFacade.Get(StaticDataKeys.AdapterPhieuThu); QLMamNon.Dao.QLMamNonDs.PhieuThuDataTable phieuThuDataTable = phieuThuTableAdapter.GetDataForSoQuyTienMat(fromDate, toDate, StringUtil.JoinWithCommas(phanLoaiThuIds)); Dictionary <string, SoQuyTienMatItem> groupDateToSoQuyTienMatItemsMap = new Dictionary <string, SoQuyTienMatItem>(); foreach (QLMamNon.Dao.QLMamNonDs.PhieuThuRow phieuThuRow in phieuThuDataTable) { phieuThuRow.PhanLoaiThu = phieuThuRow.IsPhanLoaiThuIdNull() ? "Thu tiền học phí" : StaticDataUtil.GetPhanLoaiThuById(phieuThuRow.PhanLoaiThuId); int groupDate = getGroupDate(fromDate, phieuThuRow); DateTime dateOfGroup = fromDate.AddDays((groupDate + 1) * NumberOfDateToGroupPhieuThu - 1); if (dateOfGroup > toDate) { dateOfGroup = toDate; } string key = StringUtil.Join(new int[] { groupDate, phieuThuRow.PhanLoaiThuId }, "~"); if (!groupDateToSoQuyTienMatItemsMap.ContainsKey(key)) { groupDateToSoQuyTienMatItemsMap.Add(key, new SoQuyTienMatItem() { DienGiai = phieuThuRow.PhanLoaiThu, NgayChungTu = dateOfGroup, SoTienThu = 0 }); } } foreach (QLMamNon.Dao.QLMamNonDs.PhieuThuRow phieuThuRow in phieuThuDataTable) { int groupDate = getGroupDate(fromDate, phieuThuRow); string key = StringUtil.Join(new int[] { groupDate, phieuThuRow.PhanLoaiThuId }, "~"); SoQuyTienMatItem soQuyTienMatItemThu = groupDateToSoQuyTienMatItemsMap[key]; soQuyTienMatItemThu.SoTienThu += phieuThuRow.SoTien; } int addedCount = 0; foreach (SoQuyTienMatItem soQuyTienMatItemThu in groupDateToSoQuyTienMatItemsMap.Values) { soQuyTienMatMap.Add(soQuyTienMatItemThu.NgayChungTu.AddMilliseconds(addedCount++), soQuyTienMatItemThu); } }