public QueryResult QuerySaleAdvTemplates(SaleAdvTemplateQueryFilter msg)
{
int totalCount;
var dataTable = ObjectFactory <ISaleAdvTemplateQueryDA> .Instance.Query(msg, out totalCount);
return(new QueryResult()
{
Data = dataTable,
TotalCount = totalCount
});
}
public DataTable Query(SaleAdvTemplateQueryFilter filter, out int totalCount)
{
PagingInfoEntity pagingEntity = new PagingInfoEntity();
pagingEntity.SortField = filter.PagingInfo.SortBy;
pagingEntity.MaximumRows = filter.PagingInfo.PageSize;
pagingEntity.StartRowIndex = filter.PagingInfo.PageIndex * filter.PagingInfo.PageSize;
var cmd = DataCommandManager.CreateCustomDataCommandFromConfig("QuerySaleAdvTemplates");
using (var sqlBuilder = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, pagingEntity, "result.CreateDate DESC"))
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"sa.SysNo", DbType.Int32, "@SysNo", QueryConditionOperatorType.Equal, filter.SysNo);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"sa.CreateTime", DbType.DateTime, "@CreateDateFrom", QueryConditionOperatorType.MoreThanOrEqual, filter.CreateDateFrom);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"sa.CreateTime", DbType.DateTime, "@CreateDateTo", QueryConditionOperatorType.LessThan, filter.CreateDateTo);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"sa.Status", DbType.Int32, "@Status", QueryConditionOperatorType.Equal, filter.Status);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"v_user.DisplayName", DbType.String, "@CreateUser", QueryConditionOperatorType.Like, filter.CreateUser);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"sa.CompanyCode", DbType.String, "@CompanyCode", QueryConditionOperatorType.Equal, filter.CompanyCode);
cmd.CommandText = sqlBuilder.BuildQuerySql();
DataTable dt = cmd.ExecuteDataTable(new EnumColumnList {
{ "Status", typeof(SaleAdvStatus) },
{ "EnableReplyRank", typeof(CustomerRank) },
{ "Type", typeof(ShowType) },
{ "GroupType", typeof(GroupType) }
});
totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount"));
return(dt);
}
}
public void Query(SaleAdvQueryVM vm, int pageSize, int pageIndex, string sortField, EventHandler <RestClientEventArgs <dynamic> > callback)
{
SaleAdvTemplateQueryFilter filter = vm.ConvertVM <SaleAdvQueryVM, SaleAdvTemplateQueryFilter>();
filter.CompanyCode = CPApplication.Current.CompanyCode;
filter.PagingInfo = new QueryFilter.Common.PagingInfo
{
PageSize = pageSize,
PageIndex = pageIndex,
SortBy = sortField
};
string relativeUrl = "/MKTService/SaleAdvTemplate/Query";
restClient.QueryDynamicData(relativeUrl, filter, (obj, args) =>
{
if (args.FaultsHandle())
{
return;
}
callback(obj, args);
});
}
