Ejemplo n.º 1
0
        //		public string UPDATE { get { return statementUpdate(); } }
        // ————————————————————————————————————————————————————
        #endregion

        #region statement(…): categories,tables,insert,delete,update
        /// <summary>
        /// Automation/Generation of a Category-Query based on info supplied to this class.
        /// </summary>
        /// <returns>A SELECT query for categories.</returns>
        public string statementCategories()
        {
            return(query_statement_select
                   //+"@fields"
                   .Replace("@fields", "*")
                   //+"@table"
                   .Replace("@table", CategoryName.QBrace())
                   //+"@where"
                   .Replace("@where", "")
                   //				.Replace("@category","".QWhere(CategoryName.QBrace().QEqual("@"+CategoryValue)))
                   //+"@category"
                   .Replace("@category", "")
                   //+"@order"
                   .Replace("@order", "\n".QOrderBy(CategoryTitle.QBrace(), SqlSortOrder == SqlOrderMode.Ascending))
                   );
        }