private void btnInDanhSach_Click(object sender, EventArgs e) { if (cmbLoaiThuChi.EditValue != null && grvTongHop.DataRowCount > 0) { DataTable dtReport = dtTongHop.Copy(); dtReport.Columns.Add("TenLoaiThuChi", typeof(string)); dtReport.Columns.Add("NoiDungBaoCao", typeof(string)); dtReport.Columns.Add("HeTrinhDo", typeof(string)); dtReport.Columns.Add("TongTienBangChu", typeof(string)); dtReport.Rows[0]["TenLoaiThuChi"] = cmbLoaiThuChi.Text.ToUpper(); if (rdDanhSach.EditValue.ToString() == "0") { dtReport.Rows[0]["NoiDungBaoCao"] = "Từ " + dtpTuNgay.Text + " đến " + dtpDenNgay.Text; } else if (rdDanhSach.EditValue.ToString() == "1") { dtReport.Rows[0]["NoiDungBaoCao"] = "Học kỳ: " + Program.HocKy.ToString() + " - Năm học: " + Program.NamHoc; } else { dtReport.Rows[0]["NoiDungBaoCao"] = "Năm học: " + Program.NamHoc; } string HeTrinhDo = ""; if (ucLocHeTrinhDo.cmbHe.EditValue != null) { HeTrinhDo = "HỆ: " + ucLocHeTrinhDo.cmbHe.Text.ToUpper(); } if (ucLocHeTrinhDo.cmbTrinhDo.EditValue != null) { HeTrinhDo += (HeTrinhDo == "" ? "TRÌNH ĐỘ: " : " - TRÌNH ĐỘ: ") + ucLocHeTrinhDo.cmbTrinhDo.Text.ToUpper(); } if (cmbCoSo.EditValue != null) { HeTrinhDo += (HeTrinhDo == "" ? "TẠI: " : " - TẠI: ") + cmbCoSo.Text.ToUpper(); } dtReport.Rows[0]["HeTrinhDo"] = HeTrinhDo; Lib.clsStringHelper cls = new Lib.clsStringHelper(); dtReport.Rows[dtReport.Rows.Count - 1]["TongTienBangChu"] = cls.ReadMoney(TongThu) + " đồng."; frmReport frm = new frmReport(dtReport, dtReport, "rBangKeThuChi", "rBangTongHopThuChi", new string[] { "Subreport1" }); frm.Show(); } else { ThongBao("Chưa chọn loại thu chi."); } }
private void LapBienLaiThuTien(DataTable dtDinhMuc, int IDSV_SinhVien) { // Them bien lai thu tien pTC_BienLaiThuTienInfo = new TC_BienLaiThuTienInfo(); pTC_BienLaiThuTienInfo.GhiChu = ""; pTC_BienLaiThuTienInfo.HocKy = Program.HocKy; pTC_BienLaiThuTienInfo.IDDM_NamHoc = Program.IDNamHoc; pTC_BienLaiThuTienInfo.IDHT_NguoiThu = Program.objUserCurrent.HT_UserID; pTC_BienLaiThuTienInfo.IDSV_SinhVien = IDSV_SinhVien; pTC_BienLaiThuTienInfo.IDDM_Lop = pDM_LopInfo.DM_LopID; pTC_BienLaiThuTienInfo.NgayThu = DateTime.Now; pTC_BienLaiThuTienInfo.NoiDung = "THU TIỀN HỌC KỲ " + Program.HocKy.ToString() + " NĂM HỌC " + Program.NamHoc; pTC_BienLaiThuTienInfo.PhieuThu = true; pTC_BienLaiThuTienInfo.Printed = false; pTC_BienLaiThuTienInfo.SoPhieu = GetSoPhieu(Program.HocKy, Program.IDNamHoc, IDSV_SinhVien, pDM_LopInfo.IDDM_DiaDiem); //dtDinhMuc.Columns[3]. pTC_BienLaiThuTienInfo.SoTien = SumColumnValue(dtDinhMuc, "SoTien"); pTC_BienLaiThuTienInfo.SoTienBangChu = clsStrHelper.ReadMoney(pTC_BienLaiThuTienInfo.SoTien) + " đồng"; pTC_BienLaiThuTienInfo.PhieuHuy = false; pTC_BienLaiThuTienInfo.NgayHuy = DateTime.Parse("1/1/1900"); int intTC_BienLaiThuTienID = oBTC_BienLaiThuTien.Add(pTC_BienLaiThuTienInfo); // them bien lai thu tien chi tiet foreach (DataRow mdr in dtDinhMuc.Rows) { if (float.Parse("0" + mdr["SoTien"].ToString()) > 0 && mdr["TC_LoaiThuChiID"].ToString() != "") { pTC_BienLaiThuTien_ChiTietInfo = new TC_BienLaiThuTien_ChiTietInfo(); pTC_BienLaiThuTien_ChiTietInfo.IDTC_BienLaiThuTien = intTC_BienLaiThuTienID; pTC_BienLaiThuTien_ChiTietInfo.IDTC_DinhMucThuSinhVien = int.Parse("0" + mdr["IDTC_DinhMucThuSinhVien"].ToString()); pTC_BienLaiThuTien_ChiTietInfo.IDTC_LoaiThuChi = int.Parse(mdr["TC_LoaiThuChiID"].ToString()); pTC_BienLaiThuTien_ChiTietInfo.LanThu = int.Parse("0" + mdr["LanThu"].ToString()); pTC_BienLaiThuTien_ChiTietInfo.NoiDung = mdr["NoiDung"].ToString(); pTC_BienLaiThuTien_ChiTietInfo.SoTien = float.Parse("0" + mdr["SoTien"].ToString()); oBTC_BienLaiThuTien_ChiTiet.Add(pTC_BienLaiThuTien_ChiTietInfo); } } }
private void btnInDanhSach_Click(object sender, EventArgs e) { dlgLopFilter dlg = new dlgLopFilter(); if (dlg.ShowDialog() == DialogResult.Yes) { DM_LopInfo pDM_LopFilterInfo = dlg.pDM_LopInfo; DataTable dtMain = oBTC_DanhSachHocBong.GetInSinhVienByKyTruoc(pDM_LopFilterInfo, Program.IDNamHoc, Program.HocKy, Program.NamHoc, int.Parse(cmbThang.Text)); if (dtMain.Rows.Count > 0) { dtMain.Columns.Add("Thang", typeof(string)); dtMain.Columns.Add("TenNam", typeof(string)); dtMain.Columns.Add("HeTrinhDo", typeof(string)); dtMain.Columns.Add("TongTienBangChu", typeof(string)); dtMain.Rows[0]["Thang"] = cmbThang.Text; if (7 <= int.Parse(cmbThang.Text) && int.Parse(cmbThang.Text) <= 12) { dtMain.Rows[0]["TenNam"] = Program.NamHoc.Substring(0, 4); } else { dtMain.Rows[0]["TenNam"] = Program.NamHoc.Substring(5); } double SoTien = double.Parse(dtMain.Compute("Sum(SoTienConLai)", "").ToString()); Lib.clsStringHelper cls = new Lib.clsStringHelper(); dtMain.Rows[dtMain.Rows.Count - 1]["TongTienBangChu"] = cls.ReadMoney(SoTien); dtMain.Rows[0]["HeTrinhDo"] = dlg.HeTrinhDo; frmReport frm = new frmReport(dtMain, dtMain, "rDanhSachHocBong_ChiTiet", "rDanhSachHocBong_BangKe", new string[] { "Subreport1" }); frm.ShowDialog(); } else { ThongBao("Không có dữ liệu để in báo cáo!"); } } }