淺談小區(qū)物業(yè)管理數(shù)據(jù)庫(kù)設(shè)計(jì)-資料下載頁(yè)
2025-04-12 22:43本頁(yè)面
【正文】 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_Update@E_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_Update@P_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_Update@RM_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_Update@CMU_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_Update@CU_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管理員信息查詢(xún)SQL語(yǔ)句：Exec Pr_Administrator_Query 39。A0139。附錄3. 1—2住戶(hù)信息查詢(xún)SQL語(yǔ)句：Exec Pr_RoomOwner_Query 39。R0139。附錄3. 1—3設(shè)備信息查詢(xún)SQL語(yǔ)句：Exec Pr_Equipment_Query 39。Eq0139。附錄3. 1—4停車(chē)信息查詢(xún)SQL語(yǔ)句：Exec Pr_Park_Query 39。Pa0139。附錄3. 1—5停車(chē)信息查詢(xún)SQL語(yǔ)句：Exec Pr_RepairManagement_Query 39。Rep0139。附錄3. 1—6收費(fèi)信息查詢(xún)SQL語(yǔ)句：Exec Pr_ChargeManagement_Query 39。C10139。附錄3. 2—1管理員信息更新SQL語(yǔ)句：Exec Pr_Administrator_Update 39。A0139。,39。zhangsan39。,39。男39。,39。設(shè)備39。,39。1519144207739。更新前表中數(shù)據(jù)：更新后表中數(shù)據(jù)：附錄3. 2—2設(shè)備信息更新SQL語(yǔ)句：Exec Pr_Equipment_Update39。Eq0139。,39。fadianji39。,39。Eq0139。,39。1992081339。,39。1992081839。,39。A0439。,39。R1639。更新前表中數(shù)據(jù)：更新后表中數(shù)據(jù)：附錄3. 2—3維修信息更新SQL語(yǔ)句：Exec Pr_RepairManagement_Update39。Rep0139。,39。Rep39。,39。239。,39。R0239。,39。包洪星39。,39。A0439。,39。1992080939。,39。4839。更新前表中數(shù)據(jù)：更新后表中數(shù)據(jù)：附錄3. 2—4收費(fèi)信息更新SQL語(yǔ)句：Exec Pr_Charge_Update39。C20139。,39。C239。,39。電費(fèi)39。,39。4939。,39。1992082039。,39。是39。,39。R0139。更新前表中數(shù)據(jù)：更新后表中數(shù)據(jù)：
公司管理相關(guān)推薦
鄂ICP備17016276號(hào)-1