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