//public List<string> GetUomCodes() //{ // ArrayList filter = new ArrayList(1); // filter.Add(new ArrayList(3) { "code", "!=", false }); // ArrayList ids = oObject.Search("product.uom", filter); // ArrayList records = oObject.Read("product.uom", ids, new ArrayList(1) { "code" }); // List<string> uoms = new List<string>(); // foreach (Hashtable record in records) // { // if (!uoms.Contains((string)record["code"])) // uoms.Add((string)record["code"]); // } // return uoms; //} public List <string> GetRouteTemplates() { ArrayList filter = new ArrayList(1); filter.Add(new ArrayList(3) { "name", "like", "_template" }); ArrayList ids = oObject.Search("mrp.routing", filter); ArrayList records = oObject.Read("mrp.routing", ids, new ArrayList(1) { "name" }); List <string> routes = new List <string>(); foreach (Hashtable record in records) { if (!routes.Contains((string)record["name"])) { routes.Add((string)record["name"]); } } routes.Sort(); return(routes); }
private DataTable GetEcos() { ecoTable = GetEcoDataTable(); if (this.versionIds.Count == 0) { return(ecoTable); } ArrayList filter = new ArrayList(); filter.Add(new ArrayList(3) { "product_id", "in", this.versionIds }); ArrayList ids = oClient.Search("ecm.eco.rev.line", filter); ArrayList fields = new ArrayList() { "eco_id", "new_rev", "zone", "description", "target_date", "owner_id" }; ArrayList records = oClient.Read("ecm.eco.rev.line", ids, fields); foreach (Hashtable rec in records) { DataRow row = ecoTable.NewRow(); row["Eco"] = (string)((ArrayList)rec["eco_id"])[1]; row["Rev"] = (string)rec["new_rev"]; row["Zone"] = rec["zone"].GetType() == Type.GetType("System.Boolean") ? "" : (string)rec["zone"]; row["Description"] = rec["description"].GetType() == Type.GetType("System.bool") ? "" : (string)rec["description"]; row["Date"] = (string)rec["target_date"]; row["Owner"] = (string)((ArrayList)rec["owner_id"])[1]; ecoTable.Rows.Add(row); } ecoTable.DefaultView.Sort = "Eco ASC"; return(ecoTable); }