private void btnSearch_Click(object sender, EventArgs e) { if (this.txtSearchDocnum.Text.Trim().Length == 0) { return; } List <ArtrnMin> iv_list = DbfTable.InvoiceList(this.data_path, TransactionStatus.STATUS.ALL, DbfTable.INVOICE_TYPE.IV); List <ArtrnMin> hs_list = DbfTable.InvoiceList(this.data_path, TransactionStatus.STATUS.ALL, DbfTable.INVOICE_TYPE.HS); ArtrnMin target_invoice = null; if (iv_list.Where(i => i.docnum.Trim() == this.txtSearchDocnum.Text.Trim()).FirstOrDefault() != null) { target_invoice = iv_list.Where(i => i.docnum.Trim() == this.txtSearchDocnum.Text.Trim()).First(); this.tabControl2.SelectedTab = this.tabIV; this.cbStatus.SelectedItem = this.cbStatus.Items.Cast <ComboboxItem>().Where(c => (TransactionStatus.STATUS)c.Value == TransactionStatus.STATUS.ALL).First(); this.dgvIV.Rows.Cast <DataGridViewRow>().Where(r => ((string)r.Cells[this.col_iv_docnum.Name].Value).Trim() == this.txtSearchDocnum.Text.Trim()).First().Cells[this.col_iv_docnum.Name].Selected = true; } else if (hs_list.Where(i => i.docnum.Trim() == this.txtSearchDocnum.Text.Trim()).FirstOrDefault() != null) { target_invoice = hs_list.Where(i => i.docnum.Trim() == this.txtSearchDocnum.Text.Trim()).First(); this.tabControl2.SelectedTab = this.tabHS; this.cbStatus.SelectedItem = this.cbStatus.Items.Cast <ComboboxItem>().Where(c => (TransactionStatus.STATUS)c.Value == TransactionStatus.STATUS.ALL).First(); this.dgvHS.Rows.Cast <DataGridViewRow>().Where(r => ((string)r.Cells[this.col_hs_docnum.Name].Value).Trim() == this.txtSearchDocnum.Text.Trim()).First().Cells[this.col_hs_docnum.Name].Selected = true; } else { MessageBox.Show("ค้นหาบิลขายเลขที่ " + this.txtSearchDocnum.Text.Trim() + " ไม่พบ"); return; } }
private void MainForm_Shown(object sender, EventArgs e) { if (this.data_path == null) { DialogCompanySelect comp = new DialogCompanySelect(this); if (comp.ShowDialog() == DialogResult.OK) { this.data_path = comp.selected_comp.RewriteDataPath(); this.lblDataPath.Text = DbfTable.GetIsinfo(this.data_path).thinam + " ( " + this.data_path.TrimEnd('\\') + " )"; this.LoadStatusComboboxItem(); this.cbStatus.SelectedItem = this.cbStatus.Items.Cast <ComboboxItem>().Where(i => ((TransactionStatus.STATUS)i.Value) == TransactionStatus.STATUS.WARRANTY).First(); this.iv_list = new BindingList <ArtrnMin>(DbfTable.InvoiceList(this.data_path, this.status, DbfTable.INVOICE_TYPE.IV)); this.dgvIV.DataSource = this.iv_list; this.tabIV.Text = " ขายเชื่อ (" + this.iv_list.Count.ToString() + ") <F6> "; } else { Application.Exit(); } } else { this.lblDataPath.Text = DbfTable.GetIsinfo(this.data_path).thinam + " ( " + this.data_path.TrimEnd('\\') + " )"; this.LoadStatusComboboxItem(); this.cbStatus.SelectedItem = this.cbStatus.Items.Cast <ComboboxItem>().Where(i => ((TransactionStatus.STATUS)i.Value) == TransactionStatus.STATUS.WARRANTY).First(); this.iv_list = new BindingList <ArtrnMin>(DbfTable.InvoiceList(this.data_path, this.status, DbfTable.INVOICE_TYPE.IV)); this.dgvIV.DataSource = this.iv_list; this.tabIV.Text = " ขายเชื่อ (" + this.iv_list.Count.ToString() + ") <F6> "; } }
private void GetInvoiceList() { if (this.tabControl2.SelectedTab == this.tabIV) { this.iv_list = new BindingList <ArtrnMin>(DbfTable.InvoiceList(this.data_path, this.status, DbfTable.INVOICE_TYPE.IV)); this.dgvIV.DataSource = this.iv_list; this.tabIV.Text = " ขายเชื่อ (" + this.iv_list.Count.ToString() + ") <F6> "; } else { this.hs_list = new BindingList <ArtrnMin>(DbfTable.InvoiceList(this.data_path, this.status, DbfTable.INVOICE_TYPE.HS)); this.dgvHS.DataSource = this.hs_list; this.tabHS.Text = " ขายสด (" + this.hs_list.Count.ToString() + ") <F7> "; } }