/// <summary>
/// Read RequestXML To DB
/// </summary>
/// <param name="file"></param>
internal static void ReadRequestXMLToDB(string file, string fileTime, string lineNo)
{
try
{
XmlDocument xdoc = new XmlDocument();
xdoc.Load(file);
XmlNode nodes = xdoc.SelectSingleNode("root");
string typeNo = string.Empty;
string timeStamp = string.Empty;
//获取当前Request xml文件的TypeNo and timeStamp
if (nodes != null)
{
foreach (XmlNode node in nodes)
{
if (node.Name == "event")
{
XmlNodeList xmlFeeds = ReadXML_MV.GetChildNodes(node);
foreach (XmlNode nodeFeed in xmlFeeds)
{
typeNo = ReadXML_MV.ReadAttrValue(nodeFeed, "typeNo") ?? string.Empty;
if (!string.IsNullOrEmpty(typeNo))
{
break;
}
}
}
if (node.Name == "header")
{
foreach (System.Xml.XmlAttribute item in node.Attributes)
{
if (item.Name == "timeStamp")
{
timeStamp = item.Value;
break;
}
}
}
}
//插入数据库
InsertToRequestInfoAndCompare(typeNo, timeStamp, fileTime, lineNo);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
/// <summary>
/// Read RequestXML To DB
/// </summary>
/// <param name="file"></param>
internal static void ReadResponseXMLToDB(string file, string fileTime, string lineNo)
{
try
{
XmlDocument xdoc = new XmlDocument();
xdoc.Load(file);
XmlNode nodes = xdoc.SelectSingleNode("root/body/structArrays/array");
string matID = string.Empty;
string partNo = string.Empty;
string timeStamp = string.Empty;
//获取当前Request xml文件的TypeNo and timeStamp
if (nodes != null)
{
//21号线Response报文不同
if (lineNo == "21" || lineNo == "32" || lineNo == "26")
{
foreach (XmlNode node in nodes)
{
if (node.Name == "values")
{
XmlNodeList xmlFeeds = ReadXML_MV.GetChildNodes(node);
foreach (XmlNode nodeFeed in xmlFeeds)
{
partNo = ReadXML_MV.ReadAttrValue(nodeFeed, "partNo");
matID = ReadXML_MV.ReadAttrValue(nodeFeed, "matID");
if (!string.IsNullOrEmpty(partNo) && !string.IsNullOrEmpty(matID))
{
break;
}
}
}
}
}
else
{
foreach (XmlNode node in nodes)
{
if (node.Name == "values")
{
XmlNodeList xmlFeeds = ReadXML_MV.GetChildNodes(node);
foreach (XmlNode nodeFeed in xmlFeeds)
{
partNo = ReadXML_MV.ReadAttrValue(nodeFeed, "typeNo");
matID = ReadXML_MV.ReadAttrValue(nodeFeed, "matID");
if (!string.IsNullOrEmpty(partNo) && !string.IsNullOrEmpty(matID))
{
break;
}
}
}
}
}
XmlNode nodes_head = xdoc.SelectSingleNode("root");
//获取当前Request xml文件的TypeNo and timeStamp
foreach (XmlNode node in nodes_head)
{
if (node.Name == "header")
{
foreach (System.Xml.XmlAttribute item in node.Attributes)
{
if (item.Name == "timeStamp")
{
timeStamp = item.Value;
break;
}
}
}
}
//插入数据库
InsertToResponseInfoAndCompare(partNo, matID, timeStamp, fileTime, lineNo);
}
}
catch
{
throw;
}
}
