һ򿪡ҩƷϵͳ-ϱͻ(SQL)

ڵϵͳáȻķ

   1.ڡݿáڣдҩϵͳݿӦ
   2.ڡáУڡֵУдݣ

select M.YPMC as DrugName,M.SCPH as BatchNumber,M.JXMC as MedicamentModel,M.YPGG as Spec,M.SCCJ as Manufacturer,Z.RQ as PurchasingDate,M.SCRQ as ProductionDate,M.YXQZ as ExpiryDate,M.SL as Quantity,M.JLDW as Measurement,'ϸ' as CheckConclusion,Z.DWMC as Supplier,Y.PZWH as ApprovalNumber
from RKD_ZB Z,RKD_MX M,BM_YP Y 
where Z.ID=M.ID and M.YPBM=Y.BM and Z.SH='T' and Z.RQ between ($UpDate) and ($UpDate);


   3.ڡáУڡֵУдݣ
select M.YPMC as DrugName,M.SCPH as BatchNumber,M.JXMC as MedicamentModel,M.YPGG as Spec,Y.PZWH as ApprovalNumber,M.SCCJ as Manufacturer,M.JLDW as Measurement,Z.RQ as SaleDate,M.SL as Quantity from XSD_ZB Z,XSD_MX M,BM_YP Y 
where Z.ID=M.ID and M.YPBM=Y.BM and Z.SH='T' and Z.RQ between ($UpDate) and ($UpDate);


   4.ڡáУڡֵУдݣ

select Y.MC as DrugName,K.SCPH as BatchNumber,K.YPBM as BrevityCode,L.MC as Category,K.KCSL as Quantity,Y.JLDW as Measurement,Y.JXMC as MedicamentModel,Y.GG as Spec,Y.PZWH as ApprovalNumber,Y.SCCJ as Manufacturer,' ' as RegistrationNumber from KC_KCDTB K,BM_YP Y
,BM_YPLB L where K.YPBM=Y.BM and Y.LB=L.BM and K.KCSL>0

򡰰ҩṩĽӿҪݿSQLSever,ʹAccessݿľͻؽݿתSQLServerݿ⡣ݿתκμ⣬ֱ뾫Ϲ˾ϵ

ġ򡰰ҩṩĽӿҪ.net framework 2.0֧֣ûʹýӿǰذװ.net framework 2.0ڰװκμ⣬ֱ뾫Ϲ˾ϵ



    
 
 
