示例#1
0
        /// <summary>
        /// 查询公告
        /// </summary>
        /// <param name="filter">查询条件</param>
        public static QueryResult<Notices> QueryNotices(NoticesQueryFilter filter)
        {
            QueryResult<Notices> result = new QueryResult<Notices>();
            PagingInfoEntity page = new PagingInfoEntity();
            page.SortField = (filter.SortList == null || filter.SortList.Count == 0) ? null : filter.SortListToString();
            page.MaximumRows = filter.PageSize;
            page.StartRowIndex = (filter.PageIndex - 1) * filter.PageSize;
            CustomDataCommand cmd = DataCommandManager.CreateCustomDataCommandFromConfig("QueryNotices");
            using (var sqlBuilder = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, page, "SysNo DESC"))
            {
                sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "SysNo", DbType.Int32, "@SysNo",
                    QueryConditionOperatorType.Equal, filter.SysNo);
                sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "Contents", DbType.String, "@Contents",
                    QueryConditionOperatorType.Like, filter.Contents);
                sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "Status", DbType.Int32, "@Status",
                    QueryConditionOperatorType.Equal, filter.Status);

                cmd.CommandText = sqlBuilder.BuildQuerySql();
                result.ResultList = cmd.ExecuteEntityList<Notices>();

                int totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount"));
                result.PagingInfo = new PagingInfo() { PageIndex = filter.PageIndex, PageSize = filter.PageSize, TotalCount = totalCount };
                return result;
            }
        }
示例#2
0
        protected void Page_Load(object sender, EventArgs e)
        {
            NoticesQueryFilter queryFilter = new NoticesQueryFilter();
            queryFilter.PageCount = 0;
            queryFilter.PageIndex = 1;
            queryFilter.PageSize = 10;

            NoticesLogic.QueryNotices(queryFilter);

            btnOK.ServerClick += new EventHandler(btnOK_ServerClick);
        }
示例#3
0
        public override void PageLoad()
        {
            base.PageLoad();
            ucPager.PageSize = 10;
            QueryFilter = new NoticesQueryFilter();

            if (!IsPostBack)
            {
                BindData();
            }
        }
示例#4
0
 /// <summary>
 /// 修改公告状态
 /// </summary>
 /// <param name="sysNo">编号</param>
 /// <param name="status">状态</param>
 public static QueryResult<Notices> QueryNotices(NoticesQueryFilter queryFilter)
 {
     return NoticesDA.QueryNotices(queryFilter);
 }