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

        public DataTable GetOrderListDataTable(int? restaurantId = null)
        {
            string sql = @"SELECT A.*,C.RESTAURANT_NAME,D.FOOD_NAME FROM ORDERLIST A
                                LEFT JOIN ORDERMAIN B ON A.ORDER_ID = B.ORDER_ID
                                LEFT JOIN RESTAURANT C ON B.RESTAURANT_ID = C.RESTAURANT_ID
                                LEFT JOIN FOOD D ON A.FOOD_ID = D.FOOD_ID
                                WHERE 1=1 ";
            if (restaurantId != null)
                sql += " AND C.RESTAURANT_ID = @RESTAURANT_ID ";
            using (DbCommand dc = Db.GetSqlStringCommand(sql))
            {
                if (restaurantId != null)
                    Db.AddInParameter(dc, "@RESTAURANT_ID", DbType.Int32, restaurantId);
                return Db.ExecuteDataTable(dc);
            }
        }