public static void InphieuDieuTri(DataTable dtPrint, DateTime ngayin)
{
string tieude = "", reportname = "";
var crpt = Utility.GetReport("noitru_phieudieutri", ref tieude, ref reportname);
if (crpt == null)
{
return;
}
//var crpt = new crpt_PhieuDieuTri();
var objForm = new frmPrintPreview("IN PHIẾU ĐIỀU TRỊ", crpt, true, true);
crpt.SetDataSource(dtPrint);
objForm.mv_sReportFileName = Path.GetFileName(reportname);
objForm.mv_sReportCode = "noitru_phieudieutri";
Utility.SetParameterValue(crpt, "ParentBranchName", globalVariables.ParentBranch_Name);
Utility.SetParameterValue(crpt, "BranchName", globalVariables.Branch_Name);
Utility.SetParameterValue(crpt, "CurrentDate", Utility.FormatDateTime(ngayin));
Utility.SetParameterValue(crpt, "sTitleReport", tieude);
Utility.SetParameterValue(crpt, "BottomCondition", THU_VIEN_CHUNG.BottomCondition());
objForm.crptViewer.ReportSource = crpt;
objForm.ShowDialog();
objForm.Dispose();
}
/// <summary>
/// hàm thực hiện việc in phiếu dịch vụ
/// </summary>
/// <param name="m_dtReportPhieuThu"></param>
/// <param name="NgayInPhieu"></param>
/// <param name="sTitleReport"></param>
public void LAOKHOA_INPHIEU_DICHVU(DataTable m_dtReportPhieuThu, DateTime NgayInPhieu, string sTitleReport)
{
Utility.UpdateLogotoDatatable(ref m_dtReportPhieuThu);
string tieude = "", reportname = "";
var crpt = Utility.GetReport("thanhtoan_crpt_PhieuDV_A5", ref tieude, ref reportname);
if (crpt == null)
{
return;
}
var objForm = new frmPrintPreview("", crpt, true, true);
//try
//{
crpt.SetDataSource(m_dtReportPhieuThu);
//crpt.DataDefinition.FormulaFields["Formula_1"].Text = Strings.Chr(34) + " ".Replace("#$X$#", Strings.Chr(34) + "&Chr(13)&" + Strings.Chr(34)) + Strings.Chr(34);
Utility.SetParameterValue(crpt, "ParentBranchName", globalVariables.ParentBranch_Name);
Utility.SetParameterValue(crpt, "BranchName", globalVariables.Branch_Name);
Utility.SetParameterValue(crpt, "Telephone", globalVariables.Branch_Phone);
Utility.SetParameterValue(crpt, "Address", globalVariables.Branch_Address);
// Utility.SetParameterValue(crpt,"DateTime", Utility.FormatDateTime(dtCreateDate.Value));
Utility.SetParameterValue(crpt, "CurrentDate", Utility.FormatDateTime(NgayInPhieu));
Utility.SetParameterValue(crpt, "sTitleReport", sTitleReport);
Utility.SetParameterValue(crpt, "sMoneyCharacter",
new MoneyByLetter().sMoneyToLetter(SumOfTotal(m_dtReportPhieuThu).ToString()));
Utility.SetParameterValue(crpt, "BottomCondition", THU_VIEN_CHUNG.BottomCondition());
objForm.crptViewer.ReportSource = crpt;
objForm.ShowDialog();
}
/// <summary>
/// hàm thực hiện việc in phiếu báo cáo tổng hợp
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void cmdInPhieuXN_Click(object sender, EventArgs e)
{
_dtData = BAOCAO_NGOAITRU.BaocaoTamungHoanung(Utility.Int16Dbnull(txtNhanvien.MyID, -1), chkByDate.Checked?dtFromDate.Value.ToString("dd/MM/yyyy"):"01/01/1900",
chkByDate.Checked ? dtToDate.Value.ToString("dd/MM/yyyy") : "01/01/1900",
Utility.Int16Dbnull(cbokhoa.SelectedValue, -1),
Utility.Int16Dbnull(cboDoituongKCB.SelectedValue, -1),
Utility.Bool2byte(optHoanung.Checked)
);
Utility.SetDataSourceForDataGridEx(grdList, _dtData, false, true, "1=1", "");
Utility.UpdateLogotoDatatable(ref _dtData);
THU_VIEN_CHUNG.CreateXML(_dtData, "baocao_tamung.xml");
if (_dtData.Rows.Count <= 0)
{
Utility.ShowMsg("Không tìm thấy dữ liệu báo cáo theo điều kiện bạn chọn", "Thông báo", MessageBoxIcon.Information);
return;
}
string Condition = string.Format("Từ ngày {0} đến {1} - Thu ngân viên :{2} ", dtFromDate.Text, dtToDate.Text, txtNhanvien.Text);
var crpt = Utility.GetReport(optTamung.Checked?"baocao_tamung":"baocao_hoanung", ref tieude, ref reportname);
if (crpt == null)
{
return;
}
string StaffName = globalVariables.gv_strTenNhanvien;
if (string.IsNullOrEmpty(globalVariables.gv_strTenNhanvien))
{
StaffName = globalVariables.UserName;
}
try
{
frmPrintPreview objForm = new frmPrintPreview(tieude, crpt, true, _dtData.Rows.Count <= 0 ? false : true);
//try
//{
crpt.SetDataSource(_dtData);
objForm.mv_sReportFileName = Path.GetFileName(reportname);
objForm.mv_sReportCode = optTamung.Checked?"baocao_tamung":"baocao_hoanung";
Utility.SetParameterValue(crpt, "StaffName", StaffName);
Utility.SetParameterValue(crpt, "ParentBranchName", globalVariables.ParentBranch_Name);
Utility.SetParameterValue(crpt, "BranchName", globalVariables.Branch_Name);
Utility.SetParameterValue(crpt, "Address", globalVariables.Branch_Address);
Utility.SetParameterValue(crpt, "Phone", globalVariables.Branch_Phone);
Utility.SetParameterValue(crpt, "FromDateToDate", Condition);
Utility.SetParameterValue(crpt, "sTitleReport", tieude);
Utility.SetParameterValue(crpt, "Tongtien_chu", new MoneyByLetter().sMoneyToLetter(_dtData.Compute("SUM(so_tien)", "1=1").ToString()));
Utility.SetParameterValue(crpt, "sCurrentDate", Utility.FormatDateTimeWithThanhPho(dtNgayInPhieu.Value));
Utility.SetParameterValue(crpt, "BottomCondition", THU_VIEN_CHUNG.BottomCondition());
objForm.crptViewer.ReportSource = crpt;
objForm.ShowDialog();
}
catch (Exception ex)
{
Utility.CatchException(ex);
}
}
private void cmdInPhieu_Click(object sender, EventArgs e)
{
int trangthai = -1;
DataTable dtDanhsach =
SPs.BhytBaocaoDongchitra(dtFromDate.Value, dtToDate.Value,
Utility.sDbnull(cboKhoa.SelectedValue, "KKB"), globalVariables.gv_intIDNhanvien, trangthai)
.GetDataSet().Tables[0];
Utility.SetDataSourceForDataGridEx(grdResult, dtDanhsach, false, false, "", "");
THU_VIEN_CHUNG.CreateXML(dtDanhsach, "BHYT_baocao_dongchitra.XML");
Utility.UpdateLogotoDatatable(ref dtDanhsach);
string reportCode = "BHYT_baocao_dongchitra";
string Condition =
string.Format("Từ ngày {0} đến {1} - Khoa KCB :{2}",
dtFromDate.Text, dtToDate.Text, globalVariables.MA_KHOA_THIEN);
ReportDocument crpt = Utility.GetReport(reportCode, ref tieude, ref reportname);
if (crpt == null)
{
return;
}
string StaffName = globalVariables.gv_strTenNhanvien;
if (string.IsNullOrEmpty(globalVariables.gv_strTenNhanvien))
{
StaffName = globalVariables.UserName;
}
try
{
var objForm = new frmPrintPreview(tieude, crpt, true, dtDanhsach.Rows.Count <= 0 ? false : true);
crpt.SetDataSource(dtDanhsach);
objForm.mv_sReportFileName = Path.GetFileName(reportname);
objForm.mv_sReportCode = reportCode;
crpt.SetParameterValue("StaffName", StaffName);
crpt.SetParameterValue("ParentBranchName", globalVariables.ParentBranch_Name);
crpt.SetParameterValue("BranchName", globalVariables.Branch_Name);
crpt.SetParameterValue("Address", globalVariables.Branch_Address);
crpt.SetParameterValue("Phone", globalVariables.Branch_Phone);
crpt.SetParameterValue("FromDateToDate", Condition);
crpt.SetParameterValue("sTitleReport", tieude);
crpt.SetParameterValue("sCurrentDate", Utility.FormatDateTimeWithThanhPho(dtNgayInPhieu.Value));
crpt.SetParameterValue("BottomCondition", THU_VIEN_CHUNG.BottomCondition());
Utility.SetParameterValue(crpt, "txtTrinhky", Utility.getTrinhky(objForm.mv_sReportFileName, globalVariables.SysDate));
objForm.crptViewer.ReportSource = crpt;
objForm.ShowDialog();
}
catch (Exception exception)
{
Utility.ShowMsg("Lỗi:" + exception.Message);
}
finally
{
Utility.FreeMemory(crpt);
}
}
void cmdPrint_Click(object sender, EventArgs e)
{
Utility.WaitNow(this);
DataTable dtData =
SPs.KcbThamkhamPhieuchuyenvien(Utility.DoTrim(txtMaluotkham.Text)).GetDataSet().Tables[0];
if (dtData.Rows.Count <= 0)
{
Utility.ShowMsg("Không tìm thấy dữ liệu cho báo cáo", "Thông báo", MessageBoxIcon.Warning);
return;
}
THU_VIEN_CHUNG.CreateXML(dtData, "thamkham_phieuchuyenvien.XML");
Utility.UpdateLogotoDatatable(ref dtData);
string StaffName = globalVariables.gv_strTenNhanvien;
if (string.IsNullOrEmpty(globalVariables.gv_strTenNhanvien))
{
StaffName = globalVariables.UserName;
}
string tieude = "", reportname = "";
ReportDocument crpt = Utility.GetReport("thamkham_phieuchuyenvien", ref tieude, ref reportname);
if (crpt == null)
{
return;
}
try
{
frmPrintPreview objForm = new frmPrintPreview("PHIẾU CHUYỂN TUYẾN", crpt, true, dtData.Rows.Count <= 0 ? false : true);
crpt.SetDataSource(dtData);
objForm.mv_sReportFileName = Path.GetFileName(reportname);
objForm.mv_sReportCode = "thamkham_phieuchuyenvien";
Utility.SetParameterValue(crpt, "StaffName", StaffName);
Utility.SetParameterValue(crpt, "BranchName", globalVariables.Branch_Name);
Utility.SetParameterValue(crpt, "ParentBranchName", globalVariables.ParentBranch_Name);
Utility.SetParameterValue(crpt, "Address", globalVariables.Branch_Address);
Utility.SetParameterValue(crpt, "Phone", globalVariables.Branch_Phone);
Utility.SetParameterValue(crpt, "sTitleReport", tieude);
Utility.SetParameterValue(crpt, "CurrentDate", Utility.FormatDateTimeWithThanhPho(dtpNgayin.Value));
Utility.SetParameterValue(crpt, "BottomCondition", THU_VIEN_CHUNG.BottomCondition());
Utility.SetParameterValue(crpt, "txtTrinhky", Utility.getTrinhky(objForm.mv_sReportFileName, globalVariables.SysDate));
objForm.crptViewer.ReportSource = crpt;
objForm.ShowDialog();
}
catch (Exception ex)
{
Utility.CatchException(ex);
}
finally
{
Utility.DefaultNow(this);
GC.Collect();
Utility.FreeMemory(crpt);
}
}
public static void INMAU_CHUYENKHAM_CHUYENKHOA(DataTable mDtReport, string sTitleReport, string report,
string lydochuyen)
{
Utility.UpdateLogotoDatatable(ref mDtReport);
string tieude = "", reportname = "";
ReportDocument reportDocument = report == "PHIEUKHAM_CHUYENKHOA"
? Utility.GetReport("thamkham_phieukham_chuyenkhoa", ref tieude, ref reportname)
: Utility.GetReport("thamkham_phieuxn_benhpham", ref tieude, ref reportname);
if (reportDocument == null)
{
return;
}
ReportDocument crpt = reportDocument;
var objForm = new frmPrintPreview(sTitleReport, crpt, true, mDtReport.Rows.Count > 0);
try
{
mDtReport.AcceptChanges();
objForm.mv_sReportFileName = Path.GetFileName(reportname);
objForm.mv_sReportCode = "thamkham_phieukham_chuyenkhoa";
crpt.SetDataSource(mDtReport);
Utility.SetParameterValue(crpt, "Phone", globalVariables.Branch_Phone + globalVariables.SOMAYLE);
Utility.SetParameterValue(crpt, "Address", globalVariables.Branch_Address);
Utility.SetParameterValue(crpt, "BranchName", globalVariables.Branch_Name);
Utility.SetParameterValue(crpt, "CurrentDate", Utility.FormatDateTime(globalVariables.SysDate));
Utility.SetParameterValue(crpt, "sTitleReport", tieude);
Utility.SetParameterValue(crpt, "lydochuyen", lydochuyen);
Utility.SetParameterValue(crpt, "BottomCondition", THU_VIEN_CHUNG.BottomCondition());
Utility.SetParameterValue(crpt, "txtTrinhky",
Utility.getTrinhky(objForm.mv_sReportFileName,
globalVariables.SysDate));
objForm.crptViewer.ReportSource = crpt;
objForm.ShowDialog();
//if (Utility.isPrintPreview(PropertyLib._MayInProperties.TenMayInPhieuKCB, PropertyLib._MayInProperties.PreviewPhieuKCB))
//{
// objForm.SetDefaultPrinter(PropertyLib._MayInProperties.TenMayInPhieuKCB, 0);
// objForm.ShowDialog();
//}
//else
//{
// objForm.addTrinhKy_OnFormLoad();
// crpt.PrintOptions.PrinterName = PropertyLib._MayInProperties.TenMayInBienlai;
// crpt.PrintToPrinter(1, false, 0, 0);
//}
}
catch (Exception ex)
{
Utility.ShowMsg(ex.ToString());
}
finally
{
GC.Collect();
}
}
/// <summary>
/// HÀM THỰC HIỆN VIỆC IN PHIẾU BIÊN LAI CHO BẢO HIỂM Y TẾ
/// </summary>
/// <param name="m_dtReportPhieuThu"></param>
/// <param name="sTitleReport"></param>
/// <param name="ngayIn"></param>
public void LAOKHOA_INPHIEU_BIENLAI_BHYT(DataTable m_dtReportPhieuThu, string sTitleReport, DateTime ngayIn)
{
if (m_dtReportPhieuThu.Rows.Count <= 0)
{
Utility.ShowMsg("Không tìm thấy bản ghi nào", "Thông báo", MessageBoxIcon.Warning);
return;
}
Utility.UpdateLogotoDatatable(ref m_dtReportPhieuThu);
THU_VIEN_CHUNG.Sapxepthutuin(ref m_dtReportPhieuThu, true);
m_dtReportPhieuThu.DefaultView.Sort = "THU_TU ASC";
m_dtReportPhieuThu.AcceptChanges();
decimal phuthu = SumOfTotal(m_dtReportPhieuThu, "PHU_THU");
decimal bnct = SumOfTotal(m_dtReportPhieuThu, "BNCT");
decimal Total = bnct + phuthu;
string tieude = "", reportname = "";
ReportDocument crpt = Utility.GetReport("thanhtoan_Bienlai_BHYT_A4", ref tieude, ref reportname);
if (PropertyLib._MayInProperties.CoGiayInBienlai == Papersize.A4)
{
crpt = Utility.GetReport("thanhtoan_Bienlai_BHYT_A4", ref tieude, ref reportname);
}
else
{
crpt = Utility.GetReport("thanhtoan_Bienlai_BHYT_A5", ref tieude, ref reportname);
}
if (crpt == null)
{
return;
}
var objForm = new frmPrintPreview(sTitleReport, crpt, true, true);
//try
//{
crpt.SetDataSource(m_dtReportPhieuThu.DefaultView);
//crpt.DataDefinition.FormulaFields["Formula_1"].Text = Strings.Chr(34) + " Nhân viên ".Replace("#$X$#", Strings.Chr(34) + "&Chr(13)&" + Strings.Chr(34)) + Strings.Chr(34);
Utility.SetParameterValue(crpt, "Phone", globalVariables.Branch_Phone);
Utility.SetParameterValue(crpt, "Address", globalVariables.Branch_Address);
//Utility.SetParameterValue(crpt,"ParentBranchName", globalVariables.ParentBranch_Name);
Utility.SetParameterValue(crpt, "BranchName", globalVariables.Branch_Name);
Utility.SetParameterValue(crpt, "CurrentDate", Utility.FormatDateTime(ngayIn));
Utility.SetParameterValue(crpt, "sTitleReport", sTitleReport);
Utility.SetParameterValue(crpt, "BottomCondition", THU_VIEN_CHUNG.BottomCondition());
Utility.SetParameterValue(crpt, "sMoneyLetter", _moneyByLetter.sMoneyToLetter(Total.ToString()));
objForm.crptViewer.ReportSource = crpt;
objForm.ShowDialog();
//}
//catch (Exception ex)
//{
// Utility.DefaultNow(this);
//}
}
private void cmdPrint_Click(object sender, EventArgs e)
{
try
{
//Truyền dữ liệu vào datatable
DataTable m_dtReport = BAOCAO_THUOC.ThuocLaythongtinInphieuDutruthuoc(Utility.Int16Dbnull(cboKhoxuat.SelectedValue, -1), KIEU_THUOC_VT);
THU_VIEN_CHUNG.CreateXML(m_dtReport, "thuoc_PhieuDutru.xml");
if (m_dtReport.Rows.Count <= 0)
{
Utility.ShowMsg("Không tìm thấy dữ liệu cho báo cáo", "Thông báo", MessageBoxIcon.Warning);
return;
}
//Add logo vào datatable
Utility.UpdateLogotoDatatable(ref m_dtReport);
string tieude = "", reportname = "";
string mabaocao = "thuoc_PhieuDutru";
var crpt = Utility.GetReport(mabaocao, ref tieude, ref reportname);
if (crpt == null)
{
return;
}
//baocaO_TIEUDE1.TIEUDE
frmPrintPreview objForm = new frmPrintPreview(tieude, crpt, true, m_dtReport.Rows.Count <= 0 ? false : true);
crpt.SetDataSource(m_dtReport);
objForm.mv_sReportFileName = System.IO.Path.GetFileName(reportname);
objForm.mv_sReportCode = mabaocao;
Utility.SetParameterValue(crpt, "BranchName", globalVariables.Branch_Name);
Utility.SetParameterValue(crpt, "ParentBranchName", globalVariables.ParentBranch_Name);
Utility.SetParameterValue(crpt, "sTitleReport", tieude);
Utility.SetParameterValue(crpt, "sCurrentDate", Utility.FormatDateTimeWithThanhPho(globalVariables.SysDate));
Utility.SetParameterValue(crpt, "BottomCondition", THU_VIEN_CHUNG.BottomCondition());
Utility.SetParameterValue(crpt, "txtTrinhky", "");
Utility.SetParameterValue(crpt, "tenkho", cboKhoxuat.Text);
objForm.crptViewer.ReportSource = crpt;
objForm.ShowDialog();
}
catch (Exception exception)
{
Utility.ShowMsg("Lỗi:" + exception.Message);
}
}
public static void InphieuNhapkho(int IDPhieuNhap, string sTitleReport, DateTime NgayIn)
{
DataTable m_dtReport = new THUOC_NHAPKHO().Laythongtininphieunhapkhothuoc(IDPhieuNhap);
if (m_dtReport.Rows.Count <= 0)
{
Utility.ShowMsg("Không tìm thấy thông tin ", "Thông báo", MessageBoxIcon.Warning);
return;
}
THU_VIEN_CHUNG.CreateXML(m_dtReport, "thuoc_phieu_nhapkho.xml");
MoneyByLetter _moneyByLetter = new MoneyByLetter();
string tinhtong = TinhTong(m_dtReport, TPhieuNhapxuatthuocChitiet.ThanhTienColumn.ColumnName);
string tieude = "", reportname = "";
var crpt = Utility.GetReport("thuoc_phieunhapkho", ref tieude, ref reportname);
// VNS.HIS.UI.BaoCao.PhieuNhapKho.CRPT_PHIEU_NHAPKHO crpt =new CRPT_PHIEU_NHAPKHO();
var objForm = new frmPrintPreview(sTitleReport, crpt, true, m_dtReport.Rows.Count <= 0 ? false : true);
Utility.UpdateLogotoDatatable(ref m_dtReport);
try
{
m_dtReport.AcceptChanges();
crpt.SetDataSource(m_dtReport);
////crpt.DataDefinition.FormulaFields["Formula_1"].Text = Strings.Chr(34) + " PHÒNG TIẾP ĐÓN ".Replace("#$X$#", Strings.Chr(34) + "&Chr(13)&" + Strings.Chr(34)) + Strings.Chr(34);
objForm.mv_sReportFileName = Path.GetFileName(reportname);
objForm.mv_sReportCode = "thuoc_phieunhapkho";
Utility.SetParameterValue(crpt, "ParentBranchName", globalVariables.ParentBranch_Name);
Utility.SetParameterValue(crpt, "BranchName", globalVariables.Branch_Name);
Utility.SetParameterValue(crpt, "sMoneyLetter", _moneyByLetter.sMoneyToLetter(tinhtong));
Utility.SetParameterValue(crpt, "sCurrentDate", Utility.FormatDateTimeWithThanhPho(NgayIn));
Utility.SetParameterValue(crpt, "sTitleReport", tieude);
Utility.SetParameterValue(crpt, "BottomCondition", THU_VIEN_CHUNG.BottomCondition());
Utility.SetParameterValue(crpt, "txtTrinhky", Utility.getTrinhky(objForm.mv_sReportFileName, globalVariables.SysDate));
objForm.crptViewer.ReportSource = crpt;
objForm.ShowDialog();
// Utility.DefaultNow(this);
}
catch (Exception ex)
{
if (globalVariables.IsAdmin)
{
Utility.ShowMsg(ex.ToString());
}
}
}
public static void InBienBanGiaoHang(int IDPhieuNhap, string sTitleReport, DateTime NgayIn)
{
DataTable m_dtReport = SPs.ThuocLaydulieuinphieuchuyenkho2lien(IDPhieuNhap).GetDataSet().Tables[0];
if (m_dtReport.Rows.Count <= 0)
{
Utility.ShowMsg("Không tìm thấy thông tin ", "Thông báo", MessageBoxIcon.Warning);
return;
}
THU_VIEN_CHUNG.CreateXML(m_dtReport, "thuoc_phieu_bienbangiaohang");
string tieude = "", reportname = "";
var crpt = Utility.GetReport("thuoc_phieu_bienbangiaohang", ref tieude, ref reportname);
Utility.UpdateLogotoDatatable(ref m_dtReport);
var objForm = new frmPrintPreview(sTitleReport, crpt, true, true);
try
{
m_dtReport.AcceptChanges();
crpt.SetDataSource(m_dtReport);
objForm.mv_sReportFileName = Path.GetFileName(reportname);
objForm.mv_sReportCode = "thuoc_phieu_bienbangiaohang";
Utility.SetParameterValue(crpt, "ParentBranchName", globalVariables.ParentBranch_Name);
Utility.SetParameterValue(crpt, "BranchName", globalVariables.Branch_Name);
Utility.SetParameterValue(crpt, "sCurrentDate", Utility.FormatDateTimeWithThanhPho(NgayIn));
Utility.SetParameterValue(crpt, "sTitleReport", tieude);
Utility.SetParameterValue(crpt, "BottomCondition", THU_VIEN_CHUNG.BottomCondition());
// Utility.SetParameterValue(crpt, "sMoneyLetter", new MoneyByLetter().sMoneyToLetter(tinhtong));
Utility.SetParameterValue(crpt, "txtTrinhky", Utility.getTrinhky(objForm.mv_sReportFileName, globalVariables.SysDate));
objForm.crptViewer.ReportSource = crpt;
objForm.ShowDialog();
// Utility.DefaultNow(this);
}
catch (Exception ex)
{
if (globalVariables.IsAdmin)
{
Utility.ShowMsg(ex.ToString());
}
}
finally
{
Utility.FreeMemory(crpt);
}
}
public static void Inphieuxuatthuockhoa(int IDPhieuNhap, string sTitleReport, DateTime NgayIn)
{
DataTable m_dtReport = SPs.ThuocLaythongtininphieuXuatkhothuoc(IDPhieuNhap).GetDataSet().Tables[0];
if (m_dtReport.Rows.Count <= 0)
{
Utility.ShowMsg("Không tìm thấy thông tin ", "Thông báo", MessageBoxIcon.Warning);
return;
}
string tieude = "", reportname = "";
var crpt = Utility.GetReport("CRPT_PHIEUXUAT_KHOLE_TOIKHOA", ref tieude, ref reportname);
var objForm = new frmPrintPreview(sTitleReport, crpt, true, true);
Utility.UpdateLogotoDatatable(ref m_dtReport);
try
{
m_dtReport.AcceptChanges();
crpt.SetDataSource(m_dtReport);
//crpt.DataDefinition.FormulaFields["Formula_1"].Text = Strings.Chr(34) +
//"".Replace("#$X$#",
// Strings.Chr(34) + "&Chr(13)&" +
// Strings.Chr(34)) + Strings.Chr(34);
objForm.mv_sReportFileName = Path.GetFileName(reportname);
objForm.mv_sReportCode = "CRPT_PHIEUXUAT_KHOLE_TOIKHOA";
Utility.SetParameterValue(crpt, "ParentBranchName", globalVariables.ParentBranch_Name);
Utility.SetParameterValue(crpt, "BranchName", globalVariables.Branch_Name);
Utility.SetParameterValue(crpt, "sCurrentDate", Utility.FormatDateTimeWithThanhPho(NgayIn));
Utility.SetParameterValue(crpt, "sTitleReport", sTitleReport);
Utility.SetParameterValue(crpt, "BottomCondition", THU_VIEN_CHUNG.BottomCondition());
Utility.SetParameterValue(crpt, "txtTrinhky", Utility.getTrinhky(objForm.mv_sReportFileName, globalVariables.SysDate));
objForm.crptViewer.ReportSource = crpt;
objForm.ShowDialog();
// Utility.DefaultNow(this);
}
catch (Exception ex)
{
if (globalVariables.IsAdmin)
{
Utility.ShowMsg(ex.ToString());
}
}
}
public static void InphieuThanhly(int IDPhieuNhap, string sTitleReport, DateTime NgayIn)
{
DataTable m_dtReport = SPs.ThuocLaythongtininphieuXuatkhothuoc(IDPhieuNhap).GetDataSet().Tables[0];
if (m_dtReport.Rows.Count <= 0)
{
Utility.ShowMsg("Không tìm thấy thông tin ", "Thông báo", MessageBoxIcon.Warning);
return;
}
MoneyByLetter _moneyByLetter = new MoneyByLetter();
string tinhtong = TinhTong(m_dtReport, TPhieuNhapxuatthuocChitiet.ThanhTienColumn.ColumnName);
THU_VIEN_CHUNG.CreateXML(m_dtReport, "thuoc_bienban_thanhly");
string tieude = "", reportname = "";
var crpt = Utility.GetReport("thuoc_bienban_thanhly", ref tieude, ref reportname);
Utility.UpdateLogotoDatatable(ref m_dtReport);
var objForm = new frmPrintPreview(sTitleReport, crpt, true, true);
try
{
m_dtReport.AcceptChanges();
crpt.SetDataSource(m_dtReport);
objForm.mv_sReportFileName = Path.GetFileName(reportname);
objForm.mv_sReportCode = "thuoc_bienban_thanhly";
Utility.SetParameterValue(crpt, "ParentBranchName", globalVariables.ParentBranch_Name);
Utility.SetParameterValue(crpt, "BranchName", globalVariables.Branch_Name);
Utility.SetParameterValue(crpt, "sCurrentDate", Utility.FormatDateTimeWithThanhPho(NgayIn));
Utility.SetParameterValue(crpt, "sMoneyLetter", _moneyByLetter.sMoneyToLetter(tinhtong));
Utility.SetParameterValue(crpt, "sTitleReport", tieude);
Utility.SetParameterValue(crpt, "BottomCondition", THU_VIEN_CHUNG.BottomCondition());
Utility.SetParameterValue(crpt, "txtTrinhky", Utility.getTrinhky(objForm.mv_sReportFileName, globalVariables.SysDate));
objForm.crptViewer.ReportSource = crpt;
objForm.ShowDialog();
}
catch (Exception ex)
{
if (globalVariables.IsAdmin)
{
Utility.ShowMsg(ex.ToString());
}
}
}
public void KYDONG_INPHIEU_DICHVU(DataTable m_dtReportPhieuThu, DateTime NgayInPhieu, string sTitleReport, string khogiay)
{
Utility.UpdateLogotoDatatable(ref m_dtReportPhieuThu);
ReportDocument reportDocument = new ReportDocument();
string tieude = "", reportname = "";
switch (khogiay)
{
case "A4":
reportDocument = Utility.GetReport("thanhtoan_Bienlai_Dichvu_A4", ref tieude, ref reportname);
break;
case "A5":
reportDocument = Utility.GetReport("thanhtoan_13", ref tieude, ref reportname);
break;
}
if (reportDocument == null)
{
return;
}
var crpt = reportDocument;
decimal tong = m_dtReportPhieuThu.AsEnumerable().Sum(c => c.Field <decimal>("TONG_BN"));
var objForm = new frmPrintPreview("", crpt, true, true);
//try
//{
crpt.SetDataSource(m_dtReportPhieuThu);
//crpt.DataDefinition.FormulaFields["Formula_1"].Text = Strings.Chr(34) + " ".Replace("#$X$#", Strings.Chr(34) + "&Chr(13)&" + Strings.Chr(34)) + Strings.Chr(34);
Utility.SetParameterValue(crpt, "ParentBranchName", globalVariables.ParentBranch_Name);
Utility.SetParameterValue(crpt, "BranchName", globalVariables.Branch_Name);
Utility.SetParameterValue(crpt, "Telephone", globalVariables.Branch_Phone);
Utility.SetParameterValue(crpt, "Address", globalVariables.Branch_Address);
// Utility.SetParameterValue(crpt,"DateTime", Utility.FormatDateTime(dtCreateDate.Value));
Utility.SetParameterValue(crpt, "CurrentDate", Utility.FormatDateTime(NgayInPhieu));
Utility.SetParameterValue(crpt, "sTitleReport", sTitleReport);
Utility.SetParameterValue(crpt, "sMoneyCharacter",
new MoneyByLetter().sMoneyToLetter(Utility.sDbnull(tong)));
Utility.SetParameterValue(crpt, "BottomCondition", THU_VIEN_CHUNG.BottomCondition());
objForm.crptViewer.ReportSource = crpt;
objForm.ShowDialog();
}
public static void InphieuTraKholeVeKhochan(int IDPhieuNhap, string sTitleReport, DateTime NgayIn)
{
try
{
DataTable m_dtReport = SPs.ThuocLaythongtininphieutrakholevekhochan(IDPhieuNhap).GetDataSet().Tables[0];
if (m_dtReport.Rows.Count <= 0)
{
Utility.ShowMsg("Không tìm thấy thông tin ", "Thông báo", MessageBoxIcon.Warning);
return;
}
THU_VIEN_CHUNG.CreateXML(m_dtReport, "thuoc_phieutrakholevekhochan.xml");
Utility.UpdateLogotoDatatable(ref m_dtReport);
string tieude = "", reportname = "";
var crpt = Utility.GetReport("thuoc_phieutrakholevekhochan", ref tieude, ref reportname);
var objForm = new frmPrintPreview(sTitleReport, crpt, true, m_dtReport.Rows.Count <= 0 ? false : true);
m_dtReport.AcceptChanges();
crpt.SetDataSource(m_dtReport);
objForm.mv_sReportFileName = Path.GetFileName(reportname);
objForm.mv_sReportCode = "thuoc_phieutrakholevekhochan";
Utility.SetParameterValue(crpt, "BranchName", globalVariables.Branch_Name);
Utility.SetParameterValue(crpt, "sCurrentDate", Utility.FormatDateTimeWithThanhPho(NgayIn));
Utility.SetParameterValue(crpt, "sTitleReport", sTitleReport);
Utility.SetParameterValue(crpt, "BottomCondition", THU_VIEN_CHUNG.BottomCondition());
Utility.SetParameterValue(crpt, "sMoneybyletter", THU_VIEN_CHUNG.BottomCondition());
Utility.SetParameterValue(crpt, "txtTrinhky", Utility.getTrinhky(objForm.mv_sReportFileName, globalVariables.SysDate));
objForm.crptViewer.ReportSource = crpt;
objForm.ShowDialog();
// Utility.DefaultNow(this);
}
catch (Exception ex)
{
if (globalVariables.IsAdmin)
{
Utility.ShowMsg(ex.ToString());
}
}
}
public static void InphieuTranhacungcap(int IDPhieuNhap, string sTitleReport, DateTime NgayIn)
{
try
{
DataTable m_dtReport = SPs.ThuocLaydulieuinphieuchuyenkho2lien(IDPhieuNhap).GetDataSet().Tables[0];
if (m_dtReport.Rows.Count <= 0)
{
Utility.ShowMsg("Không tìm thấy thông tin ", "Thông báo", MessageBoxIcon.Warning);
return;
}
THU_VIEN_CHUNG.CreateXML(m_dtReport, "thuoc_phieutranhacungcap");
string tieude = "", reportname = "";
var crpt = Utility.GetReport("thuoc_phieutranhacungcap", ref tieude, ref reportname);
Utility.UpdateLogotoDatatable(ref m_dtReport);
var objForm = new frmPrintPreview(sTitleReport, crpt, true, true);
m_dtReport.AcceptChanges();
crpt.SetDataSource(m_dtReport);
objForm.mv_sReportFileName = Path.GetFileName(reportname);
objForm.mv_sReportCode = "thuoc_phieutranhacungcap";
Utility.SetParameterValue(crpt, "ParentBranchName", globalVariables.ParentBranch_Name);
Utility.SetParameterValue(crpt, "BranchName", globalVariables.Branch_Name);
Utility.SetParameterValue(crpt, "sCurrentDate", Utility.FormatDateTimeWithThanhPho(NgayIn));
Utility.SetParameterValue(crpt, "sTitleReport", tieude);
Utility.SetParameterValue(crpt, "BottomCondition", THU_VIEN_CHUNG.BottomCondition());
objForm.crptViewer.ReportSource = crpt;
objForm.ShowDialog();
}
catch (Exception ex)
{
if (globalVariables.IsAdmin)
{
Utility.ShowMsg(ex.ToString());
}
}
}
public static void InBanCamKetPhauThuat(DataTable mDtReport, string sTitleReport, DateTime ngayIn)
{
string tieude = "", reportname = "";
ReportDocument crpt = Utility.GetReport("noitru_giaycamketPT_A5", ref tieude, ref reportname);
if (crpt == null)
{
return;
}
THU_VIEN_CHUNG.CreateXML(mDtReport, "noitru_giaycamketPT_A5.xml");
var moneyByLetter = new MoneyByLetter();
var objForm = new frmPrintPreview(sTitleReport, crpt, true, mDtReport.Rows.Count > 0);
// string tinhtong = TinhTong(m_dtReport);
Utility.UpdateLogotoDatatable(ref mDtReport);
try
{
crpt.SetDataSource(mDtReport);
objForm.mv_sReportFileName = Path.GetFileName(reportname);
objForm.mv_sReportCode = "noitru_giaycamketPT_A5";
Utility.SetParameterValue(crpt, "ParentBranchName", globalVariables.ParentBranch_Name);
Utility.SetParameterValue(crpt, "BranchName", globalVariables.Branch_Name);
Utility.SetParameterValue(crpt, "CurrentDate", Utility.FormatDateTimeWithThanhPho(ngayIn));
Utility.SetParameterValue(crpt, "sTitleReport", tieude);
Utility.SetParameterValue(crpt, "BottomCondition", THU_VIEN_CHUNG.BottomCondition());
objForm.crptViewer.ReportSource = crpt;
objForm.ShowDialog();
}
catch (Exception ex)
{
if (globalVariables.IsAdmin)
{
Utility.ShowMsg(ex.ToString());
}
}
}
void cmdIn_Click(object sender, EventArgs e)
{
try
{
if (objLuotkham == null)
{
Utility.ShowMsg("Bạn cần chọn bệnh nhân in phiếu tạm ứng");
return;
}
if (grdTamung.GetDataRows().Count() <= 0)
{
Utility.ShowMsg("Bạn cần chọn phiếu tạm ứng muốn in");
return;
}
if (!Utility.isValidGrid(grdTamung))
{
grdTamung.MoveFirst();
}
DataTable m_dtReport = noitru_TamungHoanung.NoitruInphieutamung(Utility.Int64Dbnull(Utility.GetValueFromGridColumn(grdTamung, NoitruTamung.Columns.Id), -1));
THU_VIEN_CHUNG.CreateXML(m_dtReport, "noitru_phieutamung.xml");
if (m_dtReport.Rows.Count <= 0)
{
Utility.ShowMsg("Không tìm thấy dữ liệu", "Thông báo", MessageBoxIcon.Warning);
return;
}
string tieude = "", reportname = "";
var crpt = Utility.GetReport("noitru_phieutamung", ref tieude, ref reportname);
if (crpt == null)
{
return;
}
MoneyByLetter _moneyByLetter = new MoneyByLetter();
var objForm = new frmPrintPreview(tieude, crpt, true, m_dtReport.Rows.Count <= 0 ? false : true);
Utility.UpdateLogotoDatatable(ref m_dtReport);
crpt.SetDataSource(m_dtReport);
objForm.mv_sReportFileName = Path.GetFileName(reportname);
objForm.mv_sReportCode = "noitru_phieutamung";
Utility.SetParameterValue(crpt, "ParentBranchName", globalVariables.ParentBranch_Name);
Utility.SetParameterValue(crpt, "BranchName", globalVariables.Branch_Name);
Utility.SetParameterValue(crpt, "Address", globalVariables.Branch_Address);
Utility.SetParameterValue(crpt, "TelePhone", globalVariables.Branch_Phone);
Utility.SetParameterValue(crpt, "sMoneyLetter", _moneyByLetter.sMoneyToLetter(Utility.Int32Dbnull(m_dtReport.Compute("SUM(so_tien)", "1=1"), 0).ToString()));
Utility.SetParameterValue(crpt, "sCurrentDate", Utility.FormatDateTimeWithThanhPho(DateTime.Now));
Utility.SetParameterValue(crpt, "sTitleReport", tieude);
Utility.SetParameterValue(crpt, "BottomCondition", THU_VIEN_CHUNG.BottomCondition());
objForm.crptViewer.ReportSource = crpt;
if (Utility.isPrintPreview(PropertyLib._MayInProperties.TenMayInBienlai, PropertyLib._MayInProperties.PreviewPhieuTamung))
{
objForm.SetDefaultPrinter(PropertyLib._MayInProperties.TenMayInBienlai, 0);
objForm.ShowDialog();
}
else
{
objForm.addTrinhKy_OnFormLoad();
crpt.PrintOptions.PrinterName = PropertyLib._MayInProperties.TenMayInBienlai;
crpt.PrintToPrinter(objForm.getPrintNumber, false, 0, 0);
}
}
catch (Exception)
{
}
}
private void INPHIEU_XETNGHIEM(bool IsQuick, string sTitleReport, DateTime NgayIn)
{
string strPatient_ID = string.Empty;
var DTPrint = new DataTable();
string vTestTypeId = GetCheckTestType();
string vTestID = GetcheckTestID();
if (vTestTypeId == "-1")
{
Utility.ShowMsg("Chưa chọn loại xét nghiệm để in");
return;
}
if (grdList.GetCheckedRows().Length > 0)
{
foreach (GridEXRow gridExRow in grdList.GetCheckedRows())
{
strPatient_ID += "," + Utility.Int32Dbnull(gridExRow.Cells["Patient_ID"].Value, -1);
}
strPatient_ID = strPatient_ID.Remove(0, 1);
}
else
{
strPatient_ID = Utility.sDbnull(grdList.GetValue("Patient_ID"));
}
DTPrint =
SPs.GtvtGetTestResultForPrintV2FromDateToDate(strPatient_ID, vTestTypeId, vTestID,
dtFromDate.Date.ToShortDateString(),
dtToDate.Date.ToShortDateString()).GetDataSet().Tables[0];
if (DTPrint.Rows.Count <= 0)
{
Utility.ShowMsg("Không tìm thấy bản ghi nào", "Thông báo");
return;
}
ProcessData(ref DTPrint);
if (SysPara.IsNormalResult == 1)
{
string normalLevel = Utility.Int32Dbnull(DTPrint.Rows[0]["Sex"], 1) == 1
? "Normal_Level"
: "Normal_LevelW";
ProcessNormalResult(ref DTPrint);
//ProcessNormalResult(ref DTPrint, "Test_result", normalLevel, -1, 1, 0,
// "binhthuong", false);
foreach (DataRow row in DTPrint.Rows)
{
if (
(row["Test_result"].ToString().Trim().ToUpper().StartsWith("ÂM")) ||
(row["Test_result"].ToString().Trim().ToUpper().Contains("AM"))
)
{
row["binhthuong"] = -1;
}
else if (
(row["Test_result"].ToString().Trim().ToUpper().StartsWith("DƯƠ")) ||
(row["Test_result"].ToString().Trim().ToUpper().Contains("DUO"))
)
{
row["binhthuong"] = 1;
}
}
}
try
{
reporttype = File.ReadAllText(filereporttype);
if (chkA5.Checked)
{
StrCode = reporttype;
}
else if (chkA4.Checked)
{
StrCode = reporttype;
}
}
catch (Exception ex)
{
MessageBox.Show("Loz" + ex, "Thông báo");
}
//Tạo list loại xét nghiệm được tick chọn
//CrptBusiness.testTypeList.Clear();
//foreach (var row in grdTestType.GetCheckedRows())
//{
// var a = row.Cells["TestType_ID"].Value;
// CrptBusiness.testTypeList.Add(Utility.Int32Dbnull(row.Cells["TestType_ID"].Value));
//}
string tieude = "", reportname = "";
var crpt = Utility.GetReport("LAOKHOA_crpt_DetailTestReport_TESTTYPE", ref tieude, ref reportname);
var objForm = new frmPrintPreview(sTitleReport, crpt, true, DTPrint.Rows.Count <= 0 ? false : true);
Utility.UpdateLogotoDatatable(ref DTPrint);
try
{
DTPrint.AcceptChanges();
crpt.SetDataSource(DTPrint);
objForm.crptViewer.ReportSource = crpt;
////crpt.DataDefinition.FormulaFields["Formula_1"].Text = Strings.Chr(34) + " PHÒNG TIẾP ĐÓN ".Replace("#$X$#", Strings.Chr(34) + "&Chr(13)&" + Strings.Chr(34)) + Strings.Chr(34);
objForm.crptTrinhKyName = Path.GetFileName(reportname);
Utility.SetParameterValue(crpt, "ParentBranchName", globalVariables.ParentBranch_Name);
Utility.SetParameterValue(crpt, "BranchName", globalVariables.Branch_Name);
Utility.SetParameterValue(crpt, "sCurrentDate", Utility.FormatDateTimeWithThanhPho(NgayIn));
Utility.SetParameterValue(crpt, "sTitleReport", tieude);
Utility.SetParameterValue(crpt, "BottomCondition", THU_VIEN_CHUNG.BottomCondition());
objForm.ShowDialog();
// Utility.DefaultNow(this);
}
catch (Exception ex)
{
if (globalVariables.IsAdmin)
{
Utility.ShowMsg(ex.ToString());
}
}
//StrCode = reporttype.Trim();
//// neu rpt A4 hoac A5 ma chua khai bao thi lay me no cai mac dinh(.)
//if (StrCode == "")
//{
// crptBusiness.StrCode = rdoNoheader.Checked ? "LABNOHEADER" : "LABREPORT";
//}
//else
//{
// crptBusiness.StrCode = StrCode;
//}
//crptBusiness.FormPreviewTitle = "In kết quả xét nghiệm";
//crptBusiness.Print(IsQuick, printDocument.PrinterSettings.PrinterName);
}
private void cmdInPhieuXN_Click(object sender, EventArgs e)
{
_dtData =
SPs.BaocaoThongkeSokhambenh(dtFromDate.Value, dtToDate.Value,
Utility.Int16Dbnull(cboDoituongKCB.SelectedValue, -1),
Utility.Int16Dbnull(txtNhanvientiepdon.txtMyID, -1),
Utility.sDbnull(cboKhoa.SelectedValue, "KKB"), thamso, Utility.Int16Dbnull(cboTinhTrang.SelectedValue, -1)).GetDataSet().
Tables[0];
Utility.SetDataSourceForDataGridEx(grdList, _dtData, true, true, "1=1", "");
THU_VIEN_CHUNG.CreateXML(_dtData, "baocao_thongke_sokhambenh.XML");
if (_dtData.Rows.Count <= 0)
{
Utility.ShowMsg("Không tìm thấy dữ liệu báo cáo theo điều kiện bạn chọn", "Thông báo",
MessageBoxIcon.Information);
return;
}
Utility.UpdateLogotoDatatable(ref _dtData);
reportname = "baocao_thongke_sokhambenh";
string Condition =
string.Format("Từ ngày {0} đến {1} - Đối tượng : {2} - Khoa KCB :{3} - Người tiếp đón: {4}",
dtFromDate.Text, dtToDate.Text,
cboDoituongKCB.SelectedIndex >= 0
? Utility.sDbnull(cboDoituongKCB.Text)
: "Tất cả",
cboKhoa.SelectedIndex > 0
? Utility.sDbnull(cboKhoa.Text)
: "Tất cả", txtNhanvientiepdon.MyCode == "-1" ? "Tất cả" : txtNhanvientiepdon.Text);
ReportDocument crpt = Utility.GetReport(reportname, ref tieude, ref reportname);
if (crpt == null)
{
return;
}
string StaffName = globalVariables.gv_strTenNhanvien;
if (string.IsNullOrEmpty(globalVariables.gv_strTenNhanvien))
{
StaffName = globalVariables.UserName;
}
try
{
var objForm = new frmPrintPreview(tieude, crpt, true, _dtData.Rows.Count > 0);
//try
//{
crpt.SetDataSource(_dtData);
objForm.mv_sReportFileName = Path.GetFileName(reportname);
objForm.mv_sReportCode = reportname;
crpt.SetParameterValue("StaffName", StaffName);
crpt.SetParameterValue("ParentBranchName", globalVariables.ParentBranch_Name);
crpt.SetParameterValue("BranchName", globalVariables.Branch_Name);
crpt.SetParameterValue("Address", globalVariables.Branch_Address);
crpt.SetParameterValue("FromDateToDate", Condition);
crpt.SetParameterValue("sTitleReport", tieude);
crpt.SetParameterValue("sCurrentDate", Utility.FormatDateTimeWithThanhPho(dtNgayInPhieu.Value));
crpt.SetParameterValue("BottomCondition", THU_VIEN_CHUNG.BottomCondition());
Utility.SetParameterValue(crpt, "txtTrinhky",
Utility.getTrinhky(objForm.mv_sReportFileName, globalVariables.SysDate));
objForm.crptViewer.ReportSource = crpt;
objForm.ShowDialog();
}
catch (Exception exception)
{
Utility.ShowMsg("Lỗi:" + exception.Message);
}
finally
{
Utility.FreeMemory(crpt);
}
}
private void cmdInPhieuXN_Click(object sender, EventArgs e)
{
try
{
if (!string.IsNullOrEmpty(cboKhoThuoc.Text))
{
var query = (from chk in cboKhoThuoc.CheckedValues.AsEnumerable()
let x = Utility.sDbnull(chk)
select x).ToArray();
if (query.Count() > 0)
{
chuoiIDKhoThuoc = string.Join(",", query);
}
}
//Lấy giá trị xác nhận hết hạn hay chưa
Int16 ishethan;
if (radTatCa.Checked)
{
ishethan = -1;
}
else if (radChuaHetHan.Checked)
{
ishethan = 0;
}
else if (radDaHetHan.Checked)
{
ishethan = 1;
}
else
{
ishethan = -1;
}
//Truyền dữ liệu vào datatable
DataTable m_dtReport = BAOCAO_THUOC.ThuocBaocaoSoluongtonthuoctheokho(chuoiIDKhoThuoc, Utility.Int32Dbnull(txtDrugID.Text, -1), Utility.Int32Dbnull(txtLoaithuoc.MyID, -1), ishethan, KIEU_THUOC_VT);
THU_VIEN_CHUNG.CreateXML(m_dtReport, "thuoc_baocaothuocton_theokho.xml");
//Truyền dữ liệu vào datagrid-view
Utility.SetDataSourceForDataGridEx(grdList, m_dtReport, false, true, "1=1", "");
if (m_dtReport.Rows.Count <= 0)
{
Utility.ShowMsg("Không tìm thấy dữ liệu cho báo cáo", "Thông báo", MessageBoxIcon.Warning);
return;
}
//Add stt vào datatable
Utility.AddColumToDataTable(ref m_dtReport, "STT", typeof(Int32));
int idx = 1;
foreach (DataRow drv in m_dtReport.Rows)
{
drv["STT"] = idx;
idx++;
}
m_dtReport.AcceptChanges();
//Add logo vào datatable
Utility.UpdateLogotoDatatable(ref m_dtReport);
//Lấy chuỗi condition truyền vào biến ?FromDateToDate trên crpt
string Condition = string.Format("Thuộc kho :{0} - Thuốc: {1}", string.IsNullOrEmpty(cboKhoThuoc.Text) ? "Tất cả" : cboKhoThuoc.Text,
string.IsNullOrEmpty(txtthuoc.Text) ? "Tất cả" : txtthuoc.Text);
//Lấy tên người tạo báo cáo và gọi crpt
string StaffName = globalVariables.gv_strTenNhanvien;
string tieude = "", reportname = "";
string tenbaocao = chkInbienbankiemke.Checked?"vt_bienban_kiemkevt":"vt_baocaovtton_theokho";
if (KIEU_THUOC_VT == "THUOC")
{
tenbaocao = chkInbienbankiemke.Checked ? "thuoc_bienban_kiemkethuoc" : "thuoc_baocaothuocton_theokho";
}
var crpt = Utility.GetReport(tenbaocao, ref tieude, ref reportname);
if (crpt == null)
{
return;
}
if (string.IsNullOrEmpty(globalVariables.gv_strTenNhanvien))
{
StaffName = globalVariables.UserName;
}
frmPrintPreview objForm = new frmPrintPreview(baocaO_TIEUDE1.TIEUDE, crpt, true, m_dtReport.Rows.Count <= 0 ? false : true);
crpt.SetDataSource(m_dtReport);
objForm.mv_sReportFileName = Path.GetFileName(reportname);
objForm.mv_sReportCode = tenbaocao;
//crpt.DataDefinition.FormulaFields["Formula_1"].Text = Strings.Chr(34) + "".Replace("#$X$#", Strings.Chr(34) + "&Chr(13)&" + Strings.Chr(34)) + Strings.Chr(34);
Utility.SetParameterValue(crpt, "ReportCondition", Condition);
Utility.SetParameterValue(crpt, "BranchName", globalVariables.Branch_Name);
Utility.SetParameterValue(crpt, "ParentBranchName", globalVariables.ParentBranch_Name);
Utility.SetParameterValue(crpt, "ReportTitle", baocaO_TIEUDE1.TIEUDE);
Utility.SetParameterValue(crpt, "sCurrentDate", Utility.FormatDateTimeWithThanhPho(dtNgayInPhieu.Value));
Utility.SetParameterValue(crpt, "BottomCondition", THU_VIEN_CHUNG.BottomCondition());
Utility.SetParameterValue(crpt, "DayOfWarning", nmrSongay.Value);
Utility.SetParameterValue(crpt, "ngay_in", dtNgayInPhieu.Value.ToString("dd/MM/yyyy"));
Utility.SetParameterValue(crpt, "txtTrinhky", Utility.getTrinhky(objForm.mv_sReportFileName, globalVariables.SysDate));
objForm.crptViewer.ReportSource = crpt;
objForm.ShowDialog();
}
catch (Exception exception)
{
}
}
/// <summary>
/// hàm thực hiện việc in phiếu xét nghiêm
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void cmdPrint_Click(object sender, EventArgs e)
{
try
{
string nhomdichvu = "-1";
if (!string.IsNullOrEmpty(cboNhomdichvuCLS.Text) && cboNhomdichvuCLS.CheckedValues != null)
{
var query = (from chk in cboNhomdichvuCLS.CheckedValues.AsEnumerable()
let x = Utility.sDbnull(chk)
select x).ToArray();
if (query.Count() > 0)
{
nhomdichvu = string.Join(",", query);
}
}
if (chkChitiet.Checked)
{
_reportTable =
BAOCAO_NGOAITRU.BaocaoThutientheokhoaChitiet(Utility.sDbnull(cboPhong.SelectedValue, -1),
chkByDate.Checked ? dtFromDate.Value : Convert.ToDateTime("01/01/1900"),
chkByDate.Checked ? dtToDate.Value : globalVariables.SysDate, Utility.sDbnull(cboDoituongKCB.SelectedValue, -1), nhomdichvu,
Utility.sDbnull(cbonhanvien.SelectedValue, -1), Utility.sDbnull(cbokhoa.SelectedValue, -1));
Utility.SetDataSourceForDataGridEx(grdChitiet, _reportTable, false, true, "1=1", "");
Janus.Windows.GridEX.GridEXColumn gridExColumnTientong = grdChitiet.RootTable.Columns["Thanh_Tien"];
tong_tien = Utility.Int32Dbnull(grdChitiet.GetTotal(gridExColumnTientong, Janus.Windows.GridEX.AggregateFunction.Sum));
}
else
{
_reportTable =
BAOCAO_NGOAITRU.BaocaoThutientheokhoaTonghop(Utility.sDbnull(cboPhong.SelectedValue, -1),
chkByDate.Checked ? dtFromDate.Value : Convert.ToDateTime("01/01/1900"),
chkByDate.Checked ? dtToDate.Value : globalVariables.SysDate, Utility.sDbnull(cboDoituongKCB.SelectedValue, -1), nhomdichvu,
Utility.sDbnull(cbonhanvien.SelectedValue, -1), Utility.sDbnull(cbokhoa.SelectedValue, -1));
Utility.SetDataSourceForDataGridEx(grdList, _reportTable, false, true, "1=1", "");
Janus.Windows.GridEX.GridEXColumn gridExColumnTientong = grdList.RootTable.Columns["Thanh_Tien"];
tong_tien = Utility.Int32Dbnull(grdList.GetTotal(gridExColumnTientong, Janus.Windows.GridEX.AggregateFunction.Sum));
}
if (_reportTable.Rows.Count <= 0)
{
Utility.ShowMsg("Không tìm thấy dữ liệu cho báo cáo", "Thông báo", MessageBoxIcon.Warning);
return;
}
string StaffName = globalVariables.gv_strTenNhanvien;
if (string.IsNullOrEmpty(globalVariables.gv_strTenNhanvien))
{
StaffName = globalVariables.UserName;
}
string Condition = string.Format("Từ ngày {0} đến {1} - Đối tượng : {2} - Nhân viên :{3} - Khoa chỉ định :{4} - Phòng thực hiện :{5} - Nhóm dịch vụ: {6}", dtFromDate.Text, dtToDate.Text,
cboDoituongKCB.SelectedIndex > 0
? Utility.sDbnull(cboDoituongKCB.Text)
: "Tất cả",
cbonhanvien.SelectedIndex > 0
? Utility.sDbnull(cbonhanvien.Text)
: "Tất cả", cbokhoa.SelectedIndex > 0 ? Utility.sDbnull(cbokhoa.Text) : "Tất cả",
cboPhong.SelectedIndex > 0 ? Utility.sDbnull(cboPhong.Text) : "Tất cả", cboNhomdichvuCLS.CheckedValues != null ? Utility.sDbnull(cboNhomdichvuCLS.Text) : "Tất cả");
Utility.UpdateLogotoDatatable(ref _reportTable);
string reportCode = chkChitiet.Checked ? "baocao_thutientheokhoa_chitiet" : "baocao_thutientheokhoa_tonghop";
var crpt = Utility.GetReport(reportCode, ref tieude, ref reportname);
if (crpt == null)
{
return;
}
frmPrintPreview objForm = new frmPrintPreview(tieude, crpt, true, _reportTable.Rows.Count <= 0 ? false : true);
crpt.SetDataSource(_reportTable);
objForm.mv_sReportFileName = Path.GetFileName(reportname);
objForm.mv_sReportCode = reportCode;
Utility.SetParameterValue(crpt, "StaffName", StaffName);
Utility.SetParameterValue(crpt, "BranchName", globalVariables.Branch_Name);
Utility.SetParameterValue(crpt, "Address", globalVariables.Branch_Address);
Utility.SetParameterValue(crpt, "Phone", globalVariables.Branch_Phone);
Utility.SetParameterValue(crpt, "FromDateToDate", Condition);
Utility.SetParameterValue(crpt, "sTitleReport", tieude);
Utility.SetParameterValue(crpt, "Tongtien_chu", new MoneyByLetter().sMoneyToLetter(tong_tien.ToString()));
Utility.SetParameterValue(crpt, "sCurrentDate", Utility.FormatDateTimeWithThanhPho(dtNgayInPhieu.Value));
Utility.SetParameterValue(crpt, "BottomCondition", THU_VIEN_CHUNG.BottomCondition());
objForm.crptViewer.ReportSource = crpt;
objForm.ShowDialog();
}
catch (Exception ex)
{
Utility.CatchException("Lỗi khi in báo cáo", ex);
}
}
/// <summary>
/// hàm thực hiện việc in phiếu báo cáo tổng hợp
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void cmdInPhieuXN_Click(object sender, EventArgs e)
{
if (chkTachCDHA.Checked)
{
_dtData =
BAOCAO_NGOAITRU.BaocaoDoanhthuphongkham(
chkByDate.Checked ? dtFromDate.Value : Convert.ToDateTime("01/01/1900"),
chkByDate.Checked ? dtToDate.Value : globalVariables.SysDate,
Utility.sDbnull(cboDoituongKCB.SelectedValue, -1), Utility.sDbnull(cboNhanvien.SelectedValue, -1), Utility.ByteDbnull(cboLoaidichvu.SelectedValue, 2), Utility.sDbnull(cboKhoa.SelectedValue, -1));
Utility.SetDataSourceForDataGridEx(grdChitiet, _dtData, false, true, "1=1", "");
Janus.Windows.GridEX.GridEXColumn gridExColumnTientong = grdChitiet.RootTable.Columns["TONGCONG"];
tong_tien = Utility.Int32Dbnull(grdChitiet.GetTotal(gridExColumnTientong, Janus.Windows.GridEX.AggregateFunction.Sum));
}
else
{
_dtData =
BAOCAO_NGOAITRU.BaocaoDoanhthuphongkhamTonghop(
chkByDate.Checked ? dtFromDate.Value : Convert.ToDateTime("01/01/1900"),
chkByDate.Checked ? dtToDate.Value : globalVariables.SysDate,
Utility.sDbnull(cboDoituongKCB.SelectedValue, -1), Utility.sDbnull(cboNhanvien.SelectedValue, -1), Utility.ByteDbnull(cboLoaidichvu.SelectedValue, -1), Utility.sDbnull(cboKhoa.SelectedValue, -1));
Utility.SetDataSourceForDataGridEx(grdList, _dtData, false, true, "1=1", "");
Janus.Windows.GridEX.GridEXColumn gridExColumnTientong = grdList.RootTable.Columns["TONGCONG"];
tong_tien = Utility.Int32Dbnull(grdList.GetTotal(gridExColumnTientong, Janus.Windows.GridEX.AggregateFunction.Sum));
}
if (_dtData.Rows.Count <= 0)
{
Utility.ShowMsg("Không tìm thấy dữ liệu báo cáo theo điều kiện bạn chọn", "Thông báo", MessageBoxIcon.Information);
return;
}
Utility.UpdateLogotoDatatable(ref _dtData);
string Condition = string.Format("Từ ngày {0} đến {1} - Đối tượng : {2} - Nhân viên :{3}", dtFromDate.Text, dtToDate.Text,
cboDoituongKCB.SelectedIndex >= 0
? Utility.sDbnull(cboDoituongKCB.Text)
: "Tất cả",
cboNhanvien.SelectedIndex > 0
? Utility.sDbnull(cboNhanvien.Text)
: "Tất cả");
string reportcode = chkTachCDHA.Checked ? "baocao_doanhthuphongkham_chitiet" : "baocao_doanhthuphongkham_tonghop";
var crpt = Utility.GetReport(reportcode, ref tieude, ref reportname);
if (crpt == null)
{
return;
}
string StaffName = globalVariables.gv_strTenNhanvien;
if (string.IsNullOrEmpty(globalVariables.gv_strTenNhanvien))
{
StaffName = globalVariables.UserName;
}
try
{
frmPrintPreview objForm = new frmPrintPreview(tieude, crpt, true, _dtData.Rows.Count <= 0 ? false : true);
//try
//{
crpt.SetDataSource(_dtData);
objForm.mv_sReportFileName = Path.GetFileName(reportname);
objForm.mv_sReportCode = reportcode;
crpt.SetParameterValue("StaffName", StaffName);
crpt.SetParameterValue("BranchName", globalVariables.Branch_Name);
crpt.SetParameterValue("Address", globalVariables.Branch_Address);
crpt.SetParameterValue("Phone", globalVariables.Branch_Phone);
crpt.SetParameterValue("FromDateToDate", Condition);
crpt.SetParameterValue("sTitleReport", tieude);
crpt.SetParameterValue("sMoneybyLetter", new MoneyByLetter().sMoneyToLetter(tong_tien.ToString()));
crpt.SetParameterValue("sCurrentDate", Utility.FormatDateTimeWithThanhPho(dtNgayInPhieu.Value));
crpt.SetParameterValue("BottomCondition", THU_VIEN_CHUNG.BottomCondition());
objForm.crptViewer.ReportSource = crpt;
objForm.ShowDialog();
}
catch (Exception exception)
{
}
}
private void cmdInPhieuXN_Click(object sender, EventArgs e)
{
_dtData = new DataTable();
if (chkChitiet.Checked)
{
_dtData =
BAOCAO_NGOAITRU.BaoCaoThongkeTheoMaBenhICD10ChiTiet(
chkByDate.Checked ? dtFromDate.Value : Convert.ToDateTime("01/01/1900"),
chkByDate.Checked ? dtToDate.Value : globalVariables.SysDate,
Utility.sDbnull(cboDoituongKCB.SelectedValue, ""), Utility.sDbnull(cboKhoa.SelectedValue, ""),
Utility.sDbnull(txtListICD.Text, ""));
THU_VIEN_CHUNG.CreateXML(_dtData, "baocao_thongketheomabenh_icd10_chitiet.xml");
Utility.SetDataSourceForDataGridEx(grdChitiet, _dtData, false, true, "1=1", "");
}
else
{
_dtData =
BAOCAO_NGOAITRU.BaoCaoThongkeTheoMaBenhICD10TongHop(
chkByDate.Checked ? dtFromDate.Value : Convert.ToDateTime("01/01/1900"),
chkByDate.Checked ? dtToDate.Value : globalVariables.SysDate,
Utility.sDbnull(cboDoituongKCB.SelectedValue, ""), Utility.sDbnull(cboKhoa.SelectedValue, ""),
Utility.sDbnull(txtListICD.Text, ""));
THU_VIEN_CHUNG.CreateXML(_dtData, "baocao_thongketheomabenh_icd10_tonghop.xml");
Utility.SetDataSourceForDataGridEx(grdList, _dtData, false, true, "1=1", "");
}
if (_dtData.Rows.Count <= 0)
{
Utility.ShowMsg("Không tìm thấy dữ liệu báo cáo theo điều kiện bạn chọn", "Thông báo",
MessageBoxIcon.Information);
return;
}
Utility.UpdateLogotoDatatable(ref _dtData);
string Condition =
string.Format("Từ ngày {0} đến {1} - Đối tượng : {2} - Khoa KCB :{3} - Người tiếp đón: {4}",
dtFromDate.Text, dtToDate.Text,
cboDoituongKCB.SelectedIndex >= 0
? Utility.sDbnull(cboDoituongKCB.Text)
: "Tất cả",
cboKhoa.SelectedIndex > 0
? Utility.sDbnull(cboKhoa.Text)
: "Tất cả", txtMaBenhICD10.MyCode == "-1" ? "Tất cả" : txtMaBenhICD10.Text);
ReportDocument crpt =
Utility.GetReport(
chkChitiet.Checked
? "baocao_thongketheomabenh_icd10_chitiet"
: "baocao_thongketheomabenh_icd10_tonghop", ref tieude, ref reportname);
if (crpt == null)
{
return;
}
string StaffName = globalVariables.gv_strTenNhanvien;
if (string.IsNullOrEmpty(globalVariables.gv_strTenNhanvien))
{
StaffName = globalVariables.UserName;
}
try
{
var objForm = new frmPrintPreview(tieude, crpt, true, _dtData.Rows.Count <= 0 ? false : true);
crpt.SetDataSource(_dtData);
objForm.mv_sReportFileName = Path.GetFileName(reportname);
objForm.mv_sReportCode = chkChitiet.Checked
? "baocao_thongketheomabenh_icd10_chitiet"
: "baocao_thongketheomabenh_icd10_tonghop";
crpt.SetParameterValue("StaffName", StaffName);
crpt.SetParameterValue("ParentBranchName", globalVariables.ParentBranch_Name);
crpt.SetParameterValue("BranchName", globalVariables.Branch_Name);
crpt.SetParameterValue("Address", globalVariables.Branch_Address);
crpt.SetParameterValue("Phone", globalVariables.Branch_Phone);
crpt.SetParameterValue("FromDateToDate", Condition);
crpt.SetParameterValue("sTitleReport", tieude);
crpt.SetParameterValue("sCurrentDate", Utility.FormatDateTimeWithThanhPho(dtNgayInPhieu.Value));
crpt.SetParameterValue("BottomCondition", THU_VIEN_CHUNG.BottomCondition());
objForm.crptViewer.ReportSource = crpt;
objForm.ShowDialog();
}
catch (Exception exception)
{
Utility.ShowMsg("Lỗi:" + exception.Message);
}
}
private void cmdInPhieu_Click(object sender, EventArgs e)
{
int trangthai = -1;
if (radTatca.Checked)
{
trangthai = -1;
}
if (radDathuchien.Checked)
{
trangthai = 1;
}
if (radChuathuchien.Checked)
{
trangthai = 0;
}
DataTable dtDanhsach =
SPs.BaocaoThongkedanhsachThuchienchucnang(dtFromDate.Value, dtToDate.Value,
Utility.Int16Dbnull(cboDoituongKCB.SelectedValue, -1),
Utility.sDbnull(cboKhoa.SelectedValue, "KKB"), Args,
Utility.Int32Dbnull(txtdichvu.MyID, -1), trangthai)
.GetDataSet().Tables[0];
Utility.SetDataSourceForDataGridEx(grdResult, dtDanhsach, false, false, "", "");
THU_VIEN_CHUNG.CreateXML(dtDanhsach, "baocao_thongkedanhsach_chucnang.XML");
if (dtDanhsach.Rows.Count <= 0)
{
Utility.ShowMsg("Không có dữ liệu để báo cáo!");
return;
}
Utility.UpdateLogotoDatatable(ref dtDanhsach);
string reportCode = "";
switch (Args.Substring(0, 2))
{
case "SA":
reportCode = "baocao_thongkedanhsach_sieuam";
break;
case "XQ":
reportCode = "baocao_thongkedanhsach_xquang";
break;
case "DT":
reportCode = "baocao_thongkedanhsach_dientim";
break;
case "NS":
reportCode = "baocao_thongkedanhsach_noisoi";
break;
case "PT":
reportCode = "baocao_thongkedanhsach_pttt";
break;
default:
reportCode = "baocao_thongkedanhsach_noisoi";
break;
}
string Condition =
string.Format("Từ ngày {0} đến {1} - Đối tượng : {2} - Khoa KCB :{3}",
dtFromDate.Text, dtToDate.Text,
cboDoituongKCB.SelectedIndex >= 0
? Utility.sDbnull(cboDoituongKCB.Text)
: "Tất cả",
cboKhoa.SelectedIndex > 0
? Utility.sDbnull(cboKhoa.Text)
: "Tất cả");
ReportDocument crpt = Utility.GetReport(reportCode, ref tieude, ref reportname);
if (crpt == null)
{
return;
}
string StaffName = globalVariables.gv_strTenNhanvien;
if (string.IsNullOrEmpty(globalVariables.gv_strTenNhanvien))
{
StaffName = globalVariables.UserName;
}
try
{
var objForm = new frmPrintPreview(tieude, crpt, true, dtDanhsach.Rows.Count <= 0 ? false : true);
crpt.SetDataSource(dtDanhsach);
objForm.mv_sReportFileName = Path.GetFileName(reportname);
objForm.mv_sReportCode = reportCode;
crpt.SetParameterValue("StaffName", StaffName);
crpt.SetParameterValue("ParentBranchName", globalVariables.ParentBranch_Name);
crpt.SetParameterValue("BranchName", globalVariables.Branch_Name);
crpt.SetParameterValue("Address", globalVariables.Branch_Address);
crpt.SetParameterValue("Phone", globalVariables.Branch_Phone);
crpt.SetParameterValue("FromDateToDate", Condition);
crpt.SetParameterValue("sTitleReport", tieude);
crpt.SetParameterValue("sCurrentDate", Utility.FormatDateTimeWithThanhPho(dtNgayInPhieu.Value));
crpt.SetParameterValue("BottomCondition", THU_VIEN_CHUNG.BottomCondition());
Utility.SetParameterValue(crpt, "txtTrinhky",
Utility.getTrinhky(objForm.mv_sReportFileName, globalVariables.SysDate));
objForm.crptViewer.ReportSource = crpt;
objForm.ShowDialog();
}
catch (Exception exception)
{
Utility.ShowMsg("Lỗi:" + exception.Message);
}
finally
{
Utility.FreeMemory(crpt);
}
}
/// <summary>
/// hàm thực hiện việc in phiếu báo cáo tổng hợp
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void cmdInPhieuXN_Click(object sender, EventArgs e)
{
string kieutimkiem = "-1";
if (chktienkham.Checked == true && chktientiem.Checked == false && chktienvacxin.Checked == false)
{
kieutimkiem = "1";
}
if (chktienkham.Checked == true && chktientiem.Checked == true && chktienvacxin.Checked == false)
{
kieutimkiem = "1,11";
}
if (chktienkham.Checked == false && chktientiem.Checked == true && chktienvacxin.Checked == false)
{
kieutimkiem = "11";
}
if (chktienkham.Checked == true && chktientiem.Checked == false && chktienvacxin.Checked == true)
{
kieutimkiem = "1,3";
}
if (chktienkham.Checked == false && chktientiem.Checked == true && chktienvacxin.Checked == true)
{
kieutimkiem = "11,3";
}
if (chkChitiet.Checked)
{
_dtData =
BAOCAO_NGOAITRU.BaocaoThutientiemchungchitiet(
chkByDate.Checked ? dtFromDate.Value : Convert.ToDateTime("01/01/1900"),
chkByDate.Checked ? dtToDate.Value : globalVariables.SysDate,
Utility.sDbnull(cboDoituongKCB.SelectedValue, -1),
Utility.sDbnull(cboNhanvien.SelectedValue, -1),
Utility.sDbnull(cboLoaidichvu.SelectedValue, ""),
Utility.sDbnull(thamso, ""),
Utility.sDbnull(cboKhoa.SelectedValue, -1), kieutimkiem);
THU_VIEN_CHUNG.CreateXML(_dtData, "baocao_thutien_tiemchung_chitiet.xml");
Utility.SetDataSourceForDataGridEx(grdChitiet, _dtData, false, true, "1=1", "");
Janus.Windows.GridEX.GridEXColumn gridExColumnTientong = grdChitiet.RootTable.Columns["Thanh_Tien"];
tong_tien = Utility.Int32Dbnull(grdChitiet.GetTotal(gridExColumnTientong, Janus.Windows.GridEX.AggregateFunction.Sum));
}
else
{
_dtData =
BAOCAO_NGOAITRU.BaocaoThutientiemchungtonghop(
chkByDate.Checked ? dtFromDate.Value : Convert.ToDateTime("01/01/1900"),
chkByDate.Checked ? dtToDate.Value : globalVariables.SysDate,
Utility.sDbnull(cboDoituongKCB.SelectedValue, -1),
Utility.sDbnull(cboNhanvien.SelectedValue, -1),
Utility.Int16Dbnull(cboLoaidichvu.SelectedValue, -1), Utility.sDbnull(thamso, ""), Utility.sDbnull(cboKhoa.SelectedValue, -1));
THU_VIEN_CHUNG.CreateXML(_dtData, "baocao_thutien_tiemchung_tonghop.xml");
Utility.SetDataSourceForDataGridEx(grdList, _dtData, false, true, "1=1", "");
Janus.Windows.GridEX.GridEXColumn gridExColumnTientong = grdList.RootTable.Columns["Thanh_Tien"];
tong_tien = Utility.Int32Dbnull(grdList.GetTotal(gridExColumnTientong, Janus.Windows.GridEX.AggregateFunction.Sum));
}
if (_dtData.Rows.Count <= 0)
{
Utility.ShowMsg("Không tìm thấy dữ liệu báo cáo theo điều kiện bạn chọn", "Thông báo", MessageBoxIcon.Information);
return;
}
if (chktienkham.Checked == false && chktientiem.Checked == false && chktienvacxin.Checked == true)
{
kieutimkiem = "3";
}
Utility.UpdateLogotoDatatable(ref _dtData);
string condition = string.Format("Từ ngày {0} đến {1} - Đối tượng : {2} - Nhân viên :{3} - Phương thức thanh toán: {4}", dtFromDate.Text, dtToDate.Text,
cboDoituongKCB.SelectedIndex >= 0
? Utility.sDbnull(cboDoituongKCB.Text)
: "Tất cả",
cboNhanvien.SelectedIndex > 0
? Utility.sDbnull(cboNhanvien.Text)
: "Tất cả", cboLoaidichvu.SelectedIndex > 0 ?Utility.sDbnull(cboLoaidichvu.Text):"Tất cả");
var crpt = Utility.GetReport(chkChitiet.Checked ? "baocao_thutien_tiemchung_chitiet" : "baocao_thutien_tiemchung_tonghop", ref tieude, ref reportname);
if (crpt == null)
{
return;
}
string staffName = globalVariables.gv_strTenNhanvien;
if (string.IsNullOrEmpty(globalVariables.gv_strTenNhanvien))
{
staffName = globalVariables.UserName;
}
try
{
frmPrintPreview objForm = new frmPrintPreview(tieude, crpt, true, _dtData.Rows.Count <= 0 ? false : true);
//try
//{
crpt.SetDataSource(_dtData);
objForm.mv_sReportFileName = Path.GetFileName(reportname);
objForm.mv_sReportCode = chkChitiet.Checked ? "baocao_thutien_tiemchung_chitiet" : "baocao_thutien_tiemchung_tonghop";
crpt.SetParameterValue("StaffName", staffName);
crpt.SetParameterValue("BranchName", globalVariables.Branch_Name);
crpt.SetParameterValue("Address", globalVariables.Branch_Address);
crpt.SetParameterValue("Phone", globalVariables.Branch_Phone);
crpt.SetParameterValue("FromDateToDate", condition);
crpt.SetParameterValue("sTitleReport", tieude);
crpt.SetParameterValue("sCurrentDate", Utility.FormatDateTimeWithThanhPho(dtNgayInPhieu.Value));
crpt.SetParameterValue("BottomCondition", THU_VIEN_CHUNG.BottomCondition());
objForm.crptViewer.ReportSource = crpt;
objForm.ShowDialog();
}
catch (Exception exception)
{
Utility.ShowMsg("Lỗi:" + exception.Message);
}
}
/// <summary>
/// hàm thực hiện việc in báo cáo thống kê chuyển viện
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void cmdPrint_Click(object sender, EventArgs e)
{
try
{
if (radChuyenDi.Checked)
{
_reportTable =
BAOCAO_NGOAITRU.BaoCaoThongkeChuyenVienDi(
chkByDate.Checked ? dtFromDate.Value : Convert.ToDateTime("01/01/1900"),
chkByDate.Checked ? dtToDate.Value : globalVariables.SysDate, Utility.sDbnull(txtTenBenh.MyCode, "-1"), Utility.Int32Dbnull(txtBacSy.MyID, -1),
Utility.Int32Dbnull(txtBenhVien.MyID, -1), Utility.Int32Dbnull(cboNTNT.SelectedValue, -1),
Utility.Int32Dbnull(cboDoituongKCB.SelectedValue, -1));
THU_VIEN_CHUNG
.CreateXML(_reportTable, "baocao_thongke_chuyendi.XML");
Utility.SetDataSourceForDataGridEx(grdChuyendi, _reportTable, false, true, "1=1", "");
}
else
{
_reportTable =
BAOCAO_NGOAITRU.BaoCaoThongkeChuyenVienDen(
chkByDate.Checked ? dtFromDate.Value : Convert.ToDateTime("01/01/1900"),
chkByDate.Checked ? dtToDate.Value : globalVariables.SysDate,
Utility.Int32Dbnull(txtBenhVien.MyID, -1), Utility.Int32Dbnull(cboNTNT.SelectedValue, -1),
Utility.Int32Dbnull(cboDoituongKCB.SelectedValue, -1));
THU_VIEN_CHUNG
.CreateXML(_reportTable, "baocao_thongke_chuyenden.XML");
Utility.SetDataSourceForDataGridEx(grdChuyenDen, _reportTable, false, true, "1=1", "");
}
if (_reportTable.Rows.Count <= 0)
{
Utility.ShowMsg("Không tìm thấy dữ liệu cho báo cáo", "Thông báo", MessageBoxIcon.Warning);
return;
}
string StaffName = globalVariables.gv_strTenNhanvien;
if (string.IsNullOrEmpty(globalVariables.gv_strTenNhanvien))
{
StaffName = globalVariables.UserName;
}
string Condition = string.Format("Từ ngày {0} đến {1} - Đối tượng : {2} - Loại điều trị :{3} ", dtFromDate.Text, dtToDate.Text,
cboDoituongKCB.SelectedIndex > 0
? Utility.sDbnull(cboDoituongKCB.Text)
: "Tất cả", cboNTNT.SelectedIndex > 0 ? Utility.sDbnull(cboNTNT.Text) : "Tất cả");
Utility.UpdateLogotoDatatable(ref _reportTable);
string reportCode = radChuyenDen.Checked ? "baocao_thongke_chuyenden" : "baocao_thongke_chuyendi";
var crpt = Utility.GetReport(reportCode, ref tieude, ref reportname);
if (crpt == null)
{
return;
}
frmPrintPreview objForm = new frmPrintPreview(tieude, crpt, true, _reportTable.Rows.Count <= 0 ? false : true);
crpt.SetDataSource(_reportTable);
objForm.mv_sReportFileName = Path.GetFileName(reportname);
objForm.mv_sReportCode = reportCode;
Utility.SetParameterValue(crpt, "StaffName", StaffName);
Utility.SetParameterValue(crpt, "BranchName", globalVariables.Branch_Name);
Utility.SetParameterValue(crpt, "ParentBranchName", globalVariables.ParentBranch_Name);
Utility.SetParameterValue(crpt, "Address", globalVariables.Branch_Address);
Utility.SetParameterValue(crpt, "Phone", globalVariables.Branch_Phone);
Utility.SetParameterValue(crpt, "FromDateToDate", Condition);
Utility.SetParameterValue(crpt, "sTitleReport", tieude);
Utility.SetParameterValue(crpt, "CurrentDate", Utility.FormatDateTimeWithThanhPho(dtNgayInPhieu.Value));
Utility.SetParameterValue(crpt, "BottomCondition", THU_VIEN_CHUNG.BottomCondition());
Utility.SetParameterValue(crpt, "txtTrinhky", Utility.getTrinhky(objForm.mv_sReportFileName, globalVariables.SysDate));
objForm.crptViewer.ReportSource = crpt;
objForm.ShowDialog();
}
catch (Exception ex)
{
Utility.CatchException("Lỗi khi in báo cáo", ex);
}
}
private void InphieuCLS()
{
m_dtReport = null;
//SPs.ClsLaokhoaInphieuChidinhCls(objAssignInfo.AssignCode, objAssignInfo.PatientCode,
// Utility.Int32Dbnull(objAssignInfo.PatientId)).GetDataSet().Tables[0];
if (m_dtReport.Rows.Count <= 0)
{
Utility.ShowMsg("Không tìm thấy bản ghi nào, bạn xem lại, phải chọn một bản ghi để thực hiện việc in phiếu chỉ định", "Thông báo", MessageBoxIcon.Warning);
return;
}
m_dtReport = (from lox in m_dtReport.AsEnumerable().Cast <DataRow>()
where Utility.Int32Dbnull(lox["CHO_PHEP_IN"], 0) == 1
select lox
).CopyToDataTable();
Utility.UpdateLogotoDatatable(ref m_dtReport);
Utility.AddColumToDataTable(ref m_dtReport, "SO_PHIEU_BARCODE", typeof(byte[]));
byte[] arrBarCode = Utility.GenerateBarCode(barcode);
foreach (DataRow drv in m_dtReport.Rows)
{
drv["SO_PHIEU_BARCODE"] = arrBarCode;
}
m_dtReport.AcceptChanges();
string KhoGiay = "A5";
if (radKhoA4.Checked)
{
KhoGiay = "A4";
}
try
{
ReportDocument reportDocument = new ReportDocument();
string tieude = "", reportname = "";
switch (KhoGiay)
{
case "A5":
reportDocument = Utility.GetReport("thamkham_PHIEU_CHIDINH_CLS_A5", ref tieude, ref reportname);
break;
case "A4":
reportDocument = Utility.GetReport("thamkham_PHIEU_CHIDINH_CLS", ref tieude, ref reportname);
break;
default:
reportDocument = Utility.GetReport("thamkham_PHIEU_CHIDINH_CLS", ref tieude, ref reportname);
break;
}
if (reportDocument == null)
{
return;
}
var crpt = reportDocument;
frmPrintPreview objForm = new frmPrintPreview(txtTieuDe.Text, crpt, true, m_dtReport.Rows.Count <= 0 ? false : true);
//try
//{
crpt.SetDataSource(m_dtReport);
//crpt.DataDefinition.FormulaFields["Formula_1"].Text = Strings.Chr(34) + "".Replace("#$X$#", Strings.Chr(34) + "&Chr(13)&" + Strings.Chr(34)) + Strings.Chr(34);
// Utility.SetParameterValue(crpt,"ParentBranchName", globalVariables.ParentBranch_Name);
Utility.SetParameterValue(crpt, "BranchName", globalVariables.Branch_Name);
Utility.SetParameterValue(crpt, "Address", globalVariables.Branch_Address);
Utility.SetParameterValue(crpt, "Phone", globalVariables.Branch_Phone);
Utility.SetParameterValue(crpt, "sTitleReport", txtTieuDe.Text);
Utility.SetParameterValue(crpt, "CurrentDate", Utility.FormatDateTimeWithThanhPho(dtNgayInPhieu.Value));
Utility.SetParameterValue(crpt, "BottomCondition", THU_VIEN_CHUNG.BottomCondition());
objForm.crptViewer.ReportSource = crpt;
objForm.ShowDialog();
}
catch (Exception exception)
{
}
}
/// <summary>
/// hàm thực hiên viecj in báo cáo doanh thu tiền khám chữa bệnh viện phí
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void cmdInPhieuXN_Click(object sender, EventArgs e)
{
_mabschidinh = "-1";
_idThuoc = -1;
// Lấy Id Bác sỹ
if (!string.IsNullOrEmpty(cboBacSyChiDinh.Text))
{
var query = (from chk in cboBacSyChiDinh.CheckedValues.AsEnumerable()
let x = Utility.sDbnull(chk)
select x).ToArray();
if (query.Count() > 0)
{
_mabschidinh = string.Join(",", query);
}
}
//Truyền dữ liệu vào datatable
DataTable m_dtReport = BAOCAO_THUOC.ThuocBaocaoTinhhinhkedonthuocTheobacsy(Utility.Int32Dbnull(cboStock.SelectedValue, -1), Utility.Int32Dbnull(cboDoiTuong.SelectedValue, -1),
_mabschidinh, _idThuoc, chkByDate.Checked ? dtFromDate.Value : Convert.ToDateTime("01/01/1900"), chkByDate.Checked ? dtToDate.Value : globalVariables.SysDate, Utility.Int16Dbnull(cboTrangthai.SelectedValue, -1));
if (m_dtReport == null)
{
return;
}
THU_VIEN_CHUNG.CreateXML(m_dtReport, "thuoc_baocaokedon_theobacsy.xml");
//Kiểm tra dữ liệu
if (m_dtReport.Rows.Count <= 0)
{
Utility.ShowMsg("Không tìm thấy dữ liệu cho báo cáo", "Thông báo", MessageBoxIcon.Warning);
return;
}
//Truyền tổng tiền vào text và chuyển qua tiền bằng chữ
Janus.Windows.GridEX.GridEXColumn gridExColumnTong = grdList.RootTable.Columns["thanh_tien"];
decimal tong =
Utility.DecimaltoDbnull(grdList.GetTotal(gridExColumnTong, Janus.Windows.GridEX.AggregateFunction.Sum));
m_dtReport.AcceptChanges();
Utility.UpdateLogotoDatatable(ref m_dtReport);
//Truyền dữ liệu vào datagrid-view
Utility.SetDataSourceForDataGridEx(grdList, m_dtReport, false, true, "1=1", "");
//Lấy chuỗi condition truyền vào biến ?FromDateToDate trên crpt
string Condition = string.Format("Từ ngày {0} đến {1}- Đối tượng {2} - Thuộc kho :{3} - Bác sỹ: {4}", dtFromDate.Text, dtToDate.Text,
cboDoiTuong.SelectedIndex > 0
? Utility.sDbnull(cboDoiTuong.SelectedValue)
: "Tất cả",
cboStock.SelectedIndex > 0
? Utility.sDbnull(cboStock.SelectedValue)
: "Tất cả",
string.IsNullOrEmpty(cboBacSyChiDinh.Text) ? "Tất cả" : cboBacSyChiDinh.Text);
//Lấy tên người tạo báo cáo và gọi crpt
string StaffName = globalVariables.gv_strTenNhanvien;
string tieude = "", reportname = "";
var crpt = Utility.GetReport("thuoc_baocaokedon_theobacsy", ref tieude, ref reportname);
if (crpt == null)
{
return;
}
if (string.IsNullOrEmpty(globalVariables.gv_strTenNhanvien))
{
StaffName = globalVariables.UserName;
}
try
{
frmPrintPreview objForm = new frmPrintPreview(baocaO_TIEUDE1.TIEUDE, crpt, true, m_dtReport.Rows.Count <= 0 ? false : true);
crpt.SetDataSource(m_dtReport);
objForm.mv_sReportFileName = Path.GetFileName(reportname);
objForm.mv_sReportCode = "thuoc_baocaokedon_theobacsy";
Utility.SetParameterValue(crpt, "StaffName", StaffName);
Utility.SetParameterValue(crpt, "BranchName", globalVariables.Branch_Name);
Utility.SetParameterValue(crpt, "Address", globalVariables.Branch_Address);
Utility.SetParameterValue(crpt, "Phone", globalVariables.Branch_Phone);
Utility.SetParameterValue(crpt, "FromDateToDate", Condition);
Utility.SetParameterValue(crpt, "sTitleReport", baocaO_TIEUDE1.TIEUDE);
Utility.SetParameterValue(crpt, "TienBangChu", _moneyByLetter.sMoneyToLetter(tong.ToString()));
Utility.SetParameterValue(crpt, "sCurrentDate", Utility.FormatDateTimeWithThanhPho(dtNgayInPhieu.Value));
Utility.SetParameterValue(crpt, "BottomCondition", THU_VIEN_CHUNG.BottomCondition());
Utility.SetParameterValue(crpt, "Department_Name", globalVariables.KhoaDuoc);
Utility.SetParameterValue(crpt, "txtTrinhky", Utility.getTrinhky(objForm.mv_sReportFileName, globalVariables.SysDate));
objForm.crptViewer.ReportSource = crpt;
objForm.ShowDialog();
}
catch (Exception exception)
{
}
}
/// <summary>
/// hàm thực hiên viecj in báo cáo doanh thu tiền khám chữa bệnh viện phí
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void cmdInPhieuXN_Click(object sender, EventArgs e)
{
DataTable m_dtReport =
BAOCAO_THUOC.ThuocBaocaoTinhhinhPhatthuocbenhnhan(
chkByDate.Checked ? dtFromDate.Value : Convert.ToDateTime("01/01/1900"),
chkByDate.Checked ? dtToDate.Value : globalVariables.SysDate,
Utility.Int32Dbnull(cboStock.SelectedValue, -1),
Utility.Int32Dbnull(cboDoiTuong.SelectedValue, "-1"), chkThongketheongaychot.Checked ? 1 : 0,
kieuthuoc_vt);
Utility.SetDataSourceForDataGridEx(grdList, m_dtReport, false, true, "1=1", "");
GridEXColumn gridExColumn = grdList.RootTable.Columns["THANH_TIEN"];
if (m_dtReport.Rows.Count <= 0)
{
Utility.ShowMsg("Không tìm thấy dữ liệu cho báo cáo", "Thông báo", MessageBoxIcon.Warning);
return;
}
Utility.AddColumToDataTable(ref m_dtReport, "STT", typeof(Int32));
int idx = 1;
foreach (DataRow drv in m_dtReport.Rows)
{
drv["STT"] = idx;
idx++;
}
m_dtReport.AcceptChanges();
Utility.UpdateLogotoDatatable(ref m_dtReport);
string Condition = string.Format("Từ ngày {0} đến {1}- Đối tượng {2} - Thuộc kho :{3}", dtFromDate.Text,
dtToDate.Text,
cboDoiTuong.SelectedIndex > 0
? Utility.sDbnull(cboDoiTuong.Text)
: "Tất cả",
cboStock.SelectedIndex > 0
? Utility.sDbnull(cboStock.Text)
: "Tất cả");
// Utility.AddColumToDataTable(ref m_dtReport, "SO_PHIEU_BARCODE", typeof(byte[]));
// byte[] arrBarCode = Utility.GenerateBarCode(barcode);
string StaffName = globalVariables.gv_strTenNhanvien;
if (string.IsNullOrEmpty(globalVariables.gv_strTenNhanvien))
{
StaffName = globalVariables.UserName;
}
try
{
string tieude = "", reportname = "";
string reportCode = kieuthuoc_vt == "THUOC"
? "thuoc_baocao_chitiet_thuoccapphat_benhnhan"
: "vt_baocao_chitiet_vtcapphat_benhnhan";
ReportDocument crpt = Utility.GetReport(reportCode, ref tieude, ref reportname);
if (crpt == null)
{
return;
}
var objForm = new frmPrintPreview(baocaO_TIEUDE1.txtTieuDe.Text, crpt, true,
m_dtReport.Rows.Count <= 0 ? false : true);
//try
//{
crpt.SetDataSource(m_dtReport);
objForm.mv_sReportFileName = Path.GetFileName(reportname);
objForm.mv_sReportCode = reportCode;
//crpt.DataDefinition.FormulaFields["Formula_1"].Text = Strings.Chr(34) + "".Replace("#$X$#", Strings.Chr(34) + "&Chr(13)&" + Strings.Chr(34)) + Strings.Chr(34);
// Utility.SetParameterValue(crpt,"ParentBranchName", globalVariables.ParentBranch_Name);
Utility.SetParameterValue(crpt, "StaffName", StaffName);
Utility.SetParameterValue(crpt, "BranchName", globalVariables.Branch_Name);
Utility.SetParameterValue(crpt, "Address", globalVariables.Branch_Address);
Utility.SetParameterValue(crpt, "Phone", globalVariables.Branch_Phone);
Utility.SetParameterValue(crpt, "FromDateToDate", Condition);
Utility.SetParameterValue(crpt, "sTitleReport", tieude);
Utility.SetParameterValue(crpt, "sCurrentDate", Utility.FormatDateTimeWithThanhPho(dtNgayInPhieu.Value));
Utility.SetParameterValue(crpt, "BottomCondition", THU_VIEN_CHUNG.BottomCondition());
Utility.SetParameterValue(crpt, "Deparment_Name", globalVariables.KhoaDuoc);
Utility.SetParameterValue(crpt, "txtTrinhky",
Utility.getTrinhky(objForm.mv_sReportFileName,
globalVariables.SysDate));
objForm.crptViewer.ReportSource = crpt;
objForm.ShowDialog();
//Utility.DecimaltoDbnull(THU_VIEN_CHUNG.Laygiatrithamsohethong("THUOC_INGIAYXINNOP_TIENTHUOC", "0", false), 0m)
if (THU_VIEN_CHUNG.Laygiatrithamsohethong("THUOC_INGIAYXINNOP_TIENTHUOC", "0", false) == "1")
{
string tieude2 = "", reportname2 = "";
string reportCode2 = kieuthuoc_vt == "THUOC"
? "thuoc_baocao_giayxinnop_tienthuoc"
: "vt_baocao_chitiet_vtcapphat_benhnhan";
ReportDocument crpt2 = Utility.GetReport(reportCode2, ref tieude2, ref reportname2);
if (crpt2 == null)
{
return;
}
var objForm2 = new frmPrintPreview(baocaO_TIEUDE1.txtTieuDe.Text, crpt2, true,
m_dtReport.Rows.Count <= 0 ? false : true);
//try
//{
crpt2.SetDataSource(m_dtReport);
objForm2.mv_sReportFileName = Path.GetFileName(reportname2);
objForm2.mv_sReportCode = reportCode2;
//crpt.DataDefinition.FormulaFields["Formula_1"].Text = Strings.Chr(34) + "".Replace("#$X$#", Strings.Chr(34) + "&Chr(13)&" + Strings.Chr(34)) + Strings.Chr(34);
// Utility.SetParameterValue(crpt,"ParentBranchName", globalVariables.ParentBranch_Name);
Utility.SetParameterValue(crpt2, "StaffName", StaffName);
Utility.SetParameterValue(crpt2, "BranchName", globalVariables.Branch_Name);
Utility.SetParameterValue(crpt2, "Address", globalVariables.Branch_Address);
Utility.SetParameterValue(crpt2, "Phone", globalVariables.Branch_Phone);
Utility.SetParameterValue(crpt2, "FromDateToDate", Condition);
Utility.SetParameterValue(crpt2, "sTitleReport", tieude2);
Utility.SetParameterValue(crpt2, "sCurrentDate",
Utility.FormatDateTimeWithThanhPho(dtNgayInPhieu.Value));
Utility.SetParameterValue(crpt2, "BottomCondition", THU_VIEN_CHUNG.BottomCondition());
Utility.SetParameterValue(crpt2, "Deparment_Name", globalVariables.KhoaDuoc);
Utility.SetParameterValue(crpt2, "txtTrinhky",
Utility.getTrinhky(objForm2.mv_sReportFileName,
globalVariables.SysDate));
objForm2.crptViewer.ReportSource = crpt2;
objForm2.ShowDialog();
}
}
catch (Exception exception)
{
Utility.ShowMsg("Lỗi:" + exception.Message);
}
}
/// <summary>
/// hàm thực hiện việc in phiếu xét nghiêm
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void cmdPrint_Click(object sender, EventArgs e)
{
try
{
if (chkChitiet.Checked)
{
_reportTable =
BAOCAO_NGOAITRU.BaocaoThuvienphiChitiet(Utility.sDbnull(cbokhoa.SelectedValue, "-1"), chkByDate.Checked ? dtFromDate.Value : Convert.ToDateTime("01/01/1900"),
chkByDate.Checked ? dtToDate.Value : globalVariables.SysDate, Utility.sDbnull(cbonhanvien.SelectedValue, -1),
Utility.sDbnull(cboDoituongKCB.SelectedValue, -1),
Utility.Int32Dbnull(cboNTNT.SelectedValue, -1), Utility.Int32Dbnull(cboHoadon.SelectedValue, -1), chkLoaitimkiem.Checked ? 1 : 0);
Utility.SetDataSourceForDataGridEx(grdChitiet, _reportTable, false, true, "1=1", "");
//Janus.Windows.GridEX.GridEXColumn gridExColumnTientong = grdChitiet.RootTable.Columns["tong_Tien"];
//tong_tien = Utility.Int32Dbnull(grdList.GetTotal(gridExColumnTientong, Janus.Windows.GridEX.AggregateFunction.Sum));
}
else
{
_reportTable =
BAOCAO_NGOAITRU.BaocaoThuvienphiTonghop(Utility.sDbnull(cbokhoa.SelectedValue, "-1"), chkByDate.Checked ? dtFromDate.Value : Convert.ToDateTime("01/01/1900"),
chkByDate.Checked ? dtToDate.Value : globalVariables.SysDate, Utility.sDbnull(cbonhanvien.SelectedValue, "-1"),
Utility.sDbnull(cboDoituongKCB.SelectedValue, "-1"),
Utility.Int32Dbnull(cboNTNT.SelectedValue, -1), Utility.Int32Dbnull(cboHoadon.SelectedValue, -1), chkLoaitimkiem.Checked ? 1 : 0);
Utility.SetDataSourceForDataGridEx(grdList, _reportTable, false, true, "1=1", "");
//Janus.Windows.GridEX.GridEXColumn gridExColumnTientong = grdList.RootTable.Columns["tong_Tien"];
//tong_tien = Utility.Int32Dbnull(grdList.GetTotal(gridExColumnTientong, Janus.Windows.GridEX.AggregateFunction.Sum));
}
THU_VIEN_CHUNG.CreateXML(_reportTable, chkChitiet.Checked ? "baocao_thuvienphi_chitiet" : "baocao_thuvienphi_tonghop");
if (_reportTable.Rows.Count <= 0)
{
Utility.ShowMsg("Không tìm thấy dữ liệu cho báo cáo", "Thông báo", MessageBoxIcon.Warning);
return;
}
string StaffName = globalVariables.gv_strTenNhanvien;
if (string.IsNullOrEmpty(globalVariables.gv_strTenNhanvien))
{
StaffName = globalVariables.UserName;
}
string Condition = string.Format("Từ ngày {0} đến {1} - Đối tượng : {2} -TNV :{3} - Loại điều trị :{4} ", dtFromDate.Text, dtToDate.Text,
cboDoituongKCB.SelectedIndex > 0
? Utility.sDbnull(cboDoituongKCB.Text)
: "Tất cả",
cbonhanvien.SelectedIndex > 0
? Utility.sDbnull(cbonhanvien.Text)
: "Tất cả", cboNTNT.SelectedIndex > 0 ? Utility.sDbnull(cboNTNT.Text) : "Tất cả");
Utility.UpdateLogotoDatatable(ref _reportTable);
string reportCode = chkChitiet.Checked ? "baocao_thuvienphi_chitiet" : "baocao_thuvienphi_tonghop";
var crpt = Utility.GetReport(reportCode, ref tieude, ref reportname);
if (crpt == null)
{
return;
}
frmPrintPreview objForm = new frmPrintPreview(tieude, crpt, true, _reportTable.Rows.Count <= 0 ? false : true);
crpt.SetDataSource(_reportTable);
objForm.mv_sReportFileName = Path.GetFileName(reportname);
objForm.mv_sReportCode = reportCode;
Utility.SetParameterValue(crpt, "StaffName", StaffName);
Utility.SetParameterValue(crpt, "BranchName", globalVariables.Branch_Name);
Utility.SetParameterValue(crpt, "ParentBranchName", globalVariables.ParentBranch_Name);
Utility.SetParameterValue(crpt, "Address", globalVariables.Branch_Address);
Utility.SetParameterValue(crpt, "Phone", globalVariables.Branch_Phone);
Utility.SetParameterValue(crpt, "FromDateToDate", Condition);
Utility.SetParameterValue(crpt, "sTitleReport", tieude);
Utility.SetParameterValue(crpt, "sCurrentDate", Utility.FormatDateTimeWithThanhPho(dtNgayInPhieu.Value));
Utility.SetParameterValue(crpt, "BottomCondition", THU_VIEN_CHUNG.BottomCondition());
objForm.crptViewer.ReportSource = crpt;
objForm.ShowDialog();
}
catch (Exception ex)
{
Utility.CatchException("Lỗi khi in báo cáo", ex);
}
}