private void Table_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
try
{
if (string.IsNullOrEmpty(Config.TABLE_USER) || string.IsNullOrEmpty(Config.TABLE_NAME))
{
IDs = null;
Columns = null;
}
else
{
IDs = dC_Service.GetIDs(Config.TABLE_USER, Config.TABLE_NAME);
Columns = dC_Service.GetColumns(Config.TABLE_NAME);
}
OnPropertyChanged("IDs");
OnPropertyChanged("Columns");
}
catch (Exception)
{
}
}
private void btn_OK_Click(object sender, RoutedEventArgs e)
{
try
{
DC_SERVER server = this.cmb_Server.SelectedItem as DC_SERVER;
DataRowView cra = this.cmb_Crane.SelectedItem as DataRowView;
DC_DEVICE device = new DC_DEVICE()
{
CHANNEL = "S7",
CRA_ID = Convert.ToInt32(cra["ID"]),
ENABLE = 1,
NAME = cra["CRA_NAME"].ToString(),
NUM = cra["CRA_NUM"].ToString(),
S7CONNECTION = this.txt_Conn.Text.Trim(),
DESCRIPTION = cra["CRA_NAME"].ToString(),
SERVER_ID = server.ID,
Configs = new ObservableCollection <DC_DATA_CONFIG>(),
};
dC_Service.InsertDCDevice(device);
DataTable columnInfo = dC_Service.GetColumns("CRANE_REAL_INFO");
{
DataRow row = columnInfo.Rows.Cast <DataRow>().First(s => s["COLUMN_NAME"].ToString() == "COORD_X");
DC_DATA_CONFIG config = new DC_DATA_CONFIG()
{
NUM = "REAL_X",
NAME = "实时_X",
MEMORY_ADDRESS = "DB1,DINT4000",
DESCRIPTION = "实时_X",
SUBSCRIPTION = 1,
DEVICE_ID = device.ID,
ENABLE = 1,
IDENTITY_VALUE = dC_Service.GetCraRealInfoID(cra["ID"].ToString()),
TABLE_USER = "******",
TABLE_NAME = "CRANE_REAL_INFO",
FIELD_NAME = row["COLUMN_NAME"].ToString(),
FIELD_DATA_TYPE = row["DATA_TYPE"].ToString(),
FIELD_DATA_LENGTH = GetValue(row["DATA_LENGTH"]),
FIELD_DATA_PRECISION = GetValue(row["DATA_PRECISION"]),
FIELD_DATA_SCALE = GetValue(row["DATA_SCALE"]),
};
dC_Service.InsertDataConfig(config);
device.Configs.Add(config);
}
{
DataRow row = columnInfo.Rows.Cast <DataRow>().First(s => s["COLUMN_NAME"].ToString() == "COORD_Y");
DC_DATA_CONFIG config = new DC_DATA_CONFIG()
{
NUM = "REAL_Y",
NAME = "实时_Y",
MEMORY_ADDRESS = "DB1,DINT4004",
DESCRIPTION = "实时_Y",
SUBSCRIPTION = 1,
DEVICE_ID = device.ID,
ENABLE = 1,
IDENTITY_VALUE = dC_Service.GetCraRealInfoID(cra["ID"].ToString()),
TABLE_USER = "******",
TABLE_NAME = "CRANE_REAL_INFO",
FIELD_NAME = row["COLUMN_NAME"].ToString(),
FIELD_DATA_TYPE = row["DATA_TYPE"].ToString(),
FIELD_DATA_LENGTH = GetValue(row["DATA_LENGTH"]),
FIELD_DATA_PRECISION = GetValue(row["DATA_PRECISION"]),
FIELD_DATA_SCALE = GetValue(row["DATA_SCALE"]),
};
dC_Service.InsertDataConfig(config);
device.Configs.Add(config);
}
{
DataRow row = columnInfo.Rows.Cast <DataRow>().First(s => s["COLUMN_NAME"].ToString() == "LITTLE_HOOK_Y");
DC_DATA_CONFIG config = new DC_DATA_CONFIG()
{
NUM = "REAL_LITTLE_Y",
NAME = "实时_副Y",
MEMORY_ADDRESS = "DB1,DINT4008",
DESCRIPTION = "实时_副Y",
SUBSCRIPTION = 1,
DEVICE_ID = device.ID,
ENABLE = 1,
IDENTITY_VALUE = dC_Service.GetCraRealInfoID(cra["ID"].ToString()),
TABLE_USER = "******",
TABLE_NAME = "CRANE_REAL_INFO",
FIELD_NAME = row["COLUMN_NAME"].ToString(),
FIELD_DATA_TYPE = row["DATA_TYPE"].ToString(),
FIELD_DATA_LENGTH = GetValue(row["DATA_LENGTH"]),
FIELD_DATA_PRECISION = GetValue(row["DATA_PRECISION"]),
FIELD_DATA_SCALE = GetValue(row["DATA_SCALE"]),
};
dC_Service.InsertDataConfig(config);
device.Configs.Add(config);
}
{
DataRow row = columnInfo.Rows.Cast <DataRow>().First(s => s["COLUMN_NAME"].ToString() == "COORD_Z");
DC_DATA_CONFIG config = new DC_DATA_CONFIG()
{
NUM = "REAL_Z",
NAME = "实时_Z",
MEMORY_ADDRESS = "DB1,DINT4012",
DESCRIPTION = "实时_Z",
SUBSCRIPTION = 1,
DEVICE_ID = device.ID,
ENABLE = 1,
IDENTITY_VALUE = dC_Service.GetCraRealInfoID(cra["ID"].ToString()),
TABLE_USER = "******",
TABLE_NAME = "CRANE_REAL_INFO",
FIELD_NAME = row["COLUMN_NAME"].ToString(),
FIELD_DATA_TYPE = row["DATA_TYPE"].ToString(),
FIELD_DATA_LENGTH = GetValue(row["DATA_LENGTH"]),
FIELD_DATA_PRECISION = GetValue(row["DATA_PRECISION"]),
FIELD_DATA_SCALE = GetValue(row["DATA_SCALE"]),
};
dC_Service.InsertDataConfig(config);
device.Configs.Add(config);
}
{
DataRow row = columnInfo.Rows.Cast <DataRow>().First(s => s["COLUMN_NAME"].ToString() == "LITTLE_HOOK_Z");
DC_DATA_CONFIG config = new DC_DATA_CONFIG()
{
NUM = "REAL_LITTLE_Z",
NAME = "实时_副Z",
MEMORY_ADDRESS = "DB1,DINT4016",
DESCRIPTION = "实时_副Z",
SUBSCRIPTION = 1,
DEVICE_ID = device.ID,
ENABLE = 1,
IDENTITY_VALUE = dC_Service.GetCraRealInfoID(cra["ID"].ToString()),
TABLE_USER = "******",
TABLE_NAME = "CRANE_REAL_INFO",
FIELD_NAME = row["COLUMN_NAME"].ToString(),
FIELD_DATA_TYPE = row["DATA_TYPE"].ToString(),
FIELD_DATA_LENGTH = GetValue(row["DATA_LENGTH"]),
FIELD_DATA_PRECISION = GetValue(row["DATA_PRECISION"]),
FIELD_DATA_SCALE = GetValue(row["DATA_SCALE"]),
};
dC_Service.InsertDataConfig(config);
device.Configs.Add(config);
}
{
DataRow row = columnInfo.Rows.Cast <DataRow>().First(s => s["COLUMN_NAME"].ToString() == "WEIGHT");
DC_DATA_CONFIG config = new DC_DATA_CONFIG()
{
NUM = "REAL_WEIGHT",
NAME = "实时_主钩重量",
MEMORY_ADDRESS = "DB1,DINT4020",
DESCRIPTION = "实时_主钩重量",
SUBSCRIPTION = 1,
DEVICE_ID = device.ID,
ENABLE = 1,
IDENTITY_VALUE = dC_Service.GetCraRealInfoID(cra["ID"].ToString()),
TABLE_USER = "******",
TABLE_NAME = "CRANE_REAL_INFO",
FIELD_NAME = row["COLUMN_NAME"].ToString(),
FIELD_DATA_TYPE = row["DATA_TYPE"].ToString(),
FIELD_DATA_LENGTH = GetValue(row["DATA_LENGTH"]),
FIELD_DATA_PRECISION = GetValue(row["DATA_PRECISION"]),
FIELD_DATA_SCALE = GetValue(row["DATA_SCALE"]),
};
dC_Service.InsertDataConfig(config);
device.Configs.Add(config);
}
{
DataRow row = columnInfo.Rows.Cast <DataRow>().First(s => s["COLUMN_NAME"].ToString() == "LITTLE_HOOK_WEIGHT");
DC_DATA_CONFIG config = new DC_DATA_CONFIG()
{
NUM = "REAL_LITTLE_WEIGHT",
NAME = "实时_副钩重量",
MEMORY_ADDRESS = "DB1,DINT4024",
DESCRIPTION = "实时_副钩重量",
SUBSCRIPTION = 1,
DEVICE_ID = device.ID,
ENABLE = 1,
IDENTITY_VALUE = dC_Service.GetCraRealInfoID(cra["ID"].ToString()),
TABLE_USER = "******",
TABLE_NAME = "CRANE_REAL_INFO",
FIELD_NAME = row["COLUMN_NAME"].ToString(),
FIELD_DATA_TYPE = row["DATA_TYPE"].ToString(),
FIELD_DATA_LENGTH = GetValue(row["DATA_LENGTH"]),
FIELD_DATA_PRECISION = GetValue(row["DATA_PRECISION"]),
FIELD_DATA_SCALE = GetValue(row["DATA_SCALE"]),
};
dC_Service.InsertDataConfig(config);
device.Configs.Add(config);
}
{
DataRow row = columnInfo.Rows.Cast <DataRow>().First(s => s["COLUMN_NAME"].ToString() == "OBJ_COUNT");
DC_DATA_CONFIG config = new DC_DATA_CONFIG()
{
NUM = "REAL_OBJ_COUNT",
NAME = "实时_吊物数量",
MEMORY_ADDRESS = "DB1,B4029",
DESCRIPTION = "实时_吊物数量",
SUBSCRIPTION = 1,
DEVICE_ID = device.ID,
ENABLE = 1,
IDENTITY_VALUE = dC_Service.GetCraRealInfoID(cra["ID"].ToString()),
TABLE_USER = "******",
TABLE_NAME = "CRANE_REAL_INFO",
FIELD_NAME = row["COLUMN_NAME"].ToString(),
FIELD_DATA_TYPE = row["DATA_TYPE"].ToString(),
FIELD_DATA_LENGTH = GetValue(row["DATA_LENGTH"]),
FIELD_DATA_PRECISION = GetValue(row["DATA_PRECISION"]),
FIELD_DATA_SCALE = GetValue(row["DATA_SCALE"]),
};
dC_Service.InsertDataConfig(config);
device.Configs.Add(config);
}
{
DataRow row = columnInfo.Rows.Cast <DataRow>().First(s => s["COLUMN_NAME"].ToString() == "IS_ONLINE");
DC_DATA_CONFIG config = new DC_DATA_CONFIG()
{
NUM = "REAL_IS_ONLINE",
NAME = "实时_网络状态",
MEMORY_ADDRESS = "&statepathval()",
DESCRIPTION = "实时_网络状态",
SUBSCRIPTION = 1,
DEVICE_ID = device.ID,
ENABLE = 1,
IDENTITY_VALUE = dC_Service.GetCraRealInfoID(cra["ID"].ToString()),
TABLE_USER = "******",
TABLE_NAME = "CRANE_REAL_INFO",
FIELD_NAME = row["COLUMN_NAME"].ToString(),
FIELD_DATA_TYPE = row["DATA_TYPE"].ToString(),
FIELD_DATA_LENGTH = GetValue(row["DATA_LENGTH"]),
FIELD_DATA_PRECISION = GetValue(row["DATA_PRECISION"]),
FIELD_DATA_SCALE = GetValue(row["DATA_SCALE"]),
};
dC_Service.InsertDataConfig(config);
device.Configs.Add(config);
}
{
DC_DATA_CONFIG config = new DC_DATA_CONFIG()
{
NUM = "ACTION_X",
NAME = "动作_X",
MEMORY_ADDRESS = "DB1,DINT4054",
DESCRIPTION = "动作_X",
SUBSCRIPTION = 0,
DEVICE_ID = device.ID,
ENABLE = 1,
};
dC_Service.InsertDataConfig(config);
device.Configs.Add(config);
}
{
DC_DATA_CONFIG config = new DC_DATA_CONFIG()
{
NUM = "ACTION_Y",
NAME = "动作_Y",
MEMORY_ADDRESS = "DB1,DINT4058",
DESCRIPTION = "动作_Y",
SUBSCRIPTION = 0,
DEVICE_ID = device.ID,
ENABLE = 1,
};
dC_Service.InsertDataConfig(config);
device.Configs.Add(config);
}
{
DC_DATA_CONFIG config = new DC_DATA_CONFIG()
{
NUM = "ACTION_LITTLE_Y",
NAME = "动作_副Y",
MEMORY_ADDRESS = "DB1,DINT4062",
DESCRIPTION = "动作_副Y",
SUBSCRIPTION = 0,
DEVICE_ID = device.ID,
ENABLE = 1,
};
dC_Service.InsertDataConfig(config);
device.Configs.Add(config);
}
{
DC_DATA_CONFIG config = new DC_DATA_CONFIG()
{
NUM = "ACTION_Z",
NAME = "动作_Z",
MEMORY_ADDRESS = "DB1,DINT4066",
DESCRIPTION = "动作_Z",
SUBSCRIPTION = 0,
DEVICE_ID = device.ID,
ENABLE = 1,
};
dC_Service.InsertDataConfig(config);
device.Configs.Add(config);
}
{
DC_DATA_CONFIG config = new DC_DATA_CONFIG()
{
NUM = "ACTION_LITTLE_Z",
NAME = "动作_副Z",
MEMORY_ADDRESS = "DB1,DINT4070",
DESCRIPTION = "动作_副Z",
SUBSCRIPTION = 0,
DEVICE_ID = device.ID,
ENABLE = 1,
};
dC_Service.InsertDataConfig(config);
device.Configs.Add(config);
}
{
DC_DATA_CONFIG config = new DC_DATA_CONFIG()
{
NUM = "ACTION_WEIGHT",
NAME = "动作_主钩重量",
MEMORY_ADDRESS = "DB1,DINT4074",
DESCRIPTION = "动作_主钩重量",
SUBSCRIPTION = 0,
DEVICE_ID = device.ID,
ENABLE = 1,
};
dC_Service.InsertDataConfig(config);
device.Configs.Add(config);
}
{
DC_DATA_CONFIG config = new DC_DATA_CONFIG()
{
NUM = "ACTION_LITTLE_WEIGHT",
NAME = "动作_副钩重量",
MEMORY_ADDRESS = "DB1,DINT4078",
DESCRIPTION = "动作_副钩重量",
SUBSCRIPTION = 0,
DEVICE_ID = device.ID,
ENABLE = 1,
};
dC_Service.InsertDataConfig(config);
device.Configs.Add(config);
}
{
DC_DATA_CONFIG config = new DC_DATA_CONFIG()
{
NUM = "ACTION_SYMBOL",
NAME = "动作_动作类型",
MEMORY_ADDRESS = "DB1,B4082",
DESCRIPTION = "动作_动作类型",
SUBSCRIPTION = 0,
DEVICE_ID = device.ID,
ENABLE = 1,
};
dC_Service.InsertDataConfig(config);
device.Configs.Add(config);
}
{
DC_DATA_CONFIG config = new DC_DATA_CONFIG()
{
NUM = "ACTION_OBJ_COUNT",
NAME = "动作_吊物数量",
MEMORY_ADDRESS = "DB1,B4083",
DESCRIPTION = "动作_吊物数量",
SUBSCRIPTION = 0,
DEVICE_ID = device.ID,
ENABLE = 1,
};
dC_Service.InsertDataConfig(config);
device.Configs.Add(config);
}
{
DC_DATA_CONFIG config = new DC_DATA_CONFIG()
{
NUM = "ACTION_CACHE_NUM",
NAME = "动作_缓存序号",
MEMORY_ADDRESS = "DB1,DINT4050",
DESCRIPTION = "动作_缓存序号",
SUBSCRIPTION = 0,
DEVICE_ID = device.ID,
ENABLE = 1,
};
dC_Service.InsertDataConfig(config);
device.Configs.Add(config);
}
{
DC_DATA_CONFIG config = new DC_DATA_CONFIG()
{
NUM = "ACTION_READED_NUM",
NAME = "动作_已读序号",
MEMORY_ADDRESS = "DB1,DINT4035",
DESCRIPTION = "动作_已读序号",
SUBSCRIPTION = 0,
DEVICE_ID = device.ID,
ENABLE = 1,
};
dC_Service.InsertDataConfig(config);
device.Configs.Add(config);
}
{
DC_DATA_CONFIG config = new DC_DATA_CONFIG()
{
NUM = "ACTION_TIME",
NAME = "动作_动作时间",
MEMORY_ADDRESS = "DB1,B4084,6",
DESCRIPTION = "动作_动作时间",
SUBSCRIPTION = 0,
DEVICE_ID = device.ID,
ENABLE = 1,
};
dC_Service.InsertDataConfig(config);
device.Configs.Add(config);
}
{
DC_DATA_CONFIG config = new DC_DATA_CONFIG()
{
NUM = "CAL_TIME",
NAME = "校正_校正时间",
MEMORY_ADDRESS = "DB1,B4100,6",
DESCRIPTION = "校正_校正时间",
SUBSCRIPTION = 0,
DEVICE_ID = device.ID,
ENABLE = 1,
};
dC_Service.InsertDataConfig(config);
device.Configs.Add(config);
}
{
DC_DATA_CONFIG config = new DC_DATA_CONFIG()
{
NUM = "CAL_WRITE_FLAG",
NAME = "校正_写入标志",
MEMORY_ADDRESS = "DB1,B4106",
DESCRIPTION = "校正_写入标志",
SUBSCRIPTION = 0,
DEVICE_ID = device.ID,
ENABLE = 1,
};
dC_Service.InsertDataConfig(config);
device.Configs.Add(config);
}
MessageBox.Show("操作成功。");
AddCraSuccess?.Invoke(server, device);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
