/// <summary> /// 根据收费id获取收费信息 /// </summary> /// <param name="chargeId"></param> /// <returns></returns> public WaterChageItem GetCharInfoByChargeId(string chargeId) { WaterChageItem retData = null; if (string.IsNullOrWhiteSpace(chargeId)) { return(retData); } using (var context = WDbContext()) { var sql = @"select CHARGEID,CHARGETYPEID,CHARGEDATETIME,RECEIPTPRINTCOUNT,RECEIPTNO from WATERFEECHARGE where CHARGEID=@chargeId"; retData = context.Sql(sql) .Parameter("chargeId", chargeId) .QuerySingle <WaterChageItem>(); return(retData); } }
/// <summary> /// /// </summary> /// <param name="recordId"></param> /// <returns></returns> public WaterChageItem GetChargeInfoByRecordId(string recordId) { WaterChageItem retData = null; if (string.IsNullOrWhiteSpace(recordId)) { return(retData); } using (var context = WDbContext()) { var sql = @"select c.CHARGEID,c.CHARGETYPEID,c.CHARGEDATETIME,c.RECEIPTPRINTCOUNT,c.RECEIPTNO from WATERFEECHARGE c join readMeterRecord r on c.CHARGEID=r.chargeID where r.readMeterRecordId=@recordId"; retData = context.Sql(sql) .Parameter("recordId", recordId) .QuerySingle <WaterChageItem>(); return(retData); } }