📄 yx_cms.txt
字号:
case "Tj":
sql = sql + " and YX_Tj=1 order by YX_Addtime desc,YX_ID desc";
displayaction = "推荐";
break;
case "Time":
sql = sql + " order by YX_AddTime desc";
displayaction = "时间";
break;
case "Sale":
sql = sql + " and YX_Sm=1 order by YX_Addtime desc,YX_ID desc";
displayaction = "热卖";
break;
case "Price":
sql = sql + " order by YX_ProPrice";
displayaction = "价格";
break;
default:
sql = sql + "order by YX_Addtime desc,YX_ID desc";
break;
}
}
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");
}
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='510' height='13' align='left'>排序方式： <A href='Productlist_1.aspx?Action=Sale&ClassId=" + classid + "&ActionShow=" + ActionShow + pagelinkurl + "' class=" + proliststyle(Action, "Sale") + ">按热卖</A> | <A href='Productlist_1.aspx?Action=Tj&ClassId=" + classid + "&ActionShow=" + ActionShow + pagelinkurl + "' class=" + proliststyle(Action, "Tj") + ">按推荐</A> | <A href='Productlist_1.aspx?Action=Price&ClassId=" + classid + "&ActionShow=" + ActionShow + pagelinkurl + "' class=" + proliststyle(Action, "Price") + ">按价格</A> | <A href='Productlist_1.aspx?Action=Time&ClassId=" + classid + pagelinkurl + "&ActionShow=" + ActionShow + "' class=" + proliststyle(Action, "Time") + ">按上架时间</A> | <A href='Productlist_1.aspx?Action=&ClassId=" + classid + "&ActionShow=" + ActionShow + pagelinkurl + "' class=" + proliststyle(Action, "") + ">全部显示</A></TD>");
Sbuilder.Append(@"<TD width='48'> </TD>");
Sbuilder.Append(@"<TD width='55'></TD>");
Sbuilder.Append(@"<TD width='82'></TD>");
Sbuilder.Append(@"<TD width='213'>显示方式：<A href='Productlist_1.aspx?ActionShow=Show1&ClassId=" + classid + "&Action=" + Action + pagelinkurl + "' class=" + proliststyle(ActionShow, "Show1") + ">图文版</A> | <A href='Productlist_1.aspx?ActionShow=Show2&ClassId=" + classid + "&Action=" + Action + pagelinkurl + "' 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 + ">" + newstr(dr["YX_ProductName"].ToString(), Tnum) + "</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 + ">商品名称:" + newstr(dr["YX_ProductName"].ToString(), Tnum) + "</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 + "> 商品简介:" + newstr(dr["YX_ProCon"].ToString(), Cnum) + "</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;
//取得数据库中的总记录
Pnum = Exsql.YX_Execint(sqlnum);
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(Pager2(startnum, Pnum, NewPer, Par, Action, ActionShow, pagelinkurl));
}
else
{
Sbuilder.Append(Pager2(startnum, Pnum, pernum, Par, Action, ActionShow, pagelinkurl));
}
}
ds.Clear();
ds.Dispose();
Exsql.Close();
Exsql.Dispose();
return Sbuilder.ToString();
}
#endregion
#region 商品批发横排显示，带分页{#Shop_PiFa*行数，标题显示字数，状态，参数名称,网站内容子数,标题样式,内容样式，是否显示分页}
/// <summary>
/// 商品横排显示，带分页
/// </summary>
/// <param name="row">每页显示的条数</param>
/// <param name="Tnum">商品标题显示的字数</param>
/// <param name="start">商品状态 1推荐 2特价 3热卖</param>
/// <param name="Par">参数名称</param>
/// <param name="Cnum">内容显示的字数</param>
/// <param name="Tstyle">标题显示的标式名称,直接填写class名称</param>
/// <param name="Cstyle">内容显示的标式名称,直接填写class名称</param>
/// <returns></returns>
public string Shop_PiFa(int row, int Tnum, int start, string Par, int Cnum, string Tstyle, string Cstyle)
{
string strid = "";
//查询具体的类别的商品的传递参数：
int classid = 0;
//商品名称
string PtName = "";
string pagelinkurl = "";
if (HttpContext.Current.Request["PtName"] != null)
{
PtName = ClearInputString(HttpContext.Current.Request["PtName"].ToString(), HttpContext.Current.Request["PtName"].ToString().Length);
pagelinkurl += "&PtName=" + HttpContext.Current.Server.UrlEncode(PtName);
}
//关键字
string PtKey = "";
if (HttpContext.Current.Request["PtKey"] != null)
{
PtKey = ClearInputString(HttpContext.Current.Request["PtKey"].ToString(), HttpContext.Current.Request["PtKey"].ToString().Length);
pagelinkurl += "&PtKey=" + HttpContext.Current.Server.UrlEncode(PtKey);
}
//商品编码
string PtNum = "";
if (HttpContext.Current.Request["PtNum"] != null)
{
PtNum = ClearInputString(HttpContext.Current.Request["PtNum"].ToString(), HttpContext.Current.Request["PtNum"].ToString().Length);
pagelinkurl += "&PtNum=" + PtNum;
}
//商品说明
string PtRemark = "";
if (HttpContext.Current.Request["PtRemark"] != null)
{
PtRemark = ClearInputString(HttpContext.Current.Request["PtRemark"].ToString(), HttpContext.Current.Request["PtRemark"].ToString().Length);
pagelinkurl += "&PtRemark=" + HttpContext.Current.Server.UrlEncode(PtRemark);
}
//搜索关键字类别
string SearchKind = "";
string SearchText = "";
if (HttpContext.Current.Request["SearchText"] != null)
{
SearchText = HttpContext.Current.Request["SearchText"].ToString();
if (HttpContext.Current.Request["SearchKind"] != null)
{
SearchKind = HttpContext.Current.Request["SearchKind"].ToString();
if (SearchKind == "1")
{
PtName = ClearInputString(SearchText, SearchText.Length);
pagelinkurl += "&PtName=" + PtName;
}
else if (SearchKind == "2")
{
PtKey = ClearInputString(SearchText, SearchText.Length);
pagelinkurl += "&PtKey=" + PtKey;
}
else if (SearchKind == "4")
{
PtNum = ClearInputString(SearchText, SearchText.Length);
pagelinkurl += "&PtNum=" + PtNum;
}
else
{
PtRemark = ClearInputString(SearchText, SearchText.Length);
pagelinkurl += "&PtRemark=" + PtRemark;
}
}
}
string PtMade = "";
if (HttpContext.Current.Request["PtMade"] != null)
{
PtMade = ClearInputString(HttpContext.Current.Request["PtMade"].ToString(), HttpContext.Current.Request["PtMade"].ToString().Length);
pagelinkurl += "&PtMade=" + HttpContext.Current.Server.UrlEncode(PtMade);
}
//商品价格范围
string PtPrice = "";
if (HttpContext.Current.Request["PtPrice"] != null)
{
PtPrice = HttpContext.Current.Request["PtPrice"].ToString();
pagelinkurl += "&PtPrice=" + HttpContext.Current.Server.UrlEncode(PtPrice);
}
//商品上架时间
int days = 0;
if (HttpContext.Current.Request["days"] != null)
{
days = Convert.ToInt32(HttpContext.Current.Request["days"]);
pagelinkurl += "&days=" + days;
}
//商品热卖
string ReMai = "";
if (HttpContext.Current.Request["ReMai"] != null)
{
ReMai = HttpContext.Current.Request["ReMai"].ToString();
pagelinkurl += "&ReMai=" + ReMai;
}
//商品特价
string TeJia = "";
if (HttpContext.Curr⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -