Esempio n. 1
0
        public ExceptionLogDAO()
        {
            TableName = "default";

            SelectMethods.Add("List", new SelectFilterDelegate(this.Select_List));
            SelectMethods.Add("TimeLine", new SelectFilterDelegate(this.Select_TimeLine));

            //================================================================================

            WhereMethods.Add("CreateTime", new FilterDelegate(this.Where_CreateTime));
            WhereMethods.Add("Keyword", new FilterDelegate(this.Where_Keyword));
            WhereMethods.Add("Subkey", new FilterDelegate(this.Where_Subkey));
            WhereMethods.Add("Type", new FilterDelegate(this.Where_Type));
            WhereMethods.Add("Level", new FilterDelegate(this.Where_Level));
            WhereMethods.Add("ProjectKey", new FilterDelegate(this.Where_ProjectKey));
        }
Esempio n. 2
0
 //
 /// <summary>
 /// SELECT (|TableName.colName|,...) FROM |tableName1| {INNER_JOIN (|tableName2|,...) ON (TableName1.colName=TableName2.colname)} {WHERE (TableName.colName=value)/|TableName.colName| BETWEEN/NOT_BETWEEN/IN/NOT_IN (values)} {ORDER_BY (TableName.colName) DESC/ASC}
 /// SELECT (COUNT) FROM ...
 /// SELECT (AVG/MIN/MAX/SUM,TableName.ColName) FROM
 /// SELECT (TOP,VALUES/PERC=5) FROM
 /// </summary>
 /// <param name="query"></param>
 private static void Select(string query)
 {
     SelectMethods.Execute(query);
 }