/// <summary>
///查询SEO信息
/// </summary>
/// <param name="callback"></param>
public void SEOQuery(SEOQueryFilter 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/SEOInfo/QuerySEO";
restClient.QueryDynamicData(relativeUrl, filter, callback);
}
public override void OnPageLoad(object sender, EventArgs e)
{
filter = new SEOQueryFilter();
_queryVM = new SEOMetadataQueryVM();
_queryVM.CompanyCode = Newegg.Oversea.Silverlight.ControlPanel.Core.CPApplication.Current.CompanyCode;
_queryVM.ChannelID = "1";
QuerySection.DataContext = _queryVM;
btnStackPanel.DataContext = _queryVM;
facade = new SEOFacade(this);
cbNewsCategory.ItemsSource = EnumConverter.GetKeyValuePairs <ADStatus>(EnumConverter.EnumAppendItemType.All);
base.OnPageLoad(sender, e);
}
private void OnMaintainDialogResult(object sender, ResultEventArgs args)
{
if (args.DialogResult == DialogResultType.OK)
{
filter = _queryVM.ConvertVM <SEOMetadataQueryVM, SEOQueryFilter>();
filter.PageType = ucPageType.PageType;
filter.PageID = ucPageType.PageID;
filterVM = Newegg.Oversea.Silverlight.Utilities.UtilityHelper.DeepClone <SEOQueryFilter>(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(ResNewsInfo.Information_ExportFailed);
return;
}
ColumnSet col = new ColumnSet(this.QueryResultGrid);
filter = _queryVM.ConvertVM <SEOMetadataQueryVM, SEOQueryFilter>();
filter.PageInfo = new ECCentral.QueryFilter.Common.PagingInfo()
{
PageSize = ConstValue.MaxRowCountLimit,
PageIndex = 0,
SortBy = string.Empty
};
facade.ExportExcelFile(filterVM, new ColumnSet[] { col });
}
private void Button_Search_Click(object sender, RoutedEventArgs e)
{
if (lstChannel.SelectedValue == null)
{
Window.Alert(ResNewsInfo.Information_SelectTheChannel, MessageType.Error);
}
else
{
if (ValidationManager.Validate(this.QuerySection))
{
filter = _queryVM.ConvertVM <SEOMetadataQueryVM, SEOQueryFilter>();
filter.PageType = ucPageType.PageType;
filter.PageID = ucPageType.PageID;
filterVM = Newegg.Oversea.Silverlight.Utilities.UtilityHelper.DeepClone <SEOQueryFilter>(filter);
QueryResultGrid.QueryCriteria = this.filter;
QueryResultGrid.Bind();
}
}
}
public DataTable QuerySEO(SEOQueryFilter filter, out int totalCount)
{
PagingInfoEntity pagingEntity = new PagingInfoEntity();
pagingEntity.SortField = filter.PageInfo.SortBy;
pagingEntity.MaximumRows = filter.PageInfo.PageSize;
pagingEntity.StartRowIndex = filter.PageInfo.PageIndex * filter.PageInfo.PageSize;
var cmd = DataCommandManager.CreateCustomDataCommandFromConfig("SEO_GetSEODataList");
using (var sqlBuilder = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, pagingEntity, "B.SysNo DESC"))
{
//sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "ChannelID", DbType.String, "@ChannelID", QueryConditionOperatorType.Equal, filter.ChannelID);
if (filter.PageID == 1 || filter.PageID == 2 || filter.PageID == 3)
{
sqlBuilder.ConditionConstructor.BeginGroupCondition(QueryConditionRelationType.AND);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.OR,
"C3.C1Sysno", DbType.Int32, "@PageID",
QueryConditionOperatorType.Equal, filter.PageID);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.OR,
"C3.C2Sysno", DbType.Int32, "@PageID",
QueryConditionOperatorType.Equal, filter.PageID);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.OR,
"C3.C3Sysno", DbType.Int32, "@PageID",
QueryConditionOperatorType.Equal, filter.PageID);
sqlBuilder.ConditionConstructor.EndGroupCondition();
}
else
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.OR, "cm.PageID", DbType.Int32, "@PageID", QueryConditionOperatorType.Equal, filter.PageID);
}
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"cm.PageType", DbType.Int32, "@PageType",
QueryConditionOperatorType.Equal, filter.PageType);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"cm.PageTitle", DbType.String, "@PageTitle",
QueryConditionOperatorType.Like, filter.PageTitle);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"cm.PageDescription", DbType.String, "@PageDescription",
QueryConditionOperatorType.Like, filter.PageDescription);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"cm.PageKeywords", DbType.String, "@PageKeywords",
QueryConditionOperatorType.Like, filter.PageKeywords);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"cm.CompanyCode", DbType.String, "@CompanyCode",
QueryConditionOperatorType.Equal, filter.CompanyCode);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"cm.Status", DbType.String, "@Status",
QueryConditionOperatorType.Equal, filter.Status);
cmd.CommandText = sqlBuilder.BuildQuerySql();
var dt = cmd.ExecuteDataTable <ECCentral.BizEntity.MKT.ADStatus>("Status");
totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount"));
return(dt);
}
}
public virtual QueryResult QuerySEO(SEOQueryFilter filter)
{
int totalCount;
DataTable dataTable = ObjectFactory <ISEOQueryDA> .Instance.QuerySEO(filter, out totalCount);
List <CodeNamePair> pair = ObjectFactory <PageTypeAppService> .Instance.GetPageType(filter.CompanyCode, filter.ChannelID.ToString(), ModuleType.SEO);
//foreach (DataRow dr in dataTable.Rows)
//{
// foreach (CodeNamePair p in pair)
// {
// if (dr["PageType"].ToString() == p.Code)
// {
// PageResult pr = ObjectFactory<PageTypeAppService>.Instance.GetPage(filter.CompanyCode, filter.ChannelID.ToString(), ModuleType.SEO, p.Code);
// if(pr.PageList!=null && pr.PageList.Count>0)
// dr["PageIDName"] = pr.PageList[0].PageName;
// dr["PageTypeName"] = p.Name;
// //还需要转换页面名称
// }
// }
//}
foreach (DataRow dr in dataTable.Rows)
{
SEOItem item = new SEOItem();
item.PageType = int.Parse(dr["PageType"].ToString());
item.PageID = int.Parse(dr["PageID"].ToString());
item.CompanyCode = dr["CompanyCode"].ToString();
foreach (CodeNamePair p in pair)
{
if (dr["PageType"].ToString() == p.Code)
{
dr["PageTypeName"] = p.Name;
}
}
switch (int.Parse(dr["PageType"].ToString()))
{
case 1:
dr["PageIDName"] = seoItemAppService.GetCNameFromCategory1(item);
break;
case 2:
dr["PageIDName"] = seoItemAppService.GetCNameFromCategory2(item);
break;
case 3:
dr["PageIDName"] = seoItemAppService.GetCNameFromCategory3(item);
break;
case 4:
dr["PageIDName"] = seoItemAppService.GetBrandName(item);
break;
case 5:
dr["PageIDName"] = seoItemAppService.GetSaleAdvertisement(item);
break;
case 9:
dr["PageIDName"] = seoItemAppService.GetBrandNameSpe(item);
break;
case 29:
dr["PageIDName"] = seoItemAppService.GetVendorName(item);
break;
}
}
return(new QueryResult()
{
Data = dataTable,
TotalCount = totalCount
});
}
public void ExportExcelFile(SEOQueryFilter filter, ColumnSet[] columns)
{
string relativeUrl = "/MKTService/SEOInfo/QuerySEO";
restClient.ExportFile(relativeUrl, filter, columns);
}
