.NET (Core and Framework)

class Program
 {
     static unsafe void Main(string[] args)
     {
         int deviceNr;
         char* Info;
         int intMyReturnVal;
         deviceNr = 0;
         Info = null;
         intMyReturnVal = sample_getinfo(deviceNr, Info);
     }

     [DllImport("opcard2lib.dll")]
     private unsafe static extern int sample_getinfo(int deviceNr, char* Info);
 }

SELECT     i.item_id, i.sequence, i.item_name, od.buy_price, od.sell_price,
SUM(od.quantity) AS sum_qty,
l.location_name, oh.usr_login,
CASE i.is_composite_item WHEN 1 THEN "anything" WHEN 0 THEN "something" END AS remarks
FROM         item i, operation_detail od,operation_header oh,location l
WHERE
i.item_id=od.item_id and i.sequence=od.sequence and
od.operation_header_id=oh.operation_header_id and
oh.location_id=l.location_id and
  (oh.operation_type_id = "anything") AND
 (oh.operation_date >= @date_from ) AND
 (oh.operation_date <= @date_to ) AND
 (i.item_id >= @item_id_from OR @item_id_from = 0)
  AND (i.item_id <= @item_id_to OR @item_id_to = 0)
  AND (l.location_id = @location_id OR @location_id = '0')
  AND (i.is_raw_item = 0)
GROUP BY i.item_id, i.sequence, i.item_name, l.location_name,
 oh.usr_login, od.buy_price, od.sell_price,i.is_composite_item
order by i.item_id, i.sequence,l.location_name