Grove kit 2008 Curd 类

最新推荐文章于 2024-06-13 09:59:29 发布

zhangchuccc

最新推荐文章于 2024-06-13 09:59:29 发布

阅读量1k

点赞数

CC 4.0 BY-SA版权

分类专栏： Asp.Net 文章标签： filter query list string null oo

本文链接：https://blog.youkuaiyun.com/zhangchuccc/article/details/5831521

Asp.Net 专栏收录该内容

8 篇文章

订阅专栏

本文介绍了一个使用Grovekit2008框架进行数据库操作的示例，包括增删改查等功能的实现。展示了如何通过C#进行数据库交互，如获取所有记录、分页查询等。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

公司主要采用的是Grove kit 2008 来做开发,以下是一个基于Grove增删改查的代码

using System; using System.Collections.Generic; using System.Linq; using System.Text; using Grove; using Grove.ORM; using System.Collections; namespace SH.Business { /// <summary> /// 表LSP_INFO,增删改查(CURD)操作 /// zc 2010-8-23 /// </summary> public class LSPCurd { /// <summary> /// 返回所有记录 /// </summary> /// <param name="filter"></param> /// <returns></returns> public IList<LSP_INFO> GetLspInfo(string filter) { IList<LSP_INFO> list = null; ObjectOperator oo = new ObjectOperator(DBConnect.DBName); IObjectQuery query = new PersistObjectQuery(typeof(LSP_INFO)); query.Filter = filter; ArrayList alt = oo.GetObjectSet(query); if (alt != null) { list = alt.Cast<LSP_INFO>().ToList(); } return list; } /// <summary> /// 获得信息条数 /// </summary> /// <param name="filter"></param> /// <returns></returns> public int GetLspInfoCount(string filter) { int Count = 0; ObjectOperator oo = new ObjectOperator(DBConnect.DBName); IObjectQuery query = new PersistObjectQuery(typeof(LSP_INFO)); if (!string.IsNullOrEmpty(filter)) { query.Filter = filter; } Count = oo.GetCount(query); return Count; } /// <summary> /// 修改信息 /// </summary> /// <param name="info"></param> /// <returns></returns> public bool UpdateLspInfo(LSP_INFO info) { bool result = false; ObjectOperator oo = new ObjectOperator(DBConnect.DBName); oo.BeginTranscation(); int i = oo.Update(info); if (i > 0) { result = true; } return result; } /// <summary> /// 删除信息 /// </summary> /// <param name="filter"></param> /// <returns></returns> public bool DeleteLspInfo(string filter) { bool result = false; ObjectOperator oo = new ObjectOperator(); oo.BeginTranscation(); int i = oo.Remove(typeof(LSP_INFO), filter); if (i > 0) { result = true; } if (result) { oo.Commit(); } else { oo.Rollback(); } return result; } /// <summary> /// 新增信息 /// </summary> /// <param name="depart"></param> /// <param name="obj"></param> /// <returns></returns> public bool InsertLspInfo(LSP_INFO info) { bool result = false; ObjectOperator oo = new ObjectOperator(); oo.BeginTranscation(); int i = oo.Insert(info); if (i > 0) { result = true; } return result; } /// <summary> /// 分页显示记录 /// </summary> /// <param name="filter"></param> /// <param name="StartRecord"></param> /// <param name="EndRecord"></param> /// <returns></returns> public IList<LSP_INFO> GetLspInfoPage(string filter, int StartRecord, int EndRecord) { IList<LSP_INFO> list = null; ObjectOperator oo = new ObjectOperator(DBConnect.DBName); IObjectQuery query = new PersistObjectQuery(typeof(LSP_INFO)); if (!string.IsNullOrEmpty(filter)) { query.Filter = filter; } ArrayList alt = oo.GetObjectSet(query, StartRecord, EndRecord); if (alt != null) { list = alt.Cast<LSP_INFO>().ToList(); } return list; } } }