//削除 private void btn_del_user_Click(object sender, EventArgs e) { //MessageBox.Show("btn_del_user_click"); if (uid != "0" && user != "") { int result = 0; string sql = ""; //デリート sql = "delete from parsonal where uid = '" + uid + "'"; result = mdb.executeNonQuery(sql); //バックアップ sql = "insert into timedata_backup select * from timedata where uid = '" + uid + "'"; result = mdb.executeNonQuery(sql); //削除 sql = "delete from timedata where uid = '" + uid + "'"; result = mdb.executeNonQuery(sql); MessageBox.Show("削除しました。"); } this.Close(); }
//登録 private void btn_regist_user_Click(object sender, EventArgs e) { //MessageBox.Show("btn_regist_user_Click"); if (tbox_user.Text != "") { //DB登録 int result; OleDbDataReader reader; reader = mdb.executeQuery("select count(1) from parsonal where uid = '" + this.lbl_11.Text + "'"); reader.Read(); result = (int)reader.GetValue(0); if (result == 0) { string sql = "insert into parsonal values (" + " '" + this.lbl_11.Text + "'" + ",'" + this.lbl_12.Text + "'" + ",'" + this.lbl_13.Text + "'" + ",'" + this.lbl_14.Text + "'" + ",'" + this.lbl_15.Text + "'" + ",'" + this.tbox_user.Text + "')"; result = mdb.executeNonQuery(sql); MessageBox.Show("登録しました。"); //フォームクローズ this.Close(); } else if (result > 0) { MessageBox.Show("既に登録済みです。"); } } else { MessageBox.Show("名前を入力してください。"); } }
private void timer_add_Tick(object sender, EventArgs e) { if (nfc.IsCurrentCard && this.timer_lock == false) { try { int result; string user; OleDbDataReader reader; DateTime addDate; timer_lock = true; byte[] recv; byte[] send = null; //UID send = new byte[] { 0xff, 0xca, 0x00, 0x00 }; recv = nfc.SendCommand2(send); uid = BitConverter.ToString(recv).Replace("-", ""); Debug.WriteLine("CARD_UID:" + uid); string sql = "select count(1) from parsonal where uid = '" + uid + "'"; reader = mdb.executeQuery(sql); reader.Read(); result = (int)reader.GetValue(0); if (result > 0) { foreach (UserInval v in user_list) { if (v.uid == uid) { Debug.WriteLine("時間内DB追加無し"); return; } } sql = "select user from parsonal where uid = '" + uid + "'"; reader = mdb.executeQuery(sql); reader.Read(); user = (string)reader.GetValue(0); addDate = DateTime.Now; sql = "select count(1) from timedata where uid = '" + uid + "'"; reader = mdb.executeQuery(sql); reader.Read(); result = (int)reader.GetValue(0); sql = "insert into timedata values (" + "'" + uid + "'," + (result + 1) + "," + "'" + DateTime.Now + "')"; result = mdb.executeNonQuery(sql); if (result > 0) { //正常登録 this.lbl_name.Text = user; this.lbl_timer2.Text = addDate.ToLongTimeString(); this.lbl_timer2.ForeColor = Color.Red; this.timer.Enabled = false; this.timer_interval.Enabled = true; Debug.WriteLine("正常登録:" + uid); Debug.WriteLine(""); user_list.Add(new UserInval(uid, DateTime.Now)); } } } catch (ApplicationException) { //null Debug.WriteLine("ApplicationException:MainForm"); } } if (nfc.IsReaderRemoved == true) { this.sttl_status.Text = "カードリーダーが接続されていません"; app_failed = true; } else if (nfc.IsNfcFaild == true) { this.Close(); } else { if (app_failed == false) { this.sttl_status.Text = "ポーリング中"; } } timer_lock = false; }