/// <summary>
/// 保存数据
/// </summary>
/// <param name="baseFilter"></param>
/// <param name="responseEntity"></param>
public void SaveData(BaseFilter baseFilter, ResponseEntity responseEntity)
{
var filter = baseFilter as ClearLoanReasonSaveFilter;
if (filter == null)
{
ServiceUtility.SetResponseStatus(responseEntity, EnumResponseState.RequestCommandError);
return;
}
var searchFilter = new ClearLoanReasonSearchFilter();
searchFilter.ContractNo = filter.ContractNo;
var lstResult = Singleton <ClearLoanReasonSearchDAL <ClearLoanReasonSearchViewData> >
.Instance.SearchData(searchFilter);
if (lstResult == null || lstResult.Count == 0)
{
ServiceUtility.SetResponseStatus(responseEntity, EnumResponseState.Others, "内部异常");
m_Logger.Info("内部异常。");
return;
}
else
{
var business = lstResult[0];
if (business.ClearLoanType == filter.ClearLoanType &&
business.ClearLoanRemark == filter.ClearLoanRemark)
{
ServiceUtility.SetResponseStatus(responseEntity
, EnumResponseState.Others, "未更改原因，请更改原因后保存。");
m_Logger.Info("未更改原因，请更改原因后保存。");
return;
}
filter.BusinessId = business.BusinessID;
int ret = Singleton <ClearLoanReasonSaveDAL> .Instance.Update(filter);
if (ret > 0)
{
var responseResult = new ResponseListResult <ClearLoanReasonSearchViewData>();
responseResult.TotalCount = 1;
responseResult.LstResult = lstResult;
ServiceUtility.SetResponseStatus(responseEntity, EnumResponseState.Success);
responseEntity.Results = responseResult;
}
else
{
ServiceUtility.SetResponseStatus(responseEntity, EnumResponseState.Others, "更新失败。");
}
}
}
/// <summary>
/// 根据过滤条件，返回检索数据的Sql文
/// </summary>
/// <param name="baseFilter"></param>
/// <returns></returns>
protected override string GetSearchSql(BaseFilter baseFilter)
{
ClearLoanReasonSearchFilter filter = baseFilter as ClearLoanReasonSearchFilter;
if (filter == null)
{
return("");
}
StringBuilder sb = new StringBuilder();
sb.Append(" SELECT BillID");
sb.Append(" ,BusinessID");
//sb.Append(" ,CustomerID");
sb.Append(" ,BillType");
sb.Append(" ,BillStatus");
sb.Append(" ,BillMonth");
sb.Append(" ,CompanyKey");
sb.Append(" ,BeginTime");
sb.Append(" ,EndTime");
sb.Append(" ,LimitTime");
sb.Append(" ,CreateTime");
//sb.Append(" ,OperatorID");
sb.Append(" ,IsCurrent");
sb.Append(" ,FullPaidTime");
sb.Append(" ,IsShelve");
//sb.Append(" ,DeductionID");
//sb.Append(" ,IsFixed");
sb.Append(" ,DueDate");
sb.Append(" FROM dbo.Bill WITH (NOLOCK)");
if (filter != null)
{
sb.Append(" WHERE BusinessID IN ('" + filter.BusinessIds + "')");
}
sb.Append(" ORDER BY BillID");
return(sb.ToString());
}
/// <summary>
/// 根据过滤条件，返回检索数据的Sql文
/// </summary>
/// <param name="baseFilter"></param>
/// <returns></returns>
protected override string GetSearchSql(BaseFilter baseFilter)
{
ClearLoanReasonSearchFilter filter = baseFilter as ClearLoanReasonSearchFilter;
if (filter == null)
{
return("");
}
StringBuilder sb = new StringBuilder();
sb.Append(" SELECT BillItemID");
sb.Append(" ,BillID");
sb.Append(" ,Subject");
sb.Append(" ,DueDate");
sb.Append(" ,Amount");
sb.Append(" ,DueAmt");
sb.Append(" ,ReceivedAmt");
sb.Append(" ,CreateTime");
sb.Append(" ,FullPaidTime");
sb.Append(" ,Overdue");
sb.Append(" ,SubjectType");
sb.Append(" ,IsCurrent");
sb.Append(" ,IsShelve");
sb.Append(" ,BusinessID");
sb.Append(" ,PenaltyIntAmt");
sb.Append(" FROM dbo.BillItem WITH (NOLOCK)");
sb.Append(" WHERE BillID IN (SELECT BillID FROM dbo.Bill ");
if (filter != null)
{
sb.Append(" WHERE BusinessID IN ('" + filter.BusinessIds + "'))");
}
return(sb.ToString());
}