C# Класс Stardust.Manager.Helpers.CreateSqlCommandHelper

Показать файл Открыть проект Примеры использования класса

Открытые методы

Метод	Описание
CreateDeleteFromJobQueueCommand ( System.Guid jobId, SqlConnection sqlConnection, SqlTransaction sqlTransaction ) : SqlCommand
CreateDeleteJobByJobIdCommand ( System.Guid jobId, SqlConnection sqlConnection, SqlTransaction sqlTransaction ) : SqlCommand
CreateDoesJobDetailItemExistsCommand ( System.Guid jobId, SqlConnection sqlConnection ) : SqlCommand
CreateDoesJobItemExistsCommand ( System.Guid jobId, SqlConnection sqlConnection ) : SqlCommand
CreateDoesJobQueueItemExistsCommand ( System.Guid jobId, SqlConnection sqlConnection ) : SqlCommand
CreateGetAllExecutingJobsCommand ( SqlConnection sqlConnection ) : SqlCommand
CreateGetAllJobsCommand ( SqlConnection sqlConnection ) : SqlCommand
CreateGetJobQueueItemByJobIdCommand ( System.Guid jobId, SqlConnection sqlConnection ) : SqlCommand
CreateInsertIntoJobCommand ( JobQueueItem jobQueueItem, string sentToWorkerNodeUri, SqlConnection sqlConnection, SqlTransaction sqlTransaction ) : SqlCommand
CreateInsertIntoJobDetailCommand ( System.Guid jobId, string detail, System.DateTime created, SqlConnection sqlConnection ) : SqlCommand
CreateInsertIntoJobQueueCommand ( JobQueueItem jobQueueItem, SqlConnection sqlConnection, SqlTransaction sqlTransaction ) : SqlCommand
CreateSelect1JobQueueItemCommand ( SqlConnection sqlConnection, SqlTransaction sqlTransaction ) : SqlCommand
CreateSelectAllAliveWorkerNodesCommand ( SqlConnection sqlConnection ) : SqlCommand
CreateSelectAllItemsInJobQueueCommand ( SqlConnection connection ) : SqlCommand
CreateSelectJobByJobIdCommand ( System.Guid jobId, SqlConnection sqlConnection ) : SqlCommand
CreateSelectJobDetailByJobIdCommand ( System.Guid jobId, SqlConnection sqlConnection ) : SqlCommand
CreateSelectJobThatDidNotEndCommand ( string sentToWorkerNodeUri, SqlConnection sqlConnection, SqlTransaction sqlTransaction ) : SqlCommand
CreateSelectWorkerNodeCommand ( System.Guid jobId, SqlConnection sqlConnection, SqlTransaction sqlTransaction ) : SqlCommand
CreateUpdateCancellingResultCommand ( System.Guid jobId, SqlConnection sqlConnection, SqlTransaction sqlTransaction ) : SqlCommand
CreateUpdateResultCommand ( System.Guid jobId, string result, System.DateTime ended, SqlConnection sqlConnection ) : SqlCommand

Описание методов

CreateDeleteFromJobQueueCommand() публичный Метод

public CreateDeleteFromJobQueueCommand ( System.Guid jobId, SqlConnection sqlConnection, SqlTransaction sqlTransaction ) : SqlCommand
jobId	System.Guid
sqlConnection	System.Data.SqlClient.SqlConnection
sqlTransaction	System.Data.SqlClient.SqlTransaction
Результат	System.Data.SqlClient.SqlCommand

CreateDeleteJobByJobIdCommand() публичный Метод

public CreateDeleteJobByJobIdCommand ( System.Guid jobId, SqlConnection sqlConnection, SqlTransaction sqlTransaction ) : SqlCommand
jobId	System.Guid
sqlConnection	System.Data.SqlClient.SqlConnection
sqlTransaction	System.Data.SqlClient.SqlTransaction
Результат	System.Data.SqlClient.SqlCommand

CreateDoesJobDetailItemExistsCommand() публичный Метод

public CreateDoesJobDetailItemExistsCommand ( System.Guid jobId, SqlConnection sqlConnection ) : SqlCommand
jobId	System.Guid
sqlConnection	System.Data.SqlClient.SqlConnection
Результат	System.Data.SqlClient.SqlCommand

CreateDoesJobItemExistsCommand() публичный Метод

public CreateDoesJobItemExistsCommand ( System.Guid jobId, SqlConnection sqlConnection ) : SqlCommand
jobId	System.Guid
sqlConnection	System.Data.SqlClient.SqlConnection
Результат	System.Data.SqlClient.SqlCommand

CreateDoesJobQueueItemExistsCommand() публичный Метод

public CreateDoesJobQueueItemExistsCommand ( System.Guid jobId, SqlConnection sqlConnection ) : SqlCommand
jobId	System.Guid
sqlConnection	System.Data.SqlClient.SqlConnection
Результат	System.Data.SqlClient.SqlCommand

CreateGetAllExecutingJobsCommand() публичный Метод

public CreateGetAllExecutingJobsCommand ( SqlConnection sqlConnection ) : SqlCommand
sqlConnection	System.Data.SqlClient.SqlConnection
Результат	System.Data.SqlClient.SqlCommand

CreateGetAllJobsCommand() публичный Метод

public CreateGetAllJobsCommand ( SqlConnection sqlConnection ) : SqlCommand
sqlConnection	System.Data.SqlClient.SqlConnection
Результат	System.Data.SqlClient.SqlCommand

CreateGetJobQueueItemByJobIdCommand() публичный Метод

public CreateGetJobQueueItemByJobIdCommand ( System.Guid jobId, SqlConnection sqlConnection ) : SqlCommand
jobId	System.Guid
sqlConnection	System.Data.SqlClient.SqlConnection
Результат	System.Data.SqlClient.SqlCommand

CreateInsertIntoJobCommand() публичный Метод

public CreateInsertIntoJobCommand ( JobQueueItem jobQueueItem, string sentToWorkerNodeUri, SqlConnection sqlConnection, SqlTransaction sqlTransaction ) : SqlCommand
jobQueueItem	Stardust.Manager.Models.JobQueueItem
sentToWorkerNodeUri	string
sqlConnection	System.Data.SqlClient.SqlConnection
sqlTransaction	System.Data.SqlClient.SqlTransaction
Результат	System.Data.SqlClient.SqlCommand

CreateInsertIntoJobDetailCommand() публичный Метод

public CreateInsertIntoJobDetailCommand ( System.Guid jobId, string detail, System.DateTime created, SqlConnection sqlConnection ) : SqlCommand
jobId	System.Guid
detail	string
created	System.DateTime
sqlConnection	System.Data.SqlClient.SqlConnection
Результат	System.Data.SqlClient.SqlCommand

CreateInsertIntoJobQueueCommand() публичный Метод

public CreateInsertIntoJobQueueCommand ( JobQueueItem jobQueueItem, SqlConnection sqlConnection, SqlTransaction sqlTransaction ) : SqlCommand
jobQueueItem	Stardust.Manager.Models.JobQueueItem
sqlConnection	System.Data.SqlClient.SqlConnection
sqlTransaction	System.Data.SqlClient.SqlTransaction
Результат	System.Data.SqlClient.SqlCommand

CreateSelect1JobQueueItemCommand() публичный Метод

public CreateSelect1JobQueueItemCommand ( SqlConnection sqlConnection, SqlTransaction sqlTransaction ) : SqlCommand
sqlConnection	System.Data.SqlClient.SqlConnection
sqlTransaction	System.Data.SqlClient.SqlTransaction
Результат	System.Data.SqlClient.SqlCommand

CreateSelectAllAliveWorkerNodesCommand() публичный Метод

public CreateSelectAllAliveWorkerNodesCommand ( SqlConnection sqlConnection ) : SqlCommand
sqlConnection	System.Data.SqlClient.SqlConnection
Результат	System.Data.SqlClient.SqlCommand

CreateSelectAllItemsInJobQueueCommand() публичный Метод

public CreateSelectAllItemsInJobQueueCommand ( SqlConnection connection ) : SqlCommand
connection	System.Data.SqlClient.SqlConnection
Результат	System.Data.SqlClient.SqlCommand

CreateSelectJobByJobIdCommand() публичный Метод

public CreateSelectJobByJobIdCommand ( System.Guid jobId, SqlConnection sqlConnection ) : SqlCommand
jobId	System.Guid
sqlConnection	System.Data.SqlClient.SqlConnection
Результат	System.Data.SqlClient.SqlCommand

CreateSelectJobDetailByJobIdCommand() публичный Метод

public CreateSelectJobDetailByJobIdCommand ( System.Guid jobId, SqlConnection sqlConnection ) : SqlCommand
jobId	System.Guid
sqlConnection	System.Data.SqlClient.SqlConnection
Результат	System.Data.SqlClient.SqlCommand

CreateSelectJobThatDidNotEndCommand() публичный Метод

public CreateSelectJobThatDidNotEndCommand ( string sentToWorkerNodeUri, SqlConnection sqlConnection, SqlTransaction sqlTransaction ) : SqlCommand
sentToWorkerNodeUri	string
sqlConnection	System.Data.SqlClient.SqlConnection
sqlTransaction	System.Data.SqlClient.SqlTransaction
Результат	System.Data.SqlClient.SqlCommand

CreateSelectWorkerNodeCommand() публичный Метод

public CreateSelectWorkerNodeCommand ( System.Guid jobId, SqlConnection sqlConnection, SqlTransaction sqlTransaction ) : SqlCommand
jobId	System.Guid
sqlConnection	System.Data.SqlClient.SqlConnection
sqlTransaction	System.Data.SqlClient.SqlTransaction
Результат	System.Data.SqlClient.SqlCommand

CreateUpdateCancellingResultCommand() публичный Метод

public CreateUpdateCancellingResultCommand ( System.Guid jobId, SqlConnection sqlConnection, SqlTransaction sqlTransaction ) : SqlCommand
jobId	System.Guid
sqlConnection	System.Data.SqlClient.SqlConnection
sqlTransaction	System.Data.SqlClient.SqlTransaction
Результат	System.Data.SqlClient.SqlCommand

CreateUpdateResultCommand() публичный Метод

public CreateUpdateResultCommand ( System.Guid jobId, string result, System.DateTime ended, SqlConnection sqlConnection ) : SqlCommand
jobId	System.Guid
result	string
ended	System.DateTime
sqlConnection	System.Data.SqlClient.SqlConnection
Результат	System.Data.SqlClient.SqlCommand