//private void FillDevice()
//{
// string sms_sqlstr2 = "SELECT * FROM hd_pile_info_t";
// MySqlDataAdapter sms_da = new MySqlDataAdapter(sms_sqlstr2, sms_conn);
// DataSet sms_ds = new DataSet();
// sms_da.Fill(sms_ds, "T");
// advTree1.Nodes.Clear();
// foreach (DataRow item in sms_ds.Tables[0].Rows)
// {
// DevComponents.AdvTree.Node n = new DevComponents.AdvTree.Node(item["user_id"].ToString());
// n.Tag = item;
// //n.Value = item["dev_id"].ToString();
// if (item["pile_type"].ToString() == "2")
// n.ImageIndex = 1;
// else if (item["pile_type"].ToString() == "3")
// n.ImageIndex = 2;
// else
// n.ImageIndex = 0;
// n.NodeClick += n_NodeClick;
// advTree1.Nodes.Add(n);
// }
//}
public void SetSelectdDevice(DataRow row)
{
labelSearchStat.Text = "";
timerFlash.Stop();
TextBoxDevid.Value = "";
TextBoxUserid.Text = "";
TextBoxsFactoryid.Text = "";
TextBoxsVersion.Text = "";
comboBoxType.SelectedIndex = 1;
TextBoxsSIM.Text = "";
TextBoxsAddr.Text = "";
TextBoxsPosition.Text = "";
TextBoxsOutvol.Text = "";
TextBoxsOutcur.Text = "";
comboBoxRelaystat.SelectedIndex = 0;
comboBoxConnstat.SelectedIndex = 0;
TextBoxsTotaldegree.Text = "";
comboBoxBattery.SelectedIndex = 0;
comboBoxWorkstat.SelectedIndex = 0;
DrawChart("");
if (row != null)
{
TextBoxDevid.Value = row["dev_id"].ToString();
TextBoxUserid.Text = row["user_id"].ToString();
TextBoxsFactoryid.Text = row["vender_id"].ToString();
TextBoxsVersion.Text = row["software_ver"].ToString();
comboBoxType.SelectedIndex = int.Parse(row["pile_type"].ToString()) - 1;
TextBoxsSIM.Text = row["sim_id"].ToString();
TextBoxsAddr.Text = row["address"].ToString();
TextBoxsPosition.Text = row["position"].ToString();
string sms_sqlstr2 = "SELECT * FROM pile_state_t where dev_id='" + TextBoxDevid.Value + "' order by date_time desc limit 1";
MySqlDataAdapter sms_da2 = new MySqlDataAdapter(sms_sqlstr2, Framework.Environment.SMS_CONN);
DataSet sms_ds2 = new DataSet();
sms_da2.Fill(sms_ds2, "T");
if (sms_ds2.Tables[0].Rows.Count > 0)
{
DataRow r = sms_ds2.Tables[0].Rows[0];
TextBoxsOutvol.Text = r["output_vol"].ToString();
TextBoxsOutcur.Text = r["output_cur"].ToString();
comboBoxRelaystat.SelectedIndex = int.Parse(r["relay_state"].ToString());
comboBoxConnstat.SelectedIndex = int.Parse(r["conn_state"].ToString());
TextBoxsTotaldegree.Text = r["total_degree"].ToString();
comboBoxBattery.SelectedIndex = int.Parse(r["battery"].ToString());
//comboBoxWorkstat.SelectedIndex = int.Parse(r["work_state"].ToString());
}
BOCOM.DataModel.CDZDevStatusInfo info = Framework.Container.Instance.DevStateService.GetDevByID(TextBoxDevid.Value);
if (info != null)
{
comboBoxWorkstat.SelectedIndex = info.WorkStat;
}
}
}
void DevStateService_OnDevStateChanged(object sender, EventArgs e)
{
string devid = sender.ToString();
BOCOM.DataModel.CDZDevStatusInfo info = Framework.Container.Instance.DevStateService.GetDevByID(devid);
if (info != null)
{
UpdateDevServiceStatic(devid, info.WorkStat);
}
}
private void FillDevice(DevComponents.AdvTree.Node parentNode)
{
if (parentNode == null)
{
foreach (DataRow row in sms_ds.Tables[0].Rows)
{
int level = int.Parse(row["level"].ToString());
if (level == 1)
{
DevComponents.AdvTree.Node n = new DevComponents.AdvTree.Node(row["node_name"].ToString());
n.ImageIndex = 4;
n.Tag = row;
FillDevice(n);
advTree1.Nodes.Add(n);
}
}
}
else
{
DataRow r = parentNode.Tag as DataRow;
if (r != null)
{
int level = int.Parse(r["level"].ToString());
if (level == 4)
{
string sms_sqlstr2 = "SELECT * FROM hd_pile_info_t where node_id=" + r["node_id"].ToString();
MySqlDataAdapter sms_da_pile = new MySqlDataAdapter(sms_sqlstr2, Framework.Environment.SMS_CONN);
DataSet sms_ds_pile = new DataSet();
sms_da_pile.Fill(sms_ds_pile, "T");
foreach (DataRow item in sms_ds_pile.Tables[0].Rows)
{
DevComponents.AdvTree.Node n = new DevComponents.AdvTree.Node(item["dev_id"].ToString());
n.Tag = item;
string devid = item["dev_id"].ToString();
BOCOM.DataModel.CDZDevStatusInfo info = Framework.Container.Instance.DevStateService.GetDevByID(devid);
if (info != null)
{
switch (info.WorkStat)
{
case 0: //离线，
n.ImageIndex = 10;
break;
case 1: //故障
n.ImageIndex = 9;
break;
case 2: //待机，
n.ImageIndex = 8;
break;
case 3: //工作
n.ImageIndex = 7;
break;
default:
n.ImageIndex = 10;
break;
}
}
else
{
n.ImageIndex = 10;
}
n.NodeClick += n_NodeClick;
parentNode.Nodes.Add(n);
}
}
else
{
foreach (DataRow item in sms_ds.Tables[0].Rows)
{
if (r["node_id"].ToString() == item["parent_id"].ToString())
{
DevComponents.AdvTree.Node n = new DevComponents.AdvTree.Node(item["node_name"].ToString());
if (level == 3)
{
n.ImageIndex = 6;
}
else
{
n.ImageIndex = 5;
}
n.Tag = item;
FillDevice(n);
parentNode.Nodes.Add(n);
}
}
}
}
}
}
