/// <summary>
/// 广告效果BBS查询
/// </summary>
/// <param name="filter"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public DataTable QueryAdvEffectBBS(AdvEffectBBSQueryFilter 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("AdvEffectMonitor_GetAdvBBSList");
using (var sqlBuilder = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, pagingEntity, "B.UserID DESC"))
{
//sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "ChannelID", DbType.String, "@ChannelID", QueryConditionOperatorType.Equal, filter.ChannelID);
if (filter.InDateFrom.HasValue && filter.InDateTo.HasValue && filter.InDateFrom.Equals(filter.InDateTo))
{
filter.InDateTo = filter.InDateTo.Value.AddDays(1);
}
//sqlBuilder.ConditionConstructor.AddBetweenCondition(QueryConditionRelationType.AND, "A.ClickDate", DbType.DateTime, "@ClickDate", QueryConditionOperatorType.MoreThanOrEqual, QueryConditionOperatorType.LessThanOrEqual, filter.InDateFrom, filter.InDateTo);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "A.ClickDate", DbType.DateTime, "@ClickDateFrom", QueryConditionOperatorType.MoreThanOrEqual, filter.InDateFrom);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "A.ClickDate", DbType.DateTime, "@ClickDateTo", QueryConditionOperatorType.LessThan, filter.InDateTo);
cmd.CommandText = sqlBuilder.BuildQuerySql();
var ds = cmd.ExecuteDataSet();
totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount"));
return(ds.Tables[0]);
}
}
public virtual QueryResult QueryAdvEffectBBS(AdvEffectBBSQueryFilter filter)
{
int totalCount;
var dataTable = ObjectFactory <IAdvertiserQueryDA> .Instance.QueryAdvEffectBBS(filter, out totalCount);
return(new QueryResult()
{
Data = dataTable,
TotalCount = totalCount
});
}
private void Button_Search_Click(object sender, RoutedEventArgs e)
{
if (ValidationManager.Validate(this.QuerySection))
{
filter = model.ConvertVM <AdvEffectBBSVM, AdvEffectBBSQueryFilter>();
filterVM = Newegg.Oversea.Silverlight.Utilities.UtilityHelper.DeepClone <AdvEffectBBSQueryFilter>(filter);
QueryResultGrid.QueryCriteria = this.filter;
QueryResultGrid.Bind();
}
}
public override void OnPageLoad(object sender, EventArgs e)
{
model = new AdvEffectBBSVM();
model.ChannelID = "1";
QuerySection.DataContext = model;
facade = new AdvEffectMonitorFacade(this);
filter = new AdvEffectBBSQueryFilter();
model.CompanyCode = Newegg.Oversea.Silverlight.ControlPanel.Core.CPApplication.Current.CompanyCode;
base.OnPageLoad(sender, e);
}
/// <summary>
/// 查询广告效果所涉及的价钱总计
/// </summary>
/// <param name="filter"></param>
/// <param name="callback"></param>
//public void QueryAdvEffectToltalPrice(AdvEffectQueryFilter filter, EventHandler<RestClientEventArgs<dynamic>> callback)
//{
// string relativeUrl = "/MKTService/AdvInfo/QueryAdvEffectToltalPrice";
// restClient.QueryDynamicData(relativeUrl, filter, callback);
//}
/// <summary>
/// 查询广告效果BBS推广
/// </summary>
/// <param name="filter"></param>
/// <param name="callback"></param>
public void QueryAdvEffectBBS(AdvEffectBBSQueryFilter 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/AdvInfo/QueryAdvEffectBBS";
restClient.QueryDynamicData(relativeUrl, filter, callback);
}
private void btnBBSClickReport_Click(object sender, RoutedEventArgs e)
{
if (filterVM == null || this.QueryResultGrid.TotalCount < 1)
{
Window.Alert(ResNewsInfo.Information_ExportFailed);
return;
}
ColumnSet col = new ColumnSet(this.QueryResultGrid);
filter = model.ConvertVM <AdvEffectBBSVM, AdvEffectBBSQueryFilter>();
filter.PageInfo = new ECCentral.QueryFilter.Common.PagingInfo()
{
PageSize = ConstValue.MaxRowCountLimit,
PageIndex = 0,
SortBy = string.Empty
};
facade.ExportEffectBBSExcelFile(filter, new ColumnSet[] { col });
}
/// <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 = model.ConvertVM <AdvEffectBBSVM, AdvEffectBBSQueryFilter>();
filter.PageInfo = new ECCentral.QueryFilter.Common.PagingInfo()
{
PageSize = ConstValue.MaxRowCountLimit,
PageIndex = 0,
SortBy = string.Empty
};
//col.Insert(0, "ProductId", ResRMAReports.Excel_ProductID, 20) .SetWidth("ProductName", 30);
facade.ExportEffectBBSExcelFile(filterVM, new ColumnSet[] { col });
}
public void ExportEffectBBSExcelFile(AdvEffectBBSQueryFilter filter, ColumnSet[] columns)
{
string relativeUrl = "/MKTService/AdvInfo/QueryAdvEffectBBS";
restClient.ExportFile(relativeUrl, filter, columns);
}
