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);
}
