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