public void SetEnt(BuStationInfo ent, IDataReader dr)
{
ent.StationId = MyConvert.ToInt(dr["StationId"]);
ent.StationName = MyConvert.ToString(dr["StationName"]);
ent.StationBoss = MyConvert.ToString(dr["StationBoss"]);
ent.ProvinceId = MyConvert.ToInt(dr["ProvinceId"]);
ent.CityId = MyConvert.ToInt(dr["CityId"]);
ent.Address = MyConvert.ToString(dr["Address"]);
}
/// <summary>
/// 得到列表
/// </summary>
/// <param name="ent"></param>
/// <returns></returns>
public List <BuStationInfo> GetBuStationInfoList(string Where)
{
List <BuStationInfo> list = new List <BuStationInfo>();
using (DbDataReader reader = DataBaseManage.ExecuteReader(DalSql + Where))
{
while (reader.Read())
{
BuStationInfo ent = new BuStationInfo();
SetEnt(ent, reader);
list.Add(ent);
}
}
return(list);
}
/// <summary>
/// 根据StationId得到 BuStationInfo 实体
/// </summary>
/// <param name="ent"></param>
/// <returns></returns>
public BuStationInfo GetBuStationInfo(int StationId)
{
BuStationInfo ent = null;
string sql = DalSql;
sql = sql + " And StationId";
MySqlParameter[] paras = new MySqlParameter[]
{
new MySqlParameter("StationId", StationId)
};
using (DbDataReader reader = DataBaseManage.ExecuteReader(sql, paras))
{
if (reader.Read())
{
ent = new BuStationInfo();
SetEnt(ent, reader);
}
}
return(ent);
}
