/// <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);
}
}
