private void Button_Search_Click(object sender, RoutedEventArgs e)
{
if (ValidationManager.Validate(this.QuerySection))
{
filter = queryVM.ConvertVM <HotKeywordsQueryVM, HotKeywordsQueryFilter>();
filter.PageType = ucPageType.PageType;
filter.PageID = ucPageType.PageID;
filterVM = Newegg.Oversea.Silverlight.Utilities.UtilityHelper.DeepClone <HotKeywordsQueryFilter>(filter);
QueryResultGrid.QueryCriteria = this.filter;
QueryResultGrid.Bind();
}
}
/// <summary>
/// 查询热门关键字
/// </summary>
/// <param name="filter"></param>
/// <param name="callback"></param>
public void QueryHotKeywords(HotKeywordsQueryFilter filter, int PageSize, int PageIndex, string SortField, EventHandler <RestClientEventArgs <dynamic> > callback)
{
filter.PageInfo = new ECCentral.QueryFilter.Common.PagingInfo()
{
PageSize = PageSize,
PageIndex = PageIndex,
SortBy = SortField
};
string relativeUrl = "/MKTService/KeywordsInfo/QueryHotKeywords";
restClient.QueryDynamicData(relativeUrl, filter, callback);
}
private void OnMaintainDialogResult(object sender, ResultEventArgs args)
{
if (args.DialogResult == DialogResultType.OK)
{
filter = queryVM.ConvertVM <HotKeywordsQueryVM, HotKeywordsQueryFilter>();
filter.PageType = ucPageType.PageType;
filter.PageID = ucPageType.PageID;
filterVM = Newegg.Oversea.Silverlight.Utilities.UtilityHelper.DeepClone <HotKeywordsQueryFilter>(filter);
QueryResultGrid.QueryCriteria = this.filter;
QueryResultGrid.Bind();
}
}
/// <summary>
/// 数据全部导出
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void QueryResultGrid_ExportAllClick(object sender, EventArgs e)
{
if (filterVM == null || this.QueryResultGrid.TotalCount < 1)
{
Window.Alert(ResKeywords.Information_ExportFailed);
return;
}
ColumnSet col = new ColumnSet(this.QueryResultGrid);
filter = queryVM.ConvertVM <HotKeywordsQueryVM, HotKeywordsQueryFilter>();
filter.PageInfo = new ECCentral.QueryFilter.Common.PagingInfo()
{
PageSize = ConstValue.MaxRowCountLimit,
PageIndex = 0,
SortBy = string.Empty
};
facade.ExportExcelFile(filterVM, new ColumnSet[] { col });
}
public override void OnPageLoad(object sender, EventArgs e)
{
facade = new HotKeywordsQueryFacade(this);
filter = new HotKeywordsQueryFilter();
queryVM = new HotKeywordsQueryVM();
queryVM.CompanyCode = CPApplication.Current.CompanyCode;
queryVM.ChannelID = "1";
QuerySection.DataContext = queryVM;
facade.GetHotKeywordsEditUserList(CPApplication.Current.CompanyCode, (s, args) =>
{
if (args.FaultsHandle())
{
return;
}
BindEditUserList(args.Result);
});
base.OnPageLoad(sender, e);
}
public virtual QueryResult QueryHotKeywords(HotKeywordsQueryFilter filter)
{
int totalCount;
var dataTable = ObjectFactory <IHotKeywordsQueryDA> .Instance.QueryHotKeywords(filter, out totalCount);
List <CodeNamePair> pair = ObjectFactory <PageTypeAppService> .Instance.GetPageType(filter.CompanyCode, filter.ChannelID.ToString(), ModuleType.HotKeywords);
List <ECCategory> category1List = ObjectFactory <IECCategoryQueryDA> .Instance.GetAllECCategory1(filter.CompanyCode, filter.ChannelID.ToString());
List <ECCategory> category3List = ObjectFactory <IECCategoryQueryDA> .Instance.GetAllECCategory3(filter.CompanyCode, filter.ChannelID.ToString());
foreach (DataRow dr in dataTable.Rows)
{
PageTypePresentationType pageTypePresentationType = PageTypeUtil.ResolvePresentationType(ModuleType.HotKeywords, dr["PageType"].ToString());
switch (pageTypePresentationType)
{
case PageTypePresentationType.Category1:
dr["PageIDName"] = category1List.SingleOrDefault(a => a.SysNo.Value == int.Parse(dr["PageID"].ToString())).Name;
break;
case PageTypePresentationType.Category3:
dr["PageIDName"] = category3List.SingleOrDefault(a => a.SysNo.Value == int.Parse(dr["PageID"].ToString())).Name;
break;
default:
PageResult pr = ObjectFactory <PageTypeAppService> .Instance.GetPage(filter.CompanyCode, filter.ChannelID.ToString(), ModuleType.HotKeywords, dr["PageType"].ToString());
if (pr.PageList != null && pr.PageList.Count > 0)
{
dr["PageIDName"] = pr.PageList.SingleOrDefault(a => a.ID.Value == int.Parse(dr["PageID"].ToString())).PageName;
}
break;
}
}
return(new QueryResult()
{
Data = dataTable,
TotalCount = totalCount
});
}
/// <summary>
/// 查询热门关键字
/// </summary>
/// <param name="filter"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public DataTable QueryHotKeywords(HotKeywordsQueryFilter filter, out int totalCount)
{
PagingInfoEntity pagingEntity = new PagingInfoEntity();
if (filter.PageInfo == null)
{
pagingEntity = null;
}
else
{
pagingEntity.SortField = filter.PageInfo.SortBy;
pagingEntity.MaximumRows = filter.PageInfo.PageSize;
pagingEntity.StartRowIndex = filter.PageInfo.PageIndex * filter.PageInfo.PageSize;
}
var cmd = DataCommandManager.CreateCustomDataCommandFromConfig("Keyword_QueryHotKeywordsList");
using (var sqlBuilder = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, pagingEntity, "A.SysNo DESC"))
{
//TODO:添加渠道查询条件
//sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "ChannelID", DbType.String, "@ChannelID", QueryConditionOperatorType.Equal, filter.ChannelID);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "sk.PageType", DbType.Int32, "@PageType", QueryConditionOperatorType.Equal, filter.PageType);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "sk.PageID", DbType.Int32, "@PageID", QueryConditionOperatorType.Equal, filter.PageID);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "sk.Keyword", DbType.String, "@Keyword", QueryConditionOperatorType.Like, filter.Keywords);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "sk.Priority", DbType.Int32, "@Priority", QueryConditionOperatorType.Equal, filter.Priority);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "sk.EditUserSysNo", DbType.Int32, "@EditUserSysNo", QueryConditionOperatorType.Equal, filter.EditUserSysNo);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "sk.IsOnlineShow", DbType.Int32, "@Status", QueryConditionOperatorType.Equal, filter.IsOnlineShow);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "sk.CompanyCode", DbType.String, "@CompanyCode", QueryConditionOperatorType.Equal, filter.CompanyCode);
sqlBuilder.ConditionConstructor.AddBetweenCondition(QueryConditionRelationType.AND, "sk.EditDate", DbType.DateTime, "@EditDate", QueryConditionOperatorType.MoreThanOrEqual, QueryConditionOperatorType.LessThan, filter.EditDateFrom, filter.EditDateTo);
sqlBuilder.ConditionConstructor.AddBetweenCondition(QueryConditionRelationType.AND, "sk.HiddenDate", DbType.DateTime, "@HiddenDate", QueryConditionOperatorType.MoreThanOrEqual, QueryConditionOperatorType.LessThan, filter.InvalidDateFrom, filter.InvalidDateTo);
cmd.CommandText = sqlBuilder.BuildQuerySql();
var dt = cmd.ExecuteDataTable <ECCentral.BizEntity.MKT.NYNStatus>("IsOnlineShow");
totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount"));
return(dt);
}
}
public void ExportExcelFile(HotKeywordsQueryFilter filter, ColumnSet[] columns)
{
string relativeUrl = "/MKTService/KeywordsInfo/QueryHotKeywords";
restClient.ExportFile(relativeUrl, filter, columns);
}
