void SearchList() { string line = null; string name = null; DateTime from = DateTime.MinValue; DateTime to = DateTime.MaxValue; _table = DatabaseSet.GetInspectList(line, name, from, to); _table.Columns.Add("NG處理", typeof(string)); string sort = bindingSource.Sort; bindingSource.Sort = null; bindingSource.DataSource = null; this.GroupTable = null; if (this.InspectMode == InspeceMode.ByPn) { bindingSource.DataSource = this.GroupTable; } else { bindingSource.DataSource = _table; } bindingSource.Sort = sort; btnSend.Enabled = _table.Rows.Count > 0; dgv.EditMode = DataGridViewEditMode.EditOnEnter; }
private void btnSend_Click(object sender, EventArgs e) { DatabaseSet.待驗清單DataTable table = (DatabaseSet.待驗清單DataTable)bindingSource.DataSource; if (MessageBox.Show("資料經送出後不可再修改,請確認後繼續", "送出確認", MessageBoxButtons.OKCancel, MessageBoxIcon.Exclamation) == DialogResult.OK) { int delete; int update = DatabaseSet.UpdateInspectDeleteList(table, out delete); MessageBox.Show("更新了 " + update + " 筆檢驗資料\n共刪除 " + delete + " 筆檢驗資料"); SearchList(); } }
void SearchUnreinspectList() { string line = null; string name = null; _table = DatabaseSet.GetUnreinspectList(line, name); _table.Columns.Add("NG處理", typeof(string)); string sort = bindingSource.Sort; bindingSource.Sort = null; this.GroupTable = null; this.InspectMode = InspeceMode.OnlyUnre; bindingSource.DataSource = _table; bindingSource.Sort = sort; btnSend.Enabled = false; dgv.EditMode = DataGridViewEditMode.EditProgrammatically; }
void SearchList() { string qcn = txtQCN.Text.Trim(); string partnubmer = txtPartNumber.Text.Trim(); DateTime date = DateTime.MinValue; if (ckbDate.Checked) { date = dtpDate.Value; } DatabaseSet.待驗清單DataTable table = DatabaseSet.GetInspectCompleteList(qcn, partnubmer, date); table.Columns.Add("刪除", typeof(bool)); bindingSource.DataSource = table; btnSend.Enabled = table.Rows.Count > 0; dgv.AutoResizeColumns(); dgv.Columns[0].Width = 40; dgv.Columns[1].Width = 50; }