public void Update() { var url = "http://localhost:5984/_fti/local/events/_design/searchdocuments/by_fields?q=archive:false&limit=80"; var user = new User(); var lucene1 = new LuceneRequest <EventCouch>(); lucene1.rows = new List <Row <EventCouch> >(); Task <string> task = HTTP_GET(url); task.Wait(); var res = task.Result; var lucene = JsonConvert.DeserializeObject <LuceneRequest <EventWar> >(res); foreach (var l in lucene.rows) { EventCouch ev = new EventCouch(); ev = EventManager.ConvertEventWarToEventCouchParent(l.fields); lucene1.rows.Add(new Row <EventCouch>() { id = l.id, fields = ev }); } CouchRequest <EventCouch> list = new CouchRequest <EventCouch>(); list.total_rows = lucene.total_rows; foreach (var r in lucene1.rows) { list.rows.Add(r.fields); list.rows.Last()._id = r.id; } int i = 0; foreach (var r in list.rows) { r.warehouse_id = "91af1930ecfb96fcc19ae7689c000689"; //var id1 = ""; //// id1 = GetUUID(); //DateTime UpdatedTime = r.Data_vydachi ?? new DateTime(); //r.Data_vydachi = new DateTimeOffset(r.Data_vydachi).ToUnixTimeMilliseconds(); var json = JsonConvert.SerializeObject(r); var request = (HttpWebRequest)WebRequest.Create("http://localhost:5984/events/" + r._id); ServicePointManager.DefaultConnectionLimit = 1000; request.Credentials = new NetworkCredential("admin", "root"); request.Method = "PUT"; request.ContentType = "application/json"; request.KeepAlive = false; using (var streamWriter = new StreamWriter(request.GetRequestStream())) { var o = (Newtonsoft.Json.Linq.JObject)JsonConvert.DeserializeObject(json); var json1 = JsonConvert.SerializeObject(o); streamWriter.Write(json1); } } }
public CouchRequest <EventCouch> GetFilterSortDocuments(string filter = "", int pagesize = 10, string sort = "Номер_упаковки", string order = "", int page = 0, string warehouse = "") { CouchRequest <EventCouch> list = new CouchRequest <EventCouch>(); var limit = pagesize; var skip = (page - 1) * limit; if (filter == null) { filter = ""; } var q = ""; if (filter != "") { q = "( " + filter + " ) AND archive:false "; } else { q = "archive:false "; } var sort1 = "&sort="; if (sort == "Номер_упаковки" || sort == "Количество") { if (order != "desc") { sort1 += "\"/\"" + sort + "<int>"; } else { sort1 += "\"\\\"" + sort + "<int>"; } } else { if (order != "desc") { sort1 += "\"/\"" + sort; } else { sort1 += "\"\\\"" + sort; } } if (warehouse == null || warehouse == "") { warehouse = ""; } else if (warehouse == "") { q = "(" + q + ")"; } else { q = "(" + q + ")" + " AND " + "warehouse:" + warehouse; } var url = "http://localhost:5984/_fti/local/events/_design/searchdocuments/by_fields?q=" + q + sort1 + "&skip=" + skip + "&limit=" + limit; var user = new User(); var lucene1 = new LuceneRequest <EventCouch>(); lucene1.rows = new List <Row <EventCouch> >(); Task <string> task = HTTP_GET(url); task.Wait(); var res = task.Result; var lucene = JsonConvert.DeserializeObject <LuceneRequest <EventWar> >(res); foreach (var l in lucene.rows) { EventCouch ev = new EventCouch(); ev = EventManager.ConvertEventWarToEventCouchParent(l.fields); lucene1.rows.Add(new Row <EventCouch>() { id = l.id, fields = ev }); } list.total_rows = lucene.total_rows; // url = "http://localhost:5984/_fti/local/warehouses/_design/searchdocuments/by_fields?q=archive:false"; // task = HTTP_GET(url); // task.Wait(); // res = task.Result; //var lucene123 = JsonConvert.DeserializeObject<LuceneRequest<Warehouse.Model.Db.Warehouse>>(res); // foreach (var r in lucene123.rows) // { // r.fields.id = r.id; // list.wars.Add(r.fields); // } foreach (var r in lucene1.rows) { list.rows.Add(r.fields); } list.wars = GetWarehouses(); return(list); }