public List <SPPaymentInfoEntity> FindAllNotSendData(SPChannelEntity channelId, SPClientEntity clientId, DateTime startdate, DateTime endDate, int maxDataCount)
{
var queryBuilder = new NHibernateDynamicQueryGenerator <SPPaymentInfoEntity>();
if (channelId != null)
{
queryBuilder.AddWhereClause(PROPERTY_CHANNELID.Eq(channelId));
}
if (clientId != null)
{
queryBuilder.AddWhereClause(PROPERTY_CLIENTID.Eq(clientId));
}
queryBuilder.AddWhereClause(PROPERTY_CREATEDATE.Ge(startdate.Date));
queryBuilder.AddWhereClause(PROPERTY_CREATEDATE.Lt(endDate.AddDays(1).Date));
queryBuilder.AddWhereClause(PROPERTY_ISINTERCEPT.Eq(false));
queryBuilder.AddWhereClause(PROPERTY_SUCESSSTOSEND.Eq(false));
queryBuilder.SetMaxResults(maxDataCount);
return(this.FindListByQueryBuilder(queryBuilder));
}
public static List <SPRecordWrapper> QueryRecord(SPChannelWrapper channel, SPCodeWrapper code, SPSClientWrapper client, string dataType, DateTime?startDate, DateTime?endDate, List <QueryFilter> filters, string orderByColumnName, bool isDesc)
{
SPChannelEntity channelEntity = null;
if (channel != null)
{
channelEntity = channel.Entity;
}
SPCodeEntity codeEntity = null;
if (code != null)
{
codeEntity = code.Entity;
}
SPSClientEntity clientEntity = null;
if (client != null)
{
clientEntity = client.Entity;
}
return(ConvertToWrapperList(businessProxy.QueryRecord(channelEntity, codeEntity, clientEntity, dataType, startDate, endDate, filters, orderByColumnName, isDesc)));
}
public List<SPClientChannelSettingEntity> FindAllByOrderByAndFilterAndChannelIDAndProvinceAndPort(string sortFieldName, bool isDesc, SPChannelEntity channelEntity, string province, string port, int pageIndex, int pageSize, out int recordCount)
{
NHibernateDynamicQueryGenerator<SPClientChannelSettingEntity> queryGenerator = this.GetNewQueryBuilder();
if (channelEntity!=null)
queryGenerator.AddWhereClause(PROPERTY_CHANNELID.Eq(channelEntity));
queryGenerator.AddWhereClause(Or(PROPERTY_DISABLE.IsNull(), PROPERTY_DISABLE.Eq(false)));
if (!string.IsNullOrEmpty(province))
queryGenerator.AddWhereClause(PROPERTY_ALLOWANDDISABLEAREA.Like(province,MatchMode.Anywhere));
if (!string.IsNullOrEmpty(port))
queryGenerator.AddWhereClause(PROPERTY_CHANNELCODE.Like(port, MatchMode.Anywhere));
AddDefaultOrderByToQueryGenerator(sortFieldName, isDesc, queryGenerator);
queryGenerator.SetFirstResult((pageIndex-1)*pageSize);
queryGenerator.SetMaxResults(pageSize);
List<SPClientChannelSettingEntity> results = FindListByPageByQueryBuilder(queryGenerator, out recordCount);
return results;
}
public List <SPPaymentInfoEntity> FindAllDataTableByOrderByAndCleintIDAndChanneLIDAndDate(int channelId, int clientId, DateTime startDateTime, DateTime enddateTime, DataType dataType, string sortFieldName, bool isDesc, int pageIndex, int pageSize, out int recordCount)
{
SPChannelEntity channelEntity = null;
if (channelId > 0)
{
channelEntity = this.DataObjectsContainerIocID.SPChannelDataObjectInstance.Load(channelId);
}
SPClientEntity clientEntity = null;
if (clientId > 0)
{
clientEntity = this.DataObjectsContainerIocID.SPClientDataObjectInstance.Load(clientId);
}
return(this.SelfDataObj.FindAllDataTableByOrderByAndCleintIDAndChanneLIDAndDate(channelEntity, clientEntity,
startDateTime,
enddateTime, dataType.ToString(),
sortFieldName, isDesc,
pageIndex, pageSize,
out recordCount));
}
public void CloneChannelParams(int channelId, SPClientEntity entity)
{
SPChannelEntity channelEntity = this.DataObjectsContainerIocID.SPChannelDataObjectInstance.Load(channelId);
List <SPChannelParamsEntity> channelParamsEntities =
this.DataObjectsContainerIocID.SPChannelParamsDataObjectInstance.GetAllEnableParams(channelEntity);
List <SPSendClientParamsEntity> sendClientParamsEntities =
this.DataObjectsContainerIocID.SPSendClientParamsDataObjectInstance.GetAllEnableParams(entity);
foreach (SPSendClientParamsEntity spSendClientParamsEntity in sendClientParamsEntities)
{
this.DataObjectsContainerIocID.SPSendClientParamsDataObjectInstance.Delete(spSendClientParamsEntity);
}
foreach (SPChannelParamsEntity channelParamsEntity in channelParamsEntities)
{
SPSendClientParamsEntity spSendClientParamsEntity = new SPSendClientParamsEntity();
spSendClientParamsEntity.ClientID = entity;
spSendClientParamsEntity.Name = channelParamsEntity.Name;
spSendClientParamsEntity.Title = channelParamsEntity.Title;
spSendClientParamsEntity.Description = channelParamsEntity.Description;
spSendClientParamsEntity.IsEnable = channelParamsEntity.IsEnable;
spSendClientParamsEntity.IsRequired = channelParamsEntity.IsRequired;
spSendClientParamsEntity.MappingParams = channelParamsEntity.ParamsMappingName;
this.DataObjectsContainerIocID.SPSendClientParamsDataObjectInstance.Save(spSendClientParamsEntity);
}
}
public List <SPChannelParamsEntity> GetList_By_SPChannelEntity(SPChannelEntity fkentity)
{
NHibernateDynamicQueryGenerator <SPChannelParamsEntity> dynamicQueryGenerator = this.GetNewQueryBuilder();
dynamicQueryGenerator.AddWhereClause(PROPERTY_CHANNELID.Eq(fkentity));
return(this.FindListByQueryBuilder(dynamicQueryGenerator));
}
public List <SPClientChannelSettingEntity> GetSettingByChannel(SPChannelEntity spChannelEntity)
{
NHibernateDynamicQueryGenerator <SPClientChannelSettingEntity> queryGenerator = this.GetNewQueryBuilder();
queryGenerator.AddWhereClause(PROPERTY_CHANNELID.Eq(spChannelEntity));
return(this.FindListByQueryBuilder(queryGenerator));
}
public SPRecordEntity FindByLinkIDAndChannelID(SPChannelEntity spChannelEntity, string linkId)
{
var queryBuilder = new NHibernateDynamicQueryGenerator <SPRecordEntity>();
queryBuilder.AddWhereClause(PROPERTY_CHANNELID.Eq(spChannelEntity));
queryBuilder.AddWhereClause(PROPERTY_LINKID.Eq(linkId));
return(this.FindSingleEntityByQueryBuilder(queryBuilder));
}
public SPRecordEntity FindByLinkIDAndChannelID(SPChannelEntity spChannelEntity, string linkId)
{
var queryBuilder = new NHibernateDynamicQueryGenerator<SPRecordEntity>();
queryBuilder.AddWhereClause(PROPERTY_CHANNELID.Eq(spChannelEntity));
queryBuilder.AddWhereClause(PROPERTY_LINKID.Eq(linkId));
return this.FindSingleEntityByQueryBuilder(queryBuilder);
}
public SPPaymentInfoEntity CheckChannleLinkIDIsExist(SPChannelEntity spChannelEntity, SPPaymentInfoEntity paymentInfo)
{
var queryBuilder = new NHibernateDynamicQueryGenerator <SPPaymentInfoEntity>();
queryBuilder.AddWhereClause(PROPERTY_CHANNELID.Eq(spChannelEntity));
queryBuilder.AddWhereClause(PROPERTY_LINKID.Eq(paymentInfo.Linkid));
return(this.FindSingleEntityByQueryBuilder(queryBuilder));
}
public List <SPPaymentInfoEntity> FindAllByChannelIDAndClientChannelIDAndPhoneList(int channelId, int clientChannelId, List <string> phones)
{
SPChannelEntity spChannelEntity = null;
if (channelId > 0)
{
spChannelEntity = DataObjectsContainerIocID.SPChannelDataObjectInstance.Load(channelId);
}
return(this.SelfDataObj.FindAllByChannelIDAndClientChannelIDAndPhoneList(spChannelEntity, clientChannelId, phones));
}
public List <SPPaymentInfoEntity> FindAllByChannelIDAndClientChannelIDAndPhoneListByOrderBy(int channelId, int clientChannelId, List <string> phones, string sortFieldName, bool isDesc, int pageIndex, int limit, out int recordCount)
{
SPChannelEntity spChannelEntity = null;
if (channelId > 0)
{
spChannelEntity = DataObjectsContainerIocID.SPChannelDataObjectInstance.Load(channelId);
}
return(this.SelfDataObj.FindAllByChannelIDAndClientChannelIDAndPhoneListByOrderBy(spChannelEntity, clientChannelId, phones, sortFieldName, isDesc, pageIndex, limit, out recordCount));
}
public List<SPChannelDefaultClientSycnParamsEntity> GetAllEnableDefaultSendParams(SPChannelEntity spChannelEntity)
{
NHibernateDynamicQueryGenerator<SPChannelDefaultClientSycnParamsEntity> queryGenerator = this.GetNewQueryBuilder();
queryGenerator.AddWhereClause(PROPERTY_CHANNELID.Eq(spChannelEntity));
queryGenerator.AddWhereClause(PROPERTY_ISENABLE.Eq(true));
queryGenerator.AddOrderBy(PROPERTY_ID.Desc());
return this.FindListByQueryBuilder(queryGenerator);
}
public List <SPChannelParamsEntity> GetAllShowParams(SPChannelEntity channle)
{
NHibernateDynamicQueryGenerator <SPChannelParamsEntity> queryGenerator = this.GetNewQueryBuilder();
queryGenerator.AddWhereClause(PROPERTY_CHANNELID.Eq(channle));
queryGenerator.AddWhereClause(PROPERTY_ISENABLE.Eq(true));
queryGenerator.AddOrderBy(PROPERTY_ID.Desc());
return(this.FindListByQueryBuilder(queryGenerator));
}
public List <SPChannelParamsEntity> FindPageDataByChannelID(string orderByColumnName, bool isDesc, int pageIndex, int pageSize, int channleId, out int recordCount)
{
SPChannelEntity channel = null;
if (channleId > 0)
{
channel = this.DataObjectsContainerIocID.SPChannelDataObjectInstance.Load(channleId);
}
return(this.SelfDataObj.FindPageDataByChannelID(orderByColumnName, isDesc, pageIndex, pageSize, channel,
out recordCount));
}
public List<SPCodeInfoEntity> FindAllByOrderByAndFilterAndChannelID(SPChannelEntity channelEntity, List<QueryFilter> queryFilters, string orderByColumnName, bool isDesc)
{
NHibernateDynamicQueryGenerator<SPCodeInfoEntity> queryGenerator = this.GetNewQueryBuilder();
if (channelEntity != null)
queryGenerator.AddWhereClause(PROPERTY_CHANNELID.Eq(channelEntity));
AddDefaultOrderByToQueryGenerator(orderByColumnName, isDesc, queryGenerator);
List<SPCodeInfoEntity> results = FindListByQueryBuilder(queryGenerator);
return results;
}
public List <SPClientChannelSettingEntity> FindAllByOrderByAndFilterAndChannelIDAndCodeAndPort(string sortFieldName, bool isDesc, int channleId, string mo, string port, int pageIndex, int pageSize, out int recordCount)
{
SPChannelEntity channelEntity = null;
if (channleId > 0)
{
channelEntity = this.DataObjectsContainerIocID.SPChannelDataObjectInstance.Load(channleId);
}
return(this.SelfDataObj.FindAllByOrderByAndFilterAndChannelIDAndCodeAndPort(sortFieldName, isDesc,
channelEntity, mo, port,
pageIndex, pageSize,
out recordCount));
}
internal static SPChannelWrapper ConvertEntityToWrapper(SPChannelEntity entity)
{
if (entity == null)
{
return(null);
}
if (entity.Id == 0)
{
return(null);
}
return(new SPChannelWrapper(entity));
}
public static SPChannelSycnParamsEntity NewSPChannelSycnParams(SPChannelEntity channelEntity, string name, string description, string paramsMappingName, string paramsType)
{
SPChannelSycnParamsEntity moSendParamsEntity = new SPChannelSycnParamsEntity();
moSendParamsEntity.ChannelID = channelEntity;
moSendParamsEntity.Name = name;
moSendParamsEntity.Title = name;
moSendParamsEntity.Description = description;
moSendParamsEntity.IsEnable = true;
moSendParamsEntity.ParamsType = paramsType;
moSendParamsEntity.MappingParams = paramsMappingName;
return(moSendParamsEntity);
}
public List <SPCodeInfoEntity> FindAllByOrderByAndFilterAndChannelID(SPChannelEntity channelEntity, List <QueryFilter> queryFilters, string orderByColumnName, bool isDesc)
{
NHibernateDynamicQueryGenerator <SPCodeInfoEntity> queryGenerator = this.GetNewQueryBuilder();
if (channelEntity != null)
{
queryGenerator.AddWhereClause(PROPERTY_CHANNELID.Eq(channelEntity));
}
AddDefaultOrderByToQueryGenerator(orderByColumnName, isDesc, queryGenerator);
List <SPCodeInfoEntity> results = FindListByQueryBuilder(queryGenerator);
return(results);
}
public SPPaymentInfoEntity CheckChannleLinkIDIsExist(SPChannelEntity spChannelEntity, SPPaymentInfoEntity paymentInfo, List <string> uniqueKeyNames)
{
var queryBuilder = new NHibernateDynamicQueryGenerator <SPPaymentInfoEntity>();
queryBuilder.AddWhereClause(PROPERTY_CHANNELID.Eq(spChannelEntity));
queryBuilder.AddWhereClause(PROPERTY_LINKID.Eq(paymentInfo.Linkid));
if (uniqueKeyNames.Contains("mobile"))
{
queryBuilder.AddWhereClause(PROPERTY_MOBILENUMBER.Eq(paymentInfo.MobileNumber));
}
return(this.FindSingleEntityByQueryBuilder(queryBuilder));
}
public static SPChannelParamsEntity NewChannelParams(SPChannelEntity channelEntity, string name, string description, string paramsMappingName, string paramsType)
{
SPChannelParamsEntity paramsEntity = new SPChannelParamsEntity();
paramsEntity.ChannelID = channelEntity;
paramsEntity.Name = name;
paramsEntity.Title = name;
paramsEntity.Description = description;
paramsEntity.IsEnable = true;
paramsEntity.IsRequired = true;
paramsEntity.ParamsMappingName = paramsMappingName;
paramsEntity.ParamsType = paramsType;
return(paramsEntity);
}
private SPChannelParamsEntity CreateNewChannelParams(SPChannelEntity channelEntity, string paramName, string paramDesciption, string paramsMappingName)
{
SPChannelParamsEntity paramsEntity = new SPChannelParamsEntity();
paramsEntity.ChannelID = channelEntity;
paramsEntity.Name = paramName;
paramsEntity.Title = paramName;
paramsEntity.Description = paramDesciption;
paramsEntity.IsEnable = true;
paramsEntity.IsRequired = true;
paramsEntity.IsUnique = false;
paramsEntity.ParamsMappingName = paramsMappingName;
paramsEntity.ParamsType = "普通参数";
return(paramsEntity);
}
public List<SPCodeInfoEntity> FindAllByOrderByAndFilterAndChannelID(SPChannelEntity channelEntity, List<QueryFilter> filters, string orderByColumnName, bool isDesc, int pageIndex, int pageSize, out int recordCount)
{
NHibernateDynamicQueryGenerator<SPCodeInfoEntity> queryGenerator = this.GetNewQueryBuilder();
if (channelEntity != null)
queryGenerator.AddWhereClause(PROPERTY_CHANNELID.Eq(channelEntity));
AddDefaultOrderByToQueryGenerator(orderByColumnName, isDesc, queryGenerator);
queryGenerator.SetFirstResult((pageIndex - 1) * pageSize);
queryGenerator.SetMaxResults(pageSize);
List<SPCodeInfoEntity> results = FindListByPageByQueryBuilder(queryGenerator, out recordCount);
return results;
}
public List <SPClientEntity> FindByChannelID(int cid)
{
SPChannelEntity channelEntity = this.DataObjectsContainerIocID.SPChannelDataObjectInstance.Load(cid);
List <SPClientChannelSettingEntity> settings = this.DataObjectsContainerIocID.SPClientChannelSettingDataObjectInstance.GetSettingByChannel(channelEntity);
List <SPClientEntity> clientEntities = new List <SPClientEntity>();
foreach (SPClientChannelSettingEntity spClientEntity in settings)
{
if (!clientEntities.Contains(spClientEntity.ClinetID))
{
clientEntities.Add(spClientEntity.ClinetID);
}
}
return(clientEntities);
}
public List <SPCodeEntity> FindAllByChannelIDAndClientIDAndMoAndSpNumber(int?channelId, int?clientId, string mo, string spcode)
{
SPChannelEntity channel = null;
if (channelId.HasValue)
{
channel = this.DataObjectsContainerIocID.SPChannelDataObjectInstance.Load(channelId.Value);
}
SPSClientEntity client = null;
if (clientId.HasValue)
{
client = this.DataObjectsContainerIocID.SPSClientDataObjectInstance.Load(clientId.Value);
}
return
(this.DataObjectsContainerIocID.SPCodeDataObjectInstance.FindAllByChannelIDAndClientIDAndMoAndSpNumber(
channel, client, mo, spcode));
}
public List <SPCodeInfoEntity> FindAllByOrderByAndFilterAndChannelID(SPChannelEntity channelEntity, List <QueryFilter> filters, string orderByColumnName, bool isDesc, int pageIndex, int pageSize, out int recordCount)
{
NHibernateDynamicQueryGenerator <SPCodeInfoEntity> queryGenerator = this.GetNewQueryBuilder();
if (channelEntity != null)
{
queryGenerator.AddWhereClause(PROPERTY_CHANNELID.Eq(channelEntity));
}
AddDefaultOrderByToQueryGenerator(orderByColumnName, isDesc, queryGenerator);
queryGenerator.SetFirstResult((pageIndex - 1) * pageSize);
queryGenerator.SetMaxResults(pageSize);
List <SPCodeInfoEntity> results = FindListByPageByQueryBuilder(queryGenerator, out recordCount);
return(results);
}
public List <SPPaymentInfoEntity> FindAllNotSendData(int channelId, int clientId, DateTime startdate, DateTime endDate, int maxDataCount)
{
SPChannelEntity channelEntity = null;
if (channelId > 0)
{
channelEntity = this.DataObjectsContainerIocID.SPChannelDataObjectInstance.Load(channelId);
}
SPClientEntity clientEntity = null;
if (clientId > 0)
{
clientEntity = this.DataObjectsContainerIocID.SPClientDataObjectInstance.Load(clientId);
}
return(this.SelfDataObj.FindAllNotSendData(channelEntity, clientEntity, startdate, endDate, maxDataCount));
}
public static SPCodeEntity NewDefaultCode(SPChannelEntity channelEntity)
{
SPCodeEntity code = new SPCodeEntity();
code.Name = channelEntity.Name + "ĬÈϱàÂë";
code.Description = channelEntity.Name + "ĬÈϱàÂë";
code.ChannelID = channelEntity;
code.OrderIndex = 0;
code.Code = channelEntity.Code + "DefaultCode";
code.Mo = "";
code.MOLength = code.Mo.Length;
code.MOType = DictionaryConst.Dictionary_CodeType_CodeDefault_Key;
code.HasFilters = false;
code.SPCodeType = DictionaryConst.Dictionary_CodeType_CodeDefault_Key;
code.SPCode = "";
code.SPCodeLength = code.SPCode.Length;
code.IsDiable = false;
//code.DayLimit = "";
//code.MonthLimit = "";
//code.SendText = "";
code.Price = 0;
return(code);
}
public List <SPCodeEntity> FindAllByChannelIDAndClientIDAndMoAndSpNumber(SPChannelEntity channel, SPSClientEntity client, string mo, string spcode)
{
NHibernateDynamicQueryGenerator <SPCodeEntity> dynamicQueryGenerator = this.GetNewQueryBuilder();
if (channel != null)
{
dynamicQueryGenerator.AddWhereClause(SPCodeDataObject.PROPERTY_CHANNELID.Eq(channel));
}
if (client != null)
{
dynamicQueryGenerator.AddWhereClause(SPClientCodeRelationDataObject.Query_ClientAssignedCode(client, PROPERTY_ID.CriterionProperty));
}
if (!string.IsNullOrEmpty(mo))
{
dynamicQueryGenerator.AddWhereClause(SPCodeDataObject.PROPERTY_MO.Like(mo, MatchMode.Anywhere));
}
if (!string.IsNullOrEmpty(spcode))
{
dynamicQueryGenerator.AddWhereClause(SPCodeDataObject.PROPERTY_SPCODE.Like(spcode, MatchMode.Anywhere));
}
dynamicQueryGenerator.AddWhereClause(
Not(SPCodeDataObject.PROPERTY_MOTYPE.Eq(DictionaryConst.Dictionary_CodeType_CodeDefault_Key)));
dynamicQueryGenerator.AddOrderBy(PROPERTY_MOTYPE.Asc());
dynamicQueryGenerator.AddOrderBy(PROPERTY_MO.Asc());
dynamicQueryGenerator.AddOrderBy(PROPERTY_SPCODE.Asc());
return(this.FindListByQueryBuilder(dynamicQueryGenerator));
}
/// <summary>
/// 全构造函数
/// </summary>
public SPPaymentInfoEntity( int id, string mobileNumber, SPChannelEntity channelID, SPClientEntity clientID, string message, bool? isIntercept, DateTime? createDate, int? clientGroupID, string cpid, string mid, string port, string ywid, string linkid, string dest, string price, string ip, bool? sucesssToSend, string extendField1, string extendField2, string extendField3, string extendField4, string extendField5, string extendField6, string extendField7, string extendField8, string mobileOperators, string requestContent, string city, string province, bool? isTestData, int? channleClientID, bool? isSycnData, string sSycnDataUrl, int? sycnRetryTimes, bool isReport)
{
_id = id;
_mobileNumber = mobileNumber;
_channelID = channelID;
_clientID = clientID;
_message = message;
_isIntercept = isIntercept;
_createDate = createDate;
_clientGroupID = clientGroupID;
_cpid = cpid;
_mid = mid;
_port = port;
_ywid = ywid;
_linkid = linkid;
_dest = dest;
_price = price;
_ip = ip;
_sucesssToSend = sucesssToSend;
_extendField1 = extendField1;
_extendField2 = extendField2;
_extendField3 = extendField3;
_extendField4 = extendField4;
_extendField5 = extendField5;
_extendField6 = extendField6;
_extendField7 = extendField7;
_extendField8 = extendField8;
_mobileOperators = mobileOperators;
_requestContent = requestContent;
_city = city;
_province = province;
_isTestData = isTestData;
_channleClientID = channleClientID;
_isSycnData = isSycnData;
_sSycnDataUrl = sSycnDataUrl;
_sycnRetryTimes = sycnRetryTimes;
_isReport = isReport;
}
public List <SPMonitoringRequestEntity> FindAllByChannelID(SPChannelEntity _channelID)
{
return(this.SelfDataObj.GetList_By_ChannelID_SPChannelEntity(_channelID));
}
public List <SPMonitoringRequestEntity> FindAllByOrderByAndFilterAndChannelID(string orderByColumnName, bool isDesc, SPChannelEntity _channelID, PageQueryParams pageQueryParams)
{
return(this.SelfDataObj.GetPageList_By_ChannelID_SPChannelEntity(orderByColumnName, isDesc, _channelID, pageQueryParams));
}
public List <SPPaymentInfoEntity> FindAllDataTableByOrderByAndCleintIDAndChanneLIDAndDate(SPChannelEntity channelId, SPClientEntity clientId, DateTime startDateTime, DateTime enddateTime, string dataType, string sortFieldName, bool isDesc, int pageIndex, int pageSize, out int recordCount)
{
var queryBuilder = new NHibernateDynamicQueryGenerator <SPPaymentInfoEntity>();
if (channelId != null)
{
queryBuilder.AddWhereClause(PROPERTY_CHANNELID.Eq(channelId));
}
if (clientId != null)
{
queryBuilder.AddWhereClause(PROPERTY_CLIENTID.Eq(clientId));
}
if (startDateTime == DateTime.MinValue)
{
startDateTime = DateTime.Now;
}
if (enddateTime == DateTime.MinValue)
{
enddateTime = DateTime.Now;
}
queryBuilder.AddWhereClause(PROPERTY_CREATEDATE.Ge(startDateTime.Date));
queryBuilder.AddWhereClause(PROPERTY_CREATEDATE.Lt(enddateTime.AddDays(1).Date));
switch (dataType)
{
case "All":
break;
case "Intercept":
queryBuilder.AddWhereClause(PROPERTY_ISINTERCEPT.Eq(true));
break;
case "Down":
queryBuilder.AddWhereClause(PROPERTY_ISINTERCEPT.Eq(false));
break;
case "DownSycn":
queryBuilder.AddWhereClause(PROPERTY_ISINTERCEPT.Eq(false));
queryBuilder.AddWhereClause(PROPERTY_SUCESSSTOSEND.Eq(true));
break;
}
AddDefaultOrderByToQueryGenerator(sortFieldName, isDesc, queryBuilder);
queryBuilder.SetFirstResult((pageIndex - 1) * pageSize);
queryBuilder.SetMaxResults(pageSize);
return(FindListByPageByQueryBuilder(queryBuilder, out recordCount));
}
private NHibernateDynamicQueryGenerator<SPRecordEntity> BuilderQueryGenerator(SPChannelEntity channel, SPCodeEntity code,
SPSClientEntity client, string dataType,
DateTime? startDate, DateTime? endDate, List<QueryFilter> filters,
string orderByColumnName, bool isDesc)
{
var queryBuilder = new NHibernateDynamicQueryGenerator<SPRecordEntity>();
if (channel!=null)
queryBuilder.AddWhereClause(PROPERTY_CHANNELID.Eq(channel));
if (code != null)
queryBuilder.AddWhereClause(PROPERTY_CODEID.Eq(code));
if (client != null)
queryBuilder.AddWhereClause(PROPERTY_CLIENTID.Eq(client));
DayReportType reportType = (DayReportType) Enum.Parse(typeof (DayReportType), dataType);
SetReportTypeFilter(queryBuilder, reportType);
if (startDate != null)
queryBuilder.AddWhereClause(PROPERTY_CREATEDATE.Ge(startDate.Value.Date));
if (endDate != null)
queryBuilder.AddWhereClause(PROPERTY_CREATEDATE.Lt(endDate.Value.Date.AddDays(1)));
AddQueryFiltersToQueryGenerator(filters, queryBuilder);
AddDefaultOrderByToQueryGenerator(orderByColumnName, isDesc, queryBuilder);
return queryBuilder;
}
/// <summary>
/// 默认构造函数
/// </summary>
public SPPaymentInfoEntity()
{
_id = 0;
_mobileNumber = null;
_channelID = null;
_clientID = null;
_message = null;
_isIntercept = null;
_createDate = null;
_clientGroupID = null;
_cpid = null;
_mid = null;
_port = String.Empty;
_ywid = null;
_linkid = null;
_dest = null;
_price = null;
_ip = null;
_sucesssToSend = null;
_extendField1 = null;
_extendField2 = null;
_extendField3 = null;
_extendField4 = null;
_extendField5 = null;
_extendField6 = null;
_extendField7 = null;
_extendField8 = null;
_mobileOperators = null;
_requestContent = null;
_city = null;
_province = null;
_isTestData = null;
_channleClientID = null;
_isSycnData = null;
_sSycnDataUrl = null;
_sycnRetryTimes = 0;
_isReport = false;
}
public List<SPClientChannelSettingEntity> GetSettingByChannel(SPChannelEntity spChannelEntity)
{
NHibernateDynamicQueryGenerator<SPClientChannelSettingEntity> queryGenerator = this.GetNewQueryBuilder();
queryGenerator.AddWhereClause(PROPERTY_CHANNELID.Eq(spChannelEntity));
return this.FindListByQueryBuilder(queryGenerator);
}
public List<SPRecordEntity> QueryRecordByPage(SPChannelEntity channel, SPCodeEntity code, SPSClientEntity client, string dataType, DateTime? startDate, DateTime? endDate, List<QueryFilter> filters, string orderByColumnName, bool isDesc)
{
var queryBuilder = BuilderQueryGenerator(channel, code, client, dataType, startDate, endDate, filters, orderByColumnName, isDesc);
return FindListByQueryBuilder(queryBuilder);
}
public List <SPPaymentInfoEntity> FindAllByChannelIDAndClientChannelIDAndPhoneList(SPChannelEntity channelId, int clientChannelId, List <string> phones)
{
var queryBuilder = new NHibernateDynamicQueryGenerator <SPPaymentInfoEntity>();
if (channelId != null)
{
queryBuilder.AddWhereClause(PROPERTY_CHANNELID.Eq(channelId));
}
if (clientChannelId > 0)
{
queryBuilder.AddWhereClause(PROPERTY_CHANNLECLIENTID.Eq(clientChannelId));
}
if (phones != null && phones.Count > 0)
{
queryBuilder.AddWhereClause(PROPERTY_MOBILENUMBER.In(phones));
}
queryBuilder.AddOrderBy(PROPERTY_ID.Asc());
return(FindListByQueryBuilder(queryBuilder));
}
public List<SPMonitoringRequestEntity> FindAllByChannelID(SPChannelEntity _channelID)
{
return this.SelfDataObj.GetList_By_ChannelID_SPChannelEntity(_channelID);
}
public List <SPChannelParamsEntity> GetPageList_By_SPChannelEntity(string orderByColumnName, bool isDesc, int pageIndex, int pageSize, SPChannelEntity fkentity, out int recordCount)
{
NHibernateDynamicQueryGenerator <SPChannelParamsEntity> dynamicQueryGenerator = this.GetNewQueryBuilder();
dynamicQueryGenerator.AddWhereClause(PROPERTY_CHANNELID.Eq(fkentity));
AddDefaultOrderByToQueryGenerator(orderByColumnName, isDesc, dynamicQueryGenerator);
dynamicQueryGenerator.SetFirstResult((pageIndex - 1) * pageSize);
dynamicQueryGenerator.SetMaxResults(pageSize);
return(FindListByPageByQueryBuilder(dynamicQueryGenerator, out recordCount));
}
public List<SPMonitoringRequestEntity> FindAllByOrderByAndFilterAndChannelID(string orderByColumnName, bool isDesc, SPChannelEntity _channelID, PageQueryParams pageQueryParams)
{
return this.SelfDataObj.GetPageList_By_ChannelID_SPChannelEntity(orderByColumnName, isDesc,_channelID, pageQueryParams);
}
