參賽作品
<% //3.SELECT ALL DATA(分頁) & ISSHOW = 1. string SelectListComm = "SELECT TOP " + pageSize + " [RowNumber],[ID],LEFT([Name],7) AS [ShortName],LEFT([WorksName],12) AS [ShortWorksName],LEFT([Description],40) AS [ShortDescription],[MovieType],[MovieID],[InsertTime],[likeCount] FROM (SELECT ROW_NUMBER() OVER (ORDER BY cast([likeCount] as int) DESC,[InsertTime]) AS RowNumber,* FROM [20160910_cheers_trending_film] WHERE [IsShow]='1') A WHERE RowNumber > " + pageSize + "*(" + Convert.ToString(page) + "-1) "; Cmd = new SqlCommand(SelectListComm, Conn); Conn.Open(); dr = Cmd.ExecuteReader(); while (dr.Read()) { string id = dr["ID"].ToString(); string name = (string)dr["ShortName"]; string worksName = dr["ShortWorksName"].ToString(); string description = dr["ShortDescription"].ToString(); string MovieType = dr["MovieType"].ToString(); string MovieID = dr["MovieID"].ToString(); string InsertTime = System.String.Format("{0:yyyy.MM.dd}", dr["InsertTime"]); string likeCount = dr["likeCount"].ToString(); string MovieIframe = ""; //設定影片iframe url if(MovieType =="2"){ MovieIframe = ""; } else if (MovieType == "3") { MovieIframe = ""; }else { MovieIframe = ""; } if (description.Length >= 39) { description = description + "...更多>>"; } %>
<%=MovieIframe%>
<%
}
//close DB.
if (dr != null)
{
Cmd.Cancel();
dr.Close();
}
if (Conn.State == ConnectionState.Open)
{
Conn.Close();
Conn.Dispose();
}
%>
<%=worksName %>
<%--人氣：<%=likeCount %>
--%><%=InsertTime %>
<%-- --%>作者／製作團隊：<%=name %>
<%=description%>
<%
pageAll = Convert.ToInt32(Math.Ceiling(Convert.ToDouble(totleCount) / Convert.ToDouble(pageSize)));
//上一頁.
if (page > 1)
{
Response.Write(" < ");
}
else
{
Response.Write(" < ");
}
//1~x頁.
for (int i = 1; i <= pageAll; i++)
{
if (page == i)
{
Response.Write("" + page + "");
}
else
{
Response.Write("" + i + "");
}
}
//下一頁.
if (page < pageAll){
Response.Write(" > ");
}
else
{
Response.Write(" > ");
}
%>