From 124102d5db2a2ace2f2d8484ceda658829657552 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期六, 06 一月 2024 14:14:52 +0800
Subject: [PATCH] 图片表的sql操作
---
JiangSu/cs/ModelDAL.cs | 36 ++----------------------------------
1 files changed, 2 insertions(+), 34 deletions(-)
diff --git a/JiangSu/cs/ModelDAL.cs b/JiangSu/cs/ModelDAL.cs
index e21ad70..9267467 100644
--- a/JiangSu/cs/ModelDAL.cs
+++ b/JiangSu/cs/ModelDAL.cs
@@ -11,38 +11,6 @@
{
public class ModelDAL
{
- /// <summary>
- /// 鑾峰彇鍙傛暟鍒楄〃
- /// </summary>
- public static SQLiteParameter[] GetParams<T>(string sql, T t)
- {
- List<SQLiteParameter> list = new List<SQLiteParameter>();
- Type tType = typeof(T);
- BindingFlags flags = BindingFlags.Public | BindingFlags.IgnoreCase | BindingFlags.Instance;
-
- int start = sql.IndexOf("@");
- while (start != -1)
- {
- int end = sql.IndexOf(",", start);
- if (end == -1) end = sql.IndexOf(")", start);
- if (end == -1) end = sql.IndexOf(" ", start);
- if (end == -1) end = sql.Length;
-
- string name = sql.Substring(start + 1, end - start - 1);
- PropertyInfo pi = tType.GetProperty(name, flags);
- if (pi != null)
- {
- object value = pi.GetValue(t, null);
- SQLiteParameter dp = new SQLiteParameter("@" + name, value);
- list.Add(dp);
- }
-
- start = sql.IndexOf("@", end);
- }
-
- return list.ToArray();
- }
-
public static List<Model> SelectByPage(string name, int pageSize = 10, int pageIndex = 1)
{
bool flag = string.IsNullOrWhiteSpace(name);
@@ -88,7 +56,7 @@
public static int Insert(Model model)
{
string sql = "insert into model (name, json) values (@name, @json);select last_insert_rowid();";
- SQLiteParameter[] sqlParams = GetParams<Model>(sql, model);
+ SQLiteParameter[] sqlParams = Tools.GetSQLiteParams<Model>(sql, model);
//return SQLiteHelper.ExecuteNonQuery(sql, sqlParams);
@@ -99,7 +67,7 @@
public static int UpdateById(Model model)
{
string sql = "update model set name = @name, json = @json where id = @id";
- SQLiteParameter[] sqlParams = GetParams<Model>(sql, model);
+ SQLiteParameter[] sqlParams = Tools.GetSQLiteParams<Model>(sql, model);
return SQLiteHelper.ExecuteNonQuery(sql, sqlParams);
}
--
Gitblit v1.9.3