public static string GetStatement(SERVICE_QUERY_TYPE queryType, string baseCommandText, string table, List <string> columns, List <string> values) { string queryStatement = BLANK; switch (queryType) { case SERVICE_QUERY_TYPE.INSERT: queryStatement = getInsertStatement(baseCommandText, table, columns, values); break; case SERVICE_QUERY_TYPE.UPDATE: break; case SERVICE_QUERY_TYPE.SELECT: break; case SERVICE_QUERY_TYPE.UNKNOWN: break; default: break; } return(queryStatement); }
public static string GetBaseQuery(SERVICE_QUERY_TYPE queryType) { // new data access DataAccess settings = new DataAccess(); string queryValue = BLANK; switch (queryType) { case SERVICE_QUERY_TYPE.INSERT: queryValue = settings.SERVICE_BASE_QUERY_INSERT; break; case SERVICE_QUERY_TYPE.UPDATE: break; case SERVICE_QUERY_TYPE.SELECT: break; default: break; } return(queryValue); }
public static extern bool EnumServicesStatusEx(int SCManager, int InfoLevel, SERVICE_QUERY_TYPE ServiceType, SERVICE_QUERY_STATE ServiceState, IntPtr Services, int BufSize, out int BytesNeeded, out int ServicesReturned, out int ResumeHandle, int GroupName);