From 5ddadba291ea2d9dba78259973594a4664b94f57 Mon Sep 17 00:00:00 2001
From: C3032 <C3032@BC3032>
Date: 星期四, 08 一月 2026 16:45:35 +0800
Subject: [PATCH] 简化相机逻辑，支持手动数据处理
---
LB_SmartVision/SQL/DatabaseRecordProductDataHelper.cs | 72 ++++++++++++++++++++++++++++++++++++
1 files changed, 72 insertions(+), 0 deletions(-)
diff --git a/LB_SmartVision/SQL/DatabaseRecordProductDataHelper.cs b/LB_SmartVision/SQL/DatabaseRecordProductDataHelper.cs
new file mode 100644
index 0000000..ae357bf
--- /dev/null
+++ b/LB_SmartVision/SQL/DatabaseRecordProductDataHelper.cs
@@ -0,0 +1,72 @@
+锘縰sing LB_SmartVisionCommon;
+using MySql.Data.MySqlClient;
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace LB_SmartVision.SQL
+{
+ public class DatabaseRecordProductDataHelper
+ {
+ private static string connectionString = "Server=localhost;Database=product_db;Uid=root;Pwd=root;";
+ private static object databaseRecordProductDataHelperObject = new object();
+ public static MySqlConnection GetConnection()
+ {
+ return new MySqlConnection(connectionString);
+ }
+ // 鍒涘缓鏁版嵁搴撳拰琛�
+ public static void InitializeDatabase()
+ {
+ lock (databaseRecordProductDataHelperObject)
+ {
+ try
+ {
+ using (var connection = GetConnection())
+ {
+ connection.Open();
+ // 鍒涘缓鏁版嵁搴�
+ string createDbSql = @"CREATE DATABASE IF NOT EXISTS product_db;";
+ using (var cmd = new MySqlCommand(createDbSql, connection))
+ {
+ cmd.ExecuteNonQuery();
+ }
+ // 浣跨敤鏁版嵁搴�
+ string useDbSql = @"USE product_db;";
+ using (var cmd = new MySqlCommand(useDbSql, connection))
+ {
+ cmd.ExecuteNonQuery();
+ }
+ // 鍒涘缓琛紙澧炲姞绱㈠紩浠ユ彁楂樻煡璇㈡�ц兘锛�
+ string createTableSql = @"
+ CREATE TABLE IF NOT EXISTS RecordProductData (
+ Id INT AUTO_INCREMENT PRIMARY KEY,
+ ProductName VARCHAR(255) NOT NULL,
+ ProductSN VARCHAR(255) NOT NULL,
+ InspectionOperator VARCHAR(255),
+ NGType VARCHAR(255),
+ NGSize VARCHAR(255),
+ DetectionTime VARCHAR(255)),
+ CameraInspection VARCHAR(255),
+ CreatedDate DATETIME DEFAULT CURRENT_TIMESTAMP,
+ INDEX idx_created_date (CreatedDate),
+ INDEX idx_product_number (ProductSN),
+ INDEX idx_operator (InspectionOperator)
+ );";
+ using (var cmd = new MySqlCommand(createTableSql, connection))
+ {
+ cmd.ExecuteNonQuery();
+ AsyncLogHelper.Info("鏁版嵁搴撳拰琛ㄥ垱寤烘垚鍔燂紒");
+ }
+ }
+ }
+ catch (Exception ex)
+ {
+ AsyncLogHelper.Error($"鏁版嵁搴撳垵濮嬪寲澶辫触: {ex.Message}");
+ throw;
+ }
+ }
+ }
+ }
+}
--
Gitblit v1.9.3