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