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