internal static SPDayReportWrapper ConvertEntityToWrapper(SPDayReportEntity entity)
{
if (entity == null)
{
return(null);
}
if (entity.ReportID == 0)
{
return(null);
}
return(new SPDayReportWrapper(entity));
}
public void UpdateRecordAndReport(DayliyReport dayReport, SPClientChannelSettingEntity spClientChannelSettingEntity, int newIntercept)
{
if (newIntercept < 0)
{
return;
}
if (newIntercept > dayReport.TotalCount)
{
return;
}
int newCount = dayReport.InterceptCount - newIntercept;
if (newCount == 0)
{
return;
}
string sql = "";
if (newCount < 0)
{
sql = string.Format("Update SPPaymentInfo set IsIntercept = 1 where ID In (select Top {0} id from dbo.SPPaymentInfo where ChannleClientID = {1} and CreateDate > '{2}' and CreateDate < '{3}' and IsIntercept = 0)", newCount * -1, spClientChannelSettingEntity.Id, dayReport.ReportDate.Date, dayReport.ReportDate.Date.AddDays(1));
}
else
{
sql = string.Format("Update SPPaymentInfo set IsIntercept = 0 where ID In (select Top {0} id from dbo.SPPaymentInfo where ChannleClientID = {1} and CreateDate > '{2}' and CreateDate < '{3}' and IsIntercept = 1)", newCount, spClientChannelSettingEntity.Id, dayReport.ReportDate.Date, dayReport.ReportDate.Date.AddDays(1));
}
this.AdoNetDb.ExecuteNoQuery(sql, CommandType.Text);
if (dayReport.ReportDate.Date < System.DateTime.Now.Date)
{
SPDayReportEntity spDayReportEntity =
this.DataObjectsContainerIocID.SPDayReportDataObjectInstance.FindReportByChannelIDChannelIDAndDate(spClientChannelSettingEntity.ChannelID.Id, spClientChannelSettingEntity.ClinetID.Id, dayReport.ReportDate.Date);
if (spDayReportEntity == null)
{
return;
}
spDayReportEntity.InterceptTotalCount = newIntercept;
spDayReportEntity.DownTotalCount = dayReport.TotalCount - newIntercept;
this.DataObjectsContainerIocID.SPDayReportDataObjectInstance.Update(spDayReportEntity);
}
}
public void ReBulidReport(DateTime date)
{
this.AdoNetDb.ResetAllReportedData(date);
//Get all need to generate report's channle nad client ID.
DataSet dsAllClientChannel = this.AdoNetDb.GetAllClientChannel(date);
DataTable dsDayTotalCount = this.AdoNetDb.GetDayTotalCount(date);
DataTable dsDayDownCount = this.AdoNetDb.GetDayDownCount(date);
DataTable dsDayInterceptCount = this.AdoNetDb.GetDayInterceptCount(date);
DataTable dsDayDownSycnCount = this.AdoNetDb.GetDayDownSycnCount(date);
foreach (DataRow dataRow in dsAllClientChannel.Tables[0].Rows)
{
int channelID = (int)dataRow["ChannelID"];
int clientID = (int)dataRow["ClientID"];
string filterSql = string.Format(" ClientID = {0} and ChannelID = {1} ", clientID, channelID);
int totalCount = this.AdoNetDb.ExecuteScalarFormDataTable("TotalCount", filterSql, dsDayTotalCount);
int downCount = this.AdoNetDb.ExecuteScalarFormDataTable("DownCount", filterSql, dsDayDownCount);
int interceptCount = this.AdoNetDb.ExecuteScalarFormDataTable("InterceptCount", filterSql, dsDayInterceptCount);
int downSycnCount = this.AdoNetDb.ExecuteScalarFormDataTable("DownSycnCount", filterSql, dsDayDownSycnCount);
SPDayReportEntity dayReportEntity = this.SelfDataObj.FindReportByChannelIDChannelIDAndDate(channelID, clientID, date);
bool hasReport = false;
if (dayReportEntity == null)
{
dayReportEntity = new SPDayReportEntity();
dayReportEntity.ChannelID = channelID;
dayReportEntity.ClientID = clientID;
try
{
if (clientID > 0)
{
SPClientEntity spClient =
this.DataObjectsContainerIocID.SPClientDataObjectInstance.Load(clientID);
if (spClient != null)
{
//if(spClient.SPClientGroupID!=null)
//{
// dayReportEntity.ClientGroupID = spClient.SPClientGroupID.Id;
//}
SPClientWrapper clientWrapper = new SPClientWrapper(spClient);
if (clientWrapper.DefaultClientChannelSetting != null)
{
dayReportEntity.ChannelClientID = clientWrapper.DefaultClientChannelSetting.Id;
}
}
}
}
catch (Exception ex)
{
Logger.Error("±¨±í´íÎó£¨SPClientGroupID ChannelClientID£©£º" + ex.Message);
}
}
dayReportEntity.UpTotalCount = totalCount;
dayReportEntity.UpSuccess = 0;
dayReportEntity.InterceptTotalCount = interceptCount;
dayReportEntity.InterceptSuccess = 0;
dayReportEntity.DownTotalCount = downCount;
dayReportEntity.DownSuccess = downSycnCount;
dayReportEntity.ReportDate = new DateTime(date.Year, date.Month, date.Day);
this.SelfDataObj.SaveOrUpdate(dayReportEntity);
}
this.AdoNetDb.ClearAllReportedData(date);
}
internal SPDayReportWrapper(SPDayReportEntity entityObj)
{
entity = entityObj;
}
internal SPDayReportWrapper(SPDayReportEntity entityObj)
{
entity = entityObj;
}
internal static SPDayReportWrapper ConvertEntityToWrapper(SPDayReportEntity entity)
{
if (entity == null)
return null;
if (entity.ReportID == 0)
return null;
return new SPDayReportWrapper(entity);
}
