/// <summary>
/// 检索数据
/// </summary>
/// <param name="filter"></param>
/// <param name="responseEntity"></param>
public void ExportData(DeriveSevExportFilter filter, ResponseEntity responseEntity)
{
if (filter == null)
{
ServiceUtility.SetResponseStatus(responseEntity, EnumResponseState.RequestCommandError);
return;
}
var reportDetailList
= Singleton <DeriveSevReceivedExportDAL <DeriveSevExportReceiveViewData> > .Instance.SearchData(filter);
if (reportDetailList == null || reportDetailList.Count == 0)
{
ServiceUtility.SetResponseStatus(responseEntity, EnumResponseState.NoResult);
m_Logger.Info("无数据可导出！。");
}
else
{
//string[] titles = new string[] {
// "类型","合同号","姓名"};
//string[] fileds = new string[] {
// "StrReviceType", "ContactNo", "CustomerName"};
//filter.Titles = string.Join(",", titles);
//filter.Fields = string.Join(",", fileds);
SetExportData(reportDetailList);
// 设置输出文件
SetExportFile(filter, reportDetailList, responseEntity);
}
}
/// <summary>
/// 获取存贮过程输入参数
/// </summary>
/// <param name="baseFilter"></param>
/// <returns></returns>
protected override IDictionary <string, object> GetSearchSpInParams(BaseFilter baseFilter)
{
DeriveSevExportFilter filter = baseFilter as DeriveSevExportFilter;
if (filter == null)
{
return(null);
}
IDictionary <string, object> inPutParam = new Dictionary <string, object>();
inPutParam.Add("@BeginDate", filter.StartDate);
inPutParam.Add("@EndDate", filter.EndDate);
inPutParam.Add("@ServiceSideKey", filter.ServiceSideKey);
inPutParam.Add("@BranchKeyList", filter.BranchKey);
return(inPutParam);
}
/// <summary>
/// 检索数据
/// </summary>
/// <param name="filter"></param>
/// <param name="responseEntity"></param>
public void ExportData(DeriveSevExportFilter filter, ResponseEntity responseEntity)
{
if (filter == null)
{
ServiceUtility.SetResponseStatus(responseEntity, EnumResponseState.RequestCommandError);
return;
}
var reportDetailList
= Singleton <DeriveSevForeign3ExportDAL <DeriveSevExportForeignViewData> > .Instance.SearchData(filter);
if (reportDetailList == null || reportDetailList.Count == 0)
{
ServiceUtility.SetResponseStatus(responseEntity, EnumResponseState.NoResult);
m_Logger.Info("无数据可导出！。");
}
else
{
// 格式化成导出的格式
DataTable dt = FormatToExport(reportDetailList, filter);
// 设置输出文件
SetExportFile(filter, dt, responseEntity);
}
}
/// <summary>
/// 格式化成导出的格式
/// </summary>
/// <param name="batchViewList">原始数据</param>
/// <returns>格式化后结果</returns>
private DataTable FormatToExport(List <DeriveSevExportForeignViewData> batchViewList, DeriveSevExportFilter filter)
{
DataTable dtb = new DataTable();
string[] columns = filter.Fields.Split(WebServiceConst.Separater_Comma.ToArray());
foreach (string col in columns)
{
dtb.Columns.Add(col);
}
foreach (var data in batchViewList)
{
DataRow dtr = dtb.NewRow();
dtr["BusinessCode"] = "030";
dtr["ContractID"] = data.ContractNo;
dtr["CustomerName"] = data.CustomerName;
dtr["AccountID"] = data.AccountID;
dtr["BnakID"] = data.BnakID;
dtr["City"] = data.City;
dtr["PaymentDate"] = data.PaymentDate.ToDateTimeString().Replace(" 00:00:00", string.Empty);
dtb.Rows.Add(dtr);
}
return(dtb);
}
/// <summary>
/// 格式化成导出的格式
/// </summary>
/// <param name="batchViewList">原始数据</param>
/// <returns>格式化后结果</returns>
private DataTable FormatToExport(List <DeriveSevExportForeignViewData> batchViewList, DeriveSevExportFilter filter)
{
DataTable dtb = new DataTable();
string[] columns = filter.Fields.Split(WebServiceConst.Separater_Comma.ToArray());
foreach (string col in columns)
{
dtb.Columns.Add(col);
}
foreach (var data in batchViewList)
{
DataRow dtr = dtb.NewRow();
dtr["BusinessCode"] = data.BusinessCode;
dtr["ContractID"] = data.ContractID;
dtr["CustomerName"] = data.CustomerName;
dtr["DeductDate"] = data.DeductDate;
dtr["DeductType"] = data.DeductType;
dtr["ContractAmount"] = data.ContractAmount;
dtr["InterestAmount"] = data.InterestAmount;
dtr["ServiceFee"] = data.ServiceFee;
dtr["ServiceFeedeductcharge"] = data.ServiceFeedeductcharge;
dtr["deductcharge"] = data.deductcharge;
dtr["guaranteecharge"] = data.guaranteecharge;
dtr["CleanCreditCharge"] = data.CleanCreditCharge;
dtr["PunitiveInterestAmount"] = data.PunitiveInterestAmount;
dtr["RepayDuration"] = data.RepayDuration;
dtr["ContractTerminatedDate"] = data.ContractTerminatedDate;
dtr["RepaySeqNo"] = data.RepaySeqNo;
dtr["ThirdPartyCode"] = data.ThirdPartyCode;
dtr["RecieveDate"] = data.RecieveDate;
dtb.Rows.Add(dtr);
}
return(dtb);
}
