<script type="text/javascript">
//<![CDATA[
// 163 AJAX Tab
// update 2006.10.18
// 增加鼠标延迟感应特性。
function test(rs) {
Yin.Default.GetSelectedValues(rs, get_country_Result_CallBack);
}
function test_call_back(res) {
//alert(res.value);
//document.getElementById("ware").innerHTML = res.value;
res = null;
}
function get_country_Result_CallBack(res){
if (typeof(res.value) == 'object'){
var ds = res.value;
var msg = document.getElementById("ware");
var msTab = ds.Tables[0];
var n = 1;
for (var i=0; i < msTab.Rows.length; ++i){
if(n % 4 == 0)
var s = s +"<div>"+msTab.Rows[i].infoName+"<br /><img src="+msTab.Rows[i].infoImg+" width=115 height=90></div></ul><ul>";
else
var s = s +"<div>"+msTab.Rows[i].infoName+"</span><span><img src="+msTab.Rows[i].infoImg+" width=115 height=90></div>";
n++;
//var s = s + "<tr><td>"+msTab.Rows[i].infoName+"</td></tr><tr><td><img src="+msTab.Rows[i].infoImg+" width=115 height=90></td></tr>";
};
alert(s);
msg.innerHTML ="<ul>"+s+"";
}
}
//]]>
</script>
using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using AjaxPro;
using System.Collections.Generic;
namespace Yin{
public partial class Default : System.Web.UI.Page{
protected void Page_Load(object sender, EventArgs e){
AjaxPro.Utility.RegisterTypeForAjax(typeof(Default));
}
protected string Chars(string str,int num){
str.Trim();
if (str.Length < num)
return str;
else
return str.Substring(0, num)+"...";
}
[AjaxMethod]
public DataSet GetSelectedValues(string yzs)
{
DataSet s = new DataSet();
switch (yzs)
{
case "雅砻":
s = myData(2);
break;
case "奇正":
s= myData(4);
break;
case "甘露":
s = myData(3);
break;
case "金诃":
s = myData(26);
break;
case "晶珠":
s = myData(28);
break;
case "其它":
s = myData(30);
break;
default:
s = myData(2);
break;
}
return s;
}
#region 该过程用来绑定数据
public DataSet myData(int num)
{
//首先建立DataSet对象,注意这里读取了全部数据
string strSql = "select infoName,infoImg,buyprice from WareInfo where infoType in (select typeId from WareType where typeFatherId =" + num + ")";
SqlDataAdapter adp = SqlHelper.ExecuteAdapter(CommandType.Text, strSql, null);
DataSet dst = new DataSet();
adp.Fill(dst, "WareInfo");
return dst;
//DataView dv = new DataView();
//dv.Table = dst.Tables[0];
//dv.RowFilter = "infoType =" +chars;//in ((select typeId from WareType where typeFatherId="+"))"; //+ "and isView = " + true;
}
#endregion
}
}