public void SetEnt(BuCarInfo ent, IDataReader dr) { ent.CarNumber = MyConvert.ToString(dr["CarNumber"]); ent.CarName = MyConvert.ToString(dr["CarName"]); ent.CarKind = MyConvert.ToString(dr["CarKind"]); ent.CarRemark = MyConvert.ToString(dr["CarRemark"]); }
/// <summary> /// 得到列表 /// </summary> /// <param name="ent"></param> /// <returns></returns> public List<BuCarInfo> GetBuCarInfoList(string Where) { List<BuCarInfo> list = new List<BuCarInfo>(); using(DbDataReader reader = DataBaseManage.ExecuteReader(DalSql+Where)) { while (reader.Read()) { BuCarInfo ent = new BuCarInfo(); SetEnt(ent, reader); list.Add(ent); } } return list; }
/// <summary> /// 得到列表 /// </summary> /// <param name="ent"></param> /// <returns></returns> public List <BuCarInfo> GetBuCarInfoList(string Where) { List <BuCarInfo> list = new List <BuCarInfo>(); using (DbDataReader reader = DataBaseManage.ExecuteReader(DalSql + Where)) { while (reader.Read()) { BuCarInfo ent = new BuCarInfo(); SetEnt(ent, reader); list.Add(ent); } } return(list); }
/// <summary> /// 根据CarNumber得到 BuCarInfo 实体 /// </summary> /// <param name="ent"></param> /// <returns></returns> public BuCarInfo GetBuCarInfo(string CarNumber) { BuCarInfo ent = null; string sql = DalSql; sql = sql + " And CarNumber"; MySqlParameter[] paras = new MySqlParameter[] { new MySqlParameter("CarNumber",CarNumber) }; using(DbDataReader reader = DataBaseManage.ExecuteReader(sql, paras)) { if (reader.Read()) { ent = new BuCarInfo(); SetEnt(ent, reader); } } return ent; }
/// <summary> /// 根据CarNumber得到 BuCarInfo 实体 /// </summary> /// <param name="ent"></param> /// <returns></returns> public BuCarInfo GetBuCarInfo(string CarNumber) { BuCarInfo ent = null; string sql = DalSql; sql = sql + " And CarNumber"; MySqlParameter[] paras = new MySqlParameter[] { new MySqlParameter("CarNumber", CarNumber) }; using (DbDataReader reader = DataBaseManage.ExecuteReader(sql, paras)) { if (reader.Read()) { ent = new BuCarInfo(); SetEnt(ent, reader); } } return(ent); }