private void tmn_In_Click(object sender, EventArgs e) { m_dstamung.WriteXml("v_dstontamung.xml", XmlWriteMode.WriteSchema); frmReport af = new frmReport(m_v, m_dstamung.Tables[0], "v_tontamung.rpt", "", "", "", "", "", "", "", "", "", "Tồn Tạm Ứng", 1, true); af.ShowDialog(); }
private void tmn_In_Click(object sender, EventArgs e) { string reportname = "", asyt = "", abv = "", inbc = ""; if (!System.IO.Directory.Exists("..//..//Datareport//")) { System.IO.Directory.CreateDirectory("..//..//Datareport//"); } dscho.WriteXml("..//..//Datareport//v_2007_dscho_ttrv.xml", XmlWriteMode.WriteSchema); asyt = m_v.Syte; abv = m_v.Tenbv; inbc = lan.Change_language_MessageText("Từ ngày ") + " " + txtTN.Text.Substring(0, 10) + " " + lan.Change_language_MessageText("đến ngày ") + " " + txtDN.Text.Substring(0, 10); if (txtTN.Text == txtDN.Text) { inbc = lan.Change_language_MessageText("Ngày ") + " " + txtTN.Text.Substring(0, 10); } reportname = "v_2007_dscho_ttrv.rpt"; frmReport f = new frmReport(m_v, dscho.Tables[0], reportname, asyt.ToUpper(), abv.ToUpper(), inbc, "", "", "", "", "", "", "", 1, true); f.ShowDialog(); }
private void butIn_Click(object sender, EventArgs e) { try { //m_dsgoivp.WriteXml("v_goivp.xml",XmlWriteMode.WriteSchema); string aten = ""; try { aten = m_v.get_data("select ten from medibv.v_giavp where id=" + m_id_gia).Tables[0].Rows[0]["ten"].ToString(); } catch { aten = ""; } //int tylegiamgia = int.Parse(txtTiLe.Value.ToString()); frmReport af = new frmReport(m_v, m_dskythuatxungdot.Tables[0], "v_kythuatxungdot.rpt", "", "", "", "", aten, "", "", "", "", "Gói viện phí", 1, true); af.ShowDialog(); } catch { } }
private void f_Xem() { string acurdir = System.Environment.CurrentDirectory; tmn_Export.Enabled = false; tmn_Xem.Enabled = false; try { DataSet ads = f_Get_Data(); if (ads.Tables[0].Rows.Count == 0) { MessageBox.Show(lan.Change_language_MessageText("Không có số liệu!"), LibVP.AccessData.Msg); return; } if (ads != null) { string areport = "", asyt = "", abv = "", angayin = "", anguoiin = "", aghichu = ""; areport = "v_2007_bkhoantra.rpt"; if (rdBC_02.Checked) { areport = "v_2007_bkhoantra_trongngay.rpt"; } else if (rdBC_03.Checked) { areport = "v_2007_bkhoantra_khacngay.rpt"; } if (rdBC_01.Checked && chkBHYTTraBnTra.Checked) { areport = "v_2007_bkhoantra_bhyt.rpt"; if (System.IO.File.Exists("..//..//..//report//" + areport) == false) { areport = "v_2007_bkhoantra.rpt"; } } asyt = m_v.Syte; abv = m_v.Tenbv; angayin = lan.Change_language_MessageText("Ngày") + " " + txtNgayin.Value.Day.ToString().PadLeft(2, '0') + " " + lan.Change_language_MessageText("tháng") + " " + txtNgayin.Value.Month.ToString().PadLeft(2, '0') + " " + lan.Change_language_MessageText("năm") + " " + txtNgayin.Value.Year.ToString(); anguoiin = txtNguoilapphieu.Text.Trim(); if (rdThang.Checked) { aghichu = lan.Change_language_MessageText("Tháng:") + " " + txtThang.Value.ToString().PadLeft(2, '0') + " " + lan.Change_language_MessageText("Năm:") + " " + txtNam.Value.ToString(); } else { aghichu = lan.Change_language_MessageText("Từ ngày:") + " " + txtTN.Text.Substring(0, 10) + " " + lan.Change_language_MessageText("Đến ngày:") + " " + txtDN.Text.Substring(0, 10); } if (!System.IO.Directory.Exists("..\\..\\Report_vp\\")) { System.IO.Directory.CreateDirectory("..\\Report_vp\\"); } if (System.IO.Directory.Exists("..//..//datareport") == false) { System.IO.Directory.CreateDirectory("..//..//datareport"); } ads.WriteXml("..//..//datareport//v_2007_bkhoantra.xml", XmlWriteMode.WriteSchema); // frmReport fa = new frmReport(m_v, ads.Tables[0], areport, asyt.ToUpper(), abv.ToUpper(), angayin, anguoiin, aghichu, txtNguoilapphieu.Text.Trim(), txtThuquy.Text.Trim(), txtKetoanvp.Text.Trim(), txtPhongtckt.Text.Trim(), "Bảng kê hoá đơn hoàn trả.", 1, chkXem.Checked?true:false); fa.KetxuatExcel = bKetxuatExcel; fa.ShowDialog(); } } catch { } finally { System.Environment.CurrentDirectory = acurdir; tmn_Export.Enabled = true; tmn_Xem.Enabled = true; } }
private void f_Xem() { string areport = ""; string acurdir = System.Environment.CurrentDirectory; tmn_Export.Enabled = false; tmn_Xem.Enabled = false; try { DataSet ads = f_Get_Data(); if (ads != null) { string asyt = "", abv = "", angayin = "", anguoiin = "", aghichu = ""; areport = "v_2007_bkthutamung.rpt"; if (rdBC_03.Checked) { areport = "v_2007_bkthutamung_conghoan.rpt"; } if (cbMaubaocao.SelectedIndex > 0) { string areportt = areport.Replace(".rpt", "_" + cbMaubaocao.SelectedValue.ToString().Trim() + ".rpt"); if (System.IO.File.Exists("..\\..\\Report_vp\\" + areportt)) { areport = areportt; } } asyt = m_v.Syte; abv = m_v.Tenbv; angayin = lan.Change_language_MessageText("Ngày") + " " + txtNgayin.Value.Day.ToString().PadLeft(2, '0') + " " + lan.Change_language_MessageText("tháng") + " " + txtNgayin.Value.Month.ToString().PadLeft(2, '0') + " " + lan.Change_language_MessageText("năm") + " " + txtNgayin.Value.Year.ToString(); anguoiin = txtNguoilapphieu.Text.Trim(); if (rdThang.Checked) { aghichu = lan.Change_language_MessageText("Tháng:") + " " + txtThang.Value.ToString().PadLeft(2, '0') + " " + lan.Change_language_MessageText("Năm:") + " " + txtNam.Value.ToString(); } else { if (chkGio.Checked) { aghichu = lan.Change_language_MessageText("Từ ngày:") + " " + txtTN.Text.Substring(0, 16) + " " + lan.Change_language_MessageText("Đến ngày:") + " " + txtDN.Text.Substring(0, 16); } else { aghichu = lan.Change_language_MessageText("Từ ngày:") + " " + txtTN.Text.Substring(0, 10) + " " + lan.Change_language_MessageText("Đến ngày:") + " " + txtDN.Text.Substring(0, 10); } } if (!System.IO.Directory.Exists("..//..//Datareport//")) { System.IO.Directory.CreateDirectory("..//..//Datareport//"); } ads.WriteXml("..//..//Datareport//v_BKtamung.xml", XmlWriteMode.WriteSchema); if (!System.IO.Directory.Exists("..\\..\\Report_vp\\")) { System.IO.Directory.CreateDirectory("..\\Report_vp\\"); } if (ads.Tables[0].Rows.Count == 0) { MessageBox.Show(lan.Change_language_MessageText("Không có số liệu!"), LibVP.AccessData.Msg); return; } if ((chkInrieng.Checked == false && chkInchung.Checked == false) || chkInrieng.Checked) { frmReport fa = new frmReport(m_v, ads.Tables[0], areport, asyt.ToUpper(), abv.ToUpper(), angayin, anguoiin, aghichu, txtNguoilapphieu.Text.Trim(), txtThuquy.Text.Trim(), txtKetoanvp.Text.Trim(), txtPhongtckt.Text.Trim(), "Báo cáo thu viện phí trực tiếp", 1, chkXemkhiin.Checked?true:false); fa.KetxuatExcel = bKetxuatExcel; fa.ShowDialog(); } if (chkInchung.Checked) { areport = areport.Replace(".rpt", "_inchung.rpt"); frmReport fa = new frmReport(m_v, ads.Tables[0], areport, asyt.ToUpper(), abv.ToUpper(), angayin, anguoiin, aghichu, txtNguoilapphieu.Text.Trim(), txtThuquy.Text.Trim(), txtKetoanvp.Text.Trim(), txtPhongtckt.Text.Trim(), "Báo cáo thu viện phí trực tiếp", 1, chkXemkhiin.Checked?true:false); fa.KetxuatExcel = bKetxuatExcel; fa.ShowDialog(); } } } catch (Exception ex) { MessageBox.Show(areport + "\n" + ex.ToString()); } finally { System.Environment.CurrentDirectory = acurdir; tmn_Export.Enabled = true; tmn_Xem.Enabled = true; } }