public ObservableCollection<wsSimpleItem> getListByLevel(int? level, int? _id) { List<Node> NodeList = new List<Node>(); ObservableCollection<wsSimpleItem> listB = new ObservableCollection<wsSimpleItem>(); switch (level) { case 1: foreach (Node node1 in chldlist) { NodeList.Add(node1); } break; case 2: foreach (Node node1 in chldlist) { if (node1.bi.ID == _id) { foreach (Node node2 in node1.chldlist) { NodeList.Add(node2); } break; } } break; case 3: foreach (Node node1 in chldlist) { foreach (Node node2 in node1.chldlist) { if (node2.bi.ID == _id) { foreach (Node node3 in node2.chldlist) { NodeList.Add(node3); } break; } } } break; //case 4: // foreach (Node node1 in chldlist) // { // if (node1.bi.ID == _id) // { // foreach (Node node2 in node1.chldlist) // { // if (node2.bi.ID == _id) // { // foreach (Node node3 in node2.chldlist) // { // if (node3.bi.ID == _id) // { // foreach (Node node4 in node3.chldlist) // { // NodeList.Add(node4); // } // } // } // } // } // } // } // break; } foreach (Node n in NodeList) { wsSimpleItem sitem = new wsSimpleItem(); sitem.ID = n.bi.ID; sitem.Description = n.bi.Description; listB.Add(sitem); } return listB; }
void w_selFilterTypeClosed(object sender, EventArgs e) { cwnd_treeTypes w = sender as cwnd_treeTypes; if (w.DialogResult == true) { globalFilterType = w.selectedItem; } else { globalFilterType.ID = null; globalFilterType.Description = "Все"; } btn_selFilterType.Content = "Класс = \"" + globalFilterType.Description + "\""; wc.ws_selectPassportsListAsync(globalFilterType.ID,globalFilterPlace.ID); }
public string selectPlaceParents(int? ID) // lp_sel_ParentsOfPlace { List<wsSimpleItem> l = new List<wsSimpleItem>(); string s = null; using (SqlConnection conn = new SqlConnection(Configuration.ConnectionString)) { SqlCommand cmd = new SqlCommand("lp_sel_ParentsOfPlace"); conn.Open(); cmd.Connection = conn; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ID", objectOrNull(ID)); SqlDataReader Reader = cmd.ExecuteReader(); if (Reader.HasRows) { while (Reader.Read()) { wsSimpleItem temp = new wsSimpleItem(); if (!Reader.IsDBNull(Reader.GetOrdinal("PlaceID"))) temp.ID = (int)Reader["PlaceID"]; if (!Reader.IsDBNull(Reader.GetOrdinal("PlaceName"))) temp.Description = (string)Reader["PlaceName"]; l.Add(temp); } } Reader.Close(); conn.Close(); } if (l.Count > 0) { foreach (wsSimpleItem item in l) { if (item != null) { s += item.Description; s += " -> "; } } s = s.Substring(0, s.LastIndexOf(" -> ")); } else s = "Размещение не задано"; return s; }
public List<wsSimpleItem> selectCalibrationTypes() { List<wsSimpleItem> l = new List<wsSimpleItem>(); using (SqlConnection conn = new SqlConnection(Configuration.ConnectionString)) { SqlCommand cmd = new SqlCommand("SELECT ID, TypeName FROM tbl_CalibrationType"); conn.Open(); cmd.Connection = conn; SqlDataReader Reader = cmd.ExecuteReader(); while (Reader.Read()) { wsSimpleItem item = new wsSimpleItem(); if (!Reader.IsDBNull(Reader.GetOrdinal("ID"))) item.ID = (int)Reader["ID"]; if (!Reader.IsDBNull(Reader.GetOrdinal("TypeName"))) item.Description = (string)Reader["TypeName"]; l.Add(item); } conn.Close(); } return l; }
public List<wsSimpleItem> selectModelParents(int? ID) // lp_sel_ParentsOfModel { List<wsSimpleItem> l = new List<wsSimpleItem>(); using (SqlConnection conn = new SqlConnection(Configuration.ConnectionString)) { SqlCommand cmd = new SqlCommand("lp_sel_ParentsOfModel"); conn.Open(); cmd.Connection = conn; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ID", objectOrNull(ID)); SqlDataReader Reader = cmd.ExecuteReader(); if (Reader.HasRows) { while (Reader.Read()) { wsSimpleItem temp = new wsSimpleItem(); if (!Reader.IsDBNull(Reader.GetOrdinal("ModelID"))) temp.ID = (int)Reader["ModelID"]; if (!Reader.IsDBNull(Reader.GetOrdinal("Mname"))) temp.Description = (string)Reader["Mname"]; l.Add(temp); } } Reader.Close(); conn.Close(); } return l; }