コード例 #1
0
 /// <summary>
 /// 新闻列表
 /// </summary>
 /// <param name="searchSetting"></param>
 /// <returns></returns>
 public static IPageOfList<CompanyNewsInfo> List(CompanyNewsSearchSetting searchSetting)
 {
     return CompanyNewsManage.List(searchSetting);
 }
コード例 #2
0
        /// <summary>
        /// 分页列表(包含CompanyNews和Articles两个部分)
        /// </summary>
        /// <param name="searchSetting"></param>
        /// <returns></returns>
        public static IPageOfList<CompanyNewsInfo> List(CompanyNewsSearchSetting searchSetting)
        {
            FastPaging fp = new FastPaging();
            fp.OverOrderBy = " CN.PublishDateTime DESC";
            fp.PageIndex = searchSetting.PageIndex;
            fp.PageSize = searchSetting.PageSize;
            fp.QueryFields = "*";
            fp.TableName = string.Format(@"( 
SELECT Id,CompanyId,[Type],Title,Content,Remark,ImageUrl,Tags,PublishDateTime,ModifyDateTime,CreateDateTime,IsDeleted,Url 
FROM CompanyNews WITH(NOLOCK) WHERE CompanyId = {0} AND [Type] = '{1}' AND IsDeleted = 0 
UNION ALL 
SELECT Id,CompanyId,'article',Title,Content,Remark,ImageUrl,Tags,PublishDateTime,LastModifyDateTime,CreateDateTime,IsDeleted,Url 
FROM Articles WITH(NOLOCK) WHERE CompanyId = {0} AND IsDeleted = 0)",searchSetting.CompanyId,searchSetting.Type);
            fp.PrimaryKey = "Id";
            fp.TableReName = "CN";

            IList<CompanyNewsInfo> list = new List<CompanyNewsInfo>();
            CompanyNewsInfo model = null;
            DataTable dt = SQLPlus.ExecuteDataTable(CommandType.Text, fp.Build2005());
            if (dt != null && dt.Rows.Count > 0)
            {
                foreach (DataRow dr in dt.Rows)
                {
                    model = GetByDataRow(dr);
                    if (model != null)
                    {
                        list.Add(model);
                    }
                }
            }
            int count = Convert.ToInt32(SQLPlus.ExecuteScalar(CommandType.Text, fp.BuildCountSQL()));
            return new PageOfList<CompanyNewsInfo>(list, searchSetting.PageIndex, searchSetting.PageSize, count);
        }