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