第一步:.cs文件
using NetWing.Common;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.Sql;
using System.Data.SqlClient;
using NetWing.Common.Data.SqlServer;
namespace NetWing.BPM.Admin.weixin
{
public partial class productlist : System.Web.UI.Page
{
<!--建立一个全局变量-->
public DataTable dt = null;
protected void Page_Load(object sender, EventArgs e)
{
//判断用户是否登录
//string uid = CookieHelper.GetCookie("currentUserID");//得到用户id
//if (string.IsNullOrEmpty(uid))//说明没有登录
//{
// Response.Redirect("login.aspx");
//}
//else
//{
//}
<!--利用全局变量为变量获取数据表-->
dt = SqlEasy.ExecuteDataTable("select *,(select COUNT(*) from wzsh_khxx where productid=KeyId)as shu from wzsh_product order by sort_id asc");
}
}
}
第二步.aspx前台页面
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="productlist.aspx.cs" Inherits="NetWing.BPM.Admin.weixin.productlist" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Data.Sql" %>
<!DOCTYPE html>
<!-- saved from url=(0033)http://www.mana.com/card/detail/3 -->
<html style="font-size: 37.5px;">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>产品中心</title>
<meta name="viewport" content="width=device-width,initial-scale=1,minimum-scale=1,maximum-scale=1">
<meta name="Keywords" content="">
<meta name="Description" content="">
<link rel="stylesheet" href="cssandjs/creditcard.css">
<script type="text/javascript" src="cssandjs/jquery-1.10.2.min.js"></script>
</head>
<body>
<div id="creditcard">
<header>
<div class="logo">
<a href="javascript:history.back(-1);" class="">
<samp class="fanhui"></samp></a>
</div>
<div class="title">产品中心</div>
</header>
<div class="flnav_box">
<ul>
<li>
<a href=""><i></i>房贷</a>
</li>
<li>
<a href=""><i></i>房贷</a>
</li>
<li>
<a href=""><i></i>房贷</a>
</li>
<li>
<a href=""><i></i>房贷</a>
</li>
<li>
<a href=""><i></i>房贷</a>
</li>
<li>
<a href=""><i></i>房贷</a>
</li>
<li>
<a href=""><i></i>房贷</a>
</li>
<li>
<a href=""><i></i>房贷</a>
</li>
</ul>
</div>
<!--循环开始-->
<div class="card-info">
<div class="mainlist" id="productlist">
<div class="pro_list">
<ul>
<%foreach (DataRow dr in dt.Rows)
{%>
<li>
<!--后端变量赋值后可在此使用字段获取数据-->
<div class="tup_box">
<a href="/weixin/daikuan.aspx?keyid=<%=dr["KeyId"].ToString() %>">
<img src="<%=dr["img_url"].ToString() %>"" />
</a>
</div>
<div class="wenz_box">
<h2><a href="/weixin/daikuan.aspx?keyid=<%=dr["KeyId"].ToString() %>"><%=dr["title"].ToString() %></a></h2>
<div class="sup_box">
<p><span class="sup1">借款范围:</span><span class="sup2"><%=dr["range"].ToString() %></span></p>
<p><span class="sup1">借款期限:</span><span class="sup2"><%=dr["term"].ToString() %></span></p>
<p><span class="sup1">申请人数:</span><span class="sup2"><%=dr["shu"].ToString() %>人</span></p>
<p><a href="/weixin/daikuan.aspx?keyid=<%=dr["KeyId"].ToString() %>">查看详情</a></p>
</div>
</div>
</li>
<%} %>
</ul>
</div>
</div>
</div>
</div>
</body>
</html> Copyright © 2004-2024 Ynicp.com 版权所有 法律顾问:建纬(昆明)律师事务所 昆明市网翼通科技有限公司 滇ICP备08002592号-4
