public IList<Core.Business.DeviceInfo> GetAllDeviceInfo() { IList<Core.Business.DeviceInfo> deviceInfolist = new List<Core.Business.DeviceInfo>(); SqlServerUtility sql = new SqlServerUtility(); SqlDataReader reader = sql.ExecuteSqlReader(SqlGetAllDeviceInfo); if (reader != null) { while (reader.Read()) { Core.Business.DeviceInfo deviceInfo = new Core.Business.DeviceInfo(); if (!reader.IsDBNull(0)) deviceInfo.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) deviceInfo.DeviceName = reader.GetString(1); if (!reader.IsDBNull(2)) deviceInfo.DeviceCode = reader.GetString(2); if (!reader.IsDBNull(3)) deviceInfo.ProDate = reader.GetDateTime(3); if (!reader.IsDBNull(4)) deviceInfo.ProFac = reader.GetString(4); if (!reader.IsDBNull(5)) deviceInfo.FacAddress = reader.GetString(5); if (!reader.IsDBNull(6)) deviceInfo.FacPhone = reader.GetString(6); if (!reader.IsDBNull(7)) deviceInfo.Zip_Code = reader.GetString(7); if (!reader.IsDBNull(8)) deviceInfo.Contactor = reader.GetString(8); if (!reader.IsDBNull(9)) deviceInfo.BuyDate = reader.GetDateTime(9); if (!reader.IsDBNull(10)) deviceInfo.CheckDate = reader.GetDateTime(10); if (!reader.IsDBNull(11)) deviceInfo.StartDate = reader.GetDateTime(11); if (!reader.IsDBNull(12)) deviceInfo.DeviceLvl = reader.GetInt32(12); if (!reader.IsDBNull(13)) deviceInfo.DevDes = reader.GetString(13); if (!reader.IsDBNull(14)) deviceInfo.AidDevDes = reader.GetString(14); if (!reader.IsDBNull(15)) deviceInfo.DevNum = reader.GetInt32(15); if (!reader.IsDBNull(16)) deviceInfo.ClassRoomCode = reader.GetString(16); if (!reader.IsDBNull(17)) deviceInfo.DepartCode = reader.GetString(17); deviceInfo.MarkOld(); deviceInfolist.Add(deviceInfo); } reader.Close(); } return deviceInfolist; }
public Core.Business.DeviceInfo Select(int id) { SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@Id", SqlDbType.Int, id); SqlDataReader reader = sql.ExecuteSqlReader(SqlSelectDeviceInfo); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.DeviceInfo deviceInfo = new Core.Business.DeviceInfo(); if (!reader.IsDBNull(0)) deviceInfo.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) deviceInfo.DeviceName = reader.GetString(1); if (!reader.IsDBNull(2)) deviceInfo.DeviceCode = reader.GetString(2); if (!reader.IsDBNull(3)) deviceInfo.ProDate = reader.GetDateTime(3); if (!reader.IsDBNull(4)) deviceInfo.ProFac = reader.GetString(4); if (!reader.IsDBNull(5)) deviceInfo.FacAddress = reader.GetString(5); if (!reader.IsDBNull(6)) deviceInfo.FacPhone = reader.GetString(6); if (!reader.IsDBNull(7)) deviceInfo.Zip_Code = reader.GetString(7); if (!reader.IsDBNull(8)) deviceInfo.Contactor = reader.GetString(8); if (!reader.IsDBNull(9)) deviceInfo.BuyDate = reader.GetDateTime(9); if (!reader.IsDBNull(10)) deviceInfo.CheckDate = reader.GetDateTime(10); if (!reader.IsDBNull(11)) deviceInfo.StartDate = reader.GetDateTime(11); if (!reader.IsDBNull(12)) deviceInfo.DeviceLvl = reader.GetInt32(12); if (!reader.IsDBNull(13)) deviceInfo.DevDes = reader.GetString(13); if (!reader.IsDBNull(14)) deviceInfo.AidDevDes = reader.GetString(14); if (!reader.IsDBNull(15)) deviceInfo.DevNum = reader.GetInt32(15); if (!reader.IsDBNull(16)) deviceInfo.ClassRoomCode = reader.GetString(16); if (!reader.IsDBNull(17)) deviceInfo.DepartCode = reader.GetString(17); reader.Close(); return deviceInfo; } else { if (reader != null && !reader.IsClosed) reader.Close(); return null; } }
public IList<CY.GFive.Core.Business.DeviceInfo> GetSerachDevicesByName(string name) { SqlServerUtility utility = new SqlServerUtility(); IList<DeviceInfo> devices = new List<DeviceInfo>(); if (name != null) utility.AddParameter("DeviceName", SqlDbType.VarChar, name); SqlDataReader reader = utility.ExecuteSqlReader(SQL_GET_DEVICE_BY_DEVICE_NAMESer); if (reader != null && !reader.IsClosed) { while (reader.Read()) { Core.Business.DeviceInfo deviceInfo = new Core.Business.DeviceInfo(); if (!reader.IsDBNull(0)) deviceInfo.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) deviceInfo.DeviceName = reader.GetString(1); if (!reader.IsDBNull(2)) deviceInfo.DeviceCode = reader.GetString(2); if (!reader.IsDBNull(3)) deviceInfo.ProDate = reader.GetDateTime(3); if (!reader.IsDBNull(4)) deviceInfo.ProFac = reader.GetString(4); if (!reader.IsDBNull(5)) deviceInfo.FacAddress = reader.GetString(5); if (!reader.IsDBNull(6)) deviceInfo.FacPhone = reader.GetString(6); if (!reader.IsDBNull(7)) deviceInfo.Zip_Code = reader.GetString(7); if (!reader.IsDBNull(8)) deviceInfo.Contactor = reader.GetString(8); if (!reader.IsDBNull(9)) deviceInfo.BuyDate = reader.GetDateTime(9); if (!reader.IsDBNull(10)) deviceInfo.CheckDate = reader.GetDateTime(10); if (!reader.IsDBNull(11)) deviceInfo.StartDate = reader.GetDateTime(11); if (!reader.IsDBNull(12)) deviceInfo.DeviceLvl = reader.GetInt32(12); if (!reader.IsDBNull(13)) deviceInfo.DevDes = reader.GetString(13); if (!reader.IsDBNull(14)) deviceInfo.AidDevDes = reader.GetString(14); if (!reader.IsDBNull(15)) deviceInfo.DevNum = reader.GetInt32(15); if (!reader.IsDBNull(16)) deviceInfo.ClassRoomCode = reader.GetString(16); if (!reader.IsDBNull(17)) deviceInfo.DepartCode = reader.GetString(17); deviceInfo.MarkOld(); devices.Add(deviceInfo); } reader.Close(); } return devices; }