<%@ Page Language="C#"%> <%@ Import NameSpace = "System" %> <%@ Import NameSpace = "System.Data" %> <%@ Import NameSpace = "System.Data.SqlClient" %> <%@ Import NameSpace = "System.Web.Configuration" %> <% string ID = Request["id"]; bool result = IsNumeric(ID); //id為空值或非數字. if (!result) { ID = "1"; } string Name = "", NameSummary = "", WorksName = "", Description = "", MovieType = "", MovieID = "", InsertTime = ""; string CityName="",AreaName=""; string MovieIframe = ""; //設定影片iframe url string likeCount = ""; SqlConnection Conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["topicReader_ConnectionString"].ConnectionString); SqlCommand Cmd = new SqlCommand(); SqlDataReader dr = null; //此SQL用VIEW查詢. string SelectTopComm = "SELECT * FROM [20160910_cheers_trending_film] WHERE [ID]=@id and [IsShow]='1' "; Cmd = new SqlCommand(SelectTopComm, Conn); Cmd.Parameters.Clear(); Cmd.Parameters.Add("@id", SqlDbType.NVarChar, 200).Value = ID; Conn.Open(); dr = Cmd.ExecuteReader(); while (dr.Read()) { ID = dr["ID"].ToString(); Name = dr["Name"].ToString(); NameSummary = dr["NameSummary"].ToString(); WorksName = dr["WorksName"].ToString(); Description = dr["Description"].ToString(); MovieType = dr["MovieType"].ToString(); MovieID = dr["MovieID"].ToString(); InsertTime = System.String.Format("{0:yyyy.MM.dd}", dr["InsertTime"]); CityName = dr["CityName"].ToString(); AreaName = dr["AreaName"].ToString(); likeCount = dr["likeCount"].ToString(); } if (MovieType == "2") { MovieIframe = ""; } else if (MovieType == "3") { MovieIframe = ""; } else { MovieIframe = ""; } //close DB. if (dr != null) { Cmd.Cancel(); dr.Close(); } if (Conn.State == ConnectionState.Open) { Conn.Close(); Conn.Dispose(); } %> 「全民潮台灣」第二屆短片徵件競賽首獎20萬元 - 外交部xCheersx第一電商

參賽作品

<%=MovieIframe%>

<%=WorksName %>

<%=InsertTime %> <%=CityName %> <%=AreaName %>

<%--

人氣:<%=likeCount %>

--%> <%--

--%>

作者／製作團隊：<%=Name %>

作者／製作團隊簡介：<%=NameSummary %>

<%=Description %>