C

@cheerasak777

Arduno gee generated engin enhance

C#
2 years ago
#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;

ALERT++!!when not empty result

SQL
2 years ago
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 slide" END

mod-Small-fish

SQL
2 years ago
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')

Correct WBC WHEN NRBC <10 THEN NULL

SQL
2 years ago
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

When count nRBC >=10

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

BIG_LOMA

SQL
2 years ago
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, lab_items.possible_value,

estimate CrCl

SQL
2 years ago
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

UPDATE Test_Blank_Result_Flag = 1แก้ไขให้โปรไฟล์นับเป็นสถิติด้วย

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

UPDATE_CREAROR_For_NEW

SQL
2 years ago
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.tables where name like 'tbl_lab_information%' or name ='tbl_lab_Analyzer_Result'

Update TAT(R) and TAT (S)

SQL
2 years ago
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 tbl_lab_setup_Test_Control.Test_Code IN (

LN แยกLN:66###-01

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

LN แยกLN:66###-01

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

A:C BY BOSS PEE NOONG(UACR)

SQL
2 years ago
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 "%CH201%" = "10" AND "%CH202%" = "50" THEN "20" WHEN "%CH201%" = "10" AND "%CH202%" = "100" THEN "10" WHEN "%CH201%" = "10" AND "%CH202%" = "200" THEN "5" WHEN "%CH201%" = "10" AND "%CH202%" = "300" THEN "3" WHEN "%CH201%" = "10" AND "%CH2

MAU is ### (NORMAL/ABNOR)

SQL
2 years ago
CASE WHEN( (%CC0570%* 100)/%CC5751% ) < 30 THEN "Normal (Less than 30 mg/g)" WHEN ( (%CC0570%* 100)/%CC5751% ) >= 30 AND %CC5752% < 300 THEN "Abnormal (Between 30-300 mg/g)" WHEN ( (%CC0570%* 100)/%CC5751%

kill i-CN HIS

Bash
2 years ago
taskkill /F /IM I-CN-HIS.exe /T c: cd C:\Program Files (x86)\i-CN-HIS HL7 start i-CN-HIS.exe timeout 1

นับจำนวน HNต่อวัน

SQL
2 years ago
select HN from( SELECT convert(varchar(10), [IREQ_OD_DT], 120) as OrderDate ,[IREQ_PID] as HN FROM [view_lab_information_Request] where IREQ_INACTIVE = 'N' and IREQ_OD_DT between '@d1' and '@d2' ) as x group by OrderDate, HN

Find duplicates of HisCode.

SQL
2 years ago
SELECT Test_His_Code , COUNT(*) count FROM tbl_lab_setup_Test GROUP BY [Test_His_Code] Having COUNT(*) > 1

GEE@botLine@BardTHAI

Java
2 years ago
//เด็กคอม www.dek-com.com const ACCESS_TOKEN = "ACCESS_TOKEN"; const bot = new LineBotSdk.client(ACCESS_TOKEN); function doPost(e) { bot.call(e, callback) }; function callback(e) { if (e.message.type == "text" ) { bot.replyMessage(e, [bot.textMessage(bard(e.message.text, 'en', 'th'))]); } };

BIG_SHACK_FOR_MYSQL

SQL
2 years ago
SET @SubGroupCode = '106'; --1068คือ subGroupCode (SET @ใช้กับMYSQL]) SELECT sg_list.lab_items_sub_group_code AS SubGroupCode, sg.lab_items_sub_group_name AS SubGroupName, li.ecode AS ItemECode, li.lab_items_name AS ItemName, li.lab_items_code AS ItemCode, li.display_order AS DisplayOrder, li.lab_items_normal_value AS NormalValue,

อัพเดท UPDATE Source_Definition

SQL
2 years ago
/*UPDATE dbo.tbl_lab_setup_Source_Definition SET Source_Definition_Name = CASE WHEN Source_Definition_Code = '000' THEN 'ไม่ทราบฝ่าย' WHEN Source_Definition_Code = '001' THEN 'ความดัน' -- เพิ่มเงื่อนไขสำหรับ Source_Definition_Code อื่น ๆ ต่อไป ELSE Source_Definition_Name -- ถ้าไม่ตรงกับเงื่อนไขใด ๆ ให้เก็บค่าเดิม END, Source_Group_Code = CASE WHEN Source_Definition_Code = '000' THEN 'OPD' WHEN Source_Definition_Code = '001' THEN 'OPD'