分享

如何在*.aspx页面中直接嵌入C#代码

 若生安饶 2011-05-16
<%@   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>

    本站是提供个人知识管理的网络存储空间,所有内容均由用户发布,不代表本站观点。请注意甄别内容中的联系方式、诱导购买等信息,谨防诈骗。如发现有害或侵权内容,请点击一键举报。
    转藏 分享 献花(0

    0条评论

    发表

    请遵守用户 评论公约