petshop4.0 详解之七(PetShop表示层设计)(3)

petshop4.0 详解之七(PetShop表示层设计)(3)

2007-09-12 16:22

代码中，aspnet_Membership_CreateUser为aspnet_regsql工具为membership创建的存储过程，它的功能就是创建一个用户。 OracleMembershipProvider类中对CreateUser()方法的定义如下： public override MembershipUser CreateUser( string username, string password, string email, string passwordQuestion, string passwordAnswer, bool isApproved, object userId, out MembershipCreateStatus status) {     //前面的代码略; //Create connection OracleConnection connection = new OracleConnection(OracleHelper.ConnectionStringMembership); connection.Open(); OracleTransaction transaction = connection.BeginTransaction(IsolationLevel.ReadCommitted); try {    DateTime dt = DateTime.Now;   bool isUserNew = true;   // Step 1: Check if the user exists in the Users table: create if not       int uid = GetUserID(transaction, applicationId, username, true, false, dt, out isUserNew);   if(uid == 0) { // User not created successfully!     status = MembershipCreateStatus.ProviderError;    return null;    }   // Step 2: Check if the user exists in the Membership table: Error if yes.   if(IsUserInMembership(transaction, uid)) {     status = MembershipCreateStatus.DuplicateUserName;    return null;    }   // Step 3: Check if Email is duplicate   if(IsEmailInMembership(transaction, email, applicationId)) {     status = MembershipCreateStatus.DuplicateEmail;    return null;    }   // Step 4: Create user in Membership table        int pFormat = (int)passwordFormat;   if(!InsertUser(transaction, uid, email, pass, pFormat, salt, "", "", isApproved, dt)) {     status = MembershipCreateStatus.ProviderError;    return null;    }   // Step 5: Update activity date if user is not new   if(!isUserNew) {    if(!UpdateLastActivityDate(transaction, uid, dt)) {      status = MembershipCreateStatus.ProviderError;     return null;     }    }    status = MembershipCreateStatus.Success;   return new MembershipUser(this.Name, username, uid, email, passwordQuestion, null, isApproved, false, dt, dt, dt, dt, DateTime.MinValue); } catch(Exception) {   if(status == MembershipCreateStatus.Success)     status = MembershipCreateStatus.ProviderError;   throw; } finally {   if(status == MembershipCreateStatus.Success)     transaction.Commit();   else     transaction.Rollback();    connection.Close();    connection.Dispose(); } }