62,046
社区成员
发帖
与我相关
我的任务
分享
CREATE PROCEDURE Up_Add_Users
(@User_Name varchar(20),@User_Pwd varchar(50),@User_Ask varchar(100),@User_Answer varchar(100),@User_Email varchar(200),
@UserBase_Sex varchar(10),@UserBase_Birthday datetime,@UserBase_Seat varchar(200),@UserBase_Oicq varchar(15),@UserBase_Msn varchar(200),
@UserBase_Pic varchar(200),@UserBase_Ink varchar(1000),@User_Id int out)
AS
INSERT INTO [Users](User_Name,User_Pwd,User_Ask,User_Answer,User_Email,User_Online)
VALUES(@User_Name,@User_Pwd,@User_Ask,@User_Answer,@User_Email,1)
SELECT @User_Id = Max ([User_id]) FROM Users
INSERT INTO UserBase (UserBase_UserId)VALUES(@User_Id)
INSERT INTO UserState (UserState_UserId)VALUES(@User_Id)
EXEC Up_Change_UserBase @User_Id,@UserBase_Sex,@UserBase_Birthday,@UserBase_Seat,@UserBase_Oicq,@UserBase_Msn,@UserBase_Pic,@UserBase_Ink
/* --------------------论坛信息表 ----------------------*/
UPDATE Bbs_SiteInfo SET SiteInfo_UserCount = SiteInfo_UserCount +1 ,SiteInfo_NewUserId =@User_Id,SiteInfo_NewUserName=@User_Name WHERE SiteInfo_Id = 1
GO
SqlCommand cmdForum = new SqlCommand("Up_Add_Users", connForum);
cmdForum.CommandType = CommandType.StoredProcedure;
cmdForum.Parameters.Add("@User_Name", userName);
cmdForum.Parameters.Add("@User_Pwd", MD5(pwd));
cmdForum.Parameters.Add("@User_Ask", "0");
cmdForum.Parameters.Add("@User_Answer", "我的生意网");
cmdForum.Parameters.Add("@User_Email", mail);
cmdForum.Parameters.Add("@UserBase_Sex", "boy");
cmdForum.Parameters.Add("@UserBase_Birthday", DateTime.Now.ToString());
cmdForum.Parameters.Add("@UserBase_Seat", "中国");
cmdForum.Parameters.Add("@UserBase_Oicq", "312112153");
cmdForum.Parameters.Add("@UserBase_Msn", "msn@hotmail.com");
cmdForum.Parameters.Add("@UserBase_Pic", "images/user.gif");
cmdForum.Parameters.Add("@UserBase_Ink", "我的个性签名");
//cmdForum.Parameters.Add("@User_Id",)
connForum.Open();
cmdForum.ExecuteNonQuery();
cmdForum.Parameters.Add("@User_Id", SqlDbType.Int);
cmdForum.Parameters["@User_Id"].Direction = ParameterDirection.Output;
cmdForum.Parameters.Add(new SqlParameter("@User_Id", SqlDbType.Int));
cmdForum.Parameters["@User_Id"].Direction = ParameterDirection.Output;
cmdForum.Parameters.Add(new SqlParameter("@User_Id", SqlDbType.Int)).Value=...;
cmdForum.Parameters["@User_Id"].Direction = ParameterDirection.Output;