//删除管理区域
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);
}
