public override int SaveBindOrUnbindSmsCode(int userID, MobilePhoneAction action, long mobilePhone, string smsCode, long changedMobilePhone, string changedSmsCode) { using (SqlQuery query = new SqlQuery()) { query.CommandText = "bx_SaveBindOrUnbindSmsCode"; query.CommandType = CommandType.StoredProcedure; query.CreateParameter <int>("@UserID", userID, SqlDbType.Int); query.CreateParameter <byte>("@Action", (byte)action, SqlDbType.TinyInt); query.CreateParameter <long>("@MobilePhone", mobilePhone, SqlDbType.BigInt); query.CreateParameter <long>("@ChangedMobilePhone", changedMobilePhone, SqlDbType.BigInt); query.CreateParameter <string>("@SmsCode", smsCode, SqlDbType.VarChar, 10); query.CreateParameter <string>("@ChangedSmsCode", changedSmsCode, SqlDbType.VarChar, 10); SqlParameter returnParam = query.CreateParameter <int>("@Result", SqlDbType.Int, ParameterDirection.ReturnValue); query.ExecuteNonQuery(); return((int)returnParam.Value); } }
public override void SetPhoneBySmsCode(int userID, long mobilePhone, string smsCode, MobilePhoneAction action, out bool success) { using (SqlQuery query = new SqlQuery()) { query.CommandText = "bx_SetPhoneBySmsCode"; query.CommandType = CommandType.StoredProcedure; query.CreateParameter <int>("@UserID", userID, SqlDbType.Int); query.CreateParameter <byte>("@Action", (byte)action, SqlDbType.TinyInt); query.CreateParameter <long>("@MobilePhone", mobilePhone, SqlDbType.BigInt); query.CreateParameter <string>("@SmsCode", smsCode, SqlDbType.VarChar, 10); SqlParameter returnParam = query.CreateParameter <bool>("@Success", SqlDbType.Bit, ParameterDirection.ReturnValue); query.ExecuteNonQuery(); success = ((int)returnParam.Value) == 1; } }
public override void SetPhoneBySmsCode(int userID, long mobilePhone, string smsCode, MobilePhoneAction action, out bool success) { using (SqlQuery query = new SqlQuery()) { query.CommandText = "bx_SetPhoneBySmsCode"; query.CommandType = CommandType.StoredProcedure; query.CreateParameter<int>("@UserID", userID, SqlDbType.Int); query.CreateParameter<byte>("@Action", (byte)action, SqlDbType.TinyInt); query.CreateParameter<long>("@MobilePhone", mobilePhone, SqlDbType.BigInt); query.CreateParameter<string>("@SmsCode", smsCode, SqlDbType.VarChar, 10); SqlParameter returnParam = query.CreateParameter<bool>("@Success", SqlDbType.Bit, ParameterDirection.ReturnValue); query.ExecuteNonQuery(); success = ((int)returnParam.Value) == 1; } }
public override int SaveBindOrUnbindSmsCode(int userID, MobilePhoneAction action, long mobilePhone, string smsCode, long changedMobilePhone, string changedSmsCode) { using (SqlQuery query = new SqlQuery()) { query.CommandText = "bx_SaveBindOrUnbindSmsCode"; query.CommandType = CommandType.StoredProcedure; query.CreateParameter<int>("@UserID", userID, SqlDbType.Int); query.CreateParameter<byte>("@Action", (byte)action, SqlDbType.TinyInt); query.CreateParameter<long>("@MobilePhone", mobilePhone, SqlDbType.BigInt); query.CreateParameter<long>("@ChangedMobilePhone", changedMobilePhone, SqlDbType.BigInt); query.CreateParameter<string>("@SmsCode", smsCode, SqlDbType.VarChar, 10); query.CreateParameter<string>("@ChangedSmsCode", changedSmsCode, SqlDbType.VarChar, 10); SqlParameter returnParam = query.CreateParameter<int>("@Result", SqlDbType.Int, ParameterDirection.ReturnValue); query.ExecuteNonQuery(); return (int)returnParam.Value; } }
public abstract void SetPhoneBySmsCode(int userID, long mobilePhone, string smsCode, MobilePhoneAction action, out bool success);
public abstract int SaveBindOrUnbindSmsCode(int userID, MobilePhoneAction action, long newMobilePhone, string newSmsCode, long oldMobilePhone, string oldSmsCode);