コード例 #1
0
        public void ServerVariables(string entId, string userId, HttpRequest request)
        {
            //发出请求的远程主机的IP地址
            var addr = request.ServerVariables["Remote_Addr"].ToString();
            //发出请求的远程主机名称
            var host = "";
            //发出请求的远程主机端口
            var port = request.ServerVariables["SERVER_PORT"].ToString();

            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into ServerVariables(UserID,EntID,Host,Addr,Port,RecordDate)values(@userId,@entId,@host,@addr,@port,@date)");
            SqlParameter[] sqls = new SqlParameter[] {
                new SqlParameter("@userId", userId),
                new SqlParameter("@entId", entId),
                new SqlParameter("@host", host),
                new SqlParameter("@addr", addr),
                new SqlParameter("@port", port),
                new SqlParameter("@date", DateTime.Now)
            };
            SqlRun sql = new SqlRun(SqlRun.sqlstr);

            sql.RunSqlNumber(strSql.ToString(), sqls);
        }