示例#1
0
        /// <summary>
        /// 添加UserAccessLogInfo
        /// </summary>
        /// <param name="useraccesslog"></param>
        /// <returns></returns>
        public async static Task <long> AddUserAccessLogAsync(UserAccessLogInfo useraccesslog)
        {
            string sql = @"INSERT INTO [UserAccessLog]
			([Url],[Referer],[UserAgent],[UserId],[Ip],[Other],[Type])
			VALUES
			(@Url,@Referer,@UserAgent,@UserId,@Ip,@Other,@Type) 
			SELECT SCOPE_IDENTITY()
			"            ;
            var    par = new DynamicParameters();

            par.Add("@Url", useraccesslog.Url, DbType.AnsiString);
            par.Add("@Referer", useraccesslog.Referer, DbType.AnsiString);
            par.Add("@UserAgent", useraccesslog.UserAgent, DbType.AnsiString);
            par.Add("@UserId", useraccesslog.UserId, DbType.Int32);
            par.Add("@Ip", useraccesslog.Ip, DbType.AnsiString);
            par.Add("@Other", useraccesslog.Other, DbType.String);
            par.Add("@Type", useraccesslog.Type, DbType.Int16);
            return(await DapWrapper.InnerQueryScalarSqlAsync <int>(DbConfig.ArticleManagerConnString, sql, par));
        }