#region RptTSZS003 [WebMethod] public string RptTSZS003 (string xmlStr) {SqlCommand cmd = new SqlCommand ( "", Con); XmlDocument Doc = new XmlDocument (); XmlNode rNode, fNode, cNode = null; string tabID, memberID, re = ""; Try {doc.loadxml (xmlstr); Re = "LOADXML-OK / N";} catCH (Exception E) {RE = E.Message "/ n"; }con.open (); if (doc! = null) {rNode = Doc.DocumentElement; tabID = rNode.Attributes [ "tabID"] InnerText;. memberID = rNode.Attributes [ "Reporter"] InnerText;. try {fNode = rNode.ChildNodes [0]; // people CMD.COMMANDTEXT = "delete from people3 where tabid = '" Tabid "'"; cmd.executenonquery (); for (int i = 0; i "'"; Cmd.executenonQuery (); for (int i = 0; i cmd.ExecuteNonQuery ();} cmd.CommandText = "Insert into TSZS003 (tabID, workType, workObj, devType," "devClass, devStep, devKind, devName, devSize, devID, devComID," "devAddr, madeID, madeCom, madeComID, madeDate, useCom, useComAddr, " " useComMan, useComPhone, contractID, contractDate, workCom, permitID, permitTime, " " workComMan, workComID, workComMan2, workComMan2Phone, workComMan3, " " workComMan3Phone, workComAddr, buildCom, buildComAddr, buildDate1 , " " Builddate2, Buildcost1, Buildcost2) VALUES ('" Tabid "', '" fnode.childNodes [0] .INnertext "', '" fnode.childnodes [1] .INnertext "', '" Fnode.childNodes [2] .innertext "','" fnode.childNodes [3] .INnertext "','" fnode.childnodes [4] .INnertext "','" fnode.childNodes [5] .innertext "','" Fnode.childNodes [6] .innertext "','" fnode.childNodes [7] .INnertext "','" fnode.childnodes [8] .innerText "','" fnode. ChildNodes [9] .innertext "','" FNO De.childNodes [10] .innertext "','" fnode.childnotes [11] .innertext "','" fnode.childnodes [12] .INnertext "','" fnode.childNodes [13] .INnertext "','" Fnode.childnodes [14] .innertext "" " fnode.childnodes [15] .INNNERTEXT " , '" Fnode.childnodes [16] .innertext "', '" fnode.childNodes [17] .innertext "', '" fnode.childnodes [18] .INnertext "', '" fnode.childnodes [ 19] .innerText "','" fnode.childnodes [20] .INnertext "','" fnode.childnodes [21] .INnertext "','" fnode.childnodes [22] .innerText ", ' " Fnode.childNodes [23] .innertext " ',' " fnode.childNodes [24] .INnertext " ',' " fnode.childnodes [25] .innertext " ',' " fnode.childnodes [26] .Innertext "','" fnode.childnodes [27] .innertext "','" fnode.childnodes [28] .innerText "','" fnode.childnodes [29] .INNNERTEXT "','" Fnode.childNodes [30] .innertext "','" fnode.childNodes [31] .INNNERTEXT "','" fnode.childNodes [32] .INnertext "','" fnode.childnodes [33] .INNNERTEXT "','" Fnode.childNodes [34] .innertext "','" fnode.childnodes [35] .innertext "','" fnode.childnodes [36] .INNNERTEXT "" "; cmd.executenonQuery (); RE = "WriteDet AIL-OK / N ";} catch (Exception E) {RE = E.MESSAGE " / n ";} finally {} try {cmd.commandtext =" Update TSZS003 Set Memberid = '" memberid ", answer =
