Sry.Solution.Components/PublicMethod.cs

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

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Web;
using System.Text.RegularExpressions;
using Sry.Framework.Dal;
using System.Data;
using System.Web.UI.WebControls;
using System.Web.UI;
using System.Data.SqlClient;

namespace Sry.Solution.Components
{
    /// <summary>
    /// 公共方法
    /// </summary>
   public class PublicMethod
    {
        /// <summary>
        /// 帅选表
        /// </summary>
        /// <param name="dt">原DataTable</param>
        /// <param name="listKey">字段名List</param>
        /// <param name="listRes">字段值List</param>
        /// <returns>帅选后的DataTable</returns>
        public static DataTable Select(DataTable dt, List<string> listKey, List<string> listRes)
        {
            DataView dv = new DataView();
            dv.Table = dt;
            StringBuilder str = new StringBuilder();
            for (int i = 0; i < listKey.Count; i++)
            {
                for (int j = 0; j < listRes.Count; j++)
                {
                    if (i == j)
                    {
                        str.Append(listKey[i] + "='" + listRes[j] + "' and ");
                    }
                }
            }
            dv.RowFilter = str.ToString().Substring(0, str.ToString().LastIndexOf("and"));
            return dv.ToTable();
        }
        /// <summary>
        /// 对表格排序
        /// </summary>
        /// <param name="dt">原DataTable</param>
        /// <param name="order">排序字段</param>
        /// <returns>排序后的DataTable</returns>
        public static DataTable SortDesc(DataTable dt, String order)
        {
            DataView dv = new DataView();
            dv.Table = dt;
            dv.Sort = order + " desc";
            return dv.ToTable();
        }
        /// <summary>
        /// 根据索引和pagesize返回记录
        /// </summary>