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