public IList<Core.Business.StaffTrain> GetAllStaffTrain() { IList<Core.Business.StaffTrain> staffTrainlist = new List<Core.Business.StaffTrain>(); SqlServerUtility sql = new SqlServerUtility(); SqlDataReader reader = sql.ExecuteSqlReader(SqlGetAllStaffTrain); if (reader != null) { while (reader.Read()) { Core.Business.StaffTrain staffTrain = new Core.Business.StaffTrain(); if (!reader.IsDBNull(0)) staffTrain.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) staffTrain.Code = reader.GetString(1); if (!reader.IsDBNull(2)) staffTrain.TrainName = reader.GetString(2); if (!reader.IsDBNull(3)) staffTrain.TrainStartDate = reader.GetDateTime(3); if (!reader.IsDBNull(4)) staffTrain.ConsistTime = reader.GetDecimal(4); if (!reader.IsDBNull(5)) staffTrain.StopDate = reader.GetDateTime(5); if (!reader.IsDBNull(6)) staffTrain.TrainSate = reader.GetString(6); if (!reader.IsDBNull(7)) staffTrain.TrainCate = reader.GetString(7); if (!reader.IsDBNull(8)) staffTrain.TrainDegree = reader.GetString(8); staffTrain.MarkOld(); staffTrainlist.Add(staffTrain); } reader.Close(); } return staffTrainlist; }
public Core.Business.StaffTrain GetByCode(string stcode) { Core.Business.StaffTrain staffTrain = new Core.Business.StaffTrain(); SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@Code", SqlDbType.NVarChar, stcode); SqlDataReader reader = sql.ExecuteSqlReader(SqlGetByCode); if (reader != null && !reader.IsClosed && reader.Read()) { if (!reader.IsDBNull(0)) staffTrain.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) staffTrain.Code = reader.GetString(1); if (!reader.IsDBNull(2)) staffTrain.TrainName = reader.GetString(2); if (!reader.IsDBNull(3)) staffTrain.TrainStartDate = reader.GetDateTime(3); if (!reader.IsDBNull(4)) staffTrain.ConsistTime = reader.GetDecimal(4); if (!reader.IsDBNull(5)) staffTrain.StopDate = reader.GetDateTime(5); if (!reader.IsDBNull(6)) staffTrain.TrainSate = reader.GetString(6); if (!reader.IsDBNull(7)) staffTrain.TrainCate = reader.GetString(7); if (!reader.IsDBNull(8)) staffTrain.TrainDegree = reader.GetString(8); reader.Close(); staffTrain.MarkOld(); return staffTrain; } else { if (reader != null && !reader.IsClosed) reader.Close(); return null; } }
public IList<Core.Business.StaffTrain> SearchByName(string stname) { IList<Core.Business.StaffTrain> stlist = new List<Core.Business.StaffTrain>(); SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@TrainName", SqlDbType.NVarChar, stname); SqlDataReader reader = sql.ExecuteSqlReader(SqlSearchByName); if (reader != null && !reader.IsClosed) { while (reader.Read()) { Core.Business.StaffTrain staffTrain = new Core.Business.StaffTrain(); if (!reader.IsDBNull(0)) staffTrain.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) staffTrain.Code = reader.GetString(1); if (!reader.IsDBNull(2)) staffTrain.TrainName = reader.GetString(2); if (!reader.IsDBNull(3)) staffTrain.TrainStartDate = reader.GetDateTime(3); if (!reader.IsDBNull(4)) staffTrain.ConsistTime = reader.GetDecimal(4); if (!reader.IsDBNull(5)) staffTrain.StopDate = reader.GetDateTime(5); if (!reader.IsDBNull(6)) staffTrain.TrainSate = reader.GetString(6); if (!reader.IsDBNull(7)) staffTrain.TrainCate = reader.GetString(7); if (!reader.IsDBNull(8)) staffTrain.TrainDegree = reader.GetString(8); staffTrain.MarkOld(); stlist.Add(staffTrain); } reader.Close(); } return stlist; }