示例#1
0
        public static void InphieuChidinhCLS(int id_benhnhan,string ma_luotkham, int v_AssignId, string v_AssignCode,string  nhomincls,int selectedIndex, bool inTach ,ref string mayin)
        {
            try
            {
                mayin = "";
                KcbChidinhcl objAssignInfo = KcbChidinhcl.FetchByID(v_AssignId);

                DataTable dt = new KCB_THAMKHAM().KcbThamkhamLaydulieuInphieuCls(id_benhnhan, ma_luotkham, v_AssignCode, nhomincls).Tables[0];
                if (dt == null || dt.Rows.Count <= 0)
                {
                    Utility.ShowMsg("Không có dữ liệu in. Mời bạn kiểm tra lại");
                    return;
                }
                THU_VIEN_CHUNG.CreateXML(dt,"Thamkham_InphieuCLS.XML");
                Utility.UpdateLogotoDatatable(ref dt);
                Utility.CreateBarcodeData(ref dt, v_AssignCode);

                var crpt = new ReportDocument();
                string KhoGiay = "A5";
                bool inchung = false;
                string tieude = "", reportname = "";
                if (PropertyLib._MayInProperties.CoGiayInCLS == Papersize.A4) KhoGiay = "A4";
                if (KhoGiay == "A5")
                    if (inTach && selectedIndex == 0)//Nếu in riêng mà chọn tất
                        crpt = Utility.GetReport("thamkham_InphieuchidinhCLS_RIENG_A5", ref tieude, ref reportname);
                    else
                    {
                        inchung = true;
                        crpt = Utility.GetReport("thamkham_InphieuchidinhCLS_A5", ref tieude, ref reportname);
                    }
                else//Khổ giấy A4
                    if (inTach && selectedIndex == 0)//Nếu in riêng mà chọn tất-->Gọi báo cáo nhóm theo nhóm in
                        crpt = Utility.GetReport("thamkham_InphieuchidinhCLS_RIENG_A4", ref tieude, ref reportname);
                    else
                    {
                        inchung = true;
                        crpt = Utility.GetReport("thamkham_InphieuchidinhCLS_A4", ref tieude, ref reportname);
                    }

                if (crpt == null) return;
                if (inchung)
                {
                    List<string> lstNhominCLS = (from p in dt.AsEnumerable()
                                                 where Utility.DoTrim(Utility.sDbnull(p.Field<string>("nhom_in_cls"))) != ""
                                                 select p.Field<string>("nhom_in_cls")
                                               ).Distinct().ToList<string>();
                    if (lstNhominCLS.Count > 1)
                    {
                        string tenphieuchidinh = THU_VIEN_CHUNG.Laygiatrithamsohethong("CLS_TENPHIEU_INCHUNG", "PHIẾU CHỈ ĐỊNH CẬN LÂM SÀNG", true); ;
                        foreach (DataRow dr in dt.Rows)
                            dr["ten_nhominphieucls"] = tenphieuchidinh;
                    }
                }
                var objForm = new frmPrintPreview("IN PHIẾU CHỈ ĐỊNH", crpt, true, true);
                try
                {
                    crpt.SetDataSource(dt);
                    //crpt.DataDefinition.FormulaFields["Formula_1"].Text = Strings.Chr(34) + "    Nhân viên        Bác sĩ chỉ định     ".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);
                    if (!inTach && selectedIndex == 0)
                    {
                        foreach (DataRow dr in dt.Rows)
                            dr[VKcbChidinhcl.Columns.TenNhominphieucls] = THU_VIEN_CHUNG.Laygiatrithamsohethong("TIEUDE_PHIEUCHIDNHCLS_INCHUNG", "PHIẾU CHỈ ĐỊNH", true);
                    }
                    else
                    {
                        Utility.SetParameterValue(crpt, "TitleReport", tieude);
                    }
                    Utility.SetParameterValue(crpt, "CurrentDate", Utility.FormatDateTimeWithLocation(globalVariables.SysDate, globalVariables.gv_strDiadiem));
                    objForm.crptViewer.ReportSource = crpt;
                    if (Utility.isPrintPreview(PropertyLib._MayInProperties.TenMayInBienlai, PropertyLib._MayInProperties.PreviewInCLS))
                    {
                        objForm.SetDefaultPrinter(PropertyLib._MayInProperties.TenMayInBienlai, 0);
                        objForm.ShowDialog();
                        mayin = PropertyLib._MayInProperties.TenMayInBienlai;
                    }
                    else
                    {
                        objForm.addTrinhKy_OnFormLoad();
                        crpt.PrintOptions.PrinterName = PropertyLib._MayInProperties.TenMayInBienlai;
                        mayin = PropertyLib._MayInProperties.TenMayInBienlai;
                        crpt.PrintToPrinter(1, false, 0, 0);
                    }
                }
                catch (Exception ex)
                {
                   // Utility.DefaultNow(this);
                }

            }
            catch
            {
            }
        }
        private void IN_HOADON()
        {
            string LyDoIn = "0";
            try
            {
                if (!Utility.isValidGrid(grdPayment))
                    return;
                int payment_ID = Utility.Int32Dbnull(grdPayment.GetValue(KcbThanhtoan.Columns.IdThanhtoan), -1);

                try
                {
                    dtPatientPayment = _THANHTOAN.Laythongtinhoadondo(payment_ID);
                    dtPatientPayment.Rows[0]["sotien_bangchu"] =
                        new MoneyByLetter().sMoneyToLetter(Utility.sDbnull(dtPatientPayment.Rows[0]["TONG_TIEN"]));
                    int lengh = txtSerieDau.Text.Length;
                    string tieude="", reportname = "";
                    ReportDocument report = Utility.GetReport("thanhtoan_Hoadondo",ref tieude,ref reportname);
                    if (report == null) return;
                    frmPrintPreview objForm = new frmPrintPreview("", report, true, true);
                    objForm.mv_sReportFileName = Path.GetFileName(reportname);
                    objForm.mv_sReportCode = "thanhtoan_Hoadondo";
                    report.PrintOptions.PrinterName = cbomayinhoadon.Text;
                    report.SetDataSource(dtPatientPayment);
                    report.SetParameterValue("NGUOIIN", Utility.sDbnull(globalVariables.gv_strTenNhanvien, ""));

                    report.SetParameterValue("ParentBranchName", globalVariables.ParentBranch_Name);
                    report.SetParameterValue("BranchName", globalVariables.Branch_Name);
                    report.SetParameterValue("DateTime", Utility.FormatDateTime(globalVariables.SysDate));
                    report.SetParameterValue("CurrentDate", Utility.FormatDateTime(globalVariables.SysDate));
                    report.SetParameterValue("sTitleReport", tieude);
                    //report.SetParameterValue("CharacterMoney", new MoneyByLetter().sMoneyToLetter(TONG_TIEN.ToString()));
                    objForm.crptViewer.ReportSource = report;

                    if (Utility.isPrintPreview(PropertyLib._MayInProperties.TenMayInHoadon, PropertyLib._MayInProperties.PreviewInHoadon))
                    {
                        objForm.SetDefaultPrinter(PropertyLib._MayInProperties.TenMayInHoadon, 1);
                        objForm.ShowDialog();
                    }
                    else
                    {
                        report.PrintOptions.PrinterName = PropertyLib._MayInProperties.TenMayInHoadon;
                        report.PrintToPrinter(1,false, 0, 0);
                    }
                }
                catch (Exception ex1)
                {
                    Utility.ShowMsg("Lỗi khi thực hiện in hóa đơn mẫu. Liên hệ IT để được trợ giúp-->" +
                                    ex1.Message);
                }
            }
            catch (Exception ex)
            {
                Utility.ShowMsg(ex.Message);
            }
        }
示例#3
0
        public static void InPhieuKCB_DV(DataTable m_dtReport, string sTitleReport,string KhoGiay)
        {
            ReportDocument reportDocument=new ReportDocument();
             string tieude="", reportname = "";
            switch (KhoGiay)
            {
                case "A4":
                    reportDocument =Utility.GetReport("tiepdon_PhieuKCB_Dvu_A4",ref tieude,ref reportname);
                    break;
                case "A5":
                    reportDocument = Utility.GetReport("tiepdon_PhieuKCB_Dvu_A5" ,ref tieude,ref reportname);
                    break;

            }
            if (reportDocument == null) return;

            var crpt = reportDocument;
            var objForm = new frmPrintPreview(sTitleReport, crpt, true, m_dtReport.Rows.Count <= 0 ? false : true);
            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);
                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", sTitleReport);
                Utility.SetParameterValue(crpt,"BottomCondition", THU_VIEN_CHUNG.BottomCondition());
                objForm.crptViewer.ReportSource = crpt;
                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.TenMayInPhieuKCB;
                    crpt.PrintToPrinter(1, false, 0, 0);
                }

            }
            catch (Exception ex)
            {
                Utility.ShowMsg(ex.ToString());
            }
        }
        private void PrintPres(int PresID)
        {
            DataTable v_dtData =new  KCB_KEDONTHUOC().LaythongtinDonthuoc_In(PresID);
            Utility.AddColumToDataTable(ref v_dtData, "BarCode", typeof(byte[]));
            //barcode.Data = Utility.sDbnull(Pres_ID);
            byte[] Barcode = Utility.GenerateBarCode(barcode);
            string ICD_Name = "";
            string ICD_Code = "";

            foreach (DataRow drv in v_dtData.Rows)
            {
                drv["BarCode"] = Barcode;
                drv["chan_doan"] ="";
                drv["ma_icd"] = "";
            }
            THU_VIEN_CHUNG.CreateXML(v_dtData, "thamkham_InDonthuocA4.xml");
            v_dtData.AcceptChanges();
            // log.Info("Thuc hien in don thuoc");
            Utility.UpdateLogotoDatatable(ref v_dtData);
            string KhoGiay = "A5";
            if (PropertyLib._MayInProperties.CoGiayInDonthuoc == Papersize.A4) KhoGiay = "A4";
            ReportDocument reportDocument = new ReportDocument();
            string tieude = "", reportname = "",reportCode="";
            switch (KhoGiay)
            {
                case "A5":
                    reportCode = "quaythuoc_InDonthuocA5";
                    reportDocument = Utility.GetReport("quaythuoc_InDonthuocA5", ref tieude, ref reportname);
                    break;
                case "A4":
                    reportCode = "quaythuoc_InDonthuocA4";
                    reportDocument = Utility.GetReport("quaythuoc_InDonthuocA4", ref tieude, ref reportname);
                    break;
                default:
                    reportCode = "quaythuoc_InDonthuocA4";
                    reportDocument = Utility.GetReport("quaythuoc_InDonthuocA4", ref tieude, ref reportname);
                    break;
            }
            if (reportDocument == null) return;
            //v_dtData.AcceptChanges();
            Utility.WaitNow(this);
            ReportDocument crpt = reportDocument;
            var objForm = new frmPrintPreview("IN ĐƠN THUỐC BỆNH NHÂN", crpt, true, true);
            try
            {
                objForm.mv_sReportFileName = Path.GetFileName(reportname);
                objForm.mv_sReportCode = reportCode;
                crpt.SetDataSource(v_dtData);
                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, "ReportTitle", tieude);
                Utility.SetParameterValue(crpt, "CurrentDate", Utility.FormatDateTime(globalVariables.SysDate));
                Utility.SetParameterValue(crpt, "BottomCondition", THU_VIEN_CHUNG.BottomCondition());
                objForm.crptViewer.ReportSource = crpt;
                if (Utility.isPrintPreview(PropertyLib._MayInProperties.TenMayInBienlai, PropertyLib._MayInProperties.PreviewInDonthuoc))
                {
                    objForm.SetDefaultPrinter(PropertyLib._MayInProperties.TenMayInBienlai, 0);
                    objForm.ShowDialog();
                    cbomayinphoiBHYT.Text = PropertyLib._MayInProperties.TenMayInBienlai;
                }
                else
                {
                    objForm.addTrinhKy_OnFormLoad();
                    crpt.PrintOptions.PrinterName = PropertyLib._MayInProperties.TenMayInBienlai;
                    crpt.PrintToPrinter(1, false, 0, 0);
                }
                Utility.DefaultNow(this);
            }
            catch (Exception ex)
            {
                Utility.DefaultNow(this);
            }
        }
 private void PrintPres(int PresID)
 {
     try
     {
         DataTable dataTable = this._KEDONTHUOC.LaythongtinDonthuoc_In(PresID);
         if (dataTable.Rows.Count <= 0)
         {
             Utility.ShowMsg("không tìm  thấy thuốc, Có thể bạn chưa lưu được thuốc, \nMời bạn kiểm tra lại", "thông báo", MessageBoxIcon.Exclamation);
             return;
         }
         Utility.AddColumToDataTable(ref dataTable, "BarCode", typeof(byte[]));
         THU_VIEN_CHUNG.CreateXML(dataTable, "thamkham_InDonthuocA4.xml");
         this.barcode.Data = Utility.sDbnull(this.txtPres_ID.Text);
         byte[] buffer = Utility.GenerateBarCode(this.barcode);
         string str = "";
         string str2 = "";
         if ((dataTable != null) && (dataTable.Rows.Count > 0))
         {
         }
         foreach (DataRow row in dataTable.Rows)
         {
             row["BarCode"] = buffer;
             row["chan_doan"] = (Utility.sDbnull(row["chan_doan"]).Trim() == "") ? str : (Utility.sDbnull(row["chan_doan"]) + ";" + str);
             row["ma_icd"] = str2;
         }
         dataTable.AcceptChanges();
         Utility.UpdateLogotoDatatable(ref dataTable);
         string str3 = "A5";
         if (PropertyLib._MayInProperties.CoGiayInDonthuoc == Papersize.A4)
         {
             str3 = "A4";
         }
         ReportDocument document = new ReportDocument();
         string tieude = "";
         string fileName = "";
         string str6 = str3;
         if (str6 != null)
         {
             if (!(str6 == "A5"))
             {
                 if (str6 == "A4")
                 {
                     document = Utility.GetReport("thamkham_InDonthuocA4", ref tieude, ref fileName);
                     goto Label_0252;
                 }
             }
             else
             {
                 document = Utility.GetReport("thamkham_InDonthuocA5", ref tieude, ref fileName);
                 goto Label_0252;
             }
         }
         document = Utility.GetReport("thamkham_InDonthuocA5", ref tieude, ref fileName);
     Label_0252:
         if (document != null)
         {
             Utility.WaitNow(this);
             ReportDocument rptDoc = document;
             frmPrintPreview preview = new frmPrintPreview("IN ĐƠN THUỐC BỆNH NH\x00c2N", rptDoc, true, true);
             try
             {
                 rptDoc.SetDataSource(dataTable);
                 Utility.SetParameterValue(rptDoc, "ParentBranchName", globalVariables.ParentBranch_Name);
                 Utility.SetParameterValue(rptDoc, "BranchName", globalVariables.Branch_Name);
                 Utility.SetParameterValue(rptDoc, "Address", globalVariables.Branch_Address);
                 Utility.SetParameterValue(rptDoc, "Phone", globalVariables.Branch_Phone);
                 Utility.SetParameterValue(rptDoc, "ReportTitle", "ĐƠN THUỐC");
                 Utility.SetParameterValue(rptDoc, "CurrentDate", Utility.FormatDateTime(this.dtNgayIn.Value));
                 Utility.SetParameterValue(rptDoc, "BottomCondition", THU_VIEN_CHUNG.BottomCondition());
                 preview.crptViewer.ReportSource = rptDoc;
                 if (Utility.isPrintPreview(PropertyLib._MayInProperties.TenMayInBienlai, PropertyLib._MayInProperties.PreviewInDonthuoc))
                 {
                     preview.SetDefaultPrinter(PropertyLib._MayInProperties.TenMayInBienlai, 0);
                     preview.ShowDialog();
                     this.cboLaserPrinters.Text = PropertyLib._MayInProperties.TenMayInBienlai;
                 }
                 else
                 {
                     preview.addTrinhKy_OnFormLoad();
                     rptDoc.PrintOptions.PrinterName = PropertyLib._MayInProperties.TenMayInBienlai;
                     rptDoc.PrintToPrinter(1, false, 0, 0);
                 }
                 Utility.DefaultNow(this);
             }
             catch (Exception)
             {
                 Utility.DefaultNow(this);
             }
         }
     }
     catch(Exception ex)
     {
         Utility.CatchException(ex);
     }
 }
示例#6
0
        void PrintReport(bool view)
        {
            try
            {
                if (mdtReport != null)
                {
                    if (mdtReport.Rows.Count <= 0 || mdtReport.Columns.Count <= 0)
                        return;
                    //Báo cáo chi tiết
                     string tieude="", reportname = "";
                    if (optChitiet.Checked == true)
                    {

                        ReportDocument crpt = Utility.GetReport("BHYT_80A_CT" ,ref tieude,ref reportname);
                        if (crpt == null) return;

                        frmPrintPreview objForm =
                            new frmPrintPreview(
                               baocaO_TIEUDE1.txtTieuDe.Text, crpt,
                                true, mdtReport.Rows.Count <= 0 ? false : true);
                        Utility.UpdateLogotoDatatable(ref mdtReport);
                        crpt.SetDataSource(mdtReport);
                        objForm.crptViewer.ReportSource = crpt;
                        objForm.mv_sReportFileName = Path.GetFileName(reportname);
                        objForm.mv_sReportCode = "BHYT_80A_CT";
                        Utility.SetParameterValue(crpt,"ParentBranchName", globalVariables.ParentBranch_Name);
                        Utility.SetParameterValue(crpt,"Address", globalVariables.Branch_Address);
                        Utility.SetParameterValue(crpt,"Telephone", globalVariables.Branch_Phone);
                        Utility.SetParameterValue(crpt,"BranchName", globalVariables.Branch_Name);
                        Utility.SetParameterValue(crpt,"FromDateToDate", dtpFromDate.Value.ToString("dd/MM/yyyy") + " ĐẾN NGÀY " +
                                               dtpToDate.Value.ToString("dd/MM/yyyy"));
                        Utility.SetParameterValue(crpt,"sTitleReport", baocaO_TIEUDE1.txtTieuDe.Text);
                        Utility.SetParameterValue(crpt,"NTN", Utility.FormatDateTimeWithThanhPho(dtCreateDate.Value));
                        Utility.SetParameterValue(crpt,"TongTien", ChuyenDoiSoThanhChu());

                        if (Utility.isPrintPreview(PropertyLib._MayInProperties.TenMayInBienlai, view))
                        {
                            objForm.SetDefaultPrinter(PropertyLib._MayInProperties.TenMayInBienlai, 1);
                            objForm.ShowDialog();
                        }
                        else
                        {
                            crpt.PrintOptions.PrinterName = PropertyLib._MayInProperties.TenMayInBienlai;
                            crpt.PrintToPrinter(1, false, 0, 0);
                        }

                    }
                    //Báo cáo tổng hợp
                    else if (optTonghop.Checked == true)
                    {
                        ReportDocument crpt = Utility.GetReport("BHYT_80A_TH",ref tieude,ref reportname);
                        if (crpt == null) return;
                        frmPrintPreview objForm =
                            new frmPrintPreview(
                                baocaO_TIEUDE1.txtTieuDe.Text, crpt, true, mdtReport.Rows.Count <= 0 ? false : true);
                        Utility.UpdateLogotoDatatable(ref mdtReport);
                        crpt.SetDataSource(mdtReport);
                        objForm.crptViewer.ReportSource = crpt;
                        objForm.mv_sReportFileName = Path.GetFileName(reportname);
                        objForm.mv_sReportCode = "BHYT_80A_TH";
                        Utility.SetParameterValue(crpt,"ParentBranchName", globalVariables.ParentBranch_Name);
                        Utility.SetParameterValue(crpt,"Address", globalVariables.Branch_Address);
                        Utility.SetParameterValue(crpt,"Telephone", globalVariables.Branch_Phone);
                        Utility.SetParameterValue(crpt,"BranchName", globalVariables.Branch_Name);
                        Utility.SetParameterValue(crpt,"FromDateToDate", dtpFromDate.Value.ToString("dd/MM/yyyy") + " ĐẾN NGÀY " +
                                               dtpToDate.Value.ToString("dd/MM/yyyy"));
                        Utility.SetParameterValue(crpt,"sTitleReport", baocaO_TIEUDE1.txtTieuDe.Text);
                        Utility.SetParameterValue(crpt,"NTN", Utility.FormatDateTimeWithThanhPho(dtCreateDate.Value));
                        Utility.SetParameterValue(crpt,"TongTien", ChuyenDoiSoThanhChu());

                        if (Utility.isPrintPreview(PropertyLib._MayInProperties.TenMayInBienlai, view))
                        {
                            objForm.SetDefaultPrinter(PropertyLib._MayInProperties.TenMayInBienlai, 1);
                            objForm.ShowDialog();
                        }
                        else
                        {
                            crpt.PrintOptions.PrinterName = PropertyLib._MayInProperties.TenMayInBienlai;
                            crpt.PrintToPrinter(1, false, 0, 0);
                        }
                    }
                    else
                    {
                        MessageBox.Show("Chọn lựa không chính xác", "THÔNG BÁO", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    }
                }
            }
            catch (Exception ex)
            {
                Utility.ShowMsg(ex.Message);
            }
        }
示例#7
0
        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)
            {
            }
        }
        public void IN_HOADON(int payment_ID)
        {
            string LyDoIn = "0";
               try
               {
               DataTable dtPatientPayment = new KCB_THANHTOAN().Laythongtinhoadondo(payment_ID);
               dtPatientPayment.Rows[0]["sotien_bangchu"] =
                   new MoneyByLetter().sMoneyToLetter(Utility.sDbnull(dtPatientPayment.Rows[0]["TONG_TIEN"]));
               string tieude = "", reportname = "";
               ReportDocument report = Utility.GetReport("thanhtoan_Hoadondo", ref tieude, ref reportname);
               if (report == null) return;
               var objForm = new frmPrintPreview("", report, true, true);
               //objForm.AutoClose = true;
               objForm.mv_sReportFileName = Path.GetFileName(reportname);
               objForm.mv_sReportCode = "thanhtoan_Hoadondo";
               report.SetDataSource(dtPatientPayment);
               Utility.SetParameterValue(report,"NGUOIIN", Utility.sDbnull(globalVariables.gv_strTenNhanvien, ""));

               Utility.SetParameterValue(report,"ParentBranchName", globalVariables.ParentBranch_Name);
               Utility.SetParameterValue(report,"BranchName", globalVariables.Branch_Name);
               Utility.SetParameterValue(report,"DateTime", Utility.FormatDateTime(globalVariables.SysDate));
               Utility.SetParameterValue(report,"CurrentDate", Utility.FormatDateTimeWithLocation(globalVariables.SysDate,globalVariables.gv_strDiadiem));
               Utility.SetParameterValue(report, "sTitleReport", tieude);
               Utility.SetParameterValue(report, "txtTrinhky", Utility.getTrinhky(objForm.mv_sReportFileName,globalVariables.SysDate));
               objForm.crptViewer.ReportSource = report;

               if (Utility.isPrintPreview(PropertyLib._MayInProperties.TenMayInHoadon, PropertyLib._MayInProperties.PreviewInHoadon))
               {
                   objForm.SetDefaultPrinter(PropertyLib._MayInProperties.TenMayInHoadon, 1);
                   objForm.ShowDialog();
               }
               else
               {
                   objForm.addTrinhKy_OnFormLoad();
                   report.PrintOptions.PrinterName = PropertyLib._MayInProperties.TenMayInHoadon;
                   report.PrintToPrinter(1, false, 0, 0);
               }

               }
               catch (Exception ex1)
               {
               Utility.CatchException(ex1);
               }
        }
        private bool IN_TTAT_DTRI_NGOAITRU()
        {
            try
            {
                string ICD_Name = "";
                string ICD_Code = "";
                DataSet dsData = _KCB_THAMKHAM.LaythongtinInphieuTtatDtriNgoaitru(objkcbdangky.IdKham);
                THU_VIEN_CHUNG.CreateXML(dsData);
                string NGAY_KEDON = "";
                string[] arrDate =
                    Utility.sDbnull(
                        dsData.Tables[2].Rows.Count > 0
                            ? dsData.Tables[2].Rows[0]["NGAY_KEDON"]
                            : globalVariables.SysDate.ToString("dd/MM/yyyy"),
                        globalVariables.SysDate.ToString("dd/MM/yyyy")).Split('/');
                NGAY_KEDON = "Ngày " + arrDate[0] + " tháng " + arrDate[1] + " năm " + arrDate[2];
                DataTable v_dtData = dsData.Tables[0];
                DataTable sub_dtData = getChitietCLS();
                THU_VIEN_CHUNG.CreateXML(sub_dtData, "sub_report.xml");
                // new DataTable("Temp");
                if (v_dtData != null && v_dtData.Rows.Count > 0)
                    GetChanDoan(Utility.sDbnull(v_dtData.Rows[0]["ICD_CHINH"], ""),
                                Utility.sDbnull(v_dtData.Rows[0]["ICD_PHU"], ""), ref ICD_Name, ref ICD_Code);
                foreach (DataRow dr in v_dtData.Rows)
                {
                    dr["chan_doan"] = Utility.sDbnull(dr["chan_doan"]).Trim() == ""
                                          ? ICD_Name
                                          : Utility.sDbnull(dr["chan_doan"]) + ";" + ICD_Name;
                    //dr[DmucBenh.Columns.MaBenh] = ICD_Code;
                    dr["ma_icd"] = ICD_Code;
                }
                v_dtData.AcceptChanges();
                v_dtData.AcceptChanges();
                Utility.UpdateLogotoDatatable(ref v_dtData);
                string tieude = "", reportname = "";
                ReportDocument crpt = Utility.GetReport("thamkham_InPhieutomtatdieutringoaitru_A4", ref tieude,
                                                        ref reportname);
                if (PropertyLib._MayInProperties.CoGiayInTomtatDieutriNgoaitru == Papersize.A5)
                    crpt = Utility.GetReport("thamkham_InPhieutomtatdieutringoaitru_A5", ref tieude, ref reportname);
                if (crpt == null) return false;
                var objForm = new frmPrintPreview("PHIẾU TÓM TẮT ĐIỀU TRỊ NGOẠI TRÚ", crpt, true, true);
                crpt.SetDataSource(v_dtData);
                crpt.Subreports[0].SetDataSource(sub_dtData);
                Utility.SetParameterValue(crpt, "ParentBranchName", globalVariables.ParentBranch_Name);
                Utility.SetParameterValue(crpt, "BranchName", globalVariables.Branch_Name);
                Utility.SetParameterValue(crpt, "NGAY_KEDON", NGAY_KEDON);
                objForm.crptViewer.ReportSource = crpt;
                //In ngay
                if (cboPrintPreviewTomtatdieutringoaitru.SelectedValue.ToString() == "1")
                    objForm.addTrinhKy_OnFormLoad();
                if (Utility.isPrintPreview(PropertyLib._MayInProperties.TenMayInBienlai,
                                           PropertyLib._MayInProperties.PreviewInTomtatDieutriNgoaitru))
                {
                    objForm.SetDefaultPrinter(PropertyLib._MayInProperties.TenMayInBienlai, 0, 1);
                    objForm.ShowDialog();
                }
                else
                {
                    crpt.PrintOptions.PrinterName = PropertyLib._MayInProperties.TenMayInBienlai;
                    crpt.PrintToPrinter(2, false, 0, 0);
                }

                List<int> lstKho =
                    dsData.Tables[2].AsEnumerable().Select(c => c.Field<int>("id_kho")).Distinct().ToList();
                foreach (int s in lstKho)
                {
                    DataTable dt = v_dtData.Clone();
                    dt = dsData.Tables[2].Select("id_kho = " + s, "stt_in").CopyToDataTable();
                    foreach (DataRow dr in dt.Rows)
                    {
                        dr["chan_doan"] = Utility.sDbnull(dr["chan_doan"]).Trim() == ""
                                              ? ICD_Name
                                              : Utility.sDbnull(dr["chan_doan"]) + ";" + ICD_Name;
                        //dr[DmucBenh.Columns.MaBenh] = ICD_Code;
                        dr["ma_icd"] = ICD_Code;
                    }
                    dt.AcceptChanges();
                    ReportDocument crpt1 = Utility.GetReport("thamkham_Inphieulinhthuocngoaitru_A4", ref tieude,
                                                             ref reportname);
                    if (PropertyLib._MayInProperties.CoGiayInTomtatDieutriNgoaitru == Papersize.A5)
                        crpt1 = Utility.GetReport("thamkham_Inphieulinhthuocngoaitru_A5", ref tieude, ref reportname);
                    if (crpt1 == null) return false;
                    var objForm1 = new frmPrintPreview("PHIẾU LĨNH THUỐC NGOẠI TRÚ", crpt1, true, true);
                    crpt1.SetDataSource(dt);
                    crpt1.SetParameterValue("ParentBranchName", globalVariables.ParentBranch_Name);
                    crpt1.SetParameterValue("BranchName", globalVariables.Branch_Name);
                    crpt1.SetParameterValue("NGAY_KEDON", NGAY_KEDON);
                    objForm1.crptViewer.ReportSource = crpt1;
                    if (cboPrintPreviewTomtatdieutringoaitru.SelectedValue.ToString() == "1")
                        objForm1.addTrinhKy_OnFormLoad();
                    if (Utility.isPrintPreview(PropertyLib._MayInProperties.TenMayInBienlai,
                                               PropertyLib._MayInProperties.PreviewInTomtatDieutriNgoaitru))
                    {
                        objForm1.SetDefaultPrinter(PropertyLib._MayInProperties.TenMayInBienlai, 0, 2);
                        objForm1.ShowDialog();
                        Utility.DefaultNow(this);
                    }
                    else
                    {
                        crpt1.PrintOptions.PrinterName = PropertyLib._MayInProperties.TenMayInBienlai;
                        crpt1.PrintToPrinter(1, false, 0, 0);
                    }
                }
                return true;
            }
            catch (Exception ex)
            {
                Utility.ShowMsg(ex.Message);
                return false;
            }
        }
        public void INPHOI_BHYT(DataTable m_dtReportPhieuThu,  DateTime ngayIn, KcbLuotkham objPatientExam)
        {
            Utility.UpdateLogotoDatatable(ref m_dtReportPhieuThu);
               THU_VIEN_CHUNG.Sapxepthutuin(ref m_dtReportPhieuThu,true);
               m_dtReportPhieuThu.DefaultView.Sort = "stt_in ,stt_hthi_dichvu,stt_hthi_chitiet,ten_chitietdichvu";
               m_dtReportPhieuThu.AcceptChanges();

            string tieude="", reportname = "";
               var crpt = Utility.GetReport("BHYT_InPhoi" ,ref tieude,ref reportname);
               if (crpt == null) return;
               frmPrintPreview objForm = new frmPrintPreview(tieude, crpt, true, true);
               objForm.NGAY = NGAYINPHIEU;
               try
               {
               objForm.mv_sReportFileName = Path.GetFileName(reportname);
               objForm.mv_sReportCode = "BHYT_InPhoi";
               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,"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,"sMoneyCharacter_Thanhtien",
                                      sMoneyByLetter.sMoneyToLetter(
                                          SumOfTotal_BH(m_dtReportPhieuThu, "TT_KHONG_PHUTHU").ToString()));
               Utility.SetParameterValue(crpt,"sMoneyCharacter_Thanhtien_BH",
                                      sMoneyByLetter.sMoneyToLetter(
                                          SumOfTotal_BH(m_dtReportPhieuThu, "TT_BHYT").ToString()));
               Utility.SetParameterValue(crpt,"sMoneyCharacter_Thanhtien_BN",
                                      sMoneyByLetter.sMoneyToLetter(
                                          SumOfTotal_BH(m_dtReportPhieuThu, "TT_BN").ToString()));
               Utility.SetParameterValue(crpt,"sMoneyCharacter_Thanhtien_Khac",
                                      sMoneyByLetter.sMoneyToLetter(
                                          SumOfTotal_BH(m_dtReportPhieuThu, "TT_PHUTHU").ToString()));
               Utility.SetParameterValue(crpt, "txtTrinhky", Utility.getTrinhky(objForm.mv_sReportFileName, NGAYINPHIEU));
               objForm.crptViewer.ReportSource = crpt;

               if (Utility.isPrintPreview(PropertyLib._MayInProperties.TenMayInBienlai, PropertyLib._MayInProperties.PreviewInPhoiBHYT))
               {
                   objForm.SetDefaultPrinter(PropertyLib._MayInProperties.TenMayInBienlai, 0);
                   if (objForm.ShowDialog() == DialogResult.OK)
                   {
                       //Tự động khóa BN để kết thúc
                       new Update(KcbLuotkham.Schema)
                           .Set(KcbLuotkham.Columns.NgayKetthuc).EqualTo(globalVariables.SysDate)
                           .Set(KcbLuotkham.Columns.NguoiKetthuc).EqualTo(globalVariables.UserName)
                           .Set(KcbLuotkham.Columns.Locked).EqualTo(1)
                           .Where(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(objPatientExam.MaLuotkham)
                           .And(KcbLuotkham.Columns.IdBenhnhan).IsEqualTo(objPatientExam.IdBenhnhan).Execute();
                   }
               }
               else
               {
                   //Tự động khóa BN để kết thúc
                   new Update(KcbLuotkham.Schema)
                       .Set(KcbLuotkham.Columns.NgayKetthuc).EqualTo(globalVariables.SysDate)
                       .Set(KcbLuotkham.Columns.NguoiKetthuc).EqualTo(globalVariables.UserName)
                       .Set(KcbLuotkham.Columns.Locked).EqualTo(1)
                       .Where(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(objPatientExam.MaLuotkham)
                       .And(KcbLuotkham.Columns.IdBenhnhan).IsEqualTo(objPatientExam.IdBenhnhan).Execute();
                   objForm.addTrinhKy_OnFormLoad();
                   crpt.PrintOptions.PrinterName = PropertyLib._MayInProperties.TenMayInBienlai;
                   crpt.PrintToPrinter(1, false, 0, 0);
               }

               }
               catch (Exception ex)
               {
               Utility.CatchException(ex);
               }
        }
 /// <summary>
 /// hàm thưc hiện viêc in thông tin của phiếu thu đồng chi trả
 /// </summary>
 /// <param name="m_dtReportPhieuThu"></param>
 /// <param name="NgayInPhieu"></param>
 /// <param name="sTitleReport"></param>
 public void INPHIEU_DONGCHITRA(DataTable m_dtReportPhieuThu, DateTime NgayInPhieu, string sTitleReport)
 {
     Utility.UpdateLogotoDatatable(ref m_dtReportPhieuThu);
     string tieude="", reportname = "";
        var crpt = Utility.GetReport("thanhtoan_PHIEUTHU_DONGCHITRA",ref tieude,ref reportname);
        if (crpt == null) return;
        var objForm = new frmPrintPreview("", crpt, true, true);
        //try
        //{
        objForm.mv_sReportFileName = Path.GetFileName(reportname);
        objForm.mv_sReportCode = "thanhtoan_PHIEUTHU_DONGCHITRA";
        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,"Phone", 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,"sMoneyLetter",
                           new MoneyByLetter().sMoneyToLetter(SumOfTotal(m_dtReportPhieuThu,"SO_TIEN").ToString()));
        Utility.SetParameterValue(crpt,"BottomCondition", THU_VIEN_CHUNG.BottomCondition());
        objForm.crptViewer.ReportSource = crpt;
        if (Utility.isPrintPreview(PropertyLib._MayInProperties.TenMayInBienlai, PropertyLib._MayInProperties.PreviewInBienlai))
        {
        objForm.SetDefaultPrinter(PropertyLib._MayInProperties.TenMayInBienlai, 0);
        objForm.ShowDialog();
        }
        else
        {
        objForm.addTrinhKy_OnFormLoad();
        crpt.PrintOptions.PrinterName = PropertyLib._MayInProperties.TenMayInBienlai;
        crpt.PrintToPrinter(1, false, 0, 0);
        }
 }
        public void INPHIEU_DICHVU(DataTable m_dtReportPhieuThu, DateTime NgayInPhieu,string khogiay)
        {
            Utility.UpdateLogotoDatatable(ref m_dtReportPhieuThu);
               ReportDocument reportDocument = new ReportDocument();
            string tieude="", reportname = "",reportCode="";
               switch (khogiay)
               {
               case "A4":
                   reportCode = "thanhtoan_Bienlai_Dichvu_A4";
                   reportDocument = Utility.GetReport("thanhtoan_Bienlai_Dichvu_A4",ref tieude,ref reportname);
                   break;
               case "A5":
                   reportCode = "thanhtoan_Bienlai_Dichvu_A5";
                   reportDocument = Utility.GetReport("thanhtoan_Bienlai_Dichvu_A5" ,ref tieude,ref reportname);
                   break;

               }
               if (reportDocument == null) return;
               var crpt = reportDocument;
               var p = (from q in m_dtReportPhieuThu.AsEnumerable()
                    group q by q.Field<long>(KcbThanhtoan.Columns.IdThanhtoan) into r
                    select new
                    {
                        _key = r.Key,
                        tongtien_chietkhau_hoadon = r.Min(g => g.Field<decimal>("tongtien_chietkhau_hoadon")),
                        tongtien_chietkhau_chitiet = r.Min(g => g.Field<decimal>("tongtien_chietkhau_chitiet")),
                        tongtien_chietkhau = r.Min(g => g.Field<decimal>("tongtien_chietkhau"))
                    }).ToList();

               decimal tong = m_dtReportPhieuThu.AsEnumerable().Sum(c => c.Field<decimal>("TT_BN"));
               decimal tong_ck_hoadon = p.Sum(c => c.tongtien_chietkhau_hoadon);
               decimal tong_ck =p.Sum(c =>c.tongtien_chietkhau);
               tong = tong - tong_ck;
               var objForm = new frmPrintPreview("", crpt, true, true);
               objForm.mv_sReportFileName = Path.GetFileName(reportname);
               objForm.mv_sReportCode = reportCode;
               //try
               //{
               crpt.SetDataSource(m_dtReportPhieuThu.DefaultView);
               //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,"tienmiengiam_hdon", tong_ck_hoadon);
               Utility.SetParameterValue(crpt,"tong_miengiam", tong_ck);
               Utility.SetParameterValue(crpt,"tongtien_bn", tong);

               //  Utility.SetParameterValue(crpt,"DateTime", Utility.FormatDateTime(dtCreateDate.Value));
               Utility.SetParameterValue(crpt,"CurrentDate", Utility.FormatDateTime(NgayInPhieu));
               Utility.SetParameterValue(crpt, "sTitleReport", tieude);
               Utility.SetParameterValue(crpt,"sMoneyCharacter",
                                  new MoneyByLetter().sMoneyToLetter(Utility.sDbnull(tong)));
               Utility.SetParameterValue(crpt,"BottomCondition", THU_VIEN_CHUNG.BottomCondition());
               objForm.crptViewer.ReportSource = crpt;
               if (Utility.isPrintPreview(PropertyLib._MayInProperties.TenMayInBienlai, PropertyLib._MayInProperties.PreviewInBienlai))
               {
               objForm.SetDefaultPrinter(PropertyLib._MayInProperties.TenMayInBienlai, 0);
               objForm.ShowDialog();
               }
               else
               {
               objForm.addTrinhKy_OnFormLoad();
               crpt.PrintOptions.PrinterName = PropertyLib._MayInProperties.TenMayInBienlai;
               crpt.PrintToPrinter(1, false, 0, 0);
               }
        }
        public void InPhieuchi(long payment_ID)
        {
            string LyDoIn = "0";
               try
               {
               DataTable dtPatientPayment = new KCB_THANHTOAN().KcbThanhtoanLaythongtinphieuchi(payment_ID);
               THU_VIEN_CHUNG.CreateXML(dtPatientPayment, "thanhtoan_phieuchi.xml");
               dtPatientPayment.Rows[0]["sotien_bangchu"] =
                   new MoneyByLetter().sMoneyToLetter(Utility.sDbnull(dtPatientPayment.Rows[0]["SO_TIEN"]));
               string tieude = "", reportname = "";
               ReportDocument report = Utility.GetReport("thanhtoan_phieuchi", ref tieude, ref reportname);
               if (report == null) return;
               var objForm = new frmPrintPreview("", report, true, true);
               objForm.mv_sReportFileName = Path.GetFileName(reportname);
               objForm.mv_sReportCode = "thanhtoan_phieuchi";
               report.SetDataSource(dtPatientPayment);
               Utility.SetParameterValue(report,"NGUOIIN", Utility.sDbnull(globalVariables.gv_strTenNhanvien, ""));

               Utility.SetParameterValue(report,"ParentBranchName", globalVariables.ParentBranch_Name);
               Utility.SetParameterValue(report,"BranchName", globalVariables.Branch_Name);
               Utility.SetParameterValue(report,"DateTime", Utility.FormatDateTime(globalVariables.SysDate));
               Utility.SetParameterValue(report,"sCurrentDate", Utility.FormatDateTimeWithLocation(globalVariables.SysDate, globalVariables.gv_strDiadiem));
               Utility.SetParameterValue(report, "sTitleReport", tieude);
               //Utility.SetParameterValue(report,"CharacterMoney", new MoneyByLetter().sMoneyToLetter(TONG_TIEN.ToString()));
               objForm.crptViewer.ReportSource = report;

               if (Utility.isPrintPreview(PropertyLib._MayInProperties.TenMayInHoadon, PropertyLib._MayInProperties.PreviewInHoadon))
               {
                   objForm.SetDefaultPrinter(PropertyLib._MayInProperties.TenMayInHoadon, 1);
                   objForm.ShowDialog();
               }
               else
               {
                   objForm.addTrinhKy_OnFormLoad();
                   report.PrintOptions.PrinterName = PropertyLib._MayInProperties.TenMayInHoadon;
                   report.PrintToPrinter(1, false, 0, 0);
               }
               }
               catch (Exception ex1)
               {
               Utility.ShowMsg("Lỗi khi thực hiện in hóa đơn mẫu. Liên hệ IT để được trợ giúp-->" +
                               ex1.Message);
               }
        }
示例#14
0
        private void InphieuDv()
        {
            foreach (GridEXRow GridEXRow in grdTestInfo.GetCheckedRows())
            {
                xmen += "," + Utility.sDbnull(GridEXRow.Cells["id_chidinh"].Value, -1);
            }
            idDichvu = xmen.Remove(0, 1);
            int patient_id = Utility.Int32Dbnull(grdTestInfo.GetValue("id_benhnhan"));
            // KcbChidinhcl objAssignInfo = KcbChidinhcl.FetchByID(v_AssignId);
            DataTable dt = SPs.DLayThongTinBNChiDinhDV(idDichvu, patient_id).GetDataSet().Tables[0];

            if (dt == null || dt.Rows.Count <= 0)
            {
                Utility.ShowMsg("Không có dữ liệu in. Mời bạn kiểm tra lại");
                return;
            }
            //THU_VIEN_CHUNG.CreateXML(dt, "Thamkham_InphieuCLS.XML");
            Utility.UpdateLogotoDatatable(ref dt);
            //Utility.CreateBarcodeData(ref dt, v_AssignCode);

            idDichvu = "";
            string KhoGiay = "A5";
            bool inchung = false;
            string tieude = "", reportname = "";
            MoneyByLetter _moneyByLetter = new MoneyByLetter();
            var tinhtong = Utility.sDbnull(TinhTong(dt, KcbChidinhclsChitiet.DonGiaColumn.ColumnName));
            var smstinh = dt.Compute("SUM(TT_PHUTHU)","");
            string tongcong = Utility.sDbnull(TinhTong(dt, "tongcong"));
            string thanhtien = Utility.sDbnull(TinhTong(dt, "thanhtien"));
              //  int tongcong = Utility.Int16Dbnull(tinhtong )+ Utility.Int16Dbnull(smstinh);
            var crpt = Utility.GetReport("thanhtoan_Bienlai_Dichvu_A5", ref tieude, ref reportname);
            var objForm = new frmPrintPreview("IN PHIẾU THANH TOAN", crpt, true, true);
            try
            {
                //Utility.AddColumToDataTable(ref dt,"TinhTong",typeof(string));
                //   foreach (DataRow  drRow in dt.Rows)
                //   {
                //       drRow["tinhtong"] = tinhtong;
                //   }
                //   dt.AcceptChanges();
                crpt.SetDataSource(dt);
                //crpt.DataDefinition.FormulaFields["Formula_1"].Text = Strings.Chr(34) + "    Nhân viên        Bác sĩ chỉ định     ".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, "Telephone", globalVariables.Branch_Phone);
                Utility.SetParameterValue(crpt, "Address", globalVariables.Branch_Address);
                Utility.SetParameterValue(crpt, "CurrentDate", Utility.FormatDateTimeWithLocation(globalVariables.SysDate, globalVariables.gv_strDiadiem));
                Utility.SetParameterValue(crpt, "sTitleReport", tieude);
                Utility.SetParameterValue(crpt, "tinhtong", tinhtong);
                Utility.SetParameterValue(crpt, "tongcong", tongcong);
                Utility.SetParameterValue(crpt, "thanhtien", thanhtien);

                Utility.SetParameterValue(crpt, "BottomCondition", THU_VIEN_CHUNG.BottomCondition());
                Utility.SetParameterValue(crpt, "sMoneyCharacter", _moneyByLetter.sMoneyToLetter(Utility.sDbnull(tinhtong)));
                objForm.crptViewer.ReportSource = crpt;
                objForm.SetDefaultPrinter(PropertyLib._MayInProperties.TenMayInBienlai, 0);
                objForm.ShowDialog();

                objForm.Dispose();
                //  mayin = PropertyLib._MayInProperties.TenMayInBienlai;
                //}
                //else
                //{
                //    objForm.addTrinhKy_OnFormLoad();
                //    crpt.PrintOptions.PrinterName = PropertyLib._MayInProperties.TenMayInBienlai;
                //    //mayin = PropertyLib._MayInProperties.TenMayInBienlai;
                //    crpt.PrintToPrinter(1, false, 0, 0);
                //}
            }
            catch (Exception ex)
            {
                Utility.DefaultNow(this);
            }
        }