读XML文档

最新推荐文章于 2024-09-22 15:25:09 发布

JJNW

最新推荐文章于 2024-09-22 15:25:09 发布

阅读量1.2k

点赞数

分类专栏： C# 文章标签： xml exception null insert delete string

本文链接：https://blog.csdn.net/jjnw/article/details/332629

版权

C# 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

  #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<fNode.ChildNodes.Count;i++){
      cNode=fNode.ChildNodes[i];//rec
      if (cNode==null||cNode.ChildNodes[0]==null) continue;
      cmd.CommandText="Insert into People3 (tabID,taskObj,peopleName,peopleID,taskType,taskStep) "+
       "Values ('"+tabID+"','"+cNode.ChildNodes[0].InnerText+"','"+
       cNode.ChildNodes[1].InnerText+"','"+
       cNode.ChildNodes[2].InnerText+"','"+
       cNode.ChildNodes[3].InnerText+"','"+
       cNode.ChildNodes[4].InnerText+"')";
      cmd.ExecuteNonQuery();
     }
     re+="WritePeople-OK/n";
    }catch(Exception e){
     re+=e.Message+"/n";
    }finally{}
    try{
     fNode=rNode.ChildNodes[1];//packge
     cmd.CommandText="Delete From Packge3 Where tabID='"+tabID+"'";
     cmd.ExecuteNonQuery();
     for(int i=0;i<fNode.ChildNodes.Count;i++){
      cNode=fNode.ChildNodes[i];//rec
      if (cNode==null||cNode.ChildNodes[0]==null) continue;
      cmd.CommandText="Insert into Packge3 (tabID,pakObj,pakCom,pakID) "+
       "Values ('"+tabID+"','"+cNode.ChildNodes[0].InnerText+"','"+
       cNode.ChildNodes[1].InnerText+"','"+
       cNode.ChildNodes[2].InnerText+"')";
      cmd.ExecuteNonQuery();
     }
     re+="WritePackge-OK/n";
    }catch(Exception e){
     re+=e.Message+"/n";
    }finally{}
    try{
     fNode=rNode.ChildNodes[2];//file
     cmd.CommandText="Delete From File3 Where tabID='"+tabID+"'";
     cmd.ExecuteNonQuery();
     for(int i=0;i<fNode.ChildNodes.Count;i++){
      cNode=fNode.ChildNodes[i];//rec
      if (cNode==null||cNode.ChildNodes[0]==null) continue;
      cmd.CommandText="Insert into File3 (tabID,fileName,fileSize) "+
       "Values ('"+tabID+"','"+cNode.ChildNodes[0].InnerText+"','"+
       cNode.ChildNodes[1].InnerText+"')";
      cmd.ExecuteNonQuery();
     }
     re+="WriteFile-OK/n";
    }catch(Exception e){
     re+=e.Message+"/n";
    }finally{}
    try{
     fNode=rNode.ChildNodes[3];//detail
     if (fNode.ChildNodes[0]!=null){
      if (IsReported(tabID)){
       cmd.CommandText="Delete From TSZS003 Where tabID='"+tabID+"'";
       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+"','"+
        fNode.ChildNodes[10].InnerText+"','"+
        fNode.ChildNodes[11].InnerText+"','"+
        fNode.ChildNodes[12].InnerText+"','"+
        fNode.ChildNodes[13].InnerText+"','"+
        fNode.ChildNodes[14].InnerText+"','"+
        fNode.ChildNodes[15].InnerText+"','"+
        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].InnerText+"','"+
        fNode.ChildNodes[30].InnerText+"','"+
        fNode.ChildNodes[31].InnerText+"','"+
        fNode.ChildNodes[32].InnerText+"','"+
        fNode.ChildNodes[33].InnerText+"','"+
        fNode.ChildNodes[34].InnerText+"','"+
        fNode.ChildNodes[35].InnerText+"','"+
        fNode.ChildNodes[36].InnerText+"')";
      cmd.ExecuteNonQuery();
     }
     re+="WriteDetail-OK/n";
    }catch(Exception e){
     re+=e.Message+"/n";
    }finally{}
    try{
     cmd.CommandText="Update TSZS003 Set MemberID='"+memberID
      +"',Answer=0,ReportDate='"+DateTime.Now.ToString()
      +"' Where tabID='"+tabID+"'";
     cmd.ExecuteNonQuery();
     re+="UpDate-OK/n";
    }catch(Exception e){
     re+=e.Message+"/n";
    }finally{}
   }
   return re;
  }
  #endregion