ดู code แล้วไม่มีคำสั่งใส่ข้อมูลนี้น่ะครับ
select * from opitemrece where hos_guid = '{BFF29363-5840-4862-B7B9-3B6985F354A3}'
INSERT INTO opitemrece (hos_guid,vn,hn,an,icode,qty,drugusage,idr,iperday,iperdose,recetime,unitprice,vstdate,vsttime,doctor,rxdate,rxtime,sp_use,hcode,`print`,dep_code,finance_number,discount,use_right,node_id,order_no,`sub_type`,pttype,income,remain,item_type,staff,doctor_lock,paidst,item_no,last_modified,sum_price,cost,stock_department_id) VALUES ('{BFF29363-5840-4862-B7B9-3B6985F354A3}','530705132246','000000999',NULL,'3000602',1,'','N/A',0,0,NULL,60,'2010-07-05','13:22:46',NULL,'2010-07-05','13:23:32',NULL,NULL,NULL,'010',NULL,NULL,NULL,NULL,NULL,'3',NULL,'05',NULL,'',NULL,NULL,NULL,-1,NULL,60,NULL,NULL)
insert into replicate_log (`event_time`,`client`,`sql`) values (current_timestamp,'WISANU-PC','INSERT INTO opitemrece (hos_guid,vn,hn,an,icode,qty,drugusage,idr,iperday,iperdose,recetime,unitprice,vstdate,vsttime,doctor,rxdate,rxtime,sp_use,hcode,`print`,dep_code,finance_number,discount,use_right,node_id,order_no,`sub_type`,pttype,income,remain,item_type,staff,doctor_lock,paidst,item_no,last_modified,sum_price,cost,stock_department_id) VALUES (\'{BFF29363-5840-4862-B7B9-3B6985F354A3}\',\'530705132246\',\'000000999\',NULL,\'3000602\',1,\'\',\'N/A\',0,0,NULL,60,\'2010-07-05\',\'13:22:46\',NULL,\'2010-07-05\',\'13:23:32\',NULL,NULL,NULL,\'010\',NULL,NULL,NULL,NULL,NULL,\'3\',NULL,\'05\',NULL,\'\',NULL,NULL,NULL,-1,NULL,60,NULL,NULL)')
select service_price from lab_items where lab_items_code=2130
select count(*) as cc from s_drugitems where icode='3000293'
select vstdate from ovst where vn='530705132246'
select vsttime from ovst where vn='530705132246'
select hn from ovst where vn='530705132246'
select pttype from ovst where vn='530705132246'
select debtor from pttype where pttype='10'
select discount from pttype where pttype='10'
select * from opitemrece where hos_guid = '{DBB47123-915B-48E2-9700-1602B6C8B285}'
select income from nondrugitems where icode='3000293'
select * from opitemrece where hos_guid = '{DBB47123-915B-48E2-9700-1602B6C8B285}'
INSERT INTO opitemrece (hos_guid,vn,hn,an,icode,qty,drugusage,idr,iperday,iperdose,recetime,unitprice,vstdate,vsttime,doctor,rxdate,rxtime,sp_use,hcode,`print`,dep_code,finance_number,discount,use_right,node_id,order_no,`sub_type`,pttype,income,remain,item_type,staff,doctor_lock,paidst,item_no,last_modified,sum_price,cost,stock_department_id) VALUES ('{DBB47123-915B-48E2-9700-1602B6C8B285}','530705132246','000000999',NULL,'3000293',1,'','N/A',0,0,NULL,270,'2010-07-05','13:22:46',NULL,'2010-07-05','13:23:33',NULL,NULL,NULL,'010',NULL,NULL,NULL,NULL,NULL,'3',NULL,'05',NULL,'',NULL,NULL,NULL,-1,NULL,270,NULL,NULL)
หัวข้อ: รายการ LAB ไม่ปรากฎที่ห้องการเงิน (อ่าน 12008 ครั้ง)