public string getOrderCountByOrderNumberPart(string orderNumberPart)
{
MSDatabaseConnector msDatabaseConnectorLW = new MSDatabaseConnector(Config.MSDbLW);
String query = $@"use [LW08v6]
select count(*) from orders with (nolock)
where X_ORDER_CODE like '%" + orderNumberPart + "%'";
var orderCount = msDatabaseConnectorLW.QueryExecutorScalar(query);
return(orderCount);
}
public string getCounclusionCountByOrderNumber(string orderNumber)
{
MSDatabaseConnector msDatabaseConnectorLW = new MSDatabaseConnector(Config.MSDbLW);
String query = $@"use [LW08v6]
select count(*) from [X_ComplexEndings] (nolock) where OrderItem_ID in (
select id from [dbo].[X_ORDER_ITEMS] (nolock) oi
where oi.ORDER_NUM in (select order_num from [dbo].[ORDERS] (nolock) where x_order_code='" + orderNumber + "'))";
var conclusionCount = msDatabaseConnectorLW.QueryExecutorScalar(query);
return(conclusionCount);
}
public string getOrderCountByExternalSampleNumberPart(string externalSampleNumberPart, DateTime dateFrom, DateTime dateTo)
{
MSDatabaseConnector msDatabaseConnectorLW = new MSDatabaseConnector(Config.MSDbLW);
String query = $@"use [LW08v6]
select count(*) from orders with (nolock)
where created_on>='" + dateFrom.ToString("yyyy-MM-dd") + "T00:00:00' and created_on<='" +
dateTo.ToString("yyyy-MM-dd") + "T23:59:59' and order_num in (select order_num from sample with (nolock) where x_old_sample_id like '%" +
externalSampleNumberPart + "%')";
var orderCount = msDatabaseConnectorLW.QueryExecutorScalar(query);
return(orderCount);
}
