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 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 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"]; }