private void btnSearch_Click(object sender, RoutedEventArgs e)
{
if (ValidationManager.Validate(this.QuerySection))
{
filter = model.ConvertVM <NewsAdvReplyQueryVM, NewsAdvReplyQueryFilter>();
filterVM = Newegg.Oversea.Silverlight.Utilities.UtilityHelper.DeepClone <NewsAdvReplyQueryFilter>(filter);
QueryResultGrid.QueryCriteria = this.filter;
QueryResultGrid.Bind();
}
}
public virtual QueryResult QueryNewsAdvReply(NewsAdvReplyQueryFilter msg)
{
int totalCount;
var dataTable = ObjectFactory <INewsQueryDA> .Instance.QueryNewsAdvReply(msg, out totalCount);
return(new QueryResult()
{
Data = dataTable,
TotalCount = totalCount
});
}
/// <summary>
/// 查询公告及促销评论
/// </summary>
/// <param name="callback"></param>
public void QueryNewsAdvReply(NewsAdvReplyQueryFilter 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/NewsInfo/QueryNewsAdvReply";
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(ResNewsInfo.Information_ExportFailed);
return;
}
ColumnSet col = new ColumnSet(this.QueryResultGrid);
filter = model.ConvertVM <NewsAdvReplyQueryVM, NewsAdvReplyQueryFilter>();
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 NewsAdvReplyQueryFacade(this);
model = new NewsAdvReplyQueryVM();
model.ChannelID = "1";
QuerySection.DataContext = model;
filter = new NewsAdvReplyQueryFilter();
model.CompanyCode = Newegg.Oversea.Silverlight.ControlPanel.Core.CPApplication.Current.CompanyCode;
showStatus.ItemsSource = EnumConverter.GetKeyValuePairs <ECCentral.BizEntity.MKT.NewsAdvReplyStatus>(EnumConverter.EnumAppendItemType.All);
comIsUploadImage.ItemsSource = EnumConverter.GetKeyValuePairs <ECCentral.BizEntity.MKT.NYNStatus>(EnumConverter.EnumAppendItemType.All);
CodeNamePairHelper.GetList("MKT", "CommentsCategory", CodeNamePairAppendItemType.All, (obj, args) =>
{
if (args.FaultsHandle())
{
return;
}
comCommentCategory.ItemsSource = args.Result;
});
facade.GetNewAdvReplyCreateUsers((obj, args) =>
{
if (args.FaultsHandle())
{
return;
}
BizEntity.Common.UserInfo select = new BizEntity.Common.UserInfo();
select.UserID = "0";
select.UserName = ECCentral.BizEntity.Enum.Resources.ResCommonEnum.Enum_All;
List <BizEntity.Common.UserInfo> source = args.Result;
source.Add(select);
lastEditUsers.ItemsSource = source;
});
showStatus.SelectedIndex = 0;
lastEditUsers.SelectedIndex = 0;
comCommentCategory.SelectedIndex = 0;
comIsUploadImage.SelectedIndex = 0;
base.OnPageLoad(sender, e);
}
public void ExportExcelFile(NewsAdvReplyQueryFilter filter, ColumnSet[] columns)
{
string relativeUrl = "/MKTService/NewsInfo/QueryNewsAdvReply";
restClient.ExportFile(relativeUrl, filter, columns);
}
/// <summary>
/// 查询公告及促销评论
/// </summary>
/// <param name="filter"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public DataTable QueryNewsAdvReply(NewsAdvReplyQueryFilter 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("News_QueryNewsAdvReplyList");
using (var sqlBuilder = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, pagingEntity, "N.SysNo DESC"))
{
//sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "ChannelID", DbType.String, "@ChannelID", QueryConditionOperatorType.Equal, filter.ChannelID);
sqlBuilder.ConditionConstructor.AddBetweenCondition(QueryConditionRelationType.AND, "N.CreateDate", DbType.DateTime, "@CreateDate", QueryConditionOperatorType.MoreThanOrEqual, QueryConditionOperatorType.LessThanOrEqual, filter.InDateFrom, filter.InDateTo);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "N.CustomerSysNo", DbType.Int32, "@CustomerSysNo", QueryConditionOperatorType.Equal, filter.CustomerSysNo);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "N.LastEditUserSysNo", DbType.Int32, "@LastEditUserSysNo", QueryConditionOperatorType.Like, filter.LastEditUserSysNo);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "N.ReferenceType", DbType.Int32, "@ReferenceType", QueryConditionOperatorType.Equal, filter.ReferenceType);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "N.ReferenceSysNo", DbType.Int32, "@ReferenceSysNo", QueryConditionOperatorType.Equal, filter.ReferenceSysNo);
//sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "CI.LastEditUserID", DbType.String, "@LastEditUserID", QueryConditionOperatorType.Like, filter.LastEditUserID);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "SI.DisplayName", DbType.String, "@LastEditUserID", QueryConditionOperatorType.Like, filter.LastEditUserID);
if (filter.IsUploadImage != null)
{
if (filter.IsUploadImage == ECCentral.BizEntity.MKT.NYNStatus.Yes)
{
sqlBuilder.ConditionConstructor.AddCustomCondition(QueryConditionRelationType.AND, "N.Image is not null");
}
//sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "N.Image", DbType.Int32, "@Image", QueryConditionOperatorType.IsNotNull, "");
else
{
sqlBuilder.ConditionConstructor.AddCustomCondition(QueryConditionRelationType.AND, "N.Image is null");
}
//sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "N.[Image]", DbType.String, "@Image", filter.IsUploadImage == ECCentral.BizEntity.MKT.NYNStatus.Yes?QueryConditionOperatorType.IsNotNull:QueryConditionOperatorType.IsNull,);
}
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "N.ReplyContent", DbType.String, "@ReplyContent", QueryConditionOperatorType.Like, filter.ReplyContent);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "N.SysNo", DbType.Int32, "@SysNo", QueryConditionOperatorType.Like, filter.SysNo);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "N.Status", DbType.Int32, "@Status", QueryConditionOperatorType.Equal, filter.Status);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "N.CompanyCode", DbType.String, "@CompanyCode", QueryConditionOperatorType.Equal, filter.CompanyCode);
cmd.CommandText = sqlBuilder.BuildQuerySql();
EnumColumnList enumList = new EnumColumnList();
enumList.Add("Status", typeof(ECCentral.BizEntity.MKT.NewsAdvReplyStatus)); //前台展示状态
enumList.Add("ReplyHasReplied", typeof(ECCentral.BizEntity.MKT.NYNStatus)); //是否存在回复
CodeNamePairColumnList pairList = new CodeNamePairColumnList();
pairList.Add("ReferenceType", "MKT", "CommentsCategory"); //ReferenceType评论类型
var dt = cmd.ExecuteDataTable(enumList, pairList);
totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount"));
//if (dt != null && dt.Rows.Count > 0)
//{
// foreach (DataRow dr in dt.Rows)
// {
// if (!string.IsNullOrEmpty(dr["Image"].ToString()))
// {
// dr["Image"] = "http://c3.neweggimages.com.cn/CImages/Promotion/P80/" + dr["Image"].ToString().Replace(",", ",http://c3.neweggimages.com.cn/CImages/Promotion/P80/");
// dr["LinkImage"] = "http://c3.neweggimages.com.cn/CImages/Promotion/Original/" + dr["Image"].ToString().Replace(",", ",http://c3.neweggimages.com.cn/CImages/Promotion/Original/");
// }
// }
//}
return(dt);
}
}
