/*查询数据 * 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); }