程式名稱：AR_Unit



select * from m_syshad where sprg='ACCM1000'

select * from m_sysctl where co_type='AR' and co_role='1912'

UPDATE "gas".."m_sysctl" SET "co_seq"=@P1 WHERE "co_type"=@P2 AND "co_role"=@P3 AND "co_mon" IS NULL AND "co_seq"=@P4 AND "co_name"=@P5 AND "strdt" IS NULL AND "enddt" IS NULL AND "USRID" IS NULL AND "ENTDT" IS NULL',N'@P1 float,@P2 varchar(4),@P3 varchar(8),@P4 float,@P5 varchar(10)',2,'AR  ','1912    ',1,' 

--主

select m_cust.*,m_empbas.name as devnm  from m_cust left join m_empbas on m_cust.devman=m_empbas.empid   where m_cust.stno='003'AND m_cust.CustNo LIKE '00305871%' and (m_cust.depos>0 or m_cust.duebk<0)   order by m_cust.custno

--沖帳記錄

select a.* ,b.paydsc, c.susnm as pasnm  from m_paydtl a  left join m_paydsc b on a.payid=b.payid  left join m_sysusr c on a.pasman=c.suser  where   a.stno='003' and a.custno='00305871' order by a.saldt


select * from m_paydsc


select * from m_ArH where stno='003' and arno='AR19120002'


INSERT INTO "gas".."m_ArH" ("arno","stno","ardt","custno","serno","passdt","passno","invno","invdt","Tax","total","payamt","aramt","devman","isacc","accdt","accno","ispass","remark","chkno","chkdt","creid","credt","usrid","entdt") 

VALUES ('AR19120002','003','2019-12-13 00:00:00','00305871',NULL,NULL,NULL,NULL,NULL,0,11246,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'admin','2019-12-13 15:05:35',N'admin','2019-12-13 15:05:35')


select m_arh.* ,b.cusnm ,b.accway ,b.cutel1,b.cuadd , c.name as devnm    

from m_arh  

left join m_cust b on m_arh.custno=b.custno  

left join m_empbas c on m_arh.devman=c.empid  

where    m_arh.stno='003' and arno='AR19120002'   

order by  m_arh.ardt, m_arh.arno

Created with the Personal Edition of HelpNDoc: Free Kindle producer