C# 클래스 Stardust.Manager.Helpers.CreateSqlCommandHelper

파일 보기 프로젝트 열기: Teleopti/Stardust 1 사용 예제들

공개 메소드들

메소드	설명
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