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