.Net将后台写进前台aspx页面实例

几点注意事项(步骤):

1.用<script runat="server"><script>

2.将后台代码全复制到script内,并把外部的命名空间及引用的命名空间全部删掉。

3.在aspx页面顶部用<%@ Import Namespace="Systerm"%>将之前删掉的命名空间引用进来。并把第一行的引用继承等删掉。

4.最后一步,删掉后台的aspx.cs和designer.cs,再对项目进行清理,重新生成,运行,大功告成!

 

我自己的实例:

 

<%@ Page Language="C#" AutoEventWireup="true" %>

<%@ Import Namespace="System" %>
<%@ Import Namespace="System.Collections.Generic" %>
<%@ Import Namespace="System.Linq" %>
<%@ Import Namespace="System.Web" %>
<%@ Import Namespace="System.Web.UI" %>
<%@ Import Namespace="System.Web.UI.WebControls" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="DNoteCNote" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <link href="css/IE.css" rel="stylesheet" type="text/css" />
    <style type="text/css">
       .fixHeaderStyle
        { PADDING-RIGHT: 0px;
        PADDING-LEFT: 0px;
        FONT-WEIGHT: bold;
        FONT-SIZE: 12px;
        VERTICAL-ALIGN: middle;
        LINE-HEIGHT: 20px;
        FONT-FAMILY: "Arial" , "Helvetica" , "sans-serif";
        POSITION: relative;
        TOP: expression(this.offsetParent.scrollTop-2);
        Z-INDEX: 5 ; HEIGHT: 26px; BACKGROUND-COLOR: #f0f0e8;
        TEXT-ALIGN: center; TEXT-DECORATION: none;
        ext-transform: capitalize ;
        }
         .hlink
        {
        height:25px;width:40px;color:Blue;font-size:15px;
            }
    </style>
    <script runat="server">
        public int inumber = 1;
        public int CurPage;
        public int pageSize = 500;
        protected string urlParams = "&tempnum=XXX&SESSIONID=XXX&PAGEREC=XXX";
        PagedDataSource PDS = new PagedDataSource();
        private string constr = @"data source=.\mssqlserver1;database=ATP_AI_AIR;uid=sa;pwd=123456";
        private string strsql = "";
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                bind();
            }
        }
        private void bind()
        {
            int TotalCount = 0;
            int TotalPage = 1;
            SqlConnection conn = new SqlConnection(constr);
            conn.Open();
            strsql = "select * from View_RPT_AI_DNOTE_CNOTE order by TempID ASC";
            SqlDataAdapter adapter = new SqlDataAdapter(strsql, conn);
            DataSet ds = new DataSet();
            adapter.Fill(ds, "dnotecnote");
            DataView dv = ds.Tables[0].DefaultView;
            TotalCount = dv.Count;
            PDS.DataSource = dv;
            conn.Close();
            PDS.AllowPaging = true;
            PDS.PageSize = pageSize;
            if (Request.QueryString["page"] != null)
            {
                CurPage = Convert.ToInt32(Request.QueryString["page"]);
            }
            else
                CurPage = 1;
            if (TotalCount == 0)
            {
                TotalPage = 1;
            }
            else
            {
                if (TotalCount % PDS.PageSize == 0)
                    TotalPage = TotalCount / PDS.PageSize;
                else
                    TotalPage = TotalCount / PDS.PageSize + 1;
            }
            PDS.CurrentPageIndex = CurPage - 1;
            lblCurrentPage.Text = "共" + TotalCount.ToString() + "条记录 当前页:" + CurPage.ToString() + "/" + TotalPage;
            lnkFrist.NavigateUrl = Request.CurrentExecutionFilePath + "?page=1" + urlParams;
            if (!PDS.IsFirstPage)
                lnkPrev.NavigateUrl = Request.CurrentExecutionFilePath + "?page=" + Convert.ToString(CurPage - 1) + urlParams;
            if (!PDS.IsLastPage)
                lnkNext.NavigateUrl = Request.CurrentExecutionFilePath + "?page=" + Convert.ToString(CurPage + 1) + urlParams;
            lnkEnd.NavigateUrl = Request.CurrentExecutionFilePath + "?page=" + TotalPage + urlParams;

            Repeater1.DataSource = PDS;
            Repeater1.DataBind();
        }
       
        </script>
</head>
<body>
    <form id="form1" runat="server">
    <div>   
    <asp:Repeater ID="Repeater1" runat="server">
    <HeaderTemplate>
     <table width="340%" id="tblResult" bgcolor="CornflowerBlue"  cellpadding=1 cellspacing=1 >
       <%-- <tr style="position:relative; top:expression(this.offsetParent.scrollTop);">
--%>
        <tr  class = "fixHeaderStyle">
        <td class="clsHeader">NO.</td>
        <td class="clsHeader">TempID</td>
        <td class="clsHeader">Type</td>
        <td class="clsHeader">ETA Date</td>
        <td class="clsHeader">MB/L#</td>
        <td class="clsHeader"> HB/L#</td>
        <td class="clsHeader">Party Type</td>
        <td class="clsHeader">Code</td>
        <td class="clsHeader">Name</td>
        <td class="clsHeader">Curr</td>
<%--        <td class="clsHeader">A/R</td>
        <td class="clsHeader">A/P </td>--%>
        <td class="clsHeader">发票号</td>
        <td class="clsHeader">开票日期</td>
        <td class="clsHeader">JobID</td>
        <td class="clsHeader">开票人</td>
        <td class="clsHeader">Sales</td>
        <td class="clsHeader">R/O</td>
       <%-- <td class="clsHeader">核销单</td>--%>
        <td class="clsHeader">Flight#/Date</td>
        <td class="clsHeader">ETA</td>
        <td class="clsHeader">Pay Terms</td>
        <td class="clsHeader">Agreement No.</td>
        <td class="clsHeader">No.</td>
        <td class="clsHeader">过账人</td>
        <td class="clsHeader">过账日期</td>
        <td class="clsHeader">过账凭证</td>
        <td class="clsHeader">记账人</td>
        <td class="clsHeader">记账日期</td>
        <td class="clsHeader">记账凭证</td>
        <td class="clsHeader">对账人</td>
        <td class="clsHeader">对账日期</td>
        <td class="clsHeader">对账凭证</td>
        <td class="clsHeader">签收人</td>
        <td class="clsHeader">签收日期</td>
        <td class="clsHeader">签收凭证</td>
        <td class="clsHeader">销账人</td>    

        <td class="clsHeader">销账日期</td>
        <td class="clsHeader">销账凭证</td>
        <td class="clsHeader">作废人</td>
        <td class="clsHeader">作废日期</td>
        <td class="clsHeader">LockBy</td>
        <td class="clsHeader">Orig.Curr</td>
        <td class="clsHeader">Orig.Amt</td>
        <td class="clsHeader">制单日期</td>
        <td class="clsHeader">制单人</td>
        </tr>
        </HeaderTemplate>
        <ItemTemplate>
        <tr style="background-color:White;">
        <td>
       <%=inumber + pageSize * (CurPage - 1)%>
       <% inumber = inumber + 1; %>
        </td>
        <td><%# DataBinder.Eval(Container.DataItem, "TempID")%></td>
      
        <td><%# DataBinder.Eval(Container.DataItem, "BILL_TYPE")%></td>
       <%-- <td><%# DataBinder.Eval(Container.DataItem, "ETD_DATE")%></td>--%>
        <%--<td><%# Convert.ToDateTime(DataBinder.Eval(Container.DataItem, "ETD_DATE").ToString())%></td>--%>
        <td> <%#Eval("ETD_DATE").ToString() == "" ? string.Empty : Convert.ToDateTime(Eval("ETD_DATE")).ToString("yyyy-MM-dd").Replace('-','/')%>
</td>
        <td><%# DataBinder.Eval(Container.DataItem, "MAWB_NUM")%></td>
        <td><%# DataBinder.Eval(Container.DataItem, "AWB_NUM")%></td>
        <td><%# DataBinder.Eval(Container.DataItem, "PARTY_TYPE_NAME")%></td>
        <td><%# DataBinder.Eval(Container.DataItem, "PARTY_CODE")%></td>
        <td><%# DataBinder.Eval(Container.DataItem, "PARTY_NAME")%></td>
        <td><%# DataBinder.Eval(Container.DataItem, "CURRENCY")%></td>
<%--        <td><%# DataBinder.Eval(Container.DataItem, "AR")%></td>
        <td><%# DataBinder.Eval(Container.DataItem, "AP")%></td>--%>
        <td><%# DataBinder.Eval(Container.DataItem, "TAXINV_NUM")%></td>
        <td> <%#Eval("TAXINV_DATE").ToString() == "" ? string.Empty : Convert.ToDateTime(Eval("TAXINV_DATE")).ToString("yyyy-MM-dd").Replace('-', '/')%>
</td>

        <td><%# DataBinder.Eval(Container.DataItem, "JOBID")%></td>
        <td><%# DataBinder.Eval(Container.DataItem, "TAXINV_BY")%></td>
        <td><%# DataBinder.Eval(Container.DataItem, "SALESMAN_CODE")%></td>
        <td><%# DataBinder.Eval(Container.DataItem, "OS_AGENT_CODE")%></td>
        <%--<td><%# DataBinder.Eval(Container.DataItem, "TR_NUM")%></td>--%>
        <td><%# DataBinder.Eval(Container.DataItem, "FLIGHT_NUM")%></td>
        <td> <%#Eval("FLIGHT_DATE").ToString() == "" ? string.Empty : Convert.ToDateTime(Eval("FLIGHT_DATE")).ToString("yyyy-MM-dd").Replace('-', '/')%>
</td>
        <td><%# DataBinder.Eval(Container.DataItem, "AE_AGREEMENT_NUM")%></td>
        <td><%# DataBinder.Eval(Container.DataItem, "AE_PAYTERMS_CODE")%></td>
        <td><%# DataBinder.Eval(Container.DataItem, "DN_CN_NUM")%></td>
        <td><%# DataBinder.Eval(Container.DataItem, "ISSUED_BY")%></td>
        <td> <%#Eval("ISSUED_DATE").ToString() == "" ? string.Empty : Convert.ToDateTime(Eval("ISSUED_DATE")).ToString("yyyy-MM-dd").Replace('-', '/')%>
</td>
        <td><%# DataBinder.Eval(Container.DataItem, "ISSUED_VOUCHER")%></td>
        <td><%# DataBinder.Eval(Container.DataItem, "POSTACCT_BY")%></td>
        <td> <%#Eval("POSTACCT_DATE").ToString() == "" ? string.Empty : Convert.ToDateTime(Eval("POSTACCT_DATE")).ToString("yyyy-MM-dd").Replace('-', '/')%>
</td>
        <td><%# DataBinder.Eval(Container.DataItem, "POSTACCT_VOUCHER")%></td>
        <td><%# DataBinder.Eval(Container.DataItem, "CHECKED_BY")%></td>
         <td> <%#Eval("CHECKED_DATE").ToString() == "" ? string.Empty : Convert.ToDateTime(Eval("CHECKED_DATE")).ToString("yyyy-MM-dd").Replace('-', '/')%>
</td>
        <td><%# DataBinder.Eval(Container.DataItem, "CHECKED_VOUCHER")%></td>
        <td><%# DataBinder.Eval(Container.DataItem, "RECEIPT_BY")%></td>
        <td> <%#Eval("RECEIPT_DATE").ToString() == "" ? string.Empty : Convert.ToDateTime(Eval("RECEIPT_DATE")).ToString("yyyy-MM-dd").Replace('-', '/')%>
</td>
        <td><%# DataBinder.Eval(Container.DataItem, "RECEIPT_VOUCHER")%></td>
        <td><%# DataBinder.Eval(Container.DataItem, "CANCELACCT_BY")%></td>
        <td> <%#Eval("CANCELACCT_DATE").ToString() == "" ? string.Empty : Convert.ToDateTime(Eval("CANCELACCT_DATE")).ToString("yyyy-MM-dd").Replace('-', '/')%>
</td>
        <td><%# DataBinder.Eval(Container.DataItem, "CANCELACCT_VOUCHER")%></td>
        <td><%# DataBinder.Eval(Container.DataItem, "VOID_BY")%></td>
        <td> <%#Eval("VOID_DATE").ToString() == "" ? string.Empty : Convert.ToDateTime(Eval("VOID_DATE")).ToString("yyyy-MM-dd").Replace('-', '/')%>
</td>
        <td><%# DataBinder.Eval(Container.DataItem, "LOCKED_BY")%></td>
        <td><%# DataBinder.Eval(Container.DataItem, "ORIG_CURR")%></td>
        <td><%# DataBinder.Eval(Container.DataItem, "ORIG_AMT")%></td>
        <td> <%#Eval("LASTUPDATE").ToString() == "" ? string.Empty : Convert.ToDateTime(Eval("LASTUPDATE")).ToString("yyyy-MM-dd").Replace('-', '/')%>
</td>
        <td><%# DataBinder.Eval(Container.DataItem, "MODIFIED_BY")%></td>      
        </tr>
        </ItemTemplate>
        <AlternatingItemTemplate>
        <tr>
        <td>
       <%=inumber + pageSize * (CurPage - 1)%>
       <% inumber = inumber + 1; %>
        </td>
        <td><%# DataBinder.Eval(Container.DataItem, "TempID")%></td>
      
        <td><%# DataBinder.Eval(Container.DataItem, "BILL_TYPE")%></td>
       <%-- <td><%# DataBinder.Eval(Container.DataItem, "ETD_DATE")%></td>--%>
        <%--<td><%# Convert.ToDateTime(DataBinder.Eval(Container.DataItem, "ETD_DATE").ToString())%></td>--%>
        <td> <%#Eval("ETD_DATE").ToString() == "" ? string.Empty : Convert.ToDateTime(Eval("ETD_DATE")).ToString("yyyy-MM-dd").Replace('-','/')%>
</td>
        <td><%# DataBinder.Eval(Container.DataItem, "MAWB_NUM")%></td>
        <td><%# DataBinder.Eval(Container.DataItem, "AWB_NUM")%></td>
        <td><%# DataBinder.Eval(Container.DataItem, "PARTY_TYPE_NAME")%></td>
        <td><%# DataBinder.Eval(Container.DataItem, "PARTY_CODE")%></td>
        <td><%# DataBinder.Eval(Container.DataItem, "PARTY_NAME")%></td>
        <td><%# DataBinder.Eval(Container.DataItem, "CURRENCY")%></td>
<%--        <td><%# DataBinder.Eval(Container.DataItem, "AR")%></td>
        <td><%# DataBinder.Eval(Container.DataItem, "AP")%></td>--%>
        <td><%# DataBinder.Eval(Container.DataItem, "TAXINV_NUM")%></td>
        <td> <%#Eval("TAXINV_DATE").ToString() == "" ? string.Empty : Convert.ToDateTime(Eval("TAXINV_DATE")).ToString("yyyy-MM-dd").Replace('-', '/')%>
</td>

        <td><%# DataBinder.Eval(Container.DataItem, "JOBID")%></td>
        <td><%# DataBinder.Eval(Container.DataItem, "TAXINV_BY")%></td>
        <td><%# DataBinder.Eval(Container.DataItem, "SALESMAN_CODE")%></td>
        <td><%# DataBinder.Eval(Container.DataItem, "OS_AGENT_CODE")%></td>
        <%--<td><%# DataBinder.Eval(Container.DataItem, "TR_NUM")%></td>--%>
        <td><%# DataBinder.Eval(Container.DataItem, "FLIGHT_NUM")%></td>
        <td> <%#Eval("FLIGHT_DATE").ToString() == "" ? string.Empty : Convert.ToDateTime(Eval("FLIGHT_DATE")).ToString("yyyy-MM-dd").Replace('-', '/')%>
</td>
        <td><%# DataBinder.Eval(Container.DataItem, "AE_AGREEMENT_NUM")%></td>
        <td><%# DataBinder.Eval(Container.DataItem, "AE_PAYTERMS_CODE")%></td>
        <td><%# DataBinder.Eval(Container.DataItem, "DN_CN_NUM")%></td>
        <td><%# DataBinder.Eval(Container.DataItem, "ISSUED_BY")%></td>
        <td> <%#Eval("ISSUED_DATE").ToString() == "" ? string.Empty : Convert.ToDateTime(Eval("ISSUED_DATE")).ToString("yyyy-MM-dd").Replace('-', '/')%>
</td>
        <td><%# DataBinder.Eval(Container.DataItem, "ISSUED_VOUCHER")%></td>
        <td><%# DataBinder.Eval(Container.DataItem, "POSTACCT_BY")%></td>
        <td> <%#Eval("POSTACCT_DATE").ToString() == "" ? string.Empty : Convert.ToDateTime(Eval("POSTACCT_DATE")).ToString("yyyy-MM-dd").Replace('-', '/')%>
</td>
        <td><%# DataBinder.Eval(Container.DataItem, "POSTACCT_VOUCHER")%></td>
        <td><%# DataBinder.Eval(Container.DataItem, "CHECKED_BY")%></td>
         <td> <%#Eval("CHECKED_DATE").ToString() == "" ? string.Empty : Convert.ToDateTime(Eval("CHECKED_DATE")).ToString("yyyy-MM-dd").Replace('-', '/')%>
</td>
        <td><%# DataBinder.Eval(Container.DataItem, "CHECKED_VOUCHER")%></td>
        <td><%# DataBinder.Eval(Container.DataItem, "RECEIPT_BY")%></td>
        <td> <%#Eval("RECEIPT_DATE").ToString() == "" ? string.Empty : Convert.ToDateTime(Eval("RECEIPT_DATE")).ToString("yyyy-MM-dd").Replace('-', '/')%>
</td>
        <td><%# DataBinder.Eval(Container.DataItem, "RECEIPT_VOUCHER")%></td>
        <td><%# DataBinder.Eval(Container.DataItem, "CANCELACCT_BY")%></td>
        <td> <%#Eval("CANCELACCT_DATE").ToString() == "" ? string.Empty : Convert.ToDateTime(Eval("CANCELACCT_DATE")).ToString("yyyy-MM-dd").Replace('-', '/')%>
</td>
        <td><%# DataBinder.Eval(Container.DataItem, "CANCELACCT_VOUCHER")%></td>
        <td><%# DataBinder.Eval(Container.DataItem, "VOID_BY")%></td>
        <td> <%#Eval("VOID_DATE").ToString() == "" ? string.Empty : Convert.ToDateTime(Eval("VOID_DATE")).ToString("yyyy-MM-dd").Replace('-', '/')%>
</td>
        <td><%# DataBinder.Eval(Container.DataItem, "LOCKED_BY")%></td>
        <td><%# DataBinder.Eval(Container.DataItem, "ORIG_CURR")%></td>
        <td><%# DataBinder.Eval(Container.DataItem, "ORIG_AMT")%></td>
        <td> <%#Eval("LASTUPDATE").ToString() == "" ? string.Empty : Convert.ToDateTime(Eval("LASTUPDATE")).ToString("yyyy-MM-dd").Replace('-', '/')%>
</td>
        <td><%# DataBinder.Eval(Container.DataItem, "MODIFIED_BY")%></td>      
        </tr>
        </AlternatingItemTemplate>
        <FooterTemplate>
        </table>
        </FooterTemplate>
    </asp:Repeater>
    <div>
            <asp:Label ID="lblCurrentPage" runat="server" ></asp:Label>
           
            <asp:HyperLink class="" style="background-color:;" ID="lnkFrist" runat="server"><span class="hlink">首页</span></asp:HyperLink>
            <asp:HyperLink class="" style="background-color:;" ID="lnkPrev" runat="server"><span class="hlink">上一页</span></asp:HyperLink>
            <asp:HyperLink class="" style="background-color:;" ID="lnkNext" runat="server"><span class="hlink">下一页</span></asp:HyperLink>
            <asp:HyperLink class="" style="background-color:;" ID="lnkEnd" runat="server"><span class="hlink">尾页</span></asp:HyperLink>

        </div>
    </div>
    </form>
</body>
</html>

 

 

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值