From 2f0fe710bf011d4f0051339bfbfebb597bff1a50 Mon Sep 17 00:00:00 2001
From: zs <zhousong@weben-smart.com>
Date: 周三, 06 11月 2024 13:35:02 +0800
Subject: [PATCH] 切换数据库为mysql
---
DataCapture_MA/Form1.cs | 42 +++++++++++++++++++++++++-----------------
1 files changed, 25 insertions(+), 17 deletions(-)
diff --git a/DataCapture_MA/Form1.cs b/DataCapture_MA/Form1.cs
index c737007..a930e1c 100644
--- a/DataCapture_MA/Form1.cs
+++ b/DataCapture_MA/Form1.cs
@@ -130,27 +130,35 @@
private void CreateDatabase()
{
- using (var context = new DbModel())
+ try
{
- // 纭繚鏁版嵁搴撳拰琛ㄥ瓨鍦紝濡傛灉涓嶅瓨鍦ㄥ垯鍒涘缓
- context.Database.EnsureCreated();
-
- // 娣诲姞涓�浜涙暟鎹�
- context.RobotInfo.Add(new RobotInfo
+ using (var context = new DbModel())
{
- WarnningNum = 0,
- //RobotStatus = "Normal",
- RobotModel = "Model X",
- RobotSerialNo = "123456",
- WarnningContent = "娓呴櫎瀵屾枃鏈鏁版嵁",
- CreateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
- IsDelete = false
- });
+ // 纭繚鏁版嵁搴撳拰琛ㄥ瓨鍦紝濡傛灉涓嶅瓨鍦ㄥ垯鍒涘缓
+ context.Database.EnsureCreated();
- // 淇濆瓨鏇存敼
- context.SaveChanges();
+ // 娣诲姞涓�浜涙暟鎹�
+ context.RobotInfo.Add(new RobotInfo
+ {
+ WarnningNum = 0,
+ //RobotStatus = "Normal",
+ RobotModel = "Model X",
+ RobotSerialNo = "123456",
+ WarnningContent = "娓呴櫎瀵屾枃鏈鏁版嵁",
+ CreateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
+ CreateStamp = DateTimeOffset.Now.ToUnixTimeSeconds(),
+ IsDelete = false
+ });
- var xx = context.RobotInfo.ToList();
+ // 淇濆瓨鏇存敼
+ context.SaveChanges();
+
+ var xx = context.RobotInfo.ToList();
+ }
+ }
+ catch (Exception ex)
+ {
+ r_showBox.Text = "鏁版嵁搴撳垵濮嬪寲寮傚父"+ ex.Message;
}
}
--
Gitblit v1.9.3