/// <summary>
/// 查询自动匹配关键字
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Button_Search_Click(object sender, RoutedEventArgs e)
{
if (ValidationManager.Validate(this.QuerySection))
{
filter = model.ConvertVM <SearchedKeywordsQueryVM, SearchedKeywordsFilter>();
filterVM = Newegg.Oversea.Silverlight.Utilities.UtilityHelper.DeepClone <SearchedKeywordsFilter>(filter);
QueryResultGrid.QueryCriteria = this.filter;
QueryResultGrid.Bind();
}
}
public virtual QueryResult QuerySearchedKeywords(SearchedKeywordsFilter filter)
{
int totalCount;
var dataTable = ObjectFactory <IKeywordQueryDA> .Instance.QuerySearchedKeywords(filter, out totalCount);
return(new QueryResult()
{
Data = dataTable,
TotalCount = totalCount
});
}
/// <summary>
/// 添加自动匹配关键字
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnNewItem_Click(object sender, RoutedEventArgs e)
{
UCAddSearchedKeywords usercontrol = new UCAddSearchedKeywords();
usercontrol.Dialog = Window.ShowDialog(ResKeywords.Title_CreateSearchedKeywords, usercontrol, (obj, args) =>
{
filter = model.ConvertVM <SearchedKeywordsQueryVM, SearchedKeywordsFilter>();
filterVM = Newegg.Oversea.Silverlight.Utilities.UtilityHelper.DeepClone <SearchedKeywordsFilter>(filter);
QueryResultGrid.QueryCriteria = this.filter;
QueryResultGrid.Bind();
});
}
/// <summary>
/// 查询自动匹配关键字
/// </summary>
/// <param name="callback"></param>
public void QuerySearchedKeywords(SearchedKeywordsFilter 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/QuerySearchedKeywords";
restClient.QueryDynamicData(relativeUrl, filter, callback);
}
/// <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 = model.ConvertVM <SearchedKeywordsQueryVM, SearchedKeywordsFilter>();
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 SearchedKeywordsQueryFacade(this);
model = new SearchedKeywordsQueryVM();
filter = new SearchedKeywordsFilter();
model.CompanyCode = Newegg.Oversea.Silverlight.ControlPanel.Core.CPApplication.Current.CompanyCode;
model.ChannelID = "1";
QuerySection.DataContext = model;
facade.LoadEditUsers(Newegg.Oversea.Silverlight.ControlPanel.Core.CPApplication.Current.CompanyCode, (s, args) =>
{
if (args.FaultsHandle())
{
return;
}
List <UserInfo> list = args.Result;
UserInfo user = new UserInfo();
user.UserName = "******";
list.Add(user);
this.comEditUserList.ItemsSource = list;
});
comCreateUserType.ItemsSource = EnumConverter.GetKeyValuePairs <KeywordsOperateUserType>(EnumConverter.EnumAppendItemType.All);
cbShowStatus.ItemsSource = new List <KeyValuePair <ADStatus?, string> >()
{
new KeyValuePair <ADStatus?, string>(null, "--所有--"),
new KeyValuePair <ADStatus?, string>(ADStatus.Active, "展示"),
new KeyValuePair <ADStatus?, string>(ADStatus.Deactive, "屏蔽"),
};
//CodeNamePairHelper.GetList("MKT", "CreateUserType", (s, args) =>
//{
// if (args.FaultsHandle()) return;
// this.CreateUserType.ItemsSource = args.Result;
// this.CreateUserType.SelectedIndex = 0;
//});
//Newegg.Oversea.Silverlight.Controls.Data.DataGridTextColumn status = QueryResultGrid.Columns[3] as Newegg.Oversea.Silverlight.Controls.Data.DataGridTextColumn;
//status.Binding.ConverterParameter = typeof(ADStatus);
btnVoidItem.IsEnabled = false;
btnDeleteItem.IsEnabled = false;
base.OnPageLoad(sender, e);
}
/// <summary>
/// 查询自动匹配关键字
/// </summary>
/// <param name="filter"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public DataTable QuerySearchedKeywords(SearchedKeywordsFilter 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_QuerySearchKeyword");
using (var sqlBuilder = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, pagingEntity, "SysNo DESC"))
{
//sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "ChannelID", DbType.String, "@ChannelID", QueryConditionOperatorType.Equal, filter.ChannelID);
sqlBuilder.ConditionConstructor.AddBetweenCondition(QueryConditionRelationType.AND, "EditDate", DbType.DateTime, "@EditDate", QueryConditionOperatorType.MoreThanOrEqual, QueryConditionOperatorType.LessThanOrEqual, filter.InDateFrom, filter.InDateTo);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "Keywords", DbType.String, "@Keywords", QueryConditionOperatorType.Like, filter.Keywords);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "CreateUserType", DbType.Int32, "@CreateUserType", QueryConditionOperatorType.Like, filter.CreateUserType);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "Status", DbType.String, "@Status", QueryConditionOperatorType.Equal, filter.Status);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "EditUser", DbType.String, "@EditUser", QueryConditionOperatorType.Equal, filter.EditUser);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "CompanyCode", DbType.String, "@CompanyCode", QueryConditionOperatorType.Equal, filter.CompanyCode);
cmd.CommandText = sqlBuilder.BuildQuerySql();
var dt = cmd.ExecuteDataTable <ECCentral.BizEntity.MKT.ADStatus>("Status");
totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount"));
return(dt);
}
}
public void ExportExcelFile(SearchedKeywordsFilter filter, ColumnSet[] columns)
{
string relativeUrl = "/MKTService/KeywordsInfo/QuerySearchedKeywords";
restClient.ExportFile(relativeUrl, filter, columns);
}
