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