private void textBox_BoxCode_KeyUp(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { textBox_BoxCode.Text = ""; textBox_BoxCode.Text = scannedCode.ToString(); scannedCode.Clear(); using (conn = new SQLiteConnection(connStr)) { conn.Open(); codeCURD = new BarcodeReferenceCode_CRUD(conn); BarcodeBoxCodeInfo item = new BarcodeBoxCodeInfo(); var id = codeCURD.GetMaxID(BarcodeReferenceCode_CRUD.Table.BOX_CODE) + 1; item.ID = id; item.BoxCode = textBox_BoxCode.Text; codeCURD.Insert(item); ds = codeCURD.SelectAll_Dataset(BarcodeReferenceCode_CRUD.Table.BOX_CODE); conn.Close(); } DataGridViewRefreshBinding(BarcodeReferenceCode_CRUD.Table.BOX_CODE); } else { textBox_BoxCode.Text = ""; scannedCode.Append(KeyToUni.KeyCodeToUnicode(e.KeyCode).ToUpper()); } }
private void button_BoxDelete_Click(object sender, EventArgs e) { var index = dataGridView.CurrentCell.RowIndex; var id = dataGridView[0, index]; var code = dataGridView[1, index]; BarcodeBoxCodeInfo item = new BarcodeBoxCodeInfo(); item.ID = (int)id.Value; item.BoxCode = (string)code.Value; using (conn = new SQLiteConnection(connStr)) { conn.Open(); codeCURD = new BarcodeReferenceCode_CRUD(conn); codeCURD.Delete(item); ds = codeCURD.SelectAll_Dataset(BarcodeReferenceCode_CRUD.Table.BOX_CODE); conn.Close(); } DataGridViewRefreshBinding(BarcodeReferenceCode_CRUD.Table.BOX_CODE); }