示例#1
0
        /// <summary>
        /// 重置访问情况
        /// </summary>
        /// <param name="id">主键</param>
        /// <returns>影响行数</returns>
        private int ResetVisitInfo(string id)
        {
            SQLBuilder sqlBuilder = new SQLBuilder(DBProvider);

            sqlBuilder.BeginUpdate(this.CurrentTableName);
            sqlBuilder.SetNull(PiUserLogOnTable.FieldFirstVisit);
            sqlBuilder.SetNull(PiUserLogOnTable.FieldPreviousVisit);
            sqlBuilder.SetNull(PiUserLogOnTable.FieldLastVisit);
            sqlBuilder.SetValue(PiUserLogOnTable.FieldLogOnCount, 0);
            sqlBuilder.SetWhere(PiUserLogOnTable.FieldId, id);
            return(sqlBuilder.EndUpdate());
        }
示例#2
0
        /// <summary>
        /// 重置访问情况
        /// </summary>
        /// <returns>影响行数</returns>
        public int ResetVisitInfo()
        {
            int        returnValue = 0;
            SQLBuilder sqlBuilder  = new SQLBuilder(DBProvider);

            sqlBuilder.BeginUpdate(this.CurrentTableName);
            sqlBuilder.SetNull(PiUserLogOnTable.FieldFirstVisit);
            sqlBuilder.SetNull(PiUserLogOnTable.FieldPreviousVisit);
            sqlBuilder.SetNull(PiUserLogOnTable.FieldLastVisit);
            sqlBuilder.SetValue(PiUserLogOnTable.FieldLogOnCount, 0);
            returnValue = sqlBuilder.EndUpdate();
            return(returnValue);
        }