private void btnReport_Click(object sender, EventArgs e) { try { object dataSource; if (gvResult.DataSource != null) { dataSource = gvResult.DataSource; //rcore.ShowReportRequestPerson(dataSource, reportType); } else { ParamSearchPerson param = new ParamSearchPerson(); param.name = textBoxName.Text; param.sname = textBoxSname.Text; param.id8 = mTextBoxID8.Text; param.yearin = mtxtYearin.Text; //rcore.ShowReportRequestPerson(param, reportType); } } catch (Exception ex) { MessageBox.Show("พบข้อผิดพลาดในการเรียกดูข้อมูล .. " + ex.Message); } }
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; } }
public void ShowReportRequestPerson(QueryString.Search.RequestPersonFilter reportType) { ParamSearchPerson param = new ParamSearchPerson(); param.yearin = dcore.GetMaxYearin(); ShowReportRequestPerson(param, reportType); }
private void Search(DataGridView dgv) { var watch = Stopwatch.StartNew(); try { paramSearch = new ParamSearchPerson(); paramSearch.name = textBoxName.Text; paramSearch.sname = textBoxSname.Text; paramSearch.id8 = mTextBoxID8.Text; paramSearch.id13 = textBoxID13.Text; paramSearch.yearin = mtxtYearin.Text; paramSearch.runcode = textBoxRunNum.Text.Trim(); paramSearch.company = cbbCompany.Text.Trim(); paramSearch.batt = cbbBatt.Text.Trim(); if (checkBoxSearchNivyAll.Checked) { personTable = dcore.GetSearchPersonTable("", paramSearch, itemsPerPage, page, out count); dgv.DataSource = personTable; } else { //personTable = dcore.GetSearchPersonTable("", tempInput, itemsPerPage, page, out count); personNavyData = dcore.GetSearchPerson("", DataControls.GetSelectedValueComboBoxToString(cbbProvince), paramSearch, itemsPerPage, page, out count); dgv.DataSource = personNavyData; try { dgv.Columns["navyid"].Visible = false; dgv.Columns["id13"].Visible = false; } catch { } } if (count <= itemsPerPage) { totalPage = Function.CalTotalPage(count, itemsPerPage); labelCountSearchRecord.Text = Convert.ToString(count) + " Record(s)"; labelPaging.Text = page.ToString() + "/" + totalPage.ToString(); } else { totalPage = Function.CalTotalPage(count, itemsPerPage); labelCountSearchRecord.Text = Convert.ToString((page * itemsPerPage) - itemsPerPage + 1) + " - " + Convert.ToString(page * itemsPerPage) + " of " + Convert.ToString(count) + " Record(s)"; labelPaging.Text = page.ToString() + "/" + totalPage.ToString(); } EnableButtonPage(); dgv.Focus(); } catch (Exception ex) { MessageBox.Show(ex.Message); } watch.Stop(); label8.Text = String.Format("{0}m {1}s {2}ms", watch.Elapsed.Minutes, watch.Elapsed.Seconds, watch.Elapsed.Milliseconds); }
public SearchPersonRequestForm() { InitializeComponent(); AddEnterKeyDown(); rbAddNew.Checked = true; rbEditOrDelete.Checked = false; paramSearch = new ParamSearchPerson(); pTable = new PersonRequestDataSet.PersonDataTable(); prTable = new PersonRequestDataSet.PersonRequestDataTable(); dcore = new DataCoreLibrary(); rcore = new ReportCoreLibrary(); mtxtYearin.Text = dcore.GetMaxYearin(); }
public SearchPersonTransferForm() { InitializeComponent(); AddEnterKeyDown(); rbAddNew.Checked = true; rbEditOrDelete.Checked = false; paramSearch = new ParamSearchPerson(); dtPerson = new DataTable(); dtTransDetail = new DataTable(); dtPunishmentDetail = new DataTable(); dtDataOldYearin = new DataTable(); dtIndicment = new DataTable(); dcoreNav = new DataCoreLibrary(); dcoreNav.ChangeDB("navdb"); dcoreNavAll = new DataCoreLibrary(); dcoreNavAll.ChangeDB("navdb_all"); mtxtYearin.Text = dcoreNav.GetMaxYearin(); }
private void Search(DataGridView dgv) { try { paramSearch = new ParamSearchPerson(); paramSearch.name = TxtBox_Name.Text; paramSearch.sname = TxtBox_Sname.Text; paramSearch.id8 = TxtBox_ID8.Text; paramSearch.id13 = TxtBox_ID13.Text; paramSearch.yearin = TxtBox_Yearin.Text; if (chkBox_HaveIndictment.Checked) { personNavyData = dcore.GetSearchPersonOnlyIndictment("", "", paramSearch, itemsPerPage, page, out count); dgv.DataSource = personNavyData; } else { personNavyData = dcore.GetSearchPerson("", "", paramSearch, itemsPerPage, page, out count); dgv.DataSource = personNavyData; } //เลือกไม่แสดง Column try { dgv.Columns["navyid"].Visible = false; dgv.Columns["birthdate"].Visible = false; dgv.Columns["oldyearin"].Visible = false; } catch { } dgv.Focus(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void Search() { try { ParamSearchPerson param = new ParamSearchPerson(); param.name = textBoxName.Text; param.sname = textBoxSname.Text; param.id8 = mTextBoxID8.Text; param.yearin = mtxtYearin.Text; if (rbAddNew.Checked) { listPerson = dcoreNav.GetSearchPerson("", "", param); } else if (rbEditOrDelete.Checked) { listPerson = dcoreNavAll.GetSearchPerson("", "", param); } gvResult.DataSource = listPerson; gvResult.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells; try { gvResult.Columns["navyid"].Visible = false; } catch { } count = listPerson.Count; labelCountSearchRecord.Text = Convert.ToString(count) + " Record(s)"; gvResult.Focus(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
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); } }
private void Search(MyControls.GridviewResultControl dgv) { var watch = Stopwatch.StartNew(); try { paramSearch = new ParamSearchPerson(); paramSearch.name = textBoxName.Text; paramSearch.sname = textBoxSname.Text; paramSearch.id8 = mTextBoxID8.Text; paramSearch.yearin = mtxtYearin.Text; paramSearch.id13 = textBoxID13.Text; paramSearch.runcode = textBoxRunNum.Text.Trim(); if (checkBoxSearchNivyAll.Checked) { if (dgv.EnablePagingData) { personTable = dcore.GetSearchPersonTable("", paramSearch, dgv.itemsPerPage, dgv.page, out dgv.count); dgv.BindDataToGridView(personTable); dgv.ConfigButtonPage(); } else { personTable = dcore.GetSearchPersonTable("", paramSearch, out dgv.count); dgv.BindDataToGridView(personTable); } } else { if (dgv.EnablePagingData) { personNavyData = dcore.GetSearchPerson("", DataControls.GetSelectedValueComboBoxToString(cbbProvince), paramSearch, dgv.itemsPerPage, dgv.page, out dgv.count); dgv.BindDataToGridView(Function.ConvertToDataTable <PersonSearch>(personNavyData)); dgv.BindDataPaging(dgv.page); dgv.ConfigButtonPage(); } else { personNavyData = dcore.GetSearchPerson("", DataControls.GetSelectedValueComboBoxToString(cbbProvince), paramSearch); dgv.count = personNavyData.Count; dgv.BindDataToGridView(Function.ConvertToDataTable <PersonSearch>(personNavyData)); } try { dgv.Columns["navyid"].Visible = false; dgv.Columns["id13"].Visible = false; } catch { } } dgv.CalculatePaging(); dgv.Refresh(); dgv.Focus(); } catch (Exception ex) { MessageBox.Show(ex.Message); } watch.Stop(); dgv.LbTimeExecute.Text = String.Format("{0}m {1}s {2}ms", watch.Elapsed.Minutes, watch.Elapsed.Seconds, watch.Elapsed.Milliseconds); }