MyTable.cs
上传用户:simon2hong
上传日期:2021-11-18
资源大小:16746k
文件大小:7k
- //------------------------------------------------------------------------------
- // 创建标识: Copyright (C) 2009 Socansoft.com 版权所有
- // 创建描述: SocanCode代码生成器 V4.3.2.3 自动创建于 2009-11-15 20:10:34
- //
- // 功能描述:
- //
- // 修改标识:
- // 修改描述:
- //------------------------------------------------------------------------------
- using System;
- using System.Data;
- using System.Data.Common;
- using System.Text;
- using System.Collections;
- using System.Collections.Generic;
- namespace SqlServerDAL
- {
- /// <summary>
- /// 数据访问类 MyTable
- /// </summary>
- public class MyTable : DALHelper
- {
- /// <summary>
- /// 增加一条数据
- /// </summary>
- public int Add(Model.MyTable model)
- {
- model.ModuleId = GetMaxId() + 1;
- StringBuilder strSql = new StringBuilder();
- strSql.Append("INSERT INTO MyTable(");
- strSql.Append("ModuleId,FuncId,ModuleName,ModulePos,ModuleNo,ModuleControl,ViewType)");
- strSql.Append(" VALUES (");
- strSql.Append("@in_ModuleId,@in_FuncId,@in_ModuleName,@in_ModulePos,@in_ModuleNo,@in_ModuleControl,@in_ViewType)");
DbParameter[] cmdParms = {
- DataBaseOAHelper.CreateInDbParameter("@in_ModuleId", DbType.Int32, model.ModuleId),
- DataBaseOAHelper.CreateInDbParameter("@in_FuncId", DbType.Int32, model.FuncId),
- DataBaseOAHelper.CreateInDbParameter("@in_ModuleName", DbType.String, model.ModuleName),
- DataBaseOAHelper.CreateInDbParameter("@in_ModulePos", DbType.AnsiStringFixedLength, model.ModulePos),
- DataBaseOAHelper.CreateInDbParameter("@in_ModuleNo", DbType.String, model.ModuleNo),
- DataBaseOAHelper.CreateInDbParameter("@in_ModuleControl", DbType.String, model.ModuleControl),
- DataBaseOAHelper.CreateInDbParameter("@in_ViewType", DbType.Int32, model.ViewType)};
- return DataBaseOAHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), cmdParms);
- }
- /// <summary>
- /// 更新一条数据
- /// </summary>
- public int Update(Model.MyTable model)
- {
- StringBuilder strSql = new StringBuilder();
- strSql.Append("UPDATE MyTable SET ");
- strSql.Append("FuncId=@in_FuncId,");
- strSql.Append("ModuleName=@in_ModuleName,");
- strSql.Append("ModulePos=@in_ModulePos,");
- strSql.Append("ModuleNo=@in_ModuleNo,");
- strSql.Append("ModuleControl=@in_ModuleControl,");
- strSql.Append("ViewType=@in_ViewType");
- strSql.Append(" WHERE ModuleId=@in_ModuleId");
- DbParameter[] cmdParms = {
- DataBaseOAHelper.CreateInDbParameter("@in_FuncId", DbType.Int32, model.FuncId),
- DataBaseOAHelper.CreateInDbParameter("@in_ModuleName", DbType.String, model.ModuleName),
- DataBaseOAHelper.CreateInDbParameter("@in_ModulePos", DbType.AnsiStringFixedLength, model.ModulePos),
- DataBaseOAHelper.CreateInDbParameter("@in_ModuleNo", DbType.String, model.ModuleNo),
- DataBaseOAHelper.CreateInDbParameter("@in_ModuleControl", DbType.String, model.ModuleControl),
- DataBaseOAHelper.CreateInDbParameter("@in_ViewType", DbType.Int32, model.ViewType),
- DataBaseOAHelper.CreateInDbParameter("@in_ModuleId", DbType.Int32, model.ModuleId)};
- return DataBaseOAHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), cmdParms);
- }
- /// <summary>
- /// 删除一条数据
- /// </summary>
- public int Delete(int ModuleId)
- {
- StringBuilder strSql = new StringBuilder();
- strSql.Append("DELETE FROM MyTable ");
- strSql.Append(" WHERE ModuleId=@in_ModuleId");
- DbParameter[] cmdParms = {
- DataBaseOAHelper.CreateInDbParameter("@in_ModuleId", DbType.Int32, ModuleId)};
- return DataBaseOAHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), cmdParms);
- }
- /// <summary>
- /// 得到最大ID
- /// </summary>
- public int GetMaxId()
- {
- object obj = DataBaseOAHelper.ExecuteScalar(CommandType.Text, "SELECT MAX(ModuleId) FROM MyTable", null);
- return DataBaseOAHelper.GetInt(obj);
- }
- /// <summary>
- /// 是否存在该记录
- /// </summary>
- public bool Exists(int ModuleId)
- {
- StringBuilder strSql = new StringBuilder();
- strSql.Append("SELECT COUNT(1) FROM MyTable");
- strSql.Append(" WHERE ModuleId=@in_ModuleId");
- DbParameter[] cmdParms = {
- DataBaseOAHelper.CreateInDbParameter("@in_ModuleId", DbType.Int32, ModuleId)};
- object obj = DataBaseOAHelper.ExecuteScalar(CommandType.Text, strSql.ToString(), cmdParms);
- return DataBaseOAHelper.GetInt(obj) > 0;
- }
- /// <summary>
- /// 得到一个对象实体
- /// </summary>
- public Model.MyTable GetModel(int ModuleId)
- {
- StringBuilder strSql = new StringBuilder();
- strSql.Append("SELECT * FROM MyTable ");
- strSql.Append(" WHERE ModuleId=@in_ModuleId");
- DbParameter[] cmdParms = {
- DataBaseOAHelper.CreateInDbParameter("@in_ModuleId", DbType.Int32, ModuleId)};
- Model.MyTable model = null;
- using (DbDataReader dr = DataBaseOAHelper.ExecuteReader(CommandType.Text, strSql.ToString(), cmdParms))
- {
- while (dr.Read())
- {
- model = GetModel(dr);
- }
- return model;
- }
- }
- /// <summary>
- /// 获取泛型数据列表
- /// </summary>
- public List<Model.MyTable> GetList()
- {
- StringBuilder strSql = new StringBuilder("SELECT * FROM MyTable");
- using (DbDataReader dr = DataBaseOAHelper.ExecuteReader(CommandType.Text, strSql.ToString(), null))
- {
- List<Model.MyTable> lst = GetList(dr);
- return lst;
- }
- }
- /// <summary>
- /// 得到数据条数
- /// </summary>
- public int GetCount(string condition)
- {
- return DataBaseOAHelper.GetCount("MyTable", condition);
- }
- /// <summary>
- /// 分页获取泛型数据列表
- /// </summary>
- public List<Model.MyTable> GetPageList(int pageSize, int pageIndex, string fldSort, bool fldDir, string condition)
- {
- using (DbDataReader dr = DataBaseOAHelper.GetPageList("MyTable", pageSize, pageIndex, fldSort, fldDir, condition))
- {
- List<Model.MyTable> lst = GetList(dr);
- return lst;
- }
- }
- #region -------- 私有方法,通常情况下无需修改 --------
- /// <summary>
- /// 由一行数据得到一个实体
- /// </summary>
- private Model.MyTable GetModel(DbDataReader dr)
- {
- Model.MyTable model = new Model.MyTable();
- model.ModuleId = DataBaseOAHelper.GetInt(dr["ModuleId"]);
- model.FuncId = DataBaseOAHelper.GetInt(dr["FuncId"]);
- model.ModuleName = DataBaseOAHelper.GetString(dr["ModuleName"]);
- model.ModulePos = DataBaseOAHelper.GetString(dr["ModulePos"]);
- model.ModuleNo = DataBaseOAHelper.GetString(dr["ModuleNo"]);
- model.ModuleControl = DataBaseOAHelper.GetString(dr["ModuleControl"]);
- model.ViewType = DataBaseOAHelper.GetInt(dr["ViewType"]);
- return model;
- }
- /// <summary>
- /// 由DbDataReader得到泛型数据列表
- /// </summary>
- private List<Model.MyTable> GetList(DbDataReader dr)
- {
- List<Model.MyTable> lst = new List<Model.MyTable>();
- while (dr.Read())
- {
- lst.Add(GetModel(dr));
- }
- return lst;
- }
- #endregion
- }
- }