怎样将sql操作语句转变为如下格式的xml文件
<?xml version="1.0" encoding="UTF-8" standalone="no"?> 8457811102014-10-15GE114100001140077B0006PO141006580070 84578141071990000060001014101500000218457814108199000007000201410150000022
resultClass="com.baosight.wbpj.common.qi.domain.VPlanKb">
XmlDocument xdoc = new XmlDocument();
string strXml = "";
try
{
strXml = "<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"no\"?>\r\n";
strXml += "<ufinterface count=\"1\" proc=\"check\" receiver=\"ERP\" roottag=\"pustorein\" sender=\"MES\">\r\n";
strXml += "<storein pkid=\""+ss.Tables[0].Rows[0]["DOCU_NO"].ToString()+"\">\r\n";
if (ss.Tables[0].Rows.Count > 0)
{
//循环主批次单数据
for (int i = 0; i < ss.Tables[0].Rows.Count; i++)
{
strXml += "<header>\r\n";
strXml += "<id>"+ss.Tables[0].Rows[0]["ID"].ToString()+"</id>\r\n";//主id
strXml += "<receiveflag>1</receiveflag>\r\n";
strXml += "<vouchtype/>\r\n";
strXml += "<businesstype/>\r\n";
strXml += "<source/>\r\n";
strXml += "<businesscode/>\r\n";
strXml += "<warehousecode>110<warehousecode/>\r\n";//库位
strXml += "<date>"+ss.Tables[0].Rows[0]["DOCU_DATE"].ToString()+"<date/>\r\n";
strXml += "<code>"+ss.Tables[0].Rows[0]["DOCU_NO"].ToString()+"<code/>\r\n";
strXml += "<receivecode/>\r\n";
strXml += "<departmentcode>14<departmentcode/>\r\n";//部门
strXml += "<modsortseq/>\r\n";
strXml += "<personcode>0077<personcode/>\r\n";//录入人员
strXml += "<purchasetypecode/>\r\n";
strXml += "<saletypecode/>\r\n";
strXml += "<customercode>B0006<customercode/>\r\n";//客户编号
strXml += "<vendorcode/>\r\n";
strXml += "<ordercode>"+ ss.Tables[0].Rows[0]["ORDER_NUMBER"].ToString()+"<ordercode/>\r\n";//工单号
strXml += "<quantity/>\r\n";
strXml += "<arrivecode/>\r\n";
strXml += "<billcode/>\r\n";
strXml += "<consignmentcode/>\r\n";
strXml += "<arrivedate/>\r\n";
strXml += "<checkcode/>\r\n";
strXml += "<checkdate/>\r\n";
strXml += "<checkperson/>\r\n";
strXml += "<templatenumber/>\r\n";
strXml += "<serial/>\r\n";
strXml += "<handler/>\r\n";
strXml += "<memory/>\r\n";
strXml += "<maker>0070<maker/>\r\n";//确认人员
strXml += "<chandler/>\r\n";
strXml += "<define1/>\r\n";
strXml += "<define2/>\r\n";
strXml += "<define3/>\r\n";
strXml += "<define4/>\r\n";
strXml += "<define5/>\r\n";
strXml += "<define6/>\r\n";
strXml += "<define7/>\r\n";
strXml += "<define8/>\r\n";
strXml += "<define9/>\r\n";
strXml += "<define10/>\r\n";
strXml += "<define11/>\r\n";
strXml += "<define12/>\r\n";
strXml += "<define13/>\r\n";
strXml += "<define14/>\r\n";
strXml += "<define15/>\r\n";
strXml += "<define16/>\r\n";
strXml += "<auditdate/>\r\n";
strXml += "<taxrate/>\r\n";
strXml += "<exchname/>\r\n";
strXml += "<exchrate/>\r\n";
strXml += "<contact/>\r\n";
strXml += "<phone/>\r\n";
strXml += "<mobile/>\r\n";
strXml += "<address/>\r\n";
strXml += "<conphone/>\r\n";
strXml += "<conmobile/>\r\n";
strXml += "<deliverunit/>\r\n";
strXml += "<contactname/>\r\n";
strXml += "<officephone/>\r\n";
strXml += "<mobilephone/>\r\n";
strXml += "<psnophone/>\r\n";
strXml += "<psnmobilephone/>\r\n";
strXml += "<shipaddress/>\r\n";
strXml += "<addcode/>\r\n";
strXml += "</header>\r\n";
if (sss.Tables[0].Rows.Count > 0)
{
strXml += "<body>\r\n";
//循环子项
for (int j = 0; j < sss.Tables[0].Rows.Count; j++)
{
strXml += "<entry>\r\n";
strXml += "<id>"+sss.Tables[0].Rows[0]["SBAT_ID"].ToString()+"</id>\r\n";//主单id
strXml += "<autoid>"+sss.Tables[0].Rows[0]["ID"].ToString()+"</autoid>\r\n";//子单主id
strXml += "<barcode/>\r\n";
strXml += "<inventorycode>"+sss.Tables[0].Rows[0]["PART_NUMBER"].ToString()+"</inventorycode>\r\n";//物料编码
strXml += "<free1/>\r\n";
strXml += "<free2/>\r\n";
strXml += "<free3/>\r\n";
strXml += "<free4/>\r\n";
strXml += "<free5/>\r\n";
strXml += "<free6/>\r\n";
strXml += "<free7/>\r\n";
strXml += "<free8/>\r\n";
strXml += "<free9/>\r\n";
strXml += "<free10/>\r\n";
strXml += "<shouldquantity/>\r\n";
strXml += "<shouldnumber/>\r\n";
strXml += "<quantity>"+sss.Tables[0].Rows[0]["QTY"].ToString()+"<quantity/>\r\n";//数量
strXml += "<cmassunitname/>\r\n";
strXml += "<assitantunit/>\r\n";
strXml += "<assitantunitname/>\r\n";
strXml += "<irate/>\r\n";
strXml += "<number>0<number/>\r\n";//
strXml += "<price/>\r\n";
strXml += "<cost/>\r\n";
strXml += "<plancost/>\r\n";
strXml += "<planprice/>\r\n";
strXml += "<serial>"+sss.Tables[0].Rows[0]["BATCH_NUMBER"]+"<serial/>\r\n";
strXml += "<makedate/>\r\n";
strXml += "<validdate/>\r\n";
strXml += "<transitionid/>\r\n";
strXml += "<subbillcode/>\r\n";
strXml += "<subpurchaseid/>\r\n";
strXml += "<position/>\r\n";
strXml += "<itemclasscode/>\r\n";
strXml += "<itemclassname/>\r\n";
strXml += "<itemcode/>\r\n";
strXml += "<itemname/>\r\n";
strXml += "<define22/>\r\n";
strXml += "<define23/>\r\n";
strXml += "<define24/>\r\n";
strXml += "<define25/>\r\n";
strXml += "<define26/>\r\n";
strXml += "<define27/>\r\n";
strXml += "<define28/>\r\n";
strXml += "<define29/>\r\n";
strXml += "<define30/>\r\n";
strXml += "<define31/>\r\n";
strXml += "<define32/>\r\n";
strXml += "<define33/>\r\n";
strXml += "<define34/>\r\n";
strXml += "<define35/>\r\n";
strXml += "<define36/>\r\n";
strXml += "<define37/>\r\n";
strXml += "<subconsignmentid/>\r\n";
strXml += "<delegateconsignmentid/>\r\n";
strXml += "<subproducingid/>\r\n";
strXml += "<subcheckid/>\r\n";
strXml += "<cRejectCode/>\r\n";
strXml += "<iRejectIds/>\r\n";
strXml += "<cCheckPersonCode/>\r\n";
strXml += "<dCheckDate/>\r\n";
strXml += "<cCheckCode/>\r\n";
strXml += "<iMassDate/>\r\n";
strXml += "<ioritaxcost/>\r\n";
strXml += "<ioricost/>\r\n";
strXml += "<iorimoney/>\r\n";
strXml += "<ioritaxprice/>\r\n";
strXml += "<iorisum/>\r\n";
strXml += "<taxrate/>\r\n";
strXml += "<taxprice/>\r\n";
strXml += "<isum/>\r\n";
strXml += "<massunit/>\r\n";
strXml += "<irowno>"+ss.Tables[0].Rows[0]["ROW_ID"].ToString()+"<irowno/>\r\n";//行号
strXml += "</entry> \r\n";
}
strXml += "</body>\r\n";
}
}
}
strXml += "</storein>\r\n";
strXml += "</ufinterface>\r\n";
xdoc.LoadXml(strXml);//报错的是这里
xdoc.Save("XML/a.xml");
求指点啊 ，有人能帮帮我么 ，刚刚接触