public async Task DrawModel(aModel m, CommonClass.databaseModel.detailmodel dm, WebSocket webSocket)
{
//this.ID = "n" + Guid.NewGuid().ToString("N");
var sn = new
{
c = "DrawModel",
WebSocketID = 0,
aModel = m,
id = dm.modelID,
x = dm.x,
y = dm.y,
z = dm.z,
r = dm.rotatey
};
var sendMsg = Newtonsoft.Json.JsonConvert.SerializeObject(sn);
var sendData = Encoding.ASCII.GetBytes(sendMsg);
await webSocket.SendAsync(new ArraySegment <byte>(sendData, 0, sendData.Length), WebSocketMessageType.Text, true, CancellationToken.None);
}
public static void Update(CommonClass.databaseModel.detailmodel item)
{
using (MySqlConnection con = new MySqlConnection(Connection.ConnectionStr))
{
con.Open();
using (MySqlTransaction tran = con.BeginTransaction())
{
try
{
{
string sQL = @"UPDATE detailmodel SET
x=@x,
y=@y,
z=@z,
rotatey=@rotatey
WHERE modelID=@modelID";
// long moneycount;
using (MySqlCommand command = new MySqlCommand(sQL, con, tran))
{
command.Parameters.AddWithValue("@x", item.x);
command.Parameters.AddWithValue("@y", item.y);
command.Parameters.AddWithValue("@z", item.z);
command.Parameters.AddWithValue("@rotatey", item.rotatey);
command.Parameters.AddWithValue("@modelID", item.modelID);
command.ExecuteNonQuery();
}
}
tran.Commit();
}
catch (Exception e)
{
throw e;
throw new Exception("新增错误");
}
}
}
}
public static void Add(CommonClass.databaseModel.detailmodel item)
{
using (MySqlConnection con = new MySqlConnection(Connection.ConnectionStr))
{
con.Open();
using (MySqlTransaction tran = con.BeginTransaction())
{
try
{
bool hasValue;
// long moneycount;
{
string sQL = @"SELECT
modelID
FROM
detailmodel WHERE modelID=@modelID";
// long moneycount;
using (MySqlCommand command = new MySqlCommand(sQL, con, tran))
{
command.Parameters.AddWithValue("@modelID", item.modelID);
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
hasValue = true;
}
else
{
hasValue = false;
}
}
}
}
if (hasValue)
{
string sQL = @"UPDATE detailmodel SET
x=@x,
y=@y,
z=@z,
rotatey=@rotatey
WHERE modelID=@modelID";
// long moneycount;
using (MySqlCommand command = new MySqlCommand(sQL, con, tran))
{
command.Parameters.AddWithValue("@x", item.x);
command.Parameters.AddWithValue("@y", item.y);
command.Parameters.AddWithValue("@z", item.z);
command.Parameters.AddWithValue("@rotatey", item.rotatey);
command.Parameters.AddWithValue("@modelID", item.rotatey);
command.ExecuteNonQuery();
}
}
else
{
string sQL = @"INSERT INTO detailmodel(modelID,x,y,z,amodel,rotatey)VALUES(@modelID,@x,@y,@z,@amodel,@rotatey)";
// long moneycount;
using (MySqlCommand command = new MySqlCommand(sQL, con, tran))
{
command.Parameters.AddWithValue("@modelID", item.modelID);
command.Parameters.AddWithValue("@x", item.x);
command.Parameters.AddWithValue("@y", item.y);
command.Parameters.AddWithValue("@z", item.z);
command.Parameters.AddWithValue("@amodel", item.amodel);
command.Parameters.AddWithValue("@rotatey", item.rotatey);
command.ExecuteNonQuery();
}
}
tran.Commit();
}
catch (Exception e)
{
throw e;
throw new Exception("新增错误");
}
}
}
}
