예제 #1
0
        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;
            }
        }
예제 #2
0
        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);
            }
        }