Пример #1
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="sp"></param>
        /// <returns></returns>
        protected virtual SqlParameter CreateParameter_Fileds(ExhibitionSearchEntity sp)
        {
            StringBuilder sbfileds = new StringBuilder();

            sbfileds.Append(@"*");
            return(new SqlParameter("@Fields", sbfileds.ToString()));
        }
Пример #2
0
 /// <summary>
 /// 使用缓存查询信息
 /// </summary>
 /// <param name="info">查询主体</param>
 /// <param name="totalcnt">返回条目数</param>
 /// <returns></returns>
 public DataTable QueryData(ExhibitionSearchEntity info, out int totalcnt)
 {
     //if (info.UseDBPagination)
     //{
     //    string key = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(info.ToJson(info), "MD5");
     //    DataTableRSCacheEntity rsobj = MyCache<DataTableRSCacheEntity>.Get(key);
     //    if (rsobj == null)
     //    {
     //        DataTable dt = dao.QueryData(info, out totalcnt);
     //        if (dt != null && dt.Rows.Count > 0)
     //        {
     //            rsobj = new DataTableRSCacheEntity() { Source = dt, TotalCnt = totalcnt };
     //            MyCache<DataTableRSCacheEntity>.Insert(key, rsobj, 60);
     //        }
     //        else
     //        {
     //            rsobj = new DataTableRSCacheEntity();
     //        }
     //    }
     //    totalcnt = rsobj.TotalCnt;
     //    return rsobj.Source;
     //}
     //else
     //{
     //    return dao.QueryData(info, out totalcnt);
     //}
     return(dao.QueryData(info, out totalcnt));
 }
Пример #3
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="sp"></param>
        /// <returns></returns>
        protected virtual SqlParameter CreateParameter_Table(ExhibitionSearchEntity sp)
        {
            StringBuilder sbtable = new StringBuilder();

            sbtable.Append(@"dbo.M_Exhibition_Main AS em");

            return(new SqlParameter("@TableName", sbtable.ToString()));
        }
Пример #4
0
        protected virtual SqlParameter CreateParamter_Orderby(ExhibitionSearchEntity sp)
        {
            StringBuilder sb = new StringBuilder();

            sb.Append(" em.ExhibitionOrder ASC,em.ExhibitionID ASC ");

            return(new SqlParameter("@OrderField", sb.ToString()));
        }
Пример #5
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="sp"></param>
        /// <returns></returns>
        protected virtual SqlParameter CreateParameter_Where(ExhibitionSearchEntity sp)
        {
            StringBuilder sbwhere = new StringBuilder(" 1=1 AND em.StateTypeID = 1");

            if (!string.IsNullOrEmpty(sp.ExhibitionTitle))
            {
                sbwhere.AppendFormat(" AND em.ExhibitionTitle LIKE '%{0}%'", sp.ExhibitionTitle);
            }

            return(new SqlParameter("@sqlWhere", sbwhere.ToString()));
        }
Пример #6
0
        /// <summary>
        /// 核心方法。查询条件转换成sql参数
        /// </summary>
        /// <param name="sp"></param>
        /// <returns></returns>
        protected virtual List <SqlParameter> ParseToSqlParameters(ExhibitionSearchEntity sp)
        {
            List <SqlParameter> _parameters = new List <SqlParameter>();

            _parameters.Add(CreateParameter_Table(sp));
            _parameters.Add(CreateParameter_Fileds(sp));
            _parameters.Add(CreateParamter_Orderby(sp));
            _parameters.Add(CreateParameter_Where(sp));

            _parameters.Add(new SqlParameter("@pageSize", sp.PageSize));
            _parameters.Add(new SqlParameter("@pageIndex", sp.PageIndex));
            _parameters.Add(new SqlParameter()
            {
                ParameterName = "@Records", Value = 0, Direction = System.Data.ParameterDirection.Output
            });
            return(_parameters);
        }
Пример #7
0
        public DataTable QueryData(ExhibitionSearchEntity info, out int totalcnt)
        {
            try
            {
                SqlParameter[] prms = ParseToSqlParameters(info).ToArray();
                DataTable      dt   = SQlHelper.ExecuteDataset(SQlHelper.MyConnectStr, CommandType.StoredProcedure, "sp_pager05", prms).Tables[0];
                totalcnt = int.Parse(prms[prms.Length - 1].Value.ToString());

                return(dt);
            }
            catch (Exception ex)
            {
                totalcnt = -1;
                LogUtil.WriteLog(ex);
                return(null);
            }
        }
Пример #8
0
        private DataTable GetQueryData(bool isDownload)
        {
            int totalcnt = 0;

            ExhibitionSearchEntity entity = new ExhibitionSearchEntity();

            entity.ExhibitionTitle = _exhibitionTitle;

            entity.PageSize        = base.PageSize;
            entity.PageIndex       = base.PageIndex;
            entity.UseDBPagination = !isDownload;

            DataTable table = bll.QueryData(entity, out totalcnt);

            base.TotalRecords = totalcnt;

            return(table);
        }