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)); }
// /// <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); }