MySQL中加判断

//$可以使参数sortVolumesq融入到sql语句中
var sql = $@"SELECT
t.`MemberID`,t2.`MemberName`,SUM(t1.`Volumn`)AS TotalVolume,COUNT(t.`MemberID`)AS TotalOrder
FROM `tt_tms_order` t
JOIN `tt_tms_orderextend` t1 ON t1.`OrderID`=t.`OrderID`
JOIN `tm_master_member` t2 ON t2.`MemberID`=t.`MemberID`
where t.CompanyID=@CompanyID AND t.`CreateDate`  BETWEEN @BeginDate AND @EndDate
GROUP BY t.`MemberID`,t2.`MemberName`
ORDER BY {(sortVolume ? "TotalVolume" : "TotalOrder")} DESC
LIMIT 7
";