/// <summary>
/// 由DataTable得到泛型数据列表
/// </summary>
internal List <EmsModel.PlanExperiment> GetList_GetPage(DataTable dt)
{
List <EmsModel.PlanExperiment> lst = new List <EmsModel.PlanExperiment>();
for (int i = 0; i < dt.Rows.Count; i++)
{
EmsModel.PlanExperiment mod = new EmsModel.PlanExperiment();
DataRowToModel_GetPage(mod, dt.Rows[i]);
lst.Add(mod);
}
return(lst);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public EmsModel.PlanExperiment GetEmsModel(int?ID)
{
StringBuilder sbSql4org;
DbParameter[] parms4org;
sbSql4org = new StringBuilder();
sbSql4org.Append("SELECT a.*,b.OrderNo FROM PlanExperiment a left join OrderInfo b on a.id=b.ExperimentId");
sbSql4org.Append(" WHERE a.ID=@in_ID");
parms4org = new DbParameter[] {
dbHelper.CreateInDbParameter("@in_ID", DbType.Int32, ID)
};
using (DbDataReader dr = dbHelper.ExecuteReader(CommandType.Text, sbSql4org.ToString(), parms4org))
{
if (dr.Read())
{
EmsModel.PlanExperiment mod = new EmsModel.PlanExperiment();
DbDataReaderToModel(mod, dr);
return(mod);
}
return(null);
}
}
/// <summary>
/// 由一行数据得到一个实体
/// </summary>
internal void DataRowToModel_GetPage(EmsModel.PlanExperiment EmsModel, DataRow dr)
{
DataRowToModel(EmsModel, dr);
//EmsModel.Id = dr["Id"] as int?; EmsModel.Name = dr["Name"] as string; EmsModel.Type = dr["Type"] as Byte?; EmsModel.IsOpen = dr["IsOpen"] as Byte?; EmsModel.StartDate = dr["StartDate"] as DateTime?; EmsModel.Week = dr["Week"] as int?; EmsModel.Weekday = dr["Weekday"] as int?; EmsModel.ClassHour = dr["ClassHour"] as int?; EmsModel.Part = dr["Part"] as string; EmsModel.Place = dr["Place"] as int?; EmsModel.GroupMemberNumber = dr["GroupMemberNumber"] as int?; EmsModel.GroupNumber = dr["GroupNumber"] as int?; EmsModel.NeedEquip = dr["NeedEquip"] as string; EmsModel.Contents = dr["Contents"] as string; EmsModel.PlanId = dr["PlanId"] as int?; EmsModel.Status = dr["Status"] as Byte?; EmsModel.Creator = dr["Creator"] as string; EmsModel.CreateTime = dr["CreateTime"] as DateTime?; EmsModel.Editor = dr["Editor"] as string; EmsModel.UpdateTime = dr["UpdateTime"] as DateTime?; EmsModel.IsDelete = dr["IsDelete"] as Byte?;
EmsModel.CreatorName = dr["CreatorName"] as string;
}
