/// <summary>
/// hàm thực hiện in phiếu báo cáo
/// thông tin
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void cmdBaoCao_Click(object sender, EventArgs e)
{
try
{
int trangthai = Trangthai();
int kieungaytimkiem = chkKieungaytimkiem.Checked ? 1 : 0;
DataTable m_dtReport =
BAOCAO_THUOC.ThuocBaocaoTinhhinhxuatvacxintuyenhuyen(
chkByDate.Checked ? dtFromDate.Value.ToString("dd/MM/yyyy") : "01/01/1900",
chkByDate.Checked ? dtToDate.Value.ToString("dd/MM/yyyy") : "01/01/1900", trangthai,
Utility.Int32Dbnull(txtKho.MyID), Utility.Int32Dbnull(txtthuoc.MyID, -1),
(byte)LoaiPhieu.PhieuXuatkhoTuyenXaHuyen, kieungaytimkiem, KIEU_THUOC_VT);
THU_VIEN_CHUNG.CreateXML(m_dtReport, "thuoc_baocao_xuatvacxin_tuyenhuyen.xml");
Utility.SetDataSourceForDataGridEx(grdList, m_dtReport, true, true, "1=1", "");
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 FromDateToDate = Utility.FromToDateTime(dtFromDate.Text, dtToDate.Text);
thuoc_baocao.Baocaoxuatvacxintuyehuyen(m_dtReport,
"thuoc_baocao_xuatvacxin_tuyenhuyen", baocaO_TIEUDE1.TIEUDE,
dtNgayIn.Value, FromDateToDate);
}
catch (Exception ex)
{
Utility.ShowMsg("Lỗi:" + ex.Message);
}
}
private void LoadTh()
{
try
{
if (chktuyen.Checked)
{
m_dataTH =
new BAOCAO_BHYT().BHYT_21A_PHANTUYEN(dtpFromDate.Value, dtpToDate.Value,
"BHYT", -1, txtNhomBHYT.myCode, Utility.Int32Dbnull(cboTuyen.SelectedIndex - 1, -1),
Utility.sDbnull(globalVariables.gv_strNoiDKKCBBD, "01"), globalVariables.gv_strNoicapBHYT, Utility.sDbnull(txtKCBBDCode.Text, -1),
chkKhacMa.Checked ? "KHAC" : "BANG");
THU_VIEN_CHUNG.CreateXML(m_dataTH, "BHYT21A.xml");
Utility.SetDataSourceForDataGridEx(grdListPhanTuyen, m_dataTH, true, true, "1=1", "");
grdExcel.DataSource = m_dataTH;
}
else
{
m_dataTH =
new BAOCAO_BHYT().BHYT_21A(dtpFromDate.Value, dtpToDate.Value,
"BHYT", -1, txtNhomBHYT.myCode, Utility.Int32Dbnull(cboTuyen.SelectedIndex - 1, -1),
Utility.sDbnull(globalVariables.gv_strNoiDKKCBBD, "01"), globalVariables.gv_strNoicapBHYT, Utility.sDbnull(txtKCBBDCode.Text, -1),
chkKhacMa.Checked ? "KHAC" : "BANG");
THU_VIEN_CHUNG.CreateXML(m_dataTH, "BHYT21A.xml");
Utility.SetDataSourceForDataGridEx(grdList, m_dataTH, true, true, "1=1", "");
grdExcel.DataSource = m_dataTH;
}
}
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);
}
}
/// <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);
}
}
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);
}
}
/// <summary>
/// hàm thực hiện in phiếu báo cáo
/// thông tin
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void cmdBaoCao_Click(object sender, EventArgs e)
{
try
{
string nhomthuoc = "-1";
nhomthuoc = txtLoaithuoc.MyID.ToString();
DataTable m_dtReport = null;
if (_item.KieuKho == "CHAN" || (chkChanle.Enabled && chkChanle.Checked))
{
m_dtReport = BAOCAO_THUOC.ThuocBaocaoBiendongthuocTrongkhotong(chkByDate.Checked ? dtFromDate.Text : Utility.sDbnull("01/01/1900"),
chkByDate.Checked ? dtToDate.Text : globalVariables.SysDate.ToString(),
Utility.Int32Dbnull(cboKho.SelectedValue), nhomthuoc, Utility.Int32Dbnull(txtthuoc.MyID, -1), chkBiendong.Checked ? 1 : 0);
}
else
{
m_dtReport = BAOCAO_THUOC.ThuocBaocaoBiendongthuocTrongkhole(chkByDate.Checked ? dtFromDate.Text : Utility.sDbnull("01/01/1900"),
chkByDate.Checked ? dtToDate.Text : globalVariables.SysDate.ToString(),
Utility.Int32Dbnull(cboKho.SelectedValue), Utility.Int32Dbnull(txtthuoc.MyID, -1), nhomthuoc, chkBiendong.Checked ? 1 : 0);
}
Utility.SetDataSourceForDataGridEx(_item.KieuKho == "CHAN" || (chkChanle.Enabled && chkChanle.Checked) ? grdListKhoChan : grdListKhole, m_dtReport, true, true, "1=1", "");
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 FromDateToDate = Utility.FromToDateTime(dtFromDate.Text, dtToDate.Text);
if (_item.KieuKho == "CHAN" || (chkChanle.Enabled && chkChanle.Checked))
{
THU_VIEN_CHUNG.CreateXML(m_dtReport, "baocao_xuatnhapton_khochan.xml");
thuoc_baocao.BaocaoNhapxuattonKhochan(m_dtReport, KIEU_THUOC_VT, baocaO_TIEUDE1.TIEUDE,
dtNgayIn.Value, FromDateToDate,
Utility.sDbnull(cboKho.Text), chkTheoNhomThuoc.Checked);
}
else
{
THU_VIEN_CHUNG.CreateXML(m_dtReport, "baocao_xuatnhapton_khole.xml");
thuoc_baocao.BaocaoNhapxuattonKhole(m_dtReport, KIEU_THUOC_VT, baocaO_TIEUDE1.TIEUDE,
dtNgayIn.Value, FromDateToDate,
Utility.sDbnull(cboKho.Text), chkTheoNhomThuoc.Checked);
}
//else
//{
// thuoc_baocao.BaocaoNhapxuattonKhochanTheonhom(m_dtReport, baocaO_TIEUDE1.TIEUDE,
// dtNgayIn.Value, FromDateToDate,
// Utility.sDbnull(cboKho.Text));
//}
}
catch (Exception)
{
}
}
void LoadDataView()
{
try
{
mdtReport = new BAOCAO_BHYT().BHYT_14A_NEW(dtpFromDate.Value, dtpToDate.Value, "BHYT", txtNhomBHYT.myCode);
ModifyCommands();
THU_VIEN_CHUNG.CreateXML(mdtReport, "BHYT14A.xml");
grdList.DataSource = mdtReport;
}
catch (Exception ex)
{
Utility.CatchException(ex);
}
}
private void cmdInphieuhen_Click(object sender, EventArgs e)
{
try
{
DataTable dtphienhen =
SPs.KcbThamkhamInphieuhenBenhnhan(Utility.sDbnull(txtPatient_Code.Text, ""),
Utility.Int64Dbnull(txtPatient_ID.Text, -1)).
GetDataSet().Tables[0];
THU_VIEN_CHUNG.CreateXML(dtphienhen, "thamkham_inphieuhen_benhnhan.xml");
KcbInphieu.INPHIEU_HEN(dtphienhen, "PHIẾU HẸN KHÁM");
}
catch (Exception ex)
{
Utility.ShowMsg(ex.Message);
}
}
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 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());
}
}
}
void LoadTH()
{
try
{
if (chktuyen.Checked)
{
m_dataTH =
new BAOCAO_BHYT().BHYT_19A_PHANTUYEN(dtpFromDate.Value.ToString("dd/MM/yyyy"),
dtpToDate.Value.ToString("dd/MM/yyyy"),
"BHYT", -1,
Utility.Int32Dbnull(txtDrugID.Text, -1), Utility.Int16Dbnull(txtdrugtype_id.Text, -1),
txtNhomBHYT.myCode,
Utility.Int32Dbnull(cboTuyen.SelectedValue, -1),
Utility.sDbnull(globalVariables.gv_strNoiDKKCBBD, "01"),
globalVariables.gv_strNoicapBHYT, Utility.sDbnull(txtKCBBDCode.Text, -1),
chkKhacMa.Checked ? "KHAC" : "BANG", -1);
THU_VIEN_CHUNG.CreateXML(m_dataTH, "BHYT19A.xml");
Utility.SetDataSourceForDataGridEx(grdListPhanTuyen, m_dataTH, true, true, "1=1", "");
}
else
{
m_dataTH =
new BAOCAO_BHYT().BHYT_19A(dtpFromDate.Value.ToString("dd/MM/yyyy"),
dtpToDate.Value.ToString("dd/MM/yyyy"),
"BHYT", -1,
Utility.Int32Dbnull(txtDrugID.Text, -1), Utility.Int16Dbnull(txtdrugtype_id.Text, -1),
txtNhomBHYT.myCode,
Utility.Int32Dbnull(cboTuyen.SelectedValue, -1),
Utility.sDbnull(globalVariables.gv_strNoiDKKCBBD, "01"),
globalVariables.gv_strNoicapBHYT, Utility.sDbnull(txtKCBBDCode.Text, -1),
chkKhacMa.Checked ? "KHAC" : "BANG", -1);
THU_VIEN_CHUNG.CreateXML(m_dataTH, "BHYT19A.xml");
Utility.SetDataSourceForDataGridEx(grdList, m_dataTH, true, true, "1=1", "");
}
}
catch (Exception ex)
{
Utility.CatchException(ex);
}
}
void LoadCT()
{
try
{
m_dataCT =
new BAOCAO_BHYT().BHYT_05A_CT(dtpFromDate.Value.Date, dtpToDate.Value.Date,
"BHYT", -1,
Utility.Int32Dbnull(cboTuyen.SelectedValue, -1),
Utility.sDbnull(txtKCBBDCode.Text, -1), Utility.sDbnull(txtTPCode.Text, -1));
ProcessData();
if (!m_dataCT.Columns.Contains("IsDungTuyen"))
{
m_dataCT.Columns.Add("IsDungTuyen", typeof(string));
}
THU_VIEN_CHUNG.CreateXML(m_dataCT, "BHYT05A_CT.xml");
foreach (DataRow drv in m_dataCT.Rows)
{
switch (drv["dung_tuyen"].ToString())
{
case "0":
drv["IsDungTuyen"] = "Trái tuyến";
break;
case "1":
drv["IsDungTuyen"] = "Đúng tuyến";
break;
default:
drv["IsDungTuyen"] = "Khác";
break;
}
}
//THU_VIEN_CHUNG.CreateXML(m_dataCT, @"Xml4Reports\BHYT05A_CT.xml");
m_dataCT.AcceptChanges();
Utility.SetDataSourceForDataGridEx(grdListCT, m_dataCT, true, true, "1=1", "");
}
catch (Exception ex)
{
Utility.CatchException(ex);
}
}
void LoadCT()
{
try
{
m_dataCT =
new BAOCAO_BHYT().BHYT_25A_CT(dtpFromDate.Value, dtpToDate.Value,
"BHYT", -1, Utility.Int32Dbnull(cboTuyen.SelectedIndex - 1, -1),
cboKieuBaoCao.SelectedIndex == 0?"25a":"25d",
globalVariables.gv_strNoiDKKCBBD, -1);
UpdateDataAlterLoad();
if (!m_dataCT.Columns.Contains("IsDungTuyen"))
{
m_dataCT.Columns.Add("IsDungTuyen", typeof(string));
}
THU_VIEN_CHUNG.CreateXML(m_dataCT, "BHYT25A_CT.xml");
foreach (DataRow drv in m_dataCT.Rows)
{
switch (drv["dung_tuyen"].ToString())
{
case "0":
drv["IsDungTuyen"] = "Trái tuyến";
break;
case "1":
drv["IsDungTuyen"] = "Đúng tuyến";
break;
default:
drv["IsDungTuyen"] = "Khác";
break;
}
}
m_dataCT.AcceptChanges();
Utility.SetDataSourceForDataGridEx(grdListCT, m_dataCT, true, true, "1=1", "");
}
catch (Exception ex)
{
Utility.CatchException(ex);
}
}
public static void InphieuXuatkho_2lien(int IDPhieuNhap, string sTitleReport, DateTime NgayIn)
{
try
{
DataTable dataTable = SPs.ThuocLaydulieuinphieuchuyenkho2lien(IDPhieuNhap).GetDataSet().Tables[0];
if (dataTable.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(dataTable, "THANHTIEN_XUAT");
THU_VIEN_CHUNG.CreateXML(dataTable, "thuoc_phieu_xuatkho_2lien.xml");
string tieude = "", reportname = "", reportCode = "";
reportCode = THU_VIEN_CHUNG.Laygiatrithamsohethong("THUOC_INPHIEUXUATKHO_2LIEN", "0", false) == "1"
? "thuoc_phieu_xuatkho_2lien"
: "thuoc_phieu_xuatkho_1lien";
var crpt = Utility.GetReport(reportCode, ref tieude, ref reportname);
if (crpt != null)
{
frmPrintPreview objForm = new frmPrintPreview(sTitleReport, crpt, true, true);
Utility.UpdateLogotoDatatable(ref dataTable);
crpt.SetDataSource(dataTable);
objForm.mv_sReportFileName = Path.GetFileName(reportname);
objForm.mv_sReportCode = reportCode;
Utility.SetParameterValue(crpt, "BranchName", globalVariables.Branch_Name);
Utility.SetParameterValue(crpt, "ParentBranchName", globalVariables.ParentBranch_Name);
Utility.SetParameterValue(crpt, "sTitleReport", sTitleReport);
Utility.SetParameterValue(crpt, "sMoneyLetter", _moneyByLetter.sMoneyToLetter(tinhtong));
Utility.SetParameterValue(crpt, "sCurrentDate", Utility.FormatDateTime(globalVariables.SysDate));
Utility.SetParameterValue(crpt, "txtTrinhky", Utility.getTrinhky(objForm.mv_sReportFileName, globalVariables.SysDate));
objForm.crptViewer.ReportSource = crpt;
objForm.ShowDialog();
}
}
catch (Exception ex)
{
Utility.ShowMsg("Lỗi khi in báo cáo InphieuXuatkho_2lien()-->\n" + ex.Message);
return;
}
}
void LoadTH()
{
try
{
m_dataTH =
new BAOCAO_BHYT().BHYT_05A_TH(dtpFromDate.Value, dtpToDate.Value,
"BHYT",
cboNhom.SelectedValue.ToString(), Utility.Int32Dbnull(cboTuyen.SelectedValue, -1),
txtTPCode.Text,
-1);
THU_VIEN_CHUNG.CreateXML(m_dataTH, "BHYT05A_TH.xml");
m_dataTH.AcceptChanges();
//THU_VIEN_CHUNG.CreateXML(m_dataTH, @"Xml4Reports\BHYT05A_TH.xml");
Utility.SetDataSourceForDataGridEx(grdListTH, m_dataTH, true, true, "1=1", "");
}
catch (Exception ex)
{
Utility.CatchException(ex);
}
}
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());
}
}
}
private void InMauChuyenKhoa(string maLuotkham, long idBenhnhan)
{
try
{
DataTable _dtInphieu = _KCB_THAMKHAM.InMauPhieuChuyenKhoa(maLuotkham, idBenhnhan).Tables[0];
THU_VIEN_CHUNG.CreateXML(_dtInphieu, "thamkham_phieukham_chuyenkhoa.xml");
string reportcode = "";
if (radkhamchuyenkhoa.Checked)
{
reportcode = "PHIEUKHAM_CHUYENKHOA";
}
else
{
reportcode = "PHIEUKHAM_BENHPHAM";
}
KcbInphieu.INMAU_CHUYENKHAM_CHUYENKHOA(_dtInphieu, "PHIẾU KHÁM CHUYÊN KHOA", reportcode, txtLydo.Text);
}
catch (Exception ex)
{
Utility.ShowMsg("Lỗi:" + ex.Message);
}
}
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());
}
}
}
/// <summary>
/// hàm thực hiện in phiếu báo cáo
/// thông tin
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void cmdBaoCao_Click(object sender, EventArgs e)
{
try
{
int trangthai = Trangthai();
int kieungaytimkiem = chkKieungaytimkiem.Checked ? 1 : 0;
DataTable m_dtReport =
BAOCAO_THUOC.ThuocBaocaoTinhhinhnhapkhothuoc(chkByDate.Checked ? dtFromDate.Value.ToString("dd/MM/yyyy") : "01/01/1900",
chkByDate.Checked ? dtToDate.Value.ToString("dd/MM/yyyy") : "01/01/1900", trangthai,
Utility.Int32Dbnull(cboKho.SelectedValue), Utility.Int32Dbnull(txtthuoc.MyID, -1), (byte)LoaiPhieu.PhieuThanhly, kieungaytimkiem, Utility.DoTrim(txtLydothanhly.Text), "-1", KIEU_THUOC_VT);
THU_VIEN_CHUNG.CreateXML(m_dtReport, "thuoc_baocaochitiet_nhapkho.xml");
Utility.SetDataSourceForDataGridEx(grdList, m_dtReport, true, true, "1=1", "");
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 FromDateToDate = Utility.FromToDateTime(dtFromDate.Text, dtToDate.Text);
thuoc_baocao.BaocaoThanhlythuoc(m_dtReport, KIEU_THUOC_VT == "THUOC"?"thuoc_baocao_thanhly":"vt_baocao_thanhly", baocaO_TIEUDE1.TIEUDE, dtNgayIn.Value, FromDateToDate);
}
catch (Exception)
{
}
}
private void PrintReport(bool view)
{
try
{
prgBar.Visible = true;
if (m_dataTH != null)
{
string reportcode;
if (chktuyen.Checked)
{
reportcode = "BHYT_21A_PHANTUYEN";
}
else
{
reportcode = "BHYT_21A";
}
if (m_dataTH.Rows.Count <= 0 || m_dataTH.Columns.Count <= 0)
{
return;
}
string tieude = "", reportname = "";
ReportDocument crpt = Utility.GetReport(reportcode, ref tieude, ref reportname);
if (crpt == null)
{
return;
}
var objForm = new frmPrintPreview(Utility.DoTrim(baocaO_TIEUDE1.TIEUDE), crpt, true, true);
if (m_dataTH.Rows.Count <= 0)
{
return;
}
Utility.UpdateLogotoDatatable(ref m_dataTH);
THU_VIEN_CHUNG.CreateXML(m_dataTH, string.Format("{0}.xml", reportcode));
crpt.SetDataSource(m_dataTH);
objForm.mv_sReportFileName = Path.GetFileName(reportname);
objForm.mv_sReportCode = reportcode;
Utility.SetParameterValue(crpt, "ParentBranchName", globalVariables.ParentBranch_Name);
Utility.SetParameterValue(crpt, "BranchName", globalVariables.Branch_Name);
Utility.SetParameterValue(crpt, "ReportCondition", GetReportCondition());
Utility.SetParameterValue(crpt, "NTN", Utility.FormatDateTimeWithThanhPho(dtpNgayIn.Value));
Utility.SetParameterValue(crpt, "sBangChu", new MoneyByLetter().sMoneyToLetter(SumOfTotal(m_dataTH)));
Utility.SetParameterValue(crpt, "sTitleReport", baocaO_TIEUDE1.TIEUDE);
objForm.crptViewer.ReportSource = crpt;
if (view)
{
objForm.ShowDialog();
}
else
{
crpt.PrintOptions.PaperSize = PaperSize.PaperA4;
crpt.PrintOptions.PaperOrientation = PaperOrientation.Landscape;
crpt.PrintToPrinter(1, false, 1, 1);
}
prgBar.Visible = false;
}
}
catch (Exception ex)
{
log.Error("Loi trong qua trinh in bao cao : (0)", ex);
prgBar.Visible = false;
}
}
/// <summary>
/// hàm thực hiện in phiếu báo cáo
/// thông tin
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void cmdBaoCao_Click(object sender, EventArgs e)
{
try
{
string nhomthuoc = "-1";
if (Utility.Int32Dbnull(txtKho.MyID, -1) < 0)
{
Utility.ShowMsg("Bạn phải chọn Kho thuốc");
txtKho.Focus();
return;
}
nhomthuoc = txtLoaithuoc.MyID.ToString();
DataTable m_dtReport = null;
string fromdate = "01/01/1900";
string todate = "01/01/1900";
string _value = "1";
if (optThang.Checked)
{
if (cboThang.SelectedIndex < 0)
{
Utility.ShowMsg("Bạn phải chọn Tháng báo cáo");
cboThang.Focus();
return;
}
_value = cboThang.SelectedValue.ToString();
switch (_value)
{
case "2":
fromdate = new DateTime(dtpNam.Value.Year, Utility.Int32Dbnull(_value, 2), 1).ToString("dd/MM/yyyy");
todate = new DateTime(dtpNam.Value.Year, Utility.Int32Dbnull(_value, 2), 29).ToString("dd/MM/yyyy");
break;
case "4":
case "6":
case "9":
case "11":
fromdate = new DateTime(dtpNam.Value.Year, Utility.Int32Dbnull(_value, 2), 1).ToString("dd/MM/yyyy");
todate = new DateTime(dtpNam.Value.Year, Utility.Int32Dbnull(_value, 2), 30).ToString("dd/MM/yyyy");
break;
default:
fromdate = new DateTime(dtpNam.Value.Year, Utility.Int32Dbnull(_value, 2), 1).ToString("dd/MM/yyyy");
todate = new DateTime(dtpNam.Value.Year, Utility.Int32Dbnull(_value, 2), 31).ToString("dd/MM/yyyy");
break;
}
}
else if (optQuy.Checked)
{
if (cboQuy.SelectedIndex < 0)
{
Utility.ShowMsg("Bạn phải chọn Quý báo cáo");
cboQuy.Focus();
return;
}
_value = cboQuy.SelectedValue.ToString();
switch (_value)
{
case "1":
fromdate = new DateTime(dtpNam.Value.Year, 1, 1).ToString("dd/MM/yyyy");
todate = new DateTime(dtpNam.Value.Year, 3, 31).ToString("dd/MM/yyyy");
break;
case "2":
fromdate = new DateTime(dtpNam.Value.Year, 4, 1).ToString("dd/MM/yyyy");
todate = new DateTime(dtpNam.Value.Year, 6, 30).ToString("dd/MM/yyyy");
break;
case "3":
fromdate = new DateTime(dtpNam.Value.Year, 7, 1).ToString("dd/MM/yyyy");
todate = new DateTime(dtpNam.Value.Year, 9, 30).ToString("dd/MM/yyyy");
break;
case "4":
fromdate = new DateTime(dtpNam.Value.Year, 10, 1).ToString("dd/MM/yyyy");
todate = new DateTime(dtpNam.Value.Year, 12, 31).ToString("dd/MM/yyyy");
break;
default:
fromdate = new DateTime(dtpNam.Value.Year, 1, 1).ToString("dd/MM/yyyy");
todate = new DateTime(dtpNam.Value.Year, 12, 31).ToString("dd/MM/yyyy");
break;
}
}
else if (optNam.Checked)
{
fromdate = new DateTime(dtpNam.Value.Year, 1, 1).ToString("dd/MM/yyyy");
todate = new DateTime(dtpNam.Value.Year, 12, 31).ToString("dd/MM/yyyy");
}
else
{
fromdate = dtFromDate.Value.ToString("dd/MM/yyyy");
todate = dtToDate.Value.ToString("dd/MM/yyyy");
}
byte kieubiendong = (byte)cboKieutonghop.SelectedIndex;
string xmlFile = "ThuocBaocaophatsinhTonghop.xml";
if (cboKieubangke.SelectedIndex == 0)
{
xmlFile = "ThuocBaocaophatsinhChitiet.xml";
m_dtReport = BAOCAO_THUOC.ThuocBaocaophatsinhChitiet(fromdate, todate,
Utility.Int32Dbnull(txtKho.MyID), Utility.Int32Dbnull(txtthuoc.MyID, -1), kieubiendong,
nhomthuoc, 1, Utility.Int32Dbnull(txtKhoXuat.MyID, -1));
}
else
{
xmlFile = "ThuocBaocaophatsinhTonghop.xml";
m_dtReport = BAOCAO_THUOC.ThuocBaocaophatsinhTonghop(fromdate, todate,
Utility.Int32Dbnull(txtKho.MyID), Utility.Int32Dbnull(txtthuoc.MyID, -1), kieubiendong,
nhomthuoc, 1, Utility.Int32Dbnull(txtKhoXuat.MyID, -1));
}
THU_VIEN_CHUNG.CreateXML(m_dtReport, xmlFile);
Utility.SetDataSourceForDataGridEx(cboKieutonghop.SelectedIndex == 0?grdTonghop: grdChitiet, m_dtReport, true, true, "1=1", "");
if (m_dtReport == null || m_dtReport.Rows.Count <= 0)
{
Utility.ShowMsg("Không tìm thấy dữ liệu báo cáo", "Thông báo");
return;
}
string FromDateToDate = Utility.FromToDateTime(dtFromDate.Text, dtToDate.Text);
thuoc_baocao.ThuocBaocaophatsinh(m_dtReport, baocaO_TIEUDE1.MA_BAOCAO, baocaO_TIEUDE1.TIEUDE,
dtNgayIn.Value, FromDateToDate,
Utility.sDbnull(txtKho.Text));
}
catch (Exception ex)
{
Utility.ShowMsg(ex.Message);
}
}
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);
}
}
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 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)
{
}
}
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);
}
}
/// <summary>
/// hàm thực hiện in phiếu báo cáo
/// thông tin
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void cmdBaoCao_Click(object sender, EventArgs e)
{
try
{
string nhomthuoc = "-1";
nhomthuoc = txtLoaithuoc.MyID.ToString();
string fromdate = "01/01/2000";
string todate = "01/01/2000";
string _value = "1";
string _tondau = "Tồn đầu";
string _toncuoi = "Tồn cuối";
string FromDateToDate = Utility.FromToDateTime(dtFromDate.Text, dtToDate.Text);
if (optThang.Checked)
{
if (cboThang.SelectedIndex < 0)
{
Utility.ShowMsg("Bạn phải chọn Tháng báo cáo");
cboThang.Focus();
return;
}
_value = cboThang.SelectedValue.ToString();
_tondau = "Tồn đầu tháng " + _value;
_toncuoi = "Tồn cuối tháng " + _value;
FromDateToDate = "Tháng " + _value;
switch (_value)
{
case "2":
fromdate = new DateTime(dtpNam.Value.Year, Utility.Int32Dbnull(_value, 2), 1).ToString("dd/MM/yyyy");
todate = new DateTime(dtpNam.Value.Year, Utility.Int32Dbnull(_value, 2), 29).ToString("dd/MM/yyyy");
break;
case "4":
case "6":
case "9":
case "11":
fromdate = new DateTime(dtpNam.Value.Year, Utility.Int32Dbnull(_value, 2), 1).ToString("dd/MM/yyyy");
todate = new DateTime(dtpNam.Value.Year, Utility.Int32Dbnull(_value, 2), 30).ToString("dd/MM/yyyy");
break;
default:
fromdate = new DateTime(dtpNam.Value.Year, Utility.Int32Dbnull(_value, 2), 1).ToString("dd/MM/yyyy");
todate = new DateTime(dtpNam.Value.Year, Utility.Int32Dbnull(_value, 2), 31).ToString("dd/MM/yyyy");
break;
}
}
else if (optQuy.Checked)
{
if (cboQuy.SelectedIndex < 0)
{
Utility.ShowMsg("Bạn phải chọn Quý báo cáo");
cboQuy.Focus();
return;
}
_value = cboQuy.SelectedValue.ToString();
_tondau = "Tồn đầu quý " + _value;
_toncuoi = "Tồn cuối quý " + _value;
FromDateToDate = "Quý " + _value;
switch (_value)
{
case "1":
fromdate = new DateTime(dtpNam.Value.Year, 1, 1).ToString("dd/MM/yyyy");
todate = new DateTime(dtpNam.Value.Year, 3, 31).ToString("dd/MM/yyyy");
break;
case "2":
fromdate = new DateTime(dtpNam.Value.Year, 4, 1).ToString("dd/MM/yyyy");
todate = new DateTime(dtpNam.Value.Year, 6, 30).ToString("dd/MM/yyyy");
break;
case "3":
fromdate = new DateTime(dtpNam.Value.Year, 7, 1).ToString("dd/MM/yyyy");
todate = new DateTime(dtpNam.Value.Year, 9, 30).ToString("dd/MM/yyyy");
break;
case "4":
fromdate = new DateTime(dtpNam.Value.Year, 10, 1).ToString("dd/MM/yyyy");
todate = new DateTime(dtpNam.Value.Year, 12, 31).ToString("dd/MM/yyyy");
break;
default:
fromdate = new DateTime(dtpNam.Value.Year, 1, 1).ToString("dd/MM/yyyy");
todate = new DateTime(dtpNam.Value.Year, 12, 31).ToString("dd/MM/yyyy");
break;
}
}
else if (optNam.Checked)
{
FromDateToDate = "Năm " + dtpNam.Value.Year.ToString();
_tondau = "Tồn " + dtpNam.Value.AddYears(-1).Year.ToString();
_toncuoi = "Tồn " + dtpNam.Value.Year.ToString();
fromdate = new DateTime(dtpNam.Value.Year, 1, 1).ToString("dd/MM/yyyy");
todate = new DateTime(dtpNam.Value.Year, 12, 31).ToString("dd/MM/yyyy");
}
else
{
_tondau = "Tồn đầu " + dtFromDate.Value.ToString("dd/MM/yyyy");
_toncuoi = "Tồn cuối " + dtToDate.Value.ToString("dd/MM/yyyy");
fromdate = dtFromDate.Value.ToString("dd/MM/yyyy");
todate = dtToDate.Value.ToString("dd/MM/yyyy");
}
DataTable m_dtReport = null;
m_dtReport = BAOCAO_THUOC.ThuocBaocaonhapxuatthuoc(fromdate,
todate,
lstStockID, nhomthuoc, Utility.Int32Dbnull(txtthuoc.MyID, -1), chkBiendong.Checked ? 1 : 0);
Utility.SetDataSourceForDataGridEx(grdList, m_dtReport, true, true, "1=1", "");
THU_VIEN_CHUNG.CreateXML(m_dtReport, "baocao_nhapxuatthuoc.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;
}
thuoc_baocao.BaocaoNhapxuatThuoc(m_dtReport, cboReportType.SelectedValue.ToString(), KIEU_THUOC_VT, baocaO_TIEUDE1.TIEUDE, _tondau, _toncuoi,
dtNgayIn.Value, FromDateToDate,
Utility.sDbnull(cboKho.Text), chkTheoNhomThuoc.Checked);
}
catch (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.ThuocBaocaoTinhhinhBenhnhanlinhthuoc(
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"));
Utility.SetDataSourceForDataGridEx(grdList, m_dtReport, false, true, "1=1", "");
Janus.Windows.GridEX.GridEXColumn gridExColumn = grdList.RootTable.Columns["THANH_TIEN"];
decimal tonghuy = Utility.DecimaltoDbnull(grdList.GetTotal(gridExColumn, Janus.Windows.GridEX.AggregateFunction.Sum));
THU_VIEN_CHUNG.CreateXML(m_dtReport, "thuoc_baocao_danhsachBenhnhan_linhthuoc");
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_danhsachBenhnhan_linhthuoc" : "vt_baocao_danhsachBenhnhan_linhvt";
ReportDocument crpt = Utility.GetReport(reportCode, ref tieude, ref reportname);
if (crpt == null)
{
return;
}
frmPrintPreview objForm = new frmPrintPreview(baocaO_TIEUDE1.TIEUDE, 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", baocaO_TIEUDE1.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();
}
catch (Exception exception)
{
}
}