private void mnu_AllTasks_Click(object sender, EventArgs e) { DataTable dt = new DataTable(); dt = DBTasks.DBTasksAll(); lv_TaskMgr.Items.Clear(); foreach (DataRow row in dt.Rows) { DevListViewItem node = new DevListViewItem(); node.Text = row["Name"].ToString(); node.Tag = row["ID"].ToString(); node.uAddress = Convert.ToInt16(row["Address"]); node.uLine = Convert.ToInt32(row["Line"]); node.SubItems.Add(row["Time"].ToString()); node.SubItems.Add(row["TaskType"].ToString()); node.SubItems.Add(row["Action"].ToString()); node.Checked = true; lv_TaskMgr.Items.Add(node); } }
/// <summary> /// 装载输入设备列表 /// </summary> private void LoadInputDevices() { tm_AllowAction.Enabled = true; if (lv_Category.SelectedItems.Count > 0) { DataTable dt = new DataTable(); if (lv_Category.SelectedItems[0].Tag.ToString() == "999999") { dt = DBDevices.DBInputDevAll(); } else { dt = DBDevices.DBQueryInputDevicesByType(lv_Category.SelectedItems[0].Tag.ToString()); } lv_DIItems.Items.Clear(); foreach (DataRow row in dt.Rows) { DevListViewItem node = new DevListViewItem(); node.Text = row["Name"].ToString(); node.Title = row["Name"].ToString(); node.Tag = row["ID"].ToString(); node.uAddress = Convert.ToInt16(row["Address"]); node.uLine = Convert.ToInt32(row["Line"]); DataTable adt = new DataTable(); adt = DBiCoreVal.DBQueryValByItem(row["ID"].ToString()); foreach (DataRow dr in adt.Rows) { iCore_Value icv = new iCore_Value(); icv.CMD = dr["Command"].ToString(); icv.Value = Convert.ToDecimal(dr["Command"]); node.ActionList.Add(icv); } try { node.DefAction = Convert.ToInt32(row["DefAction"]); } catch { node.DefAction = 0; } try { node.ImgGroup = Convert.ToInt32(row["ImgGroup"]); } catch { node.ImgGroup = 0; } try { node.DevIO = Convert.ToInt32(row["IO"]); } catch { node.DevIO = 0; } lv_DIItems.Items.Add(node); } UnknownStatus(); } }
/// <summary> /// 装载分组任务 /// </summary> private void LoadGroupTasks() { if (TaskLock) { return; } DataTable dt = new DataTable(); if (lv_Category.SelectedItems.Count > 0) { if (lv_Category.SelectedItems[0].Tag.ToString() == "999999") { dt = DBTasks.DBTasksAll(); lv_TaskMgr.Items.Clear(); foreach (DataRow row in dt.Rows) { DevListViewItem node = new DevListViewItem(); node.Text = row["Name"].ToString(); node.Tag = row["ID"].ToString(); node.uAddress = Convert.ToInt16(row["Address"]); node.uLine = Convert.ToInt32(row["Line"]); node.SubItems.Add(row["Time"].ToString()); node.SubItems.Add(row["TaskType"].ToString()); node.SubItems.Add(row["Action"].ToString()); node.Checked = true; lv_TaskMgr.Items.Add(node); } } else { lv_TaskMgr.Items.Clear(); foreach (DevListViewItem mlvi in lv_Items.Items) { dt = DBTasks.DBQueryTasksByItem(mlvi.Tag.ToString()); foreach (DataRow row in dt.Rows) { DevListViewItem node = new DevListViewItem(); node.Text = row["Name"].ToString(); node.Tag = row["ID"].ToString(); node.uAddress = Convert.ToInt16(row["Address"]); node.uLine = Convert.ToInt32(row["Line"]); node.SubItems.Add(row["Time"].ToString()); node.SubItems.Add(row["TaskType"].ToString()); node.SubItems.Add(row["Action"].ToString()); node.Checked = true; lv_TaskMgr.Items.Add(node); } } } } }