62,074
社区成员
发帖
与我相关
我的任务
分享
string uln = CUserInfo.GetUserLoginName();
if (!"".Equals(uln) && uln != null)
{
if(ReturnID=0)
{("<script>alert('系统繁忙,请稍后.');</script>"}
else{
CDbInfo.ExecuteSp(vCnn, "sp_personal_userinfoUpdate09", objParameter);
Response.Write("<script>alert('个人信息修改成功.');window.location='userinfo.aspx';</script>");
}}
else
{
Response.Write("<script>alert('登录超时,请重新登录!');window.location='login.aspx';</script>");
}
IF OBJECT_ID (N'sp_personal_userinfoUpdate09', N'P' ) IS not null
DROP PROCEDURE sp_personal_userinfoUpdate09;
GO
CREATE PROCEDURE sp_personal_userinfoUpdate09
(
@iUserRegId int
,@sUserTrueName varchar(50)
,@sNickName varchar(50)
,@sUserEmail varchar(50)
,@sMobile varchar(50)
,@sTel varchar(50)
,@sQq varchar(50)
,@sMsn varchar(50)
,@sBirthday varchar(50)
,@sRegion varchar(50)
,@sCity varchar(50)
,@sSelfIntro varchar(2000)
,@sWorkYn varchar(10)
,@sOpenInfoYn varchar(10)
,@sPhoto varchar(10)
,@iSex int
,@sSpecialty varchar(50)
,@sUserLoginName varchar(50)
)
WITH ENCRYPTION
AS
BEGIN
begin tran addandup
update tb_userRegInfo set fd_User_Name=@sUserTrueName,fd_nickName=@sNickName,fd_Email=@sUserEmail
,fd_mobile=@sMobile,fd_tel=@sTel,fd_qq=@sQq,fd_msn=@sMsn,fd_birthday=@sBirthday
,fd_region=@sRegion,fd_city=@sCity,fd_selfIntro=@sSelfIntro
,fd_workYn=@sWorkYn,fd_openInfoYn=@sOpenInfoYn,fd_photoFileName=@sPhoto
,fd_sex=@iSex,fd_Specialty=@sSpecialty
where fd_userRegId=@iUserRegId;
--同时修改学生表中的信息
update tb_Users set fd_User_Name=@sUserTrueName,fd_nickName=@sNickName,fd_Email=@sUserEmail
,fd_mobile=@sMobile,fd_tel=@sTel,fd_qq=@sQq,fd_msn=@sMsn,fd_birthday=@sBirthday
,fd_region=@sRegion,fd_city=@sCity,fd_selfIntro=@sSelfIntro
,fd_workYn=@sWorkYn,fd_openInfoYn=@sOpenInfoYn,fd_photoFileName=@sPhoto
,fd_sex=@iSex,fd_Specialty=@sSpecialty
where fd_Login_Name=@sUserLoginName
commit tran addandup
IF @@ERROR <> 0 or @@rowcount > 1
begin
rollback tran addandup
end
END
居然更新不了信息 返回行不等于1?