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
}
