停車場收費(fèi)系統(tǒng)-閱讀頁
2025-07-04 20:14本頁面
【正文】 sof1asselect count(Clno) 固定車位總數(shù)from lotwhere Cltype=39。P2create procedure sof2asselect count(Clno) 自由車位總數(shù)from lotwhere Cltype=39。P3create procedure sof3asselect 3count() 空閑自由車位from lot,parkwhere = and Cltype=39。 and Carat=1P4create procedure sof4asselect count(Clno) 車位總數(shù)from lotP5create procedure sof5nom char(10)asselect *from chargewhere Carno=nomP6create procedure sof6s_Carno char(10),s_Carbrand char(10),s_Carcolor char(4)asinsert into Carvalues(s_Carno,s_Carbrand,s_Carcolor)P7create procedure sof7s_Clno char(20),s_Clspace char(20),s_Cltype char(20),s_Carno char(20),s_Carname char(20),s_Carbrand char(20),s_Carcolor char(20),s_Caradd char(20),s_Cartel char(20),s_Clbalance floatasinsert into lotvalues(s_Clno,s_Clspace,s_Cltype,s_Carno,s_Carname,s_Carbarnd,s_Carcolor,s_Caradd,s_Cartel,s_Clbalance)P8create procedure sof8s_Clno char(20),s_Carno char(20),s_Carat bit,s_Carin datetime,s_Carout datetime,s_Timetype char(20)asinsert into parkvalues(s_Clno,s_Carno,s_Carat,s_Carin,s_Carout,s_Timetype)P9create procedure sof9s_Cwno char(10),s_Carno char(10),s_Cartime float,s_Moneypay float,s_Piece char(10)asinsert into chargevalues(s_Cwno,s_Carno,s_Cartime,s_Moneypay,s_Piece)P10create procedure sof10asselect *from CarP11create procedure sof11asselect *from lotP12create procedure sof12asselect *from parkP13create procedure sof13asselect *from chargeP14create procedure sof14s_Carno char(20)asdeletefrom chargewhere Carno=s_CarnoP15create procedure sof15s_Carno char(20)asupdate lotset Clbalance=150where Carno=T1Create trigger insert_or_update_clbalanceOn lot for insert,updateAsIf exists(select* From lot Where Clbalance100)BeginPrint 39。RollbackEnd。禁止無端修改，修改不成功39。T3Create trigger tri_del_moOn charge for deleteAsIf exists(select * From deleted Where Carpay70)RollbackBeginPrint39。
黨政相關(guān)相關(guān)推薦
鄂ICP備17016276號-1