四、实例
前台代码
<script type ="text/javascript" >
//根据SQL条件，获取后台求和结果
function SumOfAjax()
{
FLX.ComplexQuery.TestAjaxpro.AjaxSumData($("TxtSQL").value,ResultResp);
$("TxtResult").value= "正在处理，请稍候";
}
function ResultResp( resp )
{
$("TxtResult").value = resp.value ;
}
</script>
//根据SQL条件，获取后台求和结果
function SumOfAjax()
{
FLX.ComplexQuery.TestAjaxpro.AjaxSumData($("TxtSQL").value,ResultResp);
$("TxtResult").value= "正在处理，请稍候";
}
function ResultResp( resp )
{
$("TxtResult").value = resp.value ;
}
</script>
后台代码
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using FLX.ORM;
namespace FLX.ComplexQuery
{
public partial class TestAjaxpro : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
//注册ajaxpro类
AjaxPro.Utility.RegisterTypeForAjax(typeof(FLX.ComplexQuery.TestAjaxpro));
}
/// <summary>
/// 供前台AJAX调用 统计求和，结果返回前台；
/// </summary>
/// <returns></returns>
[AjaxPro.AjaxMethod]
public int AjaxSumData(string strSQL)
{
int Sum=0;
string sql = strSQL;
DataTable dt = new DataTable();
dt = FLX.ORM.BrokerFactory.GetBroker(Config.DataBasePath).DataAccess.ExecuteDataTable(sql);
for (int i = 0; i < dt.Rows.Count; i++)
{
Sum += Convert.ToInt32(dt.Rows[i]["num"].ToString());
}
return Sum;
}
}
}
using System.Collections;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using FLX.ORM;
namespace FLX.ComplexQuery
{
public partial class TestAjaxpro : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
//注册ajaxpro类
AjaxPro.Utility.RegisterTypeForAjax(typeof(FLX.ComplexQuery.TestAjaxpro));
}
/// <summary>
/// 供前台AJAX调用 统计求和，结果返回前台；
/// </summary>
/// <returns></returns>
[AjaxPro.AjaxMethod]
public int AjaxSumData(string strSQL)
{
int Sum=0;
string sql = strSQL;
DataTable dt = new DataTable();
dt = FLX.ORM.BrokerFactory.GetBroker(Config.DataBasePath).DataAccess.ExecuteDataTable(sql);
for (int i = 0; i < dt.Rows.Count; i++)
{
Sum += Convert.ToInt32(dt.Rows[i]["num"].ToString());
}
return Sum;
}
}
}
