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