WEB开发网
开发学院WEB开发Ajax 一個Ajax.NET的查詢實例 阅读

一個Ajax.NET的查詢實例

 2006-07-08 11:15:40 来源:WEB开发网   
核心提示:因為項目中只能用.net 1.1,所以atlas是用不了了,只能玩玩AjaxPRofession.net, 下面是一個查詢的案例,一個Ajax.NET的查詢實例, 在頁面上放置一個DataGrid1,各種查詢結果均放入其中,在client端的JS中將SQL語句傳給server端的方法,attachment 參數表示作為

因為項目中只能用.net 1.1,所以atlas是用不了了,只能玩玩AjaxPRofession.net, 下面是一個查詢的案例。 在頁面上放置一個DataGrid1,各種查詢結果均放入其中,在client端的JS中將SQL語句傳給server端的方法,執行一個查詢,並可以控制雙擊行是否展開一個新的查詢。可將DataGrid1的內容導出到Excel中、模擬Gmail的Ajax的loading運用

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.sessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.IO;
namespace eol
{
   /**//// <summary>
   /// index 的摘要描述。
   /// </summary>
   public class index : System.Web.UI.Page
   {
     protected System.Web.UI.WebControls.TextBox TextBox1;
     protected WebControlLibrary.InputCalendar startTime;
     protected WebControlLibrary.InputCalendar endTime;
     protected WebControlLibrary.InputCalendar pStartTime;
     protected WebControlLibrary.InputCalendar pEndTime;
     protected System.Data.SqlClient.SqlConnection Conn=new SqlConnection();
     protected System.Web.UI.WebControls.TextBox eformsn;
     protected System.Web.UI.WebControls.Label Label1;
     protected System.Web.UI.WebControls.DataGrid DataGrid1=new DataGrid();
     protected System.Web.UI.WebControls.Button Button2;
     protected System.Web.UI.HtmlControls.HtmlInputText applicant;
     public string toExcel;
  
     private void Page_Load(object sender, System.EventArgs e)
     {
       AjaxPro.Utility.RegisterTypeForAjax(typeof(eol.index));
     }

   public DataSet DB(string dataName, string sqlCmd)
     {
       string connStr="server=172.16.0.120;uid=msikdb;pwd=dbmsik;database="+dataName;
       Conn.ConnectionString=connStr;
       try
       {
         Conn.Open();
       }
       catch(Exception ex)
       {
         Conn.Close();
         Response.Write(ex.Message);
       }
       SqlCommand cmd=new SqlCommand(sqlCmd, Conn);
       SqlDataAdapter da=new SqlDataAdapter();
       da.SelectCommand=cmd;
       DataSet ds = new DataSet();
       da.Fill(ds);
       Conn.Close();
       return ds;
     }

   Web Form 設計工具產生的程式碼#region Web Form 設計工具產生的程式碼
     override protected void OnInit(EventArgs e)
     {
       //
       // CODEGEN: 此為 asp.net Web Form 設計工具所需的呼叫。
       //
       InitializeComponent();
       base.OnInit(e);
     }
    
     /**//// <summary>
     /// 此為設計工具支援所必須的方法 - 請勿使用程式碼編輯器修改
     /// 這個方法的內容。
     /// </summary>
     private void InitializeComponent()
     {  
       this.Conn = new System.Data.SqlClient.SqlConnection();
       this.Button2.Click += new System.EventHandler(this.Button2_Click);
       this.DataGrid1.ItemCreated += new System.Web.UI.WebControls.DataGridItemEventHandler(this.getPageIndexStyle);
       this.Load += new System.EventHandler(this.Page_Load);

   }
     #endregion


     private void getPageIndexStyle(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
     {
      
       if(e.Item.ItemType == ListItemType.Pager)
       {
         e.Item.Cells[0].Text="Total Row:"+this.DataGrid1.Items.Count.ToString();
       }
     }
    
     [AjaxPro.AjaxMethod]
     public string AjaxData(string sSql, bool clientEvent)
     {
       if (clientEvent)
       {
         DataGrid1.ItemDataBound+=new DataGridItemEventHandler(DataGrid1_ItemDataBound);
       }
//       DataGrid1.AllowPaging=true;
//       DataGrid1.PagerStyle.Position=PagerPosition.Top;
//       DataGrid1.PagerStyle.Mode=PagerMode.NumericPages;
//       DataGrid1.ItemCreated+=new DataGridItemEventHandler(getPageIndexStyle);
       DataGrid1.DataSource=DB("query",sSql);
       DataGrid1.HeaderStyle.BackColor=System.Drawing.Color.Blue;
       DataGrid1.Width=Unit.Percentage(100);
       DataGrid1.HeaderStyle.ForeColor=System.Drawing.Color.White;
       DataGrid1.DataBind();
      
      
       System.Text.StringBuilder sb=new System.Text.StringBuilder();
       System.IO.StringWriter sw=new System.IO.StringWriter(sb);
       System.Web.UI.HtmlTextWriter htw=new HtmlTextWriter(sw);
       this.DataGrid1.RenderControl(htw);
       string s=sb.ToString().Replace(" 上午 12:00:00", "");
       this.toExcel=s;
       Session["txtExcel"]=s;
       return s;
     }
    
     public void setToExcel()
     {
       //下面這行很重要,attachment 參數表示作為附件下載,您可以改成online在線打開
       //filename=FileFlow.xls 指定輸出文件的名稱,注意其擴展名和指定文件類型相符,可以為:.doc    .xls    .txt  .htm  
       Response.AppendHeader("Content-Disposition","attachment;filename=EOL_"+eformsn.Text+".xls");
       Response.ContentEncoding=System.Text.Encoding.GetEncoding("big5"); 
       //Response.ContentType指定文件類型 可以為application/ms-excel,application/ms-Word ,application/ms-txt,application/ms-html或其他瀏覽器可直接支持文檔 
       Response.ContentType = "application/ms-excel";

     Response.Write(this.toExcel);
       Response.Write(Session["txtExcel"]);
       Session.Abandon();
       Response.End();
     }

   private void Button2_Click(object sender, System.EventArgs e)
     {
       setToExcel();
     }

   private void DataGrid1_ItemDataBound(object sender, DataGridItemEventArgs e)
     {
       ListItemType itemtype=(ListItemType)e.Item.ItemType;
       if (itemtype!=ListItemType.Header && itemtype!=ListItemType.Footer && itemtype!=ListItemType.Separator)
       {
         e.Item.Attributes.Add("ondblclick", "showDetail("+e.Item.Cells[1].Text+");");
         e.Item.Attributes.Add("onmouSEOver","this.className='mouseOn'");
         e.Item.Attributes.Add("onmouseout", "this.className=''");
       }
     }

   }
}
Client端的js:
<script language="javascript">    
var obj=document.all;
var frm=document.forms[0];
var box=document.getElementById("detail");
var list=document.getElementById("datagrid");

if(typeof ASP == "undefined") ASP={};
ASP.LoadingDemo_class = function() {};
Object.extend(ASP.LoadingDemo_class.prototype, Object.extend(new AjaxPro.AjaxClass(), {
   LongOperation: function() {
     return this.invoke("LongOperation", {}, this.LongOperation.getArguments().slice(0));
   },
   url: '/ajaxpro/ASP.LoadingDemo,App_Web_t_mu_tej.ashx'
}));
ASP.LoadingDemo = new ASP.LoadingDemo_class();

var c = 0;
AjaxPro.onLoading = function(b) {
   c++;
   window.status = c;
   var l = document.getElementById("loadinfo");
   l.style.visibility = b ? "visible" : "hidden";
    l.style.right=0;
   l.style.pixelTop=document.body.scrollTop;
}

function showDetail(n) {
   c = 0;
   ASP.LoadingDemo.LongOperation(new Function('getEolByeFormsn('+n+')'));
}

function getDataGrid(sql,Event)
{
   if(list.style.display=='none')
   {
     list.style.display='';
   }
   box.style.display=='' ? box.style.display='none':void(0);
   var p=eol.index.AjaxData(sql, Event).value;
   list.innerHTML=p;
}

function getEolByeFormsn(n)
{
   if (box.style.display=="none")
   {
     box.style.display="";
     box.innerHTML="<div id='toolbar'><div id='btnGoback' ><img src=http://172.16.0.134/webflow/images/cch.gif>GO BACK</div></div>"
   }
   list.style.display="none";
   var p=eol.index.AjaxData("select * from msi_eol_list_line t where eformsn="+n, false).value;
   box.innerHTML+=p;
}

window.onload=function ()
{
   box.style.display="none";
   list.style.display="none";
   document.getElementById("btnQuery").onclick=whenQuery;
   document.getElementById("btnToexcel").style.visibility="hidden";
   document.getElementById("btnHelp").onclick=getHelp;
}
function goBack()
{
   box.style.display='none';
   list.style.display='';
}
function whenQuery()
{
   var type=document.getElementById("types");
   var err=time=param='';
   var sql="select distinct (select Count(eformsn) from query.dbo.msi_eol_list_line where eformsn=w.eformsn) Line, w.* from (select eFormsn, Cast(Apply_Date as datetime) as ApplyDate, Applicant, LOB, Cast(p_date as datetime) as PendingDate, 'process' as Status from webflow.dbo.tb_326_1 union select eformsn, Cast(apply_date as datetime), applicant, lob, Cast(p_date as datetime), 'over' as Status from webflowdata.dbo.tb_326_1 where flowendstatus='E') w inner join query.dbo.msi_eol_list_line as e on w.eformsn=e.eformsn where (w.eformsn=e.eformsn) ";
   switch (type.value)
   {
     case "eformsn":
       if (frm.eformsn.value!='')
       {
         param="and e.eformsn='"+frm.eformsn.value+"'";
       }else{
         err="請輸入申請單號.!"
       }
       break;
     case "applytime":
       if (frm.startTime.value=='' && frm.endTime.value=='')
       {
         err="請輸入申請起止時間";
       }
       break;
     case "applicant":
       if (frm.applicant.value!="")
       {
         param+="and e.applicant='"+frm.applicant.value+"' order by w.ApplyDate";
       }else{
         err='請輸入申請者中文名';
       }
       break;
     case "lob":
       if (frm.lob.value!="")
       {
         param="and w.lob='"+frm.lob.value+"'";      
       }else{
         err="請輸入LOB";
       }
       break;
     case "pendingtime":
       if (frm.pStartTime.value!="" && frm.pEndTime.value!=""){
         param=" and w.PendingDate between cast('"+frm.pStartTime.value+"' as datetime) and cast('"+frm.pEndTime.value+"' as datetime) order by w.PendingDate";
       }else{
         err="請輸入Pending Time";
       }
       break;
     case "model":
       if (frm.model.value!=''){
         frm.startTime.value=frm.endTime.value='';
         sql='';
         param="select distinct (select count(model) from query.dbo.msi_eol_list_line where model=e.model) Total, eFormsn, Model, Applicant, LOB, Cast(Creation_date as datetime) as ApplyDate, Cast(pending_date as datetime) as PendingDate, (select Status from (select eFormsn, 'process' as Status from webflow.dbo.tb_326_1 union select eformsn, 'over' as Status from webflowdata.dbo.tb_326_1 where flowendstatus='E') as w where w.eformsn=e.eformsn) as Status from query.dbo.msi_eol_list_line as e where e.model='"+frm.model.value+"' group by Model, Applicant, LOB, Creation_date, Pending_Date, eformsn";
       }else{
         err="請輸入Model";
       }
       break;
   }
   if (err=='')
   {
     if (frm.startTime.value!='' && frm.endTime.value!='')
     {
       time="and ApplyDate between Cast('"+frm.startTime.value+"' as datetime) and Cast('"+frm.endTime.value+"' as datetime) ";
     }

   sql+=time+param;
     //document.write(sql);
     c = 0;
     ASP.LoadingDemo.LongOperation(new Function('getDataGrid("'+sql+'",true)'));
   }else{
     alert(err);
   }
}

var oPopup = window.createPopup();
function getHelp()
{
  var oPopupBody = oPopup.document.body;
  var lefter = screen.width-150;
  var topper = document.body.scrollTop;
  oPopupBody.innerHTML = helpbox.innerHTML;
  oPopup.show(lefter, topper, 280, document.body.offsetHeight, document.body);
  document.body.onmouseup = new Function("oPopup.hide();");
}
</script>

http://floatping.cnblogs.com/archive/2006/07/07/445225.html

Tags:Ajax NET 查詢實

编辑录入:爽爽 [复制链接] [打 印]
赞助商链接