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);
