public IList<TrainProject> Fill(string param) { if (String.IsNullOrEmpty(param)) { return GetAllTrainProject(); } else { List<CY.GFive.Core.Business.TrainProject> trainProjectlist = new List<CY.GFive.Core.Business.TrainProject>(); SqlServerUtility sql = new SqlServerUtility(); StringBuilder strBuilder = new StringBuilder(); strBuilder.Append(SqlGetAllTrainProject + param); SqlDataReader reader = sql.ExecuteSqlReader(strBuilder.ToString()); if (reader != null && !reader.IsClosed) { while (reader.Read()) { Core.Business.TrainProject trainProject = new Core.Business.TrainProject(); if (!reader.IsDBNull(0)) trainProject.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) trainProject.ProjectCode = reader.GetString(1); if (!reader.IsDBNull(2)) trainProject.ProjectName = reader.GetString(2); if (!reader.IsDBNull(3)) trainProject.PjctStartDate = reader.GetDateTime(3); if (!reader.IsDBNull(4)) trainProject.PjctConsistDate = reader.GetInt32(4); if (!reader.IsDBNull(5)) trainProject.PjctEndDate = reader.GetDateTime(5); if (!reader.IsDBNull(6)) trainProject.Contrator = reader.GetString(6); if (!reader.IsDBNull(7)) trainProject.Des = reader.GetString(7); if (!reader.IsDBNull(8)) trainProject.Phone = reader.GetString(8); if (!reader.IsDBNull(9)) trainProject.Email = reader.GetString(9); if (!reader.IsDBNull(10)) trainProject.ProjectCate = reader.GetString(10); if (!reader.IsDBNull(11)) trainProject.Fee = reader.GetDecimal(11); if (!reader.IsDBNull(12)) trainProject.FeeDes = reader.GetString(12); if (!reader.IsDBNull(13)) trainProject.TrainingState = reader.GetInt32(13); trainProject.MarkOld(); trainProjectlist.Add(trainProject); } reader.Close(); } return trainProjectlist; } }
public IList<Core.Business.TrainProject> GetAllTrainProject() { IList<Core.Business.TrainProject> trainProjectlist = new List<Core.Business.TrainProject>(); SqlServerUtility sql = new SqlServerUtility(); SqlDataReader reader = sql.ExecuteSqlReader(SqlGetAllTrainProject); if (reader != null) { while (reader.Read()) { Core.Business.TrainProject trainProject = new Core.Business.TrainProject(); if (!reader.IsDBNull(0)) trainProject.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) trainProject.ProjectCode = reader.GetString(1); if (!reader.IsDBNull(2)) trainProject.ProjectName = reader.GetString(2); if (!reader.IsDBNull(3)) trainProject.PjctStartDate = reader.GetDateTime(3); if (!reader.IsDBNull(4)) trainProject.PjctConsistDate = reader.GetInt32(4); if (!reader.IsDBNull(5)) trainProject.PjctEndDate = reader.GetDateTime(5); if (!reader.IsDBNull(6)) trainProject.Contrator = reader.GetString(6); if (!reader.IsDBNull(7)) trainProject.Des = reader.GetString(7); if (!reader.IsDBNull(8)) trainProject.Phone = reader.GetString(8); if (!reader.IsDBNull(9)) trainProject.Email = reader.GetString(9); if (!reader.IsDBNull(10)) trainProject.ProjectCate = reader.GetString(10); if (!reader.IsDBNull(11)) trainProject.Fee = reader.GetDecimal(11); if (!reader.IsDBNull(12)) trainProject.FeeDes = reader.GetString(12); if (!reader.IsDBNull(13)) trainProject.TrainingState = reader.GetInt32(13); trainProject.MarkOld(); trainProjectlist.Add(trainProject); } reader.Close(); } return trainProjectlist; }
public Core.Business.TrainProject SelectByCode(string code) { SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@ProjectCode", SqlDbType.NVarChar, code); SqlDataReader reader = sql.ExecuteSqlReader(SqlSelectTrainProjectByCode); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.TrainProject trainProject = new Core.Business.TrainProject(); if (!reader.IsDBNull(0)) trainProject.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) trainProject.ProjectCode = reader.GetString(1); if (!reader.IsDBNull(2)) trainProject.ProjectName = reader.GetString(2); if (!reader.IsDBNull(3)) trainProject.PjctStartDate = reader.GetDateTime(3); if (!reader.IsDBNull(4)) trainProject.PjctConsistDate = reader.GetInt32(4); if (!reader.IsDBNull(5)) trainProject.PjctEndDate = reader.GetDateTime(5); if (!reader.IsDBNull(6)) trainProject.Contrator = reader.GetString(6); if (!reader.IsDBNull(7)) trainProject.Des = reader.GetString(7); if (!reader.IsDBNull(8)) trainProject.Phone = reader.GetString(8); if (!reader.IsDBNull(9)) trainProject.Email = reader.GetString(9); if (!reader.IsDBNull(10)) trainProject.ProjectCate = reader.GetString(10); if (!reader.IsDBNull(11)) trainProject.Fee = reader.GetDecimal(11); if (!reader.IsDBNull(12)) trainProject.FeeDes = reader.GetString(12); if (!reader.IsDBNull(13)) trainProject.TrainingState = reader.GetInt32(13); trainProject.MarkOld(); reader.Close(); return trainProject; } else { if (reader != null && !reader.IsClosed) reader.Close(); return null; } }