DAL/QueryDAL.cs

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

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

using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Common;

namespace DAL
{
    public class QueryDAL : DALBase
    {
        public QueryDAL()
        {
            this.ConnStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
        }

        /// <summary>
        /// 获取查询分页数据
        /// </summary>
        /// <returns></returns>
        public DataTable GetDataTable(string tabname, string PrimaryKey, string Fields, string Filter, string sort, string Group, string curpage, string pagesize, out int totalcount)
        {
            this.ParameterList.Add("tabname", tabname);
            this.ParameterList.Add("PrimaryKey", PrimaryKey);
            this.ParameterList.Add("Fields", Fields);
            this.ParameterList.Add("Fields", Fields);
            this.ParameterList.Add("Filter", Filter);
            this.ParameterList.Add("sort", sort);
            this.ParameterList.Add("Group", Group);
            this.ParameterList.Add("curpage", curpage);
            this.ParameterList.Add("pagesize", pagesize);
            this.ParameterList.Add("pagesize", pagesize);
            this.ParameterList.Add("totalcount", SqlDbType.Int, ParameterDirection.InputOutput);

            DataTable dt = this.ExecuteDataTable("p_web_query");
            totalcount = Convert.ToInt32(this.ParameterList["totalcount"].Value);
            return dt;
        }
        /// <summary>
        /// 获取查询数据
        /// </summary>
        /// <param name="tabname"></param>
        /// <param name="PrimaryKey"></param>
        /// <param name="Fields"></param>
        /// <param name="Filter"></param>
        /// <param name="sort"></param>
        /// <param name="Group"></param>
        /// <returns></returns>
        public DataTable GetDataTable(string tabname, string PrimaryKey, string Fields, string Filter, string sort, string Group)
        {
            this.ParameterList.Add("tabname", tabname);
            this.ParameterList.Add("PrimaryKey", PrimaryKey);
            this.ParameterList.Add("Fields", Fields);
            this.ParameterList.Add("Filter", Filter);
            this.ParameterList.Add("sort", sort);
            this.ParameterList.Add("Group", Group);