public List<DataObject.LinkedRuleUnitDevice> List(int Id_Rule)
{
List<DataObject.LinkedRuleUnitDevice> list = null;
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
connection.Open();
string query = "Exec [BusinessRule].[ListRuleUnitAndDevice] {0}";
using (SqlCommand command = new SqlCommand(string.Format(query, Id_Rule), connection))
{
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
DataObject.LinkedRuleUnitDevice dataObject = new DataObject.LinkedRuleUnitDevice();
dataObject.UnitId = int.Parse(reader.GetValue(1).ToString());
dataObject.UnitAddress = reader.GetValue(2).ToString();
dataObject.DeviceId = int.Parse(reader.GetValue(4).ToString());
list.Add(dataObject);
}
}
}
}
return list;
}
public List <DataObject.LinkedRuleUnitDevice> List(int Id_Rule)
{
List <DataObject.LinkedRuleUnitDevice> list = null;
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
connection.Open();
string query = "Exec [BusinessRule].[ListRuleUnitAndDevice] {0}";
using (SqlCommand command = new SqlCommand(string.Format(query, Id_Rule), connection))
{
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
DataObject.LinkedRuleUnitDevice dataObject = new DataObject.LinkedRuleUnitDevice();
dataObject.UnitId = int.Parse(reader.GetValue(1).ToString());
dataObject.UnitAddress = reader.GetValue(2).ToString();
dataObject.DeviceId = int.Parse(reader.GetValue(4).ToString());
list.Add(dataObject);
}
}
}
}
return(list);
}