public List <xmlDataSources> findALLStatus_Server() { try { List <xmlDataSources> ClaimReport_Server = new List <xmlDataSources>(); MongoServer server = MongoServer.Create(connectionString); MongoDatabase db1 = server.GetDatabase(DB_NAME); MongoCollection collection1 = db1.GetCollection("KM_BiotechnologyXML_XmlStaus"); MongoCollection <BsonDocument> employees = db1.GetCollection <BsonDocument>("KM_BiotechnologyXML_XmlStaus"); foreach (BsonDocument emp in employees.FindAll()) { xmlDataSources item = new xmlDataSources(); #region 数据 if (emp.Contains("_id")) { item.Id = (emp["_id"].ToString()); } if (emp.Contains("Rack_ID")) { item.Rack_ID = (emp["Rack_ID"].ToString()); } if (emp.Contains("Input_Date")) { item.Input_Date = (emp["Input_Date"].AsString); } #endregion ClaimReport_Server.Add(item); } return(ClaimReport_Server); } catch (Exception ex) { MessageBox.Show("信息读取异常, 请检查网络或IP是否正确配置" + ex); return(null); throw ex; } }
private void ReadNewMethod(XmlElement xmlRoot, string path, XmlDocument xmlDoc) { XmlNode xn = xmlDoc.SelectSingleNode("RackReport"); string OrderName = ((XmlElement)xn).GetAttribute("OrderName"); //获取Name属性值 { //string id00 = ((XmlElement)node00).GetAttribute("OrderName"); //获取Name属性值 XmlNodeList personNodes0 = xmlRoot.GetElementsByTagName("Rack"); //获取Person子节点集合 foreach (XmlNode node0 in personNodes0) { string id0 = ((XmlElement)node0).GetAttribute("ID"); //获取Name属性值 XmlNodeList personNodes = xmlRoot.GetElementsByTagName("Hole"); //获取Person子节点集合 foreach (XmlNode node in node0.ChildNodes) { string id = ((XmlElement)node).GetAttribute("ID"); //获取Name属性值 // string name = ((XmlElement)node).GetElementsByTagName("ID")[0].InnerText; foreach (XmlNode node1 in node.ChildNodes) { string id1 = ((XmlElement)node1).GetAttribute("ID"); foreach (XmlNode node2 in node1.ChildNodes) { string id2 = ((XmlElement)node2).GetAttribute("ID"); xmlDataSources tempnote = new xmlDataSources(); //定义返回值 tempnote.Rack_ID = id0; tempnote.Hole_ID = id1; tempnote.Tube_ID = id2; tempnote.Input_Date = DateTime.Now.ToString("yyyyMMdd"); tempnote.OrderName = OrderName; tempnote.FileName = filename; Results.Add(tempnote); } } } } } }
public List <xmlDataSources> findXML_Server(string kettext, string start_time, string end_time, string Rack_ID) { #region Read database info server try { List <xmlDataSources> ClaimReport_Server = new List <xmlDataSources>(); MongoServer server = MongoServer.Create(connectionString); MongoDatabase db1 = server.GetDatabase(DB_NAME); MongoCollection collection1 = db1.GetCollection("KM_BiotechnologyXML_XmlData"); MongoCollection <BsonDocument> employees = db1.GetCollection <BsonDocument>("KM_BiotechnologyXML_XmlData"); var query = new QueryDocument("Comments", kettext); // var dd = Query.And(Query.EQ("jigoudaima", jigoudaima), Query.EQ("fapiaoleixing", fapiaoleixing));//同时满足多个条件 if (kettext != "") { foreach (BsonDocument emp in employees.Find(query)) { xmlDataSources item = new xmlDataSources(); #region 数据 if (emp.Contains("_id")) { item.Id = (emp["_id"].ToString()); } if (emp.Contains("Rack_ID")) { item.Rack_ID = (emp["Rack_ID"].ToString()); } if (emp.Contains("Hole_ID")) { item.Hole_ID = (emp["Hole_ID"].ToString()); } if (emp.Contains("Tube_ID")) { item.Tube_ID = (emp["Tube_ID"].ToString()); } if (emp.Contains("FileName")) { item.FileName = (emp["FileName"].AsString); } if (emp.Contains("Comments")) { item.Comments = (emp["Comments"].AsString); } if (emp.Contains("OrderName")) { item.OrderName = (emp["OrderName"].AsString); } if (emp.Contains("Input_Date")) { item.Input_Date = (emp["Input_Date"].AsString); } #endregion // ClaimReport_Server.Add(item); } } if (Rack_ID != "") { query = new QueryDocument("Rack_ID", Rack_ID); foreach (BsonDocument emp in employees.Find(query)) { xmlDataSources item = new xmlDataSources(); #region 数据 if (emp.Contains("_id")) { item.Id = (emp["_id"].ToString()); } if (emp.Contains("Rack_ID")) { item.Rack_ID = (emp["Rack_ID"].ToString()); } if (emp.Contains("Hole_ID")) { item.Hole_ID = (emp["Hole_ID"].ToString()); } if (emp.Contains("Tube_ID")) { item.Tube_ID = (emp["Tube_ID"].ToString()); } if (emp.Contains("FileName")) { item.FileName = (emp["FileName"].AsString); } if (emp.Contains("Comments")) { item.Comments = (emp["Comments"].AsString); } if (emp.Contains("OrderName")) { item.OrderName = (emp["OrderName"].AsString); } if (emp.Contains("Input_Date")) { item.Input_Date = (emp["Input_Date"].AsString); } #endregion // ClaimReport_Server.Add(item); } } var query1 = Query.And(Query.GTE("Input_Date", start_time.Replace("/", "")), Query.LTE("Input_Date", end_time.Replace("/", ""))); if (kettext != "" && Rack_ID == "") { query1 = Query.And(Query.GTE("Input_Date", start_time.Replace("/", "")), Query.LTE("Input_Date", end_time.Replace("/", "")), Query.Matches("Comments", kettext)); } if (Rack_ID != "" && kettext == "") { query1 = Query.And(Query.GTE("Input_Date", start_time.Replace("/", "")), Query.LTE("Input_Date", end_time.Replace("/", "")), Query.EQ("Rack_ID", Rack_ID)); } if (Rack_ID != "" && kettext != "") { query1 = Query.And(Query.GTE("Input_Date", start_time.Replace("/", "")), Query.LTE("Input_Date", end_time.Replace("/", "")), Query.EQ("Rack_ID", Rack_ID), Query.EQ("Comments", kettext)); } foreach (BsonDocument emp in employees.Find(query1)) { xmlDataSources item = new xmlDataSources(); #region 数据 if (emp.Contains("_id")) { item.Id = (emp["_id"].ToString()); } if (emp.Contains("Rack_ID")) { item.Rack_ID = (emp["Rack_ID"].ToString()); } if (emp.Contains("Hole_ID")) { item.Hole_ID = (emp["Hole_ID"].ToString()); } if (emp.Contains("Tube_ID")) { item.Tube_ID = (emp["Tube_ID"].ToString()); } if (emp.Contains("FileName")) { item.FileName = (emp["FileName"].AsString); } if (emp.Contains("Comments")) { item.Comments = (emp["Comments"].AsString); } if (emp.Contains("OrderName")) { item.OrderName = (emp["OrderName"].AsString); } if (emp.Contains("Input_Date")) { item.Input_Date = (emp["Input_Date"].AsString); } #endregion ClaimReport_Server.Add(item); } return(ClaimReport_Server); } catch (Exception ex) { MessageBox.Show("" + ex); return(null); throw ex; } #endregion }