//重新画线
private void redo_Paint(string ls_device_pos)
{
try
{
if (dbIsConned)
{
//画线
if (ds_redo_Paint.Tables[0].Rows.Count > 0)
{
////判断设备的位置
//switch (ls_device_pos)
//{
// case "0": //主界面
// g = g0;
// break;
// case "1": //tabPage1
// g = g1;
// break;
// default:
// g = g0;
// break;
//}
foreach (DataRow row in ds_redo_Paint.Tables[0].Rows)
{
DeviceSubLine device = new DeviceSubLine(this, row, g1);
Application.DoEvents();
}
}
}
}
catch (Exception ex)
{
AddErrToListView("重新画线异常：" + ex.Message.ToString());
LogHelper.LogSimlpleString(DateTime.Now.ToString("G") + "重新画线异常：" + ex.Message.ToString());
}
}
private bool InitialDev()
{
DataSet ds_dev = new DataSet();
#region 无动力输送线
//ds_dev = MySqlHelper.ExecuteDataset(dbConn, "select * from td_device_dic t where t.command_type='XC' order by device_id");
ds_dev = MySqlHelper.ExecuteDataset(dbConn, "select * from td_device_dic t where t.command_type='WDL' order by device_id");
wdl_dev = new WDL_Dev(this, ds_dev.Tables[0]);
for (int i = 0; i < ds_dev.Tables[0].Rows.Count; i++)
{
this.tabPage1.Controls.Add(wdl_dev.pic[i]);
wdl_dev.pic[i].BringToFront();
}
#endregion
#region 初始化急停按钮盒
ds_dev = MySqlHelper.ExecuteDataset(dbConn, "select * from td_device_dic t where t.command_type='ANH' order by device_id");
jt_dev = new JT_Dev(this, ds_dev.Tables[0]);
for (int i = 0; i < ds_dev.Tables[0].Rows.Count; i++)
{
this.tabPage1.Controls.Add(jt_dev.pic[i]);
jt_dev.pic[i].BringToFront();
}
#endregion
#region 初始化无命令设备：输送机、分流器、移栽机、电柜
ds_dev = MySqlHelper.ExecuteDataset(dbConn, "select * from td_device_dic t where t.command_type='' order by control_type,device_id");
ssj_dev = new SSJ_Dev(this, ds_dev.Tables[0]);
for (int i = 0; i < ds_dev.Tables[0].Rows.Count; i++)
{
this.tabPage1.Controls.Add(ssj_dev.pic[i]);
ssj_dev.pic[i].BringToFront();
}
#endregion
#region 初始化各个楼层的点动控制：各个楼层清错、手动自动、系统启动停止
ds_dev = MySqlHelper.ExecuteDataset(dbConn, "select * from td_device_dic t where t.command_type='KZAN' order by device_id");
kzan_dev = new KZAN_Dev(this, ds_dev.Tables[0]);
for (int i = 0; i < ds_dev.Tables[0].Rows.Count; i++)
{
this.tabPage1.Controls.Add(kzan_dev.pic[i]);
kzan_dev.pic[i].BringToFront();
}
#endregion
#region 初始化辅助设备
// 画线
ds_redo_Paint = MySqlHelper.ExecuteDataset(dbConn,
"select * from td_device_sub_line t where t.device_type='1' order by t.device_pos desc,t.device_id");
if (ds_redo_Paint.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in ds_redo_Paint.Tables[0].Rows)
{
////判断设备的位置
//switch (row["device_pos"].ToString())
//{
// case "0": //主界面
// g = g0;
// break;
// case "1": //tabPage1
// g = g1;
// break;
// default:
// g = g0;
// break;
//}
DeviceSubLine device = new DeviceSubLine(this, row, g1);
Application.DoEvents();
}
if_redo_Paint = true;
}
#endregion
#region 初始化设备字典
//1初始化设备控制字典
ds_dev = MySqlHelper.ExecuteDataset(dbConn, "select concat(Control_type,Control_id) 'key',Control_type,Control_id,Control_desc,t.condition " +
"from td_device_control_dic t order by Control_type,control_id");
DeviceBase.DeviceControl tmpControl;
foreach (DataRow row in ds_dev.Tables[0].Rows)
{
tmpControl.controlType = row["Control_type"].ToString();
tmpControl.controlId = row["Control_id"].ToString();
tmpControl.controlDesc = row["Control_desc"].ToString();
tmpControl.condition = row["condition"].ToString();
deviceControlDic.Add(row["key"].ToString(), tmpControl);
}
//2初始化设备状态字典
ds_dev = MySqlHelper.ExecuteDataset(dbConn,
"select concat(status_type,status_id),status_desc,status_kind,status_color from td_device_status_dic order by status_type,status_id");
DeviceBase.DeviceStatus tmpStatus;
foreach (DataRow row in ds_dev.Tables[0].Rows)
{
tmpStatus.statusDesc = row.ItemArray[1].ToString();
tmpStatus.statusKind = row.ItemArray[2].ToString();
tmpStatus.statusColor = row.ItemArray[3].ToString();
deviceStatusDic.Add(row.ItemArray[0].ToString(), tmpStatus);
}
////3初始化设备故障字典
//ds_dev = MySqlHelper.ExecuteDataset(dbConn, "select concat(failure_type,failure_id),failure_desc,failure_kind "
// + " from td_device_failure_dic order by failure_type,failure_id");
//DeviceBase.DeviceFailure tmpFailure;
//foreach (DataRow row in ds_dev.Tables[0].Rows)
//{
// tmpFailure.failureDesc = row.ItemArray[1].ToString();
// tmpFailure.failureKind = row.ItemArray[2].ToString();
// deviceFailureDic.Add(row.ItemArray[0].ToString(), tmpFailure);
//}
#endregion
ds_dev.Dispose();
return(true);
}
