public VaneInfo InitVaneInfo(SqlDataReader reader)
{
VaneInfo info = new VaneInfo();
info.ID = (int)reader["ID"];
info.VaneId1 = (int)reader["VaneId1"];
info.Param1 = (byte[])reader["Param1"];
info.VaneId2 = (int)reader["VaneId2"];
info.Param2 = (byte[])reader["Param2"];
info.VaneId3 = (int)reader["VaneId3"];
info.Param3 = (byte[])reader["Param3"];
return info;
}
public VaneInfo[] GetAllVane()
{
List<VaneInfo> infos = new List<VaneInfo>();
SqlDataReader reader = null;
try
{
db.GetReader(ref reader, "SP_Get_All_Vane");
while (reader.Read())
{
VaneInfo info = new VaneInfo();
info.ID = (int)reader["ID"];
info.VaneId1 = (int)reader["VaneId1"];
info.Param1 = (byte[])reader["Param1"];
info.VaneId2 = (int)reader["VaneId2"];
info.Param2 = (byte[])reader["Param2"];
info.VaneId3 = (int)reader["VaneId3"];
info.Param3 = (byte[])reader["Param3"];
}
}
catch (Exception e)
{
if (log.IsErrorEnabled)
log.Error("ByteArray", e);
}
finally
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
return infos.ToArray();
}
