示例#1
0
        /// <summary>
        /// 评论取数据的存储过程
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="tabelName"></param>
        /// <param name="where"></param>
        /// <param name="orderString"></param>
        /// <param name="orderType"></param>
        /// <returns></returns>
        public object QueryPaginationList <T>(string tabelName, string columns, string where, string orderString, int pageIndex, int pageSize = 20, int orderType = 1) where T : Kingsun.DB.Action, new()
        {
            try
            {
                PageParameter param = new PageParameter();
                param.OrderColumns = orderString;
                param.TbNames      = tabelName;
                param.IsOrderByASC = orderType;
                param.Columns      = "*";
                param.Columns      = string.IsNullOrEmpty(columns) ? "*" : columns;
                param.PageIndex    = pageIndex;
                param.PageSize     = pageSize;
                //param.Where
                param.Where = string.IsNullOrEmpty(where) ? "" : where;

                List <System.Data.Common.DbParameter> list = new List <System.Data.Common.DbParameter>();
                list = param.getParameterList();
                System.Data.DataSet ds = ExecuteProcedure("proc_commentPageView", list);
                if (ds != null && ds.Tables.Count == 2)
                {
                    object returnData = new
                    {
                        Total = ds.Tables[1].Rows[0][0],
                        List  = FillData <T>(ds.Tables[0])
                    };
                    return(returnData);
                }
                else
                {
                    return(new
                    {
                        Total = 0,
                        List = new List <T>()
                    });
                }
            }
            catch
            {
                throw;
            }
        }
示例#2
0
 /// <summary>
 /// 得到实体List
 /// </summary>
 /// <typeparam name="T"></typeparam>
 /// <param name="tabelName"></param>
 /// <param name="where"></param>
 /// <param name="orderString"></param>
 /// <param name="orderType"></param>
 /// <returns></returns>
 public tb_UserMessageAll <T> QueryPageList <T>(string tabelName, string where, string orderString, int pageIndex, int pageSize = 20, int orderType = 1) where T : Kingsun.DB.Action, new()
 {
     try
     {
         PageParameter param = new PageParameter();
         param.OrderColumns = orderString;
         param.TbNames      = tabelName;
         param.IsOrderByASC = orderType;
         param.Columns      = "*";
         param.PageIndex    = pageIndex;
         param.PageSize     = pageSize;
         //param.Where
         param.Where = string.IsNullOrEmpty(where) ? "1=1" : where;
         List <System.Data.Common.DbParameter> list = new List <System.Data.Common.DbParameter>();
         list = param.getParameterList();
         System.Data.DataSet ds = ExecuteProcedure("proc_pageView", list);
         if (ds != null && ds.Tables.Count == 2)
         {
             //object returnData = new
             //{
             //    Total = ds.Tables[1].Rows[0][0],
             //    List = FillData<T>(ds.Tables[0])
             //};
             tb_UserMessageAll <T> tb = new tb_UserMessageAll <T>();
             tb.Total = ds.Tables[1].Rows[0][0].ToString();
             tb.ListT = FillData <T>(ds.Tables[0]);
             return(tb);
         }
         else
         {
             tb_UserMessageAll <T> tb = new tb_UserMessageAll <T>();
             return(tb);
         }
     }
     catch
     {
         throw;
     }
 }