public void SetEnt(BuGastankInfo ent, IDataReader dr) { ent.TankNumber = MyConvert.ToString(dr["TankNumber"]); ent.TankKind = MyConvert.ToString(dr["TankKind"]); ent.TankVolume = MyConvert.ToString(dr["TankVolume"]); ent.Tank1 = MyConvert.ToString(dr["Tank1"]); ent.Tank2 = MyConvert.ToString(dr["Tank2"]); ent.Tank3 = MyConvert.ToString(dr["Tank3"]); }
/// <summary> /// 得到列表 /// </summary> /// <param name="ent"></param> /// <returns></returns> public List <BuGastankInfo> GetBuGastankInfoList(string Where) { List <BuGastankInfo> list = new List <BuGastankInfo>(); using (DbDataReader reader = DataBaseManage.ExecuteReader(DalSql + Where)) { while (reader.Read()) { BuGastankInfo ent = new BuGastankInfo(); SetEnt(ent, reader); list.Add(ent); } } return(list); }
/// <summary> /// 根据TankNumber得到 BuGastankInfo 实体 /// </summary> /// <param name="ent"></param> /// <returns></returns> public BuGastankInfo GetBuGastankInfo(string TankNumber) { BuGastankInfo ent = null; string sql = DalSql; sql = sql + " And TankNumber"; MySqlParameter[] paras = new MySqlParameter[] { new MySqlParameter("TankNumber", TankNumber) }; using (DbDataReader reader = DataBaseManage.ExecuteReader(sql, paras)) { if (reader.Read()) { ent = new BuGastankInfo(); SetEnt(ent, reader); } } return(ent); }