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