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