/// <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 (cboKho.SelectedIndex < 0) { Utility.ShowMsg("Bạn phải chọn Kho thuốc"); cboKho.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"); } m_dtReport = BAOCAO_THUOC.ThuocSovatlieuchitiet(fromdate, todate, Utility.Int32Dbnull(cboKho.SelectedValue), Utility.Int32Dbnull(txtthuoc.MyID, -1), nhomthuoc, chkBiendong.Checked ? 1 : 0); THU_VIEN_CHUNG.CreateXML(m_dtReport, "thuoc_sovatlieu_chitiet.xml"); Utility.SetDataSourceForDataGridEx(grdListChitiet, 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", MessageBoxIcon.Warning); return; } string FromDateToDate = Utility.FromToDateTime(dtFromDate.Text, dtToDate.Text); thuoc_baocao.ThuocSovatlieuchitiet(m_dtReport, KIEU_THUOC_VT, baocaO_TIEUDE1.TIEUDE, dtNgayIn.Value, FromDateToDate, Utility.sDbnull(cboKho.Text)); } catch (Exception ex) { Utility.ShowMsg(ex.Message); } }