<%@ Page Language= "C# "%>
<%@ Import Namespace= "System.Data "%> <%@Import Namespace= "System.Data.SqlClient "%> <%@Import Namespace= "System.Configuration "%> <%@Register TagPrefix= "Webdiyer " TagName= "NavBar " Src= "../nav.ascx "%> <%@Register TagPrefix= "Webdiyer " TagName= "Copyright " Src= "../copyright.ascx "%> <%@Register TagPrefix= "Webdiyer " Namespace= "Wuqi.Webdiyer " Assembly= "aspnetpager "%> <script runat= "server "> SqlConnection conn; SqlCommand cmd; void Page_Load(object src,EventArgs e){ conn=new SqlConnection(ConfigurationSettings.AppSettings[ "SQLConnString "]); if(!Page.IsPostBack){ cmd=new SqlCommand( "wqnews_GetPagedWQNews ",conn); cmd.CommandType=CommandType.StoredProcedure; cmd.Parameters.Add( "@pageindex ",1); cmd.Parameters.Add( "@pagesize ",1); cmd.Parameters.Add( "@docount ",true); conn.Open(); pager.RecordCount=(int)cmd.ExecuteScalar(); conn.Close(); BindData(); //获取分页属性值 psize.Items.FindByValue(pager.PageSize.ToString()).Selected=true; //获取导航按钮属性值 bcount.Items.FindByValue(pager.NumericButtonCount.ToString()).Selected=true; showfl.Checked=pager.ShowFirstLast; showpn.Checked=pager.ShowPrevNext; showindex.Checked=pager.ShowPageIndex; cnindex.Checked=pager.ChinesePageIndex; showdb.Checked=pager.ShowDisabledButtons; bpadding.Text=pager.PagingButtonSpacing.ToString(); bfstring.Text=pager.NumericButtonTextFormatString; fptext.Text=pager.FirstPageText; lptext.Text=pager.LastPageText; nptext.Text=pager.NextPageText; pptext.Text=pager.PrevPageText; //获取用户自定义信息区属性值 showisec.SelectedIndex=(int)pager.ShowCustomInfoSection; cuswidth.Text=pager.CustomInfoSectionWidth.ToString(); cusalign.Items.FindByValue(pager.CustomInfoTextAlign.ToString()).Selected=true; cusstyle.Text=pager.CustomInfoStyle; //获取文本框及提交按钮属性值 showbox.Items[(int)pager.ShowInputBox].Selected=true; subtext.Text=pager.SubmitButtonText; txtbeforebox.Text=pager.TextBeforeInputBox; txtafterbox.Text=pager.TextAfterInputBox; boxstyle.Text=pager.InputBoxStyle; threshold.Text=pager.ShowBoxThreshold.ToString(); //获取图片按钮属性值 btntype.SelectedIndex=(pager.PagingButtonType==PagingButtonType.Text)?0:1; imgpath.Text=pager.ImagePath; imgext.Text=pager.ButtonImageExtension; imgnameext.Text=pager.ButtonImageNameExtension; cpinameext.Text=pager.CpiButtonImageNameExtension; disnameext.Text=pager.DisabledButtonImageNameExtension; } } void BindData(){ cmd=new SqlCommand( "wqnews_GetPagedWQNews ",conn); cmd.CommandType=CommandType.StoredProcedure; cmd.Parameters.Add( "@pageindex ",pager.CurrentPageIndex); cmd.Parameters.Add( "@pagesize ",pager.PageSize); cmd.Parameters.Add( "@docount ",false); conn.Open(); dg.DataSource=cmd.ExecuteReader(); dg.DataBind(); conn.Close(); //获取并显示分页信息 cindex.Text=pager.CurrentPageIndex.ToString(); rcount.Text=pager.RecordCount.ToString(); pcount.Text=pager.PageCount.ToString(); pagesize.Text=pager.PageSize.ToString(); pagesleft.Text=pager.PagesRemain.ToString(); recordsleft.Text=pager.RecordsRemain.ToString(); //动态设置用户自定义文本内容 pager.CustomInfoText= "记录总数: <font color=\ "blue\ "> <b> "+pager.RecordCount.ToString()+ " </b> </font> "; pager.CustomInfoText+= " 总页数: <font color=\ "blue\ "> <b> "+pager.PageCount.ToString()+ " </b> </font> "; pager.CustomInfoText+= " 当前页: <font color=\ "red\ "> <b> "+pager.CurrentPageIndex.ToString()+ " </b> </font> "; } void ChangePage(object src,PageChangedEventArgs e){ pager.CurrentPageIndex=e.NewPageIndex; BindData(); System.Text.StringBuilder sb=new StringBuilder( " <script Language=\ "Javascript\ "> <!--\n "); sb.Append( "var el=document.all; "); sb.Append(dg.ClientID); sb.Append( ".scrollIntoView(true); "); sb.Append( " < "); sb.Append( "/ "); sb.Append( "script> "); if(!Page.IsStartupScriptRegistered( "scrollScript ")) Page.RegisterStartupScript( "scrollScript ",sb.ToString()); } void EditData(object src,DataGridCommandEventArgs e){ dg.EditItemIndex=e.Item.ItemIndex; BindData(); } void UpdateData(object src,DataGridCommandEventArgs e){ //这只是示例,并不更新数据。 dg.EditItemIndex=-1; BindData(); } void CancelEdit(object src,DataGridCommandEventArgs e){ dg.EditItemIndex=-1; BindData(); } void BindScript(object src,DataGridItemEventArgs e){ if(e.Item.ItemType==ListItemType.EditItem){ LinkButton btn=(LinkButton)e.Item.Cells[4].Controls[0]; btn.Attributes.Add( "onclick ", "alert(\ "本示例程序仅为演示如何使用AspNetPager控件,所以并不真正更新数据!\ ") "); } } void ChangePagerProperties(object src,EventArgs e){ //设置分页属性值 pager.PageSize=int.Parse(psize.SelectedItem.Value); //设置导航按钮属性值 pager.NumericButtonCount=int.Parse(bcount.SelectedItem.Value); pager.ShowFirstLast=showfl.Checked; pager.ShowPrevNext=showpn.Checked; pager.ShowPageIndex=showindex.Checked; if(!IsInputEmpty(fptext.Text)) pager.FirstPageText=fptext.Text; if(!IsInputEmpty(lptext.Text)) pager.LastPageText=lptext.Text; if(!IsInputEmpty(pptext.Text)) pager.PrevPageText=pptext.Text; if(!IsInputEmpty(nptext.Text)) pager.NextPageText=nptext.Text; pager.ChinesePageIndex=cnindex.Checked; pager.ShowDisabledButtons=showdb.Checked; pager.PagingButtonSpacing=Unit.Parse(bpadding.Text); pager.NumericButtonTextFormatString=bfstring.Text; //设置文本框及提交按钮属性值 pager.ShowInputBox=(ShowInputBox)Enum.Parse(typeof(ShowInputBox),showbox.SelectedItem.Value); pager.SubmitButtonText=subtext.Text; pager.TextBeforeInputBox=txtbeforebox.Text; pager.TextAfterInputBox=txtafterbox.Text; pager.ShowBoxThreshold=int.Parse(threshold.Text.Trim()); //设置图片按钮属性值 pager.PagingButtonType=(PagingButtonType)Enum.Parse(typeof(PagingButtonType),btntype.SelectedItem.Value); //设置用户自定义文本区属性值 pager.HorizontalAlign=(showisec.SelectedIndex==2)?HorizontalAlign.Left:HorizontalAlign.Right; pager.ShowCustomInfoSection=(ShowCustomInfoSection)Enum.Parse(typeof(ShowCustomInfoSection),showisec.SelectedItem.Value); pager.CustomInfoSectionWidth=Unit.Parse(cuswidth.Text.Trim()); pager.CustomInfoTextAlign=(HorizontalAlign)Enum.Parse(typeof(HorizontalAlign),cusalign.SelectedItem.Value); pager.CustomInfoStyle=cusstyle.Text; BindData(); } bool IsInputEmpty(string input){ if(input.Trim().Length> 0) return false; return true; } </script> |
|