public void QueryAllCategory(EventHandler <RestClientEventArgs <dynamic> > callback)
{
CategoryQueryFilter filter = new CategoryQueryFilter()
{
Status = CategoryStatus.Active, Type = CategoryType.CategoryType3
};
filter.PagingInfo = new PagingInfo
{
PageSize = 100000,
PageIndex = 0
};
const string relativeUrl = "/IMService/Category/GetCategoryListByType";
restClient_IM.QueryDynamicData(relativeUrl, filter,
(obj, args) =>
{
if (args.FaultsHandle())
{
return;
}
callback(obj, args);
});
}
public void QueryCategory(CategoryQueryVM model, int PageSize, int PageIndex, string SortField, EventHandler <RestClientEventArgs <dynamic> > callback)
{
CategoryQueryFilter filter = new CategoryQueryFilter()
{
Type = model.Type, Category1SysNo = model.Category1SysNo, Category2SysNo = model.Category2SysNo, Status = model.Status, CategoryName = model.CategoryName
};
filter.PagingInfo = new PagingInfo
{
PageSize = PageSize,
PageIndex = PageIndex,
SortBy = SortField
};
const string relativeUrl = "/IMService/Category/GetCategoryListByType";
restClient.QueryDynamicData(relativeUrl, filter,
(obj, args) =>
{
if (args.FaultsHandle())
{
return;
}
callback(obj, args);
}
);
}
public void QueryAllCategory3(CategoryQueryFilter queryFilter, EventHandler <RestClientEventArgs <List <CategoryInfo> > > callback)
{
queryFilter.CompanyCode = CPApplication.Current.CompanyCode;
string relativeUrl = string.Format("/MKTService/ECCategory/QueryAllCategory{0}", 3);
restClient.Query <List <CategoryInfo> >(relativeUrl, queryFilter, callback);
}
public List <CategoryInfo> QueryAllCategory3(CategoryQueryFilter queryFilter)
{
var dataCommand = DataCommandManager.GetDataCommand("QueryAllECCCategory3");
dataCommand.SetParameterValue("@CompanyCode", queryFilter.CompanyCode);
DataTable dt = dataCommand.ExecuteDataTable();
return(BuildCategoryEntityList(dt));
}
public void GetAllActiveBackendC3(EventHandler <RestClientEventArgs <List <CategoryInfo> > > callback)
{
string relativeUrl = string.Format("/IMService/Category/QueryAllCategory{0}", 3);
var queryFilter = new CategoryQueryFilter();
queryFilter.CompanyCode = CPApplication.Current.CompanyCode;
queryFilter.Status = CategoryStatus.Active;
imRestClient.Query <List <CategoryInfo> >(relativeUrl, queryFilter, callback);
}
public List <CategoryInfo> QueryCategory2(CategoryQueryFilter queryFilter)
{
var dataCommand = DataCommandManager.GetDataCommand("QueryCategory2");
dataCommand.SetParameterValue("@Category1SysNumber", queryFilter.Category1SysNo.HasValue ? queryFilter.Category1SysNo.Value : 0);
dataCommand.SetParameterValue("@CompanyCode", queryFilter.CompanyCode);
DataTable dt = dataCommand.ExecuteDataTable();
return(BuildCategoryEntityList(dt));
}
public virtual QueryResult GetCategoryListByType(CategoryQueryFilter query)
{
int totalCount;
var dataTable = ObjectFactory <ICategoryDA> .Instance.GetCategoryListByType(query, out totalCount);
return(new QueryResult
{
Data = dataTable,
TotalCount = totalCount
});
}
public UCECCCategoryPicker()
{
InitializeComponent();
queryFilter = new CategoryQueryFilter()
{
CompanyCode = CPApplication.Current.CompanyCode
};
Category1List = new List <CategoryInfo>();
Category2List = new List <CategoryInfo>();
Category3List = new List <CategoryInfo>();
this.Loaded += new RoutedEventHandler(UCECCCategoryPicker_Loaded);
}
public QueryResult QueryCategory(CategoryQueryFilter queryFilter)
{
if (queryFilter == null)
{
throw new BizException(ResouceManager.GetMessageString("IM.Manufacturer", "ManufacturerCondtionIsNull"));
}
int totalCount;
var dataTable = ObjectFactory <ICategoryQueryDA> .Instance.QueryCategory(queryFilter, out totalCount);
return(new QueryResult()
{
Data = dataTable,
TotalCount = totalCount
});
}
public PagedList <Category> GetCategories(CategoryQueryFilter filters)
{
filters.PageNumber = filters.PageNumber == 0 ? _paginationOptions.DefaultPageNumber : filters.PageNumber;
filters.PageSize = filters.PageSize == 0 ? _paginationOptions.MaxPageSize : filters.PageSize;
var categories = _unitOfWork.CategoryRepository.GetAll();
if (filters.Name != null)
{
categories = categories.Where(x => x.Name == filters.Name);
}
var pagedCategories = PagedList <Category> .Create(categories, filters.PageNumber, filters.PageSize);
return(pagedCategories);
}
public DataTable GetCategoryListByType(CategoryQueryFilter query, out int totalCount)
{
DataCommand cmd = null;
switch (query.Type)
{
case CategoryType.CategoryType1:
cmd = DataCommandManager.GetDataCommand("GetCategory1List");
break;
case CategoryType.CategoryType2:
cmd = DataCommandManager.GetDataCommand("GetCategory2List");
cmd.SetParameterValue("@Category1SysNo", query.Category1SysNo);
break;
case CategoryType.CategoryType3:
cmd = DataCommandManager.GetDataCommand("GetCategory3List");
cmd.SetParameterValue("@Category1SysNo", query.Category1SysNo);
cmd.SetParameterValue("@Category2SysNo", query.Category2SysNo);
break;
default:
cmd = DataCommandManager.GetDataCommand("GetCategory1List");
break;
}
cmd.SetParameterValue("@PageCurrent", query.PagingInfo.PageIndex);
cmd.SetParameterValue("@PageSize", query.PagingInfo.PageSize);
cmd.SetParameterValue("@SortField", query.PagingInfo.SortBy);
cmd.SetParameterValue("@Status", query.Status);
cmd.SetParameterValue("@CategoryName", query.CategoryName);
EnumColumnList enumList = new EnumColumnList
{
{ "CategoryStatus", typeof(CategoryStatus) },
};
DataTable dt = new DataTable();
dt = cmd.ExecuteDataTable(enumList);
totalCount = (int)cmd.GetParameterValue("@TotalCount");
return(dt);
}
void UCPrimaryCategoryPicker_Loaded(object sender, RoutedEventArgs e)
{
CategoryList = new List <CategoryInfo>();
categoryFacade = new CategoryFacade(CPApplication.Current.CurrentPage);
queryFilter = new CategoryQueryFilter()
{
CompanyCode = "8601"
};
InitializeCategoryComboBox();
//Loaded -= new RoutedEventHandler(UCPrimaryCategoryPicker_Loaded);
//var exp = this.GetBindingExpression(UCPrimaryCategoryPicker.CategorySysNoProperty);
//if (exp != null && exp.ParentBinding != null)
//{
// string path = exp.ParentBinding.Path.Path;
// Binding binding = new Binding();
// binding.Path = new PropertyPath(path);
// binding.Mode = BindingMode.TwoWay;
// binding.NotifyOnValidationError = true;
// cmbCategory.SetBinding(Newegg.Oversea.Silverlight.Controls.Combox.SelectedValueProperty, binding);
//}
}
public IActionResult GetCategories([FromQuery] CategoryQueryFilter filters)
{
var categories = _categoryService.GetCategories(filters);
var categoriesDtos = _mapper.Map <IEnumerable <CategoryDto> >(categories);
var metadata = new Metadata
{
TotalCount = categories.TotalCount,
PageSize = categories.PageSize,
CurrentPage = categories.CurrentPage,
TotalPages = categories.TotalPages,
HasNextPage = categories.HasNextPage,
HasPreviousPage = categories.HasPreviousPage
};
var response = new ApiResponse <IEnumerable <CategoryDto> >(categoriesDtos)
{
Meta = metadata
};
Response.Headers.Add("X-Pagination", JsonConvert.SerializeObject(metadata));
return(Ok(response));
}
public virtual DataTable QueryCategory(CategoryQueryFilter queryCriteria, out int totalCount)
{
CustomDataCommand dataCommand = DataCommandManager.CreateCustomDataCommandFromConfig("QueryCategory");
var pagingInfo = new PagingInfoEntity
{
SortField = queryCriteria.PagingInfo.SortBy,
StartRowIndex = queryCriteria.PagingInfo.PageIndex * queryCriteria.PagingInfo.PageSize,
MaximumRows = queryCriteria.PagingInfo.PageSize
};
using (var sqlBuilder = new DynamicQuerySqlBuilder(dataCommand.CommandText, dataCommand, pagingInfo, "SysNo DESC"))
{
if (!String.IsNullOrEmpty(queryCriteria.CategoryName))
{
dataCommand.AddInputParameter("@CategoryName", DbType.String, queryCriteria.CategoryName);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"C3Name",
DbType.String, "@CategoryName",
QueryConditionOperatorType.Like,
queryCriteria.CategoryName);
}
if (queryCriteria.Status != null)
{
dataCommand.AddInputParameter("@Status", DbType.String, queryCriteria.Status);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"Status",
DbType.String, "@Status",
QueryConditionOperatorType.Equal,
queryCriteria.Status);
}
dataCommand.CommandText = sqlBuilder.BuildQuerySql();
DataTable dt = dataCommand.ExecuteDataTable("CategoryStatus", typeof(CategoryStatus));
totalCount = Convert.ToInt32(dataCommand.GetParameterValue("@TotalCount"));
return(dt);
}
}
public List <CategoryInfo> QueryAllPrimaryCategory(CategoryQueryFilter queryFilter)
{
return(ObjectFactory <ICategoryQueryDA> .Instance.QueryAllPrimaryCategory(queryFilter));
}
/// <summary>
/// Xem danh sách danh mục theo filter: tên,..
/// Phân trang
/// </summary>
/// <param name="filter"></param>
/// <returns>Danh sách danh mục theo filter</returns>
public async Task <PaginatedList <CategoryResponse> > GetCategoryByFilterAsync(CategoryQueryFilter filter)
{
var data = _newsContext.Categories.Where(x => x.ParentId == null);
var dataResponse = new List <CategoryResponse>();
foreach (var item in data)
{
dataResponse.Add(new CategoryResponse
{
Id = item.Id,
Name = item.Name,
ParentId = item.ParentId,
SubCategories = await GetSubCategoryAsync(item.Id)
});
}
if (!string.IsNullOrEmpty(filter.Name))
{
dataResponse = dataResponse.Where(x => x.Name.Contains(filter.Name)).ToList();
}
if (filter.ParentId.HasValue)
{
dataResponse = dataResponse.Where(x => x.ParentId == filter.ParentId).ToList();
}
if (!filter.PageSize.HasValue && !filter.PageNumber.HasValue)
{
return(await PaginatedList <CategoryResponse> .CreateAsync(dataResponse));
}
return(await PaginatedList <CategoryResponse> .CreateAsync(dataResponse, filter.PageNumber.Value, filter.PageSize.Value));
}
public List<CategoryInfo> QueryAllCategory3(CategoryQueryFilter queryFilter)
{
return ObjectFactory<IECCategoryQueryDA>.Instance.QueryAllCategory3(queryFilter);
}
public Uri GetCategoryPaginationUri(CategoryQueryFilter filter, string actionUrl)
{
string baseUrl = $"{_baseUri}{actionUrl}";
return(new Uri(baseUrl));
}
/// <summary>
/// 查询类别数据
/// 本方法不区分1，2，3类别
/// 目前供IM类别控件使用
/// </summary>
/// <param name="queryFilter"></param>
/// <param name="callback"></param>
public void QueryAllPrimaryCategory(CategoryQueryFilter queryFilter, EventHandler <RestClientEventArgs <List <CategoryInfo> > > callback)
{
string relativeUrl = "/IMService/Category/QueryAllPrimaryCategory";
restClient.Query <List <CategoryInfo> >(relativeUrl, queryFilter, callback);
}
