protected override void DoExecute(RequestEntity requestEntity, ResponseEntity responseEntity)
{
// 定义接收客户端参数的变量
DeductRemindExportFilter filter
= ServiceUtility.ConvertToFilterFromDict <DeductRemindExportFilter>(requestEntity.Parameters);
// 客户查询
Singleton <DeductRemindExportBLL> .Instance.SearchData(filter, responseEntity);
}
protected override IDictionary <string, object> GetSearchSpInParams(Entity.Filter.BaseFilter baseFilter)
{
DeductRemindExportFilter filter = baseFilter as DeductRemindExportFilter;
if (null == filter)
{
return(null);
}
IDictionary <string, object> dicParams = new Dictionary <string, object>();
dicParams.Add("@LoanTimeBegin", filter.LoanTimeBegin);
dicParams.Add("@LoanTimeEnd", filter.LoanTimeEnd);
dicParams.Add("@SaleModel", filter.SaleModel);
dicParams.Add("@ProductKind", filter.ProductKind);
dicParams.Add("@BranchKeyList", filter.BranchKeyList);
return(dicParams);
}
/// <summary>
/// 检索数据
/// </summary>
/// <param name="baseFilter"></param>
/// <param name="responseEntity"></param>
public void SearchData(DeductRemindExportFilter baseFilter, ResponseEntity responseEntity)
{
if (baseFilter == null)
{
ServiceUtility.SetResponseStatus(responseEntity, EnumResponseState.RequestCommandError);
return;
}
baseFilter.ExportFileType = (int)EnumExportFileType.Xlsx;
var reportDetailList = Singleton <DeductRemindExportDAL> .Instance.SearchDataToDataTable(baseFilter);
if (reportDetailList == null || reportDetailList.Rows.Count == 0)
{
ServiceUtility.SetResponseStatus(responseEntity, EnumResponseState.NoResult);
m_Logger.Info("未查询到数据！。");
}
else
{
//转义枚举
foreach (DataRow item in reportDetailList.Rows)
{
item["Region"] = GetEnumValue(RedisEnumOperatorBLL.HashId_Region_9, item["Region"].ToString());
item["BranchKey"] = GetEnumValue(RedisEnumOperatorBLL.HashId_Store_12, item["BranchKey"].ToString());
item["SaleMode"] = GetEnumValue(RedisEnumOperatorBLL.HashId_SaleMode_13, item["SaleMode"].ToString());
}
//表头转换为中文,可以写在配置中,暂时在Code中指定
foreach (DataColumn col in reportDetailList.Columns)
{
if (dicEng2ChnColumn.ContainsKey(col.ColumnName))
{
col.ColumnName = dicEng2ChnColumn[col.ColumnName];
}
}
SetExportFile(baseFilter, reportDetailList, responseEntity);
}
}