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