2 <!--
3 var focus_width=245;
4 var focus_height=147;
5 var text_height=20;//20
6 var swf_height = focus_height+text_height;
//var pic1='UploadFiles/Post/633187443499218750.jpg';
//var link1='http://www.ginwave.com';
//var text1='深圳市经纬科技有限公司';
//var pic2='UploadFiles/Post/633187443499218750.jpg';
//var link2='http://www.szhaca.com';
//var text2='深圳市河南商业协会';
//var pic3='UploadFiles/Post/633187443499218750.jpg';
//var link3='http://www.szu.edu.cn';//var text3='深圳大学辅导员办公室';
var pics=pic1+'|'+pic2+'|'+pic3 ;
var links=link1+'|'+link2+'|'+link3;
var texts=text1+'|'+text2+'|'+text3;
//Method2
1 var pic1=<%= ViewState["image1"]%>;
2 var link1='PostTransfer.aspx?TranID=<%= ViewState["link1"]%>';
3 var text1=<%= ViewState["name1"]%>;
4
5 var pic2=<%= ViewState["image2"]%>;
6 var link2='PostTransfer.aspx?TranID=<%= ViewState["link2"]%>';
7 var text2=<%= ViewState["name2"]%>;
8
9 var pic3=<%= ViewState["image3"]%>;
10 var link3='PostTransfer.aspx?TranID=<%= ViewState["link3"]%>';
11 var text3=<%= ViewState["name3"]%>;
2 document.write('<param name="allowScriptAccess" value="sameDomain"><param name="movie" value="images/DefaultAdPics/viewer.swf"><param name="quality" value="high"><param name="bgcolor" value="#E7E7E7">');
3 document.write('<param name="menu" value="false"><param name=wmode value="opaque">');
4 document.write('<param name="FlashVars" value="pics='+pics+'&links='+links+'&texts='+texts+'&borderwidth='+focus_width+'&borderheight='+focus_height+'&textheight='+text_height+'">');
5 document.write('<embed ID="focus_flash" src="images/DefaultAdPics/viewer.swf" wmode="opaque" FlashVars="pics='+pics+'&links='+links+'&texts='+texts+'&borderwidth='+focus_width+'&borderheight='+focus_height+'&textheight='+text_height+'" menu="false" bgcolor="#E4D8AA" quality="high" width="'+ focus_width +'" height="'+ focus_height +'" allowScriptAccess="sameDomain" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer"/>');
6 document.write('</object>');
7 //-->
8 </SCRIPT>
Code:
DataTable dt = GetImage();
int i=0;
if(i<dt.Rows.Count)
{
ViewState["image1"]= "'"+dt.Rows[i]["PImageSmall"].ToString().Replace("../UploadFiles/Post","UploadFiles/Post")+"'";
ViewState["link1"]= dt.Rows[i]["PostID"].ToString();
ViewState["name1"]= "'"+dt.Rows[i]["PostName"].ToString()+"'";
i++;
}
if(i<dt.Rows.Count)
{
ViewState["image2"] ="'"+ dt.Rows[i]["PImageSmall"].ToString().Replace("../UploadFiles/Post","UploadFiles/Post")+"'";
ViewState["link2"]= dt.Rows[i]["PostID"].ToString();
ViewState["name2"]= "'"+dt.Rows[i]["PostName"].ToString()+"'";
i++;
}
if(i<dt.Rows.Count)
{
ViewState["image3"] = "'"+ dt.Rows[i]["PImageSmall"].ToString().Replace("../UploadFiles/Post","UploadFiles/Post")+"'";
ViewState["link3"]= dt.Rows[i]["PostID"].ToString();
ViewState["name3"]= "'"+dt.Rows[i]["PostName"].ToString()+"'";
}
*****简单模式:DataTable dt = GetImage();
for(int i=1;i<dt.Rows.Count;i++)
{
ViewState["image"+i+""] = "'"+dt.Rows[i]["PImageSmall"].ToString().Replace("../UploadFiles/Post","UploadFiles/Post")+"'";
ViewState["link"+i+""]= dt.Rows[i]["PostID"].ToString();
ViewState["name"+i+""]= "'"+dt.Rows[i]["PostName"].ToString()+"'";
}
//获取图片flash模式
public DataTable GetImage()
{
DataTable dt = null;
SqlConnection Con = new SqlConnection(WebUIDemo.Code.Conn.ConnStr);
string strImg = "select PostID,PImageSmall,PostName from LPost where PImageSmall is not null order by PostID desc";
try
{
SqlDataAdapter sda = new SqlDataAdapter(strImg,Con);
DataSet ds = new DataSet();
sda.Fill(ds);
dt = ds.Tables[0];
}
catch(Exception ex)
{
Response.Write(ex.ToString());
}
return dt;
}
public void bing()
{
SqlConnection Con = new SqlConnection(WebUIDemo.Code.Conn.ConnStr);
SqlCommand cmd = new SqlCommand("select top 8 PostName,PostID from LPost where SortID in(8180,8181) order by PostID desc",Con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
string str = "<table cellpadding=0 cellspacing=\"5\" >";
for(int i = 0;i<dt.Rows.Count;i++)
{
str += "<tr><td> <a href=PostTransfer.aspx?TranID=" + dt.Rows[i]["PostID"].ToString()+">"+dt.Rows[i]["PostName"].ToString()+"</a></td></tr>";
}
str += "</table>";
ViewState["line"]=str;
}