private void grvSoPhieu_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e) { if (grvSoPhieu.FocusedRowHandle >= 0) { drSoPhieu = grvSoPhieu.GetDataRow(grvSoPhieu.FocusedRowHandle); grdChiTiet.DataSource = oBTC_BienLaiThuTien.GetChiTiet(int.Parse(drSoPhieu["TC_BienLaiThuTienID"].ToString())); } else { grdChiTiet.DataSource = null; } }
private void LoadThongTin() { pSV_SinhVienNhapTruongInfo.SV_SinhVienNhapTruongID = SV_SinhVienID; DataTable dtTemp = oBSV_SinhVienNhapTruong.Get(pSV_SinhVienNhapTruongInfo); if (Sua == false) { lbTotal.Text = "0"; } if (dtTemp != null && dtTemp.Rows.Count > 0) { txtHoVaTen.Text = dtTemp.Rows[0]["HoVaTenTS"].ToString(); DataTable dtData; double TongTien = 0; DataTable dtDuLieu = LoadLoaiThuChi(); dtDuLieu.DefaultView.RowFilter = "KhoanThu = 1"; repositoryLoaiThuChi.DataSource = dtDuLieu.DefaultView; if (Sua == true) { dtData = oBTC_DinhMucThuSinhVien.GetBy_SinhVien(0, Program.IDNamHoc, Program.HocKy, 1, 1, SV_SinhVienID); // repositoryLoaiThuChi.DataSource = dtData; if (dtData.Rows.Count > 0) { TC_BienLaiThuTienID = int.Parse("0" + dtData.Rows[0]["TC_BienLaiThuTienID"].ToString()); } pTC_BienLaiThuTienInfo.TC_BienLaiThuTienID = TC_BienLaiThuTienID; dtLoaiThuChi = oBTC_BienLaiThuTien.GetChiTiet(pTC_BienLaiThuTienInfo.TC_BienLaiThuTienID); // repositoryLoaiThuChi.DataSource = oBTC_DinhMucThuSinhVien.GetBy_SinhVien(0, Program.IDNamHoc, Program.HocKy, 1, 0, SV_SinhVienID); } else { dtData = oBTC_DinhMucThuSinhVien.GetBy_SinhVien(0, Program.IDNamHoc, Program.HocKy, 1, 0, SV_SinhVienID); pTC_BienLaiThuTienInfo.TC_BienLaiThuTienID = 0; dtLoaiThuChi = dtData;// oBTC_DinhMucThuSinhVien.GetBy_SinhVien(0, Program.IDNamHoc, Program.HocKy, 1, 0, SV_SinhVienID); } for (int i = 0; i < dtLoaiThuChi.Rows.Count; i++) { TongTien += double.Parse("0" + dtLoaiThuChi.Rows[i]["SoTien"]); } grdLoaiThuChi.DataSource = dtLoaiThuChi; lbTotal.Text = TongTien.ToString("N0"); pTC_BienLaiThuTienInfo.TC_BienLaiThuTienID = 0; } }
private void LoadThongTin() { pSV_SinhVienInfo.SV_SinhVienID = SV_SinhVienID; DataTable dtTemp = oBSV_SinhVien.Get(pSV_SinhVienInfo); if (Sua == false) { lbTotal.Text = "0"; } if (dtTemp != null && dtTemp.Rows.Count > 0) { txtTenLop.Text = dtTemp.Rows[0]["TenLop"].ToString(); txtHoVaTen.Text = dtTemp.Rows[0]["HoVaTen"].ToString(); repositoryLoaiThuChi.DataSource = oBTC_DinhMucThuSinhVien.GetBy_SinhVien(SV_SinhVienID, Program.IDNamHoc, Program.HocKy, int.Parse(rdThuChi.EditValue.ToString()), 0, 0); //if (Sua == false) //{ // dtLoaiThuChi = oBTC_DinhMucThuSinhVien.GetBy_SinhVien(SV_SinhVienID, Program.IDNamHoc, Program.HocKy, int.Parse(rdThuChi.EditValue.ToString())); // grdLoaiThuChi.DataSource = dtLoaiThuChi; //} //else //{ if (Sua == true) { pTC_BienLaiThuTienInfo.TC_BienLaiThuTienID = int.Parse("0" + dr["TC_BienLaiThuTienID"].ToString()); dtLoaiThuChi = oBTC_BienLaiThuTien.GetChiTiet(pTC_BienLaiThuTienInfo.TC_BienLaiThuTienID); grdLoaiThuChi.DataSource = dtLoaiThuChi; } else { double TongTien = 0; pTC_BienLaiThuTienInfo.TC_BienLaiThuTienID = 0; dtLoaiThuChi = oBTC_DinhMucThuSinhVien.GetBy_SinhVien(SV_SinhVienID, Program.IDNamHoc, Program.HocKy, int.Parse(rdThuChi.EditValue.ToString()), 1, 0); TongTien = SumColumnValue(dtLoaiThuChi, "SoTien"); grdLoaiThuChi.DataSource = dtLoaiThuChi; lbTotal.Text = TongTien.ToString("N0"); } pTC_BienLaiThuTienInfo.TC_BienLaiThuTienID = 0; // } } }