//监管机器 public Boolean Listening(String uid, String mid) { MySqlConnection con = DBUtils.getConnection(); MySqlCommand cmd = con.CreateCommand(); cmd.CommandText = "SELECT A.UID, A.MID FROM NYMACHINE A WHERE A.UID = ?1 AND A.MID = ?2"; cmd.Parameters.AddWithValue("?1", uid); cmd.Parameters.AddWithValue("?2", mid); MySqlDataReader reader = cmd.ExecuteReader(); try { if (reader.Read()) { return(true); } else { return(false); } } catch { Console.WriteLine("查询失败了!"); } finally { DBUtils.close(con); reader.Close(); } return(false); }
/** * 查询所有的机器 */ public List <Dictionary <String, String> > queryAllm() { MySqlConnection con = DBUtils.getConnection(); MySqlCommand cmd = con.CreateCommand(); cmd.CommandText = "SELECT * FROM MACHINE ORDER BY ID"; MySqlDataReader reader = cmd.ExecuteReader(); try { List <Dictionary <String, String> > list = new List <Dictionary <String, String> >(); while (reader.Read()) { Dictionary <String, String> dir = new Dictionary <string, string>(); for (int i = 0; i < reader.FieldCount; i++) { dir.Add(reader.GetName(i).ToLower(), reader.GetValue(i).ToString()); } list.Add(dir); } return(list); } catch { } finally { DBUtils.close(con); reader.Close(); } return(new List <Dictionary <String, String> >()); }
//检查用户 public Boolean UserIsExisted(String name) { MySqlConnection con = DBUtils.getConnection(); MySqlCommand cmd = con.CreateCommand(); cmd.CommandText = "SELECT ID,NAME,PASSWORD,CHARA FROM USER WHERE NAME = ?1"; cmd.Parameters.AddWithValue("?1", name); MySqlDataReader reader = cmd.ExecuteReader(); try { if (reader.Read()) { return(true); } else { return(false); } } catch { Console.WriteLine("查询失败了!"); } finally { DBUtils.close(con); reader.Close(); } return(false); }
//删除用户 public Boolean delUserById(String id) { MySqlConnection con = DBUtils.getConnection(); try { MySqlCommand cmd1 = con.CreateCommand(); MySqlCommand cmd2 = con.CreateCommand(); cmd1.CommandText = "delete from nymachine where uid = ?1"; cmd1.Parameters.AddWithValue("?1", id); cmd1.ExecuteNonQuery(); cmd2.CommandText = "delete from user where id = ?1"; cmd2.Parameters.AddWithValue("?1", id); return(cmd2.ExecuteNonQuery() > 0); } catch (Exception e) { Console.WriteLine("*" + e.StackTrace); } finally { DBUtils.close(con); } return(false); }
public Dictionary <String, String> login(String name, String password) { MySqlConnection con = DBUtils.getConnection(); MySqlCommand cmd = con.CreateCommand(); cmd.CommandText = "SELECT ID,NAME,PASSWORD,CHARA FROM USER WHERE NAME = ?1 AND PASSWORD = ?2"; cmd.Parameters.AddWithValue("?1", name); cmd.Parameters.AddWithValue("?2", password); MySqlDataReader reader = cmd.ExecuteReader(); try { if (reader.Read()) { Dictionary <String, String> dir = new Dictionary <string, string>(); for (int i = 0; i < reader.FieldCount; i++) { dir.Add(reader.GetName(i).ToLower(), reader.GetValue(i).ToString()); } return(dir); } } catch { Console.WriteLine("查询失败了!"); } finally { DBUtils.close(con); reader.Close(); } return(null); }
/** * 权限管理 */ public List <String> queryGrand(int id) { MySqlConnection con = DBUtils.getConnection(); MySqlCommand cmd = con.CreateCommand(); cmd.CommandText = "SELECT A.NAME FROM MACHINE A, NYMACHINE B WHERE A.ID = B.MID AND B.UID = ?1 AND A.USERING = '1'"; cmd.Parameters.AddWithValue("?1", id); MySqlDataReader reader = cmd.ExecuteReader(); try { List <String> list = new List <String>(); while (reader.Read()) { list.Add(reader.GetValue(0).ToString()); } return(list); } catch {} finally { DBUtils.close(con); reader.Close(); } return(null); }
/*查询数据 * uid : 使用者id * sdt : 起始时间 * edt : 结束时间 * return : Dictionary<dt, val> */ public List <Dictionary <String, String> > queryData(int uid, String sdt, String edt) { MySqlConnection con = DBUtils.getConnection(); MySqlDataReader dr = null; try { MySqlCommand cmd = con.CreateCommand(); cmd.CommandText = "SELECT C.NAME, A.DATAVAL, A.GT FROM DATAS A, USER B, MACHINE C, NYMACHINE D" + " WHERE B.ID=D.UID AND D.MID=C.ID AND C.ID=A.MID AND B.ID=?1 AND A.GT >= ?2 AND A.GT <= ?3"; cmd.Parameters.AddWithValue("?1", uid); cmd.Parameters.AddWithValue("?2", sdt); cmd.Parameters.AddWithValue("?3", edt); if (cmd.ExecuteScalar() != null) { List <Dictionary <String, String> > list = new List <Dictionary <string, string> >(); dr = cmd.ExecuteReader(); while (dr.Read()) { Dictionary <String, String> dir = new Dictionary <string, string>(); for (int i = 0; i < dr.FieldCount; i++) { dir.Add(dr.GetName(i).ToLower(), dr.GetValue(i).ToString()); } list.Add(dir); } return(list); } } catch (Exception e) { Console.WriteLine(e.StackTrace); } finally { DBUtils.close(con); } return(null); }
//添加用户 public Boolean addUser(String name, String password) { MySqlConnection con = DBUtils.getConnection(); try { MySqlCommand cmd = con.CreateCommand(); cmd.CommandText = "insert into user(name, password, chara) values(?1, ?2, '2')"; cmd.Parameters.AddWithValue("?1", name); cmd.Parameters.AddWithValue("?2", password); return(cmd.ExecuteNonQuery() > 0); } catch (Exception e) { Console.WriteLine("*" + e.StackTrace); } finally { DBUtils.close(con); } return(false); }
//修改区域状态 public Boolean updateMachineById(String id, String usering) { MySqlConnection con = DBUtils.getConnection(); try { MySqlCommand cmd = con.CreateCommand(); cmd.CommandText = "update machine set usering = ?1 where id = ?2"; cmd.Parameters.AddWithValue("?1", usering); cmd.Parameters.AddWithValue("?2", id); return(cmd.ExecuteNonQuery() > 0); } catch (Exception e) { Console.WriteLine("*" + e.StackTrace); } finally { DBUtils.close(con); } return(false); }
//删除管理区域 public Boolean delManageArea(String uid, String mid) { Console.WriteLine(uid + " " + mid); MySqlConnection con = DBUtils.getConnection(); try { MySqlCommand cmd = con.CreateCommand(); cmd.CommandText = "delete from nymachine where uid = ?1 and mid = ?2"; cmd.Parameters.AddWithValue("?1", uid); cmd.Parameters.AddWithValue("?2", mid); return(cmd.ExecuteNonQuery() > 0); } catch (Exception e) { Console.WriteLine("*" + e.StackTrace); } finally { DBUtils.close(con); } return(false); }
public static bool insert(int mid, String dt, DataModel dm) { MySqlConnection con = DBUtils.getConnection(); try { String str = ObjectStringSwap.bytes2String(dm.Bs); MySqlCommand cmd = con.CreateCommand(); cmd.CommandText = "insert into datas(mid, dataval, gt) values(?1, ?2, ?3)"; cmd.Parameters.AddWithValue("?1", mid); cmd.Parameters.AddWithValue("?2", str); cmd.Parameters.AddWithValue("?3", dt); return(cmd.ExecuteNonQuery() > 0); } catch (Exception e) { Console.WriteLine("*" + e.StackTrace); } finally { DBUtils.close(con); } return(false); }