111
« เมื่อ: ธันวาคม 17, 2014, 16:08:00 PM »
อ.กอล์ฟ ผมเพิ่มโค้ดแบบนี้อ่ะครับ ถูกมั้ยครับ แต่อันที่ 2 ฉีดยา id ไม่ขึ้นครับ
{Unit Script;
var wd:tclientdataset;
Procedure Main;
begin
if (GetGlobalValue('CURRENT_DEPCODE')='027') or (GetGlobalValue('CURRENT_DEPCODE')='013')
begin
wd:=tclientdataset.create(nil);
wd.data:=hosxp_getdataset('select * from ovst where vn="'+GetGlobalValue('VN')+'"');
if wd.recordcount>0 then
begin
showmessage('Hospital Queue : '+wd.fieldbyname('oqueue').asstring+chr(10)+chr(10)
+' Queue '+getsqldata('select department from kskdepartment where depcode="'+wd.fieldbyname('main_dep').asstring+'"')+' : '+wd.fieldbyname('main_dep_queue').asstring);
end;
end;
end;
end.}
var
fvn,fcomputername,fdepartment,fhn : string;
fdate_1,fdate_2,fdate_3 : string;
tc : TClientDataset;
dTDate, sdTDate : date;
begin
//showmessage('TEST Script');
fvn:= GetGlobalValue('VN');
fcomputername := GetGlobalValue('CURRENT_COMPUTER');
fdepartment := GetGlobalValue('CURRENT_DEPCODE');
fhn:=getsqldata('select hn from ovst where vn = "'+fvn+'"');
// showmessage('Current VN = '+fvn+' , Computer Name = '+fcomputername+' , Department Code = '+fdepartment);
{==================== check TT ====================}
if getsqldata('select depcode from kskdepartment where depcode in ("011",008) and depcode="'+fdepartment+'"')=''+fdepartment+'' then
begin
fhn:=getsqldata('select hn from ovst where vn = "'+fvn+'"');
dTDate:=getsqldata('select o.vstdate from er_regist_oper e '+
'left outer join vn_stat o on o.vn=e.vn '+
'where o.hn = "'+fhn+'" and e.er_oper_code in ("412") order by o.vstdate desc limit 1 ');
if getsqldata('select count(*) as cc from er_regist_oper e '+
'left outer join vn_stat o on o.vn=e.vn '+
'where o.hn = "'+fhn+'" and e.er_oper_code in ("412") ')>0 then
begin
sdTDate:=FormatDatetime('dd/mmm/eeee',dTDate);
showmessage('[ ¼Ùé»èÇÂà¤Â©Õ´ÇѤ«Õ¹ºÒ´·ÐÂÑ¡ÁÒáÅéÇ àÁ×èÍÇѹ·Õè '+sdTDate+' ]');
end;
end;
end;
var
fvn,fcomputername,fdepartment,fhn : string;
fdate_1,fdate_2,fdate_3 : string;
tc : TClientDataset;
dTDate, sdTDate : date;
begin
//showmessage('TEST Script');
fvn:= GetGlobalValue('VN');
fcomputername := GetGlobalValue('CURRENT_COMPUTER');
fdepartment := GetGlobalValue('CURRENT_DEPCODE');
fhn:=getsqldata('select hn from ovst where vn = "'+fvn+'"');
// showmessage('Current VN = '+fvn+' , Computer Name = '+fcomputername+' , Department Code = '+fdepartment);
{==================== check TT ====================}
if getsqldata('select depcode from kskdepartment where depcode in ("011","008") and depcode="'+fdepartment+'"')=''+fdepartment+'' then
begin
fhn:=getsqldata('select hn from ovst where vn = "'+fvn+'"');
dTDate:=getsqldata('select o.vstdate from er_regist_oper e '+
'left outer join vn_stat o on o.vn=e.vn '+
'where o.hn = "'+fhn+'" and e.er_oper_code in ("224") order by o.vstdate desc limit 1 ');
if getsqldata('select count(*) as cc from er_regist_oper e '+
'left outer join vn_stat o on o.vn=e.vn '+
'where o.hn = "'+fhn+'" and e.er_oper_code in ("224") ')>0 then
begin
sdTDate:=FormatDatetime('dd/mmm/eeee',dTDate);
showmessage('[ ¼Ùé»èÇÂà¤Âä´éÃѺ¡ÒéմÂÒ ID àÁ×èÍÇѹ·Õè '+sdTDate+' ]');
end;
end;
end;