/// <summary>
/// 重置访问情况
/// </summary>
/// <param name="id">主键</param>
/// <returns>影响行数</returns>
private int ResetVisitInfo(string id)
{
SQLBuilder sqlBuilder = new SQLBuilder(this.DbHelper);
sqlBuilder.BeginUpdate(this.CurrentTableName);
sqlBuilder.SetNull(BaseUserLogOnEntity.FieldFirstVisit);
sqlBuilder.SetNull(BaseUserLogOnEntity.FieldPreviousVisit);
sqlBuilder.SetNull(BaseUserLogOnEntity.FieldLastVisit);
sqlBuilder.SetValue(BaseUserLogOnEntity.FieldLogOnCount, 0);
sqlBuilder.SetWhere(BaseUserLogOnEntity.FieldId, id);
return(sqlBuilder.EndUpdate());
}
/// <summary>
/// 重置访问情况
/// </summary>
/// <returns>影响行数</returns>
public int ResetVisitInfo()
{
int result = 0;
SQLBuilder sqlBuilder = new SQLBuilder(this.DbHelper);
sqlBuilder.BeginUpdate(this.CurrentTableName);
sqlBuilder.SetNull(BaseUserLogOnEntity.FieldFirstVisit);
sqlBuilder.SetNull(BaseUserLogOnEntity.FieldPreviousVisit);
sqlBuilder.SetNull(BaseUserLogOnEntity.FieldLastVisit);
sqlBuilder.SetValue(BaseUserLogOnEntity.FieldLogOnCount, 0);
result = sqlBuilder.EndUpdate();
return(result);
}
/// <summary>
/// 解除手机认证帮定
/// </summary>
/// <param name="userInfo">用户</param>
/// <returns>影响行数</returns>
public int RemoveMobileBinding(string mobile)
{
int result = 0;
SQLBuilder sqlBuilder = new SQLBuilder(this.DbHelper);
sqlBuilder.BeginUpdate(this.CurrentTableName);
sqlBuilder.SetNull(BaseUserContactEntity.FieldMobile);
sqlBuilder.SetWhere(BaseUserContactEntity.FieldMobile, mobile);
result = sqlBuilder.EndUpdate();
/*
* // 把主库的数据库认证也去掉
* string connectionString = ConfigurationHelper.AppSettings("K8Connection", BaseSystemInfo.EncryptDbConnection);
* if (!string.IsNullOrEmpty(connectionString))
* {
* IDbHelper dbHelper = DbHelperFactory.GetHelper(CurrentDbType.Oracle, connectionString);
* string commandText = string.Format(@"UPDATE TAB_USER
* SET Mobile = null
* WHERE Id = {0} "
* , dbHelper.GetParameter("Mobile"));
* dbHelper.ExecuteNonQuery(commandText, new IDbDataParameter[] {
* dbHelper.MakeParameter("Mobile", mobile)
* });
* }
*/
return(result);
}
