#region GetVendorInfo /// <summary> /// add by bisdev02(jake) 20110427 /// </summary> /// <param name="formNo">ESO NO.</param> /// <param name="cUser">Applicant</param> /// <returns></returns> [WebMethod] public string GetVendorInfo(string formNo, string cUser) { try { System.Text.StringBuilder sbXML = new System.Text.StringBuilder(); LevelMainManager levelMainManager = apc.GetManager<LevelMainManager>(); DataTable dt = levelMainManager.GetVendorInfo(formNo, cUser);
if (dt != null && dt.Rows.Count == 0) { return "NoData"; }
sbXML.Append("<NewDataSet>"); for (int i = 0; i < dt.Rows.Count; i++) { sbXML.Append("<VendorInfo><ESONO>" + dt.Rows[i]["ESONO"].ToString() + "</ESONO>"); sbXML.Append("<VendorCode>" + dt.Rows[i]["VendorCode"].ToString() + "</VendorCode>"); sbXML.Append("<VendorName>" + dt.Rows[i]["VendorName"].ToString() + "</VendorName>"); sbXML.Append("<Applicant>" + dt.Rows[i]["Applicant"].ToString() + "</Applicant>"); sbXML.Append("</VendorInfo>"); }
sbXML.Append("</NewDataSet>");
return sbXML.ToString(); } catch (Exception ex) { this.getLog.Error("GetVendorInfo", ex); return "False"; } }
#endregion
if (xmlDoc.HasChildNodes) { foreach (XmlNode node in xmlDoc.ChildNodes) { xmlCount = GetNode(node, listNode); } } DataTable xmlDt = new DataTable(); for (int j = 0; j < xmlCount; j++) { xmlDt.Columns.Add(new DataColumn("HeaderText " + j.ToString())); }
for (int k = 0; k < listNode.Count / xmlCount; k++) { DataRow row = xmlDt.NewRow(); for (int m = 0; m < xmlCount; m++) { row[m] = listNode[k * xmlCount + m]; } xmlDt.Rows.Add(row); }
gdvTest.DataSource = xmlDt; gdvTest.DataBind();
private int GetNode(XmlNode node, System.Collections.Generic.List<string> list) { int count = 0; if (node.HasChildNodes) { foreach (XmlNode cNode in node.ChildNodes) { count = GetNode(cNode, list); } } else { list.Add(node.Value); count = node.ParentNode.ParentNode.ChildNodes.Count; }
return count; }