直接在下面顯示明細,Ajax.!ResponseXML,DOM,DataGrid

21 篇文章 0 订阅

SalesOrder.aspx

DataGrid

      <asp:datagrid id="DGOrderList" runat="server" AllowPaging="True" Width="100%" AutoGenerateColumns="False"
       BorderColor="#3366CC" BorderStyle="None" BorderWidth="1px" BackColor="White" CellPadding="4"
       Font-Size="8px">
       <SelectedItemStyle Font-Bold="True" ForeColor="#CCFF99" BackColor="#009999"></SelectedItemStyle>
       <ItemStyle></ItemStyle>
       <HeaderStyle Font-Bold="True"></HeaderStyle>
       <FooterStyle></FooterStyle>
       <Columns>
        <asp:TemplateColumn HeaderText="核准">
         <ItemTemplate>
          <asp:CheckBox id=cboIsCheck runat="server" Checked='<%# Convert.ToBoolean(DataBinder.Eval(Container.DataItem, "IsCheck")) %>'>
          </asp:CheckBox>
         </ItemTemplate>
        </asp:TemplateColumn>
        <asp:TemplateColumn HeaderText="訂單編號">
         <ItemTemplate>
          <a runat=server href='#' οnclick=javascript:ShowDetails(this); title='<%# DataBinder.Eval(Container.DataItem,"Id") %>'>
           <%# DataBinder.Eval(Container.DataItem,"ID")%>
          </a>
         </ItemTemplate>
        </asp:TemplateColumn>
        <asp:BoundColumn DataField="CustName" HeaderText="客戶"></asp:BoundColumn>
        <asp:BoundColumn DataField="CustOrderID" HeaderText="客戶單號"></asp:BoundColumn>
        <asp:BoundColumn DataField="AllAmt" HeaderText="銷售總金額"></asp:BoundColumn>
        <asp:BoundColumn DataField="CurName" HeaderText="幣別"></asp:BoundColumn>
        <asp:BoundColumn DataField="InputName" HeaderText="開單人"></asp:BoundColumn>
        <asp:BoundColumn DataField="CheckName" HeaderText="核准人"></asp:BoundColumn>
        <asp:BoundColumn DataField="KeyDate" HeaderText="接單日期" DataFormatString="{0:yyyy-MM-dd}"></asp:BoundColumn>
       </Columns>
       <PagerStyle HorizontalAlign="Left" ForeColor="#003399" BackColor="#99CCCC" Mode="NumericPages"></PagerStyle>
      </asp:datagrid>

 

js Code:

  function ShowDetails(id)
  {   
   var sXML;
   var oNodeList;   
   var sURI = "SODetails.aspx?id="+id.title; 
      
   sXML = returnXML(sURI); 
   var xmlDoc = DOMDocument();   
   xmlDoc.loadXML(sXML);    
   
   var xslDoc = DOMDocument();
   xslDoc.load("xsl.xsl");
   land.innerHTML = sXML;
   //land.innerText =sXML;
   land.innerHTML = xmlDoc.transformNode(xslDoc); 
  }
  
  function DOMDocument()
  {
   var xmlDoc = new ActiveXObject("Msxml.DOMDocument");
   xmlDoc.async = false;   
   return xmlDoc
  }
  
  
  function returnXML(URI)
  {    
   xmlhttp = vb(); 
   if(xmlhttp!=null)
   {
    xmlhttp.onreadystatechange = Process;  
    xmlhttp.Open("POST",URI, false);         
    xmlhttp.send("");   
    return xmlhttp.responseXML.xml;
   }
   else
   {
    return null;
   }
  }

 

 

SaDetails.aspx.cs

 

  private void Page_Load(object sender, System.EventArgs e)
  {
   if(!Page.IsPostBack)
   {       
    String Id = "0";
    ReadQueryString(ref Id);
    String strXML = BindDetails(Id);

    Response.ContentType = "text/xml";
    Response.Write(strXML);
    Response.End();     
   }
  }

  private void ReadQueryString(ref String Id)
  {
   if(Request.QueryString["id"]!=null)
   {
    Id = Request.QueryString["id"].ToString().Trim();
   }
   else
   {
    Id= "0";
   }
  }

  private String BindDetails(String Id)
  {
   String strSQL = "select dtlid,dtlnbr,Itemnbr,TypeID,Qty,FOCQty,Price,Amt, convert(char(10),DeliDate,120) as DeliTime,DeliAddress,PageBox,Notes from sa_orderdtl where dtlid='"+Id+"'";
   DataTable dt = new Logon().GetDataTable(strSQL);    
   DataSet ds =new DataSet();
   ds.Tables.Add(dt);  
   return ds.GetXml();   
  }

评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值