110,533
社区成员
发帖
与我相关
我的任务
分享
<a href="default.aspx?classid=4&keywords=<%=keyword%>&userid=<%=tuserid%>&sort=2">按成单日期排序</a>
string sort = Request["sort"];
string orderstr = "id";
switch (sort)
{
case "1":
orderstr = "recorddate";
break;
case "2":
orderstr = "finishyear desc,finishmonth desc,adddate desc,id";
break;
default:
orderstr = "id";
break;
}
string page = Request["page"];
Page PageClass = new Page(tables, "id,username,tel,email,(select top 1 tname from customer_users where id=" + tables + ".userid) as tname,(select top 1 id from customer_record where comid=" + tables + ".id) as reid,price,adddate,finishyear,finishmonth", wheres, orderstr, "1", "id", "" + urls + "?keywords=" + keyword + "&classid=" + classid + "&sort=" + sort + "&userid=" + tuserid + "&adddate=" + adddate + "&page=", 30, page, "");
PageClass.Get_Content(newslist);
pagestring.Text = PageClass.Get_Page();
case "2":
orderstr = "finishyear desc,finishmonth desc,adddate desc,id";
break;