/// <summary>
/// 检索数据
/// </summary>
/// <param name="baseFilter"></param>
/// <param name="responseEntity"></param>
public void SearchData(XtgJhzkCheckExportFilter baseFilter, ResponseEntity responseEntity)
{
if (baseFilter == null)
{
ServiceUtility.SetResponseStatus(responseEntity, EnumResponseState.RequestCommandError);
return;
}
var reportDetailList
= Singleton <XtgJhzkCheckExportDAL <XtgJhzkViewData> > .Instance.SearchData(baseFilter);
if (reportDetailList == null || reportDetailList.Count == 0)
{
ServiceUtility.SetResponseStatus(responseEntity, EnumResponseState.NoResult);
m_Logger.Info("未查询到数据！。");
}
else
{
// 设置输出文件
SetExportFile(baseFilter, reportDetailList, responseEntity);
}
}
/// <summary>
/// 生成检索条件
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
private string CombineCondition(XtgJhzkCheckExportFilter filter)
{
StringBuilder sb = new StringBuilder();
sb.Append(" WHERE ProductType = " + filter.BillType.ToByte());
if (!string.IsNullOrEmpty(filter.Region))
{
sb.Append(" AND Region = '" + filter.Region + "'");
}
if (filter.BusinessID != 0)
{
sb.Append(" AND Bid = " + filter.BusinessID);
}
if (!string.IsNullOrEmpty(filter.ContractNo))
{
sb.Append(" AND ContractNo = '" + filter.ContractNo + "'");
}
if (!string.IsNullOrEmpty(filter.CashCardNo))
{
sb.Append(" AND SavingCard = '" + filter.CashCardNo + "'");
}
if (!string.IsNullOrEmpty(filter.BillStatus))
{
sb.Append(" AND BusinessStatus = " + filter.BillStatus.ToByte());
}
if (!string.IsNullOrEmpty(filter.LendingSide))
{
sb.Append(" AND LendingSide = '" + filter.LendingSide + "'");
}
if (!string.IsNullOrEmpty(filter.ServiceSide))
{
sb.Append(" AND ServiceSide = '" + filter.ServiceSide + "'");
}
if (!string.IsNullOrEmpty(filter.ReceiveAccount) &&
"1" == filter.ReceiveAccount)
{
sb.Append(" AND AccountID IN (11, 13, 14)");
}
if (!string.IsNullOrEmpty(filter.StartTime))
{
DateTime receivedTimeB = DateTime.Parse(filter.StartTime);
if (receivedTimeB > DateTime.Parse(filter.StartTime).Date)
{
receivedTimeB = DateTime.Parse(filter.StartTime);
}
else
{
receivedTimeB = DateTime.Parse(filter.StartTime).Date;
}
sb.Append(" AND ReceivedTime >= '" + receivedTimeB.ToString() + "'");
}
if (!string.IsNullOrEmpty(filter.EndTime))
{
DateTime receivedTimeE = DateTime.Parse(filter.EndTime);
if (receivedTimeE > DateTime.Parse(filter.EndTime).Date)
{
receivedTimeE = DateTime.Parse(filter.EndTime).AddSeconds(1);
}
else
{
receivedTimeE = receivedTimeE.Date.AddDays(1);
}
sb.Append(" AND ReceivedTime < '" + receivedTimeE.ToString() + "'");
}
if (!string.IsNullOrEmpty(filter.ToAccountBeginDate))
{
sb.Append(" AND ToAcountTime >= '" + filter.ToAccountBeginDate + "'");
}
if (!string.IsNullOrEmpty(filter.ToAccountEndDate))
{
sb.Append(" AND ToAcountTime <= '" + filter.ToAccountEndDate + "'");
}
if (!string.IsNullOrEmpty(filter.ReceiveType))
{
sb.Append(" AND ReceivedType IN ('" + filter.ReceiveType + "')");
}
if (!string.IsNullOrEmpty(filter.ReptColSubject))
{
sb.Append(" AND Subject IN ('" + filter.ReptColSubject + "')");
}
return(sb.ToString());
}
