public void SetEnt(BuGastankRepair ent, IDataReader dr) { ent.GasRepairId = MyConvert.ToInt(dr["GasRepairId"]); ent.GasRepairDate = MyConvert.ToDateTime(dr["GasRepairDate"]); ent.TankNumber = MyConvert.ToString(dr["TankNumber"]); ent.DutyOfficer = MyConvert.ToString(dr["DutyOfficer"]); ent.Remark = MyConvert.ToString(dr["Remark"]); }
/// <summary> /// 得到列表 /// </summary> /// <param name="ent"></param> /// <returns></returns> public List <BuGastankRepair> GetBuGastankRepairList(string Where) { List <BuGastankRepair> list = new List <BuGastankRepair>(); using (DbDataReader reader = DataBaseManage.ExecuteReader(DalSql + Where)) { while (reader.Read()) { BuGastankRepair ent = new BuGastankRepair(); SetEnt(ent, reader); list.Add(ent); } } return(list); }
/// <summary> /// 根据GasRepairId得到 BuGastankRepair 实体 /// </summary> /// <param name="ent"></param> /// <returns></returns> public BuGastankRepair GetBuGastankRepair(int GasRepairId) { BuGastankRepair ent = null; string sql = DalSql; sql = sql + " And GasRepairId"; MySqlParameter[] paras = new MySqlParameter[] { new MySqlParameter("GasRepairId", GasRepairId) }; using (DbDataReader reader = DataBaseManage.ExecuteReader(sql, paras)) { if (reader.Read()) { ent = new BuGastankRepair(); SetEnt(ent, reader); } } return(ent); }