public static bool insert_record(string id, string info, string create_time) { bool bR = false; try { int result = 0; object[] pars = new object[] { id, info, create_time }; result = int.Parse(CsharpSQLiteHelper.ExecuteNonQuery(sql_insert_record, pars).ToString()); if (result >= 1) { bR = true; } else { bR = false; } } catch (System.Exception ex) { //MessageBox.Show("出现错误:" + ex.Message); } return(bR); }
public void change_control_state(int state, object o) { switch (state) { case 0: //获取指纹成功 //btnStart.Visible = true; this.pictureBox1.Image = global::ZkFingerDemo.Properties.Resources.business_user_accept; string xh = (string)index_user_list[(int)o]; string insert_check_record = string.Format("replace into CheckRecords(record_id,checkDate,xh) values('{0}','{1}','{2}');", this.unique_check_id, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), xh); CsharpSQLiteHelper.ExecuteNonQuery(insert_check_record, null); this.refresh_check_list(); DataRow[] rows = this.person_list.Select(string.Format("xh='{0}'", xh)); if (rows.Length > 0) { string user_name = rows[0]["xm"].ToString(); string str = "欢迎你," + user_name; this.lblName.Text = str; Program.play_voice(str); } break; case 1: //获取指纹失败 //btnStart.Visible = true; this.pictureBox1.Image = global::ZkFingerDemo.Properties.Resources.business_user_delete; string str_who_are_you = "你是谁?"; this.lblName.Text = str_who_are_you; Program.play_voice("请扫描你的指纹"); break; } }
private void ShowPerson() { string select_all = "select p.xh \"学号\", p.xm \"姓名\"," + " case(f.print) when '' then '未登记' else '已登记' end \"登记状态\" " + ", pe.nj_name \"年级\", pe.bj_name \"班级\", pe.tel \"电话\", pe.email \"邮箱\" " + " from person_info_min as p,person_finger_print as f ,person_expand_info as pe" + " where p.xh=f.xh and p.xh=pe.xh order by p.xh;"; DataTable dt = CsharpSQLiteHelper.ExecuteTable(select_all, null); dataGridView1.DataSource = dt; int iNumberofStudents = dt.Rows.Count; this.groupBox2.Text = "学生列表 共有学生" + iNumberofStudents.ToString() + "名"; this.dataGridView1.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells); int headerW = this.dataGridView1.RowHeadersWidth; int columnsW = 0; DataGridViewColumnCollection columns = this.dataGridView1.Columns; for (int i = 0; i < columns.Count; i++) { columnsW += columns[i].Width; } if (columnsW + headerW < this.dataGridView1.Width) { int leftTotalWidht = this.dataGridView1.Width - columnsW - headerW; int eachColumnAddedWidth = leftTotalWidht / columns.Count; for (int i = 0; i < columns.Count; i++) { columns[i].Width += eachColumnAddedWidth; } } }
public static serialPortConfig getDefaultConfig() { serialPortConfig config = null; string port_name = string.Empty; string baut_rate = string.Empty; string sql = "select vvalue from sys_config where vkey = '{0}'"; DataTable dt_temp = CsharpSQLiteHelper.ExecuteTable(sql, new object[1] { "port_name" }); if (dt_temp.Rows.Count > 0) { port_name = dt_temp.Rows[0]["vvalue"].ToString(); } sql = "select vvalue from sys_config where vkey = '{0}'"; dt_temp = CsharpSQLiteHelper.ExecuteTable(sql, new object[1] { "baut_rate" }); if (dt_temp.Rows.Count > 0) { baut_rate = dt_temp.Rows[0]["vvalue"].ToString(); } config = new serialPortConfig(port_name, baut_rate); return(config); }
void HistoryCheckRecord_Shown(object sender, EventArgs e) { string select = "SELECT record_id \"编号\",info \"备注\",create_time \"创建时间\" FROM check_record_info order by create_time desc;"; DataTable dt = CsharpSQLiteHelper.ExecuteTable(select, null); this.dataGridView1.DataSource = dt; this.format_dgv(this.dataGridView1); }
public void set_fp_string(string tmp) { string insert_fp = string.Format("replace into person_finger_print(xh,print) values('{0}','{1}');", current_user_id, tmp); int r = CsharpSQLiteHelper.ExecuteNonQuery(insert_fp, null); if (r > 0) { this.ShowPerson(); MessageBox.Show("指纹登记成功!", "提示"); } }
public static void saveConfig(serialPortConfig config) { string sql = "insert into sys_config(vkey,vvalue) values('{0}','{1}')"; int rtn = 0; rtn = CsharpSQLiteHelper.ExecuteNonQuery(sql, new object[2] { "port_name", config.portName }); if (rtn <= 0) { return; } rtn = 0; rtn = CsharpSQLiteHelper.ExecuteNonQuery(sql, new object[2] { "baut_rate", config.baudRate }); //if (rtn <= 0) //{ // return; //} //// accessDb4o //IObjectContainer db = Db4oFactory.OpenFile(serialPortConfig.configFilePath); //try //{ // IList<serialPortConfig> list = db.Query<serialPortConfig>(delegate(serialPortConfig cf) // { // return cf.configName == config.configName; // } // ); // if (list.Count <= 0) // { // db.Store(config); // } // else // { // serialPortConfig.copy(config, list[0]); // db.Store(list[0]); // } //} //finally //{ // db.Close(); //} }
public static serialPortConfig getDefaultConfig() { serialPortConfig config = null; string port_name = string.Empty; string baut_rate = string.Empty; string sql = "select vvalue from sys_config where vkey = '{0}'"; DataTable dt_temp = CsharpSQLiteHelper.ExecuteTable(sql, new object[1] { "port_name" }); if (dt_temp.Rows.Count > 0) { port_name = dt_temp.Rows[0]["vvalue"].ToString(); } sql = "select vvalue from sys_config where vkey = '{0}'"; dt_temp = CsharpSQLiteHelper.ExecuteTable(sql, new object[1] { "baut_rate" }); if (dt_temp.Rows.Count > 0) { baut_rate = dt_temp.Rows[0]["vvalue"].ToString(); } config = new serialPortConfig(port_name, baut_rate); //IObjectContainer db = Db4oFactory.OpenFile(serialPortConfig.configFilePath); //try //{ // IList<serialPortConfig> list = db.Query<serialPortConfig>(delegate(serialPortConfig cf) // { // return cf.configName == "default"; // } // ); // if (list.Count > 0) // { // config = list[0]; // } //} //finally //{ // db.Close(); //} return(config); }
void frmUserIdentify_Shown(object sender, EventArgs e) { if (Program.g_zkfp_handle != -1) { Program.g_ZKFP.FreeFPCacheDB(Program.g_zkfp_handle); Program.g_zkfp_handle = -1; } Program.g_zkfp_handle = Program.g_ZKFP.CreateFPCacheDB(); //加入保存的指纹模板 index = 0; //List<object> keys = nsConfigDB.ConfigDB.getKeys(); //foreach (object key in keys) //{ // string tmp = (string)nsConfigDB.ConfigDB.getConfig((string)key); // index++; // Program.g_ZKFP.AddRegTemplateStrToFPCacheDB(Program.g_zkfp_handle, index, tmp); // index_user_list.Add(index, (string)key); //} string select_all = "select p.xh, p.xm," + " f.print " + ", pe.nj \"年级\", pe.bj \"班级\", pe.tel \"电话\", pe.email \"邮箱\" " + " from person_info_min as p,person_finger_print as f ,person_expand_info as pe" + " where p.xh=f.xh and p.xh=pe.xh order by p.xh;"; this.person_list = CsharpSQLiteHelper.ExecuteTable(select_all, null); foreach (DataRow dr in this.person_list.Rows) { string id = dr["xh"].ToString(); string tmp = dr["print"].ToString(); index++; Program.g_ZKFP.AddRegTemplateStrToFPCacheDB(Program.g_zkfp_handle, index, tmp); index_user_list.Add(index, id); } this.refresh_check_list(); //开始1:N识别 Program.g_ZKFP.SetAutoIdentifyPara(true, Program.g_zkfp_handle, 8); this.matrixCircularProgressControl1.Start(); }
void refresh_check_list() { // 初始化待考勤人员列表 string select_not_checked = "select p.xh \"学号\", p.xm \"姓名\" " + "from person_info_min as p where p.xh not in(select xh from CheckRecords where record_id = '{0}');"; DataTable dt_not_checked = CsharpSQLiteHelper.ExecuteTable(select_not_checked, new object[] { this.unique_check_id }); this.dgvNotChecked.DataSource = dt_not_checked; this.gbNotChecked.Text = string.Format("待考勤共{0}人", dt_not_checked.Rows.Count.ToString()); //初始化已考勤人员 string select_checked = "select p.xh \"学号\", p.xm \"姓名\" " + "from person_info_min as p where p.xh in(select xh from CheckRecords where record_id = '{0}');"; DataTable dt_checked = CsharpSQLiteHelper.ExecuteTable(select_checked, new object[] { this.unique_check_id }); this.dgvChecked.DataSource = dt_checked; this.gbChecked.Text = string.Format("已考勤共{0}人", dt_checked.Rows.Count.ToString()); this.format_dgv(this.dgvChecked); this.format_dgv(this.dgvNotChecked); }
private void btnDelete_Click(object sender, EventArgs e) { string message = "确定要删除学号为【" + txtId.Text + "】的学生记录吗?"; string caption = "删除确认"; MessageBoxButtons buttons = MessageBoxButtons.YesNo; DialogResult result; // Displays the MessageBox. result = MessageBox.Show(message, caption, buttons); if (result == System.Windows.Forms.DialogResult.Yes) { string strID = txtId.Text; this.bRefreshParentForm = true; string delete_person = string.Format("delete from person_info_min where xh='{0}';" + "delete from person_finger_print where xh='{0}';" + "delete from person_expand_info where xh='{0}';", strID); int r = CsharpSQLiteHelper.ExecuteNonQuery(delete_person, null); //bDeleted = rfidCheck_CheckOn.PersonDelete(new Person(txtId.Text, // txtName.Text, // txtTel.Text, // txtMail.Text, // txtbj.Text, // txtnj.Text, // null)); if (r > 0) { ShowPerson(); SetLabelContent(); MessageBox.Show("学号" + txtId.Text + "已经删除!!"); } else { MessageBox.Show("数据删除时出现异常!", "异常提示"); } } }
private void btnAdd_Click(object sender, EventArgs e) { string strID = txtId.Text; if (strID.Length < 0) { MessageBox.Show("请输入学号!"); return; } //if (strID.Length < 0 || strID.Length > 6 || !Regex.IsMatch(strID, "[0-9]{6}")) //{ // MessageBox.Show("学号应为六位数字!"); // return; //} Func <string, bool> check_id_exists = id => { string select_id = "select xh from person_info_min where xh={0}"; DataTable dt = CsharpSQLiteHelper.ExecuteTable(select_id, new object[] { id }); return(dt.Rows.Count > 0 ? true : false); }; if (check_id_exists(strID)) { MessageBox.Show ("已存在学号为" + strID + "的学生!"); return; } else { string name = txtName.Text; string nj = txtnj.Text; string bj = txtbj.Text; string tel = txtTel.Text; string email = txtMail.Text; string insert_person = string.Format("insert into person_info_min values('{0}','{1}');", strID, name) + string.Format("insert into person_expand_info(xh,nj_name,bj_name,tel,email) values('{0}','{1}','{2}','{3}', '{4}');", strID, nj, bj, tel, email) + string.Format("insert into person_finger_print values('{0}','');", strID); int r = CsharpSQLiteHelper.ExecuteNonQuery(insert_person, null); if (r > 0) { MessageBox.Show("学号为" + txtId.Text + "的学生新增完成!"); } } ShowPerson(); SetLabelContent(); //if (writeData) //{ // rfidCheck_CheckOn.PersonAdd(new Person(txtId.Text, // txtName.Text, // txtTel.Text, // txtMail.Text, // txtbj.Text, // txtnj.Text, // null)); // MessageBox.Show("学号为" + txtId.Text + // "的学生新增完成!"); // this.bRefreshParentForm = true; //} //dataGridView1.DataSource = myDataSet.Tables["student"]; }