public void ShowReportRequestPerson(ParamSearchPerson param, QueryString.Search.RequestPersonFilter reportType) { try { var dataSource = dcore.GetSearchRequest(param, reportType); Reports.ReportDisplay f = new Reports.ReportDisplay(); if (!Constants.fullMode) { //f.ReportViewer.ShowExportButton = false; } string headerText = ""; if (reportType == QueryString.Search.RequestPersonFilter.RTC) { headerText = "รายชื่อเสนอความต้องการทหารกองประจำการลงสังกัด ศฝท."; } else { headerText = "รายชื่อเสนอความต้องการทหารกองประจำการไปสังกัดหน่วยต่างๆ"; } List <ReportParameter> reportParam = new List <ReportParameter>(); reportParam.Add(new ReportParameter("reportHeaderText", headerText)); reportParam.Add(new ReportParameter("yearin", param.yearin)); f.ReportViewer.SetDisplayMode(Microsoft.Reporting.WinForms.DisplayMode.PrintLayout); f.DisplayReport(dataSource, "Navy.Reports.ReportRequestPerson.rdlc", reportParam); f.Show(); } catch { throw; } }
private void Search() { try { ParamSearchPerson param = new ParamSearchPerson(); param.name = textBoxName.Text; param.sname = textBoxSname.Text; param.id8 = mTextBoxID8.Text; param.yearin = mtxtYearin.Text; gvResult.Columns.Clear(); if (rbAddNew.Checked) { pTable = dcore.GetSearchPersonForRequest(param); setDataSource(pTable); gvResult.DataSource = soucre; gvResult.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells; try { gvResult.Columns["navyid"].Visible = false; gvResult.Columns["oldyearin"].Visible = false; } catch { } count = pTable.Rows.Count; } else if (rbEditOrDelete.Checked) { prTable = dcore.GetSearchRequest(param, QueryString.Search.RequestPersonFilter.All); setDataSource(prTable); gvResult.DataSource = soucre; gvResult.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells; try { gvResult.Columns["navyid"].Visible = false; gvResult.Columns["unit"].Visible = false; gvResult.Columns["num"].Visible = false; gvResult.Columns["oldyearin"].Visible = false; gvResult.Columns["updatecount"].Visible = false; } catch { } count = prTable.Rows.Count; } else if (rbSorting.Checked) { prTable = dcore.GetSearchRequest(param, QueryString.Search.RequestPersonFilter.All); //gvResult.DataSource = prTable; setDataSource(prTable); gvResult.DataSource = soucre; gvResult.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells; try { gvResult.Columns["navyid"].Visible = false; gvResult.Columns["unit"].Visible = false; gvResult.Columns["oldyearin"].Visible = false; gvResult.Columns["updatecount"].Visible = false; } catch { } count = prTable.Rows.Count; } toolStripStatusLabel1.Text = Convert.ToString(count) + " Record(s)"; gvResult.Focus(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }