private void dataBind(int pageIndex) { //AccountsPrincipal user = new AccountsPrincipal(Context.User.Identity.Name); //if (!user.HasPermissionID(PermId_Add)) //{ // this.Page011.Page_Add = ""; //} //if (!user.HasPermissionID(PermId_Search)) //{ // this.Page011.Page_Search = ""; //} //if (user.HasPermissionID(PermId_Modify)) //{ // grid.Columns[6].Visible = true; //} //if (user.HasPermissionID(PermId_Delete)) //{ // grid.Columns[7].Visible = true; //} pageIndex--; Maticsoft.BLL.NewsManage.News bll = new Maticsoft.BLL.NewsManage.News(); string strWhere = ""; if (Session["strWhereNewsRelea"] != null && Session["strWhereNewsRelea"].ToString() != "") { strWhere = Session["strWhereNewsRelea"].ToString(); } DataSet ds = new DataSet(); ds = bll.GetList(strWhere); grid.DataSource = ds.Tables[0].DefaultView; int record_Count = ds.Tables[0].Rows.Count; int page_Size = grid.PageSize; int totalPages = int.Parse(Math.Ceiling((double)record_Count / page_Size).ToString()); if (totalPages > 0) { if ((pageIndex + 1) > totalPages) pageIndex = totalPages - 1; } else { pageIndex = 0; } grid.CurrentPageIndex = pageIndex; grid.DataBind(); int page_Count = grid.PageCount; int page_Current = pageIndex + 1; Page011.Record_Count = record_Count; Page011.Page_Count = page_Count; Page021.Page_Count = page_Count; Page011.Page_Size = page_Size; Page021.Page_Size = page_Size; Page011.Page_Current = page_Current; Page021.Page_Current = page_Current; }
protected void newssearch() { string key = Request.Form[0].ToString(); int type = int.Parse(Request.Form[1]); string strType = ""; this.searchInfo.InnerHtml = key + type.ToString(); string strwhere = ""; switch (type) { case 1: strwhere = " ( heading like'%" + key + "%')"; strType = "标题"; break; case 2: strwhere = " ( content like'%" + key + "%')"; strType = "内容"; break; case 3: string strdate = "1900-01-01"; try { strdate = Convert.ToDateTime(key).ToShortDateString(); } catch { } strwhere = " issuedate>'" + strdate + "' and issuedate-1<'" + strdate + "'"; strType = "日期"; break; } Maticsoft.BLL.NewsManage.News bll = new Maticsoft.BLL.NewsManage.News(); DataSet ds = new DataSet(); ds = bll.GetList(strwhere); this.GridView1.DataSource = ds.Tables[0].DefaultView; this.GridView1.DataBind(); int count = 0; try { count = ds.Tables[0].Rows.Count; } catch { } this.searchInfo.InnerHtml = "搜索关键字:<b>" + key + " </b>搜索方式:<b>" + strType; this.searchInfo.InnerHtml += "</b>共找到记录:<b>" + count.ToString() + "</b>"; }
protected void newssearch() { string key = Request.Form[0].ToString(); int type = int.Parse(Request.Form[1]); string strType = ""; this.searchInfo.InnerHtml = key + type.ToString(); string strwhere=""; switch (type) { case 1: strwhere = " ( heading like'%" + key + "%')"; strType = "标题"; break; case 2: strwhere = " ( content like'%" + key + "%')"; strType = "内容"; break; case 3: string strdate="1900-01-01"; try { strdate = Convert.ToDateTime(key).ToShortDateString(); } catch { } strwhere = " issuedate>'" + strdate + "' and issuedate-1<'" + strdate + "'"; strType = "日期"; break; } Maticsoft.BLL.NewsManage.News bll = new Maticsoft.BLL.NewsManage.News(); DataSet ds = new DataSet(); ds = bll.GetList(strwhere); this.GridView1.DataSource = ds.Tables[0].DefaultView; this.GridView1.DataBind(); int count=0; try { count=ds.Tables[0].Rows.Count; } catch { } this.searchInfo.InnerHtml = "搜索关键字:<b>" + key + " </b>搜索方式:<b>" + strType; this.searchInfo.InnerHtml += "</b>共找到记录:<b>" +count.ToString() +"</b>"; }
private void BindData() { #region 权限检查 if (!Context.User.Identity.IsAuthenticated) { return; } AccountsPrincipal user = new AccountsPrincipal(Context.User.Identity.Name); if (user.HasPermissionID(PermId_Modify)) { gridView.Columns[7].Visible = true; } if (user.HasPermissionID(PermId_Delete)) { gridView.Columns[8].Visible = true; } #endregion string strWhere = ""; if (Session["strWhereNews"] != null && Session["strWhereNews"].ToString() != "") { strWhere += Session["strWhereNews"].ToString(); } DataSet ds = new DataSet(); ds = bll.GetList(strWhere); DataView dv = ds.Tables[0].DefaultView; gridView.DataSource = dv; gridView.DataBind(); //分页 int rows_Count = ds.Tables[0].Rows.Count; int page_Size = gridView.PageSize; int page_Count = gridView.PageCount; int page_Current = gridView.PageIndex + 1; lblRowsCount.Text = rows_Count.ToString(); lblPageCount.Text = page_Count.ToString(); lblCurrentPage.Text = page_Current.ToString(); #region 显示页导航 btnFirst.Enabled = true; btnPrev.Enabled = true; btnNext.Enabled = true; btnLast.Enabled = true; if (gridView.PageIndex == 0) { btnFirst.Enabled = false; btnPrev.Enabled = false; if (gridView.PageCount == 1) { btnLast.Enabled = false; btnNext.Enabled = false; } } else if (gridView.PageIndex == gridView.PageCount - 1) { btnLast.Enabled = false; btnNext.Enabled = false; } #endregion }
private void dataBind(int pageIndex) { //AccountsPrincipal user = new AccountsPrincipal(Context.User.Identity.Name); //if (!user.HasPermissionID(PermId_Add)) //{ // this.Page011.Page_Add = ""; //} //if (!user.HasPermissionID(PermId_Search)) //{ // this.Page011.Page_Search = ""; //} //if (user.HasPermissionID(PermId_Modify)) //{ // grid.Columns[6].Visible = true; //} //if (user.HasPermissionID(PermId_Delete)) //{ // grid.Columns[7].Visible = true; //} pageIndex--; Maticsoft.BLL.NewsManage.News bll = new Maticsoft.BLL.NewsManage.News(); string strWhere = ""; if (Session["strWhereNewsRelea"] != null && Session["strWhereNewsRelea"].ToString() != "") { strWhere = Session["strWhereNewsRelea"].ToString(); } DataSet ds = new DataSet(); ds = bll.GetList(strWhere); grid.DataSource = ds.Tables[0].DefaultView; int record_Count = ds.Tables[0].Rows.Count; int page_Size = grid.PageSize; int totalPages = int.Parse(Math.Ceiling((double)record_Count / page_Size).ToString()); if (totalPages > 0) { if ((pageIndex + 1) > totalPages) { pageIndex = totalPages - 1; } } else { pageIndex = 0; } grid.CurrentPageIndex = pageIndex; grid.DataBind(); int page_Count = grid.PageCount; int page_Current = pageIndex + 1; Page011.Record_Count = record_Count; Page011.Page_Count = page_Count; Page021.Page_Count = page_Count; Page011.Page_Size = page_Size; Page021.Page_Size = page_Size; Page011.Page_Current = page_Current; Page021.Page_Current = page_Current; }