JS操作Dataset,无涮新更新页面

来源:互联网 发布:淘宝退款不到账怎么办 编辑:程序博客网 时间:2024/04/29 09:00

<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
    }
}