/// <summary>
/// 获取保存数据的Sql文
/// </summary>
/// <param name="baseFilter"></param>
/// <returns></returns>
protected override string GetUpdateSql(Entity.Filter.BaseFilter baseFilter)
{
var filter = baseFilter as AdaptationCardFilter;
if (filter == null)
{
return("");
}
return(@" DELETE FROM [dbo].[AdaptationCard] WHERE AdaptationCardID = "
+ filter.AdaptationCardID);
}
/// <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);
}
protected override IDictionary <string, object> GetSearchSpInParams(Entity.Filter.BaseFilter baseFilter)
{
QueryEnumerationFilter filter = baseFilter as QueryEnumerationFilter;
if (null != filter)
{
IDictionary <string, object> dicParameter = new Dictionary <string, object>();
dicParameter.Add("@FullKey", filter.FullKey);
dicParameter.Add("@EnumID", filter.EnumID);
dicParameter.Add("@GetEnumType", filter.GetEnumType);
return(dicParameter);
}
return(null);
}
/// <summary>
/// 获取保存数据的Sql文
/// </summary>
/// <param name="baseFilter"></param>
/// <returns></returns>
protected override string GetUpdateSql(Entity.Filter.BaseFilter baseFilter)
{
var filter = baseFilter as ClearLoanReasonSaveFilter;
if (filter == null)
{
return("");
}
string sql = @" UPDATE dbo.Business
SET ClearLoanType = '" + filter.ClearLoanType + "'";
sql += " ,ClearLoanRemark = '" + filter.ClearLoanRemark + "'";
sql += " WHERE BusinessID = " + filter.BusinessId;
return(sql);
}
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>
/// 获取保存数据的Sql文
/// </summary>
/// <param name="baseFilter"></param>
/// <returns></returns>
protected override string GetUpdateSql(Entity.Filter.BaseFilter baseFilter)
{
var filter = baseFilter as AdaptationCardFilter;
if (filter == null)
{
return("");
}
return(@" INSERT INTO [dbo].[AdaptationCard] (
CardNo,CardUser,AdaBankName,ValidPath,ValidEndTime,
AdaDesc,ValidName,BusinessID,AdaName, CreateTime ) VALUES ( '"
+ filter.CardNo + "','"
+ filter.CardUser + "','"
+ filter.AdaBankName + "','"
+ filter.ValidPath + "','"
+ filter.ValidEndTime + "','"
+ filter.AdaDesc + "','"
+ filter.ValidName + "',"
+ filter.BusinessID + ",'"
+ filter.AdaName + "','"
+ filter.CreateTime + "' )");
}
/// <summary>
/// 获取更新代偿款支付剩余本息支付日Sql
/// </summary>
/// <param name="baseFilter"></param>
/// <returns></returns>
protected override string GetUpdateSql(Entity.Filter.BaseFilter baseFilter)
{
var filter = baseFilter as InterestFitFilter;
if (filter == null)
{
return("");
}
string sql = "Update dbo.Business Set PaymentDate = ";
if (!string.IsNullOrEmpty(filter.PaymentDate))
{
sql += "'" + filter.PaymentDate.ToDateTime() + "'";
}
else
{
sql += " NULL";
}
sql += " WHERE ContractNo IN ('" + filter.ContractNos + "')";
return(sql);
}
/// <summary>
/// 获取存储过程的名称
/// </summary>
/// <param name="baseFilter"></param>
/// <returns></returns>
protected override string GetSearchSpName(Entity.Filter.BaseFilter baseFilter)
{
return("proc_Dun_GetBHGuaranteeAmount");
}
protected override string GetSearchSql(Entity.Filter.BaseFilter baseFilter)
{
string sql = string.Empty;
return(base.GetSearchSql(baseFilter));
}
/// <summary>
/// 重写SP入参
/// </summary>
/// <param name="baseFilter"></param>
/// <returns></returns>
protected override System.Collections.Generic.IDictionary <string, object> GetSearchSpInParams(Entity.Filter.BaseFilter baseFilter)
{
IDictionary <string, object> dicParams = new Dictionary <string, object>();
QueryGuarBusinessFilter filter = baseFilter as QueryGuarBusinessFilter;
if (null == filter)
{
throw new Exception("入参Filter格式转换失败");
}
dicParams.Add("@Region", filter.Region);
dicParams.Add("@BranchKey", filter.Branch);
dicParams.Add("@TeamName", filter.Team);
dicParams.Add("@ProductKind", filter.BusinessKind);
dicParams.Add("@CustomerType", filter.CustomerType);
dicParams.Add("@StartLoanTime", filter.LoanStartTime);
dicParams.Add("@EndLoanTime", filter.LoanEndTime);
dicParams.Add("@StartGuarTime", filter.GuarStartTime);
dicParams.Add("@EndGuarTime", filter.GuarEndTime);
dicParams.Add("@OverMonth", filter.OverDueStatus);
dicParams.Add("@PaidStatus", filter.ReceiveStauts);
dicParams.Add("@PageIndex", filter.PageNo);
dicParams.Add("@PageSize", filter.PageSize);
return(dicParams);
}
/// <summary>
/// 重写SP名称
/// </summary>
/// <param name="baseFilter"></param>
/// <returns></returns>
protected override string GetSearchSpName(Entity.Filter.BaseFilter baseFilter)
{
return("proc_Dun_QueryGuarBusiness");
}
protected override string GetSearchSpName(Entity.Filter.BaseFilter baseFilter)
{
return("proc_Customer_QueryDeductRemind");
}
protected override string GetSearchSpName(Entity.Filter.BaseFilter baseFilter)
{
return("proc_Common_GetEnumeration");
}
