From 200ce83f5c9410ac6926584632ed117a2b7cd2de Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期五, 22 十二月 2023 16:14:49 +0800
Subject: [PATCH] 完成接口开发
---
JiangSu/cs/ModelDAL.cs | 20 +++++++++++++++++++-
1 files changed, 19 insertions(+), 1 deletions(-)
diff --git a/JiangSu/cs/ModelDAL.cs b/JiangSu/cs/ModelDAL.cs
index 45be61d..7ac5217 100644
--- a/JiangSu/cs/ModelDAL.cs
+++ b/JiangSu/cs/ModelDAL.cs
@@ -43,6 +43,24 @@
return list.ToArray();
}
+ public static List<Model> SelectByPage(string name, int pageSize = 10, int pageIndex = 1)
+ {
+ string sql = string.Format("select * from model where upper(name) like @name order by id limit {0} offset {1}", pageSize, pageSize * (pageIndex - 1));
+
+ SQLiteParameter param = new SQLiteParameter("@name");
+ param.Value = "%" + name.ToUpper() + "%";
+
+ DataTable dt = SQLiteHelper.GetDataTable(sql, param);
+ if (null == dt || dt.Rows.Count == 0)
+ {
+ return null;
+ }
+
+ List<Model> list = ModelHandler.FillModel<Model>(dt);
+
+ return list;
+ }
+
public static Model SelectById(long id)
{
string sql = "select * from model where id = @id";
@@ -69,7 +87,7 @@
return SQLiteHelper.ExecuteNonQuery(sql);
}
- public static int insert(Model model)
+ public static int Insert(Model model)
{
string sql = "insert into model (name, json) values (@name, @json)";
SQLiteParameter[] sqlParams = GetParams<Model>(sql, model);
--
Gitblit v1.9.3