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();
}