@cheerasak777

"C:\Program Files (x86)\TeamViewer\TeamViewer.exe" -i 192.168.0.22 -P 123456 /* TEAMV Re-direct to Client */

import re # Define the HL7 message hl7_message = """ R: <VT>MSH|^~\&|LabXpert|Mindray|||20240326132228||ORU^R01|1|P|2.3.1||||||UNICODE<CR>PID|1||^^^^MR<CR>PV1|1<CR>OBR|1||001|00001^Automated Count^99MRC|||20240326132224|||||||||||||||||HM|NotValida

—-Req_list_statistic_by_aot Select [HN], [LN], [FULLNAME], [YEAR], [SEX], [WARD NAME], [SOURCE NAME], [PRIORITY],

SELECT tlt.Test_Code, tlt.Test_Name, tlt.Test_His_Code FROM dbo.tbl_lab_setup_Test_Profile tltp INNER JOIN dbo.tbl_lab_setup_Test tlt ON tltp.Test_Item_Code = tlt.Test_Code WHERE tltp.Test_Profile_Code IN ('CH046','CH046A','CH046V') ORDER BY Test

[SCO13 -HIGLUCOSE, GLU [SCO14)-[BUNJ-[BUN] [SCO15)-[CREATININE]-[CREA] [SC008-[SGOT (AST))-[AST] [SCO091-ISPT (ALT)-[ALT] [SCO10)-(ALK PHOS)-[ALP] [SCO16)-[PROTEIN-(TP) [SC017)-[ALBUMIN)-[ALB] [SC0111-[CHOLESTEROLI-(TC] [SC012)-(TRIGLYCERIDE]-(TG] [

SELECT tlt.Test_Code, tlt.Test_Name, tlt.Test_His_Code ,Test_Checkup_Code FROM dbo.tbl_lab_setup_Test_Profile tltp INNER JOIN dbo.tbl_lab_setup_Test tlt ON tltp.Test_Item_Code = tlt.Test_Code WHERE tltp.Test_Profile_Code IN ('MC050P','MC050P','MC

<?xml version="1.0" encoding="windows-874"?> <HOSXP2LIS> <Header> <Sender>LIS</Sender> <Receiver>HOSxP</Receiver> <Pattern>P</Pattern> <GenerateDate>2024-03-05</GenerateDate> <GenerateTime>14:32:05</GenerateTime> </Header>

#include <SPI.h> #include <SD.h> // กำหนด pin const int speakerPin = 9; const int sdCardChipSelectPin = 10; // ตัวแปร File fileA, fileB, fileC, fileD; bool isPlayingA = false, isPlayingB = false, isPlayingC = false, isPlayingD = false;

CASE WHEN "%MC213%" = "0-1" or "%MC213%" = "1-2" or "%MC213%" = "2-3"or "%MC213%" = "3-5"or "%MC213%" = "5-10" or "%MC213%" = "10-20" or "%MC213%" = "20-30" or "%MC213%" = "30-50" or "%MC213%" = "50-100" or "%MC213%" = ">100" THEN "review

SELECT tlt.Test_Code, tlt.Test_Name, tlt.Test_His_Code FROM dbo.tbl_lab_setup_Test_Profile tltp INNER JOIN dbo.tbl_lab_setup_Test tlt ON tltp.Test_Item_Code = tlt.Test_Code WHERE tltp.Test_Profile_Code IN ('MC0001', 'MC0002', 'MC0003')

SELECT CASE WHEN (%HM020% < 10) THEN NULL WHEN(%HM020% >=10) THEN (%HM003%*100) /(%HM020%+100) ELSE "N/A" END /* select case when"%HM037%" <>"" then (%HM003%*(%HM006% + %HM037% ))/100.00+0.00

CASE WHEN(%HM020% >= 10) THEN (%HM003%*100)/(%HM020%+100) ELSE "" END

SELECT lab_items_sub_group_list.lab_items_sub_group_code, lab_items_sub_group.lab_items_sub_group_name, lab_items.ecode, lab_items.lab_items_name, lab_items.lab_items_code, lab_items.display_order, lab_items.lab_items_normal_value, l

select CASE WHEN {SEX} = "M" THEN ((140 - {AGEBIRTH}) * {WEIGHT}) / (72 * %CH003%) WHEN {SEX} = "F" THEN (((140 - {AGEBIRTH}) * {WEIGHT}) / (72 * %CH003%)) * 0.85 ELSE 0 END

USE LAB_DB UPDATE dbo.tbl_lab_setup_Test_Control SET Test_Blank_Result_Flag = 1 WHERE Test_Code IN ( SELECT Test_Code FROM

use -------------- MTP_LAB_DB declare @count int declare @max int declare @tsql nvarchar(255) declare @tbl table(rownum int IDENTITY (1, 1) Primary key NOT NULL , cmd nvarchar(255)) insert into @tbl(cmd) select ('delete ' + name) as cmd from sys.

UPDATE tbl_lab_setup_Test_Control SET dbo.tbl_lab_setup_Test_Control.Test_TAT_R_Days = '0', ---DATE dbo.tbl_lab_setup_Test_Control.Test_TAT_R_Hours = '2', ---Hr dbo.tbl_lab_setup_Test_Control.Test_TAT_R_Minutes = '0' ---Min WHERE

mid({BarcodeInfo.LN},1,8) + "-" + mid({BarcodeInfo.LN},9,2) /* ตัวอย่างการใช้งาน: // กำหนดตัวแปร BarcodeInfo.LN var BarcodeInfo = { LN: "1234567890" };

mid({BarcodeInfo.LN},1,8) + "-" + mid({BarcodeInfo.LN},9,2) /* ตัวอย่างการใช้งาน: // กำหนดตัวแปร BarcodeInfo.LN var BarcodeInfo = { LN: "1234567890" };

CASE WHEN "%CH201%" = "<10" AND "%CH202%" = "<10" THEN "<30" WHEN "%CH201%" = "<10" AND "%CH202%" <> "" THEN "<30" WHEN "%CH201%" = "10" AND "%CH202%" = "<10" THEN "50" WHEN "%CH201%" = "10" AND "%CH202%" = "10" THEN "100" WHEN "