Beispiel #1
0
        private void BindData(int pageno, int sendtype)
        {
            NoticeQuery noticeQuery = new NoticeQuery();

            noticeQuery.SortBy    = "ID";
            noticeQuery.SortOrder = SortAction.Desc;
            Globals.EntityCoding(noticeQuery, true);
            noticeQuery.PageIndex     = pageno;
            noticeQuery.SendType      = sendtype;
            noticeQuery.PageSize      = this.pager.PageSize;
            noticeQuery.IsDistributor = new bool?(true);
            this.title = Globals.RequestQueryStr("title");
            string text  = Globals.RequestQueryStr("starttime");
            string text2 = Globals.RequestQueryStr("endtime");
            string text3 = Globals.RequestQueryStr("username");
            string text4 = Globals.RequestQueryStr("state");

            if (!string.IsNullOrEmpty(this.title))
            {
                noticeQuery.Title  = this.title;
                this.txtTitle.Text = this.title;
            }
            try
            {
                if (!string.IsNullOrEmpty(text))
                {
                    noticeQuery.StartTime       = new System.DateTime?(System.DateTime.Parse(text));
                    this.calendarStartDate.Text = noticeQuery.StartTime.Value.ToString("yyyy-MM-dd");
                }
                if (!string.IsNullOrEmpty(text2))
                {
                    noticeQuery.EndTime       = new System.DateTime?(System.DateTime.Parse(text2));
                    this.calendarEndDate.Text = noticeQuery.EndTime.Value.ToString("yyyy-MM-dd");
                }
            }
            catch
            {
            }
            if (!string.IsNullOrEmpty(text3))
            {
                noticeQuery.Author    = text3;
                this.txtUserName.Text = text3;
            }
            string a;

            if ((a = text4) != null && (a == "0" || a == "1"))
            {
                noticeQuery.IsPub           = new int?(Globals.ToNum(text4));
                this.ddlState.SelectedValue = text4;
            }
            noticeQuery.SortBy = "IsPub asc,AddTime";
            DbQueryResult noticeRequest = NoticeHelper.GetNoticeRequest(noticeQuery);

            this.rptList.DataSource = noticeRequest.Data;
            this.rptList.DataBind();
            int totalRecords = noticeRequest.TotalRecords;

            this.pager.TotalRecords = totalRecords;
            this.recordcount        = totalRecords;
            if (this.pager.TotalRecords <= this.pager.PageSize)
            {
                this.pager.Visible = false;
            }
        }
Beispiel #2
0
 public static DbQueryResult GetNoticeRequest(NoticeQuery query)
 {
     return(new NoticeDao().GetNoticeRequest(query));
 }
        private void BindData(int pageno, int sendtype)
        {
            string      str5;
            NoticeQuery entity = new NoticeQuery
            {
                SortBy    = "ID",
                SortOrder = SortAction.Desc
            };

            Globals.EntityCoding(entity, true);
            entity.PageIndex     = pageno;
            entity.SendType      = sendtype;
            entity.PageSize      = this.pager.PageSize;
            entity.IsDistributor = true;
            this.title           = Globals.RequestQueryStr("title");
            string str  = Globals.RequestQueryStr("starttime");
            string str2 = Globals.RequestQueryStr("endtime");
            string str3 = Globals.RequestQueryStr("username");
            string s    = Globals.RequestQueryStr("state");

            if (!string.IsNullOrEmpty(this.title))
            {
                entity.Title       = this.title;
                this.txtTitle.Text = this.title;
            }
            try
            {
                if (!string.IsNullOrEmpty(str))
                {
                    entity.StartTime            = new DateTime?(DateTime.Parse(str));
                    this.calendarStartDate.Text = entity.StartTime.Value.ToString("yyyy-MM-dd");
                }
                if (!string.IsNullOrEmpty(str2))
                {
                    entity.EndTime            = new DateTime?(DateTime.Parse(str2));
                    this.calendarEndDate.Text = entity.EndTime.Value.ToString("yyyy-MM-dd");
                }
            }
            catch
            {
            }
            if (!string.IsNullOrEmpty(str3))
            {
                entity.Author         = str3;
                this.txtUserName.Text = str3;
            }
            if (((str5 = s) != null) && ((str5 == "0") || (str5 == "1")))
            {
                entity.IsPub = new int?(Globals.ToNum(s));
                this.ddlState.SelectedValue = s;
            }
            entity.SortBy = "IsPub asc,AddTime";
            DbQueryResult noticeRequest = NoticeHelper.GetNoticeRequest(entity);

            this.rptList.DataSource = noticeRequest.Data;
            this.rptList.DataBind();
            int totalRecords = noticeRequest.TotalRecords;

            this.pager.TotalRecords = totalRecords;
            this.recordcount        = totalRecords;
            if (this.pager.TotalRecords <= this.pager.PageSize)
            {
                this.pager.Visible = false;
            }
        }
 public BaseListResponse <SPGetNotice_Result> Search([FromUri] NoticeQuery query)
 {
     return(categoryService.FilterNotice(query));
 }
        /// <summary>
        /// 获取通知列表
        /// </summary>
        /// <returns></returns>
        public PageVM <NoticeVM> GetNoticeListPage(NoticeQuery query)
        {
            if (!query.PageIndex.HasValue)
            {
                query.PageIndex = 1;
            }
            if (!query.PageSize.HasValue)
            {
                query.PageSize = 10;
            }

            string sql = "select * from notice n where 1=1 ";

            if (!string.IsNullOrEmpty(query.KeyWord))
            {
                sql += string.Format(" and n.title like '%{0}%' ", query.KeyWord);
            }

            sql += " order by n.InputTime DESC ";
            string pageSql = string.Format(" Limit {0},{1}", (query.PageIndex - 1) * query.PageSize, query.PageSize);

            using (var dbContext = new DbContext().ConnectionStringName(ConnectionUtil.connWXB, DbProviderTypes.MySql))
            {
                //获取指定页数据
                List <NoticeVM> list = dbContext.Sql(sql + pageSql).Query <NoticeVM, List <NoticeVM> >(reader =>
                {
                    var noVM = new NoticeVM()
                    {
                        ID        = reader.AsInt("ID"),
                        Title     = reader.AsString("Title"),
                        Content   = reader.AsString("Content"),
                        Inputer   = reader.AsString("Inputer"),
                        InputerID = reader.AsInt("InputerID")
                    };

                    noVM.FeedBack   = string.IsNullOrEmpty(reader["FeedBack"].ToString()) ? "" : reader.AsString("FeedBack");
                    noVM.FeedBacker = string.IsNullOrEmpty(reader["FeedBacker"].ToString()) ? "" : reader.AsString("FeedBacker");

                    if (!string.IsNullOrEmpty(reader["AttachmentUrl"].ToString()))
                    {
                        noVM.AttachmentUrl = reader.AsString("AttachmentUrl");
                    }

                    if (!string.IsNullOrEmpty(reader["FeedBackerID"].ToString()))
                    {
                        noVM.FeedBackerID = reader.AsInt("FeedBackerID");
                    }

                    if (!string.IsNullOrEmpty(reader["FeedBackTime"].ToString()))
                    {
                        noVM.FeedBackTime    = Convert.ToDateTime(reader["FeedBackTime"]);
                        noVM.FeedBackTimeStr = noVM.FeedBackTime.Value.ToString("yyyy-MM-dd");
                    }
                    else
                    {
                        noVM.FeedBackTimeStr = string.Empty;
                    }

                    if (!string.IsNullOrEmpty(reader["InputTime"].ToString()))
                    {
                        noVM.InputTime    = Convert.ToDateTime(reader["InputTime"]);
                        noVM.InputTimeStr = noVM.InputTime.Value.ToString("yyyy-MM-dd");
                    }
                    else
                    {
                        noVM.InputTimeStr = string.Empty;
                    }

                    return(noVM);
                });

                list.ForEach(item =>
                {
                    if (!string.IsNullOrEmpty(item.AttachmentUrl))
                    {
                        var arr       = HttpUtility.UrlDecode(item.AttachmentUrl).Split('>');
                        item.FilePath = arr.Length > 0 ? arr[0] : string.Empty;
                        item.FileName = arr.Length > 1 ? arr[1] : string.Empty;
                    }
                    else
                    {
                        item.FilePath = string.Empty;
                        item.FileName = string.Empty;
                    }
                });

                //获取数据总数
                int totalCount = dbContext.Sql(sql).Query().Count;
                //总页数
                double totalPages = ((double)totalCount / query.PageSize.Value);

                PageVM <NoticeVM> pageVM = new PageVM <NoticeVM>();
                pageVM.Data       = list;
                pageVM.TotalCount = totalCount;
                pageVM.TotalPages = (int)Math.Ceiling(totalPages);
                pageVM.PageIndex  = query.PageIndex;

                return(pageVM);
            }
        }
Beispiel #6
0
 /// <summary>
 /// 通知查询
 /// </summary>
 /// <param name="query"></param>
 /// <returns></returns>
 public QueryResult <Notice> Query(NoticeQuery query)
 {
     return(DataBase.Query(query));
 }