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);
}
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);
}
private void cbox_ModsList_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
wsSimpleItem si = cbox_ModsList.SelectedItem as wsSimpleItem;
if (si != null)
{
Ex_Pass.DevModification = si.Description;
}
}
private void box_ed_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if ((sender as ComboBox).SelectedItem != null)
{
wsSimpleItem item = (sender as ComboBox).SelectedItem as wsSimpleItem;
WSt.setDurationFormat((int)item.ID);
dg_control.ItemsSource = null;
dg_control.ItemsSource = WSt.list_StatesDurations;
}
}
//---- Handle childwindow
private void w_selectTypeClosed(object sender, EventArgs e)
{
if ((sender as cwnd_treeTypes).DialogResult == true)
{
wsSimpleItem sitem = (sender as cwnd_treeTypes).selectedItem;
string s = (sender as cwnd_treeTypes).storedString;
wc.ws_moveItemsAsync((int)sitem.ID, s);
}
}
public string selectDeviceParents(int?ID) // lp_sel_ParentsOfType
{
List <wsSimpleItem> l = new List <wsSimpleItem>();
string s = null;
using (SqlConnection conn = new SqlConnection(Configuration.ConnectionString))
{
SqlCommand cmd = new SqlCommand("lp_sel_ParentsOfType");
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("TypeID")))
{
temp.ID = (int)Reader["TypeID"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("TypeName")))
{
temp.Description = (string)Reader["TypeName"];
}
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);
}
private void cbox_SubModelsList_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
wsSimpleItem si = cbox_SubModelsList.SelectedItem as wsSimpleItem;
if (si != null)
{
int id = (int)si.ID;
globalListMods = globalTreeModels.getListByLevel(3, id);
cbox_ModsList.ItemsSource = globalListMods;
if (cbox_ModsList.Items.Count > 0)
{
cbox_ModsList.SelectedIndex = ScoDe.SetBoxIndex_wsSimpleItem(cbox_ModsList, Ex_Pass.DevModificationID);
}
Ex_Pass.DevSubModel = si.Description;
}
}
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 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);
}
