Fm.Bussiness/Formpage.cs

（开头部分） 4KB

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

using System;
using System.Collections.Generic;
using System.Text;
using Fm.DataAccess;
using System.Data;
using System.Data.Common;
using System.Collections;

namespace Fm.Bussiness
{
    public class Formpage
    {
        public Formpage()
        {
            //
            // TODO: 在此处添加构造函数逻辑
            //
        }
        /// <summary>
        /// 带条件的分页查询(自定义排序类型的:0升序;1 排序)
        /// </summary>
        /// <param name="tablename"></param>
        /// <param name="colname"></param>
        /// <returns></returns>
        public IList PageView_ByOrder(string tablename, string colname, int pagesize, int pageindex, string where,int order)
        {
            DbCommand db = DataAccess.DataAccess.db.GetStoredProcCommand("Fm_GetRecordFromPage");
            DataAccess.DataAccess.db.AddInParameter(db, "@tblName", DbType.String, tablename);
            DataAccess.DataAccess.db.AddInParameter(db, "@fldName", DbType.String, colname);
            DataAccess.DataAccess.db.AddInParameter(db, "@PageSize", DbType.Int32, pagesize);
            DataAccess.DataAccess.db.AddInParameter(db, "@PageIndex", DbType.Int32, pageindex);
            DataAccess.DataAccess.db.AddInParameter(db, "@OrderType", DbType.Boolean, order);
            DataAccess.DataAccess.db.AddInParameter(db, "@strWhere", DbType.String, where);
            return DataAccess.DataAccess.GetData.Select<DbCommand>(db);
        }
        /// <summary>
        /// 带条件的分页查询
        /// </summary>
        /// <param name="tablename"></param>
        /// <param name="colname"></param>
        /// <returns></returns>
        public IList PageView_Bywhere(string tablename, string colname, int pagesize, int pageindex, string where)
        {
            DbCommand db = DataAccess.DataAccess.db.GetStoredProcCommand("Fm_GetRecordFromPage");
            DataAccess.DataAccess.db.AddInParameter(db, "@tblName", DbType.String, tablename);
            DataAccess.DataAccess.db.AddInParameter(db, "@fldName", DbType.String, colname);
            DataAccess.DataAccess.db.AddInParameter(db, "@PageSize", DbType.Int32, pagesize);
            DataAccess.DataAccess.db.AddInParameter(db, "@PageIndex", DbType.Int32, pageindex);
            DataAccess.DataAccess.db.AddInParameter(db, "@OrderType", DbType.Boolean, 1);
            DataAccess.DataAccess.db.AddInParameter(db, "@strWhere", DbType.String, where);
            return DataAccess.DataAccess.GetData.Select<DbCommand>(db);
        }

        /// <summary>
        /// 查询数据的总记录数
        /// </summary>
        /// <param name="tablename"></param>
        /// <param name="colname"></param>
        /// <returns></returns>
        public IList PageRow(string tablename, string colname, int pagesize, int pageindex, string where)
后面还有 32 行代码，解锁后查看完整代码

24 小时内免费解锁 3 个项目，之后 1 积分/个。 规则说明

AI 解读

登录后可用，每次 10 积分，解读结果公开显示在下面。

还没有人解读过这个文件。