Question

我有两个领域: 产品名称和价格加上2种选择:ending或 des。

用户可以通过设置2个检查箱来具体规定分类顺序: 价格检查箱上或外面,以及箱子上或外面的货箱。

当根据上述2个检查箱的情况动态地确定分类令时,我如何将顺序条款编码? 感谢。

Answer 1

您可以通过有条件地具体说明OrderBy来建立询问。条款:

var query = from product in db.Products select product;

if(price.Checked && ascending.Checked)
{
    query = query.OrderBy(product => product.Price);
}
else if(price.Checked && !ascending.Checked)
{
    query = query.OrderByDescending(product => product.Price);
}
else if(!price.Checked && ascending.Checked)
{
    query = query.OrderBy(product => product.Name);
}
else
{
    query = query.OrderByDescending(product => product.Name);
}

Answer 2

Please note that the ascendingCondition below is based on your code

if(ascendingCondition)
{
   ProductCollection.OrderBy(p => p.Name).ThenBy(p => p.Price)
}
else
{
   ProductCollection.OrderByDescending(p => p.Name).ThenByDescending(p => p.Price)
}

友情链接