Dian.Biz.OrderBiz.GetUnConfirmOrderData C# (CSharp) Method

        private DataTable GetUnConfirmOrderData(int orderId, int? foodId = null)
        {
            string sql = @"SELECT A.*,B.FOOD_NAME FROM ORDERLIST A
                            LEFT JOIN FOOD B ON A.FOOD_ID = B.FOOD_ID
                            WHERE (CANCEL_TIME = '' OR CANCEL_TIME IS NULL)
                            AND (CONFIRM_TIME = '' OR CONFIRM_TIME IS NULL)
                            AND (FINISH_TIME = '' OR FINISH_TIME IS NULL)
                            AND A.ORDER_ID = @ORDER_ID ";
            if (foodId != null)
                sql += " AND A.FOOD_ID = @FOOD_ID ";
            using (DbCommand dc = Db.GetSqlStringCommand(sql))
            {
                Db.AddInParameter(dc, "@ORDER_ID", DbType.Int32, orderId);
                if (foodId != null)
                    Db.AddInParameter(dc, "@FOOD_ID", DbType.Int32, foodId);
                return Db.ExecuteDataTable(dc);
            }
        }