<%@ 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>
本站仅提供存储服务,所有内容均由用户发布,如发现有害或侵权内容,请
点击举报。