public string FindOrderCreate() { DataSet ds = _bal.FindOrderCreate(); 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>{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()); }