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