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;
}
