public List <SPDayReportEntity> CaculateReport(DateTime reportDate, SPSClientEntity clientEntity)
{
DataTable dtDown = AdoNetDb.CaculateReport(reportDate, DayReportType.Down, clientEntity);
DataTable dtDownNotSycn = AdoNetDb.CaculateReport(reportDate, DayReportType.DownNotSycn, clientEntity);
DataTable dtDownSycnFailed = AdoNetDb.CaculateReport(reportDate, DayReportType.DownSycnFailed, clientEntity);
DataTable dtDownSycnSuccess = AdoNetDb.CaculateReport(reportDate, DayReportType.DownSycnSuccess, clientEntity);
List <SPDayReportEntity> spDayReportEntities = new List <SPDayReportEntity>();
foreach (DataRow dataRow in dtDown.Rows)
{
int channelID = (int)dataRow["ChannelID"];
int clientID = clientEntity.Id;
int codeID = (int)dataRow["CodeID"];
SPDayReportEntity spDayReport = new SPDayReportEntity();
spDayReport.ReportDate = reportDate.Date;
spDayReport.ChannelID = this.DataObjectsContainerIocID.SPChannelDataObjectInstance.Load(channelID);
spDayReport.ClientID = this.DataObjectsContainerIocID.SPSClientDataObjectInstance.Load(clientID);
spDayReport.CodeID = this.DataObjectsContainerIocID.SPCodeDataObjectInstance.Load(codeID);
spDayReport.DownTotalCount = FindCountInDataTable(dtDown, channelID, codeID);
spDayReport.DownSycnSuccess = FindCountInDataTable(dtDownSycnSuccess, channelID, codeID);
spDayReport.DownNotSycn = FindCountInDataTable(dtDownNotSycn, channelID, codeID);
spDayReport.DownSycnFailed = FindCountInDataTable(dtDownSycnFailed, channelID, codeID);
spDayReportEntities.Add(spDayReport);
}
return(spDayReportEntities);
}
public DataSet QueryChannelProvinceReport(DateTime?startDate, DateTime?endDate, int?channelId, int?codeId)
{
return(AdoNetDb.QueryChannelProvinceReport(startDate, endDate, channelId, codeId));
}
public DataSet QueryClientProvinceReport(DateTime?startDate, DateTime?endDate, int?clientId, int?codeId)
{
return(AdoNetDb.QueryClientProvinceReport(startDate, endDate, clientId, codeId));
}
public int CacultePaymentCountNotInProvince(DateTime dateTime, int clientChannelId, List <string> notInprovinces)
{
return(AdoNetDb.CacultePaymentCountNotInProvince(dateTime, clientChannelId, notInprovinces));
}
public DataSet QueryRecordProvine(DateTime?startDate, DateTime?endDate, DayReportType dayReportType, int?channelId, int?codeID, int?clientID)
{
return(AdoNetDb.QueryRecordProvine(startDate, endDate, dayReportType, channelId, codeID, clientID));
}
public int QueryPhoneCount(List <int> clientChannelIds, DateTime startDate, DateTime endDate, bool afterIntercept)
{
return(AdoNetDb.CacultePhoneCount(startDate, endDate, clientChannelIds, afterIntercept));
}
public int CacultePaymentCount(DateTime dateTime, int clientChannelId, string province)
{
return(AdoNetDb.CacultePaymentCount(dateTime, clientChannelId, province));
}
public int CacultePaymentCount(DateTime dateTime, int clientChannelId)
{
return(AdoNetDb.CacultePaymentCount(dateTime, clientChannelId));
}
public int CaculteMonthPhoneCount(DateTime dateTime, int clientChannelId, string mobileNumber)
{
return(AdoNetDb.CaculteMonthPhoneCount(dateTime, clientChannelId, mobileNumber));
}
public decimal CaculteActualInterceptRate(SPClientChannelSettingEntity entity, DateTime date)
{
return(AdoNetDb.CaculteActualInterceptRate(entity.Id, date));
}
public DataTable GetClientMobileCount(int spClientId, DateTime startDate, DateTime endDate)
{
return(AdoNetDb.GetClientMobileCount(spClientId, startDate, endDate));
}
public int FindAllPaymentCountByDateAndType(DateTime startDate, DateTime endDate, int channleClientID, string dataType)
{
return(AdoNetDb.FindAllPaymentCountByDateAndType(startDate, endDate, channleClientID, dataType));
}
public DataSet FindAllPaymentIDByDateAndType(DateTime startDate, DateTime endDate, int channleClientID, string dataType, int limit)
{
return(AdoNetDb.FindAllPaymentIDByDateAndType(startDate, endDate, channleClientID, dataType, limit));
}
public void UpdateUrlSuccessSend(int id, string url)
{
AdoNetDb.UpdateUrlSuccessSend(id, url);
}