public void SetEnt(BuBigStationInfo ent, IDataReader dr) { ent.BigStationId = MyConvert.ToInt(dr["BigStationId"]); ent.BigStationName = MyConvert.ToString(dr["BigStationName"]); ent.BigStationProvince = MyConvert.ToInt(dr["BigStationProvince"]); ent.BigStationCity = MyConvert.ToInt(dr["BigStationCity"]); ent.BigSstationAddress = MyConvert.ToInt(dr["BigSstationAddress"]); }
/// <summary> /// 得到列表 /// </summary> /// <param name="ent"></param> /// <returns></returns> public List<BuBigStationInfo> GetBuBigStationInfoList(string Where) { List<BuBigStationInfo> list = new List<BuBigStationInfo>(); using(DbDataReader reader = DataBaseManage.ExecuteReader(DalSql+Where)) { while (reader.Read()) { BuBigStationInfo ent = new BuBigStationInfo(); SetEnt(ent, reader); list.Add(ent); } } return list; }
/// <summary> /// 得到列表 /// </summary> /// <param name="ent"></param> /// <returns></returns> public List <BuBigStationInfo> GetBuBigStationInfoList(string Where) { List <BuBigStationInfo> list = new List <BuBigStationInfo>(); using (DbDataReader reader = DataBaseManage.ExecuteReader(DalSql + Where)) { while (reader.Read()) { BuBigStationInfo ent = new BuBigStationInfo(); SetEnt(ent, reader); list.Add(ent); } } return(list); }
/// <summary> /// 根据BigStationId得到 BuBigStationInfo 实体 /// </summary> /// <param name="ent"></param> /// <returns></returns> public BuBigStationInfo GetBuBigStationInfo(int BigStationId) { BuBigStationInfo ent = null; string sql = DalSql; sql = sql + " And BigStationId"; MySqlParameter[] paras = new MySqlParameter[] { new MySqlParameter("BigStationId",BigStationId) }; using(DbDataReader reader = DataBaseManage.ExecuteReader(sql, paras)) { if (reader.Read()) { ent = new BuBigStationInfo(); SetEnt(ent, reader); } } return ent; }
/// <summary> /// 根据BigStationId得到 BuBigStationInfo 实体 /// </summary> /// <param name="ent"></param> /// <returns></returns> public BuBigStationInfo GetBuBigStationInfo(int BigStationId) { BuBigStationInfo ent = null; string sql = DalSql; sql = sql + " And BigStationId"; MySqlParameter[] paras = new MySqlParameter[] { new MySqlParameter("BigStationId", BigStationId) }; using (DbDataReader reader = DataBaseManage.ExecuteReader(sql, paras)) { if (reader.Read()) { ent = new BuBigStationInfo(); SetEnt(ent, reader); } } return(ent); }