FineUI 官方论坛

标题: 数据库分页的问题 [打印本页]

作者: xiaolaohai 时间: 2017-5-22 22:42
标题: 数据库分页的问题
grid数据库分页时,  我怎么找不到没法调用 DateSourceUtil？提示上下文中不存在 DateSourceUtil

private int GetTotalCount()
      {
         return DateSourceUtil.GetDataTable2().Rows.Count;
      }

作者: xueyang214 时间: 2017-6-1 17:09
public ActionResult Index()
      {

         var pagingInfo = new PagingInfoViewModel
         {
            SortField = "ID",
            SortDirection = "DESC",
            PageIndex = 0,
            PageSize = ConfigHelper.PageSize
         };
         ViewBag.PagingInfo = pagingInfo;

         var list = AA.GetDataList(pagingInfo, string.Empty);

         return View(list);
      }
  var dt = DBHelper.GetPagedDataTable(pagingInfo, sql);

         return ConvertUtil<AA>.ConvertToModel(dt);

自己写了一个方法，估计高版本有现成的分页方法吧？
/// <summary>
      /// 数据库分页
      /// </summary>
      /// <returns></returns>
      public static DataTable GetPagedDataTable(PagingInfoViewModel pagingInfo, string sql)
      {
         DataTable dt = new DataTable();
         try
         {
            int pageIndex = pagingInfo.PageIndex;
            int pageSize = pagingInfo.PageSize;

            string sqlCount = string.Format("select count(0) from ({0}) a ", sql);
            pagingInfo.RecordCount = Convert.ToInt32(DBHelper.ExecuteScalar(sqlCount));

            Int16 totalRecord = Convert.ToInt16(pagingInfo.RecordCount);
            int rowStart = (pageIndex * pageSize) + 1;//当前页的起始序号
            int rowEnd = (pageIndex + 1) * pageSize;//当前页的结束序号
            rowEnd = rowEnd > totalRecord ? totalRecord : rowEnd;

            //排序
            if (!string.IsNullOrEmpty(pagingInfo.SortField))
            {
                  if (string.IsNullOrEmpty(pagingInfo.SortDirection)) pagingInfo.SortDirection = "ASC";
                  sql += " ORDER BY " + pagingInfo.SortField + " " + pagingInfo.SortDirection;
            }

            //查询语句
            sql = @"SELECT * FROM (
                        SELECT A.*, ROWNUM RN
                        FROM(" + sql + @") A
                        WHERE ROWNUM <= " + rowEnd.ToString() + @"
                        )  WHERE RN >= " + rowStart.ToString();

            dt = DBHelper.GetDataFromDB(sql);
            //DataTable source = DBHelper.ExecuteDataTable(sql);
         }
         catch(Exception ex)
         {
            LogClass.WriteLog(ex, sql);
         }
         return dt;
      }

作者: xueyang214 时间: 2017-6-1 17:10
/// <summary>
      /// 将DataTable转换为List实体类（模型）列表
      /// </summary>
      /// <param name="dt">DataTable</param>
      /// <returns></returns>
      public static List<T> ConvertToModel(DataTable dt)
      {

         // 定义集合
         List<T> ts = new List<T>();

         // 获得此模型的类型
         Type type = typeof(T);
         string tempName = "";

         foreach (DataRow dr in dt.Rows)
         {
            T t = new T();
            // 获得此模型的公共属性
            PropertyInfo[] propertys = t.GetType().GetProperties();
            foreach (PropertyInfo pi in propertys)
            {
                  tempName = pi.Name;  // 检查DataTable是否包含此列

                  if (dt.Columns.Contains(tempName))
                  {
                     // 判断此属性是否有Setter
                     if (!pi.CanWrite) continue;

                     object value = dr[tempName];
                     if (value != DBNull.Value)
                     {
                        try
                        {
                              pi.SetValue(t, value, null);
                        }
                        catch (Exception ex)
                        {
                              LogClass.WriteLog(ex, "数据库字段类型异常，请检查：" + tempName);
                        }
                     }
                  }
            }
            ts.Add(t);
         }

         return ts;
      }

作者: sanshi 时间: 2017-6-1 21:59
在VS中搜索官网示例源代码，你肯定可以找到： DateSourceUtil

欢迎光临 FineUI 官方论坛 (https://fineui.com/BBS/)