From 5811f0b9f7879766dc1f6166ad538f562cbce045 Mon Sep 17 00:00:00 2001
From: cdk <2441919651@qq.com>
Date: 星期一, 30 六月 2025 15:41:44 +0800
Subject: [PATCH] 修改成扫码报工
---
SQL/SQLHelper.cs | 38 ++++++++++++++++++++++++++++++++++++++
1 files changed, 38 insertions(+), 0 deletions(-)
diff --git a/SQL/SQLHelper.cs b/SQL/SQLHelper.cs
index 2e296dc..86bd0f8 100644
--- a/SQL/SQLHelper.cs
+++ b/SQL/SQLHelper.cs
@@ -180,6 +180,44 @@
}
return dataTable;
}
+
+ public DataTable ExecuteStoredProcedure(string procedureName, SqlParameter[] parameters = null)
+ {
+ try
+ {
+ using (SqlConnection connection = new SqlConnection(_connectionString))
+ {
+ using (SqlCommand command = new SqlCommand(procedureName, connection))
+ {
+ command.CommandType = CommandType.StoredProcedure;
+
+ // 娣诲姞鍙傛暟锛堝鏋滃瓨鍦級
+ if (parameters != null && parameters.Length > 0)
+ {
+ command.Parameters.AddRange(parameters);
+ }
+
+ connection.Open();
+
+ // 鍒涘缓DataTable瀛樺偍缁撴灉
+ DataTable resultTable = new DataTable();
+
+ // 浣跨敤SqlDataAdapter濉厖DataTable
+ using (SqlDataAdapter adapter = new SqlDataAdapter(command))
+ {
+ adapter.Fill(resultTable);
+ }
+
+ return resultTable;
+ }
+ }
+ }
+ catch (Exception ex)
+ {
+ return null;
+ }
+ }
+
public int ExecuteNonQuery(string sql)
{
return this.ExecuteNonQuery(sql, CommandType.Text, null);
--
Gitblit v1.9.3