public object FindUnderPublishOrder(string orderNo, string partsdrawing, string startTime, string endTime) { DataSet ds = _bal.FindUnderPublishOrder(orderNo, partsdrawing, startTime, endTime); StringBuilder sb = new StringBuilder(); sb.Append("<?xml version=\"1.0\" encoding=\"UTF-8\"?>"); sb.Append("<rows>"); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { sb.Append(string.Format("<row id='{0}'>", ds.Tables[0].Rows[i]["ORDER_NO"] + "," + ds.Tables[0].Rows[i]["PARTSDRAWING_CODE"])); // sb.Append(string.Format("<cell>< input name = \"Publish\" type = \"checkbox\" value =\"{0}\"></input></cell>", ds.Tables[0].Rows[i]["ORDER_NO"] + "," + ds.Tables[0].Rows[i]["PARTSDRAWING_CODE"])); sb.Append(string.Format("<cell></cell>")); sb.Append(string.Format("<cell>{0}</cell>", ds.Tables[0].Rows[i]["ORDER_NO"])); sb.Append(string.Format("<cell>{0}</cell>", ds.Tables[0].Rows[i]["PARTSDRAWING_CODE"])); sb.Append(string.Format("<cell>{0}</cell>", ds.Tables[0].Rows[i]["CUST_NAME"])); sb.Append(string.Format("<cell>{0}</cell>", ds.Tables[0].Rows[i]["CUST_CODE"])); sb.Append(string.Format("<cell>{0}</cell>", ds.Tables[0].Rows[i]["PLAN_QUANTITY"])); sb.Append(string.Format("<cell>{0}</cell>", ds.Tables[0].Rows[i]["QUALITY_CODE"])); sb.Append(string.Format("<cell>{0}</cell>", ds.Tables[0].Rows[i]["ASK_QUANTITY"])); sb.Append(string.Format("<cell>{0}</cell>", ds.Tables[0].Rows[i]["BATCH_NUMBER"])); sb.Append(string.Format("<cell>{0}</cell>", ds.Tables[0].Rows[i]["ASK_DATE"])); sb.Append(string.Format("<cell>{0}</cell>", ds.Tables[0].Rows[i]["UPDATED_BY"])); sb.Append(string.Format("<cell>{0}</cell>", ds.Tables[0].Rows[i]["CREATED_DATE"])); //sb.Append(string.Format("<cell>View^javascript:MySite.Runner.showDetail({0})^_self</cell>", log.ID)); sb.Append("</row>"); } } sb.Append("</rows>"); return(sb.ToString()); }