public clsSimuResultByOneGoods GetOneGoodsSimulationXML(string PathAndFileName) }
{
clsSimuResultByOneGoods OneGoods = new clsSimuResultByOneGoods();//自己定义的一个类
Hashtable AllLocationResult = new Hashtable();
System.Xml.XmlTextReader r = new XmlTextReader(PathAndFileName);
string LocationID = “”;
DataTable LocationTable = null;
while(r.Read())
{
if(r.NodeType == XmlNodeType.Element)
{
switch(r.LocalName)
{
case “Result”:
OneGoods.GoodsCode = r.GetAttribute(“GoodsCode”);
OneGoods.From = Convert.ToDateTime(r.GetAttribute(“FromDate”));
OneGoods.To = Convert.ToDateTime(r.GetAttribute(“ToDate”));
break;
case “Location”:
LocationID = r.GetAttribute(“ID”);
LocationTable = new DataTable();
LocationTable.Columns.Add(“Date”,typeof(DateTime));
LocationTable.Columns.Add(“SafetyStock”,typeof(decimal));
LocationTable.Columns.Add(“ForecastDemand”,typeof(decimal));
LocationTable.Columns.Add(“FinalOutput”,typeof(decimal));
LocationTable.Columns.Add(“FinalInput”,typeof(decimal));
LocationTable.Columns.Add(“SimuStock”,typeof(decimal));
LocationTable.Columns.Add(“SimuStockTime”,typeof(decimal));
LocationTable.Columns.Add(“ImportWorkDay”,typeof(bool));
LocationTable.Columns.Add(“ImportWorkDay”,typeof(bool));
break;
case “Record”:
if(LocationTable != null)
{
DataRow dr = LocationTable.NewRow();
dr[“Date”] = Convert.ToDateTime(r.GetAttribute(“Date”));
if(r.GetAttribute(“SafetyStock”) != null && r.GetAttribute(“SafetyStock”) != “”)
dr[“SafetyStock”] = Convert.ToDecimal(r.GetAttribute(“SafetyStock”));
if(r.GetAttribute(“ForecastDemand”) != null && r.GetAttribute(“ForecastDemand”) != “”)
dr[“ForecastDemand”] = Convert.ToDecimal(r.GetAttribute(“ForecastDemand”));
if(r.GetAttribute(“FinalInput”) != null && r.GetAttribute(“FinalInput”) != “”)
dr[“FinalInput”] = Convert.ToDecimal(r.GetAttribute(“FinalInput”));
if(r.GetAttribute(“FinalOutput”) != null && r.GetAttribute(“FinalOutput”) != “”)
dr[“FinalOutput”] = Convert.ToDecimal(r.GetAttribute(“FinalOutput”));
if(r.GetAttribute(“SimuStock”) != null && r.GetAttribute(“SimuStock”) != “”)
dr[“SimuStock”] = Convert.ToDecimal(r.GetAttribute(“SimuStock”));
if(r.GetAttribute(“SimuStockTime”) != null && r.GetAttribute(“SimuStockTime”) != “”)
dr[“SimuStockTime”] = Convert.ToDecimal(r.GetAttribute(“SimuStockTime”));
if(r.GetAttribute(“ImportWorkDay”) != null && r.GetAttribute(“ImportWorkDay”) != “”)
dr[“ImportWorkDay”] = Convert.ToBoolean(r.GetAttribute(“ImportWorkDay”));
if(r.GetAttribute(“ExportWorkDay”) != null && r.GetAttribute(“ExportWorkDay”) != “”)
dr[“ExportWorkDay”] = Convert.ToBoolean(r.GetAttribute(“ExportWorkDay”));
LocationTable.Rows.Add(dr);
break;
default:
break;
}
}
else if(r.NodeType == XmlNodeType.EndElement)
{
switch(r.LocalName)
{
case “Location”:
if(LocationTable != null)
{
LocationTable.AcceptChanges();
AllLocationResult.Add(LocationID,LocationTable);
LocationID = “”;
LocationTable = null;
}
break;
default:
break;
}
}
}
OneGoods.AllLocationResult = AllLocationResult;
return OneGoods;
}
从xml中读取数据到内存的实例_xml技巧
版权申明:本站文章部分自网络,如有侵权,请联系:west999com@outlook.com 特别注意:本站所有转载文章言论不代表本站观点! 本站所提供的图片等素材,版权归原作者所有,如需使用,请与原作者联系。未经允许不得转载:IDC资讯中心 » 从xml中读取数据到内存的实例_xml技巧
相关推荐
-      ASP通过XMLDom在服务器端操作XML文件
-      ASP操作xml–显示xml文件中的所有节点
-      WEB页面工具语言XML(五)
-      ajax+xml的asp查询代码
-      XML与HTML文件的区别
-      WEB页面工具语言XML(二)
-      用ASP生成XML数据文档(RSS订阅)
-      WEB页面工具语言XML(四)