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