I want to Convert the MS-SQL
C#:
SELECT *
FROM HI_ERP_PLAN WITH (NOLOCK)
WHERE 1 = 1
<IsNotNull Property=""PLAN_DATE"">AND PLAN_DATE = @PLAN_DATE</IsNotNull>
<IsNotNull Property=""PLANT_CODE"">AND PLANT_CODE = @PLANT_CODE</IsNotNull>
<IsNotNull Property=""PRODUCT_CODE"">AND PRODUCT_CODE = @PRODUCT_CODE</IsNotNull>
<IsNotNull Property=""ORDERBY"">ORDER BY $ORDERBY</IsNotNull>
<IsNull Property=""ORDERBY"">ORDER BY PLANT_CODE ASC, PLAN_DATE ASC </IsNull>