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