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