public override void OnPageLoad(object sender, EventArgs e)
{
facade = new ProductKeywordsQueryFacade(this);
filter = new ProductKeywordsQueryFilter();
model = new ProductKeywordsQueryVM();
model.ChannelID = "1";
model.CompanyCode = Newegg.Oversea.Silverlight.ControlPanel.Core.CPApplication.Current.CompanyCode;
comProductStatus.ItemsSource = EnumConverter.GetKeyValuePairs <ECCentral.BizEntity.IM.ProductStatus>(EnumConverter.EnumAppendItemType.All);
this.DataContext = model;
facade.GetProductKeywordsEditUserList(Newegg.Oversea.Silverlight.ControlPanel.Core.CPApplication.Current.CompanyCode, (s, args) =>
{
if (args.FaultsHandle())
{
return;
}
List <UserInfo> userList = args.Result;
userList.Insert(0, new UserInfo {
SysNo = null, UserName = ResCommonEnum.Enum_All
});
comEditUser.ItemsSource = userList;
});
base.OnPageLoad(sender, e);
}
public virtual QueryResult QueryProductPageKeywords(ProductKeywordsQueryFilter filter)
{
int totalCount;
var dataTable = ObjectFactory <IKeywordQueryDA> .Instance.QueryProductPageKeywords(filter, out totalCount);
return(new QueryResult()
{
Data = dataTable,
TotalCount = totalCount
});
}
/// <summary>
/// 查询产品页面关键字
/// </summary>
/// <param name="filter"></param>
/// <param name="callback"></param>
public void QueryProductPageKeywords(ProductKeywordsQueryFilter 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/QueryProductPageKeywords";
restClient.QueryDynamicData(relativeUrl, filter, callback);
}
private void Button_Search_Click(object sender, RoutedEventArgs e)
{
if (ValidationManager.Validate(this.QuerySection))
{
filter = model.ConvertVM <ProductKeywordsQueryVM, ProductKeywordsQueryFilter>();
filter.PropertySysNo = SelectCategoryProperty.CategoryPropertySysNo;
filter.PropertyValueSysNo = SelectCategoryProperty.PropertyValueSysNo;
filter.InputValue = SelectCategoryProperty.InputValue;
filterVM = Newegg.Oversea.Silverlight.Utilities.UtilityHelper.DeepClone <ProductKeywordsQueryFilter>(filter);
QueryResultGrid.QueryCriteria = this.filter;
QueryResultGrid.Bind();
}
}
/// <summary>
/// 查询产品页面关键字
/// </summary>
/// <param name="filter"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public DataTable QueryProductPageKeywords(ProductKeywordsQueryFilter 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.GetDataCommand("ProductKeywords_QueryProductKeywordsList");
cmd.SetParameterValue("@EditDateTo", filter.EditDateTo);
cmd.SetParameterValue("@EditDateFrom", filter.EditDateFrom);
cmd.SetParameterValue("@ProductMode", filter.ProductMode);
cmd.SetParameterValue("@C1SysNo", filter.Category1SysNo);
cmd.SetParameterValue("@C2SysNo", filter.Category2SysNo);
cmd.SetParameterValue("@C3SysNo", filter.Category3SysNo);
cmd.SetParameterValue("@VendorName", filter.VendorName);
cmd.SetParameterValue("@SelectedManufacturerSysNo", filter.SelectedManufacturerSysNo);
cmd.SetParameterValue("@Keywords", filter.Keywords);
cmd.SetParameterValue("@EditUser", filter.EditUser);
cmd.SetParameterValue("@UserSysNo", filter.PMUserSysNo);
cmd.SetParameterValue("@ProductID", filter.ProductID);
cmd.SetParameterValue("@Status", filter.Status);
cmd.SetParameterValue("@PropertyValueSysNo", filter.PropertyValueSysNo);
cmd.SetParameterValue("@PropertySysNo", filter.PropertySysNo);
cmd.SetParameterValue("@ManualInput", filter.InputValue);
cmd.SetParameterValue("@StartNumber", pagingEntity.StartRowIndex);
cmd.SetParameterValue("@EndNumber", pagingEntity.StartRowIndex + pagingEntity.MaximumRows);
cmd.SetParameterValue("@SortField", pagingEntity.SortField);
DataTable dt = new DataTable();
dt = cmd.ExecuteDataTable();
totalCount = (int)cmd.GetParameterValue("@TotalCount");
return(dt);
}
/// <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 <ProductKeywordsQueryVM, ProductKeywordsQueryFilter>();
filter.PropertySysNo = SelectCategoryProperty.CategoryPropertySysNo;
filter.PropertyValueSysNo = SelectCategoryProperty.PropertyValueSysNo;
filter.InputValue = SelectCategoryProperty.InputValue;
filter.PageInfo = new ECCentral.QueryFilter.Common.PagingInfo()
{
PageSize = ConstValue.MaxRowCountLimit,
PageIndex = 0,
SortBy = string.Empty
};
facade.ExportExcelFile(filterVM, new ColumnSet[] { col });
}
private void QueryResultGrid_LoadingDataSource(object sender, Newegg.Oversea.Silverlight.Controls.Data.LoadingDataEventArgs e)
{
if (QueryResultGrid.QueryCriteria == null)
{
filter = model.ConvertVM <ProductKeywordsQueryVM, ProductKeywordsQueryFilter>();
filter.PropertySysNo = SelectCategoryProperty.CategoryPropertySysNo;
filter.PropertyValueSysNo = SelectCategoryProperty.PropertyValueSysNo;
filter.InputValue = SelectCategoryProperty.InputValue;
filterVM = Newegg.Oversea.Silverlight.Utilities.UtilityHelper.DeepClone <ProductKeywordsQueryFilter>(filter);
QueryResultGrid.QueryCriteria = this.filter;
}
if ((QueryResultGrid.QueryCriteria as ProductKeywordsQueryFilter).EditUser == ResCommonEnum.Enum_All)
{
(QueryResultGrid.QueryCriteria as ProductKeywordsQueryFilter).EditUser = null;
}
facade.QueryProductPageKeywords(QueryResultGrid.QueryCriteria as ProductKeywordsQueryFilter, e.PageSize, e.PageIndex, e.SortField, (s, args) =>
{
if (args.FaultsHandle())
{
return;
}
gridVM = DynamicConverter <ProductKeywordsQueryVM> .ConvertToVMList <List <ProductKeywordsQueryVM> >(args.Result.Rows);
QueryResultGrid.ItemsSource = gridVM;
QueryResultGrid.TotalCount = args.Result.TotalCount;
if (gridVM != null)
{
btnBatchAdd.Visibility = Visibility.Visible;
btnBatchDelete.Visibility = Visibility.Visible;
}
else
{
btnBatchDelete.Visibility = Visibility.Collapsed;
btnBatchAdd.Visibility = Visibility.Collapsed;
}
});
}
public void ExportExcelFile(ProductKeywordsQueryFilter filter, ColumnSet[] columns)
{
string relativeUrl = "/MKTService/KeywordsInfo/QueryProductPageKeywords";
restClient.ExportFile(relativeUrl, filter, columns);
}
