public IList<TrainProjectItem> Fill(string param) { if (String.IsNullOrEmpty(param)) { return GetAllTrainProjectItem(); } else { List<CY.GFive.Core.Business.TrainProjectItem> trainProjectItemlist = new List<CY.GFive.Core.Business.TrainProjectItem>(); SqlServerUtility sql = new SqlServerUtility(); StringBuilder strBuilder = new StringBuilder(); strBuilder.Append(SqlGetAllTrainProjectItem + param); SqlDataReader reader = sql.ExecuteSqlReader(strBuilder.ToString()); if (reader != null && !reader.IsClosed) { while (reader.Read()) { Core.Business.TrainProjectItem trainProjectItem = new Core.Business.TrainProjectItem(); if (!reader.IsDBNull(0)) trainProjectItem.Id = int.Parse(reader.GetInt32(0).ToString()); if (!reader.IsDBNull(1)) trainProjectItem.ProjectCode = reader.GetString(1); if (!reader.IsDBNull(2)) trainProjectItem.ItemStartDate = reader.GetDateTime(2); if (!reader.IsDBNull(3)) trainProjectItem.ItemConsistDate = reader.GetInt32(3); if (!reader.IsDBNull(4)) trainProjectItem.ItemEndDate = reader.GetDateTime(4); if (!reader.IsDBNull(5)) trainProjectItem.Content = reader.GetString(5); if (!reader.IsDBNull(6)) trainProjectItem.StartTime = reader.GetString(6); if (!reader.IsDBNull(7)) trainProjectItem.ConsistTime = reader.GetString(7); if (!reader.IsDBNull(8)) trainProjectItem.Position = reader.GetString(8); if (!reader.IsDBNull(9)) trainProjectItem.Des = reader.GetString(9); trainProjectItem.MarkOld(); trainProjectItemlist.Add(trainProjectItem); } reader.Close(); } return trainProjectItemlist; } }
public IList<Core.Business.TrainProjectItem> GetAllTrainProjectItem() { IList<Core.Business.TrainProjectItem> trainProjectItemlist = new List<Core.Business.TrainProjectItem>(); SqlServerUtility sql = new SqlServerUtility(); SqlDataReader reader = sql.ExecuteSqlReader(SqlGetAllTrainProjectItem); if(reader != null) { while(reader.Read()) { Core.Business.TrainProjectItem trainProjectItem = new Core.Business.TrainProjectItem(); if (!reader.IsDBNull(0)) trainProjectItem.Id = int.Parse(reader.GetInt32(0).ToString()); if (!reader.IsDBNull(1)) trainProjectItem.ProjectCode = reader.GetString(1); if (!reader.IsDBNull(2)) trainProjectItem.ItemStartDate = reader.GetDateTime(2); if (!reader.IsDBNull(3)) trainProjectItem.ItemConsistDate = reader.GetInt32(3); if (!reader.IsDBNull(4)) trainProjectItem.ItemEndDate = reader.GetDateTime(4); if (!reader.IsDBNull(5)) trainProjectItem.Content = reader.GetString(5); if (!reader.IsDBNull(6)) trainProjectItem.StartTime = reader.GetString(6); if (!reader.IsDBNull(7)) trainProjectItem.ConsistTime = reader.GetString(7); if (!reader.IsDBNull(8)) trainProjectItem.Position = reader.GetString(8); if (!reader.IsDBNull(9)) trainProjectItem.Des = reader.GetString(9); trainProjectItem.MarkOld(); trainProjectItemlist.Add(trainProjectItem); } reader.Close(); } return trainProjectItemlist; }
public Core.Business.TrainProjectItem Select(int id) { SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@Id", SqlDbType.Int, id); SqlDataReader reader = sql.ExecuteSqlReader(SqlSelectTrainProjectItem); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.TrainProjectItem trainProjectItem = new Core.Business.TrainProjectItem(); if (!reader.IsDBNull(0)) trainProjectItem.Id = int.Parse(reader.GetInt32(0).ToString()); if (!reader.IsDBNull(1)) trainProjectItem.ProjectCode = reader.GetString(1); if (!reader.IsDBNull(2)) trainProjectItem.ItemStartDate = reader.GetDateTime(2); if (!reader.IsDBNull(3)) trainProjectItem.ItemConsistDate = reader.GetInt32(3); if (!reader.IsDBNull(4)) trainProjectItem.ItemEndDate = reader.GetDateTime(4); if (!reader.IsDBNull(5)) trainProjectItem.Content = reader.GetString(5); if (!reader.IsDBNull(6)) trainProjectItem.StartTime = reader.GetString(6); if (!reader.IsDBNull(7)) trainProjectItem.ConsistTime = reader.GetString(7); if (!reader.IsDBNull(8)) trainProjectItem.Position = reader.GetString(8); if (!reader.IsDBNull(9)) trainProjectItem.Des = reader.GetString(9); reader.Close(); return trainProjectItem; } else { if (reader != null && !reader.IsClosed) reader.Close(); return null; } }