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