/// <summary>
/// 获取检索数据的Sql文
/// </summary>
/// <param name="baseFilter"></param>
/// <returns></returns>
protected override string GetSearchSql(BaseFilter baseFilter)
{
BusinessGuaranteeFilter filter = baseFilter as BusinessGuaranteeFilter;
if (filter == null)
{
return("");
}
StringBuilder sql = new StringBuilder();
sql.Append(" SELECT BusinessID ");
sql.Append(" ,BusinessStatus");
sql.Append(" ,LawsuitStatus");
sql.Append(" ,ToLitigationTime");
sql.Append(" ,IsRepayment");
sql.Append(" ,LawsuitCode");
sql.Append(" ,LoanCapital");
sql.Append(" ,LoanPeriod");
sql.Append(" ,InterestRate");
sql.Append(" ,ServiceRate");
sql.Append(" ,GuaranteeSideKey");
sql.Append(" ,ContractNo");
sql.Append(" ,CustomerID");
sql.Append(" ,LendingSideKey");
//sql.Append(" ,StopDate");
sql.Append(" FROM [dbo].[Business] WITH (NOLOCK)");
sql.Append(" WHERE BusinessID = " + filter.BusinessID);
return(sql.ToString());
}
/// <summary>
/// 根据条件查询数据
/// </summary>
/// <param name="filter"></param>
/// <param name="responseEntity"></param>
public virtual void SearchData(BusinessGuaranteeFilter filter
, ResponseEntity responseEntity)
{
var lstBus = Singleton <GuarLitigationEditDAL <BusinessViewData> >
.Instance.SearchData(filter);
if (lstBus == null || lstBus.Count == 0)
{
ServiceUtility.SetResponseStatus(responseEntity, EnumResponseState.NoResult);
m_Logger.Info("未查询到数据！。");
return;
}
// 查询关帐日
DateTime stopDate = Singleton <GuarLitigationEditDAL <BusinessViewData> > .Instance.GetCloseBillDate();
foreach (var bus in lstBus)
{
bus.StopDate = stopDate;
}
var responseResult = new ResponseListResult <BusinessViewData>();
responseResult.TotalCount = lstBus.Count;
responseResult.LstResult = lstBus;
ServiceUtility.SetResponseStatus(responseEntity, EnumResponseState.Success);
responseEntity.Results = responseResult;
}
/// <summary>
/// 获取检索数据的Sql文
/// </summary>
/// <param name="baseFilter"></param>
/// <returns></returns>
protected override string GetSearchSql(BaseFilter baseFilter)
{
BusinessGuaranteeFilter filter = baseFilter as BusinessGuaranteeFilter;
if (filter == null)
{
return("");
}
StringBuilder sql = new StringBuilder();
sql.Append(" SELECT ");
sql.Append(" GuaranteeNum ");
sql.Append(" ,ContractNo ");
sql.Append(" ,CustomerName ");
sql.Append(" ,IdenNo ");
sql.Append(" ,LoanCapital ");
sql.Append(" ,DateRegion ");
sql.Append(" ,StopDate ");
sql.Append(" ,DueCapital ");
sql.Append(" ,DueInterest ");
sql.Append(" ,DueService ");
sql.Append(" ,DuePenltyInt ");
sql.Append(" ,DueTotal ");
sql.Append(" ,ReceivedMonth ");
sql.Append(" FROM [dbo].[ViewGuaranteeDetail] ");
sql.Append(" WHERE GuaranteeNum = '" + filter.BatchNo + "'");
return(sql.ToString());
}
/// <summary>
/// 获取检索数据的Sql文
/// </summary>
/// <param name="baseFilter"></param>
/// <returns></returns>
protected override string GetSearchSql(BaseFilter baseFilter)
{
BusinessGuaranteeFilter filter = baseFilter as BusinessGuaranteeFilter;
if (filter == null)
{
return("");
}
StringBuilder sql = new StringBuilder();
sql.Append(" SELECT ");
sql.Append(" CustomerName ");
sql.Append(" ,IdenNo ");
sql.Append(" ,Mobile ");
sql.Append(" ,LendingSideKey ");
sql.Append(" ,OverAmount ");
sql.Append(" ,OverdueTag ");
sql.Append(" ,LawsuitStatus ");
sql.Append(" ,MinMonth ");
sql.Append(" ,MaxMonth ");
sql.Append(" ,ExpireDate ");
sql.Append(" FROM [dbo].[ViewBusinessGuarantee] ");
sql.Append(" WHERE BusinessID IN ('" + filter.BusinessIDs + "')");
return(sql.ToString());
}
/// <summary>
/// 程序执行主入口
/// </summary>
/// <param name="requestEntity"></param>
/// <param name="responseEntity"></param>
protected override void DoExecute(RequestEntity requestEntity, ResponseEntity responseEntity)
{
// 定义接收客户端参数的变量
BusinessGuaranteeFilter filter
= ServiceUtility.ConvertToFilterFromDict <BusinessGuaranteeFilter>(requestEntity.Parameters);
// 担保和诉讼设置查询
Singleton <GuarLitigationSearchBLL> .Instance.Search(filter, responseEntity);
}
/// <summary>
/// 程序执行主入口
/// </summary>
/// <param name="requestEntity"></param>
/// <param name="responseEntity"></param>
protected override void DoExecute(RequestEntity requestEntity, ResponseEntity responseEntity)
{
// 定义接收客户端参数的变量
BusinessGuaranteeFilter filter
= ServiceUtility.ConvertToFilterFromDict <BusinessGuaranteeFilter>(requestEntity.Parameters);
// 担保和诉讼设置编辑
Singleton <BaseSearchBLL <BusinessGuaranteeItemViewData, BusinessGuaranteeItemSearchDAL <BusinessGuaranteeItemViewData> > >
.Instance.SearchData(filter, responseEntity);
}
/// <summary>
/// 批量转担保
/// </summary>
/// <param name="filter"></param>
/// <param name="responseEntity"></param>
public void BatchConvertGurantee(BusinessGuaranteeFilter filter
, ResponseEntity responseEntity)
{
var lstBus = Singleton <GuarLitigationInBatchNumDAL <Business> > .Instance.SearchData(filter);
if (lstBus == null || lstBus.Count == 0)
{
ServiceUtility.SetResponseStatus(responseEntity, EnumResponseState.BusinessError, "查询不到订单。");
m_Logger.Info("查询不到订单。");
return;
}
string errorMessage = "";
var lstBids = new List <int>();
foreach (var bus in lstBus)
{
if (!string.IsNullOrEmpty(bus.GuaranteeNum))
{
errorMessage = string.Format("错误，订单号[{0}]已存在担保批次号[{1}]", bus.BusinessID, bus.GuaranteeNum);
break;
}
else if (bus.BusinessStatus == (byte)EnumBusinessStatus.Normal)
{
errorMessage = string.Format("错误，订单号[{0}]尚未担保，不允许输入担保批次号[{1}]", bus.BusinessID, bus.GuaranteeNum);
break;
}
else if (bus.LendingSideKey == SysConst.COMPANY_DWJM_LENDING)
{
errorMessage = string.Format("错误，订单号[{0}]是外贸订单,不支持手动录入担保批次号", bus.BusinessID);
break;
}
else if (bus.BusinessStatus == (byte)EnumBusinessStatus.Guarantee)
{
lstBids.Add(bus.BusinessID);
}
}
if (!string.IsNullOrEmpty(errorMessage))
{
ServiceUtility.SetResponseStatus(responseEntity, EnumResponseState.BusinessError, errorMessage);
m_Logger.Info(errorMessage);
}
else if (lstBids != null && lstBids.Count != 0)
{
int resultCount = Singleton <GuarLitigationInBatchNumDAL <Business> >
.Instance.UpdateBatchNum(string.Join(WebServiceConst.Separater_Comma, lstBids.ToArray()), filter.GuaranteeNum);
var responseResult = new ResponseListResult <BusinessViewData>();
responseResult.TotalCount = resultCount;
ServiceUtility.SetResponseStatus(responseEntity, EnumResponseState.Success);
responseEntity.Results = responseResult;
}
}
/// <summary>
/// 获取存贮过程的输入参数
/// </summary>
/// <param name="baseFilter"></param>
/// <returns></returns>
protected override IDictionary <string, object> GetSearchSpInParams(Entity.Filter.BaseFilter baseFilter)
{
BusinessGuaranteeFilter filter = baseFilter as BusinessGuaranteeFilter;
if (filter == null)
{
return(null);
}
IDictionary <string, object> inPutParam = new Dictionary <string, object>();
inPutParam.Add("@BusinessID", filter.BusinessID);
return(inPutParam);
}
/// <summary>
/// 根据条件查询数据
/// </summary>
/// <param name="filter"></param>
/// <param name="responseEntity"></param>
public virtual void Search(BusinessGuaranteeFilter filter
, ResponseEntity responseEntity)
{
var reportDetailList = Singleton <GuarLitigationExportGuaranteeDetailDAL <BusinessGuaranteeViewDetailData> >
.Instance.SearchData(filter);
if (reportDetailList == null || reportDetailList.Count == 0)
{
ServiceUtility.SetResponseStatus(responseEntity, EnumResponseState.NoResult);
m_Logger.Info("未查询到数据！。");
}
else
{
// 设置输出文件
SetExportFile(filter, reportDetailList, responseEntity);
}
}
/// <summary>
/// 获取检索数据的SQL文
/// </summary>
/// <param name="baseFilter"></param>
/// <returns></returns>
protected override string GetSearchSql(BaseFilter baseFilter)
{
BusinessGuaranteeFilter filter = baseFilter as BusinessGuaranteeFilter;
if (filter == null)
{
return(null);
}
StringBuilder sql = new StringBuilder();
sql.Append(" SELECT ");
sql.Append(" GuaranteeNum ");
sql.Append(" ,BusinessStatus ");
sql.Append(" ,LendingSideKey ");
sql.Append(" ,BusinessID ");
sql.Append(" FROM [dbo].[Business] WITH (NOLOCK)");
sql.Append(" WHERE BusinessID IN (" + filter.BusinessIDs + ")");
return(sql.ToString());
}
/// <summary>
/// 根据条件查询数据
/// </summary>
/// <param name="filter"></param>
/// <param name="responseEntity"></param>
public virtual void Search(BusinessGuaranteeFilter filter, ResponseEntity responseEntity)
{
var reportDetailList = Singleton <GuarLitigationExportDAL <BusinessGuaranteeViewData> >
.Instance.SearchData(filter);
if (reportDetailList == null || reportDetailList.Count == 0)
{
ServiceUtility.SetResponseStatus(responseEntity, EnumResponseState.NoResult);
m_Logger.Info("未查询到数据！。");
}
else
{
foreach (var guarantee in reportDetailList)
{
guarantee.LendingSideKeyName = Singleton <RedisEnumOperatorBLL> .Instance
.GetRedisData(RedisEnumOperatorBLL.HashId_LendingGroup_4, guarantee.LendingSideKey).Name;
}
// 设置输出文件
SetExportFile(filter, reportDetailList, responseEntity, "客户列表");
}
}
/// <summary>
/// 根据条件查询数据
/// </summary>
/// <param name="filter"></param>
/// <param name="responseEntity"></param>
public virtual void Search(BusinessGuaranteeFilter filter
, ResponseEntity responseEntity)
{
var reportDetailList = Singleton <GuarLitigationSearchDAL <BusinessGuaranteeViewData> >
.Instance.SearchData(filter);
int count = Singleton <GuarLitigationSearchDAL <BusinessGuaranteeViewData> >
.Instance.GetCount(filter);
if (reportDetailList == null || reportDetailList.Count == 0)
{
ServiceUtility.SetResponseStatus(responseEntity, EnumResponseState.NoResult);
m_Logger.Info("未查询到数据！。");
}
else
{
foreach (var guarantee in reportDetailList)
{
guarantee.LendingSideKeyName = Singleton <RedisEnumOperatorBLL> .Instance
.GetRedisData(RedisEnumOperatorBLL.HashId_LendingGroup_4, guarantee.LendingSideKey).Name;
}
var responseResult = new ResponseListResult <BusinessGuaranteeViewData>();
if (filter.IsPage)
{
responseResult.TotalCount = count;
}
else
{
responseResult.TotalCount = 1;
}
responseResult.LstResult = reportDetailList;
ServiceUtility.SetResponseStatus(responseEntity, EnumResponseState.Success);
responseEntity.Results = responseResult;
}
}
/// <summary>
/// 获取检索数据的存储过程参数列表
/// </summary>
/// <param name="baseFilter"></param>
/// <returns></returns>
protected override IDictionary <string, object> GetSearchSpInParams(BaseFilter baseFilter)
{
BusinessGuaranteeFilter filter = baseFilter as BusinessGuaranteeFilter;
if (filter == null)
{
return(null);
}
IDictionary <string, object> inPutParam = new Dictionary <string, object>();
if (!string.IsNullOrEmpty(filter.CustomerName))
{
inPutParam.Add("@CustomerName", filter.CustomerName);
}
if (!string.IsNullOrEmpty(filter.IdenNo))
{
inPutParam.Add("@IdNumber", filter.IdenNo);
}
if (!string.IsNullOrEmpty(filter.ContractNo))
{
inPutParam.Add("@ContractNo", filter.ContractNo);
}
if (!string.IsNullOrEmpty(filter.OverdueTag))
{
inPutParam.Add("@OverdueTag", filter.OverdueTag);
}
if (!string.IsNullOrEmpty(filter.GuaranteeSideKey))
{
inPutParam.Add("@GuaranteeSideKey", filter.GuaranteeSideKey);
}
if (filter.BusinessStatus > 0)
{
inPutParam.Add("@BusinessStatus", filter.BusinessStatus);
}
if (!string.IsNullOrEmpty(filter.ServiceSideKey))
{
inPutParam.Add("@ServiceSideKey", filter.ServiceSideKey);
}
if (!string.IsNullOrEmpty(filter.LendingSideKey))
{
inPutParam.Add("@LendingSideKey", filter.LendingSideKey);
}
if (!string.IsNullOrEmpty(filter.GuaranteeNum))
{
inPutParam.Add("@GuaranteeNum", filter.GuaranteeNum);
}
if (filter.CapitalCnt > 0)
{
inPutParam.Add("@CapitalCnt", filter.CapitalCnt);
}
if (!string.IsNullOrEmpty(filter.ToGuaranteeFromTime))
{
inPutParam.Add("@ToGuaranteeFromTime", filter.ToGuaranteeFromTime);
}
if (!string.IsNullOrEmpty(filter.ToGuaranteeToTime))
{
inPutParam.Add("@ToGuaranteeToTime", filter.ToGuaranteeToTime);
}
if (!string.IsNullOrEmpty(filter.CompanyKeys))
{
inPutParam.Add("@CompanyKeys", filter.CompanyKeys);
}
// 需要分页
if (filter.IsPage)
{
inPutParam.Add("@FromIndex", filter.FromIndex);
inPutParam.Add("@ToIndex", filter.ToIndex);
}
return(inPutParam);
}
