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);
}
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;
}
public List <SPCodeInfoEntity> FindAllBySPCodeID(SPCodeEntity _sPCodeID)
{
return(this.SelfDataObj.GetList_By_SPCodeID_SPCodeEntity(_sPCodeID));
}
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 <SPCodeInfoEntity> FindAllByOrderByAndFilterAndSPCodeID(string orderByColumnName, bool isDesc, SPCodeEntity _sPCodeID, PageQueryParams pageQueryParams)
{
return(this.SelfDataObj.GetPageList_By_SPCodeID_SPCodeEntity(orderByColumnName, isDesc, _sPCodeID, pageQueryParams));
}
public List <SPRecordEntity> FindAllByCodeID(SPCodeEntity _codeID)
{
return(this.SelfDataObj.GetList_By_CodeID_SPCodeEntity(_codeID));
}
public List <SPClientCodeRelationEntity> FindAllByCodeID(SPCodeEntity _codeID)
{
return(this.SelfDataObj.GetList_By_CodeID_SPCodeEntity(_codeID));
}
public List <SPRecordEntity> GetPageList_By_CodeID_SPCodeEntity(string orderByColumnName, bool isDesc, SPCodeEntity fkentity, PageQueryParams pageQueryParams)
{
NHibernateDynamicQueryGenerator <SPRecordEntity> dynamicQueryGenerator = this.GetNewQueryBuilder();
dynamicQueryGenerator.AddWhereClause(PROPERTY_CODEID.Eq(fkentity));
AddDefaultOrderByToQueryGenerator(orderByColumnName, isDesc, dynamicQueryGenerator);
return(FindListByPageByQueryBuilder(dynamicQueryGenerator, pageQueryParams));
}
public void QuickAddSPChannel(SPChannelEntity channelEntity, string pLinkId, string pMo, string pMobile, string pSpCode, string pCreateDate, string pProvince, string pCity, string pExtend1, string pExtend2, string pExtend3, string pExtend4, string pExtend5, string pExtend6, string pExtend7, string pExtend8, string pExtend9, string pExtend10)
{
if (string.IsNullOrEmpty(pLinkId))
{
throw new ArgumentNullException("pLinkId");
}
if (string.IsNullOrEmpty(pMo))
{
throw new ArgumentNullException("pMo");
}
if (string.IsNullOrEmpty(pLinkId))
{
throw new ArgumentNullException("pMobile");
}
if (string.IsNullOrEmpty(pMo))
{
throw new ArgumentNullException("pSpCode");
}
channelEntity.ChannelStatus = DictionaryConst.Dictionary_ChannelStatus_Run_Key;
this.selfDataObject.Save(channelEntity);
SPSClientEntity defaultClient = GetDefaultClient();
SPCodeEntity defaultCode = SPCodeServiceProxy.NewDefaultCode(channelEntity);
this.DataObjectsContainerIocID.SPCodeDataObjectInstance.Save(defaultCode);
SPClientCodeRelationEntity spClientCodeRelation =
SPClientCodeRelationServiceProxy.NewDefaultCode(defaultClient, defaultCode);
this.DataObjectsContainerIocID.SPClientCodeRelationDataObjectInstance.Save(spClientCodeRelation);
SPChannelParamsEntity cpLinkId = SPChannelParamsServiceProxy.NewChannelParams(channelEntity, pLinkId, DictionaryConst.ParseSPFieldDictionaryKey(DictionaryConst.Dictionary_SPField_LinkID_Key), DictionaryConst.Dictionary_SPField_LinkID_Key, DictionaryConst.Dictionary_ChannelParamsType_Normal_Key);
this.DataObjectsContainerIocID.SPChannelParamsDataObjectInstance.Save(cpLinkId);
SPChannelParamsEntity cpMo = SPChannelParamsServiceProxy.NewChannelParams(channelEntity, pMo, DictionaryConst.ParseSPFieldDictionaryKey(DictionaryConst.Dictionary_SPField_MO_Key), DictionaryConst.Dictionary_SPField_MO_Key, DictionaryConst.Dictionary_ChannelParamsType_Normal_Key);
this.DataObjectsContainerIocID.SPChannelParamsDataObjectInstance.Save(cpMo);
SPChannelParamsEntity cpMobile = SPChannelParamsServiceProxy.NewChannelParams(channelEntity, pMobile, DictionaryConst.ParseSPFieldDictionaryKey(DictionaryConst.Dictionary_SPField_Mobile_Key), DictionaryConst.Dictionary_SPField_Mobile_Key, DictionaryConst.Dictionary_ChannelParamsType_Normal_Key);
this.DataObjectsContainerIocID.SPChannelParamsDataObjectInstance.Save(cpMobile);
SPChannelParamsEntity cpSpCode = SPChannelParamsServiceProxy.NewChannelParams(channelEntity, pSpCode, DictionaryConst.ParseSPFieldDictionaryKey(DictionaryConst.Dictionary_SPField_SpNumber_Key), DictionaryConst.Dictionary_SPField_SpNumber_Key, DictionaryConst.Dictionary_ChannelParamsType_Normal_Key);
this.DataObjectsContainerIocID.SPChannelParamsDataObjectInstance.Save(cpSpCode);
if (!string.IsNullOrEmpty(pCreateDate))
{
SPChannelParamsEntity cpCreateDate = SPChannelParamsServiceProxy.NewChannelParams(channelEntity, pCreateDate, DictionaryConst.ParseSPFieldDictionaryKey(DictionaryConst.Dictionary_SPField_CreateDate_Key), DictionaryConst.Dictionary_SPField_CreateDate_Key, DictionaryConst.Dictionary_ChannelParamsType_Normal_Key);
this.DataObjectsContainerIocID.SPChannelParamsDataObjectInstance.Save(cpCreateDate);
}
if (!string.IsNullOrEmpty(pProvince))
{
SPChannelParamsEntity cpProvince = SPChannelParamsServiceProxy.NewChannelParams(channelEntity, pProvince, DictionaryConst.ParseSPFieldDictionaryKey(DictionaryConst.Dictionary_SPField_Province_Key), DictionaryConst.Dictionary_SPField_Province_Key, DictionaryConst.Dictionary_ChannelParamsType_Normal_Key);
this.DataObjectsContainerIocID.SPChannelParamsDataObjectInstance.Save(cpProvince);
}
if (!string.IsNullOrEmpty(pCity))
{
SPChannelParamsEntity cpCity = SPChannelParamsServiceProxy.NewChannelParams(channelEntity, pCity, DictionaryConst.ParseSPFieldDictionaryKey(DictionaryConst.Dictionary_SPField_City_Key), DictionaryConst.Dictionary_SPField_City_Key, DictionaryConst.Dictionary_ChannelParamsType_Normal_Key);
this.DataObjectsContainerIocID.SPChannelParamsDataObjectInstance.Save(cpCity);
}
if (channelEntity.IsStateReport && !string.IsNullOrEmpty(channelEntity.StateReportParamName))
{
SPChannelParamsEntity cpStateReport = SPChannelParamsServiceProxy.NewChannelParams(channelEntity, channelEntity.StateReportParamName, DictionaryConst.ParseSPFieldDictionaryKey(DictionaryConst.Dictionary_SPField_State_Key), DictionaryConst.Dictionary_SPField_State_Key, DictionaryConst.Dictionary_ChannelParamsType_Normal_Key);
this.DataObjectsContainerIocID.SPChannelParamsDataObjectInstance.Save(cpStateReport);
}
if (!string.IsNullOrEmpty(pExtend1))
{
SPChannelParamsEntity cpExtend1 = SPChannelParamsServiceProxy.NewChannelParams(channelEntity, pExtend1, DictionaryConst.ParseSPFieldDictionaryKey(DictionaryConst.Dictionary_SPField_ExtendField1_Key), DictionaryConst.Dictionary_SPField_ExtendField1_Key, DictionaryConst.Dictionary_ChannelParamsType_Normal_Key);
this.DataObjectsContainerIocID.SPChannelParamsDataObjectInstance.Save(cpExtend1);
}
if (!string.IsNullOrEmpty(pExtend2))
{
SPChannelParamsEntity cpExtend2 = SPChannelParamsServiceProxy.NewChannelParams(channelEntity, pExtend2, DictionaryConst.ParseSPFieldDictionaryKey(DictionaryConst.Dictionary_SPField_ExtendField2_Key), DictionaryConst.Dictionary_SPField_ExtendField2_Key, DictionaryConst.Dictionary_ChannelParamsType_Normal_Key);
this.DataObjectsContainerIocID.SPChannelParamsDataObjectInstance.Save(cpExtend2);
}
if (!string.IsNullOrEmpty(pExtend3))
{
SPChannelParamsEntity cpExtend3 = SPChannelParamsServiceProxy.NewChannelParams(channelEntity, pExtend3, DictionaryConst.ParseSPFieldDictionaryKey(DictionaryConst.Dictionary_SPField_ExtendField3_Key), DictionaryConst.Dictionary_SPField_ExtendField3_Key, DictionaryConst.Dictionary_ChannelParamsType_Normal_Key);
this.DataObjectsContainerIocID.SPChannelParamsDataObjectInstance.Save(cpExtend3);
}
if (!string.IsNullOrEmpty(pExtend4))
{
SPChannelParamsEntity cpExtend4 = SPChannelParamsServiceProxy.NewChannelParams(channelEntity, pExtend4, DictionaryConst.ParseSPFieldDictionaryKey(DictionaryConst.Dictionary_SPField_ExtendField4_Key), DictionaryConst.Dictionary_SPField_ExtendField4_Key, DictionaryConst.Dictionary_ChannelParamsType_Normal_Key);
this.DataObjectsContainerIocID.SPChannelParamsDataObjectInstance.Save(cpExtend4);
}
if (!string.IsNullOrEmpty(pExtend5))
{
SPChannelParamsEntity cpExtend5 = SPChannelParamsServiceProxy.NewChannelParams(channelEntity, pExtend5, DictionaryConst.ParseSPFieldDictionaryKey(DictionaryConst.Dictionary_SPField_ExtendField5_Key), DictionaryConst.Dictionary_SPField_ExtendField5_Key, DictionaryConst.Dictionary_ChannelParamsType_Normal_Key);
this.DataObjectsContainerIocID.SPChannelParamsDataObjectInstance.Save(cpExtend5);
}
if (!string.IsNullOrEmpty(pExtend6))
{
SPChannelParamsEntity cpExtend6 = SPChannelParamsServiceProxy.NewChannelParams(channelEntity, pExtend6, DictionaryConst.ParseSPFieldDictionaryKey(DictionaryConst.Dictionary_SPField_ExtendField6_Key), DictionaryConst.Dictionary_SPField_ExtendField6_Key, DictionaryConst.Dictionary_ChannelParamsType_Normal_Key);
this.DataObjectsContainerIocID.SPChannelParamsDataObjectInstance.Save(cpExtend6);
}
if (!string.IsNullOrEmpty(pExtend7))
{
SPChannelParamsEntity cpExtend7 = SPChannelParamsServiceProxy.NewChannelParams(channelEntity, pExtend7, DictionaryConst.ParseSPFieldDictionaryKey(DictionaryConst.Dictionary_SPField_ExtendField7_Key), DictionaryConst.Dictionary_SPField_ExtendField7_Key, DictionaryConst.Dictionary_ChannelParamsType_Normal_Key);
this.DataObjectsContainerIocID.SPChannelParamsDataObjectInstance.Save(cpExtend7);
}
if (!string.IsNullOrEmpty(pExtend8))
{
SPChannelParamsEntity cpExtend8 = SPChannelParamsServiceProxy.NewChannelParams(channelEntity, pExtend8, DictionaryConst.ParseSPFieldDictionaryKey(DictionaryConst.Dictionary_SPField_ExtendField8_Key), DictionaryConst.Dictionary_SPField_ExtendField8_Key, DictionaryConst.Dictionary_ChannelParamsType_Normal_Key);
this.DataObjectsContainerIocID.SPChannelParamsDataObjectInstance.Save(cpExtend8);
}
if (!string.IsNullOrEmpty(pExtend9))
{
SPChannelParamsEntity cpExtend9 = SPChannelParamsServiceProxy.NewChannelParams(channelEntity, pExtend1, DictionaryConst.ParseSPFieldDictionaryKey(DictionaryConst.Dictionary_SPField_ExtendField9_Key), DictionaryConst.Dictionary_SPField_ExtendField9_Key, DictionaryConst.Dictionary_ChannelParamsType_Normal_Key);
this.DataObjectsContainerIocID.SPChannelParamsDataObjectInstance.Save(cpExtend9);
}
if (!string.IsNullOrEmpty(pExtend10))
{
SPChannelParamsEntity cpExtend10 = SPChannelParamsServiceProxy.NewChannelParams(channelEntity, pExtend10, DictionaryConst.ParseSPFieldDictionaryKey(DictionaryConst.Dictionary_SPField_ExtendField10_Key), DictionaryConst.Dictionary_SPField_ExtendField10_Key, DictionaryConst.Dictionary_ChannelParamsType_Normal_Key);
this.DataObjectsContainerIocID.SPChannelParamsDataObjectInstance.Save(cpExtend10);
}
SPChannelSycnParamsEntity linkidSycnParam = SPChannelSycnParamsServiceProxy.NewSPChannelSycnParams(channelEntity, DictionaryConst.Dictionary_SPField_LinkID_Key, DictionaryConst.ParseSPFieldDictionaryKey(DictionaryConst.Dictionary_SPField_LinkID_Key), DictionaryConst.Dictionary_SPField_LinkID_Key, DictionaryConst.Dictionary_ChannelParamsType_Normal_Key);
this.DataObjectsContainerIocID.SPChannelSycnParamsDataObjectInstance.Save(linkidSycnParam);
SPChannelSycnParamsEntity moSycnParam = SPChannelSycnParamsServiceProxy.NewSPChannelSycnParams(channelEntity, DictionaryConst.Dictionary_SPField_MO_Key, DictionaryConst.ParseSPFieldDictionaryKey(DictionaryConst.Dictionary_SPField_MO_Key), DictionaryConst.Dictionary_SPField_MO_Key, DictionaryConst.Dictionary_ChannelParamsType_Normal_Key);
this.DataObjectsContainerIocID.SPChannelSycnParamsDataObjectInstance.Save(moSycnParam);
SPChannelSycnParamsEntity mobileSycnParam = SPChannelSycnParamsServiceProxy.NewSPChannelSycnParams(channelEntity, DictionaryConst.Dictionary_SPField_Mobile_Key, DictionaryConst.ParseSPFieldDictionaryKey(DictionaryConst.Dictionary_SPField_Mobile_Key), DictionaryConst.Dictionary_SPField_Mobile_Key, DictionaryConst.Dictionary_ChannelParamsType_Normal_Key);
this.DataObjectsContainerIocID.SPChannelSycnParamsDataObjectInstance.Save(mobileSycnParam);
SPChannelSycnParamsEntity spCodeSycnParam = SPChannelSycnParamsServiceProxy.NewSPChannelSycnParams(channelEntity, DictionaryConst.Dictionary_SPField_SpNumber_Key, DictionaryConst.ParseSPFieldDictionaryKey(DictionaryConst.Dictionary_SPField_SpNumber_Key), DictionaryConst.Dictionary_SPField_SpNumber_Key, DictionaryConst.Dictionary_ChannelParamsType_Normal_Key);
this.DataObjectsContainerIocID.SPChannelSycnParamsDataObjectInstance.Save(spCodeSycnParam);
}
