📄 yx_cms.txt
字号:
html.Append("</tr><tr>");
}
}
sdr.Close();
}
html.Append("</tr></table>");
Exsql.Close();
return html.ToString();
}
#endregion
/// <summary>
///
/// </summary>
/// <param name="row"></param>
/// <param name="Tnum"></param>
/// <param name="Cnum"></param>
/// <param name="Tstyle"></param>
/// <param name="Cstyle"></param>
/// <returns></returns>
public string Hope_PageBrandList(int row, int Tnum, int Cnum, string Tstyle, string Cstyle)
{
int startnum = 0;
string chanshangfl = "";
int chanshangid = 0;
if (HttpContext.Current.Request["startnum"] != null)
{
startnum = Convert.ToInt32(HttpContext.Current.Request["startnum"].ToString());
} //初始化分页参数1(从记录中开始取数据的位置)
int pernum = row;
string ActionShow = "";
if (HttpContext.Current.Request["ActionShow"] != null)
{
ActionShow = HttpContext.Current.Request["ActionShow"].ToString();
}
string Action = "";
if (HttpContext.Current.Request["Action"] != null)
{
Action = HttpContext.Current.Request["Action"].ToString();
}
Exsql.Open();
int pinpai = 0;
if (HttpContext.Current.Request.QueryString["YX_PinPaiName"] != null)
{
pinpai = Convert.ToInt32(HttpContext.Current.Request.QueryString["YX_PinPaiName"]);
}
if (HttpContext.Current.Request.QueryString["chanshangfl"] != null)
{
chanshangfl = HttpContext.Current.Request.QueryString["chanshangfl"].ToString();
}
if (HttpContext.Current.Request.QueryString["chanshangid"] != null)
{
chanshangid = Convert.ToInt32(HttpContext.Current.Request.QueryString["chanshangid"]);
}
string sql = "select * from yx_product where yx_id<>0";
if (pinpai != 0)
{
sql = sql + " and yx_pinpai=" + pinpai + "";
}
else
{
sql = sql + " and yx_pinpai<>0";
}
if (chanshangfl != "")
{
sql = sql + " and zdname6='" + chanshangfl + "'";
}
if (chanshangid != 0)
{
sql = sql + " and zdname7=" + chanshangid + "";
}
string sql2 = sql.Replace("*", "Count(*)");
StringBuilder Sbuilder = new StringBuilder();
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(sql, Exsql.con);
string displaylist = "";
if (ActionShow == "Show2")
{
displaylist = "图片版";
int NewPer = 20;
da.Fill(ds, startnum, NewPer, "table");
}
else
{
displaylist = "图文版";
da.Fill(ds, startnum, pernum, "table");
}
string displayaction = "全部显示";
int i = 1;
Sbuilder.Append(@"<table width='100%' border='0' cellspacing='0' cellpadding='0'>");
Sbuilder.Append(@"<tr><td width='100%' valign='top'>");
Sbuilder.Append(@"<table width='100%' border='0' cellpadding='0' cellspacing='0'>");
Sbuilder.Append(@"<tr>");
Sbuilder.Append(@"<td width='1%'><img src='{$Hope_SitUrl$}{$Hope_Skin$}images/lb1.jpg' width='8' height='34'></td>");
Sbuilder.Append(@"<td width='100%'background='{$Hope_SitUrl$}{$Hope_Skin$}images/lb2.jpg'><TABLE cellPadding='0' width='97%'>");
Sbuilder.Append(@"<TBODY>");
Sbuilder.Append(@"<TR>");
Sbuilder.Append(@"<TD width='48'> </TD>");
Sbuilder.Append(@"<TD width='55'></TD>");
Sbuilder.Append(@"<TD width='82'></TD>");
Sbuilder.Append(@"<TD width='82'></TD>");
Sbuilder.Append(@"<TD width='82'></TD>");
Sbuilder.Append(@"<TD width='82'></TD>");
Sbuilder.Append(@"<TD width='213' align='right'>显示方式：<A href='BrandArea.aspx?ActionShow=Show1&ClassId=" + pinpai +"' class="+ proliststyle(ActionShow, "Show1") + ">图文版</A> | <A href='BrandArea.aspx?ActionShow=Show2&ClassId=" + pinpai + "' class=" + proliststyle(ActionShow, "Show2") + ">图片版</A></TD>");
Sbuilder.Append(@"</TR>");
Sbuilder.Append(@"</TBODY>");
Sbuilder.Append(@"</TABLE></td>");
Sbuilder.Append(@"<td width='1%'><img src='{$Hope_SitUrl$}{$Hope_Skin$}images/lb3.jpg' width='6' height='34'></td>");
Sbuilder.Append(@"</tr>");
Sbuilder.Append(@"</table>");
Sbuilder.Append(@"</td><tr><td bgcolor='#f4f4f4' style='height:22px;padding-left:20px;'>以下 <span class=orderclass2>" + ds.Tables["table"].Rows.Count + " </span>条结果按 <span class=orderclass2>" + displayaction + "</span> 排列，显示方式是 <span class=orderclass2>" + displaylist + "</span> </td></tr>");
Sbuilder.Append("<tr><td><table cellSpacing=0 border=0 align=center width='100%'><tr>");
foreach (DataRow dr in ds.Tables["table"].Rows)
{
if (ActionShow == "Show2")
{
Sbuilder.Append(@"<TD align=center><TABLE cellSpacing=0 border=0 align=center width='100%'>");
Sbuilder.Append(@"<TR><TD align=center> <a href='ShowProduct.aspx?YX_MID=" + dr["YX_ID"].ToString() + "'>");
Sbuilder.Append(@"<IMG height=120 src='" + dr["YX_Spic"].ToString() + "' alt='" + dr["YX_Spic"].ToString() + "' width=120 border=0></a>");
Sbuilder.Append(@"</TD></TR>");
Sbuilder.Append(@"<tr><td align='center'><a href='{$Hope_SitUrl$}ShowProduct.aspx?YX_MID=" + dr["YX_ID"].ToString() + "'> <span class=" + Tstyle + ">" + dr["YX_ProductName"].ToString() + "</A></td></tr>");
Sbuilder.Append(@"<TR><TD class='DZ' align=center> 市价:" + C1Round(Convert.ToDouble(dr["YX_ProPrice"].ToString()), 2) + "元</TD></TR>");
Sbuilder.Append(@"<TR><TD align=center>商城价:" + C1Round(propic(DZ(dr["YX_ProDZ"].ToString()), Convert.ToDouble(dr["YX_ProPrice"])), 2) + "元<br>计量单位:" + dr["YX_ProDw"].ToString() + " </TD></TR><tr><td align=center>");
if (HttpContext.Current.Session["userrank"] != null)
{
Sbuilder.Append(MemberPrice(dr["YX_ProPrice"].ToString(), dr["YX_ProDw"].ToString(), dr["YX_ProDZ"].ToString()));
}
Sbuilder.Append(@"</td></tr><TR><TD align=center> <a href=Basket.aspx?YX_ID=" + dr["YX_ID"].ToString() + "><IMG src='{$Hope_SitUrl$}{$Hope_Skin$}images/buy_1.gif' border=0></a> <a href=ShowProduct.aspx?YX_MID=" + dr["YX_ID"].ToString() + "> <IMG src='{$Hope_SitUrl$}{$Hope_Skin$}images/buy_2.gif' border=0> </a><span onclick=\"javascript:add('" + dr["YX_Class"].ToString() + "','" + dr["YX_ID"].ToString() + "','" + dr["YX_ProductName"].ToString() + "');\" style='cursor:hand'> <IMG src='{$Hope_SitUrl$}{$Hope_Skin$}images/buy_3.gif' border=0> </span></TD></TR>");
Sbuilder.Append(@"</TABLE></TD>");
if (i % 5 == 0)
{
Sbuilder.Append("<TR>");
}
}
else
{
Sbuilder.Append(@"<td width='100%' valign='top'>
<table width='100%' border='0' cellspacing='0' cellpadding='0'>
<tr>
<td width='14%' valign='top'><table width='100%' border='0' cellspacing='0' cellpadding='0' height='70'>");
Sbuilder.Append(@"<tr>");
Sbuilder.Append(@"<td align='middle' style='padding:10px'> <a href='{$Hope_SitUrl$}ShowProduct.aspx?YX_MID=" + dr["YX_ID"].ToString() + "'>");
Sbuilder.Append(@" <IMG height=120 src='" + dr["YX_Spic"].ToString() + "' alt='" + dr["YX_Spic"].ToString() + "' width=120 border=0></a> </td>");
Sbuilder.Append(@"</tr></table></td>");
Sbuilder.Append(@"<td width='85%' valign='middle' align=left>");
Sbuilder.Append(@"<a href='{$Hope_SitUrl$}ShowProduct.aspx?YX_MID=" + dr["YX_ID"].ToString() + "'> <span class=" + Tstyle + "> 商品名称:" + dr["YX_ProductName"].ToString() + "</span></a>\n");
Sbuilder.Append(@" <br>");
if (HttpContext.Current.Session["userrank"] != null)
{
Sbuilder.Append(MemberPrice(dr["YX_ProPrice"].ToString(), dr["YX_ProDw"].ToString(), dr["YX_ProDZ"].ToString()));
}
else
{
Sbuilder.Append(@"<span class='price'> 商城价:￥" + C1Round(propic(DZ(dr["YX_ProDZ"].ToString()), Convert.ToDouble(dr["YX_ProPrice"])), 2) + "元<br> 计量单位:" + dr["YX_ProDw"].ToString() + "<br>");
}
Sbuilder.Append(@"<span class=" + Cstyle + "> 商品简介:" + dr["YX_ProCon"].ToString() + "</span>");
Sbuilder.Append(@"</td> </tr><tr><td colspan=3 align=right>");
Sbuilder.Append(@"<a href=Basket.aspx?YX_ID=" + dr["YX_ID"].ToString() + "><img src='{$Hope_SitUrl$}{$Hope_Skin$}images/niu_buy.gif' alt='放入购物车' border='0'> </a>");
Sbuilder.Append(@"<a href=ShowProduct.aspx?YX_MID=" + dr["YX_ID"].ToString() + "><IMG src='{$Hope_SitUrl$}{$Hope_Skin$}images/buy_big2.gif' border=0> </a> <span onclick=\"javascript:add('" + dr["YX_Class"].ToString() + "','" + dr["YX_ID"].ToString() + "','" + dr["YX_ProductName"].ToString() + "');\" style='cursor:hand'><img src='{$Hope_SitUrl$}{$Hope_Skin$}images/niu_buy_1.gif' alt='商品对比' border='0'></a></a><br>");
Sbuilder.Append(@"</td></tr></table></td></tr><tr><td height=2 style='border-top-width: 1px;border-top-style: dashed;border-top-color: #999999;'> </td></tr>");
}
i++;
}
Sbuilder.Append(@"</table></td></tr>");
Sbuilder.Append(@"</TABLE>");
if (i == 1)
{ Sbuilder.Append("<br><font color=red>无相关产品！</font> <a href='#' onclick='javascript:history.back(-1)'>返回首页 </a><br>"); }
int Pnum = 0;//取得数据库中的总记录
SqlCommand com = new SqlCommand(sql2, Exsql.con);
Pnum = Convert.ToInt32(com.ExecuteScalar());
if (startnum > Pnum - 1)
{
startnum = Pnum - pernum - 1; //处理超出总记录数
}
if (startnum - pernum < 0) //处理记录不足
{
startnum = 0;
}
if (i != 1)
{
if (ActionShow == "Show2")
{
int NewPer = 20;
Sbuilder.Append(Pager3(startnum, Pnum, NewPer, "classid", ActionShow));
}
else
{
Sbuilder.Append(Pager3(startnum, Pnum, pernum, "classid", ActionShow));
}
}
Exsql.Close();
Exsql.Dispose();
return Sbuilder.ToString();
}
#region 分页函数
/// <summary>
/// 分页函数：
/// </summary>
/// <param name="startnum">开始查询记录的位置</param>
/// <param name="count">查询的记录总数</param>
/// <param name="pernum">每页显示多少条记录</param>
/// <param name="Wname"></param>
/// <param name="ActionShow"></param>
/// <returns></returns>
private string Pager3(int startnum, int count, int pernum, string Wname, string ActionShow)
{
string ClassId = "";
if (HttpContext.Current.Request[Wname] == null || HttpContext.Current.Request[Wname] == "")
{
ClassId = "0";
}
else
{
ClassId = HttpContext.Current.Request[Wname];
}
//获取总的页数
int pagernum1 = 0;
if (count % pernum == 0)
{
pagernum1 = count / pernum;
}
else
{
pagernum1 = count / pernum + 1;
}
//获取当前页数
int curpage = (startnum + pernum) / pernum;
if (count - pernum == startnum)
{
curpage = pagernum1;
}
string str = "<br>";
str += "\n<script>function gono(str){window.location.href='?startnum='+str+'&" + Wname + "=" + ClassId + "&ActionShow=" + ActionShow + "';}</script>\n";
str += "<tr><td colspan=10 style='text-align:center'>共有记录" + count + "条 当前是第" + curpage + "页  共有" + pagernum1 + "页";
if (count > 0)
{
str += " <a href='?startnum=0&" + Wname + "=" + ClassId + "&ActionShow=" + ActionShow + "'>首页</a> ";
}
else
{
str += " 首页 ";
}
if ((startnum - pernum) >= 0)
{
str += "<a href='?startnum=" + (startnum - pernum) + "&" + Wname + "=" + ClassId + "&ActionShow=" + ActionShow + "'>上一页</a> ";
}
else
{
str += "上一页 ";
}
if ((startnum + pernum) <= count - 1)
{
str += "<a href='?startnum=" + (startnum + pernum) + "&" + Wname + "=" + ClassId + "&ActionShow=" + ActionShow + "'>下一页</a> ";
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -