翻页Asppage

最新推荐文章于 2022-11-17 19:46:54 发布

飞鸟flyboy

最新推荐文章于 2022-11-17 19:46:54 发布

阅读量367

点赞数

分类专栏： html

本文链接：https://blog.csdn.net/a5251199/article/details/49796935

版权

html 专栏收录该内容

24 篇文章 0 订阅

订阅专栏

/// <summary>
        ///
        /// </summary>
        /// <param name="tabName">表名称</param>
        /// <param name="fieldName">查询的字段名</param>
        /// <param name="fldName">主键名</param>
        /// <param name="pageSize">每页显示数量</param>
        /// <param name="pageIndex">当前页码</param>
        /// <param name="strWhere">增加条件语句</param>
        /// <param name="orderType">排序类别 TRUE 的话是降序排列</param>
        /// <returns></returns>
        public static string Asppage(string tabName, string fieldName, string fldName, int pageSize, int pageIndex, string strWhere, bool orderTyp)
        {
            StringBuilder sbSql = new StringBuilder();
            string strTemp = "";
            string strOrder = "";
            if (orderTyp)
            {
                strOrder = " order by " + fldName + " desc";
                strTemp = " not in (select top " + (pageIndex - 1) * pageSize + " " + fldName + " from " + tabName + strOrder + ")";
            }
            else
            {
                strOrder = " order by " + fldName + " asc";
                strTemp = " not in (select top " + (pageIndex - 1) * pageSize + " " + fldName + " from " + tabName + strOrder + ")";
            }
            if (pageIndex == 1)
            {
                strTemp = "";
                if (!string.IsNullOrEmpty(strWhere.Trim()))
                {
                    strTemp = " WHERE " + strWhere;
                }
                sbSql.Append("select top " + pageSize + " " + fieldName + " FROM " + tabName + " " + strTemp + " " + strOrder);
            }
            else
            {
                if (string.IsNullOrEmpty(strWhere.Trim()))
                {
                    sbSql.Append("select top " + pageSize + " " + fieldName + " from " + tabName + " where " + fldName + strTemp + strOrder);

                }
                else
                {
                    strTemp = " not in (select top " + (pageIndex - 1) * pageSize + " " + fldName + " from " + tabName + " where " + strWhere + strOrder + ")";
                    sbSql.Append("select top " + pageSize + " " + fieldName + " from " + tabName + " where " + fldName + strTemp + " and " + strWhere + strOrder);
                }
            }
            return sbSql.ToString();
        }

生成sql语句

string sql = Asppage(tabName, filedName, fldName, pageSize, pageIndex1, strWhere, true);

SqlDataReader reader = DbHelperSQL.ExecuteReader(ConnectionStringLocal, sql);

            IList<Model.Orders> orders = new List<Model.Orders>();
            if (reader.HasRows)
            {
                while (reader.Read())
                {
                    Model.Orders order = new Model.Orders();
                    order.OrderID = reader["orderid"].ToString();
                    order.OrderState = int.Parse(reader["OrderState"].ToString());
                    order.LdtotalPrice = reader["LDTotalPrice"].ToString();
                    order.SellRemark = reader["Sellremark"].ToString();
                    order.Sumnumber = totalCount;
                    order.OrderDate = reader["OrderDate"].ToString();
                    order.PayTime = reader["payTime"].ToString();
                    order.ShoppingMoney = reader["ShoppingMoney"].ToString();
                    orders.Add(order);
                }
            }