12,162
社区成员
发帖
与我相关
我的任务
分享
DataTable dt = dsPurchaseInfo.Tables[0];
//int rows = dt.Rows.Count;
int rows = 1;
XElement rtnXml = new XElement("PURCHASE");
for (int i = 0; i < rows; i++)
{
DataRow row = dt.Rows[i];
XElement tmpjl = new XElement("PURCHASE_INFO",
new XElement("HOSPITAL_CODE", row["HOSPITAL_CODE"].ToString().Trim()),
new XElement("PRODUCT_ID", row["PRODUCT_ID"].ToString().Trim()),
new XElement("REQUEST_QTY", row["REQUEST_QTY"].ToString().Trim()),
new XElement("SALE_ORG_CODE", row["SALE_ORG_CODE"].ToString().Trim())
);
rtnXml.Add(tmpjl);
}
string PurchaseXml = rtnXml.ToString();
textBox2.Text = PurchaseXml;
StringBuilder sb = new StringBuilder();
StringWriter sw = new StringWriter(sb);
rtnXml.Save(sw, SaveOptions.DisableFormatting);
string xml = sb.ToString();