--
create proc CM_AddPhotoBook
@Pho_ClaName varchar(50),
@Pho_Popedom int,
@Pho_Explain varchar(150),
@Pho_men int
as
insert into CM_PhotoBook(Pho_ClaName,Pho_Popedom,Pho_Face,Pho_Explain,Pho_men)
values(@Pho_ClaName,@Pho_Popedom,'',@Pho_Explain,@Pho_men)

--
CREATE PROCEDURE CM_PhotoBook_Update
@Pho_ClaId int,
@Pho_ClaName varchar(50),
@Pho_Popedom int,
@Pho_Explain varchar(150),
@Pho_pwd varchar(50),
@Pho_type int
 AS 
	UPDATE CM_PhotoBook SET 
	[Pho_ClaName] = @Pho_ClaName,[Pho_Popedom] = @Pho_Popedom,
	[Pho_Explain] = @Pho_Explain,[Pho_pwd] = @Pho_pwd,[Pho_type] = @Pho_type
	WHERE [Pho_ClaId] = @Pho_ClaId

GO

--Ϊ
create proc CM_photoCover
@pho_claid int,
@photo_addr varchar(200)
as
update cm_photoBook
set Pho_Face=@photo_addr
where Pho_ClaId=@pho_claid