C# Class Prizm.Data.DAL.ADO.MillReportsRepository

Inheritance: IMillReportsRepository, IDisposable

Mostra file Open project: AleksMorozova/prizm

Public Methods

Method	Description
CountPipe ( System.DateTime startDate, System.DateTime finalDate ) : BindingList
CountWeldInf ( System.DateTime startDate, System.DateTime finalDate ) : DataSet
CreateConnection ( ) : SqlConnection
Dispose ( ) : void
GetAllKP ( ) : BindingList
GetPipelineElements ( ) : DataTable
GetPipelineElements ( System.DateTime weldDateFrom, System.DateTime weldDateTo ) : DataTable
GetPipelineElements ( string sqlQueryString ) : DataTable
GetPipelineElements ( string pipeNumber, string pipeTypes ) : DataTable
GetPipes ( System.DateTime startDate, System.DateTime finalDate ) : DataSet
GetPipesByStatus ( System.DateTime startDate, System.DateTime finalDate, List categories, MillReportType reportType, List statuses, bool previewFlag = false ) : DataSet
GetPipesFromInspection ( System.DateTime startDate, System.DateTime finalDate ) : DataSet
GetReleaseNotes ( System.DateTime startDate, System.DateTime finalDate ) : DataSet
GetUsedProducts ( int startPK, int endPK, string queryString ) : DataSet

Private Methods

Method	Description
MillReportsRepository ( ) : System

Method Details

CountPipe() public method

public CountPipe ( System.DateTime startDate, System.DateTime finalDate ) : BindingList
startDate	System.DateTime
finalDate	System.DateTime
return	BindingList

CountWeldInf() public method

public CountWeldInf ( System.DateTime startDate, System.DateTime finalDate ) : DataSet
startDate	System.DateTime
finalDate	System.DateTime
return	System.Data.DataSet

CreateConnection() public method

public CreateConnection ( ) : SqlConnection
return	System.Data.SqlClient.SqlConnection

Dispose() public method

public Dispose ( ) : void
return	void

GetAllKP() public method

public GetAllKP ( ) : BindingList
return	BindingList

GetPipelineElements() public method

public GetPipelineElements ( ) : DataTable
return	System.Data.DataTable

GetPipelineElements() public method

public GetPipelineElements ( System.DateTime weldDateFrom, System.DateTime weldDateTo ) : DataTable
weldDateFrom	System.DateTime
weldDateTo	System.DateTime
return	System.Data.DataTable

GetPipelineElements() public method

public GetPipelineElements ( string sqlQueryString ) : DataTable
sqlQueryString	string
return	System.Data.DataTable

GetPipelineElements() public method

public GetPipelineElements ( string pipeNumber, string pipeTypes ) : DataTable
pipeNumber	string
pipeTypes	string
return	System.Data.DataTable

GetPipes() public method

public GetPipes ( System.DateTime startDate, System.DateTime finalDate ) : DataSet
startDate	System.DateTime
finalDate	System.DateTime
return	System.Data.DataSet

GetPipesByStatus() public method

public GetPipesByStatus ( System.DateTime startDate, System.DateTime finalDate, List categories, MillReportType reportType, List statuses, bool previewFlag = false ) : DataSet
startDate	System.DateTime
finalDate	System.DateTime
categories	List
reportType	MillReportType
statuses	List
previewFlag	bool
return	System.Data.DataSet

GetPipesFromInspection() public method

public GetPipesFromInspection ( System.DateTime startDate, System.DateTime finalDate ) : DataSet
startDate	System.DateTime
finalDate	System.DateTime
return	System.Data.DataSet

GetReleaseNotes() public method

public GetReleaseNotes ( System.DateTime startDate, System.DateTime finalDate ) : DataSet
startDate	System.DateTime
finalDate	System.DateTime
return	System.Data.DataSet

GetUsedProducts() public method

public GetUsedProducts ( int startPK, int endPK, string queryString ) : DataSet
startPK	int
endPK	int
queryString	string
return	System.Data.DataSet