淺談小區(qū)物業(yè)管理數(shù)據(jù)庫(kù)設(shè)計(jì)-wenkub
2023-04-27 22:43:56 本頁(yè)面
【正文】 Where RepNum=inNo附錄2. 5—8Create Proc Pr_ChargeManagement_QueryinNo varchar(20)ASSelect *From ChargeManagementWhere Cno1=inNo附錄2. 5—9Create Proc Pr_Charge_QueryinNo varchar(20)ASSelect *From ChargeWhere Cno2=inNo附錄2. 5—10Create Proc Pr_RoomOwner_InsertRO_RNo char(20),RO_OwnerName char(20),RO_OwnerSex char(2),RO_OwnerPhone char(20),RO_CheckInTime char(20)AsInsert Into RoomOwnerValues(RO_RNo,RO_OwnerName,RO_OwnerSex,RO_OwnerPhone,RO_CheckInTime)附錄2. 5—11Create Proc Pr_RoomOwner_DeleteOutNo varchar(20)AsDeleteFrom RoomOwnerWhere RNo=OutNo附錄2. 5—12Create Proc Pr_Administrator_UpdateA_ANo char(20),A_AdminName char(20),A_AdminSex char(2),A_ManageItem char(20),A_AdminPhone char (20)ASUpdate Administratorset AdminName=A_AdminName, AdminSex=A_AdminSex, ManageItem=A_ManageItem, AdminPhone=A_AdminPhonewhere AdminNo=A_ANo附錄2. 5—13Create Proc Pr_Equipment_UpdateE_No char(20),E_EquName char(20),E_EquNo char(20),E_ELendTime date,E_ERetTime date,E_AdminNo char(20),E_Rno char(20)AsUpdate Equipmentset EquNo=E_EquNo, EquName=E_EquName, ELendTime=E_ELendTime, ERetTime=E_ERetTime, AdminNo=E_AdminNo, Rno=E_Rnowhere EquNo=E_No附錄2. 5—14Create Proc Pr_ParkManagement_UpdateP_No char(20),P_ParkNo char(20),P_RNo char(20),P_PStartTime date,P_PEndTime date,P_AdminNo char(20),P_PCharge intAsUpdate ParkManagementset ParkNo=P_ParkNo, RNo=P_RNo, PStartTime=P_PStartTime, PEndTime=P_PEndTime, AdminNo=P_AdminNo, PCharge=P_PChargewhere ParkNo=P_No附錄2. 5—15Create Proc Pr_RepairManagement_UpdateRM_No char(20),RM_RepNum char(20),RM_RTimes int,RM_RNo char(20),RM_OwerName char(20),RM_AdminNO char(20),RM_RTime date,RM_Rcost intAsUpdate RepairManagementset RepNum=RM_RepNum, RTimes=RM_RTimes, RNo=RM_RNo, OwnerName=RM_OwerName, AdminNo=RM_AdminNO, RTime=RM_RTime, Rcost=RM_Rcostwhere RepNum=RM_No附錄2. 5—16Create Proc Pr_ChargeManagement_UpdateCMU_No char(20),CMU_Cno1 char(20),CMU_Cname char(20),CMU_CStartTime date,CMU_CEndTime date,CMU_Cused int,CMU_CPrice int,CMU_AdminNo char(20),CMU_Rno char(20)AsUpdate ChargeManagementset Cno1=CMU_Cno1, Cname=CMU_Cname, CStartTime=CMU_CStartTime, CEndTime=CMU_CEndTime, Cused=CMU_Cused, CPrice=CMU_CPrice, AdminNo=CMU_AdminNo, Rno=CMU_Rno where Cno1=CMU_No附錄2. 5—17Create Proc Pr_Charge_UpdateCU_No char(20),CU_Cno2 char(20),CU_Cname char(20),CU_CCharge int,CU_CTime date,CU_CStatus char(2),CU_Rno char(20)AsUpdate Chargeset Cno2=CU_Cno2, Cname=CU_Cname, CCharge=CU_CCharge, CTime=CU_CTime, CStatus=CU_CStatus, Rno=CU_Rnowhere Cno2=CU_No附錄3 SQL Server2008的測(cè)試附錄3. 1—1管理員信息查詢SQL語(yǔ)句：Exec Pr_Administrator_Query 39。否39。附錄2. 1—6Create table ChargeManagement( Cno1 char(20) Primary key not null, Cname char(20) not null, CStartTime date, CEndTime date, Cused int not null, CPrice int not null, AdminNo char(20) not null, Rno char(20) not null, Foreig
公司管理相關(guān)推薦
鄂ICP備17016276號(hào)-1