public object FindOrder(string orderNo, string partsdrawing, string startTime, string endTime)
{
IList <OrderDetail> objs = _bal.FindOrder(orderNo, partsdrawing, startTime, endTime);
StringBuilder sb = new StringBuilder();
sb.Append("<?xml version=\"1.0\" encoding=\"UTF-8\"?>");
sb.Append("<rows>");
if (objs != null && objs.Count > 0)
{
foreach (OrderDetail o in objs)
{
sb.Append(string.Format("<row id='{0}'>", o.OrderNo + "," + o.PartsdrawingCode));
sb.Append(string.Format("<cell>{0}</cell>", o.OrderNo));
sb.Append(string.Format("<cell>{0}</cell>", o.CustName));
sb.Append(string.Format("<cell>{0}</cell>", o.CONTRACT));
sb.Append(string.Format("<cell>{0}</cell>", o.ProductName));
sb.Append(string.Format("<cell>{0}</cell>", o.PartsdrawingCode));
sb.Append(string.Format("<cell>{0}</cell>", o.BatchNumber));
sb.Append(string.Format("<cell>{0}</cell>", o.OrderQuantity));
sb.Append(string.Format("<cell>{0}</cell>", o.OutQuantity));
sb.Append(string.Format("<cell>{0}</cell>", o.OutDate));
sb.Append(string.Format("<cell>{0}</cell>", o.UpdatedBy));
sb.Append(string.Format("<cell>{0}</cell>", o.CreatedDate));
//sb.Append(string.Format("<cell>View^javascript:MySite.Runner.showDetail({0})^_self</cell>", log.ID));
sb.Append("</row>");
}
}
sb.Append("</rows>");
return(sb.ToString());
}
